Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ARIBILLTO FILE

UPDATED BY

AR501

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AIB-CUST-GROUP       Alpha 5
Customer Group       Customer group. Used to identify a
                     group of customer associated with one or
                     more companies.

AIB-CUSTOMER         Alpha 9  (Right Justified)
Customer Number      This field contains the number that
                     represents a customer.

AIB-BILL-TO          Numeric 4
Bill To

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

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

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

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

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

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


AIB-STATE            Alpha 2
State or Province    This field contains the two-character
                     state code of the address.


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







AIB-COUNTRY          Alpha 30  (Lower Case)
Country or Other     This 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)
County               The county for the company address.

AIB-DEFAULT-BILL     Alpha 1
Default Bill

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


AIB-REGION           Alpha 2
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