|
|
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 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 MA61.1 MA70.1 MA75.1 MAI1.1
AM115 AM117 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 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
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
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
MA61.1 MA70.1
MA75.1 MAI1.1
VBA-LOCATION-CODE Alpha 4 AP115 AP125
Element: Location Code The alternate vendor location code. AP126 AP151
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
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
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 MA61.1
MAI1.1
VBA-LAST-PMT-DATE Numeric 8 (yyyymmdd) AP170 AP197
Element: Last Payment DThe 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
MA61.1 MA70.1
MA75.1 MAI1.1
VBA-HIGHEST-BAL Signed 18.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 MA61.1
MA70.1 MA75.1
MAI1.1
VBA-CURRENT-BAL Signed 18.2 AP115 AP125
Element: Intl Amt The 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 MA61.1
MA70.1 MA75.1
MAI1.1
VBA-DRAFT-BAL Signed 18.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 18.2 AP170 AP190
Element: Intl Amt The amount of reportable income AP197 AP199
withholding for the vendor or alternate AP510 AP520
vendor location for the current year.
VBA-LY-INC-WH Signed 18.2 AP197 AP199
Element: Intl Amt The amount of reportable income AP510
withholding for the vendor or alternate
vendor location for last year.
VBA-CP-PURCH Signed 18.2 Occurs 14 Times AP115 AP125
Element: Intl Amt The purchase balance for the vendor or AP126 AP170
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 MA61.1 MA70.1
vendor group year. MA75.1 MAI1.1
VBA-LY-PURCH Signed 18.2 Occurs 13 Times AP197 AP199
Element: Intl Amt The purchase balance for the vendor or AP510
alternate vendor location for each
period of the last vendor group year.
VBA-CP-PAYMENT Signed 18.2 Occurs 14 Times AP170 AP180
Element: Intl Amt The payment balance for the vendor or AP181 AP190
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 18.2 Occurs 13 Times AP197 AP199
Element: Intl Amt The payment balance for the vendor or AP510
alternate vendor location for each
period of the last vendor group year.
VBA-CP-DSCTAKE Signed 18.2 Occurs 14 Times AP170 AP190
Element: Intl Amt The amount of discounts taken for the AP197 AP199
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 18.2 Occurs 13 Times AP197 AP199
Element: Intl Amt The amount of discounts taken for the AP510
vendor or alternate vendor location for
each period of the last vendor group
year.
VBA-CP-DSCLOST Signed 18.2 Occurs 14 Times AP170 AP190
Element: Intl Amt The amount of discounts lost for the AP197 AP199
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 18.2 Occurs 13 Times AP197 AP199
Element: Intl Amt The amount of discounts lost for the AP510
vendor or alternate vendor location for
each period of the last vendor group
year.
VBA-CP-GAINLOS Signed 18.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 18.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 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 EE135
...
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 AM117
VENDOR master balance records. AM15.1 AM15.2
LOCATION-CODE AM15.3 AM15.4
COMPANY AM20.1 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
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
|
