|
|
APDISTCODE FILE
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
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.2 MA43.6
MA43.7 PD22.1 PO101 PO21.3 PO27.2 PO32.1
PO520 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ35.1
RQ500 RQID.1 RQIF.1 RQIJ.1
UPDATED BY
AP05.3 AP305
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DTC-COMPANY Numeric 4 AP05.3
Element: Company The company number. Must be a valid
company in the Accounts Payable Company
file.
DTC-DIST-CODE Alpha 9 AP05.3
Element: Dist Code 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 Numeric 4 AP05.3
Element: Seq Nbr A system-assigned sequence number used
to identify the distribution code detail
record.
DTC-DIST-COMPANY Numeric 4 AP05.3
Element: Posting CompanThe 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 Alpha 15 AP05.3
Distribution The general ledger distribution
Accounting Unit accounting unit used for posting the
expense distribution. Must be a valid
accounting unit in the Lawson General
Ledger system.
DTC-DIS-ACCOUNT Numeric 6 AP05.3
Distribution The general ledger distribution account
Account Number number used for posting the expense
distribution. Must be a valid account
number in the Lawson General Ledger
system.
DTC-DIS-SUB-ACCT Numeric 4 AP05.3
Distribution The general ledger distribution
Subaccount Number subaccount number used for posting the
expense distribution. Must be a valid
subaccount in General Ledger.
DTC-TRAN-DIST-AMT Signed 18.2 AP05.3
Element: Intl Amt The transaction amount for the
distribution. If entered, the Allocation
Percentage and Unit Amount fields must
be blank.
DTC-DIST-RATE Signed 6.3 AP05.3
Element: Dist Rate 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 Alpha 30 (Lower Case) AP05.3
Element: Asset DescriptA description of the asset assigned to
the distribution, if assigned.
DTC-TAG-NBR Alpha 12 AP05.3
Element: Tag The tag number associated with the
distribution. Represents a short name
for a part of an asset.
DTC-ITEM-NBR Alpha 32 AP05.3
Element: Item 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 Alpha 30 AP05.3
Element: Item Desc The item description.
DTC-ITEM-QUANTITY Numeric 8 AP05.3
Element: Item Quantity 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 Alpha 10 AP05.3
Element: Asset TemplateThe 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 Alpha 30 AP05.3
Element: Model 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 Alpha 30 AP05.3
Element: Serial 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 Alpha 1 AP05.3
Element: Hold Asset 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 Numeric 10 AP05.3
Element: Asset 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 Alpha 15 AP05.3 AP20.1
Element: Activity The activity assigned to the AP20.2 AP20.3
distribution. Used to group expense AP20.4 AP20.5
distribution amounts to track costs for AP20.7 AP21.1
projects, jobs, construction, and so on, AP23.1 MA41.1
without having to define additional MA41.2 MA41.4
general ledger account numbers. Must be MA41.7 MA43.2
a valid activity in the Lawson Activity
Management system.
DTC-DST-REFERENCE Alpha 10 AP05.3
Element: Cross Ref The reference value assigned to the
distribution. If left blank, the default
reference value defined for the company
defaults.
DTC-DESCRIPTION Alpha 30 (Lower Case) AP05.3
Element: Description The distribution description. If left
blank, the vendor number and name
defaults on the distribution during
invoice entry.
DTC-ACCT-CATEGORY Alpha 5 AP05.3 AP20.1
Element: Category The account categories assigned to the AP20.2 AP20.3
distribution. Used with the Activity AP20.4 AP20.5
field. AP20.7 AP21.1
AP23.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
DTC-BILL-CATEGORY Alpha 32
Element: Bill Category
DTC-UNT-AMOUNT Signed 18.2 AP05.3
Element: Unit Amount The total units for the distribution.
If entered, the Distribution Amount and
Allocation Percentage fields must be
blank.
DTC-COMBINE Alpha 10 AP05.3
Element: Combine Asset This field indicates whether to combine
items as one asset.
DTC-ASSET-GROUP Alpha 10 AP05.3
Element: Asset Group The asset group assigned to the
distribution.
DTC-ACCT-UNIT Alpha 15
Element: Acct Unit The accounting unit assigned to the
distribution, if assigned. Must be a
valid record in the Lawson General
Ledger system.
DTC-LOCATION-NAME Alpha 15 AP05.3
Element: Location Name A user-defined location name which
represents where an asset is physically
located. Locations are used to report
asset information.
DTC-DIVISION Alpha 15 AP05.3
Element: Division A user-defined division which is used
for reporting assets.
DTC-AU-GROUP Alpha 10 AP05.3
Element: Au Group 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 Alpha 30 AP05.3
Element: Bar Code
DTC-ITEM-LOC-DTL Alpha 14 AP05.3
Element: Item Loc Dtl
APDISTCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DTCSET1 COMPANY AP00.4 AP00.5
DIST-CODE AP05.3 AP20.1
SEQ-NBR 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.2 MA43.6
MA43.7 PD22.1
PO101 PO21.3
PO27.2 PO32.1
PO520 RQ10.1
RQ10.2 RQ10.3
...
APDISTCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
Or DTC-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
|
