Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APCVENADDR


                            APCVENADDR FILE

                       Vender Address Conversion

The Vendor Address Conversion file contains vendor address information that
is converted from an external source.

UPDATED BY

AP51.3    AP510

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AAD-VENDOR-GROUP       Alpha 4                                   AP51.3
Element: Vendor Group  A vendor group represents a group of
                       vendors that can be shared by one or
                       more companies.

AAD-VENDOR             Alpha 9  (Right Justified)                AP51.3
Element: Vendor ID     The vendor's identification code.



AAD-LOCATION-CODE      Alpha 4                                   AP51.3
Purchase From
Location Code

AAD-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     AP51.3
Element: Date

AAD-ADDR1              Alpha 30  (Lower Case)                    AP51.3
Element: Address 1     This field contains the first line of
                       address information.

AAD-ADDR2              Alpha 30  (Lower Case)                    AP51.3
Element: Address 1

AAD-ADDR3              Alpha 30  (Lower Case)                    AP51.3
Element: Address 1

AAD-ADDR4              Alpha 30  (Lower Case)                    AP51.3
Element: Address 1

AAD-CITY-ADDR5         Alpha 18  (Lower Case)                    AP51.3
Element: City

AAD-STATE-PROV         Alpha 2                                   AP51.3
Element: State or ProviThe state or province.

AAD-POSTAL-CODE        Alpha 10  (Lower Case)                    AP51.3
Element: Postal Code   This field contains the postal code.

AAD-COUNTY             Alpha 25  (Lower Case)                    AP51.3
Element: County        The county for the company address.

AAD-COUNTRY            Alpha 30  (Lower Case)                    AP51.3
Element: Country or OthThis field contains the country of the
                       address, or it can be used for
                       additional information such as an
                       attention name.

                         APCVENADDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AADSET1   VENDOR-GROUP                                           AP51.3  AP510
          VENDOR
          LOCATION-CODE
          EFFECTIVE-DATE