APCVENBAL – Vendor Balance Conversion

System: Accounts Payable (AP)
Prefix: CVB
Primary key: VENDOR-GROUP, VENDOR, OLD-VENDOR, LOCATION-CODE, COMPANY
Fields: 23
Updated by: 3 programs
Referenced by: 0 programs

APCVENBAL is the Vendor Balance Conversion table in Lawson Accounts Payable (prefix CVB). It is indexed by VENDOR-GROUP, VENDOR, OLD-VENDOR, LOCATION-CODE, COMPANY (CVBSET1). It is updated by AP51.1, AP51.2 and AP510. The table has 23 fields, 1 index and 0 documented relations.

About APCVENBAL

No description in the Lawson data dictionary.

Fields (23)

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

Field / column	Type	Description & values	Updated by
`CVB-VENDOR-GROUP` PK VENDOR_GROUP	Alpha 4	Required. The vendor group. Must be a valid record in the Vendor Group file.	—
`CVB-VENDOR` PK VENDOR	Alpha 9 (Right Justified)	The vendor number. Required if not using automatic vendor numbering.	AP510
`CVB-LOCATION-CODE` PK LOCATION_CODE	Alpha 4	The alternate vendor location. Represents an alternate remittance or purchasing location for the vendor.	—
`CVB-COMPANY` PK COMPANY	Numeric 4	Required. The company number associated with the vendor. Must be a valid record in the Accounts Payable Company file.	—
`CVB-OLD-VENDOR` PK OLD_VENDOR	Alpha 9 (Right Justified)	Required if using automatic vendor numbering. The vendor's number as it existed before conversion to the Lawson Accounts Payable system.	—
`CVB-LAST-PMT-DATE` LAST_PMT_DATE	Numeric 8 (yyyymmdd)	The date of the last payment made to the vendor or alternate vendor location.	—
`CVB-LAST-PUR-DATE` LAST_PUR_DATE	Numeric 8 (yyyymmdd)	The date of the last purchase made by the vendor or alternate vendor location.	—
`CVB-HIGHEST-BAL` HIGHEST_BAL	Signed 18.2	The highest open purchase balance ever reached for the vendor or alternate vendor location.	—
`CVB-CURRENT-BAL` CURRENT_BAL	Signed 18.2	The current open purchase balance (the amount of released, or open, invoices) for the vendor or alternate vendor location.	—
`CVB-CY-INC-WH` CY_INC_WH	Signed 18.2	The amount of reportable income withholding (such as 1099 reportable income) for the vendor for the current vendor group year.	—
`CVB-LY-INC-WH` LY_INC_WH	Signed 18.2	The amount of reportable income withholding (such as 1099 reportable income) for the vendor for the last vendor group year.	—
`CVB-CP-PURCH` CP_PURCH	Signed 18.2 Occurs 14 Times ×14	The amount of purchase activity for the vendor or alternate vendor location for each period of the current vendor group year. Note: The 14th period is used to store purchase activity dated after the end of the current vendor group year. When you run AP199 (Vendor Balance Year End), any balance in the 14th period will be transferred to period one of the new vendor group year.	—
`CVB-LY-PURCH` LY_PURCH	Signed 18.2 Occurs 13 Times ×13	The amount of purchase activity for the vendor or alternate vendor location for each period of the last vendor group year.	—
`CVB-CP-PAYMENT` CP_PAYMENT	Signed 18.2 Occurs 14 Times ×14	The amount of payment activity for the vendor or alternate vendor location for each period of the current vendor group year. Note: The 14th period is used to store payment activity dated after the end of the current vendor group year. When you run AP199 (Vendor Balance Year End), any balance in the 14th period will be transferred to period one of the new vendor group year.	—
`CVB-LY-PAYMENT` LY_PAYMENT	Signed 18.2 Occurs 13 Times ×13	The amount of payment activity for the vendor or alternate vendor location for each period of the last vendor group year.	—
`CVB-CP-DSCTAKE` CP_DSCTAKE	Signed 18.2 Occurs 14 Times ×14	The amount of the discounts taken for the vendor or alternate vendor location for each period of the current vendor group year. Note: The 14th period is used to store discounts taken activity dated after the end of the current vendor group year. When AP199 (Vendor Balance Year End) is run, any balance in the 14th period will be transferred to period one of the new vendor group year.	—
`CVB-LY-DSCTAKE` LY_DSCTAKE	Signed 18.2 Occurs 13 Times ×13	The amount of the discounts taken for the vendor or alternate vendor location for each period of the last vendor group year.	—
`CVB-CP-DSCLOST` CP_DSCLOST	Signed 18.2 Occurs 14 Times ×14	The amount of the discounts lost for the vendor or alternate vendor location for each period of the current vendor group year. Note: The 14th period is used to store discounts lost activity dated after the end of the current vendor group year. When you run AP199 (Vendor Balance Year End), any balance in the 14th period will be transferred to period one of the new vendor group year.	—
`CVB-LY-DSCLOST` LY_DSCLOST	Signed 18.2 Occurs 13 Times ×13	The amount of the discounts lost for the vendor or alternate vendor location for each period of the last vendor group year.	—
`CVB-CP-GAINLOS` CP_GAINLOS	Signed 18.2 Occurs 14 Times ×14	The amount of the currency gain or loss activity for the vendor or alternate vendor location for each period of the current vendor group year. Note: The 14th period is used to store currency gain and loss activity dated after the end of the current vendor group year. When you run AP199 (Vendor Balance Year End), any balance in the 14th period will be transferred to period one of the new vendor group year.	—
`CVB-LY-GAINLOS` LY_GAINLOS	Signed 18.2 Occurs 13 Times ×13	The amount of currency gain or loss activity for the vendor or alternate vendor location for each period of the last vendor group year.	—
`CVB-CP-NBR-PMTS` CP_NBR_PMTS	Signed 6.0 Occurs 14 Times ×14	—	—
`CVB-LY-NBR-PMTS` LY_NBR_PMTS	Signed 6.0 Occurs 13 Times ×13	—	—

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
`CVBSET1`	`VENDOR-GROUP`, `VENDOR`, `OLD-VENDOR`, `LOCATION-CODE`, `COMPANY`	Primary		AP51.1, AP51.2, AP510

Programs

Updated by (3)

AP51.1 Vendor Conversion
AP51.2 Vendor Location Conversion
AP510 Vendor Conversion