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: Customer GroupCustomer group. Used to identify a
                       group of customer associated with one or
                       more companies.

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

AIB-BILL-TO            Numeric 4
Element: Bill To       This field contains the Bill To
                       identifier relating to an address.

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     This field contains the second line of
                       address information.

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

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

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-COUNTY             Alpha 25  (Lower Case)
Element: County        The county for the company address.

AIB-DEFAULT-BILL       Alpha 1
Element: Default Bill  Indicates if this Bill To is the default
                       Bill To.  Valid values are Y and N.

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