|
|
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 EE90.1 EE90.2 MA95.1 MA95.2
AP240 AR09.1 AR09.8 AP210
UPDATED BY
AP125 AP126 AP151 AP170 AP180 AP181
AP190 AP191 AP193 AP197 AP199 AP25.1
AP25.2 AP26.1 AP28.1 AP28.2 AP30.1 AP30.4
AP300 AP305 AP510 AP520 AP55.2 AP56.1
AP56.2 EE135 EE35.1 EE35.2 EE520 MA530
MA540 PO31.1 AP10.1 AP10.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VBA-VENDOR-GROUP Alpha 4 AP125 AP126
Vendor Group The vendor group. Must be a valid AP151 AP170
record in the Vendor Group file. AP180 AP181
AP191 AP193
AP197 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP30.1 AP30.4
AP510 AP520
AP55.2 AP56.1
AP56.2 EE135
EE35.1 EE35.2
EE520 MA530
MA540 PO31.1
VBA-COMPANY Numeric 4 AP125 AP126
Company The company number. Must be a valid AP151 AP170
company in the Accounts Payable Company AP180 AP181
file. AP191 AP193
AP197 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP30.1 AP30.4
AP510 AP520
AP55.2 AP56.1
AP56.2 EE135
EE35.1 EE35.2
EE520 MA530
MA540 PO31.1
VBA-VENDOR Alpha 9 AP125 AP126
Vendor ID The vendor number. Must be a valid AP151 AP170
record in the Vendor file. AP180 AP181
AP191 AP193
AP197 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP30.1 AP30.4
AP510 AP520
AP55.2 AP56.1
AP56.2 EE135
EE35.1 EE35.2
EE520 MA530
MA540 PO31.1
VBA-LOCATION-CODE Alpha 4 AP125 AP126
Location Code The alternate vendor location code. AP151 AP170
Represents an alternate remittance or AP180 AP181
purchasing location for the vendor. Must AP191 AP193
be a valid record in the Vendor Location AP197 AP25.1
file. AP25.2 AP26.1
AP28.1 AP28.2
AP30.1 AP30.4
AP510 AP520
AP55.2 AP56.1
AP56.2 EE135
EE35.1 EE35.2
EE520 MA530
MA540 PO31.1
VBA-BAL-CURRENCY Alpha 5 AP125 AP126
Balance Currency The balance currency defined for the AP151 AP170
vendor. Represents the currency in which AP180 AP181
balances for the vendor or location are AP191 AP193
stored and displayed. If left blank, the AP197 AP25.1
company base currency is used. Must be a AP25.2 AP26.1
valid record in the Currency Code file. AP28.1 AP28.2
AP30.1 AP30.4
AP510 AP520
AP55.2 AP56.1
AP56.2 EE135
EE35.1 EE35.2
EE520 MA530
MA540 PO31.1
VBA-TRAN-ND Numeric 1 AP125 AP126
Transaction Number The number of decimal places defined AP151 AP170
of Decimals for the balance currency. AP180 AP181
AP191 AP193
AP197 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP30.1 AP510
AP520 AP55.2
AP56.1 AP56.2
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PO31.1
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) AP125 AP126
Last Purchase Date The last date a purchase was made for AP170 AP193
the vendor or alternate vendor location. AP197 AP25.1
AP25.2 AP26.1
AP30.1 AP30.4
AP510 AP520
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PO31.1
VBA-HIGHEST-BAL Signed 15.2 AP125 AP126
Highest Balance The highest open balance ever reached AP170 AP190
for the vendor or alternate vendor AP193 AP197
location. This balance applies only to AP25.1 AP25.2
vendor activity not yet deleted from the AP26.1 AP30.1
Lawson Accounts Payable system by AP300 AP30.4 AP510
(History Purge). AP520 EE135
EE35.1 EE35.2
EE520 MA530
MA540 PO31.1
VBA-CURRENT-BAL Signed 15.2 AP125 AP126
Current Balance The current open balance for the vendor AP151 AP170
or alternate vendor location. AP180 AP181
AP190 AP193
AP197 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP30.1 AP510
AP520 AP55.2
AP56.2 EE135
EE35.1 EE35.2
EE520 MA530
MA540 PO31.1
VBA-DRAFT-BAL Signed 15.2 AP125 AP126
Bill of Exchange The current open bill of exchange AP151 AP180
Balance balance for the vendor or alternate AP181 AP197
vendor location. AP25.1 AP25.2
AP26.1 AP28.1
AP28.2 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 AP125 AP126
Current Period The purchase balance for the vendor or AP170 AP193
Purchases alternate vendor location for each AP197 AP199
period of the current vendor group year. AP25.1 AP25.2
AP26.1 AP30.1
Note: The 14th period is used to store AP510 AP520
purchase activity dated after the end of EE135 EE35.1
the current vendor group year. When you EE35.2 EE520
run AP199 (Vendor Balance Year End), any MA530 MA540
balance in the 14th period will be PO31.1
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 AP10.1 AP10.2
COMPANY record for a specific vendor. AP125 AP126
VENDOR AP151 AP170
LOCATION-CODE AP180 AP181
AP191 AP193
AP197 AP199
AP25.1 AP25.2
AP26.1 AP28.1
AP28.2 AP30.1
AP30.4 AP300
AP510 AP520
AP55.2 AP56.1
AP56.2 AP90.6
EE135 EE35.1
EE35.2 EE520
...
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 AR09.1 AR09.8
BAL-CURRENCY specified currency.
LOCATION-CODE
COMPANY KeyChange
VBASET4 VENDOR-GROUP This subset is used to access vendor AP10.1 AP10.2
VENDOR master balance records. AP210
LOCATION-CODE
COMPANY
VBASET5 COMPANY This index is used to access balance AP190 AP305
VENDOR records by company.
LOCATION-CODE
BAL-CURRENCY KeyChange
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
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
|