Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APCPAYMENT


                            APCPAYMENT FILE

                       Invoice Payment Interface

The Invoice Payment Conversion file is used by the Invoice Interface program
to convert or interface optional split invoice payments to the Lawson Accounts
Payable system. When you run AP520 (Invoice Interface), the system reads
records in this file for conversion or interface to the Invoice Payment file.
When Invoice Payment Conversion records are successfully converted or
interfaced, they are deleted from this file. You can use AP52.2 (Multiple
Payment 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

AP52.1    AP52.2    AP305     AP520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CVP-COMPANY            Numeric 4                                 AP52.2
Element: Company       Required. The company number. Must be a
                       valid record in the Accounts Payable
                       Company file.

CVP-VENDOR             Alpha 9  (Right Justified)                AP52.2
Element: Vendor ID     The vendor number. Must be a valid
                       record in the Vendor file. This field is
                       required unless a value is present in
                       the EDI Number field.

CVP-EDI-NBR            Alpha 15                                  AP52.2
Element: EDI Number    The vendor's electronic data
                       interchange (EDI) number.

CVP-INVOICE            Alpha 22                                  AP52.2
Element: Invoice NumberRequired. A unique invoice number for
                       the vendor.

CVP-SUFFIX             Numeric 3                                 AP52.2
Element: Invoice SuffixThe occurrence value of the invoice.

CVP-SEQ-NBR            Numeric 4                                 AP52.2
Element: Sequence NumbeA unique sequence number for this
                       payment record. Valid values are 1
                       through 9999. If left blank, the system
                       numbers each split invoice payment
                       record beginning with 1.

CVP-DUE-DATE           Numeric 8  (yyyymmdd)                     AP52.2
Element: Date          Required. The due date of the invoice
                       payment record. Used to schedule the
                       invoice payment record for payment.

CVP-TRAN-PMT-AMT       Signed 15.2                               AP52.2
Element: Adj Amt       Required. The split invoice payment
                       amount in the currency of the invoice.

CVP-TRAN-DISC-AMT      Signed 15.2                               AP52.2
Element: Actual Disc   The discount amount of the invoice
                       payment record in the currency of the
                       invoice.

CVP-TRAN-INC-WH        Signed 15.2                               AP52.2
Element: Actual Cost   The amount of the invoice withheld.

CVP-TRAN-INC-AMT       Signed 15.2                               AP52.2
Reportable Income      The reportable income amount for the
Amount                 invoice payment record. If left blank
                       and an Income Code is assigned to the
                       invoice, the reportable income amount is
                       the Invoice Amount less the discount
                       taken.

CVP-DISCOUNT-RT        Percent 5.3  (Percent)                    AP52.2
Element: Cost Pct      The rate used to calculate the discount
                       amount of the invoice payment. Required
                       if Discount Date is present.

CVP-DISC-DATE          Numeric 8  (yyyymmdd)                     AP52.2
Element: Date          The last date the discount can be
                       taken. Required if Discount Rate is
                       present.

CVP-REC-STATUS         Numeric 1                                 AP52.2
Element: Record Status The payment record status. Valid values
                       are:

                       0 = Unreleased. The split invoice
                       payment is not available for payment.

                       1 = Released (open). The split invoice
                       payment is available for payment.

                       9 = History. The split invoice payment
                       is paid and closed.

CVP-TRANS-NBR          Alpha 10  (Right Justified)               AP52.2
Element: Payment NumberThe payment number used to pay the
                       split invoice payment. Required only for
                       historical status split invoice payment
                       records. If entered, the Payment Code
                       assigned to the split invoice payment
                       must be a valid cash payment type
                       transaction code record in the Bank
                       Transaction Code file.

                       Note: If you are converting a
                       historical status split invoice payment
                       and want to link associated payment
                       (check) records to the invoice, you must
                       run CB500 (Bank Transaction Interface)
                       to convert payment records before you
                       convert associated invoices.

CVP-BANK-INST-CODE     Alpha 3                                   AP52.2  AP520
Element: Payment Code  The bank transaction code associated
                       with the invoice payment record.
                       Represents a type of cash or bill of
                       exchange payment. Required for
                       historical status invoice payment
                       records. If left blank for an unreleased
                       or released (open) status invoice
                       payment record, the payment code
                       assigned to the invoice conversion
                       record, 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.

CVP-CHECK-DATE         Numeric 8  (yyyymmdd)                     AP52.2
Element: Date          The payment date. Valid only for
                       historical status invoice payment
                       records.

CVP-DISC-LOST-FLG      Alpha 1                                   AP52.2
Element: Discount Lost Indicates whether the available
                       discount for the split invoice payment
                       was lost. Valid only for historical
                       status invoice payment records. Valid
                       values are:

                       N = No. Default value. The available
                       discount was taken.
                       Y = Yes. The available discount was
                       lost.

CVP-CASH-CODE          Alpha 4                                   AP52.2
Accounts Receivable    The cash code assigned to the split
Code                   invoice payment. 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.

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

                       Y = Yes.
                       N = No.

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

                       N = No. Default value.
                       Y = Yes.

CVP-INVOICE-GROUP      Alpha 4                                   AP52.2
Element: Invoice Group The invoice group assigned to the
                       invoice. 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. If blank, the invoice
                       group defaults from the vendor, if
                       assigned.

CVP-ENCLOSURE          Alpha 1                                   AP52.2
Element: All Flag      Indicates whether the split invoice
                       payment 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.

CVP-INCOME-CODE        Alpha 4                                   AP52.2
Accounts Receivable    The income code assigned to the split
Code                   invoice payment. 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.

CVP-BANK-CHK-AMT       Signed 15.2
Element: Adj Amt       The amount of the payment in the
                       currency of the cash code (bank
                       account). Used for historical status
                       payment records only.

CVP-BANK-ND            Numeric 1
Account Currency       The number of decimal positions defined
Code                   for the bank account currency assigned
                       to the cash code. Used for historical
                       status payments only.

CVP-BNK-CNV-RATE       Signed 12.6
Element: Account Rate  The exchange rate used to convert the
                       payment amount from the invoice currency
                       to the bank account currency. Used for
                       historical status payments only.

CVP-INC-ACCR-CODE      Alpha 10
Income Withholding     A user-defined code representing a
Code                   general ledger income withholding
                       accrual account.

CVP-RECORD-ERROR       Alpha 1
Element: Record Error  Indicates if an error was found during
                       conversion and if the error has been
                       corrected. Valid values are:

                       Y = Error found
                       N = No error found or error corrected

                         APCPAYMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CVPSET1   COMPANY       This index is used to access multiple    AP305   AP52.1
          VENDOR        invoice payment conversion or interface  AP52.2  AP520
          EDI-NBR       records.
          INVOICE
          SUFFIX
          SEQ-NBR