Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APVENBAL


                             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