APCPAYMENT – Invoice Payment Interface

System: Accounts Payable (AP)
Prefix: CVP
Primary key: COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, SEQ-NBR
Fields: 29
Updated by: 4 programs
Referenced by: 0 programs

APCPAYMENT is the Invoice Payment Interface table in Lawson Accounts Payable (prefix CVP). It is indexed by COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, SEQ-NBR (CVPSET1). It is updated by AP305, AP52.1, AP52.2 and AP520. The table has 29 fields, 1 index and 0 documented relations.

About APCPAYMENT

No description in the Lawson data dictionary.

Fields (29)

Column = COBOL field name without the CVP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`CVP-COMPANY` PK COMPANY	Numeric 4	Required. The company number. Must be a valid record in the Accounts Payable Company file.	AP52.2
`CVP-VENDOR` PK 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` PK EDI_NBR	Alpha 15	The vendor's electronic data interchange (EDI) number.	AP52.2
`CVP-INVOICE` PK INVOICE	Alpha 22	Required. A unique invoice number for the vendor.	AP52.2
`CVP-SUFFIX` PK SUFFIX	Numeric 3	The occurrence value of the invoice.	AP52.2
`CVP-SEQ-NBR` PK 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` 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` TRAN_PMT_AMT	Signed 18.2	Required. The split invoice payment amount in the currency of the invoice.	AP52.2
`CVP-TRAN-DISC-AMT` TRAN_DISC_AMT	Signed 18.2	The discount amount of the invoice payment record in the currency of the invoice.	AP52.2
`CVP-TRAN-INC-WH` TRAN_INC_WH	Signed 18.2	The amount of the invoice withheld.	AP52.2
`CVP-TRAN-INC-AMT` TRAN_INC_AMT	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` 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` DISC_DATE	Numeric 8 (yyyymmdd)	The last date the discount can be taken. Required if Discount Rate is present.	AP52.2
`CVP-REC-STATUS` REC_STATUS	Numeric 1	The payment record status. Valid values are: payment is not available for payment. payment is available for payment. is paid and closed. `0` Unreleased. The split invoice `1` Released (open). The split invoice `9` History. The split invoice payment	AP52.2
`CVP-TRANS-NBR` TRANS_NBR	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` BANK_INST_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` CHECK_DATE	Numeric 8 (yyyymmdd)	The payment date. Valid only for historical status invoice payment records.	AP52.2
`CVP-DISC-LOST-FLG` DISC_LOST_FLG	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: discount was taken. lost. `N` No. Default value. The available `Y` Yes. The available discount was	AP52.2
`CVP-CASH-CODE` 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` SEP_CHK_FLAG	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_IMM_FLAG	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` 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` ENCLOSURE	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` 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` BANK_CHK_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` BANK_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` BNK_CNV_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` INC_ACCR_CODE	Alpha 10	A user-defined code representing a general ledger income withholding accrual account.	—
`CVP-RECORD-ERROR` 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	—

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`CVPSET1`	`COMPANY`, `VENDOR`, `EDI-NBR`, `INVOICE`, `SUFFIX`, `SEQ-NBR`	Primary		AP305, AP52.1, AP52.2, AP520

Programs

Updated by (4)

AP305 Accounts Payable Company Purge
AP52.1 Invoice Interface
AP52.2 Multiple Payment Interface
AP520 Invoice Interface