APCVENBAL

Vendor Balance Conversion

The Vendor Balance Conversion file is used by the Vendor Conversion program to convert vendor balance records to the Lawson Accounts Payable system. When you run AP510 (Vendor Conversion), the system reads records in this file for conversion into the Vendor Balance file. When Vendor Balance Conversion records are successfully converted, they are purged from this file.
UPDATED BY
AP51.1 AP51.2 AP510

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CVB-VENDOR-GROUP
Element: Vendor Group
Alpha 4
Required. The vendor group. Must be a valid record in the Vendor Group file.
CVB-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor number. Required if not using automatic vendor numbering.
AP510
CVB-LOCATION-CODE
Element: Location Code
Alpha 4
The alternate vendor location. Represents an alternate remittance or purchasing location for the vendor.
CVB-COMPANY
Element: 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
Element: 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
Element: Last Pmt Date
Numeric 8 (yyyymmdd)
The date of the last payment made to the vendor or alternate vendor location.
CVB-LAST-PUR-DATE
Element: Date
Numeric 8 (yyyymmdd)
The date of the last purchase made by the vendor or alternate vendor location.
CVB-HIGHEST-BAL
Element: Intl Amt
Signed 18.2
The highest open purchase balance ever reached for the vendor or alternate vendor location.
CVB-CURRENT-BAL
Element: Intl Amt
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
Element: Intl Amt
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
Element: Intl Amt
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
Element: Intl Amt
Signed 18.2 Occurs 14 Times
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
Element: Intl Amt
Signed 18.2 Occurs 13 Times
The amount of purchase activity for the vendor or alternate vendor location for each period of the last vendor group year.
CVB-CP-PAYMENT
Element: Intl Amt
Signed 18.2 Occurs 14 Times
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
Element: Intl Amt
Signed 18.2 Occurs 13 Times
The amount of payment activity for the vendor or alternate vendor location for each period of the last vendor group year.
CVB-CP-DSCTAKE
Element: Intl Amt
Signed 18.2 Occurs 14 Times
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
Element: Intl Amt
Signed 18.2 Occurs 13 Times
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
Element: Intl Amt
Signed 18.2 Occurs 14 Times
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
Element: Intl Amt
Signed 18.2 Occurs 13 Times
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
Current Period Gain
or Loss
Signed 18.2 Occurs 14 Times
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
Last Year's Gain or
Loss
Signed 18.2 Occurs 13 Times
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
Element: Nbr Pmts
Signed 6.0 Occurs 14 Times
CVB-LY-NBR-PMTS
Element: Nbr Pmts
Signed 6.0 Occurs 13 Times


APCVENBAL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVBSET1 VENDOR-GROUP
VENDOR
OLD-VENDOR
LOCATION-CODE
COMPANY
AP51.1 AP51.2
AP510


File created: Thu Jun 09 11:07:19 2016

Home
Contact Us



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