APINVOICE – Accounts Payable Invoice

System
Accounts Payable (AP)
Prefix
API
Primary key
COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ
Fields
187
Updated by
290 programs
Referenced by
127 programs

APINVOICE is the Accounts Payable Invoice table in Lawson Accounts Payable (prefix API). It is indexed by COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ (APISET1); alternate indexes: APISET10, APISET11, APISET13, APISET14, APISET15, APISET2, APISET3, APISET4 and 5 more. It is related 1:1 to APAUTHOR, APBATCH, APCOMPANY, APINCCODE, APINVBOD, APVENADDR, APVENMAST, APPROCLEV and 19 more and 1:M to APAUDIT, APCRMEMO, APDISCACC, APDISTCODE, APDISTPAY, APDISTRIB, APPAYMENT, APCOMMENTS and 12 more. It is updated by AP10.2, AP101, AP115, AP125, AP126, AP130, AP131, AP133 and 282 more and referenced by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 119 more. The table has 187 fields, 14 indexes and 59 documented relations.

About APINVOICE

The Accounts Payable Invoice file contains accounts payable invoice records. Each record has one or more associated records in the Invoice Payment File.

Fields (187)

Column = COBOL field name without the API- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
API-COMPANY PK
COMPANY		Numeric 4The company associated with the invoice. Must be a valid record in the Accounts Payable Company file.AP125, AP126, AP150, AP180, AP181, AP190, AP20.1, AP20.2 +52 more (list truncated in source)
API-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The invoiced vendor number. Must be a valid record in the Vendor file.AP115, AP125, AP126, AP150, AP180, AP181, AP190, AP20.1 +52 more (list truncated in source)
API-INVOICE PK
INVOICE		Alpha 22The invoice number. Must be a unique invoice number for the vendor.AP115, AP125, AP126, AP150, AP180, AP181, AP190, AP20.1 +52 more (list truncated in source)
API-SUFFIX PK
SUFFIX		Numeric 3The invoice suffix number. Represents the occurrence value of the invoice. Used to identify the recurrence value of a recurring invoice and for system-generated credit memos created for prepayments and employee advances.AP125, AP126, AP150, AP170, AP180, AP181, AP190, AP193 +34 more
API-CANCEL-SEQ PK
CANCEL_SEQ		Numeric 4The sequence number assigned upon the cancellation of a distributed invoice. The first sequence assigned is 9999.AP125, AP126, AP150, AP180, AP181, AP190, AP20.8, AP25.1 +31 more
API-CANCEL-DATE
CANCEL_DATE		Numeric 8 (yyyymmdd)The cancellation date assigned to a canceled invoice.AP180, AP181, AP190, AP26.1, AP27.1, AP28.1, AP28.2, AP30.4 +3 more
API-BATCH-NUM
BATCH_NUM		Numeric 6The batch number associated with the invoice. Used only if the company has Yes selected in the Batch Release Option field.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +44 more
API-BATCH-DATE
BATCH_DATE		Numeric 8 (yyyymmdd)The batch date assigned to the batch number. Must be a valid record in the Batch file.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +21 more
API-VOUCHER-NBR
VOUCHER_NBR		Alpha 10The voucher number assigned to the invoice. Used only if the company has Yes selected in the Invoice Registration Option field.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +44 more
API-AUTH-CODE
AUTH_CODE		Alpha 3The authority code assigned to the invoice. Represents the person or department responsible for approving a registered invoice and is required before a registered invoice can be released. Used only by a company that 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.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +48 more
API-PROC-LEVEL
PROC_LEVEL		Alpha 5The process level assigned to the invoice. Must be a valid record in the Accounts Payable Process Level file.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +52 more (list truncated in source)
API-ACCR-CODE
ACCR_CODE		Alpha 4The invoice accrual code assigned to the invoice. Used to default a general ledger accrual account to the invoice. Must be a valid record in the Invoice Accrual Code file.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +49 more
API-INVOICE-TYPE
INVOICE_TYPE		Alpha 1Identifies the type of invoice. Valid values are: owed to the vendor. If the invoice is fully processed, the vendor's purchase and payment balances will be increased. owed to the vendor. If the invoice is fully processed, the vendor's purchase and payment balances will be decreased. invoice. Increase the vendor's purchase and payment balances. invoice. Used to pay a vendor for goods or services not yet received. AP170 (Payment Closing) to offset a prepayment and are applied to the vendor's invoice after it has been received. like an invoice. Used to pay an employee for expenses not yet incurred. Created by Payment Closing (AP170) to offset an employee advance. Can be applied to the employee's expense after it has been received. like an invoice.
  • Blank Invoice. Increases the amount
  • C Credit Memo. Reduces the amount
  • D Debit Memo. Processed just like an
  • P Prepayment. Processed just like an
  • Y Prepayment Credit Memo. Created by
  • A Employee Advance. Processed just
  • M Employee Advance Credit Memo.
  • E Employee Expense. Processed just
  • R Match Prepayment
AP125, AP126, AP170, AP180, AP181, AP190, AP20.1, AP20.2 +48 more
API-INV-CURRENCY
INV_CURRENCY		Alpha 5The currency of the invoice. Must be a valid record in the Currency Code file. If left blank, the vendor currency defaults.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +49 more
API-PAY-CURRENCY
PAY_CURRENCY		Alpha 5The currency used to pay the invoice. Must be a valid record in the Currency Code file.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +47 more
API-INVOICE-DTE
INVOICE_DTE		Numeric 8 (yyyymmdd)The date assigned to the invoice. Used when updating the vendor's purchase balance. If left blank, the system date defaults.AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +50 more
API-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4The purchase-from location code associated with the invoice. Must be a valid record in the Vendor Location file.AP115, AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2 +44 more
API-PO-NUMBER
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +50 more
API-PO-RELEASE
PO_RELEASE		Numeric 4The purchase order release number associated with the invoice. Used to identify a purchase order release created from a blanket or standing order.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +50 more
API-PO-CODE
PO_CODE		Alpha 4Purchase order number code. Used to keep purchase orders unique. Can be used for reporting purposes.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +50 more
API-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The invoice description.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +23 more
API-BASE-INV-AMT
BASE_INV_AMT		Signed 18.2The amount of the invoice in the company base currency. This amount is calculated based on the currency exchange rate in effect when the invoice was created or entered.AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more (list truncated in source)
API-BASE-ACT-AMT
BASE_ACT_AMT		Signed 18.2The amount of the invoice in the company base currency. For non-base currency invoices, this amount is updated when currency revaluation takes place.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP193 +52 more (list truncated in source)
API-BASE-ND
BASE_ND		Numeric 1The number of decimal places defined for the company base currency.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +47 more
API-TRAN-INV-AMT
TRAN_INV_AMT		Signed 18.2The amount of the invoice in the currency of the invoice.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +52 more (list truncated in source)
API-TRAN-ALOW-AMT
TRAN_ALOW_AMT		Signed 18.2The amount of the invoice available for discount in the currency of the invoice. Used to calculate the discount amount based on the discount rate. If left blank, the invoice amount defaults.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +48 more
API-TRAN-TXBL-AMT
TRAN_TXBL_AMT		Signed 18.2The taxable amount of the invoice in the currency of the invoice.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +52 more (list truncated in source)
API-TRAN-ND
TRAN_ND		Numeric 1The number of decimal places defined for the invoice currency.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +47 more
API-TRAN-TAX-AMT
TRAN_TAX_AMT		Signed 18.2The tax amount of the invoice in the currency of the invoice.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +52 more (list truncated in source)
API-BASE-DISC-AMT
BASE_DISC_AMT		Signed 18.2The discount amount of the invoice in the company base currency.AP125, AP126, AP150, AP170, AP180, AP181, AP190, AP191 +49 more
API-TRAN-DISC-AMT
TRAN_DISC_AMT		Signed 18.2The discount amount of the invoice in the currency of the invoice.AP125, AP126, AP150, AP170, AP180, AP181, AP190, AP20.1 +52 more
API-BASE-TOT-PMT
BASE_TOT_PMT		Signed 18.2The total payment amount created for the invoice in the company base currency.AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more (list truncated in source)
API-TRAN-TOT-PMT
TRAN_TOT_PMT		Signed 18.2The total payment amount created for the invoice in the currency of the invoice.AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more (list truncated in source)
API-BASE-TOT-DIST
BASE_TOT_DIST		Signed 18.2The total distribution amount of the invoice in the company base currency.AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more (list truncated in source)
API-TRAN-TOT-DIST
TRAN_TOT_DIST		Signed 18.2The total distribution amount of the invoice in the currency of the invoice.AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more (list truncated in source)
API-TRAN-TOT-TAX
TRAN_TOT_TAX		Signed 18.2The total tax amount of the invoice in the currency of the invoice.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +52 more (list truncated in source)
API-TRAN-TOT-TXBL
TRAN_TOT_TXBL		Signed 18.2—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +11 more
API-TRAN-PAID-AMT
TRAN_PAID_AMT		Signed 18.2The total amount of the invoice paid to date in the currency of the invoice.AP170, AP180, AP181, AP190, AP193, AP28.1, AP28.2, AP45.1 +9 more
API-ORIG-CNV-RATE
ORIG_CNV_RATE		Signed 14.7The currency exchange rate used to convert the invoice amount to the company base currency. This field may be updated if the invoice is revalued to account for exchange rate fluctuations.AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +51 more
API-ANTICIPATION
ANTICIPATION		Alpha 1Indicates whether anticipation criteria will be used to calculate the discount amount of the invoice. Valid values are:
  • N No.
  • Y Yes.
AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more
API-DISCOUNT-RT
DISCOUNT_RT		Percent 5.3 (Percent)The discount rate used to calculate the discount amount of the invoice.AP125, AP126, AP150, AP180, AP181, AP190, AP20.1, AP20.2 +45 more
API-DISC-DATE
DISC_DATE		Numeric 8 (yyyymmdd)The discount date of the invoice. Used to determine whether a discount will be taken on an invoice.AP125, AP126, AP150, AP170, AP180, AP181, AP190, AP193 +52 more (list truncated in source)
API-DUE-DATE
DUE_DATE		Numeric 8 (yyyymmdd)The invoice due date. Used to schedule the invoice for payment.AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more (list truncated in source)
API-NBR-SPLIT-PMT
NBR_SPLIT_PMT		Numeric 3Used for split payment invoices to indicate the total number of payments to be made for the invoice.AP180, AP181, AP190, AP20.8, AP28.1, AP28.2, AP30.3, AP45.1
API-SPLIT-PMT-SCH
SPLIT_PMT_SCH		Alpha 1Used for split payment invoices to 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.
AP180, AP181, AP190, AP20.8, AP28.1, AP28.2, AP30.3, AP45.1
API-NBR-RECUR-PMT
NBR_RECUR_PMT		Numeric 3Used for recurring invoices to indicate the number of times the invoice will recur.AP180, AP181, AP190, AP193, AP20.1, AP20.2, AP20.3, AP20.4 +19 more
API-RECUR-FREQ
RECUR_FREQ		Alpha 1Used for recurring invoices to indicate how often the invoice should recur. Valid values are:
  • W Weekly.
  • M Monthly.
  • Q Quarterly.
  • S Semiannually.
  • Y Yearly.
  • Blank Not a recurring invoice.
  • E End of Month
AP180, AP181, AP190, AP193, AP20.1, AP20.2, AP20.3, AP20.4 +19 more
API-REMIT-TO-CODE
REMIT_TO_CODE		Alpha 4The remit-to location code associated with the invoice. Must be a valid record in the Vendor Location file.AP115, AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2 +49 more
API-CASH-CODE
CASH_CODE		Alpha 4The cash code assigned to the invoice. Represents the bank account the invoice is to be paid from. Must be a valid record in the Cash Code file.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +23 more
API-BANK-INST-CODE
BANK_INST_CODE		Alpha 3The payment code assigned to the invoice. Represents the type of cash payment or bill of exchange payment used to pay the invoice. Must be a valid cash payment transaction code record in the Bank Transaction Code file.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +23 more
API-CURR-RECALC
CURR_RECALC		Alpha 1Used for non-base currency invoices to indicate whether the invoice will be revalued when it is scheduled for payment to account for currency exchange rate fluctuations. Valid values are:
  • N No.
  • Y Yes.
AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +23 more
API-TAX-CODE
TAX_CODE		Alpha 10The tax code or tax table code applied to the invoice. Used to calculate invoice tax information. Must be a valid record in the Tax Code file.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +47 more
API-INCOME-CODE
INCOME_CODE		Alpha 4The income code associated with the invoice. Used to track vendor income for the invoice. Must be a valid record in the Income Code file.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +18 more
API-DIST-CODE
DIST_CODE		Alpha 9The distribution code assigned to the invoice. Used during invoice entry to automatically create distributions for the invoice. Must be a valid record in the Distribution Code file.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +15 more
API-REC-STATUS
REC_STATUS		Numeric 1The status of the invoice record. Valid values are: payment.
  • 0 Unreleased. Not available for
  • 1 Released. Available for payment.
  • 9 Historical. Paid and closed.
AP125, AP126, AP170, AP180, AP181, AP190, AP20.1, AP20.2 +52 more (list truncated in source)
API-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)The date the invoice was created in the Lawson Accounts Payable system.AP170, AP180, AP181, AP190, AP193, AP20.1, AP20.2, AP20.3 +26 more
API-DISTRIB-DATE
DISTRIB_DATE		Numeric 8 (yyyymmdd)The date used for posting invoice distributions to the general ledger.AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP195 +52 more (list truncated in source)
API-OPERATOR
OPERATOR		Alpha 10The operator associated with the invoice.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +47 more
API-CREATION-TIME
CREATION_TIME		Numeric 6 (hhmmss)The time the invoice was created in the Lawson Accounts Payable system.AP170, AP180, AP181, AP190, AP193, AP20.1, AP20.2, AP20.3 +26 more
API-VENDOR-GROUP
VENDOR_GROUP		Alpha 4The vendor group associated with the invoice. Must be a valid record in the Vendor Group file.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +47 more
API-PAY-VENDOR
PAY_VENDOR		Alpha 9 (Right Justified)The pay vendor for the invoice. Represents the vendor that receives payment for the invoice. Must be a valid record in the Vendor file.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +24 more
API-PAY-GROUP
PAY_GROUP		Alpha 4The pay group associated with the invoice. A pay group is used for processing accounts payable payments. Must be a valid record in the Pay Group file.AP101, AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2 +49 more
API-INVOICE-GROUP
INVOICE_GROUP		Alpha 4The invoice group assigned to the invoice. An invoice group is a user-defined character expression that can be used to select invoices for payment. The same invoice group can be assigned to more than one invoice.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +23 more
API-LAST-DIST-SEQ
LAST_DIST_SEQ		Numeric 6Used by the system to track the number of the last distribution line created for the invoice.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP193 +52 more (list truncated in source)
API-LAST-PMT-SEQ
LAST_PMT_SEQ		Numeric 4Used by the system to track the last payment record number used for the invoice.AP133, AP170, AP180, AP181, AP190, AP193, AP20.1, AP20.2 +33 more
API-DISCOUNT-CODE
DISCOUNT_CODE		Alpha 10The discount code assigned to the invoice. Represents a general ledger discount account. Must be a valid record in the Discount Code file.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +43 more
API-INVOICE-SOURCE
INVOICE_SOURCE		Alpha 1Indicates the source for creation of the invoice. Valid values are:
  • Blank Manual entry.
  • E Electronic Data Interchange (EDI).
  • R Evaluated Receipts Settlement (ERS).
  • P Payroll
  • T Tax
  • G Garnishment
  • L Lease
  • C AR Transfer
  • S Sub Contractor
  • X Expense Interface
  • A AP Automation
AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +17 more
API-INVC-REF-TYPE
INVC_REF_TYPE		Alpha 2Indicates the type of number the vendor is providing to reference the invoice. Valid values are:
  • BM Bill of Lading.
  • IN Invoice.
  • OW Service Order.
  • PL Packing List.
  • PO Purchase Order Number.
  • VN Vendor Order.
  • WO Production Order.
  • WP Warehouse Pick Ticket.
  • ZZ Mutually Defined.
AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +17 more
API-APPROVED-FLAG
APPROVED_FLAG		Alpha 1Indicates whether the invoice is approved for payment. Valid values are:
  • Y Yes.
  • N No.
  • D Disapproved
  • M Message Exists
  • P Message Pending Action
  • R Match Prepayment
AP125, AP126, AP170, AP180, AP181, AP190, AP20.1, AP20.2 +41 more
API-APPRV-OPERATOR
APPRV_OPERATOR		Alpha 10If the invoice required approval, this field contains the operator that approved the invoice.AP180, AP181, AP190, AP28.1, AP28.2, AP32.1, AP36.1, AP45.1 +4 more
API-RETURN-NUMBER
RETURN_NUMBER		Numeric 10If the goods associated with the invoice were returned, this field contains the optional return number assigned to the return.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +16 more
API-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12The journal book assigned to the transaction.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +21 more
API-TAX-POINT
TAX_POINT		Alpha 1Indicates when the tax amount is calculated for the invoice, if applicable. Valid values are:
  • I Invoice.
  • P Payment.
  • G GL Post Date
AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +19 more
API-OBJ-ID
OBJ_ID		Numeric 12A subsystem object interface identification number. Used to identify the Invoice Distribution and Asset Detail records that are associated with the invoice. Also used for Drill Around purposes.AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +50 more
API-RECON-DATE
RECON_DATE		Numeric 8 (yyyymmdd)Represents the date the transaction cleared the bank or was voided.AP125, AP126, AP136, AP180, AP181, AP190, AP232, AP25.1 +26 more
API-POD-PRINTED
POD_PRINTED		Numeric 1Indicates is a proof of delivery has been printed for this invoice. Valid values are: " " = No
  • Y Yes
AP125, AP126, AP130, AP180, AP181, AP190, AP20.1, AP20.2 +43 more
API-MATCH-REF-NBR
MATCH_REF_NBR		Alpha 22Matching reference number. This is a user defined number used for matching.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +47 more
API-MATCH-FL
MATCH_FL		Alpha 1Indicates if the invoice is a match invoice.
  • A AOC Invoice
  • Y PO Invoice
  • N Exp Invoice
AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +52 more
API-TERMS-CD
TERMS_CD		Alpha 5Invoice payment terms code.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +43 more
API-RCPT-INV-DATE
RCPT_INV_DATE		Numeric 8 (yyyymmdd)The date the invoice was received. If left blank, the system date defaults.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +46 more
API-RETAIL-AMT
RETAIL_AMT		Signed 18.2The retail amount of the item.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +48 more
API-MATCH-STATUS
MATCH_STATUS		Numeric 1Indicates the match status of the invoice. Valid values are:
  • 0 Unmatched
  • 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)
AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +51 more
API-REASON-CODE
REASON_CODE		Alpha 4This field contains the reason code, which indicates the cause for credit memos.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +49 more
API-HANDLING-CODE
HANDLING_CODE		Alpha 4Invoice handling code. The invoice handling code contains processing rules for invoice matching.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +42 more
API-MATCH-AMT
MATCH_AMT		Signed 18.2Match amount. Represents the goods amount on which the invoice will match to a receipt.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +47 more
API-AOC-ALLOW-AMT
AOC_ALLOW_AMT		Signed 18.2Add on cost amount.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +48 more
API-LOCATION
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +42 more
API-MATCH-OBJ-ID
MATCH_OBJ_ID		Numeric 12A system generated matching object identifier.AP125, AP126, AP180, AP181, AP190, AP25.1, AP25.2, AP26.1 +28 more
API-CBPRINT-FL
CBPRINT_FL		Alpha 1Indicates whether to print chargebacks. " " = spaces
  • N No
  • Y Yes
AP131, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +23 more
API-MATCH-TABLE
MATCH_TABLE		Alpha 10Match table. Contains matching and match processing rules.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +51 more
API-TAX-CODE-CNTL
TAX_CODE_CNTL		Alpha 1This control field defines the tax code usage in invoicing and approving taxes. For PO Invoices, if set to O (Override) all lines approved for payment will use 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
  • 8 Override taxable PO Line
  • 9 Override taxable PO and AOC
AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +41 more
API-LAST-MATCH-LN
LAST_MATCH_LN		Numeric 4Last matched line number.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +48 more
API-MATCH-LEVEL
MATCH_LEVEL		Alpha 3Indicates whether the invoice was matched at the invoice or detail level.AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, MA61.1, MA66.2 +3 more
API-MATCH-DATE
MATCH_DATE		Numeric 8 (yyyymmdd)The date the invoice was matched.AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, MA61.1, MA66.2 +3 more
API-PO-INV-TAX
PO_INV_TAX		Signed 18.2The amount of invoiced tax that will be generated on the invoice from taxable add on costs and taxable purchase order receipt lines assigned to the invoice. The resulting value is then used to compute the invoice match amount when no tax code has been assigned to the invoice.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +46 more
API-BYPASS-MATCH
BYPASS_MATCH		Alpha 1—AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +41 more
API-SERVICE-FL
SERVICE_FL		Alpha 1This field indicates a transaction is a Service only transaction.
  • Y Yes
  • N No
—
API-SERVICE-AMT
SERVICE_AMT		Signed 18.2—AP125, AP126, AP180, AP181, AP190, AP25.1, AP25.2, AP26.1 +37 more
API-BUYER
BUYER		Alpha 3—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +34 more
API-FINAL-DST-FLAG
FINAL_DST_FLAG		Alpha 1—AP30.2
API-NOTC
NOTC		Alpha 2The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +17 more
API-STAT-PROC
STAT_PROC		Alpha 6The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +17 more
API-SHIP-VIA
SHIP_VIA		Alpha 12 (Lower Case)—AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +17 more
API-UNLOADING-PORT
UNLOADING_PORT		Alpha 5The prot where the goods are unloaded if required. Must be defined in IN04.1 (Port Maintenance)AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +17 more
API-INTRASTAT-NBR
INTRASTAT_NBR		Numeric 12The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added.AP125, AP126, AP180, AP181, AP190, AP25.1, AP25.2, AP26.1 +10 more
API-DROPSHIP-FL
DROPSHIP_FL		Alpha 1This flag indicates whether goods being shipped by the vendor directly to a non standard location need to have the receiving process performed.AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +11 more
API-FOB-CODE
FOB_CODE		Alpha 3The user defined Free On Board Code.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +17 more
API-NET-PAYABLE
NET_PAYABLE		DerivedThe net payment amount in the currency of the invoice.—
API-JBK-SEQ-NBR
JBK_SEQ_NBR		Numeric 10The journal book sequence number assigned to a journal book transaction when it is added or interfaced to the Lawson system. Used only when Auto Journal Book Seq Nbr is set to Yes in GL10.1 (Company).AP170, AP180, AP181, AP190, AP193, AP20.1, AP20.2, AP20.3 +23 more
API-DIVERSE-CODE
DIVERSE_CODE		Alpha 5Diversity Code for Account Payable VendorsAP115, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1 +11 more
API-FLEX-FLAG
FLEX_FLAG		Alpha 1—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more
API-RULE-GROUP
RULE_GROUP		Alpha 10This is the rule group entered on the AP20 invoice entry screen.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +41 more
API-FLOAT-DAYS
FLOAT_DAYS		Numeric 3This is a number of days to add to best terms calculation if the vendor will allow a specific number of days for payment to reach them and still receive the discount.—
API-MTCH-PREPAY-FL
MTCH_PREPAY_FL		Alpha 1Flag that notes if the invoice will be prepaid. This is for match invoices. " " = Blank
  • 1 Yes
  • 2 No
AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +8 more
API-MTCH-PREPAY-MT
MTCH_PREPAY_MT		Numeric 1Flag denotes the method of match prepayment.
  • 0 No
  • 1 Prepay from Invoice
  • 2 Eligible for Prepayment
AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +8 more
API-PREPAY-DATE
PREPAY_DATE		Numeric 8 (yyyymmdd)——
API-PRPY-DISC-CODE
PRPY_DISC_CODE		Alpha 10——
API-PRPY-REF-NBR
PRPY_REF_NBR		Alpha 22——
API-PRPY-RTL-AMT
PRPY_RTL_AMT		Signed 18.2——
API-PRPY-AMT
PRPY_AMT		Signed 18.2——
API-PRPY-AOC-AMT
PRPY_AOC_AMT		Signed 18.2——
API-PRPY-TAX-AMT
PRPY_TAX_AMT		Signed 18.2——
API-PRPY-SERV-AMT
PRPY_SERV_AMT		Signed 18.2——
API-COCO-FL
COCO_FL		Numeric 1This is the flag when added to the handling code denotes that the invoice will be reviewed for match based on header, line, and Cost components (AOC)AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +10 more
API-MATCH-AOC
MATCH_AOC		Signed 18.2This is the amount of the AOC that has been matched.AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +20 more
API-HASH-QTY
HASH_QTY		Signed 15.4This is the total qty of the goods on the invoice. This field will be used to match on quantity.AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +20 more
API-XREF-VENDOR
XREF_VENDOR		Alpha 9 (Right Justified)This is a vendor that is supported on a system outside Lawson. When records are interfaces we will maintain this vendor on the file but we will use the Lawson vendor while in the lawson application.—
API-MTCH-ERR-TYPE
MTCH_ERR_TYPE		Numeric 2This is the reason the match was not successful for Invoice Match.
  • 01 Match Invoice
  • 02 Cost error
  • 03 No receipt information
  • 04 Hash quantity error
  • 05 No AOC on purchase order
  • 06 No AOC cost
  • 07 Tax out of balance
AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +35 more
API-BT-AMT
BT_AMT		Signed 18.2This is the amount of the discount based on best terms—
API-DISC-POINT
DISC_POINT		Numeric 1This is the flag that will note if the discounts will be applied to the cost of the goods or the cost of the goods and the AOC.
  • 1 Cost of goods
  • 2 Cost of Goods and AOC
AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more
API-TAX-FLAG
TAX_FLAG		Alpha 1" " = Not interfaced
  • I Interfaced
TX101
API-TAX-OUT-BAL
TAX_OUT_BAL		DerivedThe amount of the invoice that is out-of-balance due to tax applications made for the invoice.—
API-TXB-OUT-BAL
TXB_OUT_BAL		DerivedDerived field to show difference between header taxable input and total taxable amount from distributions.—
API-PMT-OUT-BAL
PMT_OUT_BAL		DerivedThe amount of the invoice that is out-of-balance due to payment applications made for the invoice.—
API-DIST-OUT-BAL
DIST_OUT_BAL		DerivedThe amount of the invoice that is out-of-balance due to expense distribution applications made for the invoice.—
API-OUT-BAL-FLAG
OUT_BAL_FLAG		DerivedIndicates whether the invoice is out-of-balance. Valid values are:
  • N No.
  • Y Yes.
—
API-INV-STATUS
INV_STATUS		DerivedIndicates the status of the invoice. Valid values are: Unreleased. Released. Historical.—
API-REV-SIGN-AMT
REV_SIGN_AMT		DerivedThe invoice amount * -1.—
API-TYPE-SHORT-NME
TYPE_SHORT_NME		DerivedThe translation of the invoice type.—
API-PO-RELEASE-3
PO_RELEASE_3		DerivedThe purchase order release number associated with the invoice. Used to identify a purchase order release created from a blanket or standing order.—
API-CHARGEBACK-FL
CHARGEBACK_FL		Alpha 1——
API-ORIGIN-COUNTRY
ORIGIN_COUNTRY		Alpha 2The country from which the goods were shipped. Must be a valid country in IN01.1 (Country Maintenance)—
API-ORIGIN-REGION
ORIGIN_REGION		Alpha 2The region of the country from which the goods were shipped, if required. Must be a valid region in IN02.1 (Region Maintenance)—
API-DEST-COUNTRY
DEST_COUNTRY		Alpha 2The country to which the goods were shipped. Must be a valid country in IN01.1 (Country Maintenance).AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more
API-DEST-REGION
DEST_REGION		Alpha 2The region of the country to which the goods were shipped, if required. Must be a valid region in IN02.1 (Region Maintenance)—
API-TRANSPORT-MODE
TRANSPORT_MODE		Alpha 1The mode of transportation at the border crossing. Code 7 is used for the Channel Tunnel.—
API-STATEMENT
STATEMENT		Alpha 22Used to identify the invoice.API1.1
API-CONTRACT-GROUP
CONTRACT_GROUP		Alpha 4—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +10 more
API-CM-CONTRACT
CM_CONTRACT		Numeric 15—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +10 more
API-REBATE-TYPE
REBATE_TYPE		Alpha 25—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +10 more
API-REBATE-DUE-DTE
REBATE_DUE_DTE		Numeric 8 (yyyymmdd)—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +10 more
API-MTCH-PROC-TYPE
MTCH_PROC_TYPE		Alpha 2—
  • R Receipt Match
  • S Service
  • A AOC only
  • D Drop Ship
  • V Vendor Agreement
  • E Expense
AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +51 more
API-RET-ACCR-CODE
RET_ACCR_CODE		Alpha 4—AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +17 more
API-RET-TRAN-AMT
RET_TRAN_AMT		Signed 18.2—AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, MA61.1, MA70.1 +2 more
API-RET-BASE-AMT
RET_BASE_AMT		Signed 18.2—AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, MA61.1, MA70.1 +2 more
API-RET-TRAN-PMT
RET_TRAN_PMT		Signed 18.2—AP170, AP180, AP181, AP190, AP28.1, AP28.2, AP45.1
API-RET-BASE-PMT
RET_BASE_PMT		Signed 18.2—AP170, AP180, AP181, AP190, AP28.1, AP28.2, AP45.1
API-REF-INV-FL
REF_INV_FL		Alpha 1" " = No Memos exist
  • Y One or More Memos exist
AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more
API-TAX-TYPE
TAX_TYPE		Alpha 1—
  • I Invoiced
  • A Accrued
—
API-SEC-WITHHOLD
SEC_WITHHOLD		Alpha 1—
  • Y Yes
  • N No
AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +18 more
API-CREATED-BY
CREATED_BY		Alpha 10—AP115, AP180, AP181, AP190, AP193, AP20.1, AP20.2, AP20.3 +39 more
API-LAST-UPDT-DATE
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—AP101, AP115, AP125, AP126, AP130, AP131, AP133, AP136 +52 more (list truncated in source)
API-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—AP101, AP115, AP125, AP126, AP130, AP131, AP133, AP136 +52 more (list truncated in source)
API-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—AP101, AP115, AP125, AP126, AP130, AP131, AP133, AP136 +52 more (list truncated in source)
API-FOR-ECON-CODE
FOR_ECON_CODE		Alpha 10—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more
API-DISCOUNT-RT1
DISCOUNT_RT1		Percent 5.3 (Percent)—AP150, AP30.3
API-DISCOUNT-RT2
DISCOUNT_RT2		Percent 5.3 (Percent)—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +11 more
API-DISCOUNT-RT3
DISCOUNT_RT3		Percent 5.3 (Percent)—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +11 more
API-BASE-DISC-AMT1
BASE_DISC_AMT1		Signed 18.2—AP150, AP30.3
API-BASE-DISC-AMT2
BASE_DISC_AMT2		Signed 18.2—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +8 more
API-BASE-DISC-AMT3
BASE_DISC_AMT3		Signed 18.2—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +8 more
API-TRAN-DISC-AMT1
TRAN_DISC_AMT1		Signed 18.2—AP150, AP30.3
API-TRAN-DISC-AMT2
TRAN_DISC_AMT2		Signed 18.2—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +11 more
API-TRAN-DISC-AMT3
TRAN_DISC_AMT3		Signed 18.2—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +11 more
API-DISC-DATE1
DISC_DATE1		Numeric 8 (yyyymmdd)—AP150, AP30.3
API-DISC-DATE2
DISC_DATE2		Numeric 8 (yyyymmdd)—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +11 more
API-DISC-DATE3
DISC_DATE3		Numeric 8 (yyyymmdd)—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +11 more
API-FREIGHT-TOT
FREIGHT_TOT		Signed 18.2—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +20 more
API-INSURANCE-TOT
INSURANCE_TOT		Signed 18.2—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +20 more
API-CSTMS-TOT
CSTMS_TOT		Signed 18.2—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +20 more
API-OTHER-AOC-TOT
OTHER_AOC_TOT		Signed 18.2—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +20 more
API-GLBL-DOC-TYPE
GLBL_DOC_TYPE		Alpha 10—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +10 more
API-REF-TYPE
REF_TYPE		Alpha 1—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +11 more
API-CUSTOMER-ID
CUSTOMER_ID		Alpha 27—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +11 more
API-PMT-CAT-CODE
PMT_CAT_CODE		Alpha 6—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +11 more
API-NO-PAY-CONCERN
NO_PAY_CONCERN		Alpha 60——
API-REFERENCE-NO
REFERENCE_NO		Alpha 25 (Right Justified)—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more

Indexes (14)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
APISET1COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQPrimaryAM19.1, AM19.2, AM19.4, AP00.4, AP01.1, AP10.1, AP10.2, AP100 +22 more (list truncated in source)
APISET10COMPANY, RECON-DATE, ACCR-CODE, INV-CURRENCY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, REC-STATUSKeyChangeAP136, AP232
APISET11COMPANY, VENDOR, MATCH-REF-NBR, OBJ-IDKeyChange, SubsetWhere MATCH-REF-NBR != SpacesAP125, AP126, AP25.1, AP25.2, AP26.1, AP27.1, API1.1, MA60.1 +19 more
APISET13COMPANY, VENDOR, MATCH-OBJ-ID, INVOICE, SUFFIX, CANCEL-SEQKeyChangeAP125, AP126, AP131, AP136, AP232, AP25.1, AP25.2, AP26.1 +22 more (list truncated in source)
APISET14COMPANY, VENDOR, DUE-DATE, INVOICE, SUFFIX, CANCEL-SEQKeyChange, SubsetWhere ((MATCH-STATUS = Zeroes) Or (MATCH-STATUS = 1)) And (MATCH-FL = "Y") And ((REC-STATUS = Zeroes) Or (REC-STATUS = 1))AP125, AP126, AP130, AP25.1, AP25.2, AP26.1, AP27.1, API1.1 +22 more (list truncated in source)
APISET15COMPANY, CREATE-DATE, LAST-UPDT-DATE, VENDOR, INVOICE, SUFFIX, CANCEL-SEQKeyChange—
APISET2COMPANY, BATCH-NUM, AUTH-CODE, VOUCHER-NBR, VENDOR, INVOICE, SUFFIX, CANCEL-SEQKeyChange, SubsetWhere REC-STATUS = ZeroesAP00.4, AP125, AP126, AP195, AP220, AP25.1, AP25.2, AP25.3 +2 more
APISET3REC-STATUS, COMPANY, BATCH-NUM, AUTH-CODE, OPERATOR, CREATE-DATE, CREATION-TIME, VENDOR, INVOICE, SUFFIX, CANCEL-SEQKeyChangeAP193, AP195, AP198, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +16 more
APISET4COMPANY, VOUCHER-NBR, REC-STATUS, VENDOR, INVOICE, SUFFIX, CANCEL-SEQKeyChangeAP00.4, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +20 more
APISET5VENDOR-GROUP, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, COMPANYKeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
APISET6COMPANY, VENDOR, INVOICE-DTE*, INVOICE, SUFFIX, CANCEL-SEQKeyChangeAP131, AP221, AP225, AP251, AP300, AP90.2, MA126
APISET7COMPANY, REC-STATUS, BATCH-NUM, VENDOR, INVOICE, SUFFIX, CANCEL-SEQKeyChange, SubsetWhere TRAN-TOT-DIST != TRAN-INV-AMT Or TRAN-TOT-PMT != TRAN-INV-AMT Or BASE-TOT-PMT != BASE-INV-AMT Or TRAN-TOT-TAX != TRAN-TAX-AMTAP125, AP126, AP240, AP25.1, AP25.2, AP26.1, AP27.1
APISET8COMPANY, DUE-DATE, VENDOR, INVOICE, SUFFIX, CANCEL-SEQKeyChange, SubsetWhere ((MATCH-STATUS = Zeroes) Or (MATCH-STATUS = 1)) And (MATCH-FL = "Y") And ((REC-STATUS = Zeroes) Or (REC-STATUS = 1))AP125, AP126, AP25.1, AP25.2, AP252, AP26.1, AP27.1, API1.1 +20 more
APISET9COMPANY, VENDOR, PO-NUMBER, PO-RELEASE, PO-CODE, LOCATION, INVOICE, SUFFIX, CANCEL-SEQKeyChangeAP125, AP126, AP141, AP25.1, AP25.2, AP26.1, AP27.1, AP90.4 +22 more (list truncated in source)

Relations

One to one (31) — lookups and parents

RelationTableRulesConditionField map
ApauthorAPAUTHORRequiredWhen API-AUTH-CODE > SpacesAPI-COMPANY → ATR-COMPANY, API-AUTH-CODE → ATR-AUTH-CODE
ApbatchAPBATCHRequiredWhen API-BATCH-NUM != ZeroesAPI-COMPANY → APB-COMPANY, API-BATCH-NUM → APB-BATCH-NUM
ApcompanyAPCOMPANYRequiredAPI-COMPANY → CPY-COMPANY
ApinccodeAPINCCODENot RequiredAPI-INCOME-CODE → TYP-INCOME-CODE
ApinvbodAPINVBODNot Required, Delete CascadesAPI-COMPANY → YAZ-COMPANY, API-VENDOR → YAZ-VENDOR, API-INVOICE → YAZ-INVOICE, API-SUFFIX → YAZ-SUFFIX, API-CANCEL-SEQ → YAZ-CANCEL-SEQ
AppayvenaddrAPVENADDRNot RequiredCPY-VENDOR-GROUP → VDR-VENDOR-GROUP, API-PAY-VENDOR → VDR-VENDOR, Spaces → VDR-LOCATION-CODE, Spaces → VDR-RESP-CODE, Zeroes → VDR-CONTACT-LVL, "Y" → VDR-CUR-ADDR
AppayvenmastAPVENMASTRequiredCPY-VENDOR-GROUP → VEN-VENDOR-GROUP, API-PAY-VENDOR → VEN-VENDOR
ApproclevAPPROCLEVRequiredAPI-COMPANY → APR-COMPANY, API-PROC-LEVEL → APR-PROC-LEVEL
ApuavalAPUAVALNot Required"I" → UAV-SEG-TYPE, API-OBJ-ID → UAV-API-OBJ-ID, Zeroes → UAV-DIST-SEQ-NBR
ApvenlocaddrAPVENADDRNot RequiredCPY-VENDOR-GROUP → VDR-VENDOR-GROUP, API-PAY-VENDOR → VDR-VENDOR, API-REMIT-TO-CODE → VDR-LOCATION-CODE, Spaces → VDR-RESP-CODE, Zeroes → VDR-CONTACT-LVL, "Y" → VDR-CUR-ADDR
ApvenlocpurchAPVENLOCRequiredWhen API-PURCH-FR-LOC != SpacesCPY-VENDOR-GROUP → VLO-VENDOR-GROUP, API-VENDOR → VLO-VENDOR, API-PURCH-FR-LOC → VLO-LOCATION-CODE
ApvenlocremitAPVENLOCRequiredWhen API-REMIT-TO-CODE != SpacesCPY-VENDOR-GROUP → VLO-VENDOR-GROUP, API-PAY-VENDOR → VLO-VENDOR, API-REMIT-TO-CODE → VLO-LOCATION-CODE
ApvenmastAPVENMASTRequiredCPY-VENDOR-GROUP → VEN-VENDOR-GROUP, API-VENDOR → VEN-VENDOR
CbcashcodeCBCASHCODERequiredAPI-CASH-CODE → CBC-CASH-CODE
Eeadvance AEEADVANCERequiredWhen API-INVOICE-TYPE = "A"API-COMPANY → EEA-COMPANY, API-VENDOR → EEA-VENDOR, API-INVOICE → EEA-ADVANCE-NBR
Eeadvance MEEADVANCERequiredWhen API-INVOICE-TYPE = "M"API-COMPANY → EEA-COMPANY, API-VENDOR → EEA-VENDOR, API-INVOICE → EEA-ADVANCE-NBR
EeexpenseEEEXPENSERequiredWhen API-INVOICE-TYPE = "E"API-COMPANY → EXP-COMPANY, API-VENDOR → EXP-VENDOR, API-INVOICE → EXP-EXPENSE-NBR
InvusrfldAPINUSRFLDNot RequiredAPI-OBJ-ID → ISR-OBJ-ID
LminvoiceLMINVOICERequiredAPI-COMPANY → INV-COMPANY, API-VENDOR → INV-PMT-VENDOR, API-INVOICE → INV-INVOICE, API-SUFFIX → INV-SUFFIX, API-CANCEL-SEQ → INV-CANCEL-SEQ
MacompanyMACOMPANYNot RequiredAPI-COMPANY → MAY-COMPANY
MainvhandMAINVHANDRequiredAPI-COMPANY → MAH-COMPANY, API-HANDLING-CODE → MAH-HANDLING-CODE
MamtchruleMAMTCHRULERequiredAPI-RULE-GROUP → MAU-MATCH-RULE
PocompanyPOCOMPANYNot RequiredAPI-COMPANY → PCY-COMPANY
PorebduePOREBDUERequiredAPI-CONTRACT-GROUP → DUE-CONTRACT-GROUP, API-CM-CONTRACT → DUE-CM-CONTRACT, API-REBATE-TYPE → DUE-REBATE-TYPE, API-REBATE-DUE-DTE → DUE-DUE-DATE
PoreceivePORECEIVENot RequiredAPI-COMPANY → POR-COMPANY, API-VENDOR → POR-VENDOR, API-INVOICE → POR-INVOICE
PoreturnhdPORETURNHDNot RequiredAPI-COMPANY → PTH-COMPANY, API-RETURN-NUMBER → PTH-RETURN-NUMBER
PovagrmthdPOVAGRMTHDNot RequiredPCY-PROCURE-GROUP → PVH-PROCURE-GROUP, API-VENDOR → PVH-VENDOR, API-PO-NUMBER → PVH-PO-NUMBER
PurchorderPURCHORDERNot RequiredAPI-COMPANY → PCR-COMPANY, API-PO-CODE → PCR-PO-CODE, API-PO-NUMBER → PCR-PO-NUMBER, API-PO-RELEASE → PCR-PO-RELEASE
ReasoncdMAREASONCDNot RequiredAPI-REASON-CODE → MAR-REASON-CODE
TaxcodeTXTAXCODENot RequiredAPI-COMPANY → TAC-COMPANY, API-TAX-CODE → TAC-TAX-CODE
TxcompanyTXCOMPANYNot RequiredAPI-COMPANY → TXC-COMPANY

One to many (28) — child tables

RelationTableRulesConditionField map
ApauditAPAUDITCPY-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, → APA-LOCATION-CODE
ApcrmemoAPCRMEMOAPI-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
Apcrmemo2APCRMEMOAPI-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
ApdiscaccAPDISCACCAPI-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
ApdistcodeAPDISTCODEAPI-COMPANY → DTC-COMPANY, API-DIST-CODE → DTC-DIST-CODE, → DTC-SEQ-NBR
ApdistpayAPDISTPAYAPI-COMPANY → DTY-COMPANY, API-VENDOR → DTY-VENDOR, API-INVOICE → DTY-INVOICE, API-SUFFIX → DTY-SUFFIX, → DTY-PMT-SEQ-NBR, → DTY-LINE-NBR, → DTY-MAD-SEQ-NBR, → DTY-DIST-SEQ-NBR
ApdistribAPDISTRIBDelete CascadesAPI-OBJ-ID → APD-API-OBJ-ID, → APD-DIST-SEQ-NBR
AppaymentAPPAYMENTDelete CascadesAPI-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
Apvencomments2APCOMMENTS"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
ApvendivAPVENDIVAPI-VENDOR-GROUP → VDC-VENDOR-GROUP, API-VENDOR → VDC-VENDOR, API-LOCATION → VDC-LOCATION-CODE, → VDC-DIVERSE-CODE, → VDC-DCERT-DATE
MaaocdtlMAAOCDTLAPI-COMPANY → MAA-COMPANY, API-VENDOR → MAA-VENDOR, API-INVOICE → MAA-INVOICE, API-SUFFIX → MAA-SUFFIX, API-PO-NUMBER → MAA-PO-NUMBER, API-PO-RELEASE → MAA-PO-RELEASE, API-PO-CODE → MAA-PO-CODE, → MAA-LINE-NBR, → MAA-AOC-CODE, → MAA-SEQ-NBR
Maaocdtl 2MAAOCDTLAPI-COMPANY → MAA-COMPANY, API-VENDOR → MAA-VENDOR, API-INVOICE → MAA-INVOICE, API-SUFFIX → MAA-SUFFIX, → MAA-PO-NUMBER, → MAA-PO-RELEASE, → MAA-PO-CODE, → MAA-LINE-NBR, → MAA-AOC-CODE, → MAA-SEQ-NBR
MainvdtlMAINVDTLAPI-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-SEQ-NBR
Mainvdtl 2MAINVDTLAPI-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-SEQ-NBR
MainvmsgMAINVMSGAPI-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
Mainvref1MAINVREFAPI-COMPANY → MRF-COMPANY, API-VENDOR → MRF-VENDOR, API-INVOICE → MRF-API-INVOICE, API-SUFFIX → MRF-API-SUFFIX, API-CANCEL-SEQ → MRF-API-CANCEL-SEQ, → MRF-REF-INV-NBR, → MRF-REF-SUFFIX, → MRF-REF-CANCEL-SEQ
Mainvref2MAINVREFAPI-COMPANY → MRF-COMPANY, API-VENDOR → MRF-VENDOR, API-INVOICE → MRF-REF-INV-NBR, API-SUFFIX → MRF-REF-SUFFIX, API-CANCEL-SEQ → MRF-REF-CANCEL-SEQ, → MRF-API-INVOICE, → MRF-API-SUFFIX, → MRF-API-CANCEL-SEQ
MapoinvMAPOINVDelete RestrictedAPI-COMPANY → AOI-COMPANY, API-VENDOR → AOI-VENDOR, API-INVOICE → AOI-INVOICE, API-SUFFIX → AOI-SUFFIX, → AOI-PO-NUMBER, → AOI-PO-RELEASE, → AOI-PO-CODE
Match TransAPINVOICEAPI-COMPANY → API-COMPANY, API-VENDOR → API-VENDOR, API-MATCH-OBJ-ID → API-MATCH-OBJ-ID, → API-INVOICE, → API-SUFFIX, → API-CANCEL-SEQ
PomatchobjPOMATCHOBJAPI-COMPANY → PMJ-COMPANY, API-MATCH-OBJ-ID → PMJ-MATCH-OBJ-ID, → PMJ-MATCH-SEQ-NBR, → PMJ-REC-NUMBER, → PMJ-LINE-NBR, → PMJ-AOC-CODE
PomessagePOMESSAGEAPI-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 RefPORECEIVEAPI-COMPANY → POR-COMPANY, API-VENDOR → POR-VENDOR, API-MATCH-REF-NBR → POR-MATCH-REF-NBR, → POR-REC-NUMBER
PorebrecdPOREBRECDValid When API-CONTRACT-GROUP != SpacesAPI-OBJ-ID → RRC-API-OBJ-ID, → RRC-CONTRACT-GROUP, → RRC-CM-CONTRACT, → RRC-REBATE-TYPE, → RRC-DUE-DATE, → RRC-REBATE-SEQ
PoreclinePORECLINEAPI-COMPANY → PRL-COMPANY, API-MATCH-OBJ-ID → PRL-MATCH-OBJ-ID, → PRL-MATCH-SEQ-NBR, → PRL-REC-NUMBER, → PRL-LINE-NBR
Poreset9 VenPORECEIVEAPI-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
Porset3PORECEIVEAPI-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
Porset9PORECEIVEAPI-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 VenPORECEIVEAPI-COMPANY → POR-COMPANY, API-VENDOR → POR-VENDOR, → POR-PO-CODE, → POR-PO-NUMBER, → POR-PO-RELEASE, → POR-LOCATION, → POR-REC-NUMBER

Programs

Updated by (290)

Referenced by (127)