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
AP212 AP220 AP237 AP260 AP282 AP295
AP700 AP95.1 AP95.2 AP95.3 APCP.1 TX101
AP00.4 AP211 AP275 MM280 AP272
UPDATED BY
AP115 AP125 AP126 AP170 AP175 AP177
AP178 AP180 AP181 AP190 AP191 AP193
AP195 AP198 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 MA61.1 MA66.2
MA70.1 MA75.1 MAI1.1 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 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 MA61.1
MA66.2 MAI1.1
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
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
MA61.1 MA66.2
MA70.1 MA75.1
MAI1.1
APD-VENDOR Alpha 9 (Right Justified) AP115 AP125
Element: Vendor ID The vendor number. Must be a valid AP126 AP170
record in the Vendor file. AP180 AP181
AP190 AP191
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
MA61.1 MA66.2
MAI1.1
APD-INVOICE Alpha 22 AP115 AP125
Element: Invoice NumberThe 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. 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
MA61.1 MA66.2
MAI1.1
APD-SUFFIX Numeric 3 AP125 AP126
Element: Invoice SuffixThe 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, AP25.1 AP25.2
and prepayment credit memos. AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP45.1 AP520
API1.1 API2.1
MA61.1 MA66.2
MA70.1 MA75.1
MAI1.1
APD-CANCEL-SEQ Numeric 4 AP125 AP126
Element: Sequence NumbeThe sequence number assigned upon the AP170 AP180
cancellation of a distributed invoice. AP181 AP190
The first sequence assigned is 9999. AP191 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 MA61.1
MAI1.1
APD-ORIG-DIST-SEQ Numeric 4 AP180 AP181
Element: Orig Dist Seq AP190 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA66.2
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 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 MA61.1
MA66.2 MAI1.1
APD-DIST-TYPE Alpha 1 AP125 AP126
Element: Distribution TThe distribution type. Valid values are: AP170 AP180
AP181 AP190
D = Distribution. AP191 AP25.1
I = Intercompany Distribution. (Not AP25.2 AP26.1
used for distributions that originate in AP27.1 AP28.1
the Accounts Payable system.) AP28.2 AP30.2
G = Gain/Loss Distribution. AP30.4 AP45.1
R = Tax/Reversal Distribution. AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA61.1
MA66.2 MAI1.1
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 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
MA61.1 MA66.2
MAI1.1
APD-POST-OPTION Alpha 1 AP125 AP126
Element: Posting OptionThe general ledger posting option AP170 AP180
associated with the distribution record. AP181 AP190
Valid values are: AP191 AP25.1
AP25.2 AP26.1
D = Detail. AP27.1 AP28.1
S = Summary. AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA61.1
MAI1.1
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 AP25.1
Blank = Invoice. AP25.2 AP26.1
C = Credit Memo. AP27.1 AP28.1
D = Debit Memo. AP28.2 AP30.2
P = Prepayment. AP30.4 AP45.1
Y = Prepayment Credit Memo. AP520 API1.1
A = Employee Advance. API2.1 EE135
M = Employee Advance Credit Memo. EE35.1 EE35.2
E = Employee Expense. EE520 MA61.1
MAI1.1
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 AP25.1
1 = Unposted (released). AP25.2 AP26.1
9 = Posted by AP175. AP27.1 AP28.1
5 = Pending AP28.2 AP30.2
6 = Approved AP30.4 AP36.2
7 = Rejected AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA61.1 MA66.2
MA70.1 MA75.1
MAI1.1
APD-INV-CURRENCY Alpha 5 AP125 AP126
To Company Base The currency of the invoice. Must be a AP170 AP180
Currency valid record in the Currency Code file. AP181 AP190
AP191 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 MA61.1
MA66.2 MAI1.1
APD-TAX-RATE Percent 7.5 (Percent) AP125 AP126
Element: Chrg Rate The tax rate applied to the invoice. AP170 AP180
AP181 AP190
AP191 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 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
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
MA61.1 MA66.2
MAI1.1
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 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 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 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 MA61.1
MA66.2 MAI1.1
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 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 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 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 MA61.1
MA66.2 MAI1.1
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
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
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 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 MA61.1
MA66.2 MAI1.1
APD-TAXABLE-AMT Signed 18.2 AP125 AP126
Element: Intl Amt The taxable amount of the distribution. AP170 AP180
AP181 AP190
AP191 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 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
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
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 AP25.1
valid relationship record must exist in AP25.2 AP26.1
the Intercompany Relationship file. AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA61.1
MA66.2 MAI1.1
APD-DIS-ACCT-UNIT Alpha 15 AP125 AP126
Element: Accounting UniThe general ledger distribution AP170 AP180
accounting unit. Must be a valid record AP181 AP190
in the General Ledger Names file. AP191 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 MA61.1
MA66.2 MAI1.1
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 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 MA61.1
MA66.2 MAI1.1
APD-DIS-SUB-ACCT Numeric 4 AP125 AP126
Element: Subaccount The general ledger distribution AP170 AP180
subaccount number. Must be a valid AP181 AP190
record in the General Ledger Account AP191 AP25.1
Master file. 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 MA61.1
MA66.2 MAI1.1
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 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 MA61.1
MA66.2 MAI1.1
APD-TAX-INDICATOR Numeric 1 AP125 AP126
Element: Tax Indicator 0 AP180 AP181
1 = Exempt AP190 AP25.1
2 = Taxable AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA61.1
MA66.2 MAI1.1
APD-TAX-SEQ-NBR Numeric 4 AP180 AP181
Element: Tax Seq Nbr AP190 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA66.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 AP25.1
distribution as a tax distribution. Must AP25.2 AP26.1
be a valid tax code in the Lawson Tax AP27.1 AP28.1
system. AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 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 AP25.1
I = Invoiced. Default value. The tax AP25.2 AP26.1
represents an increase to the invoice AP27.1 AP28.1
amount. AP28.2 AP30.2
AP30.4 AP45.1
A = Accrued. The tax does not increase AP520 API1.1
the invoice amount. API2.1 EE135
EE35.1 EE35.2
EE520 MA61.1
MA66.2 MAI1.1
APD-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Element: Description The distribution description. AP170 AP180
AP181 AP190
AP191 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 MA61.1
MA66.2 MAI1.1
APD-DST-REFERENCE Alpha 10 AP125 AP126
Element: Cross Ref The distribution reference. AP170 AP180
AP181 AP190
AP191 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 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 AP25.1
track costs for projects, jobs, AP25.2 AP26.1
construction, and so on, without having AP27.1 AP28.1
to define additional general ledger AP28.2 AP30.2
account numbers. Must be a valid AP30.4 AP45.1
activity in the Lawson Activity AP520 API1.1
Management system. API2.1 EE135
EE35.1 EE35.2
EE520 MA61.1
MA66.2 MAI1.1
APD-ACCT-CATEGORY Alpha 5 AP125 AP126
Element: Account CategoThe account category assigned to the AP180 AP181
distribution, if applicable. Used to AP190 AP25.1
group distributions under an activity. AP25.2 AP26.1
Must be a valid account category for the AP27.1 AP28.1
activity in the Lawson Activity AP28.2 AP30.2
Management system. AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA61.1 MA66.2
MAI1.1
APD-BILL-CATEGORY Alpha 32 AP125 AP126
Element: Bill Category AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP520
API1.1 API2.1
MA61.1 MAI1.1
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 AP25.1
a valid record in the Invoice Accrual AP25.2 AP26.1
Code file. 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
MA61.1 MA66.2
MAI1.1
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 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP45.1 API1.1
API2.1 MA61.1
MA66.2 MAI1.1
APD-PO-RELEASE Numeric 4 AP125 AP126
Element: PO Release NumThe purchase order release number AP170 AP180
associated with the distribution. Used AP181 AP190
to identify a purchase order release AP191 AP25.1
(created from a blanket or standing AP25.2 AP26.1
order). AP27.1 AP28.1
AP28.2 AP30.4
AP45.1 API1.1
API2.1 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. AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP45.1
API1.1 API2.1
MA61.1 MA66.2
MAI1.1
APD-PO-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number The purchase order line number AP170 AP180
associated with the distribution. AP181 AP190
AP191 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP45.1 API1.1
API2.1 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 AP25.1
purchase order. Valid values are: AP25.2 AP26.1
AP27.1 AP28.1
Y = Yes. AP28.2 AP30.4
N = No. AP45.1 AP520
API1.1 API2.1
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 AP191
AP193 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
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 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
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 AP25.1
AP25.2 AP26.1
A = Asset. AP27.1 AP28.1
R = Repair Asset. AP28.2 AP30.2
Blank = No asset information is defined AP45.1 AP520
for the distribution. API1.1 API2.1
MA61.1 MA66.2
MAI1.1
APD-DIST-CODE Alpha 9 AP125 AP126
Element: Distribution CThe distribution code assigned to the AP180 AP181
distribution. Used to split an expense AP190 AP25.1
distribution into multiple distribution AP25.2 AP26.1
lines. Must be a valid record in the AP27.1 AP28.1
Distribution Code Header file. AP28.2 AP45.1
API1.1 API2.1
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 AP25.1
if applicable. Valid values are: AP25.2 AP26.1
AP27.1 AP28.1
I = Invoice. AP28.2 AP30.2
P = Payment. AP45.1 AP520
G = GL Post Date API1.1 API2.1
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 AP25.1
ledger records. This field is No if AP25.2 AP26.1
reversing tax transactions have not been AP27.1 AP28.1
sent to the general ledger. When the AP28.2 AP45.1
transactions are sent to the general API1.1 API2.1
ledger, this field changes to Yes. Valid MA61.1 MAI1.1
values are:
N = No.
Y = Yes.
APD-DST-OBJ-ID Numeric 12 AP180 AP181
Distribution Object An object identifier to keep the record AP190 AP28.1
ID unique. AP28.2 AP30.4
AP45.1
APD-MA-CREATE-FL Alpha 1 AP125 AP126
Matching Creation Indicates the distribution was AP180 AP181
Flag generated during matching, as opposed to AP190 AP25.1
entered manually during invoicing. AP25.2 AP26.1
AP27.1 AP28.1
Also used during the match reversal AP28.2 AP45.1
process to determine whether the API1.1 API2.1
distribution should be deleted (match MA61.1 MA66.2
distribution) or left untouched MAI1.1
(miscellaneous distribution).
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 AP25.1
inidcates that VAT reporting required. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA61.1 MA66.2
MAI1.1
APD-TRAN-DIST-FLAG Alpha 1 AP30.2
Element: Final Dst Flag
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 AP178 AP25.1
reflects "cash basis" billing. Status AP25.2 AP26.1
change will reflect AP invoice for AP27.1 AP30.2
distibution has been paid and message of AP30.4 AP520
payment has been sent to AC. API1.1 API2.1
0 = No payment information impact MA61.1 MAI1.1
1 = Requires payment information
9 = AP invoice paid. AC updated.
APD-AC-UPD-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Ac Upd Date Last Ac distribtion record status change AP178 AP25.1
date. AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA61.1 MAI1.1
APD-AC-UPD-TIME Numeric 6 (hhmmss) AP125 AP126
Element: Ac Upd Time Last AC distribution record change time. AP178 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
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: Distribution SIndicates 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 AP178
AP180 AP181
AP190 AP191
AP193 AP195
AP198 AP212
AP220 AP237
AP25.1 AP25.2
AP26.1 AP260
AP27.1 AP282
AP295 AP30.1
AP30.2 AP30.4
AP300 AP305
AP32.1 AP36.2
...
APDSET10 API-OBJ-ID KeyChange, Subset
ORIG-DIST-SEQ Where (ORIG-DIST-SEQ != Zeroes )
TAX-SEQ-NBR And (TAX-SEQ-NBR != Zeroes )
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 AP00.4 AP175
REC-STATUS distribution records used to create AP178 AP195
PROC-LEVEL general ledger distribution and AP211
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 AP237 AP275
DIS-ACCT-UNIT distribution records by the general AP95.2 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 MM280
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
APDSET7 VENDOR AP272 AP36.2
API-OBJ-ID
DIST-SEQ-NBR
APDSET8 COMPANY This index is used to access invoice
PO-NUMBER distribution records associated with a
PO-RELEASE specific purchase order's line item.
PO-CODE KeyChange, Subset
PO-LINE-NBR Where PO-NUMBER != Spaces
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
Apdistrib APDISTRIB Delete Cascades
APD-API-OBJ-ID -> APD-API-OBJ-ID
APD-DIST-SEQ-NBR -> APD-ORIG-DIST-SEQ
APD-TAX-SEQ-NBR
Sltrans SLTRANS
APD-GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|