Invoice Interface

The Invoice Interface file is used by the Invoice Interface program to convert or interface invoice records to the Lawson Accounts Payable system. When you run AP520 (Invoice Interface), the system reads records in this file for conversion or interface into the Accounts Payable Invoice file. When the Invoice Interface records and associated Distribution Interface records are successfully converted or interfaced, the invoice interface records are purged from this file. You can use AP52.1 (Invoice Interface) to add records to this file or maintain records already loaded into this file before conversion or interface to the Lawson Accounts Payable system.
UPDATED BY

AP305	AP52.1	AP52.3	AP52.2	AP52.6	AP520
PR198

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
CVI-COMPANY Element: Company	Numeric 4 Required. The company number. Must be a valid record in the Accounts Payable Company file.	AP52.1 PR198
CVI-VENDOR Element: Vendor	Alpha 9 (Right Justified) Required. The invoiced vendor number. Must be a valid record in the Vendor file. This field may be left blank if the One-Time Vendor field is Yes or if the EDI Number field has a value.	AP52.1 PR198
CVI-EDI-NBR Element: EDI Number	Alpha 15 The electronic data interchange (EDI) number assigned to the vendor.	AP52.1 PR198
CVI-INVOICE Element: Invoice	Alpha 22 Required. A unique invoice number for the vendor.	AP52.1 PR198
CVI-SUFFIX Element: Suffix	Numeric 3 The occurrence value of the invoice. Used to identify the recurrence value of a recurring invoice.	AP52.1 PR198
CVI-BATCH-NUM Element: Batch	Numeric 6 The batch number associated with the invoice. This field is used only for companies that have Yes selected in the Batch Release field. Can be left blank for released (open) or historical status invoice records.	AP52.1 PR198
CVI-VOUCHER-NBR Element: Voucher	Alpha 10 The voucher number associated with the invoice. This field is used only for companies that have Yes selected in the Invoice Approval field. If the company has Yes selected in the Auto Voucher Numbering field, leave this field blank. Can be left blank for released (open) or historical status invoice records.	AP52.1 PR198
CVI-AUTH-CODE Element: Authority Code	Alpha 3 The authority code assigned to the invoice. This field is used only for companies that have Yes selected in the Invoice Approval field. Represents the person or department responsible for approving a registered invoice. Must be a valid record in the Authority Code file.	AP52.1 PR198
CVI-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. This field is required if the company does not have a default process level assigned.	AP52.1 PR198
CVI-ACCR-CODE Element: Invoice Accrual Code	Alpha 4 The invoice accrual code assigned to the invoice. Used to default a general ledger invoice accrual account to the invoice. Must be a valid record in the Invoice Accrual Code file. If left blank, the invoice accrual code assigned to the vendor, if assigned, or the process level defaults.	AP52.1 PR198
CVI-INVOICE-TYPE Element: Invoice Type	Alpha 1 Identifies the type of invoice. Valid values are: Blank = Invoice. Default value. C = Credit Memo. D = Debit Memo.	AP52.1 PR198
CVI-OLD-VENDOR Element: Vendor	Alpha 9 (Right Justified) THIS FIELD IS NOT CURRENTLY USED.	PR198
CVI-INV-CURRENCY Element: To Base Curr	Alpha 5 The currency code representing the currency of the invoice. Must be a valid record in the Currency Codes file. If left blank, the currency defaults from the remit-to location, vendor, vendor class, company (base currency defined in the General Ledger Company file), or pay group (posting company base currency).	AP52.1 PR198
CVI-INVOICE-DTE Element: Invoice Date	Numeric 8 (yyyymmdd) Required. The invoice date. May be the date the vendor created the invoice or the date the invoice was received. Used when updating the vendor's purchase balance.	AP52.1 PR198
CVI-TAX-PNT-DATE Element: Date	Numeric 8 (yyyymmdd) Tax point date is used to update the Lawson Tax system for released (open) and historical status invoices with a tax code.	PR198
CVI-PURCH-FR-LOC Element: Purchase From	Alpha 4 The vendor's purchase-from location. Must be a valid record in the Vendor Location file. If left blank, the normal purchase-from location defined for the vendor defaults.	AP52.1 PR198
CVI-PO-NUMBER Element: Po Number	Alpha 14 (Right Justified) This field contains the number representing the purchase order.	AP52.1 PR198
CVI-PO-RELEASE Element: Po Release	Numeric 4 Used to identify a purchase order release (created from a Blanket or Standing order).	AP52.1 PR198
CVI-PO-CODE Element: Purchase Order Code	Alpha 4 Purchase order number code. Used to keep purchase orders unique. Can be used for reporting purposes.	AP52.1
CVI-AUTO-MATCH Element: Auto Match	Alpha 1 This field is not currently used. The intent of this field will be to receive electronic invoices and automatically match the invoice to the purchase order. Valid values are: Y = Yes. N = No.	PR198
CVI-DESCRIPTION Element: Description	Alpha 30 (Lower Case) The invoice description. This field accepts both upper and lower case entries.	AP52.1 PR198
CVI-BASE-INV-AMT Element: Intl Amt	Signed 18.2 The amount of the invoice in the company base currency. This field is required for non-base currency invoices with an historical status when no currency exchange rate is entered.	AP52.1 PR198
CVI-TRAN-INV-AMT Element: Intl Amt	Signed 18.2 Required. The amount of the invoice in the currency of the invoice.	AP52.1 PR198
CVI-TRAN-ALOW-AMT Element: Intl Amt	Signed 18.2 The amount of the invoice available for discount in the currency of the invoice. If left blank, the Invoice Amount defaults.	AP52.1 PR198
CVI-TRAN-TXBL-AMT Element: Intl Amt	Signed 18.2 The taxable amount of the invoice in the currency of the invoice.	AP52.1 PR198
CVI-TRAN-TAX-AMT Element: Intl Amt	Signed 18.2 The tax amount of the invoice in the currency of the invoice. If left blank and you enter a Taxable Amount and Tax Code for the invoice, the system will calculate this amount.	AP52.1 PR198
CVI-TRAN-DISC-AMT Element: Intl Amt	Signed 18.2 The discount amount of the invoice in the currency of the invoice. If left blank, the Terms Code assigned to the invoice, alternate location (type P or B), or vendor, if assigned, will be used to calculate the discount amount.	AP52.1 PR198
CVI-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 is required for non-base currency invoices with an historical status.	AP52.1 PR198
CVI-ANTICIPATION Element: Anticipate	Alpha 1 Indicates whether anticipation criteria will be used to calculate the discount amount of the invoice. If left blank, this value defaults from the Terms Code assigned to the invoice, alternate location (type P or B), or vendor, if assigned. Valid values are: Y = Yes. N = No.	AP52.1 PR198
CVI-DISCOUNT-RT Element: Discount Rt	Percent 5.3 (Percent) The rate used to calculate the discount amount of the invoice. If left blank, the Terms Code assigned to the invoice, alternate location (type P or B), vendor, or vendor class, if assigned, will be used to calculate due date and discount information.	AP52.1 PR198
CVI-DISC-DATE Element: Date	Numeric 8 (yyyymmdd) The discount date assigned to the invoice. Used by Cash Requirements (AP150) to determine whether a discount will be taken on the invoice. If left blank, the Terms Code assigned to the invoice, alternate location (type P or B), or vendor, if assigned, will be used to calculate due date and discount information.	AP52.1 PR198
CVI-DUE-DATE Element: Due Date	Numeric 8 (yyyymmdd) Required. The invoice due date. Used by AP150 (Cash Requirements) or AP151 (Bill of Exchange Generation) to select the invoice for payment. If left blank, the Terms Code assigned to the invoice, alternate location (type P or B), or vendor, if assigned, will be used to calculate due date and discount information. This field is required if the vendor or location does not have a terms code assigned and you do not assign a terms code to the invoice.	AP52.1 PR198
CVI-NBR-RECUR-PMT Element: Nbr Of Invcs	Numeric 3 Indicates the number of times a recurring invoice is to be recreated by AP170 (Payment Closing). This field is required if you enter a value in the Recurring Frequency field.	AP52.1 PR198
CVI-RECUR-FREQ Element: Recurrence Schedule	Alpha 1 Indicates how often the invoice should recur. The invoice, due, discount, and distribution dates of the invoice will be incremented by this frequency each time AP170 (Payment Closing) creates the next recurrence of the invoice. This field is required if you enter a value in the Number of Recurrences field. Valid values are: W = Weekly. M = Monthly. Q = Quarterly. S = Semiannually. A = Annually.	AP52.1 PR198
CVI-REMIT-TO-CODE Element: Remit To Code	Alpha 4 The remit-to location associated with the invoice. Must be a valid record in the Vendor Location file. If entered, the invoice payment will be remitted the address defined for the remit-to location. If left blank, the normal remit-to location defined for the vendor defaults.	AP52.1 PR198
CVI-CASH-CODE Element: Cash Code	Alpha 4 The cash code assigned to the invoice. Represents a bank account. Must be a valid record in the Cash Code file. If left blank, the cash code assigned to the remit-to location, vendor, vendor class, process level, company, or pay group defaults.	AP52.1 PR198
CVI-SEP-CHK-FLAG Separate Payment Option	Alpha 1 Indicates whether the invoice requires a separate payment form. If left blank, the separate payment option defined for the vendor defaults. Valid values are: Y = Yes. N = No.	AP52.1 PR198
CVI-PAY-IMM-FLAG Pay Immediately Option	Alpha 1 Indicates whether the invoice will be selected for immediate payment regardless of the due date. Valid values are: N = No. Default value. Y = Yes.	AP52.1 PR198
CVI-ENCLOSURE Element: Enclosure Option	Alpha 1 Indicates whether the invoice requires an enclosure with its payment. If you select Yes, you have the option to group payments that require enclosures when you run AP150 (Cash Requirements). Valid values are: N = No. Default value. Y = Yes.	AP52.1 PR198
CVI-CURR-RECALC Currency Recalculation	Alpha 1 Indicates whether the invoice currency should be revalued against the company's base currency at the time of payment to account for currency exchange rate fluctuations. If you select Yes, currency gain or loss transactions may be created for the invoice. If left blank, the revalue option defined for the vendor defaults. Valid values are: N = No. Y = Yes.	AP52.1 PR198
CVI-DISC-LOST-FLG Element: Discount Lost	Alpha 1 For historical status invoices, indicates whether the available discount was lost. Valid values are: N = No. Default value. Y = Yes.	AP52.1 PR198
CVI-TAX-CODE Element: Tax Code	Alpha 10 The tax code assigned to the invoice. Used to calculate the Tax Amount for the invoice based on the tax rates defined for the tax code and to automatically create distribution lines for the applied amounts. Must be a valid record in the Tax Code file. If left blank, you can assign tax codes to individual tax distributions or the tax code defaults from the vendor, if assigned.	AP52.1 PR198
CVI-INCOME-CODE Element: Income Code	Alpha 4 The income code assigned to the invoice. Represents a type of reportable income. Must be valid record in the Income Code file. If left blank, the income code assigned to the vendor or vendor class, if assigned, defaults.	AP52.1 PR198
CVI-HLD-CODE Element: Hold Code	Alpha 4 The hold code assigned to the invoice. Used to prevent the invoice from being scheduled for payment. Must be a valid invoice hold code record in the Hold Code file.	AP52.1 PR198
CVI-DIST-CODE Element: Dist Code	Alpha 9 The distribution code assigned to the invoice. Used to automatically create expense distribution lines for the invoice. Must be a valid record in the Distribution Code file. If left blank, the distribution code assigned to the vendor, if assigned, defaults.	AP52.1 PR198
CVI-TERM-CODE Element: Term Code	Alpha 5 The terms code assigned to the invoice. Used to calculate invoice due date and discount information. Must be a valid record in the Terms Code file. If left blank, the terms code assigned to the location (type B or P) or vendor, if assigned, defaults.	AP52.1 PR198
CVI-REC-STATUS Element: Invoice Status	Numeric 1 Required. The invoice record status. Valid values are: 0 = Unreleased. Invoice not available for payment. 1 = Released (open). Invoice available for payment. 9 = Historical. Invoice paid and closed. Note: If the invoice status is Unreleased, the Distribution Posting Status must be Unreleased. If the invoice status is Released, the Distribution Posting Status must be Unposted or Posted. If the invoice status is Historical, the Distribution Posting Status must be Posted.	AP52.1 PR198
CVI-POSTING-STATUS Distribution Posting Status	Numeric 1 Required. The posting status of associated invoice distributions. Valid values are: 0 = Unreleased. Distributions not available for posting. 1 = Unposted. Distributions available for posting. 9 = Posted. Distributions posted to general ledger. Note: If the Invoice Status is Unreleased, the Distribution Posting Status must be Unreleased. If the invoice status is Released, the Distribution Posting Status must be Unposted or Posted. If the invoice status is Historical, the Distribution Posting Status must be Posted.	AP52.3 PR198
CVI-DISTRIB-DATE Element: Post Date	Numeric 8 (yyyymmdd) The date used for posting invoice distributions to the general ledger. If left blank, either the post date defined for the batch or the invoice date defaults.	AP52.1 PR198
CVI-PAY-VENDOR Element: Pay Vendor	Alpha 9 (Right Justified) The pay vendor for the invoice. Used to send invoice payments to another vendor within the same vendor group. Although payments are sent to the pay vendor, the original or invoiced vendor will accumulate the payment balance; pay vendor balances are not updated. If multiple invoices share the same pay vendor, a single payment form will be created for the pay vendor. The payment remittance lists individual invoiced vendors and invoice numbers included in the payment. Must be a valid record in the Vendor file.	AP52.1 PR198
CVI-TRANS-NBR Element: Payment Number	Alpha 10 (Right Justified) The payment number used to pay the invoice. Required only for historical status invoice records with no payment records. If entered, the Payment Code assigned to the invoice must be a valid cash payment type transaction code record in the Bank Transaction Code file. Note: If you are converting a historical status invoice and want to link associated payment records to the invoice, you must run Bank Transaction Interface (CB500) to convert payment records before you convert associated invoices.	AP52.1 PR198
CVI-BANK-INST-CODE Element: Payment Code	Alpha 3 The bank transaction code associated with the invoice. Represents a type of cash or bill of exchange payment. Required for historical status invoice records. If left blank for an unreleased or released (open) status invoice record, the payment code assigned to the vendor, vendor class, or pay group defaults. Must be a valid cash payment or bill of exchange payment type bank transaction code record in the Bank Transaction Code file.	AP52.1 PR198
CVI-CHECK-DATE Element: Check Date	Numeric 8 (yyyymmdd) The payment date. Valid only for historical status invoice records with no payment (check) records.	AP52.1 PR198
CVI-INVOICE-GROUP Element: Invoice Group	Alpha 4 The invoice group assigned to the transaction. An invoice group is a user-defined character expression that can be assigned to one more invoices. Cash Requirements (AP150) has an option to select all invoices assigned the same invoice group.	AP52.1 PR198
CVI-ONE-TIME-VEND Element: One-Time Vendor	Alpha 1 Indicates whether a one-time vendor record is to be created for the invoiced vendor. Valid values are: N = No. Default value. Y = Yes.	AP52.1 PR198
CVI-VENDOR-VNAME Element: Vendor Name	Alpha 30 (Lower Case) The vendor name. Required only if the One-Time Vendor field = Yes. This field accepts both upper and lower case entries.	AP52.1 PR198
CVI-VENDOR-SNAME Element: Search Name	Alpha 30 The search name for the vendor. Required only if the One-Time Vendor field = Yes. If left blank, the Vendor Name defaults.	AP52.1 PR198
CVI-ADDR1 Element: Address 1	Alpha 30 (Lower Case) The first line of address information for the vendor. Required only if the One-Time Vendor field = Yes. This field accepts both upper and lower case entries.	AP52.1 PR198
CVI-ADDR2 Element: Address 2	Alpha 30 (Lower Case) The second line of address information for the vendor. Used only if the One-Time Vendor field = Yes. This field accepts both upper and lower case entries.	AP52.1 PR198
CVI-ADDR3 Element: Address 3	Alpha 30 (Lower Case) The third line of address information for the vendor. Used only if the One-Time Vendor field = Yes. This field accepts both upper and lower case entries.	AP52.1 PR198
CVI-ADDR4 Element: Address 4	Alpha 30 (Lower Case) The fourth line of address information for the vendor. Used only if the One-Time Vendor field = Yes. This field accepts both upper and lower case entries.	AP52.1 PR198
CVI-CITY-ADDR5 Element: City/Address 5	Alpha 18 (Lower Case) The city or fifth line of address information for the vendor. Used only if the One-Time Vendor field = Yes. This field accepts both upper and lower case entries.	AP52.1 PR198
CVI-STATE-PROV Element: State or Province	Alpha 2 The state or province for the vendor. Used only if the One-Time Vendor field = Yes.	AP52.1 PR198
CVI-POSTAL-CODE Element: Postal Code	Alpha 10 (Lower Case) The postal code for the vendor address. Used only if the One-Time Vendor field = Yes. This field accepts both upper and lower case entries.	AP52.1 PR198
CVI-COUNTY Element: County	Alpha 25 (Lower Case) The county for the company address.	AP52.1
CVI-COUNTRY Element: Country	Alpha 30 (Lower Case) The country for the vendor address. Can also be used for additional information such as attention name. Used only if the One-Time Vendor field = Yes. This field accepts both upper and lower case entries.	AP52.1 PR198
CVI-LEGAL-NAME Element: Legal Name	Alpha 80 (Lower Case) Institution's legal name used on the GM269 and GM272 reports.	AP52.1
CVI-VEN-INC-CODE Element: Income Code	Alpha 4	AP52.1
CVI-TAX-ID Element: Tax ID	Alpha 20	AP52.1
CVI-JRNL-BOOK-NBR Element: Journal Book	Alpha 12 If using journal books, the journal book assigned to the transaction.	AP52.1 PR198
CVI-BANK-CHK-AMT Element: Intl Amt	Signed 18.2 The amount of the invoice payment in the currency of the cash code (bank account). Used for historical status invoices only.	PR198
CVI-BANK-ND Element: Acct Nd	Numeric 1 The number of decimal positions defined for the bank account currency assigned to the cash code. Used for historical status invoices only.	PR198
CVI-BNK-CNV-RATE Element: Acct Rate	Signed 14.7 The currency exchange rate used to convert the invoice currency to the bank account currency. Used for historical status invoices only.	PR198
CVI-DISCOUNT-CODE Element: Discount Code	Alpha 10 The discount code assigned to the invoice. Represents a general ledger discount account. If left blank, the discount code assigned to the vendor, process level, or company defaults. Must be a valid record in the Discount Code file.	AP52.1 PR198
CVI-INVOICE-SOURCE Element: Invoice Source	Alpha 1 Indicates the source for creation of the invoice: manual (default), EDI, ERS. E = EDI R = ERS " " = Manual P = Payroll T = Tax G = Garnishment L = Lease C = AR Transfer S = Sub Contractor	PR198
CVI-INVC-REF-TYPE Element: Invc Ref Type	Alpha 2 Indicates the type of number the vendor is providing to reference the invoice.	AP52.1
CVI-APPROVED-FLAG Element: Approved Flag	Alpha 1 If the invoice requires approval, this field indicates whether the invoice is approved. N = No Y = Yes	AP52.1 PR198
CVI-INC-ACCR-CODE Element: Invoice Accrual Code	Alpha 10 The income withholding code assigned to the invoice. Represents a general ledger income withholding accrual account. If left blank, the income withholding code assigned to the process level or company defaults. Must be a valid record in the Income Withholding Code file.	PR198
CVI-OPERATOR Element: Operator	Alpha 10 This field is used to store the login id of the person who entered the record.
CVI-INV-USR-FLD-01 Element: Invoice User Field 1	Alpha 20 Invoice user field number 1.	AP52.1
CVI-INV-USR-FLD-02 Element: Invoice User Field 2	Alpha 20 Invoice user field number 2.	AP52.1
CVI-INV-USR-FLD-03 Element: Invoice User Field 3	Alpha 20 Invoice user field number 3.	AP52.1
CVI-INV-USR-FLD-04 Element: Invoice User Field 4	Alpha 20 Invoice user field number 4.	AP52.1
CVI-INV-USR-FLD-05 Element: Invoice User Field 5	Alpha 20 Invoice user field number 5.	AP52.1
CVI-HANDLING-CODE Invoice Handling Code	Alpha 4 Invoice handling code. Determines the processing rules for invoice matching.	AP52.1
CVI-RCPT-INV-DATE Receipt of Invoice Date	Numeric 8 (yyyymmdd) The day the invoice was received. If left blank, the system date defaults.	AP52.1
CVI-RECORD-ERROR Element: Record Error	Alpha 1 Indicates if the invoice record has not passed the edit due to errors. Valid values are N = No Y = Yes " "	AP52.1 AP520
CVI-REASON-CODE Element: Reason Code	Alpha 4 Reason code. Indicates the cause for credit memos.	AP52.1
CVI-CBPRINT-FL Element: Print Chargebacks	Alpha 1 Determines whether to print chargebacks. N = No Y = Yes	AP52.1
CVI-RETAIL-AMT Element: Retail Amount	Signed 18.2	AP52.1
CVI-SEGMENT-BLOCK Element: Segment Block	Alpha 103 This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.	AP52.1
CVI-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).	AP52.1
CVI-VAT-REG-CTRY Element: Vat Reg Ctry	Alpha 2 The country component of the VAT Registration Number. This field, together with the Registration Number for the company on the tax transaction.	AP52.1
CVI-VAT-REG-NBR Element: Vat Reg Nbr	Alpha 12 The number component of the VAT Registration Number. This field together with the Registration Country field make up the VAT Registration Number.	AP52.1
CVI-DIVERSE-CODE Element: Diverse Code	Alpha 5 Diversity Code for Account Payable Vendors	AP52.1
CVI-FLEX-FLAG Element: Flex Flag	Alpha 1	AP52.1
CVI-NOTC Element: Notc	Alpha 2 The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).	AP52.1
CVI-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).	AP52.1
CVI-FOB-CODE Element: Fob Code	Alpha 3 The user defined Free On Board Code.	AP52.1
CVI-SHIP-VIA Element: Ship Via	Alpha 12 (Lower Case)	AP52.1
CVI-UNLOADING-PORT Element: Unloading Port	Alpha 5 The prot where the goods are unloaded if required. Must be defined in IN04.1 (Port Maintenance)	AP52.1
CVI-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.	AP52.1
CVI-TRANSPORT-MODE Element: Transport Mode	Alpha 1 The mode of transportation at the border crossing. Code 7 is used for the Channel Tunnel.
CVI-TAX-TYPE Element: Tax Type	Alpha 1 I = Invoice A = Accrued

APCINVOICE FILE INDEX

APCINVOICE FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.