 |
Lawson Insight Technical Documentation |
|
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
POA3.1 AP00.4 AP00.5 AP01.1 AP141 AP150
AP151 AP155 AP156 AP160 AP161 AP175
AP176 AP197 AP212 AP213 AP220 AP230
AP240 AP245 AP250 AP252 AP255 AP270
AP275 AP282 AP284 AP40.1 AP56.2 AP90.1
AP90.3 AP90.2 AP90.4 AP91.1 AP92.2 AP92.1
AP95.1 APCP.1 APH1.1 AR48.3 CB06.2 EE20.1
EE20.2 EE20.4 EE230 EE30.1 EE90.1 EE90.2
MA126 MA278 MA63.1 MA68.1 MAED.1 POIJ.1
PR277 AP236 AP10.1 AP251 API3.1 API4.1
UPDATED BY
AP101 AP115 AP130 AP170 AP180 AP181
AP190 AP191 AP193 AP195 AP198 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 API1.1 API2.1 EE135
EE35.1 EE35.2 EE520 MA310 MA65.1 MA66.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
API-COMPANY Numeric 4 AP150 AP180
Company The company associated with the AP181 AP190
invoice. Must be a valid record in the AP28.1 AP28.2
Accounts Payable Company file. AP30.2 AP30.3
AP300 AP32.1
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-VENDOR Alpha 9 (Right Justified) AP115 AP150
Vendor ID The invoiced vendor number. Must be a AP180 AP181
valid record in the Vendor file. AP190 AP28.1
AP28.2 AP30.2
AP30.3 AP300
AP32.1 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA63.1
MA65.1 MA68.1
API-INVOICE Alpha 22 AP115 AP150
Invoice Number The invoice number. Must be a unique AP180 AP181
invoice number for the vendor. AP190 AP28.1
AP28.2 AP30.2
AP30.3 AP300
AP32.1 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA63.1
MA65.1 MA68.1
API-SUFFIX Numeric 3 AP150 AP170
Invoice Suffix The invoice suffix number. Represents AP180 AP181
the occurrence value of the invoice. AP190 AP193
Used to identify the recurrence value of AP28.1 AP28.2
a recurring invoice and for AP30.2 AP30.3
system-generated credit memos created AP300 AP32.1
for prepayments and employee advances. AP32.2 AP45.1
AP520 MA310
MA63.1 MA65.1
MA68.1
API-CANCEL-SEQ Numeric 4 AP150 AP180
Cancel Sequence The sequence number assigned upon the AP181 AP190
cancellation of a distributed invoice. AP28.1 AP28.2
The first sequence assigned is 9999. AP30.2 AP30.3
AP30.4 AP300
AP32.1 AP32.2
AP45.1 MA310
MA63.1 MA65.1
MA68.1
API-CANCEL-DATE Numeric 8 (yyyymmdd) AP180 AP181
Cancel Date The cancellation date assigned to a AP190 AP28.1
canceled invoice. AP28.2 AP30.4
AP45.1
API-BATCH-NUM Numeric 6 AP180 AP181
Batch Number The batch number associated with the AP190 AP28.1
invoice. Used only if the company has AP28.2 AP45.1
Yes selected in the Batch Release Option AP520 API1.1
field. API2.1 MA310
MA63.1 MA65.1
MA68.1
API-BATCH-DATE Numeric 8 (yyyymmdd) AP180 AP181
Batch Date The batch date assigned to the batch AP190 AP28.1
number. Must be a valid record in the AP28.2 AP45.1
Batch file. AP520 API1.1
API2.1
API-VOUCHER-NBR Alpha 10 AP180 AP181
Voucher The voucher number assigned to the AP190 AP28.1
invoice. Used only if the company has AP28.2 AP30.1
Yes selected in the Invoice Registration AP45.1 AP520
Option field. API1.1 API2.1
MA310 MA63.1
MA65.1 MA68.1
API-AUTH-CODE Alpha 3 AP180 AP181
Authority Code The authority code assigned to the AP190 AP28.1
invoice. Represents the person or AP28.2 AP36.1
department responsible for approving a AP45.1 AP520
registered invoice and is required API1.1 API2.1
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
field and No in the Batch Release field.
Must be a valid record in the Authority
Code file.
API-PROC-LEVEL Alpha 5 AP180 AP181
Process Level The process level assigned to the AP190 AP28.1
invoice. Must be a valid record in the AP28.2 AP30.1
Accounts Payable Process Level file. AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA63.1
MA65.1 MA68.1
API-ACCR-CODE Alpha 4 AP180 AP181
Invoice Accrual Code The invoice accrual code assigned to AP190 AP28.1
the invoice. Used to default a general AP28.2 AP30.1
ledger accrual account to the invoice. AP32.1 AP45.1
Must be a valid record in the Invoice AP520 API1.1
Accrual Code file. API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-INVOICE-TYPE Alpha 1 AP170 AP180
Invoice Type Identifies the type of invoice. Valid AP181 AP190
values are: AP28.1 AP28.2
AP45.1 AP520
Blank = Invoice. Increases the amount API1.1 API2.1
owed to the vendor. If the invoice is EE135 EE35.1
fully processed, the vendor's purchase EE35.2 EE520
and payment balances will be increased. MA310 MA63.1
MA65.1 MA68.1
C = Credit Memo. Reduces the amount
owed to the vendor. If the invoice is
fully processed, the vendor's purchase
and payment balances will be decreased.
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 AP180 AP181
Invoice Currency The currency of the invoice. Must be a AP190 AP28.1
valid record in the Currency Code file. AP28.2 AP30.3
If left blank, the vendor currency AP45.1 AP520
defaults. API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA63.1
MA65.1 MA68.1
API-PAY-CURRENCY Alpha 5 AP180 AP181
Payment Currency The currency used to pay the invoice. AP190 AP28.1
Must be a valid record in the Currency AP28.2 AP45.1
Code file. AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-INVOICE-DTE Numeric 8 (yyyymmdd) AP170 AP180
Invoice Date The date assigned to the invoice. Used AP181 AP190
when updating the vendor's purchase AP193 AP28.1
balance. If left blank, the system date AP28.2 AP45.1
defaults. AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-PURCH-FR-LOC Alpha 4 AP115 AP180
Purchase From The purchase-from location code AP181 AP190
Location Code associated with the invoice. Must be a AP28.1 AP28.2
valid record in the Vendor Location AP45.1 AP520
file. API1.1 API2.1
MA310 MA63.1
MA65.1 MA68.1
API-PO-NUMBER Alpha 14 (Right Justified) AP180 AP181
PO Number This field contains the number AP190 AP28.1
representing the purchase order. AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
MA310 MA63.1
MA65.1 MA68.1
API-PO-RELEASE Numeric 4 AP180 AP181
PO Release Number The purchase order release number AP190 AP28.1
associated with the invoice. Used to AP28.2 AP30.1
identify a purchase order release AP45.1 AP520
created from a blanket or standing API1.1 API2.1
order. MA310 MA63.1
MA65.1 MA68.1
API-PO-CODE Alpha 4 AP180 AP181
Purchase Order Code Purchase order number code. Used to AP190 AP28.1
keep purchase orders unique. Can be used AP28.2 AP30.1
for reporting purposes. AP45.1 AP520
API1.1 API2.1
MA310 MA63.1
MA65.1 MA68.1
API-DESCRIPTION Alpha 30 (Lower Case) AP180 AP181
Description The invoice description. AP190 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
API-BASE-INV-AMT Signed 15.2 AP170 AP180
Base Invoice Amount The amount of the invoice in the AP181 AP190
company base currency. This amount is AP193 AP28.1
calculated based on the currency AP28.2 AP30.1
exchange rate in effect when the invoice AP45.1 AP520
was created or entered. API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA63.1
MA65.1 MA68.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 AP28.1 AP28.2
updated when currency revaluation takes AP30.1 AP45.1
place. AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-BASE-ND Numeric 1 AP180 AP181
Base Number Of The number of decimal places defined AP190 AP28.1
Decimals for the company base currency. AP28.2 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA63.1
MA65.1 MA68.1
API-TRAN-INV-AMT Signed 15.2 AP180 AP181
Invoice Amount The amount of the invoice in the AP190 AP28.1
currency of the invoice. AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA63.1
MA65.1 MA68.1
API-TRAN-ALOW-AMT Signed 15.2 AP180 AP181
Allowable Amount The amount of the invoice available for AP190 AP28.1
discount in the currency of the invoice. AP28.2 AP32.2
Used to calculate the discount amount AP45.1 AP520
based on the discount rate. If left API1.1 API2.1
blank, the invoice amount defaults. MA310 MA63.1
MA65.1 MA68.1
API-TRAN-TXBL-AMT Signed 15.2 AP180 AP181
Taxable Amount The taxable amount of the invoice in AP190 AP28.1
the currency of the invoice. AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-TRAN-ND Numeric 1 AP180 AP181
Transaction Number The number of decimal places defined AP190 AP28.1
of Decimals for the invoice currency. AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-TRAN-TAX-AMT Signed 15.2 AP180 AP181
Tax Amount The tax amount of the invoice in the AP190 AP28.1
currency of the invoice. AP28.2 AP30.1
AP30.2 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA63.1
MA65.1 MA68.1
API-BASE-DISC-AMT Signed 15.2 AP170 AP180
Base Discount Amount The discount amount of the invoice in AP181 AP190
the company base currency. AP191 AP193
AP28.1 AP28.2
AP30.1 AP30.3
AP32.2 AP45.1
AP520 API1.1
API2.1 MA310
MA63.1 MA65.1
MA68.1
API-TRAN-DISC-AMT Signed 15.2 AP180 AP181
Discount Amount The discount amount of the invoice in AP190 AP28.1
the currency of the invoice. AP28.2 AP30.1
AP30.3 AP32.2
AP45.1 AP520
API1.1 API2.1
MA310 MA63.1
MA65.1 MA68.1
API-BASE-TOT-PMT Signed 15.2 AP170 AP180
Base Total Payment The total payment amount created for AP181 AP190
Amount the invoice in the company base AP193 AP28.1
currency. AP28.2 AP30.1
AP30.3 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-TRAN-TOT-PMT Signed 15.2 AP170 AP180
Total Payment Amount The total payment amount created for AP181 AP190
the invoice in the currency of the AP193 AP28.1
invoice. AP28.2 AP30.1
AP30.3 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-BASE-TOT-DIST Signed 15.2 AP170 AP180
Base Total The total distribution amount of the AP181 AP190
Distribution Amount invoice in the company base currency. AP193 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA63.1
MA65.1 MA68.1
API-TRAN-TOT-DIST Signed 15.2 AP170 AP180
Total Distribution The total distribution amount of the AP181 AP190
Amount invoice in the currency of the invoice. AP193 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA63.1
MA65.1 MA68.1
API-TRAN-TOT-TAX Signed 15.2 AP180 AP181
Total Tax Amount The total tax amount of the invoice in AP190 AP28.1
the currency of the invoice. AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA63.1
MA65.1 MA68.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 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
API-ORIG-CNV-RATE Signed 12.6 AP170 AP180
Exchange Rate The currency exchange rate used to AP181 AP190
convert the invoice amount to the AP193 AP28.1
company base currency. This field may be AP28.2 AP45.1
updated if the invoice is revalued to AP520 API1.1
account for exchange rate fluctuations. API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-ANTICIPATION Alpha 1 AP180 AP181
Anticipation Flag Indicates whether anticipation criteria AP190 AP28.1
will be used to calculate the discount AP28.2 AP45.1
amount of the invoice. Valid values are: AP520 API1.1
API2.1 EE135
N = No. EE35.1 EE35.2
Y = Yes. EE520
API-DISCOUNT-RT Percent 5.3 (Percent) AP180 AP181
Discount Rate The discount rate used to calculate the AP190 AP28.1
discount amount of the invoice. AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA63.1 MA65.1
MA68.1
API-DISC-DATE Numeric 8 (yyyymmdd) AP170 AP180
Discount Date The discount date of the invoice. Used AP181 AP190
to determine whether a discount will be AP193 AP28.1
taken on an invoice. AP28.2 AP30.1
AP30.3 AP32.2
AP45.1 AP520
API1.1 API2.1
MA310 MA63.1
MA65.1 MA68.1
API-DUE-DATE Numeric 8 (yyyymmdd) AP170 AP180
Due Date The invoice due date. Used to schedule AP181 AP190
the invoice for payment. AP193 AP28.1
AP28.2 AP30.3
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA63.1
MA65.1 MA68.1
API-NBR-SPLIT-PMT Numeric 3 AP180 AP181
Number of Split Used for split payment invoices to AP190 AP28.1
Payments indicate the total number of payments to AP28.2 AP30.3
be made for the invoice. AP45.1
API-SPLIT-PMT-SCH Alpha 1 AP180 AP181
Split Payment Used for split payment invoices to AP190 AP28.1
Schedule indicate the frequency of payments to be AP28.2 AP30.3
made for the invoice. The invoice, due, AP45.1
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 AP180 AP181
Number of Used for recurring invoices to indicate AP190 AP193
Recurrences the number of times the invoice will AP28.1 AP28.2
recur. AP30.1 AP45.1
AP520 API1.1
API2.1
API-RECUR-FREQ Alpha 1 AP180 AP181
Recurring Frequency Used for recurring invoices to indicate AP190 AP193
how often the invoice should recur. AP28.1 AP28.2
Valid values are: AP30.1 AP45.1
AP520 API1.1
W = Weekly. API2.1
M = Monthly.
Q = Quarterly.
S = Semiannually.
Y = Yearly.
Blank = Not a recurring invoice.
API-REMIT-TO-CODE Alpha 4 AP115 AP180
Remit To Location The remit-to location code associated AP181 AP190
Code with the invoice. Must be a valid record AP28.1 AP28.2
in the Vendor Location file. AP30.1 AP45.1
AP520 API1.1
API2.1
API-CASH-CODE Alpha 4 AP115 AP180
Cash Code The cash code assigned to the invoice. AP181 AP190
Represents the bank account the invoice AP28.1 AP28.2
is to be paid from. Must be a valid AP45.1 AP520
record in the Cash Code file. API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
API-BANK-INST-CODE Alpha 3 AP115 AP180
Payment Code The payment code assigned to the AP181 AP190
invoice. Represents the type of cash AP28.1 AP28.2
payment or bill of exchange payment used AP45.1 AP520
to pay the invoice. Must be a valid cash API1.1 API2.1
payment transaction code record in the EE135 EE35.1
Bank Transaction Code file. EE35.2 EE520
API-CURR-RECALC Alpha 1 AP170 AP180
Currency Used for non-base currency invoices to AP181 AP190
Recalculation indicate whether the invoice will be AP28.1 AP28.2
revalued when it is scheduled for AP45.1 AP520
payment to account for currency exchange AP55.2 API1.1
rate fluctuations. Valid values are: API2.1 EE135
EE35.1 EE35.2
N = No. EE520
Y = Yes.
API-TAX-CODE Alpha 10 AP180 AP181
Tax Code The tax code or tax table code applied AP190 AP28.1
to the invoice. Used to calculate AP28.2 AP45.1
invoice tax information. Must be a valid AP520 API1.1
record in the Tax Code file. API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-INCOME-CODE Alpha 4 AP180 AP181
Income Code The income code associated with the AP190 AP28.1
invoice. Used to track vendor income for AP28.2 AP45.1
the invoice. Must be a valid record in AP520 API1.1
the Income Code file. API2.1
API-DIST-CODE Alpha 9 AP180 AP181
Distribution Code The distribution code assigned to the AP190 AP28.1
invoice. Used during invoice entry to AP28.2 AP45.1
automatically create distributions for AP520
the invoice. Must be a valid record in
the Distribution Code file.
API-REC-STATUS Numeric 1 AP170 AP180
Record Status The status of the invoice record. Valid AP181 AP190
values are: AP28.1 AP28.2
AP30.4 AP45.1
0 = Unreleased. Not available for AP520 API1.1
payment. API2.1 EE135
1 = Released. Available for payment. EE35.1 EE35.2
9 = Historical. Paid and closed. EE520 MA310
MA63.1 MA65.1
MA68.1
API-CREATE-DATE Numeric 8 (yyyymmdd) AP170 AP180
Creation Date The date the invoice was created in the AP181 AP190
Lawson Accounts Payable system. AP193 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
API-DISTRIB-DATE Numeric 8 (yyyymmdd) AP170 AP180
Post Date The date used for posting invoice AP181 AP190
distributions to the general ledger. AP193 AP195
AP28.1 AP28.2
AP30.2 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA63.1
MA65.1 MA68.1
API-OPERATOR Alpha 10 AP180 AP181
Operator Code The operator associated with the AP190 AP28.1
invoice. AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
API-CREATION-TIME Numeric 6 (hhmmss) AP170 AP180
Creation Time The time the invoice was created in the AP181 AP190
Lawson Accounts Payable system. AP193 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
API-VENDOR-GROUP Alpha 4 AP180 AP181
Vendor Group The vendor group associated with the AP190 AP28.1
invoice. Must be a valid record in the AP28.2 AP45.1
Vendor Group file. AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-PAY-VENDOR Alpha 9 (Right Justified) AP115 AP180
Pay Vendor The pay vendor for the invoice. AP181 AP190
Represents the vendor that receives AP28.1 AP28.2
payment for the invoice. Must be a valid AP30.1 AP45.1
record in the Vendor file. AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
API-PAY-GROUP Alpha 4 AP101 AP180
Pay Group The pay group associated with the AP181 AP190
invoice. A pay group is used for AP28.1 AP28.2
processing accounts payable payments. AP30.1 AP45.1
Must be a valid record in the Pay Group AP520 API1.1
file. API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-INVOICE-GROUP Alpha 4 AP115 AP180
Invoice Group The invoice group assigned to the AP181 AP190
invoice. An invoice group is a AP28.1 AP28.2
user-defined character expression that AP45.1 AP520
can be used to select invoices for API1.1 API2.1
payment. The same invoice group can be EE135 EE35.1
assigned to more than one invoice. EE35.2 EE520
API-LAST-DIST-SEQ Numeric 4 AP170 AP180
Last Distribution Used by the system to track the number AP181 AP190
Sequence Nbr of the last distribution line created AP191 AP193
for the invoice. AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-LAST-PMT-SEQ Numeric 4 AP170 AP180
Last Payment Used by the system to track the last AP181 AP190
Sequence payment record number used for the AP193 AP28.1
invoice. AP28.2 AP30.3
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
API-DISCOUNT-CODE Alpha 10 AP180 AP181
Discount Code The discount code assigned to the AP190 AP28.1
invoice. Represents a general ledger AP28.2 AP45.1
discount account. Must be a valid record AP520 API1.1
in the Discount Code file. API2.1 MA310
MA63.1 MA65.1
MA68.1
API-INVOICE-SOURCE Alpha 1 AP180 AP181
Invoice Source Indicates the source for creation of AP190 AP28.1
the invoice. Valid values are: AP28.2 AP45.1
AP520 API1.1
Blank = Manual entry. API2.1
E = Electronic Data Interchange (EDI).
R = Evaluated Receipts Settlement (ERS).
P = Payroll
T = Tax
G = Garnishment
L = Lease
C = AR Transfer
S = Sub Contractor
API-INVC-REF-TYPE Alpha 2 AP180 AP181
Invoice Reference Indicates the type of number the vendor AP190 AP28.1
Type is providing to reference the invoice. AP28.2 AP45.1
Valid values are: AP520 API1.1
API2.1
BM = Bill of Lading.
IN = Invoice.
OW = Service Order.
PL = Packing List.
PO = Purchase Order Number.
VN = Vendor Order.
WO = Work Order.
WP = Warehouse Pick Ticket.
ZZ = Mutually Defined.
API-APPROVED-FLAG Alpha 1 AP170 AP180
Approved Indicates whether the invoice is AP181 AP190
approved for payment. Valid values are: AP28.1 AP28.2
AP32.1 AP36.1
Y = Yes. AP45.1 AP520
N = No. API1.1 API2.1
D = Disapproved EE135 EE35.1
M = Message Exists EE35.2 EE520
P = Message Pending Action MA66.2
API-APPRV-OPERATOR Alpha 10 AP180 AP181
Approval Operator If the invoice required approval, this AP190 AP28.1
field contains the operator that AP28.2 AP32.1
approved the invoice. AP36.1 AP45.1
API-RETURN-NUMBER Numeric 10 AP180 AP181
Return Number If the goods associated with the AP190 AP28.1
invoice were returned, this field AP28.2 AP45.1
contains the optional return number API1.1 API2.1
assigned to the return.
API-JRNL-BOOK-NBR Alpha 12 AP180 AP181
Journal Book The journal book assigned to the AP190 AP28.1
transaction. AP28.2 AP45.1
AP520 API1.1
EE135 EE35.1
EE35.2 EE520
API-TAX-POINT Alpha 1 AP180 AP181
Tax Point Indicates when the tax amount is AP190 AP28.1
calculated for the invoice, if AP28.2 AP30.2
applicable. Valid values are: AP32.2 AP45.1
AP520 API1.1
I = Invoice. API2.1
P = Payment.
API-OBJ-ID Numeric 12 AP170 AP180
Object ID A subsystem object interface AP181 AP190
identification number. Used to identify AP193 AP28.1
the Invoice Distribution and Asset AP28.2 AP32.1
Detail records that are associated with AP45.1 AP520
the invoice. Also used for Drill Around API1.1 API2.1
purposes. EE135 EE35.1
EE35.2 EE520
MA310 MA63.1
MA65.1 MA68.1
API-RECON-DATE Numeric 8 (yyyymmdd) AP180 AP181
Reconciliation or Represents the date the transaction AP190 AP260
Void Date cleared the bank or was voided. AP28.1 AP28.2
AP45.1 MA310
MA63.1 MA65.1
MA68.1
API-POD-PRINTED Numeric 1 AP130 AP180
Proof of Delivery Indicates is a proof of delivery has AP181 AP190
Printed been printed for this invoice. AP28.1 AP28.2
AP45.1 AP520
Valid values are: API1.1 API2.1
MA310 MA63.1
Y = Yes MA65.1 MA68.1
" " = No
API-MATCH-REF-NBR Alpha 22 AP180 AP181
Match Reference Matching reference number. This is a AP190 AP28.1
Number user defined number used for matching. AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA63.1 MA65.1
MA68.1
API-MATCH-FL Alpha 1 AP180 AP181
Match Invoice Flag Indicates if the invoice is a match AP190 AP28.1
invoice. AP28.2 AP45.1
A = AOC Invoice AP520 API1.1
Y = PO Invoice API2.1 EE135
N = Exp Invoice EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-TERMS-CD Alpha 5 AP180 AP181
Terms Code Invoice payment terms code. AP190 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA63.1 MA65.1
MA68.1
API-RCPT-INV-DATE Numeric 8 (yyyymmdd) AP180 AP181
Receipt of Invoice The date the invoice was received. If AP190 AP28.1
Date left blank, the system date defaults. AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-RETAIL-AMT Signed 15.2 AP180 AP181
Retail Amount The retail amount of the item. AP190 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA63.1 MA65.1
MA68.1
API-MATCH-STATUS Numeric 1 AP180 AP181
Match Status Indicates the match status of the AP190 AP28.1
invoice. AP28.2 AP45.1
AP520 API1.1
Valid values are: API2.1 MA310
MA63.1 MA65.1
0 = Unmatched MA68.1
1 = Out of tolerance
2 = Matched
3 = Matched out of tolerance
4 = Matched in tolerance
5 = Matched with auto chargeback
6 = Approved No Receipt (MA61)
API-REASON-CODE Alpha 4 AP180 AP181
Reason Code This field contains the reason code, AP190 AP28.1
which indicates the cause for credit AP28.2 AP45.1
memos. AP520 API1.1
API2.1 MA310
MA63.1 MA65.1
MA68.1
API-HANDLING-CODE Alpha 4 AP180 AP181
Invoice Handling Invoice handling code. The invoice AP190 AP28.1
Code handling code contains processing rules AP28.2 AP45.1
for invoice matching. AP520 API1.1
API2.1 MA310
MA63.1 MA65.1
MA68.1
API-MATCH-AMT Signed 15.2 AP180 AP181
Match Amount Match amount. Represents the goods AP190 AP28.1
amount on which the invoice will match AP28.2 AP30.2
to a receipt. AP45.1 AP520
API1.1 MA310
MA63.1 MA65.1
MA68.1
API-AOC-ALLOW-AMT Signed 15.2 AP180 AP181
Add On Cost Amount Add on cost amount. AP190 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA63.1 MA65.1
MA68.1
API-LOCATION Alpha 5 AP180 AP181
Location Code This field contains a valid stocking AP190 AP28.1
location within the company inventory. AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA63.1 MA65.1
MA68.1
API-MATCH-OBJ-ID Numeric 12 AP180 AP181
Match Object ID A system generated matching object AP190 AP28.1
identifier. AP28.2 AP45.1
AP520 MA310
MA63.1 MA65.1
MA68.1
API-CBPRINT-FL Alpha 1 AP180 AP181
Print Chargebacks Indicates whether to print chargebacks. AP190 AP28.1
N = No AP28.2 AP30.1
Y = Yes AP45.1 AP520
" " = spaces API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
API-MATCH-TABLE Alpha 10 AP180 AP181
Match Table Match table. Contains matching and AP190 AP28.1
match processing rules. AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA63.1 MA65.1
MA68.1
API-TAX-CODE-CNTL Alpha 1 AP180 AP181
Tax Code Control This control field defines the tax code AP190 AP28.1
usage in invoicing and approving taxes. AP28.2 AP45.1
API1.1 API2.1
For PO Invoices, if set to O (Override) MA310 MA63.1
all lines approved for payment will use MA65.1 MA68.1
the tax code defined for the whole
invoice.
If set to I (Ignore) no PO lines
approved for payment will be taxed.
0 = No Tax
1 = Override Product Only
2 = Ignore Product Only
3 = Calculate
4 = Overide Product and AOC
5 = Ignore Product and AOC
API-LAST-MATCH-LN Numeric 4 AP180 AP181
Last Match Line Last matched line number. AP190 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA63.1 MA65.1
MA68.1
API-MATCH-LEVEL Alpha 3 AP180 AP181
Match Level Indicates whether the invoice was AP190 AP28.1
matched at the invoice or detail level. AP28.2 AP45.1
API-MATCH-DATE Numeric 8 (yyyymmdd) AP180 AP181
Match Date The date the invoice was matched. AP190 AP28.1
AP28.2 AP45.1
API-PO-INV-TAX Signed 15.2 AP180 AP181
Invoiced Tax The amount of invoiced tax that will be AP190 AP28.1
generated on the invoice from taxable AP28.2 AP45.1
add on costs and taxable purchase order MA310 MA63.1
receipt lines assigned to the invoice. MA65.1 MA68.1
The resulting value is then used to
compute the invoice match amount when no
tax code has been assigned to the
invoice.
API-BYPASS-MATCH Alpha 1 AP180 AP181
Bypass Match AP190 AP28.1
AP28.2 AP45.1
API1.1 API2.1
MA310 MA63.1
MA65.1 MA68.1
API-SERVICE-FL Alpha 1 AP180 AP181
Service Fl This field indicates a transaction is a AP190 AP28.1
Service only transaction. AP28.2 AP45.1
Y = Yes API1.1 API2.1
N = No MA310 MA63.1
MA65.1 MA68.1
API-SERVICE-AMT Signed 15.2 AP180 AP181
Service Amt AP190 AP28.1
AP28.2 AP45.1
API1.1 API2.1
MA310 MA63.1
MA65.1 MA68.1
API-BUYER Alpha 3
Buyer
API-FINAL-DST-FLAG Alpha 1 AP30.2
Final Dst Flag
API-NOTC Alpha 2 AP180 AP181
Notc The Nature of Transaction code. Must AP190 AP28.1
be a valid code defined in IN07.1 (NOTC AP28.2 AP45.1
Maintenance). API1.1
API-STAT-PROC Alpha 6 AP180 AP181
Stat Proc The statistical procedure code applied AP190 AP28.1
to the data. The code must be defined AP28.2 AP45.1
in IN06.1. (Statistical Procedure API1.1
Maintenance).
API-SHIP-VIA Alpha 12 (Lower Case) AP180 AP181
Ship Via Description AP190 AP28.1
AP28.2 AP45.1
API1.1
API-UNLOADING-PORT Alpha 5 AP180 AP181
Unloading Port The prot where the goods are unloaded if AP190 AP28.1
required. Must be defined in IN04.1 AP28.2 AP45.1
(Port Maintenance) API1.1
API-INTRASTAT-NBR Numeric 12 AP180 AP181
Intrastat Nbr The number assigned by the Intrastat AP190 AP28.1
system to a transaction that involves AP28.2 AP45.1
Intrastat reporting after it has been API1.1
added.
API-DROPSHIP-FL Alpha 1 AP180 AP181
Dropship Flag This flag indicates whether goods being AP190 AP28.1
shipped by the vendor directly to a non AP28.2 AP45.1
standard location need to have the API1.1
receiving process performed.
API-FOB-CODE Alpha 3 AP180 AP181
Shipping Term Code The user defined Free On Board Code. AP190 AP28.1
AP28.2 AP45.1
API1.1
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-JBK-SEQ-NBR Numeric 10 AP170 AP180
Journal Book The journal book sequence number AP181 AP190
Sequence Number assigned to a journal book transaction AP193 AP28.1
when it is added or interfaced to the AP28.2 AP45.1
Lawson system. Used only when Auto AP520 API1.1
Journal Book Seq Nbr is set to Yes in EE135 EE35.1
GL10.1 (Company). EE35.2 EE520
APINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APISET1 COMPANY This index is used to access invoice AP00.4 AP00.5
VENDOR records for a specific vendor and AP01.1 AP101
INVOICE company. AP115 AP141
SUFFIX AP150 AP151
CANCEL-SEQ AP155 AP156
AP160 AP161
AP170 AP175
AP176 AP180
AP181 AP190
AP191 AP193
AP197 AP198
AP212 AP213
AP220 AP230
AP240 AP245
AP250 AP252
...
APISET10 COMPANY This index is used by AP260 (Invoice AP260
RECON-DATE Accrual Reconciliation) to quickly
VENDOR access invoice records that have not
INVOICE been reconciled by a previous AP260 run.
SUFFIX KeyChange
CANCEL-SEQ
APISET11 COMPANY KeyChange, Subset MA310 MA63.1
VENDOR Where MATCH-REF-NBR != Spaces MA65.1 MA68.1
MATCH-REF-NBR
OBJ-ID
APISET12 COMPANY This index is used to access and
CBPRINT-FL inquire on invoices released but not
VENDOR approved.
INVOICE-DTE KeyChange, Subset
INVOICE Where INVOICE-TYPE = "C"
SUFFIX
CANCEL-SEQ
APISET13 COMPANY KeyChange API1.1 MA310
VENDOR MA63.1 MA65.1
MATCH-OBJ-ID MA68.1
INVOICE
SUFFIX
CANCEL-SEQ
APISET14 COMPANY KeyChange, Subset AP130 MA126
VENDOR Where((MATCH-STATUS = Zeroes ) MA310 MA63.1
DUE-DATE Or (MATCH-STATUS = 1 )) MA65.1 MA68.1
INVOICE And (MATCH-FL = "Y" )
SUFFIX And ((REC-STATUS = Zeroes )
CANCEL-SEQ Or (REC-STATUS = 1 ))
APISET2 COMPANY This index is used to access unreleased AP00.4 AP195
BATCH-NUM invoice records for a specific batch or AP220
AUTH-CODE authority code.
VOUCHER-NBR KeyChange, Subset
VENDOR Where REC-STATUS = Zeroes
INVOICE
SUFFIX
CANCEL-SEQ
APISET3 REC-STATUS This index is used to access unreleased AP193 AP198
COMPANY invoice records for a specific batch or AP236 AP300
BATCH-NUM authority code in entry order. AP36.1
AUTH-CODE KeyChange
OPERATOR
CREATE-DATE
CREATION-TIME
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
APISET4 COMPANY This index is used to access invoice AP00.4 AP30.1
VOUCHER-NBR records for a specific voucher number. AP520 AP90.3
REC-STATUS KeyChange API1.1 API2.1
VENDOR AR48.3
INVOICE
SUFFIX
CANCEL-SEQ
APISET5 VENDOR-GROUP This index is used to access invoice AP10.1 AP115
VENDOR records not on hold for a specific hold AP251 AP91.1
INVOICE code. AP92.1 API3.1
SUFFIX KeyChange API4.1
CANCEL-SEQ
COMPANY
APISET6 COMPANY This index is used to access invoice AP251 AP300
VENDOR records for a specific vendor in invoice AP90.2
INVOICE-DTE date sequence.
INVOICE KeyChange
SUFFIX
CANCEL-SEQ
APISET7 COMPANY This index is used to access invoice AP240
REC-STATUS records that are out of balance.
BATCH-NUM KeyChange, Subset
VENDOR Where TRAN-TOT-DIST != TRAN-INV-AMT
INVOICE Or TRAN-TOT-PMT != TRAN-INV-AMT
SUFFIX Or BASE-TOT-PMT != BASE-INV-AMT
CANCEL-SEQ Or TRAN-TOT-TAX != TRAN-TAX-AMT
APISET8 COMPANY This index is used to access invoices AP252 MA126
DUE-DATE for a specific vendor in descending MA310 MA63.1
VENDOR invoice date sequence. MA65.1 MA68.1
INVOICE KeyChange, Subset
SUFFIX Where((MATCH-STATUS = Zeroes )
CANCEL-SEQ Or (MATCH-STATUS = 1 ))
And (MATCH-FL = "Y" )
And ((REC-STATUS = Zeroes )
Or (REC-STATUS = 1 ))
APISET9 COMPANY This index is used to access invoice AP141 AP90.4
VENDOR records for a specific purchase order. MA126 MA310
PO-NUMBER KeyChange MA63.1 MA65.1
PO-RELEASE MA68.1
PO-CODE
LOCATION
INVOICE
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
Appayvenaddr APVENADDR Not Required
CPY-VENDOR-GROUP -> VDR-VENDOR-GROUP
API-PAY-VENDOR -> VDR-VENDOR
Spaces -> VDR-LOCATION-CODE
"Y" -> VDR-CUR-ADDR
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
Apuaval APUAVAL Not Required
"I" -> UAV-SEG-TYPE
API-OBJ-ID -> UAV-API-OBJ-ID
Zeroes -> UAV-DIST-SEQ-NBR
Apvenlocaddr APVENADDR Not Required
CPY-VENDOR-GROUP -> VDR-VENDOR-GROUP
API-PAY-VENDOR -> VDR-VENDOR
API-REMIT-TO-CODE -> VDR-LOCATION-CODE
"Y" -> VDR-CUR-ADDR
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
Invusrfld APINUSRFLD Not Required
API-OBJ-ID -> ISR-OBJ-ID
Macompany MACOMPANY Not Required
API-COMPANY -> MAY-COMPANY
Mapool3 MAPOOLCNT Not Required
Valid When (API-POOL-OPTION = 3 )
Or ((API-POOL-OPTION = Zeroes )
And (API-POOL-OPTION = 3 ))
API-COMPANY -> MAC-COMPANY
API-VENDOR -> MAC-VENDOR
API-PO-NUMBER -> MAC-PO-NUMBER
API-PO-RELEASE -> MAC-PO-RELEASE
API-PO-CODE -> MAC-PO-CODE
API-LOCATION -> MAC-LOCATION
Pocompany POCOMPANY Not Required
API-COMPANY -> PCY-COMPANY
Poreceive PORECEIVE Not Required
API-COMPANY -> POR-COMPANY
API-VENDOR -> POR-VENDOR
API-INVOICE -> POR-INVOICE
Poreturnhd PORETURNHD Not Required
API-COMPANY -> PTH-COMPANY
API-RETURN-NUMBER -> PTH-RETURN-NUMBER
Povagrmthd POVAGRMTHD Not Required
Valid When (API- = API-)
PCY-PROCURE-GROUP -> PVH-PROCURE-GROUP
API-VENDOR -> PVH-VENDOR
API-PO-NUMBER -> PVH-PO-NUMBER
Purchorder PURCHORDER Not Required
API-COMPANY -> PCR-COMPANY
API-PO-CODE -> PCR-PO-CODE
API-PO-NUMBER -> PCR-PO-NUMBER
API-PO-RELEASE -> PCR-PO-RELEASE
Reasoncd MAREASONCD Not Required
API-REASON-CODE -> MAR-REASON-CODE
Taxcode TXTAXCODE Not Required
API-COMPANY -> TAC-COMPANY
API-TAX-CODE -> TAC-TAX-CODE
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
Apdiscacc APDISCACC
API-COMPANY -> DSK-COMPANY
API-VENDOR -> DSK-VENDOR
API-INVOICE -> DSK-INVOICE
API-SUFFIX -> DSK-SUFFIX
API-CANCEL-SEQ -> DSK-CANCEL-SEQ
DSK-SEQ-NBR
DSK-VOID-SEQ
DSK-DISC-TYPE
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
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-SEQ-NBR
Mainvdtl MAINVDTL
API-COMPANY -> MAD-COMPANY
API-VENDOR -> MAD-VENDOR
API-INVOICE -> MAD-INVOICE
API-SUFFIX -> MAD-SUFFIX
API-PO-NUMBER -> MAD-PO-NUMBER
API-PO-RELEASE -> MAD-PO-RELEASE
API-PO-CODE -> MAD-PO-CODE
MAD-LINE-NBR
MAD-AOC-CODE
MAD-SEQ-NBR
Mainvdtl 2 MAINVDTL
API-COMPANY -> MAD-COMPANY
API-VENDOR -> MAD-VENDOR
API-INVOICE -> MAD-INVOICE
API-SUFFIX -> MAD-SUFFIX
MAD-PO-NUMBER
MAD-PO-RELEASE
MAD-PO-CODE
MAD-LINE-NBR
MAD-AOC-CODE
MAD-SEQ-NBR
Mainvmsg MAINVMSG
API-COMPANY -> MAG-COMPANY
API-VENDOR -> MAG-VENDOR
API-INVOICE -> MAG-INVOICE
API-SUFFIX -> MAG-SUFFIX
API-CANCEL-SEQ -> MAG-CANCEL-SEQ
MAG-MAD-SEQ-NBR
MAG-SEQ-NBR
Mapoinv MAPOINV Delete Restricted
API-COMPANY -> AOI-COMPANY
API-VENDOR -> AOI-VENDOR
API-INVOICE -> AOI-INVOICE
API-SUFFIX -> AOI-SUFFIX
AOI-PO-NUMBER
AOI-PO-RELEASE
AOI-PO-CODE
Mapool1 MAPOOLCNT
Valid When API-POOL-OPTION = 1
Or (API-POOL-OPTION = Zeroes
And API-POOL-OPTION = 1 )
API-COMPANY -> MAC-COMPANY
API-VENDOR -> MAC-VENDOR
MAC-PO-NUMBER
MAC-PO-RELEASE
MAC-PO-CODE
MAC-LOCATION
Mapool2 MAPOOLCNT
Valid When (API-POOL-OPTION = 2 )
Or ((API-POOL-OPTION = Zeroes )
And (API-POOL-OPTION = 2 ))
API-COMPANY -> MAC-COMPANY
API-VENDOR -> MAC-VENDOR
API-PO-NUMBER -> MAC-PO-NUMBER
API-PO-RELEASE -> MAC-PO-RELEASE
API-PO-CODE -> MAC-PO-CODE
MAC-LOCATION
Match Trans APINVOICE
API-COMPANY -> API-COMPANY
API-VENDOR -> API-VENDOR
API-MATCH-OBJ-ID -> API-MATCH-OBJ-ID
API-INVOICE
API-SUFFIX
API-CANCEL-SEQ
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
Por Match Ref PORECEIVE
API-COMPANY -> POR-COMPANY
API-VENDOR -> POR-VENDOR
API-MATCH-REF-NBR -> POR-MATCH-REF-NBR
POR-REC-NUMBER
Porecline PORECLINE
API-COMPANY -> PRL-COMPANY
API-MATCH-OBJ-ID -> PRL-MATCH-OBJ-ID
PRL-MATCH-SEQ-NBR
PRL-REC-NUMBER
PRL-LINE-NBR
Poreset9 Ven PORECEIVE
API-COMPANY -> POR-COMPANY
API-VENDOR -> POR-VENDOR
API-PO-CODE -> POR-PO-CODE
API-PO-NUMBER -> POR-PO-NUMBER
API-PO-RELEASE -> POR-PO-RELEASE
POR-LOCATION
POR-REC-NUMBER
Porset3 PORECEIVE
API-AOC-ALLOW-AMT -> POR-COMPANY
API-PO-CODE -> POR-PO-CODE
API-PO-NUMBER -> POR-PO-NUMBER
API-PO-RELEASE -> POR-PO-RELEASE
POR-PO-LOCATION
POR-REC-NUMBER
Porset9 PORECEIVE
API-COMPANY -> POR-COMPANY
API-VENDOR -> POR-VENDOR
API-PO-CODE -> POR-PO-CODE
API-PO-NUMBER -> POR-PO-NUMBER
API-PO-RELEASE -> POR-PO-RELEASE
POR-LOCATION
POR-REC-NUMBER
Porset9 Ven PORECEIVE
API-COMPANY -> POR-COMPANY
API-VENDOR -> POR-VENDOR
POR-PO-CODE
POR-PO-NUMBER
POR-PO-RELEASE
POR-LOCATION
POR-REC-NUMBER
|