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    AP51.7    AP510

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AAD-VENDOR-GROUP       Alpha 4                                   AP51.3  AP51.7
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  AP51.7
Element: Vendor ID     The vendor's identification code.



AAD-LOCATION-CODE      Alpha 4                                   AP51.3  AP51.7
Element: Location Code A user-defined code that represents an
                       alternate purchasing or remittance
                       location for the vendor.

AAD-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     AP51.3  AP51.7
Element: Effective DateThe date a vendor's prices will be in
                       effect.

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

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

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

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

AAD-CITY-ADDR5         Alpha 30  (Lower Case)                    AP51.3  AP51.7
Element: Address 1     The city or address line five.

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

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

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

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

AAD-COUNTRY-CODE       Alpha 2                                   AP51.3  AP51.7
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

AAD-REGION             Alpha 2                                   AP51.3  AP51.7
Element: Region Code   The region code, if applicable for the
                       country. Used by Intrastat. Must be
                       defined in IN02.1 (Region Maintenance)


AAD-RESP-CODE          Alpha 5                                   AP51.7
Element: Resp Code     User defined field for label assignment
                       to contacts.

AAD-CONTACT-LVL        Numeric 3                                 AP51.7
Element: Contact Lvl   System generated assignment that can be
                       over-ridden at input.  To distinguish
                       and prioritize contacts.

                         APCVENADDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AADSET1   VENDOR-GROUP                                           AP51.3  AP51.7
          VENDOR                                                 AP510
          LOCATION-CODE
          RESP-CODE
          CONTACT-LVL
          EFFECTIVE-DATE