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

PO980

UPDATED BY

AP00.4	AP00.5	AP05.3	AP20.1	AP20.2	AP20.3
AP20.4	AP20.5	AP20.7	AP205	AP21.1	AP23.1
AP305	AP520	DR100	IC141	IC142	IC83.1
MA41.1	MA41.2	MA41.4	MA41.7	MA42.2	MA43.2
MA43.7	MA44.1	MA44.2	PD22.1	PD570	PO150
PO21.3	PO25.6	PO25.7	PO26.2	PO26.4	PO26.5
PO28.2	PO32.1	PO36.2	PO520	PO536	RQ10.1
RQ10.2	RQ10.3	RQ10.4	RQ11.1	RQ35.1	RQ500
RQID.1	RQIF.1	RQIJ.1

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.	AP05.3
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.	AP05.3
DTC-SEQ-NBR Element: Seq Nbr	Numeric 4 A system-assigned sequence number used to identify the distribution code detail record.	AP05.3
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.	AP05.3
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.	AP05.3
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.	AP05.3
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.	AP05.3
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.	AP05.3
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.	AP05.3
DTC-ASSET-DESC Element: Asset Description	Alpha 30 (Lower Case) A description of the asset assigned to the distribution, if assigned.	AP05.3
DTC-TAG-NBR Element: Tag	Alpha 12 The tag number associated with the distribution. Represents a short name for a part of an asset.	AP05.3
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.	AP05.3
DTC-ITEM-DESC Element: Item Desc	Alpha 30 The item description.	AP05.3
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.	AP05.3
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.	AP05.3
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.	AP05.3
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.	AP05.3
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.	AP05.3
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.	AP05.3
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.	AP05.3 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA44.1 MA44.2
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.	AP05.3
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.	AP05.3
DTC-ACCT-CATEGORY Element: Category	Alpha 5 The account categories assigned to the distribution. Used with the Activity field.	AP05.3 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA44.1 MA44.2
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.	AP05.3
DTC-COMBINE Element: Combine Asset	Alpha 10 This field indicates whether to combine items as one asset.	AP05.3
DTC-ASSET-GROUP Element: Asset Group	Alpha 10 The asset group assigned to the distribution.	AP05.3
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.	AP05.3
DTC-DIVISION Element: Division	Alpha 15 A user-defined division which is used for reporting assets.	AP05.3
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.	AP05.3
DTC-BAR-CODE Element: Bar Code	Alpha 30	AP05.3
DTC-ITEM-LOC-DTL Element: Item Loc Dtl	Alpha 14	AP05.3

APDISTCODE FILE INDEX

APDISTCODE FILE RELATIONS

ONE TO ONE RELATIONS

All trademarks and registered trademarks are the property of their respective owners.