APDISTCODE – Distribution Code Detail

System
Accounts Payable (AP)
Prefix
DTC
Primary key
COMPANY, DIST-CODE, SEQ-NBR
Fields
33
Updated by
11 programs
Referenced by
42 programs

APDISTCODE is the Distribution Code Detail table in Lawson Accounts Payable (prefix DTC). It is indexed by COMPANY, DIST-CODE, SEQ-NBR (DTCSET1). It is related 1:1 to APCOMPANY, APDISTHDR and GLMASTER. It is updated by AP05.3, AP305, PO150, PO25.6, PO25.7, PO26.2, PO26.4, PO26.5 and 3 more and referenced by AP00.4, AP00.5, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 34 more. The table has 33 fields, 1 index and 3 documented relations.

About APDISTCODE

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.

Fields (33)

Column = COBOL field name without the DTC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
DTC-COMPANY PK
COMPANY		Numeric 4The company number. Must be a valid company in the Accounts Payable Company file.AP05.3
DTC-DIST-CODE PK
DIST_CODE		Alpha 9A 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 PK
SEQ_NBR		Numeric 4A system-assigned sequence number used to identify the distribution code detail record.AP05.3
DTC-DIST-COMPANY
DIST_COMPANY		Numeric 4The 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
DIS_ACCT_UNIT		Alpha 15The 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
DIS_ACCOUNT		Numeric 6The 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
DIS_SUB_ACCT		Numeric 4The 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
TRAN_DIST_AMT		Signed 18.2The transaction amount for the distribution. If entered, the Allocation Percentage and Unit Amount fields must be blank.AP05.3
DTC-DIST-RATE
DIST_RATE		Signed 6.3The 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
ASSET_DESC		Alpha 30 (Lower Case)A description of the asset assigned to the distribution, if assigned.AP05.3
DTC-TAG-NBR
TAG_NBR		Alpha 12The tag number associated with the distribution. Represents a short name for a part of an asset.AP05.3
DTC-ITEM-NBR
ITEM_NBR		Alpha 32The 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
ITEM_DESC		Alpha 30The item description.AP05.3
DTC-ITEM-QUANTITY
ITEM_QUANTITY		Numeric 8The 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
ASSET_TEMPLATE		Alpha 10The 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
MODEL_NUMBER		Alpha 30The 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
SERIAL_NUMBER		Alpha 30The 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
HOLD_AM		Alpha 1This 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
ASSET		Numeric 10The 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
ACTIVITY		Alpha 15The 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 +9 more
DTC-DST-REFERENCE
DST_REFERENCE		Alpha 10The reference value assigned to the distribution. If left blank, the default reference value defined for the company defaults.AP05.3
DTC-DESCRIPTION
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
ACCT_CATEGORY		Alpha 5The 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 +9 more
DTC-BILL-CATEGORY
BILL_CATEGORY		Alpha 32——
DTC-UNT-AMOUNT
UNT_AMOUNT		Signed 18.2The total units for the distribution. If entered, the Distribution Amount and Allocation Percentage fields must be blank.AP05.3
DTC-COMBINE
COMBINE		Alpha 10This field indicates whether to combine items as one asset.AP05.3
DTC-ASSET-GROUP
ASSET_GROUP		Alpha 10The asset group assigned to the distribution.AP05.3
DTC-ACCT-UNIT
ACCT_UNIT		Alpha 15The accounting unit assigned to the distribution, if assigned. Must be a valid record in the Lawson General Ledger system.—
DTC-LOCATION-NAME
LOCATION_NAME		Alpha 15A user-defined location name which represents where an asset is physically located. Locations are used to report asset information.AP05.3
DTC-DIVISION
DIVISION		Alpha 15A user-defined division which is used for reporting assets.AP05.3
DTC-AU-GROUP
AU_GROUP		Alpha 10Accounting 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
BAR_CODE		Alpha 30—AP05.3
DTC-ITEM-LOC-DTL
ITEM_LOC_DTL		Alpha 14—AP05.3

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
DTCSET1COMPANY, DIST-CODE, SEQ-NBRPrimaryAP00.4, AP00.5, AP05.3, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredDTC-COMPANY → CPY-COMPANY
ApdisthdrAPDISTHDRRequiredDTC-COMPANY → HDR-COMPANY, DTC-DIST-CODE → HDR-DIST-CODE
GlmasterGLMASTERRequiredWhen DTC-DIS-ACCT-UNIT != Spaces Or DTC-DIS-ACCOUNT != ZeroesDTC-COMPANY → GLM-COMPANY, DTC-DIS-ACCT-UNIT → GLM-ACCT-UNIT, DTC-DIS-ACCOUNT → GLM-ACCOUNT, DTC-DIS-SUB-ACCT → GLM-SUB-ACCOUNT

Programs

Updated by (11)

Referenced by (42)