Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APCINVOICE


                            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
Element: 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
Element: 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
Element: EDI Number    The electronic data interchange (EDI)
                       number assigned to the vendor.

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

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

CVI-BATCH-NUM          Numeric 6                                 AP52.1  PR198
Element: 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
Element: 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
Element: Authority CodeThe 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
Element: 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
Element: Invoice AccruaThe 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
Element: 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
Element: Vendor ID     THIS FIELD IS NOT CURRENTLY USED.

CVI-INV-CURRENCY       Alpha 5                                   AP52.1  PR198
To Company Base        The currency code representing the
Currency               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
Element: 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
Element: 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
Element: 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
Element: PO Number     This field contains the number
                       representing the purchase order.

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

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

CVI-AUTO-MATCH         Alpha 1                                   PR198
Element: 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
Element: Description   The invoice description. This field
                       accepts both upper and lower case
                       entries.

CVI-BASE-INV-AMT       Signed 15.2                               AP52.1  PR198
Element: Adj Amt       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
Element: Invoice AmountRequired. The amount of the invoice in
                       the currency of the invoice.

CVI-TRAN-ALOW-AMT      Signed 15.2                               AP52.1  PR198
Element: Adj Amt       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
Element: Adj Amt       The taxable amount of the invoice in
                       the currency of the invoice.

CVI-TRAN-TAX-AMT       Signed 15.2                               AP52.1  PR198
Element: Adj Amt       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
Element: Actual Disc   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
Element: Account 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
Element: 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
Element: Cost Pct      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
Element: 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
Element: 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
Element: Nbr Of Invcs  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.

CVI-RECUR-FREQ         Alpha 1                                   AP52.1  PR198
Element: Recurrence SchIndicates 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
Purchase From          The remit-to location associated with
Location 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
Element: 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
Element: Enclosure OptiIndicates 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Distribution CThe 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
Element: 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
Element: Invoice StatusRequired. 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
Element: 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
Element: 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
Element: Payment NumberThe 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
Element: 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
Element: Date          The payment date. Valid only for
                       historical status invoice records with
                       no payment (check) records.

CVI-INVOICE-GROUP      Alpha 4                                   AP52.1  PR198
Element: 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
Element: One-Time VendoIndicates 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: City/Address 5The 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
Element: State or ProviThe 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
Element: 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
Element: County        The county for the company address.

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

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

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

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

CVI-BANK-CHK-AMT       Signed 15.2                               PR198
Element: Adj Amt       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
Account Currency       The number of decimal positions defined
Code                   for the bank account currency assigned
                       to the cash code. Used for historical
                       status invoices only.

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

CVI-DISCOUNT-CODE      Alpha 10                                  AP52.1  PR198
Element: 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
Element: Invoice SourceIndicates 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
Element: 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
Element: Invoice AccruaThe 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
Element: 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
Element: Invoice User FInvoice user field number 1.

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

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

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

CVI-INV-USR-FLD-05     Alpha 20                                  AP52.1
Element: Invoice User FInvoice 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
Element: 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
Element: Reason Code   Reason code. Indicates the cause for
                       credit memos.

CVI-CBPRINT-FL         Alpha 1                                   AP52.1
Element: Print ChargebaDetermines whether to print chargebacks.
                       N = No
                       Y = Yes

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

CVI-SEGMENT-BLOCK      Alpha 103                                 AP52.1
Element: 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
Element: 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
Element: 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"                 AP520
          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