|
|
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
AP240 AP90.6 AP90.7 AP91.5 AP91.6 EE90.1
EE90.2 MA95.1 MA95.2 PO10.1 AP10.1 AR09.1
AR09.8 AP210
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 AP300 AP305 AP510 AP520
AP55.2 AP56.2 API1.1 API2.1 EE135 EE35.1
EE35.2 EE520 MA41.7 MA61.1 MA70.1 MA75.1
MAI1.1 AM115 AM15.1 AM15.2 AM15.3 AM15.4
AM20.1 AM20.3 AM21.1 AM21.3 AM500 AM51.1
AM551 AM97.1 API3.1 API4.1 IC840 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
UK47.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VBA-VENDOR-GROUP Alpha 4 AP115 AP125
Element: Vendor Group The vendor group. Must be a valid AP126 AP151
record in the Vendor Group file. 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
MA41.7 MA61.1
MA70.1 MA75.1
MAI1.1
VBA-COMPANY Numeric 4 AP115 AP125
Element: Company The company number. Must be a valid AP126 AP151
company in the Accounts Payable Company AP170 AP180
file. 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
MA41.7 MA61.1
MA70.1 MA75.1
MAI1.1
VBA-VENDOR Alpha 9 (Right Justified) AP115 AP125
Element: Vendor ID The vendor number. Must be a valid AP126 AP151
record in the Vendor file. 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
MA41.7 MA61.1
MA70.1 MA75.1
MAI1.1
VBA-LOCATION-CODE Alpha 4 AP115 AP125
Purchase From The alternate vendor location code. AP126 AP151
Location Code Represents an alternate remittance or AP170 AP180
purchasing location for the vendor. Must AP181 AP191
be a valid record in the Vendor Location AP193 AP197
file. 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
MA41.7 MA61.1
MA70.1 MA75.1
MAI1.1
VBA-BAL-CURRENCY Alpha 5 AP115 AP125
To Company Base The balance currency defined for the AP126 AP151
Currency vendor. Represents the currency in which AP170 AP180
balances for the vendor or location are AP181 AP191
stored and displayed. If left blank, the AP193 AP197
company base currency is used. Must be a AP25.1 AP25.2
valid record in the Currency Code file. 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
MA41.7 MA61.1
MA70.1 MA75.1
MAI1.1
VBA-TRAN-ND Numeric 1 AP115 AP125
Account Currency The number of decimal places defined AP126 AP151
Code for the balance currency. 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 MA41.7
MA61.1 MAI1.1
VBA-LAST-PMT-DATE Numeric 8 (yyyymmdd) AP170 AP197
Element: 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 AP125
Element: Date The last date a purchase was made for AP126 AP170
the vendor or alternate vendor location. 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
MA41.7 MA61.1
MA70.1 MA75.1
MAI1.1
VBA-HIGHEST-BAL Signed 15.2 AP115 AP125
Element: Highest BalancThe highest open balance ever reached AP126 AP170
for the vendor or alternate vendor AP190 AP193
location. This balance applies only to AP197 AP25.1
vendor activity not yet deleted from the AP25.2 AP26.1
Lawson Accounts Payable system by AP300 AP27.1 AP30.1
(History Purge). AP30.4 AP510
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.7
MA61.1 MA70.1
MA75.1 MAI1.1
VBA-CURRENT-BAL Signed 15.2 AP115 AP125
Element: Current BalancThe current open balance for the vendor AP126 AP151
or alternate vendor location. 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 MA41.7
MA61.1 MA70.1
MA75.1 MAI1.1
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
vendor location.
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 The amount of reportable income AP510
Purchases withholding for the vendor or alternate
vendor location for last year.
VBA-CP-PURCH Signed 15.2 Occurs 14 Times AP115 AP125
Current Period The purchase balance for the vendor or AP126 AP170
Purchases alternate vendor location for each AP193 AP197
period of the current vendor group year. AP199 AP25.1
AP25.2 AP26.1
Note: The 14th period is used to store AP27.1 AP30.1
purchase activity dated after the end of AP510 AP520
the current vendor group year. When you API1.1 API2.1
run AP199 (Vendor Balance Year End), any EE135 EE35.1
balance in the 14th period will be EE35.2 EE520
transferred to period one of the new MA41.7 MA61.1
vendor group year. MA70.1 MA75.1
MAI1.1
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 AP115 AP125
Current Period The payment balance for the vendor or AP126 AP170
Purchases alternate vendor location for each AP180 AP181
period of the current vendor group year. AP190 AP193
AP197 AP199
AP25.1 AP25.2
Note: The 14th period is used to store AP26.1 AP27.1
payment activity dated after the end of AP30.1 AP510
the current vendor group year. When you AP520 API1.1
run AP199 (Vendor Balance Year End), any API2.1 EE135
balance in the 14th period will be EE35.1 EE35.2
transferred to the first period of the EE520 MA41.7
new vendor group year. MA61.1 MA70.1
MA75.1 MAI1.1
VBA-LY-PAYMENT Signed 15.2 Occurs 13 Times AP197 AP199
Last Year's The payment balance for the vendor or AP510
Purchases 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
Purchases 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
Purchases 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
Purchases 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
Purchases 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
Element: Period 1 PaymeThe payment balance for the vendor or
alternate vendor location for the first
period of the current vendor group year.
VBA-CP-PMT-02 Derived
Element: Period 2 PaymeThe payment balance for the vendor or
alternate vendor location for the second
period of the current vendor group year.
VBA-CP-PMT-03 Derived
Element: Period 3 PaymeThe payment balance for the vendor or
alternate vendor location for the third
period of the current vendor group year.
VBA-CP-PMT-04 Derived
Element: Period 4 PaymeThe payment balance for the vendor or
alternate vendor location for the fourth
period of the current vendor group year.
VBA-CP-PMT-05 Derived
Element: Period 5 PaymeThe payment balance for the vendor or
alternate vendor location for the fifth
period of the current vendor group year.
VBA-CP-PMT-06 Derived
Element: Period 6 PaymeThe payment balance for the vendor or
alternate vendor location for the sixth
period of the current vendor group year.
VBA-CP-PMT-07 Derived
Element: Period 7 PaymeThe payment balance for the vendor or
alternate vendor location for the
seventh period of the current vendor
group year.
VBA-CP-PMT-08 Derived
Element: Period 8 PaymeThe payment balance for the vendor or
alternate vendor location for the eighth
period of the current vendor group year.
VBA-CP-PMT-09 Derived
Element: Period 9 PaymeThe payment balance for the vendor or
alternate vendor location for the ninth
period of the current vendor group year.
VBA-CP-PMT-10 Derived
Element: Period 10 PaymThe payment balance for the vendor or
alternate vendor location for the tenth
period of the current vendor group year.
VBA-CP-PMT-11 Derived
Element: Period 11 PaymThe payment balance for the vendor or
alternate vendor location for the
eleventh period of the current vendor
group year.
VBA-CP-PMT-12 Derived
Element: Period 12 PaymThe payment balance for the vendor or
alternate vendor location for the
twelfth period of the current vendor
group year.
VBA-CP-PMT-13 Derived
Element: Period 13 PaymThe 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 AP125
COMPANY record for a specific vendor. AP126 AP151
VENDOR AP170 AP180
LOCATION-CODE AP181 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 AP90.6
AP91.5 AP91.6
API1.1 API2.1
...
VBASET2 VENDOR-GROUP This index is used to access balance AP240 PO10.1
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 AR09.1 AR09.8
BAL-CURRENCY specified currency.
LOCATION-CODE KeyChange
COMPANY
VBASET4 VENDOR-GROUP This subset is used to access vendor AM115 AM15.1
VENDOR master balance records. AM15.2 AM15.3
LOCATION-CODE AM15.4 AM20.1
COMPANY AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP210
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
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
|
