APCPAYMENT

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.
AP52.2
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.
AP52.2
CVP-EDI-NBR
Element: Edi Nbr
Alpha 15
The vendor's electronic data interchange (EDI) number.
AP52.2
CVP-INVOICE
Element: Invoice
Alpha 22
Required. A unique invoice number for the vendor.
AP52.2
CVP-SUFFIX
Element: Suffix
Numeric 3
The occurrence value of the invoice.
AP52.2
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.
AP52.2
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.
AP52.2
CVP-TRAN-PMT-AMT
Element: Intl Amt
Signed 18.2
Required. The split invoice payment amount in the currency of the invoice.
AP52.2
CVP-TRAN-DISC-AMT
Element: Intl Amt
Signed 18.2
The discount amount of the invoice payment record in the currency of the invoice.
AP52.2
CVP-TRAN-INC-WH
Element: Intl Amt
Signed 18.2
The amount of the invoice withheld.
AP52.2
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.
AP52.2
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.
AP52.2
CVP-DISC-DATE
Element: Date
Numeric 8 (yyyymmdd)
The last date the discount can be taken. Required if Discount Rate is present.
AP52.2
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.
AP52.2
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.
AP52.2
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.
AP52.2 AP520
CVP-CHECK-DATE
Element: Check Date
Numeric 8 (yyyymmdd)
The payment date. Valid only for historical status invoice payment records.
AP52.2
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.
AP52.2
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.
AP52.2
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.
AP52.2
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.
AP52.2
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.
AP52.2
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.
AP52.2
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.
AP52.2
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


APCPAYMENT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVPSET1 COMPANY
VENDOR
EDI-NBR
INVOICE
SUFFIX
SEQ-NBR
AP305 AP52.1
AP52.2 AP520


File created: Thu Jun 09 02:06:57 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.