APCINVOICE – Invoice Interface

System: Accounts Payable (AP)
Prefix: CVI
Primary key: COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX
Fields: 127
Updated by: 5 programs
Referenced by: 0 programs

APCINVOICE is the Invoice Interface table in Lawson Accounts Payable (prefix CVI). It is indexed by COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX (CVISET1); alternate indexes: CVISET2, CVISET3, CVISET4 and CVISET5. It is related 1:M to APCDISTRIB, APCINVERR and APCPAYMENT. It is updated by AP305, AP52.1, AP52.3, AP520 and PR198. The table has 127 fields, 5 indexes and 3 documented relations.

About APCINVOICE

No description in the Lawson data dictionary.

Fields (127)

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

Field / column	Type	Description & values	Updated by
`CVI-COMPANY` PK COMPANY	Numeric 4	Required. The company number. Must be a valid record in the Accounts Payable Company file.	AP52.1, PR198
`CVI-VENDOR` PK 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` PK EDI_NBR	Alpha 15	The electronic data interchange (EDI) number assigned to the vendor.	AP52.1, PR198
`CVI-INVOICE` PK INVOICE	Alpha 22	Required. A unique invoice number for the vendor.	AP52.1, PR198
`CVI-SUFFIX` PK 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` BATCH_NUM	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` VOUCHER_NBR	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` AUTH_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` PROC_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` ACCR_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` 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` OLD_VENDOR	Alpha 9 (Right Justified)	THIS FIELD IS NOT CURRENTLY USED.	PR198
`CVI-INV-CURRENCY` INV_CURRENCY	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` INVOICE_DTE	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` TAX_PNT_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` PURCH_FR_LOC	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` PO_NUMBER	Alpha 14 (Right Justified)	This field contains the number representing the purchase order.	AP52.1, PR198
`CVI-PO-RELEASE` PO_RELEASE	Numeric 4	Used to identify a purchase order release (created from a Blanket or Standing order).	AP52.1, PR198
`CVI-PO-CODE` PO_CODE	Alpha 4	Purchase order number code. Used to keep purchase orders unique. Can be used for reporting purposes.	AP52.1
`CVI-AUTO-MATCH` 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` DESCRIPTION	Alpha 30 (Lower Case)	The invoice description. This field accepts both upper and lower case entries.	AP52.1, PR198
`CVI-BASE-INV-AMT` BASE_INV_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` TRAN_INV_AMT	Signed 18.2	Required. The amount of the invoice in the currency of the invoice.	AP52.1, PR198
`CVI-TRAN-ALOW-AMT` TRAN_ALOW_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` TRAN_TXBL_AMT	Signed 18.2	The taxable amount of the invoice in the currency of the invoice.	AP52.1, PR198
`CVI-TRAN-TAX-AMT` TRAN_TAX_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` TRAN_DISC_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` ORIG_CNV_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` ANTICIPATION	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` 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` DISC_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` 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` NBR_RECUR_PMT	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` RECUR_FREQ	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` 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` 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` SEP_CHK_FLAG	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_IMM_FLAG	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` ENCLOSURE	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` CURR_RECALC	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` DISC_LOST_FLG	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` 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` 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` HLD_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` 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` 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` REC_STATUS	Numeric 1	Required. The invoice record status. Valid values are: for payment. for payment. 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. `0` Unreleased. Invoice not available `1` Released (open). Invoice available `9` Historical. Invoice paid and closed.	AP52.1, PR198
`CVI-POSTING-STATUS` POSTING_STATUS	Numeric 1	Required. The posting status of associated invoice distributions. Valid values are: available for posting. for posting. 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. `0` Unreleased. Distributions not `1` Unposted. Distributions available `9` Posted. Distributions posted to	AP52.3, PR198
`CVI-DISTRIB-DATE` DISTRIB_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` 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` TRANS_NBR	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` BANK_INST_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` 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` 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` ONE_TIME_VEND	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` VENDOR_VNAME	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` VENDOR_SNAME	Alpha 30	The search name for the vendor. Required only if the One-Time Vendor Name defaults. `field` Yes. If left blank, the Vendor	AP52.1, PR198
`CVI-ADDR1` ADDR1	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` ADDR2	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` ADDR3	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` ADDR4	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` CITY_ADDR5	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` STATE_PROV	Alpha 2	The state or province for the vendor. Used only if the One-Time Vendor field = Yes.	AP52.1, PR198
`CVI-POSTAL-CODE` 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` COUNTY	Alpha 25 (Lower Case)	The county for the company address.	AP52.1
`CVI-COUNTRY` 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` LEGAL_NAME	Alpha 80 (Lower Case)	Institution's legal name used on the GM269 and GM272 reports.	AP52.1
`CVI-VEN-INC-CODE` VEN_INC_CODE	Alpha 4	—	AP52.1
`CVI-TAX-ID` TAX_ID	Alpha 20	—	AP52.1
`CVI-JRNL-BOOK-NBR` JRNL_BOOK_NBR	Alpha 12	If using journal books, the journal book assigned to the transaction.	AP52.1, PR198
`CVI-BANK-CHK-AMT` BANK_CHK_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` BANK_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` BNK_CNV_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` 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` INVOICE_SOURCE	Alpha 1	Indicates the source for creation of the invoice: manual (default), EDI, ERS. " " = Manual `E` EDI `R` ERS `P` Payroll `T` Tax `G` Garnishment `L` Lease `C` AR Transfer `S` Sub Contractor	PR198
`CVI-INVC-REF-TYPE` INVC_REF_TYPE	Alpha 2	Indicates the type of number the vendor is providing to reference the invoice.	AP52.1
`CVI-APPROVED-FLAG` 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` INC_ACCR_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` OPERATOR	Alpha 10	This field is used to store the login id of the person who entered the record.	—
`CVI-INV-USR-FLD-01` INV_USR_FLD_01	Alpha 20	Invoice user field number 1.	AP52.1
`CVI-INV-USR-FLD-02` INV_USR_FLD_02	Alpha 20	Invoice user field number 2.	AP52.1
`CVI-INV-USR-FLD-03` INV_USR_FLD_03	Alpha 20	Invoice user field number 3.	AP52.1
`CVI-INV-USR-FLD-04` INV_USR_FLD_04	Alpha 20	Invoice user field number 4.	AP52.1
`CVI-INV-USR-FLD-05` INV_USR_FLD_05	Alpha 20	Invoice user field number 5.	AP52.1
`CVI-HANDLING-CODE` HANDLING_CODE	Alpha 4	Invoice handling code. Determines the processing rules for invoice matching.	AP52.1
`CVI-RCPT-INV-DATE` RCPT_INV_DATE	Numeric 8 (yyyymmdd)	The day the invoice was received. If left blank, the system date defaults.	AP52.1
`CVI-RECORD-ERROR` 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` REASON_CODE	Alpha 4	Reason code. Indicates the cause for credit memos.	AP52.1
`CVI-CBPRINT-FL` CBPRINT_FL	Alpha 1	Determines whether to print chargebacks. `N` No `Y` Yes	AP52.1
`CVI-RETAIL-AMT` RETAIL_AMT	Signed 18.2	—	AP52.1
`CVI-SEGMENT-BLOCK` 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` 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` 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` 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` DIVERSE_CODE	Alpha 5	Diversity Code for Account Payable Vendors	AP52.1
`CVI-FLEX-FLAG` FLEX_FLAG	Alpha 1	—	AP52.1
`CVI-NOTC` NOTC	Alpha 2	The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).	AP52.1
`CVI-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).	AP52.1
`CVI-FOB-CODE` FOB_CODE	Alpha 3	The user defined Free On Board Code.	AP52.1
`CVI-SHIP-VIA` SHIP_VIA	Alpha 12 (Lower Case)	—	AP52.1
`CVI-UNLOADING-PORT` 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` 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` TRANSPORT_MODE	Alpha 1	The mode of transportation at the border crossing. Code 7 is used for the Channel Tunnel.	—
`CVI-TAX-TYPE` TAX_TYPE	Alpha 1	— `I` Invoice `A` Accrued	—
`CVI-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	—	AP52.1
`CVI-DEST-COUNTRY` DEST_COUNTRY	Alpha 2	—	—
`CVI-ORIGIN-COUNTRY` ORIGIN_COUNTRY	Alpha 2	—	—
`CVI-FOR-ECON-CODE` FOR_ECON_CODE	Alpha 10	—	AP52.1
`CVI-DISCOUNT-RT1` DISCOUNT_RT1	Percent 5.3 (Percent)	—	—
`CVI-DISCOUNT-RT2` DISCOUNT_RT2	Percent 5.3 (Percent)	—	—
`CVI-DISCOUNT-RT3` DISCOUNT_RT3	Percent 5.3 (Percent)	—	—
`CVI-BASE-DISC-AMT1` BASE_DISC_AMT1	Signed 18.2	—	—
`CVI-BASE-DISC-AMT2` BASE_DISC_AMT2	Signed 18.2	—	—
`CVI-BASE-DISC-AMT3` BASE_DISC_AMT3	Signed 18.2	—	—
`CVI-TRAN-DISC-AMT1` TRAN_DISC_AMT1	Signed 18.2	—	—
`CVI-TRAN-DISC-AMT2` TRAN_DISC_AMT2	Signed 18.2	—	—
`CVI-TRAN-DISC-AMT3` TRAN_DISC_AMT3	Signed 18.2	—	—
`CVI-DISC-DATE1` DISC_DATE1	Numeric 8 (yyyymmdd)	—	—
`CVI-DISC-DATE2` DISC_DATE2	Numeric 8 (yyyymmdd)	—	—
`CVI-DISC-DATE3` DISC_DATE3	Numeric 8 (yyyymmdd)	—	—
`CVI-CARRIER-FLAG` CARRIER_FLAG	Alpha 1	—	AP52.1
`CVI-GLBL-DOC-TYPE` GLBL_DOC_TYPE	Alpha 10	—	AP52.1
`CVI-REF-TYPE` REF_TYPE	Alpha 1	—	AP52.1
`CVI-CUSTOMER-ID` CUSTOMER_ID	Alpha 27	—	AP52.1
`CVI-PMT-CAT-CODE` PMT_CAT_CODE	Alpha 6	—	AP52.1
`CVI-NO-PAY-CONCERN` NO_PAY_CONCERN	Alpha 60	—	—
`CVI-REFERENCE-NO` REFERENCE_NO	Alpha 25 (Right Justified)	—	—

Indexes (5)

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

Index	Keys	Flags	Condition	Used in
`CVISET1`	`COMPANY`, `VENDOR`, `EDI-NBR`, `INVOICE`, `SUFFIX`	Primary		AP305, AP52.1, AP52.2, AP52.3, AP520, PR198
`CVISET2`	`COMPANY`, `BATCH-NUM`, `VENDOR`, `EDI-NBR`, `INVOICE`, `SUFFIX`	KeyChange		AP520
`CVISET3`	`COMPANY`, `VENDOR`, `EDI-NBR`, `INVOICE`, `SUFFIX`	Subset	Where RECORD-ERROR = "Y"	AP52.1, AP52.6, AP520
`CVISET4`	`COMPANY`, `VENDOR`, `EDI-NBR`, `INVOICE`, `SUFFIX`	Subset	Where (RECORD-ERROR != "Y")	AP520
`CVISET5`	`COMPANY`, `BATCH-NUM`, `VENDOR`, `EDI-NBR`, `INVOICE`, `SUFFIX`	KeyChange, Subset	Where (RECORD-ERROR != "Y")	AP520

Relations

One to many (3) — child tables

Relation	Table	Field map
Apcdistrib	APCDISTRIB	`CVI-COMPANY` → `CVD-COMPANY`, `CVI-VENDOR` → `CVD-VENDOR`, `CVI-EDI-NBR` → `CVD-EDI-NBR`, `CVI-INVOICE` → `CVD-INVOICE`, `CVI-SUFFIX` → `CVD-SUFFIX`, → `CVD-DIST-SEQ-NBR`
Apcinverr	APCINVERR	`CVI-COMPANY` → `AER-COMPANY`, `CVI-VENDOR` → `AER-VENDOR`, `CVI-EDI-NBR` → `AER-EDI-NBR`, `CVI-INVOICE` → `AER-INVOICE`, `CVI-SUFFIX` → `AER-SUFFIX`, → `AER-DIST-SEQ`, → `AER-RECORD-TYPE`, → `AER-SEQ-NBR`
Apcpayment	APCPAYMENT	`CVI-COMPANY` → `CVP-COMPANY`, `CVI-VENDOR` → `CVP-VENDOR`, `CVI-EDI-NBR` → `CVP-EDI-NBR`, `CVI-INVOICE` → `CVP-INVOICE`, `CVI-SUFFIX` → `CVP-SUFFIX`, → `CVP-SEQ-NBR`

Programs

Updated by (5)

AP305 Accounts Payable Company Purge
AP52.1 Invoice Interface
AP52.3 Distribution Interface
AP520 Invoice Interface
PR198 General Ledger Posting