Lawson Insight Technical Documentation |
|
APDISTRIB
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
AP136 AP198 AP212 AP220 AP237 AP282
AP295 AP700 AP95.1 AP95.2 AP95.3 APCP.1
AP00.4 AP211 AP275 MM280 MM80.1 MM80.2
AP272
UPDATED BY
AP115 AP125 AP126 AP170 AP175 AP177
AP178 AP180 AP181 AP190 AP191 AP193
AP195 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP21.1 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP28.1 AP28.2 AP30.1 AP30.2 AP30.4
AP300 AP305 AP36.2 AP45.1 AP520 API1.1
API2.1 EE135 EE35.1 EE35.2 EE520 MA41.1
MA41.2 MA41.4 MA41.7 MA43.2 MA61.1 MA66.2
MA70.1 MA75.1 MAI1.1 PD20.1 PD20.2 PD20.3
TX101 AP32.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APD-COMPANY Numeric 4 AP125 AP126
Element: 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1 PD20.1
PD20.2 PD20.3
APD-API-OBJ-ID Numeric 12 AP125 AP126
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MA70.1
MA75.1 MAI1.1
PD20.1 PD20.2
PD20.3
APD-VENDOR Alpha 9 (Right Justified) AP115 AP125
Element: Vendor 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
PD20.1 PD20.2
PD20.3
APD-INVOICE Alpha 22 AP115 AP125
Element: Invoice 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
PD20.1 PD20.2
PD20.3
APD-SUFFIX Numeric 3 AP125 AP126
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MA70.1
MA75.1 MAI1.1
PD20.1 PD20.2
PD20.3
APD-CANCEL-SEQ Numeric 4 AP125 AP126
Element: Seq Nbr 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
PD20.1 PD20.2
PD20.3
APD-ORIG-DIST-SEQ Numeric 6 AP180 AP181
Element: Dist Seq Nbr A unique sequence number. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APD-DIST-SEQ-NBR Numeric 6 AP125 AP126
Element: Dist Seq Nbr A unique sequence number assigned to AP170 AP180
the distribution record. AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1 PD20.1
PD20.2 PD20.3
APD-DIST-TYPE Alpha 1 AP125 AP126
Element: Dist 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 AP21.1
G = Gain/Loss Distribution. AP23.1 AP25.1
R = Tax/Reversal Distribution. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1 PD20.1
PD20.2 PD20.3
APD-PROC-LEVEL Alpha 5 AP125 AP126
Element: 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP30.2 AP30.4
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
PD20.1 PD20.2
PD20.3
APD-POST-OPTION Alpha 1 AP125 AP126
Element: Post 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
PD20.1 PD20.2
PD20.3
APD-INVOICE-TYPE Alpha 1 AP125 AP126
Element: 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 AP21.1
P = Prepayment. AP23.1 AP25.1
Y = Prepayment Credit Memo. AP25.2 AP26.1
A = Employee Advance. AP27.1 AP28.1
M = Employee Advance Credit Memo. AP28.2 AP30.2
E = Employee Expense. AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
PD20.1 PD20.2
PD20.3
APD-REC-STATUS Numeric 1 AP125 AP126
Element: 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
5 = Pending AP20.7 AP21.1
6 = Approved AP23.1 AP25.1
7 = Rejected AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP36.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MA70.1
MA75.1 MAI1.1
PD20.1 PD20.2
PD20.3
APD-INV-CURRENCY Alpha 5 AP125 AP126
Element: To Base Curr 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1 PD20.1
PD20.2 PD20.3
APD-TAX-RATE Percent 7.5 (Percent) AP125 AP126
Element: Chrg 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1
APD-CURR-RATE Signed 14.7 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
PD20.1 PD20.2
PD20.3
APD-ORIG-BASE-AMT Signed 18.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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1 PD20.1
PD20.2 PD20.3
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1 PD20.1
PD20.2 PD20.3
APD-ORIG-TRAN-AMT Signed 18.2 AP125 AP126
Element: Distribution AThe 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1 PD20.1
PD20.2 PD20.3
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1 PD20.1
PD20.2 PD20.3
APD-TO-BASE-AMT Signed 18.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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
PD20.1 PD20.2
PD20.3
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1 PD20.1
PD20.2 PD20.3
APD-TAXABLE-AMT Signed 18.2 AP125 AP126
Element: Intl Amt The taxable amount of the distribution. AP170 AP180
AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1
APD-UNT-AMOUNT Signed 18.2 AP125 AP126
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APD-DIST-COMPANY Numeric 4 AP125 AP126
Element: 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1 PD20.1
PD20.2 PD20.3
APD-DIS-ACCT-UNIT Alpha 15 AP125 AP126
Element: Acct 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1 PD20.1
PD20.2 PD20.3
APD-DIS-ACCOUNT Numeric 6 AP125 AP126
Element: Account 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1 PD20.1
PD20.2 PD20.3
APD-DIS-SUB-ACCT Numeric 4 AP125 AP126
Element: Sub Acct 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1 PD20.1
PD20.2 PD20.3
APD-DISTRIB-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MA70.1 MA75.1
MAI1.1 PD20.1
PD20.2 PD20.3
APD-TAX-INDICATOR Numeric 1 AP125 AP126
Element: Tax Indicator 0 AP180 AP181
1 = Exempt AP190 AP20.1
2 = Taxable AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
PD20.1 PD20.2
PD20.3
APD-TAX-SEQ-NBR Numeric 4 AP180 AP181
Element: Tax Seq Nbr AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APD-TAX-CODE Alpha 10 AP125 AP126
Element: 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 Tax. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1
APD-TAX-TYPE Alpha 1 AP125 AP126
Element: 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 AP21.1
AP23.1 AP25.1
A = Accrued. The tax does not increase AP25.2 AP26.1
the invoice amount. AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1
APD-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Element: Description The distribution description. AP170 AP180
AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1 PD20.1
PD20.2 PD20.3
APD-DST-REFERENCE Alpha 10 AP125 AP126
Element: Cross Ref The distribution reference. AP170 AP180
AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APD-ACTIVITY Alpha 15 AP125 AP126
Element: 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 AP21.1
account numbers. Must be a valid AP23.1 AP25.1
activity in Project Accounting. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1 PD20.1
PD20.2 PD20.3
APD-ACCT-CATEGORY Alpha 5 AP125 AP126
Element: Acct 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 Project Accounting. AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
PD20.1 PD20.2
PD20.3
APD-BILL-CATEGORY Alpha 32 AP125 AP126
Element: Bill Category AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MAI1.1 PD20.1
PD20.2 PD20.3
APD-ACCR-CODE Alpha 4 AP125 AP126
Element: Invoice AccruaThe 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP30.2 AP30.4
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
PD20.1 PD20.2
PD20.3
APD-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
Element: 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1
APD-PO-RELEASE Numeric 4 AP125 AP126
Element: Po Release 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1
APD-PO-CODE Alpha 4 AP125 AP126
Element: Purchase OrderPurchase 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP45.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APD-PO-LINE-NBR Numeric 6 AP125 AP126
Element: Line Nbr 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 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 AP21.1
N = No. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APD-GLT-OBJ-ID Numeric 12 AP125 AP126
GL Interface Object This is the object identifier. It is AP170 AP175
ID used to relate commitments or posted AP180 AP181
transactions back to the originating AP190 AP191
subsystems. Each subsystem record that AP193 AP20.1
is updated as a commitment or posted AP20.2 AP20.3
transaction is assigned an object AP20.4 AP20.5
identifier. The object identifier is AP20.7 AP21.1
maintained in the subsystem files and in AP23.1 AP25.1
the Activity Commitments Detail and AP25.2 AP26.1
Activity Transaction files. The object AP27.1 AP28.1
identifier is a unique key used to drill AP28.2 AP30.2
back from Activity Management to the AP30.4 AP45.1
subsystems. AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MA70.1 MA75.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 AP191
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MA70.1 MA75.1
MAI1.1
APD-ASSET-FLAG Alpha 1 AP125 AP126
Element: 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 AP21.1
Blank = No asset information is defined AP23.1 AP25.1
for the distribution. AP25.2 AP26.1
Y = Asset or Repair AP27.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APD-DIST-CODE Alpha 9 AP125 AP126
Element: Dist 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MAI1.1
APD-TAX-POINT Alpha 1 AP125 AP126
Element: 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 AP21.1
P = Payment. AP23.1 AP25.1
G = GL Post Date AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APD-VAT-REVERSE-FL Alpha 1 AP125 AP126
Element: 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 AP21.1
transactions are sent to the general AP23.1 AP25.1
ledger, this field changes to Yes. Valid AP25.2 AP26.1
values are: AP27.1 AP28.1
AP28.2 AP45.1
N = No. API1.1 API2.1
Y = Yes. MA41.1 MA41.2
MA41.4 MA41.7
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 AP21.1
AP23.1 AP28.1
AP28.2 AP30.4
AP45.1 MA41.1
MA41.2 MA41.4
MA41.7 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 AP21.1
process to determine whether the AP23.1 AP25.1
distribution should be deleted (match AP25.2 AP26.1
distribution) or left untouched AP27.1 AP28.1
(miscellaneous distribution). AP28.2 AP45.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APD-TAX-USAGE-CD Alpha 10 AP125 AP126
Element: 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APD-TRAN-DIST-FLAG Alpha 1 AP20.1 AP20.2
Element: Final Dst Flag AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP30.2 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APD-PULL-FOR-FR-FL Alpha 1 AP175 AP177
Element: Pull For Fr Fl
APD-AC-UPD-STATUS Numeric 1 AP125 AP126
Element: Ac Upd Status AC provides status that the activity AP175 AP178
reflects "cash basis" billing. Status AP20.1 AP20.2
change will reflect AP invoice for AP20.3 AP20.4
distibution has been paid and message of AP20.5 AP20.7
payment has been sent to AC. AP21.1 AP23.1
0 = No payment information impact AP25.1 AP25.2
1 = Requires payment information AP26.1 AP27.1
9 = AP invoice paid. AC updated. AP30.2 AP30.4
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APD-AC-UPD-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Ac Upd Date Last Ac distribtion record status change AP175 AP178
date. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APD-AC-UPD-TIME Numeric 6 (hhmmss) AP125 AP126
Element: Ac Upd Time Last AC distribution record change time. AP175 AP178
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APD-DIVERSE-CODE Alpha 5 AP125 AP126
Element: Diverse Code Diversity Code for Account Payable AP25.1 AP25.2
Vendors AP26.1 AP27.1
AP520 MA61.1
MAI1.1
APD-DISTRIB-ADJ Numeric 1 AP30.2
Element: Distrib Adj Identifies distribution as one that was
created from AP30.2 Distribution
Adjustments. If created in AP30.2 form
value equal to '1'. Used to determine
source code to send to GLTRANS and
ACTRANS.
1 = Distribution Adjustment
0
APD-DIST-STATUS Derived
Element: Dist Status Indicates whether the distribution is
posted or unposted.
APD-TAX-FLAG Alpha 1 TX101
Element: All Flag
APD-ICN-CODE Alpha 8 AP20.1 AP20.2
Element: Icn Code AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP30.1 AP30.2
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APD-WEIGHT Signed 9.3 AP20.1 AP20.2
Element: Weight This field contains the unit weight of AP20.3 AP20.4
the item based on the stocking UOM. AP20.5 AP20.7
AP21.1 AP23.1
AP30.1 AP30.2
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APD-SUPLMNTARY-QTY Signed 13.4 AP20.1 AP20.2
Element: Quantity This field contains the desired AP20.3 AP20.4
quantity. AP20.5 AP20.7
AP21.1 AP23.1
AP30.1 AP30.2
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APD-LINE-TYPE Alpha 1 AP20.1 AP20.2
Element: Line Type This field contains the type of AP20.3 AP20.4
inventory on this line. AP20.5 AP20.7
G = Goods AP21.1 AP23.1
S = Service AP30.1 AP30.2
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APD-STATEMENT Alpha 22 API1.1 PD20.1
Element: Invoice Used to identify the invoice. PD20.2 PD20.3
APD-TXN-NBR Alpha 22 API1.1 PD20.1
Element: Transaction PD20.2 PD20.3
APDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APDSET1 API-OBJ-ID AP115 AP125
DIST-SEQ-NBR AP126 AP136
AP170 AP175
AP178 AP180
AP181 AP190
AP191 AP193
AP195 AP198
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP212
AP220 AP23.1
AP237 AP25.1
AP25.2 AP26.1
AP27.1 AP282
...
APDSET10 API-OBJ-ID KeyChange, Subset AP20.1 AP20.2
ORIG-DIST-SEQ Where (ORIG-DIST-SEQ != Zeroes ) AP20.3 AP20.4
TAX-SEQ-NBR And (TAX-SEQ-NBR != Zeroes ) AP20.5 AP20.7
AP21.1 AP23.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APDSET11 COMPANY Subset AP177
API-OBJ-ID Where (PULL-FOR-FR-FL = "Y" )
DIST-SEQ-NBR
APDSET12 COMPANY Subset
STATEMENT Where (PO-NUMBER = Spaces )
TXN-NBR
API-OBJ-ID
DIST-SEQ-NBR
APDSET2 COMPANY KeyChange AP00.4 AP175
REC-STATUS AP178 AP195
PROC-LEVEL AP211 TX101
DIS-ACCT-UNIT
DIS-ACCOUNT
DIS-SUB-ACCT
DISTRIB-DATE
API-OBJ-ID
DIST-SEQ-NBR
APDSET3 DIST-COMPANY KeyChange AP95.2 AP95.3
ACTIVITY
ACCT-CATEGORY
DISTRIB-DATE
API-OBJ-ID
DIST-SEQ-NBR
APDSET4 DIST-COMPANY KeyChange AP237 AP275
DIS-ACCT-UNIT AP95.2 AP95.3
DIS-ACCOUNT
DIS-SUB-ACCT
DISTRIB-DATE
API-OBJ-ID
DIST-SEQ-NBR
APDSET5 GLT-OBJ-ID KeyChange, Subset MM280 MM80.1
API-OBJ-ID Where GLT-OBJ-ID != Zeroes MM80.2
DIST-SEQ-NBR
APDSET6 DST-OBJ-ID KeyChange, Subset
Where DST-OBJ-ID != Zeroes
APDSET7 VENDOR AP272 AP36.2
API-OBJ-ID TX101
DIST-SEQ-NBR
APDSET8 COMPANY KeyChange, Subset AP20.1 AP20.2
PO-NUMBER Where PO-NUMBER != Spaces AP20.3 AP20.4
PO-RELEASE AP20.5 AP20.7
PO-CODE AP21.1 AP23.1
PO-LINE-NBR MA41.1 MA41.2
PO-AOC-CODE MA41.4 MA41.7
API-OBJ-ID MA43.2
DIST-SEQ-NBR
APDSET9 ATN-OBJ-ID KeyChange, Subset
COMPANY Where ATN-OBJ-ID != Zeroes
VENDOR
INVOICE
SUFFIX
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
Apdistrib APDISTRIB Delete Cascades
APD-API-OBJ-ID -> APD-API-OBJ-ID
APD-DIST-SEQ-NBR -> APD-ORIG-DIST-SEQ
APD-TAX-SEQ-NBR
Apvendiv APVENDIV
CPY-VENDOR-GROUP -> VDC-VENDOR-GROUP
APD-VENDOR -> VDC-VENDOR
API-LOCATION -> VDC-LOCATION-CODE
VDC-DIVERSE-CODE
VDC-DCERT-DATE
Pdchrgdist PDCHRGDIST
APD-COMPANY -> PDS-COMPANY
APD-STATEMENT -> PDS-STATEMENT
APD-TXN-NBR -> PDS-TXN-NBR
APD-DIST-SEQ-NBR -> PDS-SEQ-NBR
PDS-PCARD-PROGRAM
Sltrans SLTRANS
APD-GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|