Accounts Payable Invoice
The Accounts Payable Invoice file contains accounts payable invoice records. Each record has one or more associated records in the Invoice Payment File.
REFERENCED BY
| AP151 | AP155 | AP156 | AP160 | AP161 | AP175 |
| AP176 | AP178 | AP197 | AP211 | AP230 | AP237 |
| AP245 | AP250 | AP255 | AP270 | AP272 | AP275 |
| AP282 | AP40.1 | AP56.2 | APCP.1 | APH1.1 | CB06.2 |
| EE30.1 | EE90.1 | EE90.2 | MA540 | PO64.1 | MM280 |
| AP236 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| API-COMPANY Element: Company | Numeric 4 The company associated with the invoice. Must be a valid record in the Accounts Payable Company file. |
|||||||||||||||||||||||||||||
| API-VENDOR Element: Vendor ID | Alpha 9 (Right Justified) The invoiced vendor number. Must be a valid record in the Vendor file. |
|||||||||||||||||||||||||||||
| API-INVOICE Element: Invoice Number | Alpha 22 The invoice number. Must be a unique invoice number for the vendor. |
|||||||||||||||||||||||||||||
| API-SUFFIX Element: Invoice 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. |
|
||||||||||||||||||||||||||||
| API-CANCEL-SEQ Element: Seq Nbr | Numeric 4 The sequence number assigned upon the cancellation of a distributed invoice. The first sequence assigned is 9999. |
|
||||||||||||||||||||||||||||
| API-CANCEL-DATE Element: Cancel Date | Numeric 8 (yyyymmdd) The cancellation date assigned to a canceled invoice. |
|
||||||||||||||||||||||||||||
| API-BATCH-NUM Element: Batch Nbr | Numeric 6 The batch number associated with the invoice. Used only if the company has Yes selected in the Batch Release Option field. |
|||||||||||||||||||||||||||||
| API-BATCH-DATE Element: Batch Date | Numeric 8 (yyyymmdd) The batch date assigned to the batch number. Must be a valid record in the Batch file. |
|||||||||||||||||||||||||||||
| API-VOUCHER-NBR Element: 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. |
|||||||||||||||||||||||||||||
| API-AUTH-CODE Element: 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. |
|||||||||||||||||||||||||||||
| API-PROC-LEVEL Element: Process Level | Alpha 5 The process level assigned to the invoice. Must be a valid record in the Accounts Payable Process Level file. |
|||||||||||||||||||||||||||||
| API-ACCR-CODE Element: Invoice Accrual 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. |
|||||||||||||||||||||||||||||
| API-INVOICE-TYPE Element: Invoice Type | Alpha 1 Identifies the type of invoice. Valid values are: Blank = Invoice. Increases the amount owed to the vendor. If the invoice is fully processed, the vendor's purchase and payment balances will be increased. C = Credit Memo. Reduces the amount owed to the vendor. If the invoice is fully processed, the vendor's purchase and payment balances will be decreased. D = Debit Memo. Processed just like an invoice. Increase the vendor's purchase and payment balances. P = Prepayment. Processed just like an invoice. Used to pay a vendor for goods or services not yet received. Y = Prepayment Credit Memo. Created by AP170 (Payment Closing) to offset a prepayment and are applied to the vendor's invoice after it has been received. A = Employee Advance. Processed just like an invoice. Used to pay an employee for expenses not yet incurred. M = Employee Advance Credit Memo. Created by Payment Closing (AP170) to offset an employee advance. Can be applied to the employee's expense after it has been received. E = Employee Expense. Processed just like an invoice. R = Match Prepayment |
|||||||||||||||||||||||||||||
| API-INV-CURRENCY Element: Invoice 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. |
|||||||||||||||||||||||||||||
| API-PAY-CURRENCY Element: To Base Curr | Alpha 5 The currency used to pay the invoice. Must be a valid record in the Currency Code file. |
|||||||||||||||||||||||||||||
| API-INVOICE-DTE Element: Invoice Date | Numeric 8 (yyyymmdd) The date assigned to the invoice. Used when updating the vendor's purchase balance. If left blank, the system date defaults. |
|||||||||||||||||||||||||||||
| API-PURCH-FR-LOC Element: Purch Fr Loc | Alpha 4 The purchase-from location code associated with the invoice. Must be a valid record in the Vendor Location file. |
|||||||||||||||||||||||||||||
| API-PO-NUMBER Element: Po Number | Alpha 14 (Right Justified) This field contains the number representing the purchase order. |
|||||||||||||||||||||||||||||
| API-PO-RELEASE Element: 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. |
|||||||||||||||||||||||||||||
| API-PO-CODE Element: Purchase Order Code | Alpha 4 Purchase order number code. Used to keep purchase orders unique. Can be used for reporting purposes. |
|||||||||||||||||||||||||||||
| API-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The invoice description. |
|||||||||||||||||||||||||||||
| API-BASE-INV-AMT Element: Base Invoice Amount | 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. |
|||||||||||||||||||||||||||||
| API-BASE-ACT-AMT Revalued Base Invoice Amount | 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. |
|||||||||||||||||||||||||||||
| API-BASE-ND Element: Base Nd | Numeric 1 The number of decimal places defined for the company base currency. |
|||||||||||||||||||||||||||||
| API-TRAN-INV-AMT Element: Intl Amt | Signed 18.2 The amount of the invoice in the currency of the invoice. |
|||||||||||||||||||||||||||||
| API-TRAN-ALOW-AMT Element: Intl 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. |
|||||||||||||||||||||||||||||
| API-TRAN-TXBL-AMT Element: Intl Amt | Signed 18.2 The taxable amount of the invoice in the currency of the invoice. |
|||||||||||||||||||||||||||||
| API-TRAN-ND Element: Acct Nd | Numeric 1 The number of decimal places defined for the invoice currency. |
|||||||||||||||||||||||||||||
| API-TRAN-TAX-AMT Element: Intl Amt | Signed 18.2 The tax amount of the invoice in the currency of the invoice. |
|||||||||||||||||||||||||||||
| API-BASE-DISC-AMT Element: Intl Amt | Signed 18.2 The discount amount of the invoice in the company base currency. |
|||||||||||||||||||||||||||||
| API-TRAN-DISC-AMT Element: Intl Amt | Signed 18.2 The discount amount of the invoice in the currency of the invoice. |
|||||||||||||||||||||||||||||
| API-BASE-TOT-PMT Base Total Payment Amount | Signed 18.2 The total payment amount created for the invoice in the company base currency. |
|||||||||||||||||||||||||||||
| API-TRAN-TOT-PMT Element: Intl Amt | Signed 18.2 The total payment amount created for the invoice in the currency of the invoice. |
|||||||||||||||||||||||||||||
| API-BASE-TOT-DIST Base Total Distribution Amount | Signed 18.2 The total distribution amount of the invoice in the company base currency. |
|||||||||||||||||||||||||||||
| API-TRAN-TOT-DIST Element: Intl Amt | Signed 18.2 The total distribution amount of the invoice in the currency of the invoice. |
|||||||||||||||||||||||||||||
| API-TRAN-TOT-TAX Element: Intl Amt | Signed 18.2 The total tax amount of the invoice in the currency of the invoice. |
|||||||||||||||||||||||||||||
| API-TRAN-TOT-TXBL Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||
| API-TRAN-PAID-AMT Element: Intl Amt | Signed 18.2 The total amount of the invoice paid to date in the currency of the invoice. |
|
||||||||||||||||||||||||||||
| API-ORIG-CNV-RATE Element: Acct 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. |
|||||||||||||||||||||||||||||
| API-ANTICIPATION Element: 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. |
|||||||||||||||||||||||||||||
| API-DISCOUNT-RT Element: Discount Rt | Percent 5.3 (Percent) The discount rate used to calculate the discount amount of the invoice. |
|||||||||||||||||||||||||||||
| API-DISC-DATE Element: Date | Numeric 8 (yyyymmdd) The discount date of the invoice. Used to determine whether a discount will be taken on an invoice. |
|||||||||||||||||||||||||||||
| API-DUE-DATE Element: Due Date | Numeric 8 (yyyymmdd) The invoice due date. Used to schedule the invoice for payment. |
|||||||||||||||||||||||||||||
| API-NBR-SPLIT-PMT Element: Nbr Of Invcs | Numeric 3 Used for split payment invoices to indicate the total number of payments to be made for the invoice. |
|
||||||||||||||||||||||||||||
| API-SPLIT-PMT-SCH Element: 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. |
|
||||||||||||||||||||||||||||
| API-NBR-RECUR-PMT Element: Nbr Of Invcs | Numeric 3 Used for recurring invoices to indicate the number of times the invoice will recur. |
|
||||||||||||||||||||||||||||
| API-RECUR-FREQ Element: 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 |
|
||||||||||||||||||||||||||||
| API-REMIT-TO-CODE Element: Remit To Code | Alpha 4 The remit-to location code associated with the invoice. Must be a valid record in the Vendor Location file. |
|||||||||||||||||||||||||||||
| API-CASH-CODE Element: 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. |
|||||||||||||||||||||||||||||
| API-BANK-INST-CODE Element: Payment 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. |
|||||||||||||||||||||||||||||
| API-CURR-RECALC Currency Recalculation | 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. |
|||||||||||||||||||||||||||||
| API-TAX-CODE Element: 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. |
|||||||||||||||||||||||||||||
| API-INCOME-CODE Element: 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. |
|
||||||||||||||||||||||||||||
| API-DIST-CODE Element: 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. |
|
||||||||||||||||||||||||||||
| API-REC-STATUS Element: Rec Status | Numeric 1 The status of the invoice record. Valid values are: 0 = Unreleased. Not available for payment. 1 = Released. Available for payment. 9 = Historical. Paid and closed. |
|||||||||||||||||||||||||||||
| API-CREATE-DATE Element: Create Date | Numeric 8 (yyyymmdd) The date the invoice was created in the Lawson Accounts Payable system. |
|||||||||||||||||||||||||||||
| API-DISTRIB-DATE Element: Post Date | Numeric 8 (yyyymmdd) The date used for posting invoice distributions to the general ledger. |
|||||||||||||||||||||||||||||
| API-OPERATOR Element: Operator | Alpha 10 The operator associated with the invoice. |
|||||||||||||||||||||||||||||
| API-CREATION-TIME Element: Creation Time | Numeric 6 (hhmmss) The time the invoice was created in the Lawson Accounts Payable system. |
|||||||||||||||||||||||||||||
| API-VENDOR-GROUP Element: Vendor Group | Alpha 4 The vendor group associated with the invoice. Must be a valid record in the Vendor Group file. |
|||||||||||||||||||||||||||||
| API-PAY-VENDOR Element: 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. |
|||||||||||||||||||||||||||||
| API-PAY-GROUP Element: 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. |
|||||||||||||||||||||||||||||
| API-INVOICE-GROUP Element: 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. |
|||||||||||||||||||||||||||||
| API-LAST-DIST-SEQ Element: Dist Seq Nbr | Numeric 6 Used by the system to track the number of the last distribution line created for the invoice. |
|||||||||||||||||||||||||||||
| API-LAST-PMT-SEQ Element: Seq Nbr | Numeric 4 Used by the system to track the last payment record number used for the invoice. |
|||||||||||||||||||||||||||||
| API-DISCOUNT-CODE Element: 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. |
|||||||||||||||||||||||||||||
| API-INVOICE-SOURCE Element: 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 |
|
||||||||||||||||||||||||||||
| API-INVC-REF-TYPE Invoice Reference 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. |
|
||||||||||||||||||||||||||||
| API-APPROVED-FLAG Element: 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 |
|||||||||||||||||||||||||||||
| API-APPRV-OPERATOR Element: Operator | Alpha 10 If the invoice required approval, this field contains the operator that approved the invoice. |
|
||||||||||||||||||||||||||||
| API-RETURN-NUMBER Element: Return Number | Numeric 10 If the goods associated with the invoice were returned, this field contains the optional return number assigned to the return. |
|
||||||||||||||||||||||||||||
| API-JRNL-BOOK-NBR Element: Jrnl Book Nbr | Alpha 12 The journal book assigned to the transaction. |
|||||||||||||||||||||||||||||
| API-TAX-POINT Element: 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 |
|
||||||||||||||||||||||||||||
| API-OBJ-ID Element: Object 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. |
|||||||||||||||||||||||||||||
| API-RECON-DATE Element: Recon Date | Numeric 8 (yyyymmdd) Represents the date the transaction cleared the bank or was voided. |
|
||||||||||||||||||||||||||||
| API-POD-PRINTED Proof of Delivery Printed | Numeric 1 Indicates is a proof of delivery has been printed for this invoice. Valid values are: Y = Yes " " = No |
|||||||||||||||||||||||||||||
| API-MATCH-REF-NBR Match Reference Number | Alpha 22 Matching reference number. This is a user defined number used for matching. |
|||||||||||||||||||||||||||||
| API-MATCH-FL Element: Match Invoice Flag | Alpha 1 Indicates if the invoice is a match invoice. A = AOC Invoice Y = PO Invoice N = Exp Invoice |
|||||||||||||||||||||||||||||
| API-TERMS-CD Element: Term Code | Alpha 5 Invoice payment terms code. |
|||||||||||||||||||||||||||||
| API-RCPT-INV-DATE Receipt of Invoice Date | Numeric 8 (yyyymmdd) The date the invoice was received. If left blank, the system date defaults. |
|||||||||||||||||||||||||||||
| API-RETAIL-AMT Element: Retail Amount | Signed 18.2 The retail amount of the item. |
|||||||||||||||||||||||||||||
| API-MATCH-STATUS Element: 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) |
|||||||||||||||||||||||||||||
| API-REASON-CODE Element: Reason Code | Alpha 4 This field contains the reason code, which indicates the cause for credit memos. |
|||||||||||||||||||||||||||||
| API-HANDLING-CODE Invoice Handling Code | Alpha 4 Invoice handling code. The invoice handling code contains processing rules for invoice matching. |
|||||||||||||||||||||||||||||
| API-MATCH-AMT Element: Match Amount | Signed 18.2 Match amount. Represents the goods amount on which the invoice will match to a receipt. |
|||||||||||||||||||||||||||||
| API-AOC-ALLOW-AMT Element: Add On Cost Amount | Signed 18.2 Add on cost amount. |
|||||||||||||||||||||||||||||
| API-LOCATION Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
|||||||||||||||||||||||||||||
| API-MATCH-OBJ-ID Element: Match Object ID | Numeric 12 A system generated matching object identifier. |
|
||||||||||||||||||||||||||||
| API-CBPRINT-FL Element: Print Chargebacks | Alpha 1 Indicates whether to print chargebacks. N = No Y = Yes " " = spaces |
|||||||||||||||||||||||||||||
| API-MATCH-TABLE Element: Match Table | Alpha 10 Match table. Contains matching and match processing rules. |
|||||||||||||||||||||||||||||
| API-TAX-CODE-CNTL Element: Tax Code Control | 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 6 = ignore tax tol ovr goods tax 7 = ignore tax tol ovr goods/aoc t |
|||||||||||||||||||||||||||||
| API-LAST-MATCH-LN Element: Last Match Line | Numeric 4 Last matched line number. |
|||||||||||||||||||||||||||||
| API-MATCH-LEVEL Element: Match Level | Alpha 3 Indicates whether the invoice was matched at the invoice or detail level. |
|
||||||||||||||||||||||||||||
| API-MATCH-DATE Element: Match Date | Numeric 8 (yyyymmdd) The date the invoice was matched. |
|
||||||||||||||||||||||||||||
| API-PO-INV-TAX Element: Invoiced 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. |
|||||||||||||||||||||||||||||
| API-BYPASS-MATCH Element: All Flag | Alpha 1 |
|||||||||||||||||||||||||||||
| API-SERVICE-FL Element: Service Fl | Alpha 1 This field indicates a transaction is a Service only transaction. Y = Yes N = No |
|
||||||||||||||||||||||||||||
| API-SERVICE-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||
| API-BUYER Element: Buyer | Alpha 3 |
|
||||||||||||||||||||||||||||
| API-FINAL-DST-FLAG Element: Final Dst Flag | Alpha 1 |
|
||||||||||||||||||||||||||||
| API-NOTC Element: Notc | Alpha 2 The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance). |
|
||||||||||||||||||||||||||||
| API-STAT-PROC Element: Stat Proc | Alpha 6 The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance). |
|
||||||||||||||||||||||||||||
| API-SHIP-VIA Element: Ship Via | Alpha 12 (Lower Case) |
|
||||||||||||||||||||||||||||
| API-UNLOADING-PORT Element: Unloading Port | Alpha 5 The prot where the goods are unloaded if required. Must be defined in IN04.1 (Port Maintenance) |
|
||||||||||||||||||||||||||||
| API-INTRASTAT-NBR Element: Intrastat Nbr | Numeric 12 The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added. |
|
||||||||||||||||||||||||||||
| API-DROPSHIP-FL Element: 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. |
|
||||||||||||||||||||||||||||
| API-FOB-CODE Element: Fob Code | Alpha 3 The user defined Free On Board Code. |
|
||||||||||||||||||||||||||||
| API-NET-PAYABLE Element: Net Apyable | Derived The net payment amount in the currency of the invoice. |
|
||||||||||||||||||||||||||||
| API-JBK-SEQ-NBR Element: 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). |
|||||||||||||||||||||||||||||
| API-DIVERSE-CODE Element: Diverse Code | Alpha 5 Diversity Code for Account Payable Vendors |
|
||||||||||||||||||||||||||||
| API-FLEX-FLAG Element: Flex Flag | Alpha 1 |
|
||||||||||||||||||||||||||||
| API-RULE-GROUP Element: Rule Group | Alpha 10 This is the rule group entered on the AP20 invoice entry screen. |
|||||||||||||||||||||||||||||
| API-FLOAT-DAYS Element: 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 Element: Mtch Prepay Fl | Alpha 1 Flag that notes if the invoice will be prepaid. This is for match invoices. " " = Blank 1 = Yes 2 = No |
|
||||||||||||||||||||||||||||
| API-MTCH-PREPAY-MT Element: Mtch Prepay Mt | Numeric 1 Flag denotes the method of match prepayment. 0 = No 1 = Prepay from Invoice 2 = Eligible for Prepayment |
|
||||||||||||||||||||||||||||
| API-PREPAY-DATE Element: Prepay Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||||||
| API-PRPY-DISC-CODE Element: Prpy Disc Code | Alpha 10 |
|
||||||||||||||||||||||||||||
| API-PRPY-REF-NBR Element: Prpy Ref Nbr | Alpha 22 |
|
||||||||||||||||||||||||||||
| API-PRPY-RTL-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||
| API-PRPY-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||
| API-PRPY-AOC-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||
| API-PRPY-TAX-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||
| API-PRPY-SERV-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||
| API-COCO-FL Element: 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) |
|
||||||||||||||||||||||||||||
| API-MATCH-AOC Element: Intl Amt | Signed 18.2 This is the amount of the AOC that has been matched. |
|
||||||||||||||||||||||||||||
| API-HASH-QTY Element: 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. |
|
||||||||||||||||||||||||||||
| API-XREF-VENDOR Element: 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 Element: 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 |
|
||||||||||||||||||||||||||||
| API-BT-AMT Element: Intl Amt | Signed 18.2 This is the amount of the discount based on best terms |
|
||||||||||||||||||||||||||||
| API-DISC-POINT Element: 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 |
|
||||||||||||||||||||||||||||
| API-TAX-FLAG Element: All Flag | Alpha 1 " " = Not interfaced I = Interfaced |
|
||||||||||||||||||||||||||||
| API-TAX-OUT-BAL Element: 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 Element: Txb Out Bal | Derived Derived field to show difference between header taxable input and total taxable amount from distributions. |
|
||||||||||||||||||||||||||||
| API-PMT-OUT-BAL Element: 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 Element: 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 of Balance Indicator | Derived Indicates whether the invoice is out-of-balance. Valid values are: N = No. Y = Yes. |
|
||||||||||||||||||||||||||||
| API-INV-STATUS Element: Inv Status | Derived Indicates the status of the invoice. Valid values are: Unreleased. Released. Historical. |
|
||||||||||||||||||||||||||||
| API-REV-SIGN-AMT Reversed Signed Amount | Derived The invoice amount * -1. |
|
||||||||||||||||||||||||||||
| API-TYPE-SHORT-NME Short Invoice Type Name | Derived The translation of the invoice type. |
|
||||||||||||||||||||||||||||
| API-PO-RELEASE-3 Purchase Order Release Number | 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 Element: Chargeback Fl | Alpha 1 |
|
||||||||||||||||||||||||||||
| API-ORIGIN-COUNTRY Element: 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 Element: 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 Element: Dest Country | Alpha 2 The country to which the goods were shipped. Must be a valid country in IN01.1 (Country Maintenance). |
|
||||||||||||||||||||||||||||
| API-DEST-REGION Element: 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 Element: Transport Mode | Alpha 1 The mode of transportation at the border crossing. Code 7 is used for the Channel Tunnel. |
|
||||||||||||||||||||||||||||
| API-STATEMENT Element: Invoice | Alpha 22 Used to identify the invoice. |
|
||||||||||||||||||||||||||||
| API-CONTRACT-GROUP Element: Enterprise Grp | Alpha 4 |
|
||||||||||||||||||||||||||||
| API-CM-CONTRACT Element: Cm Contract | Numeric 15 |
|
||||||||||||||||||||||||||||
| API-REBATE-TYPE Element: Rebate Type | Alpha 25 |
|
||||||||||||||||||||||||||||
| API-REBATE-DUE-DTE Element: Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||||||
| API-MTCH-PROC-TYPE Element: Mtch Proc Type | Alpha 2 R = Receipt Match S = Service A = AOC only D = Drop Ship V = Vendor Agreement E = Expense |
|||||||||||||||||||||||||||||
| API-RET-ACCR-CODE Element: Accr Code | Alpha 4 |
|
||||||||||||||||||||||||||||
| API-RET-TRAN-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||
| API-RET-BASE-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||
| API-RET-TRAN-PMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||
| API-RET-BASE-PMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||
| API-REF-INV-FL Element: Flag | Alpha 1 Y = One or More Memos exist " " = No Memos exist |
|
||||||||||||||||||||||||||||
| API-TAX-TYPE Element: Tax Type | Alpha 1 I = Invoiced A = Accrued |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| APISET1 |
COMPANY VENDOR INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
| APISET10 |
COMPANY RECON-DATE ACCR-CODE INV-CURRENCY VENDOR INVOICE SUFFIX CANCEL-SEQ REC-STATUS |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
| APISET11 |
COMPANY VENDOR MATCH-REF-NBR OBJ-ID |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
| APISET13 |
COMPANY VENDOR MATCH-OBJ-ID INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
| APISET14 |
COMPANY VENDOR DUE-DATE INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
| APISET2 |
COMPANY BATCH-NUM AUTH-CODE VOUCHER-NBR VENDOR INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
| APISET3 |
REC-STATUS COMPANY BATCH-NUM AUTH-CODE OPERATOR CREATE-DATE CREATION-TIME VENDOR INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
| APISET4 |
COMPANY VOUCHER-NBR REC-STATUS VENDOR INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
| APISET5 |
VENDOR-GROUP VENDOR INVOICE SUFFIX CANCEL-SEQ COMPANY |
|
|||||||||||||||||||||||||||||||||||||||||||||||
| APISET6 |
COMPANY VENDOR INVOICE-DTE* INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
| APISET7 |
COMPANY REC-STATUS BATCH-NUM VENDOR INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
| APISET8 |
COMPANY DUE-DATE VENDOR INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
| APISET9 |
COMPANY VENDOR PO-NUMBER PO-RELEASE PO-CODE LOCATION INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Apauthor | APAUTHOR |
Required
| ||||||||||||||||||||||||||||||||||||
| Apbatch | APBATCH |
Required
| ||||||||||||||||||||||||||||||||||||
| Apcompany | APCOMPANY |
Required
| ||||||||||||||||||||||||||||||||||||
| Apinccode | APINCCODE |
Not Required
| ||||||||||||||||||||||||||||||||||||
| Appayvenaddr | APVENADDR |
Not Required
| ||||||||||||||||||||||||||||||||||||
| Appayvenmast | APVENMAST |
Required
| ||||||||||||||||||||||||||||||||||||
| Approclev | APPROCLEV |
Required
| ||||||||||||||||||||||||||||||||||||
| Apuaval | APUAVAL |
Not Required
| ||||||||||||||||||||||||||||||||||||
| Apvenlocaddr | APVENADDR |
Not Required
| ||||||||||||||||||||||||||||||||||||
| Apvenlocpurch | APVENLOC |
Required
| ||||||||||||||||||||||||||||||||||||
| Apvenlocremit | APVENLOC |
Required
| ||||||||||||||||||||||||||||||||||||
| Apvenmast | APVENMAST |
Required
| ||||||||||||||||||||||||||||||||||||
| Cbcashcode | CBCASHCODE |
Required
| ||||||||||||||||||||||||||||||||||||
| Eeadvance A | EEADVANCE |
Required
| ||||||||||||||||||||||||||||||||||||
| Eeadvance M | EEADVANCE |
Required
| ||||||||||||||||||||||||||||||||||||
| Eeexpense | EEEXPENSE |
Required
| ||||||||||||||||||||||||||||||||||||
| Invusrfld | APINUSRFLD |
Not Required
| ||||||||||||||||||||||||||||||||||||
| Macompany | MACOMPANY |
Not Required
| ||||||||||||||||||||||||||||||||||||
| Mainvhand | MAINVHAND |
Required
| ||||||||||||||||||||||||||||||||||||
| Mamtchrule | MAMTCHRULE |
Required
| ||||||||||||||||||||||||||||||||||||
| Mapool3 | MAPOOLCNT |
Not Required
| ||||||||||||||||||||||||||||||||||||
| Pocompany | POCOMPANY |
Not Required
| ||||||||||||||||||||||||||||||||||||
| Porebdue | POREBDUE |
Required
| ||||||||||||||||||||||||||||||||||||
| Poreceive | PORECEIVE |
Not Required
| ||||||||||||||||||||||||||||||||||||
| Poreturnhd | PORETURNHD |
Not Required
| ||||||||||||||||||||||||||||||||||||
| Povagrmthd | POVAGRMTHD |
Not Required
| ||||||||||||||||||||||||||||||||||||
| Purchorder | PURCHORDER |
Not Required
| ||||||||||||||||||||||||||||||||||||
| Reasoncd | MAREASONCD |
Not Required
| ||||||||||||||||||||||||||||||||||||
| Taxcode | TXTAXCODE |
Not Required
| ||||||||||||||||||||||||||||||||||||
| Txcompany | TXCOMPANY |
Not Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Apaudit | APAUDIT |
| ||||||||||||||||||||||||||||||||||||
| Apcrmemo | APCRMEMO |
| ||||||||||||||||||||||||||||||||||||
| Apcrmemo2 | APCRMEMO |
| ||||||||||||||||||||||||||||||||||||
| Apdiscacc | APDISCACC |
| ||||||||||||||||||||||||||||||||||||
| Apdistcode | APDISTCODE |
| ||||||||||||||||||||||||||||||||||||
| Apdistpay | APDISTPAY |
| ||||||||||||||||||||||||||||||||||||
| Apdistrib | APDISTRIB |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
| Appayment | APPAYMENT |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
| Apvencomments2 | APCOMMENTS |
| ||||||||||||||||||||||||||||||||||||
| Apvendiv | APVENDIV |
| ||||||||||||||||||||||||||||||||||||
| Maaocdtl | MAAOCDTL |
| ||||||||||||||||||||||||||||||||||||
| Maaocdtl 2 | MAAOCDTL |
| ||||||||||||||||||||||||||||||||||||
| Mainvdtl | MAINVDTL |
| ||||||||||||||||||||||||||||||||||||
| Mainvdtl 2 | MAINVDTL |
| ||||||||||||||||||||||||||||||||||||
| Mainvmsg | MAINVMSG |
| ||||||||||||||||||||||||||||||||||||
| Mainvref1 | MAINVREF |
| ||||||||||||||||||||||||||||||||||||
| Mainvref2 | MAINVREF |
| ||||||||||||||||||||||||||||||||||||
| Mapoinv | MAPOINV |
Delete Restricted
| ||||||||||||||||||||||||||||||||||||
| Mapool1 | MAPOOLCNT |
| ||||||||||||||||||||||||||||||||||||
| Mapool2 | MAPOOLCNT |
| ||||||||||||||||||||||||||||||||||||
| Match Trans | APINVOICE |
| ||||||||||||||||||||||||||||||||||||
| Pomatchobj | POMATCHOBJ |
| ||||||||||||||||||||||||||||||||||||
| Pomessage | POMESSAGE |
| ||||||||||||||||||||||||||||||||||||
| Por Match Ref | PORECEIVE |
| ||||||||||||||||||||||||||||||||||||
| Porebrecd | POREBRECD |
| ||||||||||||||||||||||||||||||||||||
| Porecline | PORECLINE |
| ||||||||||||||||||||||||||||||||||||
| Poreset9 Ven | PORECEIVE |
| ||||||||||||||||||||||||||||||||||||
| Porset3 | PORECEIVE |
| ||||||||||||||||||||||||||||||||||||
| Porset9 | PORECEIVE |
| ||||||||||||||||||||||||||||||||||||
| Porset9 Ven | PORECEIVE |
|
All trademarks and registered trademarks are the property of their
respective owners.