APVENBAL

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VBASET1 VENDOR-GROUP
COMPANY
VENDOR
LOCATION-CODE
...
AP115 AP125
AP126 AP151
AP170 AP180
AP181 AP190
AP191 AP193
AP197 AP199
AP240 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP30.4 AP300
AP510 AP520
AP55.2 AP56.2
AP590 AP90.6
AP91.5 AP91.6
VBASET2 VENDOR-GROUP
VENDOR
COMPANY
LOCATION-CODE
AP240 PO10.1
PO10.2
VBASET3 VENDOR-GROUP
VENDOR
BAL-CURRENCY
LOCATION-CODE
COMPANY
KeyChange
AP10.1 AP90.7
AR09.1 AR09.8
VBASET4 VENDOR-GROUP
VENDOR
LOCATION-CODE
COMPANY
...
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 AP110
AP115 AP125
AP126 AP131
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
VBASET5 COMPANY
VENDOR
LOCATION-CODE
BAL-CURRENCY
VENDOR-GROUP
KeyChange
AP190 AP305


APVENBAL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
VBA-COMPANY->CPY-COMPANY
Apvenloc APVENLOC Required
When VBA-LOCATION-CODE !=Spaces
VBA-VENDOR-GROUP->VLO-VENDOR-GROUP
VBA-VENDOR->VLO-VENDOR
VBA-LOCATION-CODE->VLO-LOCATION-CODE
Apvenmast APVENMAST Required
VBA-VENDOR-GROUP->VEN-VENDOR-GROUP
VBA-VENDOR->VEN-VENDOR


APVENBAL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apapphist APAPPHIST
VBA-COMPANY->AH3-COMPANY
VBA-VENDOR->AH3-VENDOR
  AH3-INVOICE
  AH3-SUFFIX
  AH3-CANCEL-SEQ
  AH3-SEQ-NBR
  AH3-VOID-SEQ
Apdrafts APDRAFTS
VBA-VENDOR-GROUP->APT-VENDOR-GROUP
VBA-VENDOR->APT-VENDOR
VBA-COMPANY->APT-COMPANY
  APT-BANK-INST-CODE
  APT-TRANS-IDENT
Appayment APPAYMENT
VBA-COMPANY->APP-COMPANY
VBA-VENDOR->APP-VENDOR
  APP-INVOICE
  APP-SUFFIX
  APP-CANCEL-SEQ
  APP-SEQ-NBR
  APP-VOID-SEQ


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

Home
Contact Us



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