APINVOICE FILE
Accounts Payable Invoice
The Accounts Payable Invoice file contains accounts payable invoice records.
Each record has one or more associated records in the Invoice Payment File.
REFERENCED BY
AP00.4 AP00.7 AP01.1 AP10.1 AP10.2 AP12.2
AP150 AP151 AP155 AP156 AP157 AP160
AP161 AP175 AP197 AP212 AP213 AP230
AP240 AP245 AP250 AP255 AP270 AP275
AP282 AP284 AP285 AP40.1 AP56.2 AP90.1
AP90.3 AP90.2 AP90.4 AP92.2 AP92.1 AP95.1
AP953 AP984 CB06.2 EE20.1 EE20.2 EE20.4
EE230 EE30.1 EE90.1 EE90.2 MA140 MA278
PO122 PO20.1 PO21.3 PO22.2 PO22.3 PO30.1
PO34.1 PO35.1 PO50.1 PO52.1 PO530 PR277
RQ10.1 RQ10.2 AP236 AP239 AP225 AP226
AP91.1
UPDATED BY
AP101 AP125 AP126 AP170 AP180 AP181
AP190 AP191 AP193 AP195 AP20.1 AP20.2
AP20.5 AP20.6 AP20.7 AP20.8 AP23.1 AP25.1
AP25.2 AP25.3 AP26.1 AP260 AP28.1 AP28.2
AP30.1 AP30.2 AP30.3 AP30.4 AP300 AP305
AP32.1 AP32.2 AP35.1 AP36.1 AP45.1 AP520
AP55.2 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
API-COMPANY Numeric 4 AP150 AP20.1
Company The company associated with the AP20.2 AP20.5
invoice. Must be a valid record in the AP20.6 AP20.7
Accounts Payable Company file. AP20.8 AP23.1
AP26.1 AP30.2
AP30.3 AP32.1
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
API-VENDOR Alpha 9 AP150 AP20.1
Vendor ID The invoiced vendor number. Must be a AP20.2 AP20.5
valid record in the Vendor file. AP20.6 AP20.7
AP20.8 AP23.1
AP26.1 AP30.2
AP30.3 AP32.1
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
API-INVOICE Alpha 22 AP150 AP20.1
Invoice Number The invoice number. Must be a unique AP20.2 AP20.5
invoice number for the vendor. AP20.6 AP20.7
AP20.8 AP23.1
AP26.1 AP30.2
AP30.3 AP32.1
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
API-SUFFIX Numeric 3 AP125 AP126
Invoice Suffix The invoice suffix number. Represents AP150 AP170
the occurrence value of the invoice. AP193 AP20.8
Used to identify the recurrence value of AP25.1 AP25.2
a recurring invoice and for AP26.1 AP30.2
system-generated credit memos created AP30.3 AP32.1
for prepayments and employee advances. AP32.2 AP520
AP952
API-CANCEL-SEQ Numeric 4 AP150 AP20.8
Cancel Sequence The sequence number assigned upon the AP26.1 AP30.2
cancellation of a distributed invoice. AP30.3 AP30.4
The first sequence assigned is 9999. AP32.1 AP32.2
AP952
API-CANCEL-DATE Numeric 8 (yyyymmdd) AP26.1 AP30.4
Cancel Date The cancellation date assigned to a AP952
canceled invoice.
API-BATCH-NUM Numeric 6 AP20.1 AP20.2
Batch Number The batch number associated with the AP20.5 AP20.6
invoice. Used only if the company has AP20.7 AP23.1
Yes selected in the Batch Release Option AP25.3 AP26.1
field. 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
API-BATCH-DATE Numeric 8 (yyyymmdd) AP20.1 AP20.2
Batch Date The batch date assigned to the batch AP20.5 AP20.6
number. Must be a valid record in the AP20.7 AP23.1
Batch file. AP26.1 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
API-VOUCHER-NBR Alpha 10 AP20.1 AP20.2
Voucher The voucher number assigned to the AP20.5 AP20.6
invoice. Used only if the company has AP20.7 AP23.1
Yes selected in the Invoice Approval AP26.1 AP30.1
field. 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
API-AUTH-CODE Alpha 3 AP20.1 AP20.2
Authority Code The authority code assigned to the AP20.5 AP20.6
invoice. Represents the person or AP20.7 AP23.1
department responsible for approving a AP26.1 AP36.1
registered invoice and is required AP520 AP952
before a registered invoice can be EE135 EE35.1
released. Used only by a company that EE35.2 EE520
has Yes selected in the Invoice Approval MA40.1 MA40.2
field and No in the Batch Release field. MA41.1 MA41.2
Must be a valid record in the Authority MA41.4 MA41.5
Code file. MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
API-PROC-LEVEL Alpha 5 AP20.1 AP20.2
Process Level The process level assigned to the AP20.5 AP20.6
invoice. Must be a valid record in the AP20.7 AP23.1
Accounts Payable Process Level file. AP30.1 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
API-ACCR-CODE Alpha 4 AP20.1 AP20.2
Invoice Accrual Code The invoice accrual code assigned to AP20.5 AP20.6
the invoice. Used to default a general AP20.7 AP23.1
ledger accrual account to the invoice. AP30.1 AP32.1
Must be a valid record in the Invoice AP520 AP952
Accrual Code file. 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
API-INVOICE-TYPE Alpha 1 AP170 AP20.1
Invoice Type Identifies the type of invoice. Valid AP20.2 AP20.5
values are: AP20.6 AP20.7
AP23.1 AP520
Blank = Invoice. Increases the amount AP952 EE135
owed to the vendor. If the invoice is EE35.1 EE35.2
fully processed, the vendor's purchase EE520 MA40.1
and payment balances will be increased. MA40.2 MA41.1
MA41.2 MA41.4
C = Credit Memo. Reduces the amount owed MA41.5 MA41.6
to the vendor. If the invoice is fully MA43.1 MA43.2
processed, the vendor's purchase and MA43.3 MA43.4
payment balances will be decreased. MA52.1 MA530
MA540 PO31.1
D = Debit Memo. Processed just like an
invoice. Increase the vendor's purchase
and payment balances.
P = Prepayment. Processed just like an
invoice. Used to pay a vendor for goods
or services not yet received.
Y = Prepayment Credit Memo. Created by
AP170 (Payment Closing) to offset a
prepayment and are applied to the
vendor's invoice after it has been
received.
A = Employee Advance. Processed just
like an invoice. Used to pay an employee
for expenses not yet incurred.
M = Employee Advance Credit Memo.
Created by AP170 (Payment Closing) to
offset an employee advance. Can be
applied to the employee's expense after
it has been received.
E = Employee Expense. Processed just
like an invoice.
API-INV-CURRENCY Alpha 5 AP20.1 AP20.2
Invoice Currency The currency of the invoice. Must be a AP20.5 AP20.6
valid record in the Currency Code file. AP20.7 AP20.8
If left blank, the vendor currency AP23.1 AP30.3
defaults. 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
API-PAY-CURRENCY Alpha 5 AP20.6 AP520
Payment Currency The currency used to pay the invoice. AP952 EE135
Must be a valid record in the Currency EE35.1 EE35.2
Code file. EE520
API-INVOICE-DTE Numeric 8 (yyyymmdd) AP170 AP193
Invoice Date The date assigned to the invoice. Used AP20.1 AP20.2
when updating the vendor's purchase AP20.5 AP20.6
balance. If left blank, the system date AP20.7 AP23.1
defaults. 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
API-PURCH-FR-LOC Alpha 4 AP20.1 AP20.2
Purchase From The purchase-from location code AP20.5 AP20.6
Location Code associated with the invoice. Must be a AP20.7 AP23.1
valid record in the Vendor Location AP520 AP952
file. 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
API-PO-NUM Alpha 7 (Right Justified) AP20.1 AP20.2
PO Number The purchase order number associated AP20.5 AP20.6
with the invoice. AP20.7 AP23.1
AP30.1 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
API-PO-RELEASE Numeric 6 AP20.1 AP20.2
PO Release Number The purchase order release number AP20.5 AP20.6
associated with the invoice. Used to AP20.7 AP23.1
identify a purchase order release AP30.1 AP520
created from a blanket or standing AP952 MA40.1
order. 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
API-PO-INVOICE-FL Alpha 1 AP20.1 AP20.2
Purchase Order Indicates whether the invoice AP20.5 AP20.6
Invoice originated in the Lawson Purchase Order AP20.7 AP23.1
system. Invoices that originate in the AP520 AP952
Lawson Purchase Order system cannot be EE135 EE35.1
deleted or canceled in Accounts Payable. EE35.2 EE520
Valid values are: MA40.1 MA40.2
MA41.1 MA41.2
N = No. MA41.4 MA41.5
Y = Yes. MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
API-DESCRIPTION Alpha 30 (Lower Case) AP20.1 AP20.2
Description The invoice description. AP20.5 AP20.6
AP20.7 AP23.1
AP30.1 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
API-BASE-INV-AMT Signed 15.2 AP170 AP193
Base Invoice Amount The amount of the invoice in the AP20.1 AP20.2
company base currency. This amount is AP20.5 AP20.6
calculated based on the currency AP20.7 AP23.1
exchange rate in effect when the invoice AP30.1 AP520
was created or entered. 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
API-BASE-ACT-AMT Signed 15.2 AP170 AP180
Revalued Base The amount of the invoice in the AP181 AP190
Invoice Amount company base currency. For non-base AP191 AP193
currency invoices, this amount is AP20.1 AP20.2
updated when currency revaluation takes AP20.5 AP20.6
place. AP20.7 AP23.1
AP30.1 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
API-BASE-ND Numeric 1 AP20.1 AP20.2
Base Number Of The number of decimal places defined AP20.5 AP20.6
Decimals for the company base currency. AP20.7 AP23.1
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
API-TRAN-INV-AMT Signed 15.2 AP20.1 AP20.2
Invoice Amount The amount of the invoice in the AP20.5 AP20.6
currency of the invoice. AP20.7 AP23.1
AP25.3 AP30.1
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
API-TRAN-ALOW-AMT Signed 15.2 AP20.1 AP20.2
Allowable Amount The amount of the invoice available for AP20.5 AP20.7
discount in the currency of the invoice. AP23.1 AP32.2
Used to calculate the discount amount AP520 AP952
based on the discount rate. If left MA40.1 MA40.2
blank, the invoice amount defaults. MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
API-TRAN-TXBL-AMT Signed 15.2 AP20.1 AP20.2
Taxable Amount The taxable amount of the invoice in AP20.5 AP20.6
the currency of the invoice. AP20.7 AP23.1
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
API-TRAN-ND Numeric 1 AP20.1 AP20.2
Transaction Number The number of decimal places defined AP20.5 AP20.6
of Decimals for the invoice currency. AP20.7 AP23.1
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
API-TRAN-TAX-AMT Signed 15.2 AP20.1 AP20.2
Tax Amount The tax amount of the invoice in the AP20.5 AP20.6
currency of the invoice. AP20.7 AP23.1
AP30.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
API-BASE-DISC-AMT Signed 15.2 AP170 AP190
Base Discount Amount The discount amount of the invoice in AP191 AP193
the company base currency. AP20.1 AP20.2
AP20.5 AP20.7
AP23.1 AP30.1
AP30.3 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
API-TRAN-DISC-AMT Signed 15.2 AP20.1 AP20.2
Discount Amount The discount amount of the invoice in AP20.5 AP20.7
the currency of the invoice. AP23.1 AP30.1
AP30.3 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
API-BASE-TOT-PMT Signed 15.2 AP170 AP193
Base Total Payment The total payment amount created for AP20.1 AP20.2
Amount the invoice in the company base AP20.5 AP20.6
currency. AP20.7 AP20.8
AP23.1 AP30.1
AP30.3 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
API-TRAN-TOT-PMT Signed 15.2 AP170 AP193
Total Payment Amount The total payment amount created for AP20.1 AP20.2
the invoice in the currency of the AP20.5 AP20.6
invoice. AP20.7 AP20.8
AP23.1 AP30.1
AP30.3 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
API-BASE-TOT-DIST Signed 15.2 AP125 AP126
Base Total The total distribution amount of the AP170 AP193
Distribution Amount invoice in the company base currency. AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP23.1
AP25.1 AP25.2
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
API-TRAN-TOT-DIST Signed 15.2 AP170 AP193
Total Distribution The total distribution amount of the AP20.1 AP20.2
Amount invoice in the currency of the invoice. AP20.5 AP20.6
AP20.7 AP23.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
API-TRAN-TOT-TAX Signed 15.2 AP20.1 AP20.2
Total Tax Amount The total tax amount of the invoice in AP20.5 AP20.6
the currency of the invoice. AP20.7 AP23.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
API-TRAN-PAID-AMT Signed 15.2 AP170 AP180
Paid Amount The total amount of the invoice paid to AP181 AP190
date in the currency of the invoice. AP193 AP520
AP952 EE135
EE35.1 EE35.2
EE520
API-ORIG-CNV-RATE Signed 12.6 AP170 AP193
Exchange Rate The currency exchange rate used to AP20.1 AP20.2
convert the invoice amount to the AP20.5 AP20.6
company base currency. This field may be AP20.7 AP23.1
updated if the invoice is revalued to AP520 AP952
account for exchange rate fluctuations. 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
API-ANTICIPATION Alpha 1 AP20.1 AP20.2
Anticipation Flag Indicates whether anticipation criteria AP20.5 AP20.6
will be used to calculate the discount AP20.7 AP23.1
amount of the invoice. Valid values are: AP520 AP952
EE135 EE35.1
N = No. EE35.2 EE520
Y = Yes. 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
API-DISCOUNT-RT Signed 5.3 AP20.1 AP20.2
Discount Rate The discount rate used to calculate the AP20.5 AP20.7
discount amount of the invoice. AP23.1 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
API-DISC-DATE Numeric 8 (yyyymmdd) AP170 AP193
Discount Date The discount date of the invoice. Used AP20.1 AP20.2
to determine whether a discount will be AP20.5 AP20.7
taken on an invoice. AP23.1 AP30.1
AP30.3 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
API-DUE-DATE Numeric 8 (yyyymmdd) AP170 AP193
Due Date The invoice due date. Used to schedule AP20.1 AP20.2
the invoice for payment. AP20.5 AP20.6
AP20.7 AP23.1
AP30.3 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
API-NBR-SPLIT-PMT Numeric 3 AP20.8 AP30.3
Number of Split Used for split payment invoices to AP952
Payments indicate the total number of payments to
be made for the invoice.
API-SPLIT-PMT-SCH Alpha 1 AP20.8 AP30.3
Split Payment Used for split payment invoices to AP952
Schedule indicate the frequency of payments to be
made for the invoice. The invoice, due,
and discount dates are incremented
according the schedule selected. Valid
values are:
W = Weekly.
M = Monthly.
Q = Quarterly.
S = Semiannually.
Y = Yearly.
Blank = Not a split payment invoice.
API-NBR-RECUR-PMT Numeric 3 AP190 AP193
Number of Used for recurring invoices to indicate AP20.1 AP20.2
Recurrences the number of times the invoice will AP20.5 AP20.7
recur. AP23.1 AP30.1
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
API-RECUR-FREQ Alpha 1 AP190 AP193
Recurring Frequency Used for recurring invoices to indicate AP20.1 AP20.2
how often the invoice should recur. AP20.5 AP20.7
Valid values are: AP23.1 AP30.1
AP520 AP952
W = Weekly. MA40.1 MA40.2
M = Monthly. MA41.1 MA41.2
Q = Quarterly. MA41.4 MA41.5
S = Semiannually. MA41.6 MA43.1
Y = Yearly. MA43.2 MA43.3
Blank = Not a recurring invoice. MA43.4 MA52.1
MA530 MA540
E = End of Month PO31.1
API-REMIT-TO-CODE Alpha 4 AP20.1 AP20.2
Remit To Location The remit-to location code associated AP20.5 AP20.6
Code with the invoice. Must be a valid record AP20.7 AP23.1
in the Vendor Location file. AP30.1 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
API-CASH-CODE Alpha 4 AP20.1 AP20.2
Cash Code The cash code assigned to the invoice. AP20.5 AP20.6
Represents the bank account the invoice AP20.7 AP23.1
is to be paid from. Must be a valid AP520 AP952
record in the Cash Code file. 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
API-BANK-INST-CODE Alpha 3 AP20.1 AP20.2
Payment Code The payment code assigned to the AP20.5 AP20.6
invoice. Represents the type of cash AP20.7 AP23.1
payment or bill of exchange payment used AP520 AP952
to pay the invoice. Must be a valid cash EE135 EE35.1
payment transaction code record in the EE35.2 EE520
Bank Transaction Code file. 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
API-CURR-RECALC Alpha 1 AP170 AP20.1
Currency Used for non-base currency invoices to AP20.2 AP20.5
Recalculation indicate whether the invoice will be AP20.6 AP20.7
revalued when it is scheduled for AP23.1 AP520
payment to account for currency exchange AP55.2 AP952
rate fluctuations. Valid values are: EE135 EE35.1
EE35.2 EE520
N = No. MA40.1 MA40.2
Y = Yes. MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
API-TAX-CODE Alpha 10 AP20.1 AP20.2
Tax Code The tax code or tax table code applied AP20.5 AP20.6
to the invoice. Used to calculate AP20.7 AP23.1
invoice tax information. Must be a valid AP520 AP952
record in the Tax Code file. 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
API-INCOME-CODE Alpha 4 AP20.1 AP20.2
Income Code The income code associated with the AP20.5 AP20.6
invoice. Used to track vendor income for AP20.7 AP23.1
the invoice. Must be a valid record in AP45.1 AP520
the Income Code file. 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
API-DIST-CODE Alpha 9 AP20.1 AP20.2
Distribution Code The distribution code assigned to the AP20.5 AP20.7
invoice. Used during invoice entry to AP23.1 AP520
automatically create distributions for AP952 MA40.1
the invoice. Must be a valid record in MA40.2 MA41.1
the Distribution Code file. MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
API-REC-STATUS Numeric 1 AP125 AP126
Record Status The status of the invoice record. Valid AP170 AP180
values are: AP181 AP190
AP25.1 AP25.2
0 = Unreleased. Not available for AP26.1 AP30.4
payment. AP520 AP952
1 = Released. Available for payment. EE135 EE35.1
9 = Historical. Paid and closed. EE35.2 EE520
MA530 MA540
PO31.1
API-CREATE-DATE Numeric 8 (yyyymmdd) AP170 AP193
Creation Date The date the invoice was created in the AP20.1 AP20.2
Lawson Accounts Payable system. AP20.5 AP20.6
AP20.7 AP23.1
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
API-DISTRIB-DATE Numeric 8 (yyyymmdd) AP170 AP193
Post Date The date used for posting invoice AP195 AP20.1
distributions to the general ledger. AP20.2 AP20.5
AP20.6 AP20.7
AP23.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
API-OPERATOR Alpha 10 AP20.1 AP20.2
Operator Code The operator associated with the AP20.5 AP20.6
invoice. AP20.7 AP23.1
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
API-CREATION-TIME Numeric 6 (hhmmss) AP170 AP193
Creation Time The time the invoice was created in the AP20.1 AP20.2
Lawson Accounts Payable system. AP20.5 AP20.6
AP20.7 AP23.1
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
API-VENDOR-GROUP Alpha 4 AP20.1 AP20.2
Vendor Group The vendor group associated with the AP20.5 AP20.6
invoice. Must be a valid record in the AP20.7 AP23.1
Vendor Group file. 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
API-PAY-VENDOR Alpha 9 AP20.1 AP20.2
Pay Vendor The pay vendor for the invoice. AP20.5 AP20.6
Represents the vendor that receives AP20.7 AP23.1
payment for the invoice. Must be a valid AP30.1 AP520
record in the Vendor file. 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
API-PAY-GROUP Alpha 4 AP101 AP180
Pay Group The pay group associated with the AP181 AP190
invoice. A pay group is used for AP20.1 AP20.2
processing accounts payable payments. AP20.5 AP20.6
Must be a valid record in the Pay Group AP20.7 AP23.1
file. AP28.1 AP28.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
API-INVOICE-GROUP Alpha 4 AP20.1 AP20.2
Invoice Group The invoice group assigned to the AP20.5 AP20.6
invoice. An invoice group is a AP20.7 AP23.1
user-defined character expression that AP520 AP952
can be used to select invoices for EE135 EE35.1
payment. The same invoice group can be EE35.2 EE520
assigned to more than one invoice. 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
API-LAST-DIST-SEQ Numeric 4 AP125 AP126
Last Distribution Used by the system to track the number AP170 AP180
Sequence Nbr of the last distribution line created AP181 AP190
for the invoice. AP191 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 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
API-LAST-PMT-SEQ Numeric 4 AP170 AP193
Last Payment Used by the system to track the last AP20.1 AP20.2
Sequence payment record number used for the AP20.5 AP20.6
invoice. AP20.7 AP20.8
AP23.1 AP30.3
AP35.1 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
API-DISCOUNT-CODE Alpha 10 AP20.1 AP20.2
Discount Code The discount code assigned to the AP20.5 AP20.6
invoice. Represents a general ledger AP20.7 AP23.1
discount account. Must be a valid record AP520 AP952
in the Discount Code file. 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
API-INVOICE-SOURCE Alpha 1 AP20.1 AP20.2
Invoice Source Indicates the source for creation of AP20.5 AP20.7
the invoice. Valid values are: AP23.1 AP520
AP952 MA40.1
Blank = Manual entry. MA40.2 MA41.1
E = Electronic Data Interchange (EDI). R MA41.2 MA41.4
= Evaluated Receipts Settlement (ERS). MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
R = ERS MA52.1 MA530
P = Payroll MA540 PO31.1
T = Tax
G = Garnishment
API-INVC-REF-TYPE Alpha 2 AP20.1 AP20.2
Invoice Reference Indicates the type of number the vendor AP20.5 AP20.7
Type is providing to reference the invoice. AP23.1 AP520
Valid values are: AP952 MA40.1
MA40.2 MA41.1
BM = Bill of Lading. MA41.2 MA41.4
IN = Invoice. MA41.5 MA41.6
OW = Service Order. MA43.1 MA43.2
PL = Packing List. MA43.3 MA43.4
PO = Purchase Order Number. MA52.1 MA530
VN = Vendor Order. MA540 PO31.1
WO = Work Order.
WP = Warehouse Pick Ticket.
ZZ = Mutually Defined.
API-APPROVED-FLAG Alpha 1 AP125 AP126
Approved Indicates whether the invoice is AP170 AP20.1
approved for payment. Valid values are: AP20.2 AP20.5
AP20.6 AP20.7
Y = Yes. AP23.1 AP25.1
N = No. AP25.2 AP26.1
D = Disapproved. AP32.1 AP36.1
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
API-APPRV-OPERATOR Alpha 10 AP32.1 AP36.1
Approval Operator If the invoice required approval, this AP952
field contains the operator that
approved or disapproved the invoice.
API-RETURN-NUMBER Numeric 10 AP20.1 AP20.2
Return Number If the goods associated with the AP20.5 AP20.7
invoice were returned, this field AP23.1 AP952
contains the optional return number MA40.1 MA40.2
assigned to the return. MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
API-JRNL-BOOK-NBR Alpha 12 AP20.1 AP20.2
Journal Book The journal book assigned to the AP20.5 AP20.7
transaction. AP23.1 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
API-TAX-POINT Alpha 1 AP20.1 AP20.2
Tax Point Indicates when the tax amount is AP20.5 AP20.6
calculated for the invoice, if AP20.7 AP23.1
applicable. Valid values are: AP30.2 AP32.2
AP520 AP952
I = Invoice. MA40.1 MA40.2
P = Payment. MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
API-OBJ-ID Numeric 12 AP170 AP193
Object ID A subsystem object interface AP20.1 AP20.2
identification number. Used to identify AP20.5 AP20.6
the Invoice Distribution and Asset AP20.7 AP23.1
Detail records that are associated with AP32.1 AP520
the invoice. Also used for Drill Around AP952 EE135
purposes. 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
API-RECON-DATE Numeric 8 (yyyymmdd) AP190 AP260
Reconciliation or Represents the date the transaction
Void Date cleared the bank or was voided.
API-TAX-OUT-BAL Derived
Tax Out of Balance The amount of the invoice that is
Amount out-of-balance due to tax applications
made for the invoice.
API-PMT-OUT-BAL Derived
Payment Out Of The amount of the invoice that is
Balance Amount out-of-balance due to payment
applications made for the invoice.
API-DIST-OUT-BAL Derived
Distrib. Out Of The amount of the invoice that is
Balance Amount out-of-balance due to expense
distribution applications made for the
invoice.
API-OUT-BAL-FLAG Derived
Out of Balance Indicates whether the invoice is
Indicator out-of-balance. Valid values are:
N = No.
Y = Yes.
API-INV-STATUS Derived
Invoice Status Indicates the status of the invoice.
Valid values are:
Unreleased.
Released.
Historical.
API-NET-PAYABLE Derived
Net Payment Amount The net payment amount in the currency
of the invoice.
API-REV-SIGN-AMT Derived
Reversed Signed The invoice amount * -1.
Amount
API-TYPE-SHORT-NME Derived
Short Invoice Type The translation of the invoice type.
Name
API-PO-RELEASE-3 Derived
Purchase Order The purchase order release number
Release Number associated with the invoice. Used to
identify a purchase order release
created from a blanket or standing
order.
API-COMMENT-EXIST Derived
Comments Exist Indicates whether comments exist for
the invoice.
API-JBK-SEQ-NBR Numeric 10 AP170 AP20.1
Journal Book The journal book sequence number AP20.2 AP20.5
Sequence Number assigned to a journal book transaction AP20.7 AP23.1
when it is added or interfaced to the AP520 AP952
Lawson system. Used only when Auto EE135 EE35.1
Journal Book Seq Nbr is set to Yes in EE35.2 EE520
GL10.1 (Company). MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
API-FINAL-DST-FLAG Alpha 1 AP30.2 AP952
Final Distribution Used to indicate whether an invoice has
Flag been fully distributed. Yes or No.
API-INTRASTAT-NBR Numeric 10 AP20.1 AP20.2
Intrastat Number The number assigned by the Intrastat AP20.5 AP20.7
system to a transaction that involves AP23.1 AP30.2
Intrastat reporting after it has been AP30.4 AP520
added. MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
API-SHIP-TO-CTRY Alpha 2 AP20.1 AP20.2
Ship To Country The ship-to country code. Must be a AP20.5 AP20.7
valid Intrastat country code, defined in AP23.1 AP30.2
AP30.4 AP520
IN01.1 (Country Maintenance) MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
API-SHIP-TO-REGION Alpha 2 AP20.1 AP20.2
Ship To Region The ship-to region code. AP20.5 AP20.7
Must be a valid region for the country, AP23.1 AP30.2
defined in IN02.1 (Region AP30.4 AP520
Maintenance). MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APISET1 COMPANY This index is used to access invoice AP00.4 AP00.7
VENDOR records for a specific vendor and AP01.1 AP10.1
INVOICE company. AP101 AP12.2
SUFFIX AP125 AP126
CANCEL-SEQ AP150 AP151
AP155 AP156
AP157 AP160
AP161 AP170
AP175 AP180
AP181 AP190
AP191 AP193
AP197 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP20.8 AP212
...
APISET10 COMPANY This index is used by AP260 (Invoice AP10.2 AP260
RECON-DATE Accrual Reconciliation) to quickly
VENDOR access invoice records that have not
INVOICE been reconciled by a previous AP260 run.
SUFFIX
CANCEL-SEQ KeyChange
APISET12 COMPANY This index is used to access and AP236 AP239
AUTH-CODE inquire on invoices released but not AP36.1
VENDOR approved.
INVOICE
SUFFIX KeyChange, Subset
CANCEL-SEQ Where (APPROVED-FLAG = "N" )
Or (APPROVED-FLAG = "D" )
APISET2 COMPANY This index is used to access unreleased AP00.4 AP125
BATCH-NUM invoice records for a specific batch or AP126 AP195
AUTH-CODE authority code. AP225 AP226
VOUCHER-NBR AP25.1 AP25.2
VENDOR KeyChange, Subset AP25.3 AP26.1
INVOICE Where REC-STATUS = Zeroes
SUFFIX
CANCEL-SEQ
APISET3 REC-STATUS This index is used to access unreleased AP193 AP20.1
COMPANY invoice records for a specific batch or AP20.2 AP20.5
BATCH-NUM authority code in entry order. AP20.6 AP20.7
AUTH-CODE AP23.1 AP25.2
OPERATOR KeyChange AP300 MA40.1
CREATE-DATE MA40.2 MA41.1
CREATION-TIME MA41.2 MA41.4
VENDOR MA41.5 MA41.6
INVOICE MA43.1 MA43.2
SUFFIX MA43.3 MA43.4
CANCEL-SEQ MA52.1
APISET4 COMPANY This index is used to access invoice AP00.4 AP20.1
VOUCHER-NBR records for a specific voucher number. AP20.2 AP20.5
REC-STATUS AP20.6 AP20.7
VENDOR KeyChange AP23.1 AP30.1
INVOICE AP520 AP90.3
SUFFIX MA40.1 MA40.2
CANCEL-SEQ MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APISET5 VENDOR-GROUP This index is used to access invoice AP10.1 AP91.1
VENDOR records not on hold for a specific hold AP92.1
INVOICE code.
SUFFIX
CANCEL-SEQ KeyChange
COMPANY
APISET6 COMPANY This index is used to access invoice AP300 AP90.2
VENDOR records for a specific vendor in invoice
INVOICE-DTE date sequence.
INVOICE
SUFFIX KeyChange
CANCEL-SEQ
APISET7 COMPANY This index is used to access invoice AP125 AP126
REC-STATUS records that are out of balance. AP240 AP25.1
BATCH-NUM AP25.2 AP26.1
VENDOR KeyChange, Subset
INVOICE Where TRAN-TOT-DIST != TRAN-INV-AMT
SUFFIX Or TRAN-TOT-PMT != TRAN-INV-AMT
CANCEL-SEQ Or BASE-TOT-PMT != BASE-INV-AMT
Or TRAN-TOT-TAX != TRAN-TAX-AMT
APISET8 COMPANY This index is used to access invoices AP90.2
VENDOR for a specific vendor in descending
INVOICE-DTE* invoice date sequence.
INVOICE
SUFFIX KeyChange
CANCEL-SEQ
APISET9 COMPANY This index is used to access invoice AP90.4
PO-NUM records for a specific purchase order.
PO-RELEASE
VENDOR KeyChange, Subset
INVOICE Where PO-NUM != Spaces
SUFFIX
CANCEL-SEQ
APINVOICE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apauthor APAUTHOR Required
When API-AUTH-CODE > Spaces
API-COMPANY -> ATR-COMPANY
API-AUTH-CODE -> ATR-AUTH-CODE
Apbatch APBATCH Required
When API-BATCH-NUM != Zeroes
API-COMPANY -> APB-COMPANY
API-BATCH-NUM -> APB-BATCH-NUM
Apcompany APCOMPANY Required
API-COMPANY -> CPY-COMPANY
Apinccode APINCCODE Not Required
API-INCOME-CODE -> TYP-INCOME-CODE
Appayvenmast APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
API-PAY-VENDOR -> VEN-VENDOR
Approclev APPROCLEV Required
API-COMPANY -> APR-COMPANY
API-PROC-LEVEL -> APR-PROC-LEVEL
Apvenlocpurch APVENLOC Required
When API-PURCH-FR-LOC != Spaces
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
API-VENDOR -> VLO-VENDOR
API-PURCH-FR-LOC -> VLO-LOCATION-CODE
Apvenlocremit APVENLOC Required
When API-REMIT-TO-CODE != Spaces
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
API-PAY-VENDOR -> VLO-VENDOR
API-REMIT-TO-CODE -> VLO-LOCATION-CODE
Apvenmast APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
API-VENDOR -> VEN-VENDOR
Cbcashcode CBCASHCODE Required
API-CASH-CODE -> CBC-CASH-CODE
Eeadvance A EEADVANCE Required
When API-INVOICE-TYPE = "A"
API-COMPANY -> EEA-COMPANY
API-VENDOR -> EEA-VENDOR
API-INVOICE -> EEA-ADVANCE-NBR
Eeadvance M EEADVANCE Required
When API-INVOICE-TYPE = "M"
API-COMPANY -> EEA-COMPANY
API-VENDOR -> EEA-VENDOR
API-INVOICE -> EEA-ADVANCE-NBR
Eeexpense EEEXPENSE Required
When API-INVOICE-TYPE = "E"
API-COMPANY -> EXP-COMPANY
API-VENDOR -> EXP-VENDOR
API-INVOICE -> EXP-EXPENSE-NBR
Pocompany POCOMPANY Not Required
API-COMPANY -> PCY-COMPANY
Poreturnhd PORETURNHD Required
API-COMPANY -> PTH-COMPANY
API-RETURN-NUMBER -> PTH-RETURN-NUMBER
Povendor POVENDOR Not Required
API-COMPANY -> POV-COMPANY
API-VENDOR -> POV-VENDOR
Process Level POPROCLEV Not Required
API-COMPANY -> POP-COMPANY
API-PROC-LEVEL -> POP-PROCESS-LEVEL
APINVOICE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apaudit APAUDIT
CPY-VENDOR-GROUP -> APA-VENDOR-GROUP
API-COMPANY -> APA-COMPANY
API-PROC-LEVEL -> APA-PROC-LEVEL
API-VENDOR -> APA-VENDOR
API-INVOICE -> APA-INVOICE
API-SUFFIX -> APA-SUFFIX
API-CANCEL-SEQ -> APA-CANCEL-SEQ
APA-SEQ-NBR
APA-TRANS-DATE
APA-TRANS-TIME
Apcrmemo APCRMEMO
API-COMPANY -> CRM-COMPANY
API-VENDOR -> CRM-VENDOR
API-INVOICE -> CRM-INVOICE
API-SUFFIX -> CRM-SUFFIX
CRM-SEQ-NBR
CRM-CR-MEMO-NBR
CRM-CR-MEMO-SUFFIX
CRM-CR-SEQ-NBR
Apcrmemo2 APCRMEMO
API-COMPANY -> CRM-COMPANY
API-VENDOR -> CRM-VENDOR
API-INVOICE -> CRM-CR-MEMO-NBR
API-SUFFIX -> CRM-CR-MEMO-SUFFIX
CRM-CR-SEQ-NBR
CRM-INVOICE
CRM-SUFFIX
CRM-SEQ-NBR
Apdistcode APDISTCODE
API-COMPANY -> DTC-COMPANY
API-DIST-CODE -> DTC-DIST-CODE
DTC-SEQ-NBR
Apdistrib APDISTRIB Delete Cascades
API-OBJ-ID -> APD-API-OBJ-ID
APD-DIST-SEQ-NBR
Apinvcomments APCOMMENTS Delete Cascades
"I" -> APC-REC-TYPE
API-COMPANY -> APC-COMPANY
API-VENDOR -> APC-VENDOR
Spaces -> APC-LOCATION-CODE
API-INVOICE -> APC-INVOICE
API-SUFFIX -> APC-SUFFIX
APC-SEQ-NBR
Apinvcomments2 APCOMMENTS Delete Cascades
"I" -> APC-REC-TYPE
VEN-VENDOR-GROUP -> APC-VENDOR-GROUP
API-VENDOR -> APC-VENDOR
Spaces -> APC-LOCATION-CODE
API-COMPANY -> APC-COMPANY
API-INVOICE -> APC-INVOICE
API-SUFFIX -> APC-SUFFIX
APC-SEQ-NBR
Appayment APPAYMENT Delete Cascades
API-COMPANY -> APP-COMPANY
API-VENDOR -> APP-VENDOR
API-INVOICE -> APP-INVOICE
API-SUFFIX -> APP-SUFFIX
API-CANCEL-SEQ -> APP-CANCEL-SEQ
APP-SEQ-NBR
APP-VOID-SEQ
Apvencomments2 APCOMMENTS
"V" -> APC-REC-TYPE
CPY-VENDOR-GROUP -> APC-VENDOR-GROUP
API-VENDOR -> APC-VENDOR
Spaces -> APC-LOCATION-CODE
API-COMPANY -> APC-COMPANY
APC-INVOICE
APC-SUFFIX
APC-SEQ-NBR
Poapprove POAPPROVE Delete Restricted
API-COMPANY -> POA-COMPANY
API-VENDOR -> POA-VENDOR
API-INVOICE -> POA-INVOICE
API-SUFFIX -> POA-SUFFIX
POA-PO-NUMBER
POA-PO-RELEASE
POA-LINE-NBR
POA-AOC-CODE
Poinvoice POINVOICE Delete Restricted
API-COMPANY -> POI-COMPANY
API-VENDOR -> POI-VENDOR
API-INVOICE -> POI-INVOICE
API-SUFFIX -> POI-SUFFIX
POI-PO-NUMBER
POI-PO-RELEASE
Pomessage POMESSAGE
API-COMPANY -> POM-COMPANY
API-BATCH-NUM -> POM-BATCH-NBR
API-VENDOR -> POM-VENDOR
API-INVOICE -> POM-INVOICE
API-SUFFIX -> POM-SUFFIX
POM-PO-NUMBER
POM-PO-RELEASE
POM-LINE-NBR
|