Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            APCINVOICE FILE

                           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    AP520     PR198

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CVI-COMPANY          Numeric 4                                   AP52.1  PR198
Company              Required. The company number. Must be a
                     valid record in the Accounts Payable
                     Company file.

CVI-VENDOR           Alpha 9  (Right Justified)                  AP52.1  PR198
Vendor               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.

CVI-EDI-NBR          Alpha 15                                    AP52.1  PR198
EDI Number           The electronic data interchange (EDI)
                     number assigned to the vendor.

CVI-INVOICE          Alpha 22                                    AP52.1  PR198
Invoice              Required. A unique invoice number for
                     the vendor.

CVI-SUFFIX           Numeric 3                                   AP52.1  PR198
Invoice Suffix       The occurrence value of the invoice.
                     Used to identify the recurrence value of
                     a recurring invoice.

CVI-BATCH-NUM        Numeric 6                                   AP52.1  PR198
Batch                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.

CVI-VOUCHER-NBR      Alpha 10                                    AP52.1  PR198
Voucher              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.

CVI-AUTH-CODE        Alpha 3                                     AP52.1  PR198
Authority Code       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.

CVI-PROC-LEVEL       Alpha 5                                     AP52.1  PR198
Process Level        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.

CVI-ACCR-CODE        Alpha 4                                     AP52.1  PR198
Invoice Accrual Code 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.

CVI-INVOICE-TYPE     Alpha 1                                     AP52.1  PR198
Invoice Type         Identifies the type of invoice. Valid
                     values are:

                     Blank = Invoice. Default value.
                     C = Credit Memo.
                     D = Debit Memo.

CVI-OLD-VENDOR       Alpha 9  (Right Justified)                  PR198
Old Vendor ID        THIS FIELD IS NOT CURRENTLY USED.

CVI-INV-CURRENCY     Alpha 5                                     AP52.1  PR198
Invoice Currency     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).

CVI-INVOICE-DTE      Numeric 8  (yyyymmdd)                       AP52.1  PR198
Invoice Date         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.

CVI-TAX-PNT-DATE     Numeric 8  (yyyymmdd)                       PR198
Tax Point Date       Tax point date is used to update the
                     Lawson Tax system for released (open)
                     and historical status invoices with a
                     tax code.

CVI-PURCH-FR-LOC     Alpha 4                                     AP52.1  PR198
Purchase From        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.

CVI-PO-NUMBER        Alpha 14  (Right Justified)                 AP52.1  PR198
PO Number            This field contains the number
                     representing the purchase order.

CVI-PO-RELEASE       Numeric 4                                   AP52.1  PR198
PO Release Number    Used to identify a purchase order
                     release (created from a Blanket or
                     Standing order).

CVI-PO-CODE          Alpha 4                                     AP52.1
Purchase Order Code  Purchase order number code. Used to
                     keep purchase orders unique. Can be used
                     for reporting purposes.

CVI-AUTO-MATCH       Alpha 1                                     PR198
Auto Match           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.

CVI-DESCRIPTION      Alpha 30  (Lower Case)                      AP52.1  PR198
Description          The invoice description. This field
                     accepts both upper and lower case
                     entries.

CVI-BASE-INV-AMT     Signed 15.2                                 AP52.1  PR198
Base Invoice Amount  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.

CVI-TRAN-INV-AMT     Signed 15.2                                 AP52.1  PR198
Invoice Amount       Required. The amount of the invoice in
                     the currency of the invoice.

CVI-TRAN-ALOW-AMT    Signed 15.2                                 AP52.1  PR198
Allowable Amount     The amount of the invoice available for
                     discount in the currency of the invoice.
                     If left blank, the Invoice Amount
                     defaults.

CVI-TRAN-TXBL-AMT    Signed 15.2                                 AP52.1  PR198
Taxable Amount       The taxable amount of the invoice in
                     the currency of the invoice.

CVI-TRAN-TAX-AMT     Signed 15.2                                 AP52.1  PR198
Tax Amount           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.

CVI-TRAN-DISC-AMT    Signed 15.2                                 AP52.1  PR198
Discount Amount      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.

CVI-ORIG-CNV-RATE    Signed 12.6                                 AP52.1  PR198
Exchange Rate        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.

CVI-ANTICIPATION     Alpha 1                                     AP52.1  PR198
Anticipate           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.

CVI-DISCOUNT-RT      Percent 5.3  (Percent)                      AP52.1  PR198
Discount Rate        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.

CVI-DISC-DATE        Numeric 8  (yyyymmdd)                       AP52.1  PR198
Discount Date        The discount date assigned to the
                     invoice. Used by AP150 (Cash
                     Requirements) 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.

CVI-DUE-DATE         Numeric 8  (yyyymmdd)                       AP52.1  PR198
Due Date             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.

CVI-NBR-RECUR-PMT    Numeric 3                                   AP52.1  PR198
Number of            Indicates the number of times a
Recurrences          recurring invoice is to be recreated by
                     AP170 (Payment Closing). This field is
                     required if you enter a value in the
                     Recurring Frequency field.

CVI-RECUR-FREQ       Alpha 1                                     AP52.1  PR198
Recurrence Schedule  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.

CVI-REMIT-TO-CODE    Alpha 4                                     AP52.1  PR198
Remit To Location    The remit-to location associated with
Code                 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.

CVI-CASH-CODE        Alpha 4                                     AP52.1  PR198
Cash Code            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.

CVI-SEP-CHK-FLAG     Alpha 1                                     AP52.1  PR198
Separate Payment     Indicates whether the invoice requires
Option               a separate payment form. If left blank,
                     the separate payment option defined for
                     the vendor defaults. Valid values are:

                     Y = Yes.
                     N = No.

CVI-PAY-IMM-FLAG     Alpha 1                                     AP52.1  PR198
Pay Immediately      Indicates whether the invoice will be
Option               selected for immediate payment
                     regardless of the due date. Valid values
                     are:

                     N = No. Default value.
                     Y = Yes.

CVI-ENCLOSURE        Alpha 1                                     AP52.1  PR198
Enclosure Option     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.

CVI-CURR-RECALC      Alpha 1                                     AP52.1  PR198
Currency             Indicates whether the invoice currency
Recalculation        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.

CVI-DISC-LOST-FLG    Alpha 1                                     AP52.1  PR198
Discount Lost        For historical status invoices,
                     indicates whether the available discount
                     was lost. Valid values are:

                     N = No. Default value.
                     Y = Yes.

CVI-TAX-CODE         Alpha 10                                    AP52.1  PR198
Tax Code             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.

CVI-INCOME-CODE      Alpha 4                                     AP52.1  PR198
Income Code          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.

CVI-HLD-CODE         Alpha 4                                     AP52.1  PR198
Hold Code            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.

CVI-DIST-CODE        Alpha 9                                     AP52.1  PR198
Distribution Code    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.

CVI-TERM-CODE        Alpha 5                                     AP52.1  PR198
Terms Code           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.

CVI-REC-STATUS       Numeric 1                                   AP52.1  PR198
Invoice Status       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.

CVI-POSTING-STATUS   Numeric 1                                   AP52.3  PR198
Distribution         Required. The posting status of
Posting Status       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.

CVI-DISTRIB-DATE     Numeric 8  (yyyymmdd)                       AP52.1  PR198
Post Date            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.

CVI-PAY-VENDOR       Alpha 9  (Right Justified)                  AP52.1  PR198
Pay Vendor           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.

CVI-TRANS-NBR        Alpha 10  (Right Justified)                 AP52.1  PR198
Payment Number       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 CB500 (Bank
                     Transaction Interface) to convert
                     payment records before you convert
                     associated invoices.

CVI-BANK-INST-CODE   Alpha 3                                     AP52.1  PR198
Payment Code         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.

CVI-CHECK-DATE       Numeric 8  (yyyymmdd)                       AP52.1  PR198
Payment Date         The payment date. Valid only for
                     historical status invoice records with
                     no payment (check) records.

CVI-INVOICE-GROUP    Alpha 4                                     AP52.1  PR198
Invoice Group        The invoice group assigned to the
                     transaction. An invoice group is a
                     user-defined character expression that
                     can be assigned to one more invoices.
                     AP150 (Cash Requirements) has an option
                     to select all invoices assigned the same
                     invoice group.

CVI-ONE-TIME-VEND    Alpha 1                                     AP52.1  PR198
One-Time Vendor      Indicates whether a one-time vendor
                     record is to be created for the invoiced
                     vendor. Valid values are:

                     N = No. Default value.
                     Y = Yes.

CVI-VENDOR-VNAME     Alpha 30  (Lower Case)                      AP52.1  PR198
Vendor Name          The vendor name. Required only if the
                     One-Time Vendor field = Yes. This field
                     accepts both upper and lower case
                     entries.

CVI-VENDOR-SNAME     Alpha 30                                    AP52.1  PR198
Search Name          The search name for the vendor.
                     Required only if the One-Time Vendor
                     field = Yes. If left blank, the Vendor
                     Name defaults.

CVI-ADDR1            Alpha 30  (Lower Case)                      AP52.1  PR198
Address 1            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.

CVI-ADDR2            Alpha 30  (Lower Case)                      AP52.1  PR198
Address 2            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.

CVI-ADDR3            Alpha 30  (Lower Case)                      AP52.1  PR198
Address 3            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.

CVI-ADDR4            Alpha 30  (Lower Case)                      AP52.1  PR198
Address 4            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.

CVI-CITY-ADDR5       Alpha 18  (Lower Case)                      AP52.1  PR198
City/Address 5       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.

CVI-STATE-PROV       Alpha 2                                     AP52.1  PR198
State or Province    The state or province for the vendor.
                     Used only if the One-Time Vendor field =
                     Yes.

CVI-POSTAL-CODE      Alpha 10  (Lower Case)                      AP52.1  PR198
Postal Code          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.

CVI-COUNTY           Alpha 25  (Lower Case)                      AP52.1
County               The county for the company address.

CVI-COUNTRY          Alpha 30  (Lower Case)                      AP52.1  PR198
Country              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.

CVI-LEGAL-NAME       Alpha 80  (Lower Case)                      AP52.1
Legal Name

CVI-VEN-INC-CODE     Alpha 4                                     AP52.1
Income Code

CVI-TAX-ID           Alpha 20                                    AP52.1
Tax ID

CVI-JRNL-BOOK-NBR    Alpha 12                                    AP52.1  PR198
Journal Book         If using journal books, the journal
                     book assigned to the transaction.

CVI-BANK-CHK-AMT     Signed 15.2                                 PR198
Bank Payment Amount  The amount of the invoice payment in
                     the currency of the cash code (bank
                     account). Used for historical status
                     invoices only.

CVI-BANK-ND          Numeric 1                                   PR198
Bank Currency Nbr    The number of decimal positions defined
of Decimals          for the bank account currency assigned
                     to the cash code. Used for historical
                     status invoices only.

CVI-BNK-CNV-RATE     Signed 12.6                                 PR198
Bank Currency        The currency exchange rate used to
Exchange Rate        convert the invoice currency to the bank
                     account currency. Used for historical
                     status invoices only.

CVI-DISCOUNT-CODE    Alpha 10                                    AP52.1  PR198
Discount Code        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.

CVI-INVOICE-SOURCE   Alpha 1                                     PR198
Invoice Source       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

CVI-INVC-REF-TYPE    Alpha 2                                     AP52.1
Invoice Reference    Indicates the type of number the vendor
Type                 is providing to reference the invoice.

CVI-APPROVED-FLAG    Alpha 1                                     AP52.1  PR198
Approved             If the invoice requires approval, this
                     field indicates whether the invoice is
                     approved.
                     N = No
                     Y = Yes

CVI-INC-ACCR-CODE    Alpha 10                                    PR198
Invoice Accrual Code 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.

CVI-OPERATOR         Alpha 10
Operator Code        This field is used to store the login
                     id of the person who entered the record.


CVI-INV-USR-FLD-01   Alpha 20                                    AP52.1
Invoice User Field 1 Invoice user field number 1.

CVI-INV-USR-FLD-02   Alpha 20                                    AP52.1
Invoice User Field 2 Invoice user field number 2.

CVI-INV-USR-FLD-03   Alpha 20                                    AP52.1
Invoice User Field 3 Invoice user field number 3.

CVI-INV-USR-FLD-04   Alpha 20                                    AP52.1
Invoice User Field 4 Invoice user field number 4.

CVI-INV-USR-FLD-05   Alpha 20                                    AP52.1
Invoice User Field 5 Invoice user field number 5.

CVI-HANDLING-CODE    Alpha 4                                     AP52.1
Invoice Handling     Invoice handling code. Determines the
Code                 processing rules for invoice matching.

CVI-RCPT-INV-DATE    Numeric 8  (yyyymmdd)                       AP52.1
Receipt of Invoice   The day the invoice was received. If
Date                 left blank, the system date defaults.

CVI-RECORD-ERROR     Alpha 1                                     AP52.1  AP520
Record Error         Indicates if the invoice record has not
                     passed the edit due to errors.

                     Valid values are

                     N = No
                     Y = Yes
                     " "

CVI-REASON-CODE      Alpha 4                                     AP52.1
Reason Code          Reason code. Indicates the cause for
                     credit memos.

CVI-CBPRINT-FL       Alpha 1                                     AP52.1
Print Chargebacks    Determines whether to print chargebacks.
                     N = No
                     Y = Yes

CVI-RETAIL-AMT       Signed 15.2                                 AP52.1
Retail Amount

CVI-SEGMENT-BLOCK    Alpha 103                                   AP52.1
User Analysis        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.

CVI-JBK-SEQ-NBR      Numeric 10                                  AP52.1
Journal Book         The journal book sequence number
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).


CVI-VAT-REG-CTRY     Alpha 2                                     AP52.1
Vat Reg Ctry         The country component of the VAT
                     Registration Number. This field,
                     together with the Registration Number
                     for the company on the tax transaction.


CVI-VAT-REG-NBR      Alpha 12                                    AP52.1
Vat Reg Nbr          The number component of the VAT
                     Registration Number. This field together
                     with the Registration Country field make
                     up the VAT Registration Number.

                         APCINVOICE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CVISET1   COMPANY       This index is used to access invoice     AP305   AP52.1
          VENDOR        conversion or interface records that do  AP52.2  AP52.3
          EDI-NBR       not have a batch number assigned.        AP520   PR198
          INVOICE
          SUFFIX

CVISET2   COMPANY       This index is used to access invoice     AP520
          BATCH-NUM     conversion or interface records that do
          VENDOR        not have a batch number assigned.
          EDI-NBR       KeyChange
          INVOICE
          SUFFIX

CVISET3   COMPANY       Subset                                   AP52.1  AP52.6
          VENDOR        Where RECORD-ERROR = "Y"
          EDI-NBR
          INVOICE
          SUFFIX

CVISET4   COMPANY       Subset                                   AP520
          VENDOR        Where (RECORD-ERROR != "Y" )
          EDI-NBR
          INVOICE
          SUFFIX

CVISET5   COMPANY       KeyChange, Subset                        AP520
          BATCH-NUM     Where (RECORD-ERROR != "Y" )
          VENDOR
          EDI-NBR
          INVOICE
          SUFFIX

                         APCINVOICE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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