 |
Lawson Insight Technical Documentation |
|
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
AP220 AP260 AP282 AP95.1 AP95.2 AP95.3
AP275 DA290
UPDATED BY
AP115 AP125 AP126 AP170 AP175 AP177
AP180 AP181 AP190 AP191 AP193 AP195
AP198 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP28.1 AP28.2 AP30.1 AP30.2 AP30.4 AP300
AP305 AP32.2 AP32.1 AP45.1 AP520 API1.1
API2.1 EE135 EE35.1 EE35.2 EE520 MA41.2
MA43.2 MA61.1 MA66.2 MA70.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APD-COMPANY Numeric 4 AP125 AP126
Company The company number. Must be a valid AP170 AP180
record in the Accounts Payable Company AP181 AP190
file. AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP260
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.2 MA43.2
MA61.1 MA66.2
MAI1.1
APD-API-OBJ-ID Numeric 12 AP125 AP126
API Object ID A unique identifier assigned to this AP170 AP180
file record. AP181 AP190
AP191 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.2 MA43.2
MA61.1 MA66.2
MAI1.1
APD-VENDOR Alpha 9 (Right Justified) AP115 AP125
Vendor ID The vendor number. Must be a valid AP126 AP170
record in the Vendor file. AP180 AP181
AP190 AP191
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP260 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-INVOICE Alpha 22 AP115 AP125
Invoice Number The invoice number. Represents a unique AP126 AP170
identifier for the invoice. Must be a AP180 AP181
valid record in the Accounts Payable AP190 AP191
Invoice file. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP260 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-SUFFIX Numeric 3 AP125 AP126
Invoice Suffix The invoice suffix number. Represents AP170 AP180
the occurrence value of the invoice. The AP181 AP190
suffix is assigned by the system to AP191 AP193
recurring invoices, employee advances, AP20.1 AP20.2
and prepayment credit memos. AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP260 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-CANCEL-SEQ Numeric 4 AP125 AP126
Cancel Sequence The sequence number assigned upon the AP170 AP180
cancellation of a distributed invoice. AP181 AP190
The first sequence assigned is 9999. AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP260
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
MA41.2 MA43.2
MA61.1 MAI1.1
APD-DIST-SEQ-NBR Numeric 4 AP125 AP126
Distribution A unique sequence number assigned to AP170 AP180
Sequence Number the distribution record. AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-DIST-TYPE Alpha 1 AP125 AP126
Distribution Type The distribution type. Valid values are: AP170 AP180
AP181 AP190
D = Distribution. AP191 AP20.1
I = Intercompany Distribution. (Not AP20.2 AP20.3
used for distributions that originate in AP20.4 AP20.5
the Accounts Payable system.) AP20.7 AP23.1
G = Gain/Loss Distribution. AP25.1 AP25.2
R = Tax/Reversal Distribution. AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-PROC-LEVEL Alpha 5 AP125 AP126
Process Level The process level associated with the AP170 AP180
distribution. Must be a valid record in AP181 AP190
the Accounts Payable Process Level file. AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.1 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.2 MA43.2
MA61.1 MA66.2
MAI1.1
APD-POST-OPTION Alpha 1 AP125 AP126
Posting Option The general ledger posting option AP170 AP180
associated with the distribution record. AP181 AP190
Valid values are: AP191 AP20.1
AP20.2 AP20.3
D = Detail. AP20.4 AP20.5
S = Summary. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MAI1.1
APD-INVOICE-TYPE Alpha 1 AP125 AP126
Invoice Type The type of invoice associated with the AP170 AP180
distribution. Valid values are: AP181 AP190
AP191 AP20.1
Blank = Invoice. AP20.2 AP20.3
C = Credit Memo. AP20.4 AP20.5
D = Debit Memo. AP20.7 AP23.1
P = Prepayment. AP25.1 AP25.2
Y = Prepayment Credit Memo. AP26.1 AP27.1
A = Employee Advance. AP28.1 AP28.2
M = Employee Advance Credit Memo. AP30.2 AP30.4
E = Employee Expense. AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MAI1.1
APD-REC-STATUS Numeric 1 AP125 AP126
Record Status The distribution record status. Valid AP170 AP175
values are: AP180 AP181
AP190 AP191
0 = Unreleased. AP193 AP20.1
1 = Unposted (released). AP20.2 AP20.3
9 = Posted by AP175. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-INV-CURRENCY Alpha 5 AP125 AP126
Invoice Currency The currency of the invoice. Must be a AP170 AP180
valid record in the Currency Code file. AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-TAX-RATE Percent 7.5 (Percent) AP125 AP126
Tax Rate The tax rate applied to the invoice. AP170 AP180
AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MAI1.1
APD-CURR-RATE Signed 13.6 AP125 AP126
Currency Exchange The currency exchange rate applied to AP170 AP180
Rate the invoice. AP181 AP190
AP191 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.2 MA43.2
MA61.1 MA66.2
MAI1.1
APD-ORIG-BASE-AMT Signed 15.2 AP125 AP126
Base Distribution The amount of the distribution in AP170 AP180
Amount company base currency. AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-BASE-ND Numeric 1 AP125 AP126
Base Currency Nbr The number of decimals positions AP170 AP180
of Decimals defined for the company base currency. AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-ORIG-TRAN-AMT Signed 15.2 AP125 AP126
Distribution Amount The amount of the distribution in the AP170 AP180
currency of the invoice. AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-TRAN-ND Numeric 1 AP125 AP126
Trans Curr Nbr of The number of decimals defined for the AP170 AP180
Decimals invoice currency. AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-TO-BASE-AMT Signed 15.2 AP125 AP126
Distribution The amount of the distribution in the AP170 AP180
Company Base Amt distribution company's base currency. AP181 AP190
AP191 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.2 MA43.2
MA61.1 MA66.2
MAI1.1
APD-TO-BASE-ND Numeric 1 AP125 AP126
Dist Company Nbr of The number of decimal positions defined AP170 AP180
Decimals for the distribution company's currency. AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-TAXABLE-AMT Signed 15.2 AP125 AP126
Taxable Amount The taxable amount of the distribution. AP170 AP180
AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-UNT-AMOUNT Signed 15.2 AP125 AP126
Unit Amount The total unit amount allocated to the AP180 AP181
expense distribution. AP190 AP191
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.2 MA43.2
MA61.1 MA66.2
MAI1.1
APD-DIST-COMPANY Numeric 4 AP125 AP126
Distribution Company The distribution company assigned to AP170 AP180
the distribution. Must be a valid record AP181 AP190
in the General Ledger Company file and a AP191 AP20.1
valid relationship record must exist in AP20.2 AP20.3
the Intercompany Relationship file. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.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.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.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.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.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.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-DISTRIB-DATE Numeric 8 (yyyymmdd) AP125 AP126
Post Date The date used for posting the AP170 AP180
distribution to the general ledger. AP181 AP190
AP191 AP193
AP195 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-TAX-CODE Alpha 10 AP125 AP126
Tax Code The tax code assigned to the AP170 AP180
distribution. Represents tax AP181 AP190
information. If present, identifies the AP191 AP20.1
distribution as a tax distribution. Must AP20.2 AP20.3
be a valid tax code in the Lawson Tax AP20.4 AP20.5
system. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-TAX-TYPE Alpha 1 AP125 AP126
Tax Type Indicates the type of tax defined for AP170 AP180
the Tax Code. Valid values are: AP181 AP190
AP191 AP20.1
I = Invoiced. Default value. The tax AP20.2 AP20.3
represents an increase to the invoice AP20.4 AP20.5
amount. AP20.7 AP23.1
AP25.1 AP25.2
A = Accrued. The tax does not increase AP26.1 AP27.1
the invoice amount. AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MAI1.1
APD-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Description The distribution description. AP170 AP180
AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-DST-REFERENCE Alpha 10 AP125 AP126
Reference The distribution reference. AP170 AP180
AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MAI1.1
APD-ACTIVITY Alpha 15 AP125 AP126
Activity The activity assigned to the AP170 AP180
distribution, if applicable. Used to AP181 AP190
group expense distribution amounts to AP191 AP20.1
track costs for projects, jobs, AP20.2 AP20.3
construction, and so on, without having AP20.4 AP20.5
to define additional general ledger AP20.7 AP23.1
account numbers. Must be a valid AP25.1 AP25.2
activity in the Lawson Activity AP26.1 AP27.1
Management system. AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-ACCT-CATEGORY Alpha 5 AP125 AP126
Account Category The account category assigned to the AP180 AP181
distribution, if applicable. Used to AP190 AP20.1
group distributions under an activity. AP20.2 AP20.3
Must be a valid account category for the AP20.4 AP20.5
activity in the Lawson Activity AP20.7 AP23.1
Management system. AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.2 MA43.2
MA61.1 MA66.2
MAI1.1
APD-ACCR-CODE Alpha 4 AP125 AP126
Invoice Accrual Code The invoice accrual code associated AP170 AP180
with the distribution. Represents a AP181 AP190
general ledger accrual account. Must be AP191 AP20.1
a valid record in the Invoice Accrual AP20.2 AP20.3
Code file. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.1 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.2 MA43.2
MA61.1 MA66.2
MAI1.1
APD-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
PO Number This field contains the number AP170 AP180
representing the purchase order. AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP45.1
API1.1 API2.1
MA41.2 MA43.2
MA61.1 MA66.2
MAI1.1
APD-PO-RELEASE Numeric 4 AP125 AP126
PO Release Number The purchase order release number AP170 AP180
associated with the distribution. Used AP181 AP190
to identify a purchase order release AP191 AP20.1
(created from a blanket or standing AP20.2 AP20.3
order). AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP45.1
API1.1 API2.1
MA41.2 MA43.2
MA61.1 MA66.2
MAI1.1
APD-PO-CODE Alpha 4 AP125 AP126
Purchase Order Code Purchase order number code. Used to AP170 AP180
keep purchase orders unique. Can also be AP181 AP190
used for reporting purposes. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP45.1 API1.1
API2.1 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-PO-LINE-NBR Numeric 6 AP125 AP126
PO Line Number The purchase order line number AP170 AP180
associated with the distribution. AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP45.1
API1.1 API2.1
MA41.2 MA43.2
MA61.1 MA66.2
MAI1.1
APD-PO-AOC-CODE Alpha 2 AP125 AP126
Purchase Order Add Indicates whether this distribution AP180 AP181
On Cost record represents an add-on cost for a AP190 AP20.1
purchase order. Valid values are: AP20.2 AP20.3
AP20.4 AP20.5
Y = Yes. AP20.7 AP23.1
N = No. AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP45.1
AP520 API1.1
API2.1 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-GLT-OBJ-ID Numeric 12 AP125 AP126
GL Interface Object This is a subsystem GL interface AP170 AP175
ID identification number. It is used for AP180 AP181
Drill Around purposes. AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MAI1.1
APD-ATN-OBJ-ID Numeric 12 AP125 AP126
Activity Interface A subsystem activity interface AP170 AP175
Object ID identification number. Used for Drill AP180 AP181
Around purposes. AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
MAI1.1
APD-ASSET-FLAG Alpha 1 AP125 AP126
Asset Exists Indicates whether an asset or asset AP170 AP180
repair record exists for the AP181 AP190
distribution. Valid values are: AP191 AP20.1
AP20.2 AP20.3
A = Asset. AP20.4 AP20.5
R = Repair Asset. AP20.7 AP23.1
Blank = No asset information is defined AP25.1 AP25.2
for the distribution. AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP45.1
AP520 API1.1
API2.1 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-DIST-CODE Alpha 9 AP125 AP126
Distribution Code The distribution code assigned to the AP180 AP181
distribution. Used to split an expense AP190 AP20.1
distribution into multiple distribution AP20.2 AP20.3
lines. Must be a valid record in the AP20.4 AP20.5
Distribution Code Header file. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 API1.1
API2.1 MA41.2
MA43.2 MA61.1
MAI1.1
APD-TAX-POINT Alpha 1 AP125 AP126
Tax Point Indicates when the tax amount is AP180 AP181
calculated for the invoice distribution, AP190 AP20.1
if applicable. Valid values are: AP20.2 AP20.3
AP20.4 AP20.5
I = Invoice. AP20.7 AP23.1
P = Payment. AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP32.2
AP45.1 AP520
API1.1 API2.1
MA41.2 MA43.2
MA61.1 MAI1.1
APD-VAT-REVERSE-FL Alpha 1 AP125 AP126
VAT Reversal Used in AP190 (Invoice Reinstatement) AP180 AP181
to create reversing tax due general AP190 AP20.1
ledger records. This field is No if AP20.2 AP20.3
reversing tax transactions have not been AP20.4 AP20.5
sent to the general ledger. When the AP20.7 AP23.1
transactions are sent to the general AP25.1 AP25.2
ledger, this field changes to Yes. Valid AP26.1 AP27.1
values are: AP28.1 AP28.2
AP45.1 API1.1
N = No. API2.1 MA41.2
Y = Yes. MA43.2 MA61.1
MAI1.1
APD-DST-OBJ-ID Numeric 12 AP180 AP181
Distribution Object An object identifier to keep the record AP190 AP20.1
ID unique. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP28.1 AP28.2
AP30.4 AP45.1
MA41.2 MA43.2
APD-MA-CREATE-FL Alpha 1 AP125 AP126
Matching Creation Indicates the distribution was AP180 AP181
Flag generated during matching, as opposed to AP190 AP20.1
entered manually during invoicing. AP20.2 AP20.3
AP20.4 AP20.5
Also used during the match reversal AP20.7 AP23.1
process to determine whether the AP25.1 AP25.2
distribution should be deleted (match AP26.1 AP27.1
distribution) or left untouched AP28.1 AP28.2
(miscellaneous distribution). AP45.1 API1.1
API2.1 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-TAX-USAGE-CD Alpha 10 AP125 AP126
Tax Usage Cd The tax usage coe for the vendor. This AP180 AP181
filed is required if the AP Company AP190 AP20.1
inidcates that VAT reporting required. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP45.1
AP520 API1.1
API2.1 MA41.2
MA43.2 MA61.1
MA66.2 MAI1.1
APD-TRAN-DIST-FLAG Alpha 1 AP20.1 AP20.2
Tran Dist Flag AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP30.2
MA41.2 MA43.2
APD-PULL-FOR-FR-FL Alpha 1 AP175 AP177
Pull For Fr Fl
APD-DIST-STATUS Derived
Distribution Status Indicates whether the distribution is
posted or unposted.
APDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APDSET1 API-OBJ-ID This index is used to access and create AP115 AP125
DIST-SEQ-NBR unique invoice distribution records. AP126 AP170
AP175 AP180
AP181 AP190
AP193 AP195
AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP260 AP27.1
AP282 AP30.1
AP30.2 AP30.4
AP300 AP305
...
APDSET11 COMPANY Subset AP177
API-OBJ-ID Where (PULL-FOR-FR-FL = "Y" )
DIST-SEQ-NBR
APDSET2 COMPANY This index is used to access invoice AP175 AP195
REC-STATUS distribution records used to create
PROC-LEVEL general ledger distribution and
DIS-ACCT-UNIT gain/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 project.
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
API-OBJ-ID
DIST-SEQ-NBR
APDSET5 GLT-OBJ-ID This index is used to access invoice DA290
API-OBJ-ID distribution records that need to
DIST-SEQ-NBR revalued by AP191 (Unrealized
Gain/Loss).
KeyChange, Subset
Where GLT-OBJ-ID != Zeroes
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 AP20.1 AP20.2
PO-NUMBER distribution records associated with a AP20.3 AP20.4
PO-RELEASE specific purchase order's line item. AP20.5 AP20.7
PO-CODE KeyChange, Subset AP23.1 MA41.2
PO-LINE-NBR Where PO-NUMBER != Spaces MA43.2
PO-AOC-CODE
API-OBJ-ID
DIST-SEQ-NBR
APDSET9 ATN-OBJ-ID This index is used to show the
COMPANY committed cost in Accounts Payable for
VENDOR the Projects 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
Actrans ACTRANS Not Required
APD-ATN-OBJ-ID -> ATN-OBJ-ID (ATNSET12)
Apcompany APCOMPANY Required
APD-COMPANY -> CPY-COMPANY
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
Apuaval APUAVAL Not Required
"D" -> UAV-SEG-TYPE
APD-API-OBJ-ID -> UAV-API-OBJ-ID
APD-DIST-SEQ-NBR -> UAV-DIST-SEQ-NBR
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
Dstusrfld APDSUSRFLD Not Required
APD-API-OBJ-ID -> DFL-API-OBJ-ID
APD-DIST-SEQ-NBR -> DFL-DIST-SEQ-NBR
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
Sltrans SLTRANS
APD-GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|