Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARIBILLTO


                             ARIBILLTO FILE

This file contains customer bill to address information.  Bill to addresses
are optional, as the customer's main address as defined in AR09 Customer
Description will be used.

UPDATED BY

AR501

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

AIB-CUSTOMER           Alpha 9  (Right Justified)
Element: Customer      This 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: Addr1         This field contains the first line of
                       address information.

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

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

AIB-ADDR4              Alpha 30  (Lower Case)
Element: Addr1         This field contains the first 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         This field contains the two-character
                       state code of the address.

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






AIB-COUNTY             Alpha 25  (Lower Case)
Element: County        This field contains the county of the
                       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        The region code, if applicable for the
                       country. Used by Intrastat processing.
                       Must be  defined in IN02.1 (Region
                       Maintenance)

AIB-E-MAIL-ADDRESS     Alpha 60  (Lower Case)
Element: Email Address e-mail address.

                         ARIBILLTO FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AIBSET1   CUST-GROUP                                             AR501
          CUSTOMER
          BILL-TO