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 Element: Company | Numeric 4 Required. The company number. Must be a valid record in the Accounts Payable Company file. |
|
||
CVP-VENDOR Element: Vendor | Alpha 9 (Right Justified) 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 Element: Edi Nbr | Alpha 15 The vendor's electronic data interchange (EDI) number. |
|
||
CVP-INVOICE Element: Invoice | Alpha 22 Required. A unique invoice number for the vendor. |
|
||
CVP-SUFFIX Element: Suffix | Numeric 3 The occurrence value of the invoice. |
|
||
CVP-SEQ-NBR Element: Seq Nbr | Numeric 4 A 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 Element: Due Date | Numeric 8 (yyyymmdd) Required. The due date of the invoice payment record. Used to schedule the invoice payment record for payment. |
|
||
CVP-TRAN-PMT-AMT Element: Intl Amt | Signed 18.2 Required. The split invoice payment amount in the currency of the invoice. |
|
||
CVP-TRAN-DISC-AMT Element: Intl Amt | Signed 18.2 The discount amount of the invoice payment record in the currency of the invoice. |
|
||
CVP-TRAN-INC-WH Element: Intl Amt | Signed 18.2 The amount of the invoice withheld. |
|
||
CVP-TRAN-INC-AMT Reportable Income Amount | Signed 18.2 The reportable income amount for the 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 Element: Discount Rt | Percent 5.3 (Percent) The rate used to calculate the discount amount of the invoice payment. Required if Discount Date is present. |
|
||
CVP-DISC-DATE Element: Date | Numeric 8 (yyyymmdd) The last date the discount can be taken. Required if Discount Rate is present. |
|
||
CVP-REC-STATUS Element: Rec Status | Numeric 1 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 Element: Payment Number | Alpha 10 (Right Justified) The 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 Element: Payment Code | Alpha 3 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 Element: Check Date | Numeric 8 (yyyymmdd) The payment date. Valid only for historical status invoice payment records. |
|
||
CVP-DISC-LOST-FLG Element: Discount Lost | Alpha 1 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 Element: Cash Code | Alpha 4 The cash code assigned to the split 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 Separate Payment Option | Alpha 1 Indicates whether the split invoice 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 Pay Immediately Option | Alpha 1 Indicates whether the split invoice payment will be selected for immediate payment regardless of the due date. Valid values are: N = No. Default value. Y = Yes. |
|
||
CVP-INVOICE-GROUP Element: Invoice Group | Alpha 4 The invoice group assigned to the invoice. 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. If blank, the invoice group defaults from the vendor, if assigned. |
|
||
CVP-ENCLOSURE Element: All Flag | Alpha 1 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 Element: Income Code | Alpha 4 The income code assigned to the split 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 Element: Intl Amt | Signed 18.2 The amount of the payment in the currency of the cash code (bank account). Used for historical status payment records only. |
|
||
CVP-BANK-ND Element: Acct Nd | Numeric 1 The number of decimal positions defined for the bank account currency assigned to the cash code. Used for historical status payments only. |
|
||
CVP-BNK-CNV-RATE Element: Acct Rate | Signed 14.7 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 Element: Inc Accr Code | Alpha 10 A user-defined code representing a general ledger income withholding accrual account. |
|
||
CVP-RECORD-ERROR Element: Record Error | Alpha 1 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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CVPSET1 |
COMPANY VENDOR EDI-NBR INVOICE SUFFIX SEQ-NBR |
|
|
All trademarks and registered trademarks are the property of their
respective owners.