Distribution Code Detail
The Distribution Code Detail file contains distribution code detail records. A distribution code detail record represents default information for one line of expense distribution. Each distribution code detail record is related to one record in the Distribution Code Header file. More than one detail record can be associated with the same header record. Distribution codes are used to automatically create expense distributions or expense distribution "shells" for invoices or to split invoice distributions into multiple distribution lines.
REFERENCED BY
AP05.3 | AP305 | PO150 | PO25.6 | PO25.7 | PO26.2 |
PO26.4 | PO26.5 | PO28.2 | PO36.2 | PO536 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DTC-COMPANY Element: Company | Numeric 4 The company number. Must be a valid company in the Accounts Payable Company file. |
|
||||||||||||||||||
DTC-DIST-CODE Element: Dist Code | Alpha 9 A user-defined code used to automatically create expense distributions or expense distribution "shells" for invoices or to split an invoice distribution into multiple distributions. Must be a valid record in the Distribution Code Header file. |
|
||||||||||||||||||
DTC-SEQ-NBR Element: Seq Nbr | Numeric 4 A system-assigned sequence number used to identify the distribution code detail record. |
|
||||||||||||||||||
DTC-DIST-COMPANY Element: Posting Company | Numeric 4 The company the expense distribution should be posted to. Must be a valid record in the General Ledger Company file and a valid relationship must exist in the Intercompany Relationship file. If left blank, the company defaults. |
|
||||||||||||||||||
DTC-DIS-ACCT-UNIT Distribution Accounting Unit | Alpha 15 The general ledger distribution accounting unit used for posting the expense distribution. Must be a valid accounting unit in the Lawson General Ledger system. |
|
||||||||||||||||||
DTC-DIS-ACCOUNT Distribution Account Number | Numeric 6 The general ledger distribution account number used for posting the expense distribution. Must be a valid account number in the Lawson General Ledger system. |
|
||||||||||||||||||
DTC-DIS-SUB-ACCT Distribution Subaccount Number | Numeric 4 The general ledger distribution subaccount number used for posting the expense distribution. Must be a valid subaccount in General Ledger. |
|
||||||||||||||||||
DTC-TRAN-DIST-AMT Element: Intl Amt | Signed 18.2 The transaction amount for the distribution. If entered, the Allocation Percentage and Unit Amount fields must be blank. |
|
||||||||||||||||||
DTC-DIST-RATE Element: Dist Rate | Signed 6.3 The percent of the invoice amount that should be allocated to the distribution. If entered, the Distribution Amount and Unit Amount fields must be blank. |
|
||||||||||||||||||
DTC-ASSET-DESC Element: Asset Description | Alpha 30 (Lower Case) A description of the asset assigned to the distribution, if assigned. |
|
||||||||||||||||||
DTC-TAG-NBR Element: Tag | Alpha 12 The tag number associated with the distribution. Represents a short name for a part of an asset. |
|
||||||||||||||||||
DTC-ITEM-NBR Element: Item | Alpha 32 The item number assigned to the distribution. Represents one element of an asset that is made up of multiple elements, but is depreciated as a common asset unit. If assigned, an Asset Template must also be assigned to the distribution. |
|
||||||||||||||||||
DTC-ITEM-DESC Element: Item Desc | Alpha 30 The item description. |
|
||||||||||||||||||
DTC-ITEM-QUANTITY Element: Item Quantity | Numeric 8 The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item. |
|
||||||||||||||||||
DTC-ASSET-TEMPLATE Element: Asset Template | Alpha 10 The asset template assigned to the distribution. Represents asset information used to create a record in the Lawson Asset Management system. If assigned, the Asset number field must be blank. |
|
||||||||||||||||||
DTC-MODEL-NUMBER Element: Model | Alpha 30 The model number assigned to the distribution. Used in conjunction with the Asset Template field. If assigned, an asset template must also be assigned to the distribution. |
|
||||||||||||||||||
DTC-SERIAL-NUMBER Element: Serial | Alpha 30 The serial number assigned to the distribution. Represents the serial number of an asset. Used in conjunction with the Asset Template field. If assigned, an asset template must also be assigned to the distribution. |
|
||||||||||||||||||
DTC-HOLD-AM Element: Hold Asset | Alpha 1 This field indicates whether to hold the asset in the Asset Interface file. Being held keeps items from becoming assets until they are released from hold. Valid values are: N = No. Default. Y = Yes. |
|
||||||||||||||||||
DTC-ASSET Element: Asset | Numeric 10 The asset number assigned to the distribution. Represents an asset belonging to the company. If assigned, the Asset Template, Model, Serial, Tag, and Item fields must be blank. |
|
||||||||||||||||||
DTC-ACTIVITY Element: Activity | Alpha 15 The activity assigned to the distribution. Used to group expense distribution amounts to track costs for projects, jobs, construction, and so on, without having to define additional general ledger account numbers. Must be a valid activity in the Lawson Activity Management system. |
|
||||||||||||||||||
DTC-DST-REFERENCE Element: Cross Ref | Alpha 10 The reference value assigned to the distribution. If left blank, the default reference value defined for the company defaults. |
|
||||||||||||||||||
DTC-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The distribution description. If left blank, the vendor number and name defaults on the distribution during invoice entry. |
|
||||||||||||||||||
DTC-ACCT-CATEGORY Element: Category | Alpha 5 The account categories assigned to the distribution. Used with the Activity field. |
|
||||||||||||||||||
DTC-BILL-CATEGORY Element: Bill Category | Alpha 32 |
|
||||||||||||||||||
DTC-UNT-AMOUNT Element: Unit Amount | Signed 18.2 The total units for the distribution. If entered, the Distribution Amount and Allocation Percentage fields must be blank. |
|
||||||||||||||||||
DTC-COMBINE Element: Combine Asset | Alpha 10 This field indicates whether to combine items as one asset. |
|
||||||||||||||||||
DTC-ASSET-GROUP Element: Asset Group | Alpha 10 The asset group assigned to the distribution. |
|
||||||||||||||||||
DTC-ACCT-UNIT Element: Acct Unit | Alpha 15 The accounting unit assigned to the distribution, if assigned. Must be a valid record in the Lawson General Ledger system. |
|
||||||||||||||||||
DTC-LOCATION-NAME Element: Location Name | Alpha 15 A user-defined location name which represents where an asset is physically located. Locations are used to report asset information. |
|
||||||||||||||||||
DTC-DIVISION Element: Division | Alpha 15 A user-defined division which is used for reporting assets. |
|
||||||||||||||||||
DTC-AU-GROUP Element: Au Group | Alpha 10 Accounting unit groups group and identify the accounting units to use when you create journal entries for adding, adjusting, transferring, or disposing of assets. Changes to accounting unit groups are dynamic, affecting all assets using the accounting unit group. Accounting unit group names are user-definable, and accounting unit groups are set up by company. |
|
||||||||||||||||||
DTC-BAR-CODE Element: Bar Code | Alpha 30 |
|
||||||||||||||||||
DTC-ITEM-LOC-DTL Element: Item Loc Dtl | Alpha 14 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||
---|---|---|---|---|---|---|---|---|---|
DTCSET1 |
COMPANY DIST-CODE SEQ-NBR |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apcompany | APCOMPANY |
Required
| ||||||||||||||||||||||||
Apdisthdr | APDISTHDR |
Required
| ||||||||||||||||||||||||
Glmaster | GLMASTER |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.