Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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
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
Vendor ID            The vendor's identification code.



AAD-LOCATION-CODE    Alpha 4                                     AP51.3
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
Effective Date       The date a vendor's prices will be in
                     effect.

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

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

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

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

AAD-CITY-ADDR5       Alpha 18  (Lower Case)                      AP51.3
City or Address 5    The city or address line five.

AAD-STATE-PROV       Alpha 2                                     AP51.3
State or Province    The state or province.

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

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

AAD-COUNTRY          Alpha 30  (Lower Case)                      AP51.3
Country or Other     This 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

AADSET2   VENDOR-GROUP
          VENDOR
          LOCATION-CODE
          EFFECTIVE-DATE*