Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APCVENBAL


                             APCVENBAL FILE

                       Vendor Balance Conversion

The Vendor Balance Conversion file is used by the Vendor Conversion program
to convert vendor balance records to the Lawson Accounts Payable system. When
you run AP510 (Vendor Conversion), the system reads records in this file for
conversion into the Vendor Balance file. When Vendor Balance Conversion
records are successfully converted, they are purged from this file.

UPDATED BY

AP51.1    AP51.2    AP510

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CVB-VENDOR-GROUP       Alpha 4
Element: Vendor Group  Required. The vendor group. Must be a
                       valid record in the Vendor Group file.

CVB-VENDOR             Alpha 9  (Right Justified)                AP510
Element: Vendor ID     The vendor number. Required if not
                       using automatic vendor numbering.

CVB-LOCATION-CODE      Alpha 4
Element: Location Code The alternate vendor location.
                       Represents an alternate remittance or
                       purchasing location for the vendor.

CVB-COMPANY            Numeric 4
Element: Company       Required. The company number associated
                       with the vendor. Must be a valid record
                       in the Accounts Payable Company file.

CVB-OLD-VENDOR         Alpha 9  (Right Justified)
Element: Vendor ID     Required if using automatic vendor
                       numbering. The vendor's number as it
                       existed before conversion to the Lawson
                       Accounts Payable system.

CVB-LAST-PMT-DATE      Numeric 8  (yyyymmdd)
Element: Last Payment DThe date of the last payment made to
                       the vendor or alternate vendor location.

CVB-LAST-PUR-DATE      Numeric 8  (yyyymmdd)
Element: Date          The date of the last purchase made by
                       the vendor or alternate vendor location.

CVB-HIGHEST-BAL        Signed 18.2
Element: Intl Amt      The highest open purchase balance ever
                       reached for the vendor or alternate
                       vendor location.

CVB-CURRENT-BAL        Signed 18.2
Element: Intl Amt      The current open purchase balance (the
                       amount of released, or open, invoices)
                       for the vendor or alternate vendor
                       location.

CVB-CY-INC-WH          Signed 18.2
Element: Intl Amt      The amount of reportable income
                       withholding (such as 1099 reportable
                       income) for the vendor for the current
                       vendor group year.

CVB-LY-INC-WH          Signed 18.2
Element: Intl Amt      The amount of reportable income
                       withholding (such as 1099 reportable
                       income) for the vendor for the last
                       vendor group year.

CVB-CP-PURCH           Signed 18.2 Occurs 14 Times
Element: Intl Amt      The amount of purchase activity for the
                       vendor or alternate vendor location for
                       each period of the current vendor group
                       year.

                       Note: The 14th period is used to store
                       purchase 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 period one of the new
                       vendor group year.

CVB-LY-PURCH           Signed 18.2 Occurs 13 Times
Element: Intl Amt      The amount of purchase activity for the
                       vendor or alternate vendor location for
                       each period of the last vendor group
                       year.

CVB-CP-PAYMENT         Signed 18.2 Occurs 14 Times
Element: Intl Amt      The amount of payment activity for the
                       vendor or alternate vendor location for
                       each period of the current vendor group
                       year.

                       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 period one of the new
                       vendor group year.

CVB-LY-PAYMENT         Signed 18.2 Occurs 13 Times
Element: Intl Amt      The amount of payment activity for the
                       vendor or alternate vendor location for
                       each period of the last vendor group
                       year.

CVB-CP-DSCTAKE         Signed 18.2 Occurs 14 Times
Element: Intl Amt      The amount of the discounts taken for
                       the vendor or alternate vendor location
                       for 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 AP199 (Vendor Balance Year End) is
                       run, any balance in the 14th period will
                       be transferred to period one of the new
                       vendor group year.

CVB-LY-DSCTAKE         Signed 18.2 Occurs 13 Times
Element: Intl Amt      The amount of the discounts taken for
                       the vendor or alternate vendor location
                       for each period of the last vendor group
                       year.

CVB-CP-DSCLOST         Signed 18.2 Occurs 14 Times
Element: Intl Amt      The amount of the discounts lost for
                       the vendor or alternate vendor location
                       for 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 period one of the
                       new vendor group year.

CVB-LY-DSCLOST         Signed 18.2 Occurs 13 Times
Element: Intl Amt      The amount of the discounts lost for
                       the vendor or alternate vendor location
                       for each period of the last vendor group
                       year.

CVB-CP-GAINLOS         Signed 18.2 Occurs 14 Times
Current Period Gain    The amount of the currency gain or loss
or Loss                activity for the vendor or alternate
                       vendor location for each period of the
                       current vendor group year.

                       Note: The 14th period is used to store
                       currency gain and 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
                       period one of the new vendor group year.

CVB-LY-GAINLOS         Signed 18.2 Occurs 13 Times
Last Year's Gain or    The amount of currency gain or loss
Loss                   activity for the vendor or alternate
                       vendor location for each period of the
                       last vendor group year.

                         APCVENBAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CVBSET1   VENDOR-GROUP  This index is used to access vendor      AP51.1  AP51.2
          VENDOR        balance conversion records.              AP510
          OLD-VENDOR
          LOCATION-CODE
          COMPANY