Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARIBILLTO


                             ARIBILLTO FILE

UPDATED BY

AR501

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AIB-CUST-GROUP         Alpha 5
Element: Buyer Group

AIB-CUSTOMER           Alpha 9  (Right Justified)
Element: Customer NumbeThis field contains the number that
                       represents a customer.

AIB-BILL-TO            Numeric 4
Element: Ship-to Code

AIB-NAME               Alpha 30  (Lower Case)
Element: Name          Displays the company description.

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

AIB-ADDR2              Alpha 30  (Lower Case)
Element: Address 1

AIB-ADDR3              Alpha 30  (Lower Case)
Element: Address 1

AIB-ADDR4              Alpha 30  (Lower Case)
Element: Address 1

AIB-CITY               Alpha 18  (Lower Case)
Element: City          This field contains the city of the
                       address.

AIB-STATE              Alpha 2
Element: State or ProviThis field contains the two-character
                       state code of the address.

AIB-ZIP                Alpha 10
Element: Postal Code   This field contains the postal code of
                       the address.






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

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

AIB-DEFAULT-BILL       Alpha 1
Element: Default Bill

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

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

                         ARIBILLTO FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AIBSET1   CUST-GROUP                                             AR501
          CUSTOMER
          BILL-TO