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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`API-COMPANY` PK COMPANY	Numeric 4	The 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 22	The 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 3	The 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 4	The 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` SET2 SET3 SET7 BATCH_NUM	Numeric 6	The 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` SET2 SET4 VOUCHER_NBR	Alpha 10	The 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` SET2 SET3 AUTH_CODE	Alpha 3	The 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 5	The 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` SET10 ACCR_CODE	Alpha 4	The 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 1	Identifies 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` SET10 INV_CURRENCY	Alpha 5	The 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 5	The 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` SET6 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 4	The 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` SET9 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` SET9 PO_RELEASE	Numeric 4	The 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` SET9 PO_CODE	Alpha 4	Purchase 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.2	The 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.2	The 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 1	The 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.2	The 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.2	The 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.2	The 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 1	The 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.2	The 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.2	The 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.2	The 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.2	The 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.2	The 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.2	The 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.2	The 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.2	The 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.2	The 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.7	The 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 1	Indicates 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` SET14 SET8 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 3	Used 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 1	Used 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 3	Used 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 1	Used 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 4	The 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 4	The 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 3	The 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 1	Used 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 10	The 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 4	The 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 9	The 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` SET10 SET3 SET4 SET7 REC_STATUS	Numeric 1	The 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` SET15 SET3 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` SET3 OPERATOR	Alpha 10	The operator associated with the invoice.	AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +47 more
#`API-CREATION-TIME` SET3 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` SET5 VENDOR_GROUP	Alpha 4	The 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 4	The 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 4	The 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 6	Used 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 4	Used 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 10	The 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 1	Indicates 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 2	Indicates 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 1	Indicates 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 10	If 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 10	If 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 12	The 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 1	Indicates 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` SET11 OBJ_ID	Numeric 12	A 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` SET10 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 1	Indicates 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` SET11 MATCH_REF_NBR	Alpha 22	Matching 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 1	Indicates 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 5	Invoice 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.2	The retail amount of the item.	AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +48 more
#`API-MATCH-STATUS` MATCH_STATUS	Numeric 1	Indicates 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 4	This 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 4	Invoice 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.2	Match 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.2	Add on cost amount.	AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +48 more
#`API-LOCATION` SET9 LOCATION	Alpha 5	This 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` SET13 MATCH_OBJ_ID	Numeric 12	A system generated matching object identifier.	AP125, AP126, AP180, AP181, AP190, AP25.1, AP25.2, AP26.1 +28 more
#`API-CBPRINT-FL` CBPRINT_FL	Alpha 1	Indicates 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 10	Match 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 1	This 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 4	Last matched line number.	AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +48 more
#`API-MATCH-LEVEL` MATCH_LEVEL	Alpha 3	Indicates 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.2	The 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 1	This 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 2	The 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 6	The 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 5	The 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 12	The 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 1	This 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 3	The 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	Derived	The net payment amount in the currency of the invoice.	—
#`API-JBK-SEQ-NBR` JBK_SEQ_NBR	Numeric 10	The 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 5	Diversity Code for Account Payable Vendors	AP115, 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 10	This 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 3	This 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 1	Flag 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 1	Flag 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 1	This 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.2	This 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.4	This 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 2	This 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.2	This is the amount of the discount based on best terms	—
#`API-DISC-POINT` DISC_POINT	Numeric 1	This 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	Derived	The amount of the invoice that is out-of-balance due to tax applications made for the invoice.	—
#`API-TXB-OUT-BAL` TXB_OUT_BAL	Derived	Derived field to show difference between header taxable input and total taxable amount from distributions.	—
#`API-PMT-OUT-BAL` PMT_OUT_BAL	Derived	The amount of the invoice that is out-of-balance due to payment applications made for the invoice.	—
#`API-DIST-OUT-BAL` DIST_OUT_BAL	Derived	The 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	Derived	Indicates whether the invoice is out-of-balance. Valid values are: `N` No. `Y` Yes.	—
#`API-INV-STATUS` INV_STATUS	Derived	Indicates the status of the invoice. Valid values are: Unreleased. Released. Historical.	—
#`API-REV-SIGN-AMT` REV_SIGN_AMT	Derived	The invoice amount * -1.	—
#`API-TYPE-SHORT-NME` TYPE_SHORT_NME	Derived	The translation of the invoice type.	—
#`API-PO-RELEASE-3` PO_RELEASE_3	Derived	The 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 2	The country from which the goods were shipped. Must be a valid country in IN01.1 (Country Maintenance)	—
#`API-ORIGIN-REGION` ORIGIN_REGION	Alpha 2	The 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 2	The 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 2	The 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 1	The mode of transportation at the border crossing. Code 7 is used for the Channel Tunnel.	—
#`API-STATEMENT` STATEMENT	Alpha 22	Used 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` SET15 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`APISET1`	`COMPANY` `VENDOR` `INVOICE` `SUFFIX` `CANCEL-SEQ`	Primary		AM19.1, AM19.2, AM19.4, AP00.4, AP01.1, AP10.1, AP10.2, AP100 +22 more (list truncated in source)
`APISET10`	`COMPANY` `RECON-DATE` `ACCR-CODE` `INV-CURRENCY` `VENDOR` `INVOICE` `SUFFIX` `CANCEL-SEQ` `REC-STATUS`	KeyChange		AP136, AP232
`APISET11`	`COMPANY` `VENDOR` `MATCH-REF-NBR` `OBJ-ID`	KeyChange, Subset	Where MATCH-REF-NBR != Spaces	AP125, AP126, AP25.1, AP25.2, AP26.1, AP27.1, API1.1, MA60.1 +19 more
`APISET13`	`COMPANY` `VENDOR` `MATCH-OBJ-ID` `INVOICE` `SUFFIX` `CANCEL-SEQ`	KeyChange		AP125, AP126, AP131, AP136, AP232, AP25.1, AP25.2, AP26.1 +22 more (list truncated in source)
`APISET14`	`COMPANY` `VENDOR` `DUE-DATE` `INVOICE` `SUFFIX` `CANCEL-SEQ`	KeyChange, Subset	Where ((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)
`APISET15`	`COMPANY` `CREATE-DATE` `LAST-UPDT-DATE` `VENDOR` `INVOICE` `SUFFIX` `CANCEL-SEQ`	KeyChange		—
`APISET2`	`COMPANY` `BATCH-NUM` `AUTH-CODE` `VOUCHER-NBR` `VENDOR` `INVOICE` `SUFFIX` `CANCEL-SEQ`	KeyChange, Subset	Where REC-STATUS = Zeroes	AP00.4, AP125, AP126, AP195, AP220, AP25.1, AP25.2, AP25.3 +2 more
`APISET3`	`REC-STATUS` `COMPANY` `BATCH-NUM` `AUTH-CODE` `OPERATOR` `CREATE-DATE` `CREATION-TIME` `VENDOR` `INVOICE` `SUFFIX` `CANCEL-SEQ`	KeyChange		AP193, AP195, AP198, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +16 more
`APISET4`	`COMPANY` `VOUCHER-NBR` `REC-STATUS` `VENDOR` `INVOICE` `SUFFIX` `CANCEL-SEQ`	KeyChange		AP00.4, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +20 more
`APISET5`	`VENDOR-GROUP` `VENDOR` `INVOICE` `SUFFIX` `CANCEL-SEQ` `COMPANY`	KeyChange		AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
`APISET6`	`COMPANY` `VENDOR` `INVOICE-DTE` ↓ `INVOICE` `SUFFIX` `CANCEL-SEQ`	KeyChange		AP131, AP221, AP225, AP251, AP300, AP90.2, MA126
`APISET7`	`COMPANY` `REC-STATUS` `BATCH-NUM` `VENDOR` `INVOICE` `SUFFIX` `CANCEL-SEQ`	KeyChange, Subset	Where 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-AMT	AP125, AP126, AP240, AP25.1, AP25.2, AP26.1, AP27.1
`APISET8`	`COMPANY` `DUE-DATE` `VENDOR` `INVOICE` `SUFFIX` `CANCEL-SEQ`	KeyChange, Subset	Where ((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
`APISET9`	`COMPANY` `VENDOR` `PO-NUMBER` `PO-RELEASE` `PO-CODE` `LOCATION` `INVOICE` `SUFFIX` `CANCEL-SEQ`	KeyChange		AP125, AP126, AP141, AP25.1, AP25.2, AP26.1, AP27.1, AP90.4 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (31) — lookups and parents

Relation Table Rules Condition Field map

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

Apinvbod

APINVBOD

Not Required, Delete Cascades

`API-COMPANY`	→	`YAZ-COMPANY`
`API-VENDOR`	→	`YAZ-VENDOR`
`API-INVOICE`	→	`YAZ-INVOICE`
`API-SUFFIX`	→	`YAZ-SUFFIX`
`API-CANCEL-SEQ`	→	`YAZ-CANCEL-SEQ`

Appayvenaddr

APVENADDR

Not Required

`CPY-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`

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`
`Spaces`	→	`VDR-RESP-CODE`
`Zeroes`	→	`VDR-CONTACT-LVL`
`"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

Lminvoice

LMINVOICE

Required

`API-COMPANY`	→	`INV-COMPANY`
`API-VENDOR`	→	`INV-PMT-VENDOR`
`API-INVOICE`	→	`INV-INVOICE`
`API-SUFFIX`	→	`INV-SUFFIX`
`API-CANCEL-SEQ`	→	`INV-CANCEL-SEQ`

Macompany

MACOMPANY

Not Required

API-COMPANY → MAY-COMPANY

Mainvhand

MAINVHAND

Required

`API-COMPANY`	→	`MAH-COMPANY`
`API-HANDLING-CODE`	→	`MAH-HANDLING-CODE`

Mamtchrule

MAMTCHRULE

Required

API-RULE-GROUP → MAU-MATCH-RULE

Pocompany

POCOMPANY

Not Required

API-COMPANY → PCY-COMPANY

Porebdue

POREBDUE

Required

`API-CONTRACT-GROUP`	→	`DUE-CONTRACT-GROUP`
`API-CM-CONTRACT`	→	`DUE-CM-CONTRACT`
`API-REBATE-TYPE`	→	`DUE-REBATE-TYPE`
`API-REBATE-DUE-DTE`	→	`DUE-DUE-DATE`

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

`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`

Txcompany

TXCOMPANY

Not Required

API-COMPANY → TXC-COMPANY

One to many (28) — child tables

Relation Table Rules Condition Field map

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`
—	→	`APA-LOCATION-CODE`

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`

Apdistpay

APDISTPAY

`API-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`

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`

Apvendiv

APVENDIV

`API-VENDOR-GROUP`	→	`VDC-VENDOR-GROUP`
`API-VENDOR`	→	`VDC-VENDOR`
`API-LOCATION`	→	`VDC-LOCATION-CODE`
—	→	`VDC-DIVERSE-CODE`
—	→	`VDC-DCERT-DATE`

Maaocdtl

MAAOCDTL

`API-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 2

MAAOCDTL

`API-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`

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-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-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`

Mainvref1

MAINVREF

`API-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`

Mainvref2

MAINVREF

`API-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`

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`

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`

Pomatchobj

POMATCHOBJ

`API-COMPANY`	→	`PMJ-COMPANY`
`API-MATCH-OBJ-ID`	→	`PMJ-MATCH-OBJ-ID`
—	→	`PMJ-MATCH-SEQ-NBR`
—	→	`PMJ-REC-NUMBER`
—	→	`PMJ-LINE-NBR`
—	→	`PMJ-AOC-CODE`

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`

Porebrecd

POREBRECD

Valid When API-CONTRACT-GROUP != Spaces

`API-OBJ-ID`	→	`RRC-API-OBJ-ID`
—	→	`RRC-CONTRACT-GROUP`
—	→	`RRC-CM-CONTRACT`
—	→	`RRC-REBATE-TYPE`
—	→	`RRC-DUE-DATE`
—	→	`RRC-REBATE-SEQ`

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`

Programs

Updated by (290)

AP10.2 Vendor Location
AP101 Pay Group Update
AP115 Vendor Merge
AP125 Batch Release
AP126 Mass Invoice Release
AP130 Proof of Delivery Statements
AP131 Chargeback
AP133 Mass Retainage Payment Adjust
AP136 Invoice Accrual Reconciliation
AP150 Cash Requirements
AP160 Payment Tape Creation
AP170 Payment Closing
AP180 Bill of Exchange Cashing Update
AP181 Bill of Exchange Statement Update
AP190 Invoice Reinstatement
AP191 Unrealized Gain or Loss
AP193 Recurring Invoice Update
AP195 Period Closing
AP198 Invoice Data Archival
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.6 Prepayment
AP20.7 Distributions
AP20.8 Payment Schedule
AP21.1 View Distributions
AP221 Potential Duplicate Payments
AP225 Vendor Statements
AP23.1 Transit Invoice Entry
AP232 Invoice Accrual Reconciliation Report
AP236 Invoice Payment Approval Edit
AP25.1 Batch Control
AP25.2 Batch Review
AP25.3 Invoice Batch Transfer
AP251 Match Analysis Report
AP26.1 Invoice Release
AP27.1 Single Invoice Release
AP28.1 Bill of Exchange Acceptance by Vendor
AP28.2 Bill of Exchange Acceptance by Date
AP30.1 Invoice Maintenance
AP30.2 Distribution Adjustments
AP30.3 Payment Schedule Adjustment
AP30.4 Invoice Cancel
AP300 Invoice and Vendor History Purge
AP305 Accounts Payable Company Purge
AP32.1 Workflow Approval Maintenance
AP33.1 Retainage Payment Adjustment
AP35.1 Credit Memo Application
AP36.1 Invoice Payment Approval
AP45.1 Reportable Income Adjustment
AP510 Vendor Conversion
AP520 Invoice Interface
AP55.2 Cash Payment Invoice Application
AP700 Accounts Payable Taxable Upgrade or Conversion
API1.1 Add Invoice
API2.1 Add Invoice
API3.1 Vendor Location Invoke
CX100 Pick List Print
CX20.1 Case Build
CX20.2 Case Detail
CX20.4 Substitute Items
CX20.5 Insert line
CX220 Case, Preference Listing
CX30.1 Case Completion Feedback
CX300 Preference List Purge
CX506 HL7 Schedules Import Interface
CXCP.1 Copy preference to case
DR100 Distribution Requirements Report
EE135 Mass Employee Release
EE35.1 Advance Release
EE35.2 Expense Release
EE520 Expense Interface
IC12.1 Item Location
IC140 Vendor Reorder Advice
IC141 Location Replenishment Report
IC142 Replenishment by Requisition PO's
IC145 Stock Status Report
IC243 Killed Item Report
IC330 Item Mass Change
IC64.1 Global Location Nbr Assignment GL/IC Company
IC64.2 Global Location Nbr Assignment IC Location
IC64.3 Global Location Number Assignment RQ Location
IC64.4 Global Location Number Assignment Manuf Code
IC64.5 Global Location Number Assignment Manuf Div
IC64.6 Global Location Number Assignment Vendor
IC64.7 Global Location Number Assignment Vendor Location
IC64.8 Global Location Number Assignment IC Bin
IC64.9 Global Location Number Assignment Buyer
IC66.1 Replenishment PO Worksheet
IC83.1 Par Location Counts
MA05.1 Handling Code
MA126 Auto Matching
MA168 Prepaid Invoice Not Received
MA180 Open Receipt Archive
MA278 Cost Variance Analysis
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.1 Memo Line Detail - Purchase Order
MA42.2 Memo Line AOC Detail
MA43.1 Invoice Line Detail - Purchase Order
MA43.2 Purchase Order Lookup
MA43.3 Invoice Line Detail - Receipt
MA43.4 Invoice Line Detail - Service
MA43.6 Service Agreement Detail
MA43.7 GL Distribution
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
MA53.1 Receipt Interface
MA530 ERS Invoice Creation
MA531 Receipt Interface
MA540 Invoice Interface
MA60.2 Invoice Level Match
MA60.3 Detail Level Match
MA60.4 Invoice Match Reference Adjustment
MA60.5 Receipt Match Reference Adjustment
MA61.1 Match Invoice Approval
MA64.9 PO Cost Message Accept Upload
MA65.1 Invoice Line Adjustment
MA66.2 Invoice Message - Details
MA66.3 Purchase Order Cost Review Message
MA67.2 Invoice Match from frontend
MA67.3 Detail Match from frontend
MA68.2 Invoice Level Match - Prepaid
MA68.3 Detail Level Match - Prepaid
MA68.4 Invoice Match Reference Adjustment
MA68.5 Receipt Match Reference Adjustment
MA70.1 Invoice Unmatch
MA75.1 PO Invoice Cancel
MA80.1 Receipt Archive
MA91.1 Match Pool Display
MAED.1 Vendor
MAI1.1 Invoke for MAMATCH Object
PD10.1 P-Card Card Request
PD10.2 P-Card Cardholder
PD130 P-Card Invoice and Release
PD20.1 P-Card Charge Approval
PD20.2 P-Card Charge Approval Level
PD20.3 P-Card Charge Approval SEA
PD570 P-Card Charge Import
PO04.1 Buyer
PO04.2 Buyer Purchasing Class
PO10.1 PO Vendor
PO10.2 Vendor Purchase From Location
PO100 Purchase Order Interface from Lawson Applications
PO101 Create Standing PO Release
PO115 Procurement Template Mass Changes
PO120 Mass PO Issue
PO122 Transmitted PO Acknowledgement
PO131 Receiving Log
PO132 Print Vendor Return Material Authorization
PO136 Matched, Not Received Report
PO15.1 Procurement Templates
PO15.2 Procurement Template Participants
PO15.4 Procurement Template Line Detail
PO150 Bid Load to Contract or Catalog
PO17.1 Purchase Order Approval Review
PO190 Close Purchase Order Header
PO20.1 Purchase Order Entry
PO20.6 Substitute Vendor Items
PO20.9 Multiple Lines
PO204 Buyer Master Listing
PO21.1 Select and Copy
PO21.2 Add-On Cost Spread
PO21.3 Account Distribution
PO21.4 Miscellaneous Add-On Cost
PO21.5 Item Add-On Cost
PO22.1 Authorization, Release
PO22.3 Mass Cancel or Delete Purchase Orders
PO22.4 Mass Cancel or Delete Purchase Order Lines
PO220 PO Status Report
PO222 Remaining PO Balance Report
PO224 PO Revision Report
PO225 Vendor Agreement Listing
PO229 Vendor Agreement Format Print
PO23.1 Purchase Order Worksheet
PO230 Unreleased Receivings Listing
PO234 PO Interface Listing Report
PO24.1 Purchase Order Direct Approval
PO25.1 Vendor Agreements
PO25.5 Vendor Agreement Item Add-On Cost
PO25.6 Vendor Agreement Line
PO25.7 Service Agreement Line
PO251 PO Buyer Message Listing
PO26.3 Vendor Agreement Commitments Spread
PO26.7 Mass Release of Vendor Agreements
PO26.9 Vendor Agreement Release
PO27.2 Select Blanket Lines
PO27.3 Create PO From Procurement Template
PO27.4 Select and Copy Template
PO275 Delivery Date Analysis
PO276 Deliver Quantity Analysis
PO277 Deliver Quality Analysis
PO28.2 Vendor Agreement Line Detail List
PO280 Purchases By Class
PO29.1 Copy Purchase Order
PO30.1 PO Receiving
PO30.2 Substitute Item
PO30.3 Additional Tracking Numbers
PO30.4 PO Receiving Line Detail List
PO300 PO and Receipt Purge
PO31.1 Vendor Return
PO31.2 Vendor Return Item Selection
PO32.2 Item Detail
PO32.4 Cancel Detail
PO33.1 Receiving Adjustment
PO34.1 Inspection Accept or Reject
PO35.1 Receiving Approval and Release
PO36.1 Identify Lawson Items by Vendor Agreement Line
PO36.2 Vendor Agreement Import Manual Input
PO38.1 Invoice AOC
PO39.1 Additional Receiving Entry
PO39.2 Additional Adjustment/Rejection Entry
PO44.1 PO Line Source
PO50.1 Buyer Message Entry
PO52.1 Buyer Message - Receiving
PO520 Purchase Order Interface from Non Lawson
PO536 Vendor Price Agreement Load
PO54.5 PO Line Detail List
PO64.1 PO Line Item History
POCP.1 POC Comments Copy
POI3.1 Invoke for POPI70PD
POID.1 PO Delivery Ticket Select
POII.1 Invoke for POPCRUPD
POIJ.1 Invoke for POPLIUPD
PR05.1 Deduction
PR05.3 Additional Vendors
PR226 United States Employee Garnishment Listing
PR247 Canada Employee Garnishment Listing
PR26.1 United States Employee Garnishment
PR47.1 Canada Employee Garnishment
PR514 Employee Deduction Master Load
RQ01.1 Requesting Locations
RQ10.1 Requisition
RQ10.2 Account Distribution
RQ10.3 Select and Copy
RQ10.4 Requisition Line Entry Detail
RQ10.5 Substitutes
RQ11.1 Kit Accessories
RQ12.1 Approval Review
RQ13.1 Direct Approval
RQ13.2 Direct Line Approval
RQ35.1 Requisition Returns
RQ44.1 Requisition Inquiry
RQ500 Requisition Interface
RQ810 Request Location Load
RQIB.1 RQRQHUPD Invoke Object
RQIF.1 RQRLNUPD Invoke Object
RQII.1 Invoke for Reqheader Inquiry
RQIJ.1 Requisition Copy
TX101 Journal File Create
TX226 Purchasing and Sales Journal
WH130 Pick List Print
WH132 Batch Feedback
WH190 Shipment Release
WH20.2 Nonstock and Special Allocation
WH20.7 Substitute Location
WH222 Shipments In Process
WH30.1 Picking Feedback by Document
WH30.2 Picking Feedback by Shipment
WH30.3 Picking by Batch
WH30.4 Bin Sequence Picking Feedback
WH31.1 Packing Feedback by Document
WH31.2 Packing Feedback by Shipment
WH31.3 Packing by Batch
WH31.4 Bin Sequence Packing Feedback
WH32.1 Shipping Feedback by Document
WH32.2 Shipping Feedback by Shipment
WH32.3 Shipping by Batch
WH32.4 Bin Sequence Shipping Feedback
WH32.5 Shipping Line Feedback
WH33.1 Bins
WH33.2 Lots
WH33.3 Serials
WH33.4 UOMs
WH33.5 Additional Shipment Information
WH33.6 Catch Weight
WH33.8 Preassembled Kits
WH33.9 Line Options
WH34.1 Component Bins
WH34.2 Component Lots
WH34.3 Component Serials
WH34.4 Component UOMs
WH40.1 Bill of Lading
WH40.2 Bill of Lading Feedback
WH520 Batch Feedback Interface
WH830 Shipment Load Program

Referenced by (127)

AC160 Asset Management Interface
AM115 Mass Additions
AM117 Mass Distribution Split
AM15.1 Single Invoice Interface
AM15.2 Combine Invoice Interface
AM15.3 Single Activity Interface
AM15.4 Combine Activity Interface
AM19.1 PO Line Asset Detail
AM19.2 Create Detail
AM19.4 Asset Book Filter
AM20.1 Quick Addition
AM20.3 Items
AM21.1 Leased Asset Quick Addition
AM21.3 Items
AM22.1 Items
AM500 Asset Management Interface
AM51.1 Item Update Adjust Interface Maint
AM551 Item Update Adjustment Interface
AM97.1 Item Interface Adjustment
AP00.4 Company
AP01.1 Pay Group
AP03.3 Query List Members
AP100 Vendor Group Copy
AP109 Vendor Current Address Update
AP110 Mass Vendor Update
AP111 Vendor Deletion
AP135 Vendor, Invoice Audit Report
AP14.1 Vendor Contact
AP14.2 Vendor Contact Address
AP14.5 1099 Tax Identification Information
AP141 Mass Invoice Hold
AP151 Bill of Exchange Generation
AP155 Payment Forms Creation
AP156 Bill of Exchange Creation
AP16.1 Vendor Bank
AP16.2 Vendor Location Bank
AP161 Electronic Payment File Creation
AP175 Invoice Distribution Closing
AP176 Match Discount Accrual
AP178 Paid Invoice Activity Update
AP197 Vendor Balance Rebuild
AP210 Vendor Listing
AP211 Vendor Invoicing
AP212 Comments Listing
AP213 Vendor Account Balance
AP220 Invoice Edit Report
AP230 Open Payables Report
AP233 Retainage Invoice Listing
AP235 Incoming Invoice Register
AP237 Distribution Approval Listing
AP240 Hold Payments Report
AP245 Reportable Income Report
AP246 Secondary Withholding Report
AP250 Cash Forecasting
AP252 Unmatched Invoice Listing
AP255 Bank Account Payment History
AP270 Vendor Payment History
AP271 Vendor Spend Report
AP272 Accounts Payable Tax Exempt Transaction Report
AP275 Invoice Distribution History
AP282 French DAS2 Preparation Report
AP284 Vendor Grand Livre
AP295 Invoice Processing Statistics
AP40.1 Invoice Hold Selection
AP56.2 Bill of Exchange Invoice Application
AP590 AP Vendor CSV
AP90.1 Invoice Search by Vendor, Invoice
AP90.2 Invoice Search by Invoice Date
AP90.3 Invoice Search by Voucher
AP90.4 Invoice Search by Purchase Order
AP91.1 Vendor Activity
AP92.1 Vendor Invoices
AP92.2 Pay Group Invoices
AP95.1 Invoice Distributions
AP97.2 Retainage Invoice Inquiry By Purchase Order
APBD.1 AP BOD Maintenance
APBD.2 AP BOD Inquiry
APCP.1 APC Comments
APH1.1 APC Comments
API4.1 Vendor Master Invoke
API6.3 Invoice Comments Create
CB00.1 Bank
CB06.2 Bank Statement Detail Entry
CB10.1 Cash Receipt Deposit
CB150 Mass Release
EE20.1 Employee Advance
EE20.2 Employee Expense
EE20.4 Employee Payback
EE230 Expense or Advance Report
EE30.1 Expense and Advance Matching
EE90.1 Advance Inquiry
EE90.2 Expense Inquiry
IC840 Cart Par Location Conversion
MA00.1 Match Table
MA167 Smart Recon queue Build
MA236 Invoiced, Not Received Report
MA26.1 PO Invoice Match
MA279 Invoice AOC Detail Report
MA63.1 Invoice Line Match
MA69.1 AOC Level Detail Match
MA69.2 AOC Level Selections
MA90.1 Match Analysis
MA90.2 All Transactions for Invoice
MA90.3 Match Analysis Details
MA90.5 Misc AOC for an Invoice
MA90.6 Summarization
MM280 Departmental Procurement Expense Report
MM80.1 Departmental Procurement Expense Inquiry Selection
MM80.2 Departmental Procurement Expense Inquiry Detail
MX123 List Member Build
MX500 Attribute Value Population
PD235 P-Card Merchant Report
PO135 Received, Not Invoiced Report
PO139 Standard Cost Calculation
PO192 PO Vendor Item Audit Report
PO195 PO Vendor Agreement Audit Report
PO223 Buyer Expediting Report
PO233 PO Received Quantity Exceptions
PO253 Item Receipt Volume Report
PO254 PO Inquiry Report
PO278 RNI Aging Report
PO529 PO Receiving File Create
PO58.2 Receipt Inquiry
POA3.1 Data Load for Vendor Analysis
PR277 Garnishment History Report
RQ260 Requisitioned Items Report
ZA161 Electronic Payment File Creation

APINVOICE – Accounts Payable Invoice

About APINVOICE

Fields (187) Copy as SQL

Indexes (14)

Relations

One to one (31) — lookups and parents

One to many (28) — child tables

Programs

Updated by (290)

Referenced by (127)

Fields (187)