|
|
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 EE90.1 EE90.2 MA95.1 MA95.2 AP10.1
AR09.1 AR09.8
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 AP30.2 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 AP90.1 AP91.1 PO10.1 AC160 AM115
AM117 AM15.1 AM15.2 AM15.3 AM15.4 AM19.1
AM19.2 AM20.1 AM20.3 AM21.1 AM21.3 AM500
AM51.1 AM551 AM97.1 AP03.3 AP110 AP131
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP210 AP220 AP23.1 API3.1 API4.1
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
MX123 MX500 MA180 MA279 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA63.1 MA65.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA80.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PD235
PO100 PO101 PO120 PO122 PO131 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO220 PO223 PO23.1 PO233 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO253 PO254 PO27.2
PO278 PO29.1 PO30.1 PO30.2 PO30.3 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 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 WH20.2
WH20.7
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 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
Element: To Base Curr The balance currency defined for the AP126 AP151
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
Element: Acct Nd The number of decimal places defined AP126 AP151
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 Pmt 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
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 AP115 AP125
Element: Intl Amt The payment balance for the vendor or AP126 AP170
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 MA61.1
new vendor group year. MA70.1 MA75.1
MAI1.1
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.
VBA-CP-NBR-PMTS Signed 6.0 Occurs 14 Times AP115 AP170
Element: Nbr Pmts AP180 AP181
AP190 AP197
AP199 AP510
AP520
VBA-CP-NBR-PMTS-01 Derived
Element: Cp Nbr Pmts 01
VBA-CP-NBR-PMTS-02 Derived
Element: Cp Nbr Pmts 02
VBA-CP-NBR-PMTS-03 Derived
Element: Cp Nbr Pmts 03
VBA-CP-NBR-PMTS-04 Derived
Element: Cp Nbr Pmts 04
VBA-CP-NBR-PMTS-05 Derived
Element: Cp Nbr Pmts 05
VBA-CP-NBR-PMTS-06 Derived
Element: Cp Nbr Pmts 06
VBA-CP-NBR-PMTS-07 Derived
Element: Cp Nbr Pmts 07
VBA-CP-NBR-PMTS-08 Derived
Element: Cp Nbr Pmts 08
VBA-CP-NBR-PMTS-09 Derived
Element: Cp Nbr Pmts 09
VBA-CP-NBR-PMTS-10 Derived
Element: Cp Nbr Pmts 10
VBA-CP-NBR-PMTS-11 Derived
Element: Cp Nbr Pmts 11
VBA-CP-NBR-PMTS-12 Derived
Element: Cp Nbr Pmts 12
VBA-CP-NBR-PMTS-13 Derived
Element: Cp Nbr Pmts 13
VBA-LY-NBR-PMTS Signed 6.0 Occurs 13 Times AP197 AP199
Element: Nbr Pmts AP510
APVENBAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VBASET1 VENDOR-GROUP AP115 AP125
COMPANY AP126 AP151
VENDOR AP170 AP180
LOCATION-CODE 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
AP90.6 AP91.5
AP91.6 API1.1
...
VBASET2 VENDOR-GROUP AP240 PO10.1
VENDOR
COMPANY
LOCATION-CODE
VBASET3 VENDOR-GROUP KeyChange AP10.1 AP90.7
VENDOR AR09.1 AR09.8
BAL-CURRENCY
LOCATION-CODE
COMPANY
VBASET4 VENDOR-GROUP AC160 AM115
VENDOR AM117 AM15.1
LOCATION-CODE AM15.2 AM15.3
COMPANY AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
...
VBASET5 COMPANY KeyChange AP190 AP305
VENDOR
LOCATION-CODE
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
|
