APDISTRIB FILE
Invoice Distribution Header
The Invoice Distribution Header file contains invoice distribution records.
The presence of a tax code identifies the record as a tax distribution.
Distribution records that have an asset number or asset template assigned will
also have an associated record in the Asset Detail file.
REFERENCED BY
AP180 AP181 AP260 AP282 AP95.1 AP95.2
AP95.3 AP275
UPDATED BY
AP125 AP126 AP170 AP175 AP190 AP191
AP193 AP195 AP20.1 AP20.2 AP20.5 AP20.7
AP225 AP226 AP23.1 AP25.1 AP25.2 AP26.1
AP30.1 AP30.2 AP30.4 AP300 AP305 AP32.2
AP32.1 AP520 AP952 AP981 AP984 EE135
EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1
MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2
MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APD-COMPANY Numeric 4 AP125 AP126
Company The company number. Must be a valid AP170 AP190
record in the Accounts Payable Company AP191 AP20.1
file. AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP260
AP30.2 AP30.4
AP32.2 AP520
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APD-API-OBJ-ID Numeric 12 AP125 AP126
Api Obj Id A unique identifier assigned to this AP170 AP190
file record. AP191 AP193
AP20.1 AP20.2
AP20.5 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APD-VENDOR Alpha 9 AP125 AP126
Vendor ID The vendor number. Must be a valid AP170 AP190
record in the Vendor file. AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP260
AP30.2 AP30.4
AP32.2 AP520
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APD-INVOICE Alpha 22 AP125 AP126
Invoice Number The invoice number. Represents a unique AP170 AP190
identifier for the invoice. Must be a AP191 AP20.1
valid record in the Accounts Payable AP20.2 AP20.5
Invoice file. AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP260
AP30.2 AP30.4
AP32.2 AP520
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APD-SUFFIX Numeric 3 AP125 AP126
Invoice Suffix The invoice suffix number. Represents AP170 AP190
the occurrence value of the invoice. The AP191 AP193
suffix is assigned by the system to AP20.1 AP20.2
recurring invoices, employee advances, AP20.5 AP20.7
and prepayment credit memos. AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP260 AP30.2
AP30.4 AP32.2
AP520 AP952
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-CANCEL-SEQ Numeric 4 AP125 AP126
Cancel Sequence The sequence number assigned upon the AP170 AP190
cancellation of a distributed invoice. AP191 AP20.1
The first sequence assigned is 9999. AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP260
AP30.2 AP30.4
AP32.2 AP520
AP952 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APD-DIST-SEQ-NBR Numeric 4 AP125 AP126
Distribution A unique sequence number assigned to AP170 AP190
Sequence Number the distribution record. AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-DIST-TYPE Alpha 1 AP125 AP126
Distribution Type The distribution type. Valid values AP170 AP190
are: AP191 AP20.1
AP20.2 AP20.5
D = Distribution. AP20.7 AP225
AP226 AP23.1
I = Intercompany Distribution. (Not AP25.1 AP25.2
used for distributions that originate in AP26.1 AP30.2
the Accounts Payable system.) AP30.4 AP32.2
AP520 AP952
G = Gain/Loss Distribution. EE135 EE35.1
EE35.2 EE520
R = Tax/Reversal Distribution. MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-PROC-LEVEL Alpha 5 AP125 AP126
Process Level The process level associated with the AP170 AP190
distribution. Must be a valid record in AP191 AP20.1
the Accounts Payable Process Level file. AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.1
AP30.2 AP30.4
AP32.2 AP520
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APD-POST-OPTION Alpha 1 AP125 AP126
Posting Option The general ledger posting option AP170 AP190
associated with the distribution record. AP191 AP20.1
Valid values are: AP20.2 AP20.5
AP20.7 AP225
D = Detail. AP226 AP23.1
S = Summary. AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-INVOICE-TYPE Alpha 1 AP125 AP126
Invoice Type The type of invoice associated with the AP170 AP190
distribution. Valid values are: AP191 AP20.1
AP20.2 AP20.5
Blank = Invoice. AP20.7 AP225
C = Credit Memo. AP226 AP23.1
D = Debit Memo. AP25.1 AP25.2
P = Prepayment. AP26.1 AP30.2
Y = Prepayment Credit Memo. AP30.4 AP32.2
A = Employee Advance. AP520 AP952
M = Employee Advance Credit Memo. EE135 EE35.1
E = Employee Expense. EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-REC-STATUS Numeric 1 AP125 AP126
Record Status The distribution record status. Valid AP170 AP175
values are: AP190 AP191
AP193 AP20.1
0 = Unreleased. AP20.2 AP20.5
1 = Unposted (released). AP20.7 AP225
9 = Posted by AP175. AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-INV-CURRENCY Alpha 5 AP125 AP126
Invoice Currency The currency of the invoice. Must be a AP170 AP190
valid record in the Currency Code file. AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-TAX-RATE Percent 7.5 (Percent) AP125 AP126
Tax Rate The tax rate applied to the invoice. AP170 AP190
AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-CURR-RATE Signed 13.6 AP125 AP126
Currency Exchange The currency exchange rate applied to AP170 AP190
Rate the invoice. AP191 AP193
AP20.1 AP20.2
AP20.5 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APD-ORIG-BASE-AMT Signed 15.2 AP125 AP126
Base Distribution The amount of the distribution in AP170 AP190
Amount company base currency. AP193 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-BASE-ND Numeric 1 AP125 AP126
Base Currency Nbr The number of decimals positions AP170 AP190
of Decimals defined for the company base currency. AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-ORIG-TRAN-AMT Signed 15.2 AP125 AP126
Distribution Amount The amount of the distribution in the AP170 AP190
currency of the invoice. AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-TRAN-ND Numeric 1 AP125 AP126
Trans Curr Nbr of The number of decimals defined for the AP170 AP190
Decimals invoice currency. AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-TO-BASE-AMT Signed 15.2 AP125 AP126
Distribution The amount of the distribution in the AP170 AP190
Company Base Amt distribution company's base currency. AP191 AP193
AP20.1 AP20.2
AP20.5 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APD-TO-BASE-ND Numeric 1 AP125 AP126
Dist Company Nbr of The number of decimal positions defined AP170 AP190
Decimals for the distribution company's currency. AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-TAXABLE-AMT Signed 15.2 AP125 AP126
Taxable Amount The taxable amount of the distribution. AP170 AP190
AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-UNT-AMOUNT Signed 15.2 AP125 AP126
Unit Amount The total unit amount allocated to the AP191 AP20.1
expense distribution. AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-DIST-COMPANY Numeric 4 AP125 AP126
Distribution Company The distribution company assigned to AP170 AP190
the distribution. Must be a valid record AP191 AP20.1
in the General Ledger Company file and a AP20.2 AP20.5
valid relationship record must exist in AP20.7 AP225
the Intercompany Relationship file. AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-DIS-ACCT-UNIT Alpha 15 AP125 AP126
Accounting Unit The general ledger distribution AP170 AP180
accounting unit. Must be a valid record AP181 AP190
in the General Ledger Names file. AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-DIS-ACCOUNT Numeric 6 AP125 AP126
Account Number The general ledger distribution account AP170 AP180
number. Must be a valid record in the AP181 AP190
General Ledger Account Master file. AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-DIS-SUB-ACCT Numeric 4 AP125 AP126
Subaccount Number The general ledger distribution AP170 AP180
subaccount number. Must be a valid AP181 AP190
record in the General Ledger Account AP191 AP20.1
Master file. AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-DISTRIB-DATE Numeric 8 (yyyymmdd) AP125 AP126
Post Date The date used for posting the AP170 AP190
distribution to the general ledger. AP191 AP193
AP195 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-TAX-CODE Alpha 10 AP125 AP126
Tax Code The tax code assigned to the AP170 AP190
distribution. Represents tax AP191 AP20.1
information. If present, identifies the AP20.2 AP20.5
distribution as a tax distribution. Must AP20.7 AP225
be a valid tax code in the Lawson Tax AP226 AP23.1
system. AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-TAX-TYPE Alpha 1 AP125 AP126
Tax Type Indicates the type of tax defined for AP170 AP190
the Tax Code. Valid values are: AP191 AP20.1
AP20.2 AP20.5
I = Invoiced. Default value. The tax AP20.7 AP225
represents an increase to the invoice AP226 AP23.1
amount. AP25.1 AP25.2
AP26.1 AP30.2
A = Accrued. The tax does not increase AP30.4 AP32.2
the invoice amount. AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Description The distribution description. AP170 AP190
AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-DST-REFERENCE Alpha 10 AP125 AP126
Reference The distribution reference. AP170 AP190
AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-ACTIVITY Alpha 15 AP125 AP126
Activity The activity assigned to the AP170 AP190
distribution, if applicable. Used to AP191 AP20.1
group expense distribution amounts to AP20.2 AP20.5
track costs for projects, jobs, AP20.7 AP225
construction, and so on, without having AP226 AP23.1
to define additional general ledger AP25.1 AP25.2
account numbers. Must be a valid AP26.1 AP30.2
activity in the Lawson Activity AP30.4 AP32.2
Management system. AP520 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-ACCT-CATEGORY Alpha 5 AP125 AP126
Account Category The account category assigned to the AP190 AP20.1
distribution, if applicable. Used to AP20.2 AP20.5
group distributions under an activity. AP20.7 AP225
Must be a valid account category for the AP226 AP23.1
activity in the Lawson Activity AP25.1 AP25.2
Management system. AP26.1 AP30.2
AP32.2 AP520
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APD-ACCR-CODE Alpha 4 AP125 AP126
Invoice Accrual Code The invoice accrual code associated AP170 AP190
with the distribution. Represents a AP191 AP20.1
general ledger accrual account. Must be AP20.2 AP20.5
a valid record in the Invoice Accrual AP20.7 AP225
Code file. AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.1
AP30.2 AP30.4
AP32.2 AP520
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APD-PO-NUM Alpha 7 (Right Justified) AP125 AP126
PO Number The purchase order number associated AP170 AP190
with the distribution. AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.4
AP952 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APD-PO-RELEASE Numeric 6 AP125 AP126
PO Release Number The purchase order release number AP170 AP190
associated with the distribution. Used AP191 AP20.1
to identify a purchase order release AP20.2 AP20.5
(created from a blanket or standing AP20.7 AP225
order). AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.4
AP952 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APD-PO-LINE-NBR Numeric 6 AP125 AP126
PO Line Number The purchase order line number AP170 AP190
associated with the distribution. AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.4
AP952 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APD-PO-AOC-CODE Alpha 2 AP125 AP126
Purchase Order Add Indicates whether this distribution AP20.1 AP20.2
On Cost record represents an add-on cost for a AP20.5 AP20.7
purchase order. Valid values are: AP225 AP226
AP23.1 AP25.1
Y = Yes. AP25.2 AP26.1
N = No. AP30.4 AP952
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-GLT-OBJ-ID Numeric 12 AP175 AP193
Subsystem GL This is a subsystem GL interface AP984
Interface ID identification number. It is used for
Drill Around purposes.
APD-ATN-OBJ-ID Numeric 12 AP125 AP126
AC System Object ID A subsystem activity interface AP170 AP175
(Sales) identification number. Used for Drill AP193 AP25.1
Around purposes. AP25.2 AP26.1
AP30.2 AP32.2
AP520 AP952
AP981 EE135
EE35.1 EE35.2
EE520 MA530
MA540 PO31.1
APD-ASSET-FLAG Alpha 1 AP125 AP126
Asset Flag Indicates whether an asset or asset AP170 AP190
repair record exists for the AP191 AP20.1
distribution. Valid values are: AP20.2 AP20.5
AP20.7 AP225
A = Asset. AP226 AP23.1
R = Repair Asset. AP25.1 AP25.2
Blank = No asset information is defined AP26.1 AP30.2
for the distribution. AP520 AP952
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-DIST-CODE Alpha 9 AP20.1 AP20.2
Distribution Code The distribution code assigned to the AP20.5 AP20.7
distribution. Used to split an expense AP23.1 AP952
distribution into multiple distribution MA40.1 MA40.2
lines. Must be a valid record in the MA41.1 MA41.2
Distribution Code Header file. MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APD-ANALYSIS-FIELD Alpha 20 AP20.1 AP20.2
Analysis Field This is a user-defined transaction AP20.5 AP20.7
analysis field. This field is not on AP23.1 AP30.2
delivered AP20 forms, but can be AP32.2 AP952
unsplatted on the form (.scr) file to a MA40.1 MA40.2
user-defined location on the AP20 forms. MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APD-TAX-POINT Alpha 1 AP125 AP126
Tax Point Indicates when the tax amount is AP20.1 AP20.2
calculated for the invoice distribution, AP20.5 AP20.7
if applicable. Valid values are: AP225 AP226
AP23.1 AP25.1
I = Invoice. AP25.2 AP26.1
P = Payment. AP30.2 AP32.2
AP520 AP952
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APD-VAT-REVERSE-FL Alpha 1 AP190 AP952
Vat Reverse Fl Used in AP190 (Invoice Reinstatement)
to create reversing tax due general
ledger records. This field is No if
reversing tax transactions have not been
sent to the general ledger. When the
transactions are sent to the general
ledger, this field changes to Yes. Valid
values are:
N = No.
Y = Yes.
APD-DST-OBJ-ID Numeric 12 AP20.1 AP20.2
Dst Obj Id The object ID links the distribution AP20.5 AP20.7
record to general ledger recurring AP23.1 AP952
journal entries. Used to drill around MA40.1 MA40.2
from the General Ledger to recurring MA41.1 MA41.2
journal entries and associated invoice MA41.4 MA41.5
detail created in AP20 (Invoice Entry). MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APD-DIST-STATUS Derived
Distribution Status Indicates whether the distribution is
posted or unposted.
APD-TRAN-DIST-FLAG Alpha 1 AP20.1 AP20.2
Transit Transit Distribution Flag. If this AP20.5 AP20.7
Distribution Flag field is equal to "Y" (yes), then the AP23.1 AP30.2
APDISTRIB record will be known as a MA40.1 MA40.2
Transit Distribution record. "N" (No) MA41.1 MA41.2
will indicate the opposite. Transit MA41.4 MA41.5
Distribution records may be created by MA41.6 MA43.1
AP23.1 (Quick Invoice Entry). MA43.2 MA43.3
Y = Transit Distribution record MA43.4 MA52.1
N = Not a Transit Dist record
R = Reversed Transit Distribution
APD-TAX-USAGE-CD Alpha 10 AP20.1 AP20.2
Tax Usage Code The tax usage code for the vendor. AP20.5 AP20.7
This field is required if the AP Company AP23.1 MA40.1
indicates that VAT reporting required MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
APD-LINE-TYPE Alpha 1 AP20.1 AP20.2
Line Type This field contains the type of AP20.5 AP20.7
inventory on this line. AP23.1 AP30.2
AP520 MA40.1
G - Goods MA40.2 MA41.1
S - Services MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
APDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APDSET1 API-OBJ-ID This index is used to access and create AP125 AP126
DIST-SEQ-NBR unique invoice distribution records. AP170 AP175
AP180 AP181
AP190 AP193
AP195 AP20.1
AP20.2 AP20.5
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP260
AP282 AP30.1
AP30.2 AP30.4
AP300 AP305
AP32.1 AP32.2
AP520 AP95.1
...
APDSET2 COMPANY This index is used to access invoice AP175 AP195
REC-STATUS distribution records used to create
PROC-LEVEL general ledger distribution and gain or
DIS-ACCT-UNIT loss transactions.
DIS-ACCOUNT KeyChange
DIS-SUB-ACCT
DISTRIB-DATE
API-OBJ-ID
DIST-SEQ-NBR
APDSET3 DIST-COMPANY This index is used to access invoice AP95.2 AP95.3
ACTIVITY distribution records associated with a
ACCT-CATEGORY specific activity.
DISTRIB-DATE KeyChange
API-OBJ-ID
DIST-SEQ-NBR
APDSET4 DIST-COMPANY This index is used to access invoice AP275 AP95.2
DIS-ACCT-UNIT distribution records by the general AP95.3
DIS-ACCOUNT ledger account number the distributions
DIS-SUB-ACCT are being posted to.
DISTRIB-DATE KeyChange
GLT-OBJ-ID
API-OBJ-ID
DIST-SEQ-NBR
APDSET6 DST-OBJ-ID This index is used to access
distribution records that are linked to
a recurring journal entry in the Lawson
General Ledger system.
KeyChange, Subset
Where DST-OBJ-ID != Zeroes
APDSET8 COMPANY This index is used to access invoice AP125 AP126
PO-NUM distribution records associated with a AP20.1 AP20.2
PO-RELEASE specific purchase order's line item. AP20.5 AP20.7
PO-LINE-NBR KeyChange, Subset AP225 AP226
PO-AOC-CODE Where PO-NUM != Spaces AP23.1 AP25.1
API-OBJ-ID AP25.2 AP26.1
DIST-SEQ-NBR MA40.1 MA40.2
MA41.1 MA41.2
MA41.3 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APDSET9 ATN-OBJ-ID This index is used to show the
COMPANY committed cost in Accounts Payable for
VENDOR the Lawson Activity Management system.
INVOICE KeyChange, Subset
SUFFIX Where ATN-OBJ-ID != Zeroes
CANCEL-SEQ
DIST-SEQ-NBR
APDISTRIB FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
APD-COMPANY -> CPY-COMPANY (CPYSET1)
Apdistcompany GLSYSTEM Required
APD-DIST-COMPANY -> GLS-COMPANY
Apinvoice APINVOICE Required
APD-COMPANY -> API-COMPANY
APD-VENDOR -> API-VENDOR
APD-INVOICE -> API-INVOICE
APD-SUFFIX -> API-SUFFIX
APD-CANCEL-SEQ -> API-CANCEL-SEQ
Approclev APPROCLEV Required
APD-COMPANY -> APR-COMPANY
APD-PROC-LEVEL -> APR-PROC-LEVEL
Apvenmast APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
APD-VENDOR -> VEN-VENDOR
Asset APASTDTL Not Required
APD-API-OBJ-ID -> APS-API-OBJ-ID
APD-DIST-SEQ-NBR -> APS-DIST-SEQ-NBR
Distribproc APPROCLEV Required
APD-COMPANY -> APR-COMPANY
APD-PROC-LEVEL -> APR-PROC-LEVEL
Glmaster GLMASTER Required
APD-DIST-COMPANY -> GLM-COMPANY
APD-DIS-ACCT-UNIT -> GLM-ACCT-UNIT
APD-DIS-ACCOUNT -> GLM-ACCOUNT
APD-DIS-SUB-ACCT -> GLM-SUB-ACCOUNT
Glsystem Orig GLSYSTEM Required
APD-COMPANY -> GLS-COMPANY
Glsystem To GLSYSTEM Required
APD-DIST-COMPANY -> GLS-COMPANY
APDISTRIB FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poaocdtl POAOCDTL
APD-COMPANY -> PAO-COMPANY
Spaces -> PAO-ORDER-NAME
APD-PO-NUM -> PAO-PO-NUMBER
APD-PO-RELEASE -> PAO-PO-RELEASE
APD-PO-LINE-NBR -> PAO-LINE-NBR
PAO-AOC-CODE
Poapprove POAPPROVE
APD-COMPANY -> POA-COMPANY
APD-VENDOR -> POA-VENDOR
APD-INVOICE -> POA-INVOICE
APD-SUFFIX -> POA-SUFFIX
APD-PO-NUM -> POA-PO-NUMBER
APD-PO-RELEASE -> POA-PO-RELEASE
APD-PO-LINE-NBR -> POA-LINE-NBR
POA-AOC-CODE
Sltrans SLTRANS
APD-GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|