Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              BILLTO FILE

                                Bill To

Bill To

REFERENCED BY

AC15.2    AR155     AR42.2    AR42.6    AR502     AR560
BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL80.1    BL820
BL92.1    BL940     OE10.1    OE10.2    OE10.3    OE10.4
OE10.5    OE10.6    OE10.7    OE10.8    OE11.1    OE11.4
OE11.8    OE11.9    OE110     OE113     OE114     OE129
OE14.4    OE15.1    OE15.2    OE15.3    OE15.4    OE15.5
OE15.7    OE30.1    OE30.2    OE30.3    OE30.4    OE30.5
OE30.6    OE30.7    OE30.9    OE510     OE810     OE830
OE85.1    OE920     OE950     PBIP.1    WH20.2    WH20.7

UPDATED BY

AR09.4    AR09.1    AR301

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

ABS-NAME             Alpha 30  (Lower Case)                      AR09.4
Name                 Contains the company description.

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

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

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

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

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

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

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



ABS-COUNTRY          Alpha 30  (Lower Case)                      AR09.4
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                                    AR09.4
County               For use in a future release.

ABS-DEFAULT-BILL     Alpha 1                                     AR09.4
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

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


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


                         BILLTO FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ABSSET1   CUST-GROUP    This path is used for record uniqueness. AC15.2  AR09.1
          CUSTOMER                                               AR09.4  AR155
          BILL-TO                                                AR301   AR42.2
                                                                 AR42.6  AR502
                                                                 AR560   BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL80.1
                                                                 BL820   BL92.1
                                                                 BL940   OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 ...

ABSSET2   CUST-GROUP    This path is used to select the default  OE10.1  OE10.2
          CUSTOMER      bill to record.                          OE10.3  OE10.4
          BILL-TO       Subset                                   OE10.5  OE10.6
                        Where DEFAULT-BILL = "Y"                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE14.4
                                                                 OE15.1  OE15.2
                                                                 OE15.3  OE15.4
                                                                 OE15.5  OE15.7
                                                                 OE510   OE810
                                                                 OE920   WH20.2
                                                                 WH20.7