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

AC551     AR10.1    AR155     AR42.2    AR42.6    AR502
AR560     BR11.1    BR120     BR121     BR122     BR123
BR151     BR152     BR156     BR20.7    BR21.1    BR211
BR420     BR521     BR55.1    BRIP.1    BRPI.1    PBIP.1
PR197     WH20.2    WH20.7

UPDATED BY

AR09.4    AR09.1    AR301     AR501

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ABS-CUST-GROUP         Alpha 5                                   AR09.4  AR501
Element: Buyer Group

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

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

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

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

ABS-ADDR2              Alpha 30  (Lower Case)                    AR09.4  AR501
Element: Address 1

ABS-ADDR3              Alpha 30  (Lower Case)                    AR09.4  AR501
Element: Address 1

ABS-ADDR4              Alpha 30  (Lower Case)                    AR09.4  AR501
Element: Address 1

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

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

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






ABS-COUNTRY            Alpha 30  (Lower Case)                    AR09.4  AR501
Element: Country or OthThis 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)                    AR09.4  AR501
Element: 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                                   AR09.4  AR501
Element: Default Bill TIndicates 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                                   AR09.4  AR501
Element: 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  AR501
Element: 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)
Element: Email Address

                         BILLTO FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ABSSET1   CUST-GROUP    This path is used for record uniqueness. AC551   AR09.1
          CUSTOMER                                               AR09.4  AR10.1
          BILL-TO                                                AR155   AR301
                                                                 AR42.2  AR42.6
                                                                 AR501   AR502
                                                                 AR560   BR11.1
                                                                 BR120   BR121
                                                                 BR122   BR123
                                                                 BR151   BR152
                                                                 BR156   BR20.7
                                                                 BR21.1  BR211
                                                                 BR420   BR521
                                                                 BR55.1  BRIP.1
                                                                 BRPI.1  PBIP.1
                                                                 PR197   WH20.2
                                                                 ...

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