Vendor Balance

The Vendor Balance file contains records of all vendor purchase and payment balances for each period of the current and last vendor group years.

REFERENCED BY

EE90.1

EE90.2

UPDATED BY

AP115	AP125	AP126	AP151	AP170	AP180
AP181	AP190	AP191	AP193	AP197	AP199
AP25.1	AP25.2	AP26.1	AP27.1	AP28.1	AP28.2
AP30.1	AP30.4	AP30.2	AP300	AP305	AP510
AP520	AP55.2	AP56.2	API1.1	API2.1	EE135
EE35.1	EE35.2	EE520	MAI1.1	AP240	AP90.6
AP90.7	AP90.1	AP91.1	PO10.1	PO10.2	AP10.1
AR09.1	AR09.8	AM115	AM117	AM15.1	AM15.2
AM15.3	AM15.4	AM19.1	AM19.2	AM20.1	AM20.3
AM21.1	AM21.3	AM500	AM51.1	AM551	AM97.1
AP03.3	AP110	AP131	AP150	AP20.1	AP20.2
AP20.3	AP20.4	AP20.5	AP20.7	AP21.1	AP210
AP220	AP23.1	API3.1	API4.1	MX123	MX500
MA41.1	MA41.2	MA41.4	MA41.7	MA43.1	MA43.2
MA43.3	MA43.4	MA43.6	MA43.7	PO136	PO190
PO300	PO520	POCP.1	POI3.1	POII.1	POIJ.1
PR05.1	PR05.3	PR226	PR247	PR26.1	PR47.1
PR514	UK47.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
VBA-VENDOR-GROUP Element: Vendor Group	Alpha 4 The vendor group. Must be a valid record in the Vendor Group file.	AP115 AP125 AP126 AP151 AP170 AP180 AP181 AP191 AP193 AP197 AP25.1 AP25.2 AP26.1 AP27.1 AP28.1 AP28.2 AP30.1 AP30.4 AP510 AP520 AP55.2 AP56.2 API1.1 API2.1 EE135 EE35.1 EE35.2 EE520 MAI1.1
VBA-COMPANY Element: Company	Numeric 4 The company number. Must be a valid company in the Accounts Payable Company file.	AP115 AP125 AP126 AP151 AP170 AP180 AP181 AP191 AP193 AP197 AP25.1 AP25.2 AP26.1 AP27.1 AP28.1 AP28.2 AP30.1 AP30.4 AP510 AP520 AP55.2 AP56.2 API1.1 API2.1 EE135 EE35.1 EE35.2 EE520 MAI1.1
VBA-VENDOR Element: Vendor	Alpha 9 (Right Justified) The vendor number. Must be a valid record in the Vendor file.	AP115 AP125 AP126 AP151 AP170 AP180 AP181 AP191 AP193 AP197 AP25.1 AP25.2 AP26.1 AP27.1 AP28.1 AP28.2 AP30.1 AP30.4 AP510 AP520 AP55.2 AP56.2 API1.1 API2.1 EE135 EE35.1 EE35.2 EE520 MAI1.1
VBA-LOCATION-CODE Element: Location Code	Alpha 4 The alternate vendor location code. Represents an alternate remittance or purchasing location for the vendor. Must be a valid record in the Vendor Location file.	AP115 AP125 AP126 AP151 AP170 AP180 AP181 AP191 AP193 AP197 AP25.1 AP25.2 AP26.1 AP27.1 AP28.1 AP28.2 AP30.1 AP30.4 AP510 AP520 AP55.2 AP56.2 API1.1 API2.1 EE135 EE35.1 EE35.2 EE520 MAI1.1
VBA-BAL-CURRENCY Element: To Base Curr	Alpha 5 The balance currency defined for the vendor. Represents the currency in which balances for the vendor or location are stored and displayed. If left blank, the company base currency is used. Must be a valid record in the Currency Code file.	AP115 AP125 AP126 AP151 AP170 AP180 AP181 AP191 AP193 AP197 AP25.1 AP25.2 AP26.1 AP27.1 AP28.1 AP28.2 AP30.1 AP30.4 AP510 AP520 AP55.2 AP56.2 API1.1 API2.1 EE135 EE35.1 EE35.2 EE520 MAI1.1
VBA-TRAN-ND Element: Acct Nd	Numeric 1 The number of decimal places defined for the balance currency.	AP115 AP125 AP126 AP151 AP170 AP180 AP181 AP191 AP193 AP197 AP25.1 AP25.2 AP26.1 AP27.1 AP28.1 AP28.2 AP30.1 AP510 AP520 AP55.2 AP56.2 API1.1 API2.1 EE135 EE35.1 EE35.2 EE520 MAI1.1
VBA-LAST-PMT-DATE Element: Last Pmt Date	Numeric 8 (yyyymmdd) The last date a payment was made to the vendor or alternate vendor location.	AP170 AP197 AP510 AP520
VBA-LAST-PUR-DATE Element: Date	Numeric 8 (yyyymmdd) The last date a purchase was made for the vendor or alternate vendor location.	AP115 AP125 AP126 AP170 AP193 AP197 AP25.1 AP25.2 AP26.1 AP27.1 AP30.1 AP30.4 AP510 AP520 API1.1 API2.1 EE135 EE35.1 EE35.2 EE520 MAI1.1
VBA-HIGHEST-BAL Element: Highest Balance	Signed 18.2 The highest open balance ever reached for the vendor or alternate vendor location. This balance applies only to vendor activity not yet deleted from the Lawson Accounts Payable system by AP300 (History Purge).	AP115 AP125 AP126 AP170 AP190 AP193 AP197 AP25.1 AP25.2 AP26.1 AP27.1 AP30.1 AP30.4 AP510 AP520 API1.1 API2.1 EE135 EE35.1 EE35.2 EE520 MAI1.1
VBA-CURRENT-BAL Element: Intl Amt	Signed 18.2 The current open balance for the vendor or alternate vendor location.	AP115 AP125 AP126 AP151 AP170 AP180 AP181 AP190 AP193 AP197 AP25.1 AP25.2 AP26.1 AP27.1 AP28.1 AP28.2 AP30.1 AP510 AP520 AP55.2 AP56.2 API1.1 API2.1 EE135 EE35.1 EE35.2 EE520 MAI1.1
VBA-DRAFT-BAL Bill of Exchange Balance	Signed 18.2 The current open bill of exchange balance for the vendor or alternate vendor location.	AP151 AP180 AP181 AP197
VBA-CY-INC-WH Element: Intl Amt	Signed 18.2 The amount of reportable income withholding for the vendor or alternate vendor location for the current year.	AP170 AP190 AP197 AP199 AP510 AP520
VBA-LY-INC-WH Element: Intl Amt	Signed 18.2 The amount of reportable income withholding for the vendor or alternate vendor location for last year.	AP197 AP199 AP510
VBA-CP-PURCH Element: Intl Amt	Signed 18.2 Occurs 14 Times The purchase balance 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.	AP115 AP125 AP126 AP170 AP193 AP197 AP199 AP25.1 AP25.2 AP26.1 AP27.1 AP30.1 AP510 AP520 API1.1 API2.1 EE135 EE35.1 EE35.2 EE520 MAI1.1
VBA-LY-PURCH Element: Intl Amt	Signed 18.2 Occurs 13 Times The purchase balance for the vendor or alternate vendor location for each period of the last vendor group year.	AP197 AP199 AP510
VBA-CP-PAYMENT Element: Intl Amt	Signed 18.2 Occurs 14 Times The payment balance 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 the first period of the new vendor group year.	AP115 AP125 AP126 AP170 AP180 AP181 AP190 AP193 AP197 AP199 AP25.1 AP25.2 AP26.1 AP27.1 AP30.1 AP510 AP520 API1.1 API2.1 EE135 EE35.1 EE35.2 EE520 MAI1.1
VBA-LY-PAYMENT Element: Intl Amt	Signed 18.2 Occurs 13 Times The payment balance for the vendor or alternate vendor location for each period of the last vendor group year.	AP197 AP199 AP510
VBA-CP-DSCTAKE Element: Intl Amt	Signed 18.2 Occurs 14 Times The amount of 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 you run AP199 (Vendor Balance Year End), any balance in the 14th period will be transferred to the first period of the new vendor group year.	AP170 AP190 AP197 AP199 AP510 AP520
VBA-LY-DSCTAKE Element: Intl Amt	Signed 18.2 Occurs 13 Times The amount of discounts taken for the vendor or alternate vendor location for each period of the last vendor group year.	AP197 AP199 AP510
VBA-CP-DSCLOST Element: Intl Amt	Signed 18.2 Occurs 14 Times The amount of 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 the first period of the new vendor group year.	AP170 AP190 AP197 AP199 AP510 AP520
VBA-LY-DSCLOST Element: Intl Amt	Signed 18.2 Occurs 13 Times The amount of discounts lost for the vendor or alternate vendor location for each period of the last vendor group year.	AP197 AP199 AP510
VBA-CP-GAINLOS Current Period Gain or Loss	Signed 18.2 Occurs 14 Times The net amount of 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/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 the first period of the new vendor group year.	AP170 AP190 AP197 AP199 AP510
VBA-LY-GAINLOS Last Year's Gain or Loss	Signed 18.2 Occurs 13 Times The net amount of currency gain or loss activity for the vendor or alternate vendor location for each period of the last vendor group year.	AP197 AP199 AP510
VBA-CP-PMT-01 Element: Period 1 Payments	Derived The payment balance for the vendor or alternate vendor location for the first period of the current vendor group year.
VBA-CP-PMT-02 Element: Period 2 Payments	Derived The payment balance for the vendor or alternate vendor location for the second period of the current vendor group year.
VBA-CP-PMT-03 Element: Period 3 Payments	Derived The payment balance for the vendor or alternate vendor location for the third period of the current vendor group year.
VBA-CP-PMT-04 Element: Period 4 Payments	Derived The payment balance for the vendor or alternate vendor location for the fourth period of the current vendor group year.
VBA-CP-PMT-05 Element: Period 5 Payments	Derived The payment balance for the vendor or alternate vendor location for the fifth period of the current vendor group year.
VBA-CP-PMT-06 Element: Period 6 Payments	Derived The payment balance for the vendor or alternate vendor location for the sixth period of the current vendor group year.
VBA-CP-PMT-07 Element: Period 7 Payments	Derived The payment balance for the vendor or alternate vendor location for the seventh period of the current vendor group year.
VBA-CP-PMT-08 Element: Period 8 Payments	Derived The payment balance for the vendor or alternate vendor location for the eighth period of the current vendor group year.
VBA-CP-PMT-09 Element: Period 9 Payments	Derived The payment balance for the vendor or alternate vendor location for the ninth period of the current vendor group year.
VBA-CP-PMT-10 Element: Period 10 Payments	Derived The payment balance for the vendor or alternate vendor location for the tenth period of the current vendor group year.
VBA-CP-PMT-11 Element: Period 11 Payments	Derived The payment balance for the vendor or alternate vendor location for the eleventh period of the current vendor group year.
VBA-CP-PMT-12 Element: Period 12 Payments	Derived The payment balance for the vendor or alternate vendor location for the twelfth period of the current vendor group year.
VBA-CP-PMT-13 Element: Period 13 Payments	Derived The payment balance for the vendor or alternate vendor location for the thirteenth period of the current vendor group year.
VBA-CP-DISC-TK-01 Period 1 Discounts Taken	Derived The amount of discounts taken for the vendor or alternate vendor location for the first period of the current vendor group year.
VBA-CP-DISC-TK-02 Period 2 Discounts Taken	Derived The amount of discounts taken for the vendor or alternate vendor location for the second period of the current vendor group year.
VBA-CP-DISC-TK-03 Period 3 Discounts Taken	Derived The amount of discounts taken for the vendor or alternate vendor location for the third period of the current vendor group year.
VBA-CP-DISC-TK-04 Period 4 Discounts Taken	Derived The amount of discounts taken for the vendor or alternate vendor location for the fourth period of the current vendor group year.
VBA-CP-DISC-TK-05 Period 5 Discounts Taken	Derived The amount of discounts taken for the vendor or alternate vendor location for the fifth period of the current vendor group year.
VBA-CP-DISC-TK-06 Period 6 Discounts Taken	Derived The amount of discounts taken for the vendor or alternate vendor location for the sixth period of the current vendor group year.
VBA-CP-DISC-TK-07 Period 7 Discounts Taken	Derived The amount of discounts taken for the vendor or alternate vendor location for the seventh period of the current vendor group year.
VBA-CP-DISC-TK-08 Period 8 Discounts Taken	Derived The amount of discounts taken for the vendor or alternate vendor location for the eighth period of the current vendor group year.
VBA-CP-DISC-TK-09 Period 9 Discounts Taken	Derived The amount of discounts taken for the vendor or alternate vendor location for the ninth period of the current vendor group year.
VBA-CP-DISC-TK-10 Period 10 Discounts Taken	Derived The amount of discounts taken for the vendor or alternate vendor location for the tenth period of the current vendor group year.
VBA-CP-DISC-TK-11 Period 11 Discounts Taken	Derived The amount of discounts taken for the vendor or alternate vendor location for the eleventh period of the current vendor group year.
VBA-CP-DISC-TK-12 Period 12 Discounts Taken	Derived The amount of discounts taken for the vendor or alternate vendor location for the twelfth period of the current vendor group year.
VBA-CP-DISC-TK-13 Period 13 Discounts Taken	Derived The amount of discounts taken for the vendor or alternate vendor location for the thirteenth period of the current vendor group year.
VBA-CP-DISC-LST-01 Period 1 Discounts Lost	Derived The amount of discounts lost for the vendor or alternate vendor location for the first period of the current vendor group year.
VBA-CP-DISC-LST-02 Period 2 Discounts Lost	Derived The amount of discounts lost for the vendor or alternate vendor location for the second period of the current vendor group year.
VBA-CP-DISC-LST-03 Period 3 Discounts Lost	Derived The amount of discounts lost for the vendor or alternate vendor location for the third period of the current vendor group year.
VBA-CP-DISC-LST-04 Period 4 Discounts Lost	Derived The amount of discounts lost for the vendor or alternate vendor location for the fourth period of the current vendor group year.
VBA-CP-DISC-LST-05 Period 5 Discounts Lost	Derived The amount of discounts lost for the vendor or alternate vendor location for the fifth period of the current vendor group year.
VBA-CP-DISC-LST-06 Period 6 Discounts Lost	Derived The amount of discounts lost for the vendor or alternate vendor location for the sixth period of the current vendor group year.
VBA-CP-DISC-LST-07 Period 7 Discounts Lost	Derived The amount of discounts lost for the vendor or alternate vendor location for the seventh period of the current vendor group year.
VBA-CP-DISC-LST-08 Period 8 Discounts Lost	Derived The amount of discounts lost for the vendor or alternate vendor location for the eighth period of the current vendor group year.
VBA-CP-DISC-LST-09 Period 9 Discounts Lost	Derived The amount of discounts lost for the vendor or alternate vendor location for the ninth period of the current vendor group year.
VBA-CP-DISC-LST-10 Period 10 Discounts Lost	Derived The amount of discounts lost for the vendor or alternate vendor location for the tenth period of the current vendor group year.
VBA-CP-DISC-LST-11 Period 11 Discounts Lost	Derived The amount of discounts lost for the vendor or alternate vendor location for the eleventh period of the current vendor group year.
VBA-CP-DISC-LST-12 Period 12 Discounts Lost	Derived The amount of discounts lost for the vendor or alternate vendor location for the twelfth period of the current vendor group year.
VBA-CP-DISC-LST-13 Period 13 Discounts Lost	Derived The amount of discounts lost for the vendor or alternate vendor location for the thirteenth period of the current vendor group year.
VBA-CP-NBR-PMTS Element: Nbr Pmts	Signed 6.0 Occurs 14 Times	AP115 AP170 AP180 AP181 AP190 AP197 AP199 AP510 AP520
VBA-CP-NBR-PMTS-01 Element: Cp Nbr Pmts 01	Derived
VBA-CP-NBR-PMTS-02 Element: Cp Nbr Pmts 02	Derived
VBA-CP-NBR-PMTS-03 Element: Cp Nbr Pmts 03	Derived
VBA-CP-NBR-PMTS-04 Element: Cp Nbr Pmts 04	Derived
VBA-CP-NBR-PMTS-05 Element: Cp Nbr Pmts 05	Derived
VBA-CP-NBR-PMTS-06 Element: Cp Nbr Pmts 06	Derived
VBA-CP-NBR-PMTS-07 Element: Cp Nbr Pmts 07	Derived
VBA-CP-NBR-PMTS-08 Element: Cp Nbr Pmts 08	Derived
VBA-CP-NBR-PMTS-09 Element: Cp Nbr Pmts 09	Derived
VBA-CP-NBR-PMTS-10 Element: Cp Nbr Pmts 10	Derived
VBA-CP-NBR-PMTS-11 Element: Cp Nbr Pmts 11	Derived
VBA-CP-NBR-PMTS-12 Element: Cp Nbr Pmts 12	Derived
VBA-CP-NBR-PMTS-13 Element: Cp Nbr Pmts 13	Derived
VBA-LY-NBR-PMTS Element: Nbr Pmts	Signed 6.0 Occurs 13 Times	AP197 AP199 AP510

APVENBAL FILE INDEX

APVENBAL FILE RELATIONS

ONE TO ONE RELATIONS

APVENBAL FILE RELATIONS

ONE TO MANY RELATIONS

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