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

MA95.1

MA95.2

UPDATED BY

AC160	AM115	AM117	AM15.1	AM15.2	AM15.3
AM15.4	AM19.1	AM19.2	AM20.1	AM20.3	AM21.1
AM21.3	AM22.1	AM500	AM51.1	AM551	AM97.1
AP03.3	AP10.1	AP110	AP115	AP125	AP126
AP131	AP150	AP151	AP170	AP180	AP181
AP190	AP191	AP193	AP197	AP199	AP20.1
AP20.2	AP20.3	AP20.4	AP20.5	AP20.7	AP21.1
AP210	AP220	AP23.1	AP240	AP25.1	AP25.2
AP26.1	AP27.1	AP271	AP28.1	AP28.2	AP30.1
AP30.2	AP30.4	AP300	AP305	AP510	AP520
AP55.2	AP56.2	AP590	AP90.1	AP90.6	AP90.7
AP91.1	API1.1	API2.1	API3.1	API4.1	AR09.1
AR09.8	CX100	CX20.1	CX20.2	CX20.4	CX20.5
CX220	CX30.1	CX300	CX506	CXCP.1	EE135
EE35.1	EE35.2	EE520	DR100	IC140	IC142
IC64.1	IC64.2	IC64.3	IC64.4	IC64.5	IC64.6
IC64.7	IC64.8	IC64.9	IC66.1	IC83.1	IC840
MX123	MX500	MA180	MA279	MA41.1	MA41.2
MA41.4	MA41.7	MA42.1	MA42.2	MA43.1	MA43.2
MA43.3	MA43.4	MA43.6	MA43.7	MA44.1	MA44.2
MA530	MA531	MA60.2	MA60.3	MA60.5	MA61.1
MA63.1	MA65.1	MA66.2	MA67.2	MA67.3	MA68.2
MA68.3	MA68.5	MA69.1	MA70.1	MA75.1	MA80.1
MAI1.1	PD10.1	PD10.2	PD130	PD20.1	PD20.2
PD20.3	PD235	PO10.1	PO10.2	PO100	PO101
PO120	PO122	PO131	PO136	PO150	PO190
PO20.1	PO20.6	PO20.9	PO21.1	PO21.2	PO21.3
PO21.4	PO21.5	PO22.1	PO22.2	PO22.3	PO22.4
PO22.5	PO220	PO223	PO23.1	PO233	PO24.1
PO25.1	PO25.5	PO25.6	PO25.7	PO253	PO254
PO27.2	PO278	PO28.2	PO29.1	PO30.1	PO30.2
PO30.3	PO30.4	PO300	PO31.1	PO31.2	PO32.2
PO32.4	PO33.1	PO34.1	PO35.1	PO36.1	PO36.2
PO38.1	PO39.1	PO39.2	PO44.1	PO50.1	PO52.1
PO520	PO536	PO54.1	PO54.2	PO54.3	PO54.4
PO54.5	POCP.1	POI3.1	POID.1	POII.1	POIJ.1
PR05.1	PR05.3	PR226	PR247	PR26.1	PR47.1
PR514	UK47.1	RQ10.1	RQ10.2	RQ10.4	RQ12.1
RQ13.1	RQ13.2	RQ260	RQ35.1	RQ500	RQIF.1
WH130	WH132	WH190	WH20.2	WH20.7	WH222
WH30.1	WH30.2	WH30.3	WH30.4	WH31.1	WH31.2
WH31.3	WH31.4	WH32.1	WH32.2	WH32.3	WH32.4
WH32.5	WH33.1	WH33.2	WH33.3	WH33.4	WH33.5
WH33.6	WH33.8	WH33.9	WH34.1	WH34.2	WH34.3
WH34.4	WH40.1	WH40.2	WH520	WH830	ZW130

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 MA61.1 MA70.1 MA75.1 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 MA61.1 MA70.1 MA75.1 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 MA61.1 MA70.1 MA75.1 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 MA61.1 MA70.1 MA75.1 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 MA61.1 MA70.1 MA75.1 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 MA61.1 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 MA61.1 MA70.1 MA75.1 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 MA61.1 MA70.1 MA75.1 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 MA61.1 MA70.1 MA75.1 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 MA61.1 MA70.1 MA75.1 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 MA61.1 MA70.1 MA75.1 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.