|
|
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. You can also use a distribution code to hold
expense distributions in a transit account and distribute them after you have
released the invoice. Use this feature when you want to release your invoices
as you create them on a quick entry screen to have a timely report of tax
liability.
REFERENCED BY
AP00.4 AP00.7 AP20.1 AP20.2 AP20.5 AP20.7
AP205 AP23.1 AP520 AP980 BL92.1 MA40.1
MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6
MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 OE10.1
OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7
OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110
OE113 OE114 OE129 OE14.4 OE15.1 OE15.2
OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810
OE920 PO21.3 PO28.6 PO32.1 PO821 RQ10.2
WH20.2 WH20.7
UPDATED BY
AP05.3 AP305 AP950
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DTC-COMPANY Numeric 4 AP05.3 AP950
Company The company number. Must be a valid
company in the Accounts Payable Company
file.
DTC-DIST-CODE Alpha 9 AP05.3 AP950
Distribution 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 AP950
Sequence Number A system-assigned sequence number used
to identify the distribution code detail
record.
DTC-DIST-COMPANY Numeric 4 AP05.3 AP950
Posting Company 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 Alpha 15 AP05.3 AP950
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 AP950
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 AP950
Distribution The general ledger distribution
Subaccount Number subaccount number used for posting the
expense distribution. Must be a valid
subaccount in the Lawson General Ledger
system.
DTC-TRAN-DIST-AMT Signed 15.2 AP05.3 AP950
Distribution Amount 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 AP950
Allocation The percent of the invoice amount that
Percentage 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 AP950
Asset Description A description of the asset assigned to
the distribution, if assigned.
DTC-TAG-NBR Alpha 12 AP05.3 AP950
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 AP950
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 AP950
Item Description The item description.
DTC-ITEM-QUANTITY Numeric 8 AP05.3 AP950
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 AP950
Asset Template 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 Alpha 30 AP05.3 AP950
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 AP950
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 AP950
Hold 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 AP950
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
Activity The activity assigned to the AP20.2 AP20.5
distribution. Used to group expense AP20.7 AP23.1
distribution amounts to track costs for AP950 MA40.1
projects, jobs, construction, and so on, MA40.2 MA41.1
without having to define additional MA41.2 MA41.4
general ledger account numbers. Must be MA41.5 MA41.6
a valid activity in the Lawson Activity MA43.1 MA43.2
Management system. MA43.3 MA43.4
MA52.1
DTC-DST-REFERENCE Alpha 10 AP05.3 AP950
Reference 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 AP950
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
Category The account categories assigned to the AP20.2 AP20.5
distribution. Used with the Activity AP20.7 AP23.1
field. AP950 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
DTC-UNT-AMOUNT Signed 15.2 AP05.3 AP950
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 AP950
Combine This field indicates whether to combine
items as one asset.
DTC-ASSET-GROUP Alpha 10 AP05.3 AP950
Asset Group The asset group assigned to the
distribution.
DTC-ACCT-UNIT Alpha 15 AP05.3 AP950
Accounting Unit The accounting unit assigned to the
distribution, if assigned. Must be a
valid record in the Lawson General
Ledger system.
DTC-LINE-TYPE Alpha 1 AP05.3
Line Type This field contains the type of
inventory on this line.
G - Goods
S - Services
DTC-LOCATION-NAME Alpha 15 AP05.3
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
Division A user-defined division which is used
for reporting assets.
APDISTCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DTCSET1 COMPANY This index is used to access AP00.4 AP00.7
DIST-CODE distribution code records. AP05.3 AP20.1
SEQ-NBR AP20.2 AP20.5
AP20.7 AP205
AP23.1 AP305
AP520 AP980
BL92.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
...
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
|