APVENBAL FILE
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
AP90.6 AP90.7 AP91.5 AP91.6 EE90.1 EE90.2
MA95.1 MA95.2 AP240 AP10.1 AR48.1 AP210
UPDATED BY
AP115 AP151 AP170 AP180 AP181 AP190
AP191 AP193 AP197 AP199 AP28.1 AP28.2
AP30.1 AP30.4 AP300 AP305 AP510 AP520
AP55.2 AP56.1 AP56.2 API1.1 API2.1 EE135
EE35.1 EE35.2 EE520 API3.1 API4.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VBA-VENDOR-GROUP Alpha 4 AP115 AP151
Vendor Group The vendor group. Must be a valid AP170 AP180
record in the Vendor Group file. AP181 AP191
AP193 AP197
AP28.1 AP28.2
AP30.1 AP30.4
AP510 AP520
AP55.2 AP56.1
AP56.2 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
VBA-COMPANY Numeric 4 AP115 AP151
Company The company number. Must be a valid AP170 AP180
company in the Accounts Payable Company AP181 AP191
file. AP193 AP197
AP28.1 AP28.2
AP30.1 AP30.4
AP510 AP520
AP55.2 AP56.1
AP56.2 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
VBA-VENDOR Alpha 9 (Right Justified) AP115 AP151
Vendor ID The vendor number. Must be a valid AP170 AP180
record in the Vendor file. AP181 AP191
AP193 AP197
AP28.1 AP28.2
AP30.1 AP30.4
AP510 AP520
AP55.2 AP56.1
AP56.2 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
VBA-LOCATION-CODE Alpha 4 AP115 AP151
Location Code The alternate vendor location code. AP170 AP180
Represents an alternate remittance or AP181 AP191
purchasing location for the vendor. Must AP193 AP197
be a valid record in the Vendor Location AP28.1 AP28.2
file. AP30.1 AP30.4
AP510 AP520
AP55.2 AP56.1
AP56.2 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
VBA-BAL-CURRENCY Alpha 5 AP115 AP151
Balance Currency The balance currency defined for the AP170 AP180
vendor. Represents the currency in which AP181 AP191
balances for the vendor or location are AP193 AP197
stored and displayed. If left blank, the AP28.1 AP28.2
company base currency is used. Must be a AP30.1 AP30.4
valid record in the Currency Code file. AP510 AP520
AP55.2 AP56.1
AP56.2 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
VBA-TRAN-ND Numeric 1 AP115 AP151
Transaction Number The number of decimal places defined AP170 AP180
of Decimals for the balance currency. AP181 AP191
AP193 AP197
AP28.1 AP28.2
AP30.1 AP510
AP520 AP55.2
AP56.1 AP56.2
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
VBA-LAST-PMT-DATE Numeric 8 (yyyymmdd) AP170 AP197
Last Payment Date The last date a payment was made to the AP510 AP520
vendor or alternate vendor location.
VBA-LAST-PUR-DATE Numeric 8 (yyyymmdd) AP115 AP170
Last Purchase Date The last date a purchase was made for AP193 AP197
the vendor or alternate vendor location. AP30.1 AP30.4
AP510 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
VBA-HIGHEST-BAL Signed 15.2 AP115 AP170
Highest Balance The highest open balance ever reached AP190 AP193
for the vendor or alternate vendor AP197 AP30.1
location. This balance applies only to AP30.4 AP510
vendor activity not yet deleted from the AP520 API1.1
Lawson Accounts Payable system by AP300 API2.1 EE135
(History Purge). EE35.1 EE35.2
EE520
VBA-CURRENT-BAL Signed 15.2 AP115 AP151
Current Balance The current open balance for the vendor AP170 AP180
or alternate vendor location. AP181 AP190
AP193 AP197
AP28.1 AP28.2
AP30.1 AP510
AP520 AP55.2
AP56.2 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
VBA-DRAFT-BAL Signed 15.2 AP151 AP180
Bill of Exchange The current open bill of exchange AP181 AP197
Balance balance for the vendor or alternate AP28.1 AP28.2
vendor location. AP56.1
VBA-CY-INC-WH Signed 15.2 AP170 AP190
Current Year Income The amount of reportable income AP197 AP199
Withheld withholding for the vendor or alternate AP510 AP520
vendor location for the current year.
VBA-LY-INC-WH Signed 15.2 AP197 AP199
Last Year's Income The amount of reportable income AP510
Withheld withholding for the vendor or alternate
vendor location for last year.
VBA-CP-PURCH Signed 15.2 Occurs 14 Times AP115 AP170
Current Period The purchase balance for the vendor or AP193 AP197
Purchases alternate vendor location for each AP199 AP30.1
period of the current vendor group year. AP510 AP520
API1.1 API2.1
Note: The 14th period is used to store EE135 EE35.1
purchase activity dated after the end of EE35.2 EE520
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.
VBA-LY-PURCH Signed 15.2 Occurs 13 Times AP197 AP199
Last Year's The purchase balance for the vendor or AP510
Purchases alternate vendor location for each
period of the last vendor group year.
VBA-CP-PAYMENT Signed 15.2 Occurs 14 Times AP170 AP180
Current Period The payment balance for the vendor or AP181 AP190
Payments alternate vendor location for each AP197 AP199
period of the current vendor group year. AP510 AP520
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.
VBA-LY-PAYMENT Signed 15.2 Occurs 13 Times AP197 AP199
Last Year's Payments The payment balance for the vendor or AP510
alternate vendor location for each
period of the last vendor group year.
VBA-CP-DSCTAKE Signed 15.2 Occurs 14 Times AP170 AP190
Current Period The amount of discounts taken for the AP197 AP199
Discounts Taken vendor or alternate vendor location for AP510 AP520
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.
VBA-LY-DSCTAKE Signed 15.2 Occurs 13 Times AP197 AP199
Last Year's The amount of discounts taken for the AP510
Discounts Taken vendor or alternate vendor location for
each period of the last vendor group
year.
VBA-CP-DSCLOST Signed 15.2 Occurs 14 Times AP170 AP190
Current Period The amount of discounts lost for the AP197 AP199
Discounts Lost vendor or alternate vendor location for AP510 AP520
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.
VBA-LY-DSCLOST Signed 15.2 Occurs 13 Times AP197 AP199
Last Year's The amount of discounts lost for the AP510
Discounts Lost vendor or alternate vendor location for
each period of the last vendor group
year.
VBA-CP-GAINLOS Signed 15.2 Occurs 14 Times AP170 AP190
Current Period Gain The net amount of currency gain or loss AP197 AP199
or Loss activity for the vendor or alternate AP510
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.
VBA-LY-GAINLOS Signed 15.2 Occurs 13 Times AP197 AP199
Last Year's Gain or The net amount of currency gain or loss AP510
Loss activity for the vendor or alternate
vendor location for each period of the
last vendor group year.
VBA-CP-PMT-01 Derived
Period 1 Payments The payment balance for the vendor or
alternate vendor location for the first
period of the current vendor group year.
VBA-CP-PMT-02 Derived
Period 2 Payments The payment balance for the vendor or
alternate vendor location for the second
period of the current vendor group year.
VBA-CP-PMT-03 Derived
Period 3 Payments The payment balance for the vendor or
alternate vendor location for the third
period of the current vendor group year.
VBA-CP-PMT-04 Derived
Period 4 Payments The payment balance for the vendor or
alternate vendor location for the fourth
period of the current vendor group year.
VBA-CP-PMT-05 Derived
Period 5 Payments The payment balance for the vendor or
alternate vendor location for the fifth
period of the current vendor group year.
VBA-CP-PMT-06 Derived
Period 6 Payments The payment balance for the vendor or
alternate vendor location for the sixth
period of the current vendor group year.
VBA-CP-PMT-07 Derived
Period 7 Payments The payment balance for the vendor or
alternate vendor location for the
seventh period of the current vendor
group year.
VBA-CP-PMT-08 Derived
Period 8 Payments The payment balance for the vendor or
alternate vendor location for the eighth
period of the current vendor group year.
VBA-CP-PMT-09 Derived
Period 9 Payments The payment balance for the vendor or
alternate vendor location for the ninth
period of the current vendor group year.
VBA-CP-PMT-10 Derived
Period 10 Payments The payment balance for the vendor or
alternate vendor location for the tenth
period of the current vendor group year.
VBA-CP-PMT-11 Derived
Period 11 Payments The payment balance for the vendor or
alternate vendor location for the
eleventh period of the current vendor
group year.
VBA-CP-PMT-12 Derived
Period 12 Payments The payment balance for the vendor or
alternate vendor location for the
twelfth period of the current vendor
group year.
VBA-CP-PMT-13 Derived
Period 13 Payments 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 Derived
Period 1 Discounts The amount of discounts taken for the
Taken vendor or alternate vendor location for
the first period of the current vendor
group year.
VBA-CP-DISC-TK-02 Derived
Period 2 Discounts The amount of discounts taken for the
Taken vendor or alternate vendor location for
the second period of the current vendor
group year.
VBA-CP-DISC-TK-03 Derived
Period 3 Discounts The amount of discounts taken for the
Taken vendor or alternate vendor location for
the third period of the current vendor
group year.
VBA-CP-DISC-TK-04 Derived
Period 4 Discounts The amount of discounts taken for the
Taken vendor or alternate vendor location for
the fourth period of the current vendor
group year.
VBA-CP-DISC-TK-05 Derived
Period 5 Discounts The amount of discounts taken for the
Taken vendor or alternate vendor location for
the fifth period of the current vendor
group year.
VBA-CP-DISC-TK-06 Derived
Period 6 Discounts The amount of discounts taken for the
Taken vendor or alternate vendor location for
the sixth period of the current vendor
group year.
VBA-CP-DISC-TK-07 Derived
Period 7 Discounts The amount of discounts taken for the
Taken vendor or alternate vendor location for
the seventh period of the current vendor
group year.
VBA-CP-DISC-TK-08 Derived
Period 8 Discounts The amount of discounts taken for the
Taken vendor or alternate vendor location for
the eighth period of the current vendor
group year.
VBA-CP-DISC-TK-09 Derived
Period 9 Discounts The amount of discounts taken for the
Taken vendor or alternate vendor location for
the ninth period of the current vendor
group year.
VBA-CP-DISC-TK-10 Derived
Period 10 Discounts The amount of discounts taken for the
Taken vendor or alternate vendor location for
the tenth period of the current vendor
group year.
VBA-CP-DISC-TK-11 Derived
Period 11 Discounts The amount of discounts taken for the
Taken vendor or alternate vendor location for
the eleventh period of the current
vendor group year.
VBA-CP-DISC-TK-12 Derived
Period 12 Discounts The amount of discounts taken for the
Taken vendor or alternate vendor location for
the twelfth period of the current vendor
group year.
VBA-CP-DISC-TK-13 Derived
Period 13 Discounts The amount of discounts taken for the
Taken vendor or alternate vendor location for
the thirteenth period of the current
vendor group year.
VBA-CP-DISC-LST-01 Derived
Period 1 Discounts The amount of discounts lost for the
Lost vendor or alternate vendor location for
the first period of the current vendor
group year.
VBA-CP-DISC-LST-02 Derived
Period 2 Discounts The amount of discounts lost for the
Lost vendor or alternate vendor location for
the second period of the current vendor
group year.
VBA-CP-DISC-LST-03 Derived
Period 3 Discounts The amount of discounts lost for the
Lost vendor or alternate vendor location for
the third period of the current vendor
group year.
VBA-CP-DISC-LST-04 Derived
Period 4 Discounts The amount of discounts lost for the
Lost vendor or alternate vendor location for
the fourth period of the current vendor
group year.
VBA-CP-DISC-LST-05 Derived
Period 5 Discounts The amount of discounts lost for the
Lost vendor or alternate vendor location for
the fifth period of the current vendor
group year.
VBA-CP-DISC-LST-06 Derived
Period 6 Discounts The amount of discounts lost for the
Lost vendor or alternate vendor location for
the sixth period of the current vendor
group year.
VBA-CP-DISC-LST-07 Derived
Period 7 Discounts The amount of discounts lost for the
Lost vendor or alternate vendor location for
the seventh period of the current vendor
group year.
VBA-CP-DISC-LST-08 Derived
Period 8 Discounts The amount of discounts lost for the
Lost vendor or alternate vendor location for
the eighth period of the current vendor
group year.
VBA-CP-DISC-LST-09 Derived
Period 9 Discounts The amount of discounts lost for the
Lost vendor or alternate vendor location for
the ninth period of the current vendor
group year.
VBA-CP-DISC-LST-10 Derived
Period 10 Discounts The amount of discounts lost for the
Lost vendor or alternate vendor location for
the tenth period of the current vendor
group year.
VBA-CP-DISC-LST-11 Derived
Period 11 Discounts The amount of discounts lost for the
Lost vendor or alternate vendor location for
the eleventh period of the current
vendor group year.
VBA-CP-DISC-LST-12 Derived
Period 12 Discounts The amount of discounts lost for the
Lost vendor or alternate vendor location for
the twelfth period of the current vendor
group year.
VBA-CP-DISC-LST-13 Derived
Period 13 Discounts The amount of discounts lost for the
Lost vendor or alternate vendor location for
the thirteenth period of the current
vendor group year.
APVENBAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VBASET1 VENDOR-GROUP This index is used to access a balance AP115 AP151
COMPANY record for a specific vendor. AP170 AP180
VENDOR AP181 AP191
LOCATION-CODE AP193 AP197
AP199 AP28.1
AP28.2 AP30.1
AP30.4 AP300
AP510 AP520
AP55.2 AP56.1
AP56.2 AP90.6
AP91.5 AP91.6
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
EE90.1 EE90.2
...
VBASET2 VENDOR-GROUP This index is used to access balance AP240
VENDOR records for a specific vendor.
COMPANY
LOCATION-CODE
VBASET3 VENDOR-GROUP This index is used to access balance AP10.1 AP90.7
VENDOR records for a specific vendor in a AR48.1
BAL-CURRENCY specified currency.
LOCATION-CODE KeyChange
COMPANY
VBASET4 VENDOR-GROUP This subset is used to access vendor AP210 API3.1
VENDOR master balance records. API4.1
LOCATION-CODE
COMPANY
VBASET5 COMPANY This index is used to access balance AP190 AP305
VENDOR records by company.
LOCATION-CODE KeyChange
BAL-CURRENCY
VENDOR-GROUP
APVENBAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
