Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              BILLTO FILE

                                Bill To

The Bill To file contains alternate billing address information for a
customer.

REFERENCED BY

AC551     AR155     AR42.2    AR42.6    AR502     AR560
BL80.1    BR11.1    BR120     BR121     BR21.1    BR211
BR420     BRIP.1    PR197

UPDATED BY

AR301     AR501

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

ABS-CUSTOMER         Alpha 9  (Right Justified)                  AR501
Customer Number      Customer number.

ABS-BILL-TO          Numeric 4                                   AR501
Bill To              Bill to number.

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

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

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

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

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

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


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


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







ABS-COUNTRY          Alpha 30  (Lower Case)                      AR501
Country or Other     This field contains the country of the
                     address, or it can be used for
                     additional information such as an
                     attention name.

ABS-COUNTY           Alpha 25  (Lower Case)                      AR501
County               This field contains the county of the
                     address, or it can be used for
                     additional information such as an
                     attention name.

ABS-DEFAULT-BILL     Alpha 1                                     AR501
Default Bill To      Indicates if the address is the default
                     billing address for the customer. Valid
                     values are:

                     Y = Default bill to
                     Blank = Not default bill to
                     N = No

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


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


ABS-E-MAIL-ADDRESS   Alpha 60  (Lower Case)
E Mail Address

                         BILLTO FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ABSSET1   CUST-GROUP    This path is used for record uniqueness. AC551   AR155
          CUSTOMER                                               AR301   AR42.2
          BILL-TO                                                AR42.6  AR501
                                                                 AR502   AR560
                                                                 BL80.1  BR11.1
                                                                 BR120   BR121
                                                                 BR21.1  BR211
                                                                 BR420   BRIP.1
                                                                 PR197

ABSSET2   CUST-GROUP    This path is used to select the default
          CUSTOMER      bill to record.
          BILL-TO       Subset
                        Where DEFAULT-BILL = "Y"