APDISTCODE

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.
UPDATED BY
AP05.3 AP305 AP00.4 AP00.5 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP205 AP21.1
AP23.1 AP520 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
PO520 PO980

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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DTCSET1 COMPANY
DIST-CODE
SEQ-NBR
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
PO520 PO980


APDISTCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
DTC-COMPANY->CPY-COMPANY
Apdisthdr APDISTHDR Required
DTC-COMPANY->HDR-COMPANY
DTC-DIST-CODE->HDR-DIST-CODE
Glmaster GLMASTER Required
When DTC-DIS-ACCT-UNIT !=Spaces
OrDTC-DIS-ACCOUNT !=Zeroes
DTC-COMPANY->GLM-COMPANY
DTC-DIS-ACCT-UNIT->GLM-ACCT-UNIT
DTC-DIS-ACCOUNT->GLM-ACCOUNT
DTC-DIS-SUB-ACCT->GLM-SUB-ACCOUNT


File created: Wed Jun 08 20:47:29 2016

Home
Contact Us



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