Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BILLTO


                              BILLTO FILE

                                Bill To

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

REFERENCED BY

AC56.1    AC560     AR155     AR42.2    AR42.6    AR502
AR560     ARLL.1    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL31.1
BL31.2    BL31.3    BL31.5    BL31.7    BL32.3    BL32.4
BL520     BL80.1    BL820     BL92.1    BR00.1    BR00.2
BR02.3    BR11.1    BR120     BR121     BR122     BR123
BR140     BR151     BR152     BR156     BR17.1    BR19.1
BR20.1    BR20.2    BR20.3    BR20.4    BR20.5    BR20.7
BR21.1    BR211     BR217     BR420     BR46.1    BR46.2
BR46.4    BR521     BR55.1    BRIP.1    WH20.2    WH20.7
PW555

UPDATED BY

AR09.4    AR09.1    AR301     AR501     PW550

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

ABS-CUSTOMER           Alpha 9  (Right Justified)                AR09.4  AR301
Element: Customer      Customer number.                          AR501   PW550

ABS-BILL-TO            Numeric 4                                 AR09.4  AR301
Element: Bill To       Bill to number.                           AR501   PW550

ABS-NAME               Alpha 30  (Lower Case)                    AR09.4  AR301
Element: Name          Displays the company description.         AR501   PW550

ABS-CONTACT            Alpha 30  (Lower Case)
Element: Name          Displays the company description.

ABS-ADDR1              Alpha 30  (Lower Case)                    AR09.4  AR301
Element: Addr1         This field contains the first line of     AR501   PW550
                       address information.

ABS-ADDR2              Alpha 30  (Lower Case)                    AR09.4  AR301
Element: Addr1         This field contains the first line of     AR501   PW550
                       address information.

ABS-ADDR3              Alpha 30  (Lower Case)                    AR09.4  AR301
Element: Addr1         This field contains the first line of     AR501   PW550
                       address information.

ABS-ADDR4              Alpha 30  (Lower Case)                    AR09.4  AR301
Element: Addr1         This field contains the first line of     AR501   PW550
                       address information.

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

ABS-STATE              Alpha 2                                   AR09.4  AR301
Element: State         This field contains the two-character     AR501   PW550
                       state code of the address.

ABS-ZIP                Alpha 10                                  AR09.4  AR301
Element: Zip           This field contains the postal code of    AR501   PW550
                       the address.






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

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

ABS-DEFAULT-BILL       Alpha 1                                   AR09.4  AR301
Element: Default Bill TIndicates if the address is the default   AR501   PW550
                       billing address for the customer. Valid
                       values are:

                       Y = Yes
                       N = No

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

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


ABS-E-MAIL-ADDRESS     Alpha 60  (Lower Case)                    AR09.4  AR301
Element: Email Address Email address of related Bill To.         AR501   PW550

                         BILLTO FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ABSSET1   CUST-GROUP                                             AC56.1  AC560
          CUSTOMER                                               AR09.1  AR09.4
          BILL-TO                                                AR155   AR301
                                                                 AR42.2  AR42.6
                                                                 AR501   AR502
                                                                 AR560   ARLL.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4
                                                                 BL520   BL80.1
                                                                 ...

ABSSET2   CUST-GROUP    Subset                                   AR09.1  AR560
          CUSTOMER      Where DEFAULT-BILL = "Y"                 BL120   BL122
          BILL-TO                                                BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 PW555   WH20.2
                                                                 WH20.7