Lawson Insight Technical Documentation |
|
BILLTO
BILLTO FILE
Bill To
The Bill To file contains alternate billing address information for a
customer.
REFERENCED BY
AR155 AR42.2 AR42.6 AR502 AR560 ARLL.1
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL80.1 BL820
BL92.1 BR00.1 BR00.2 BR02.3 BR11.1 BR120
BR121 BR122 BR140 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 BRIP.1 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 OE111 OE113 OE114
OE129 OE13.2 OE14.4 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510
OE530 OE810 OE830 OE85.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 AR301
Element: Customer GroupCustomer group. Used to identify a AR501
group of customer associated with one or
more companies.
ABS-CUSTOMER Alpha 9 (Right Justified) AR09.4 AR301
Element: Customer NumbeCustomer number. AR501
ABS-BILL-TO Numeric 4 AR09.4 AR301
Element: Bill To Bill to number. AR501
ABS-NAME Alpha 30 (Lower Case) AR09.4 AR301
Element: Name Displays the company description. AR501
ABS-ADDR1 Alpha 30 (Lower Case) AR09.4 AR301
Element: Address 1 This field contains the first line of AR501
address information.
ABS-ADDR2 Alpha 30 (Lower Case) AR09.4 AR301
Element: Address 1 This field contains the second line of AR501
address information.
ABS-ADDR3 Alpha 30 (Lower Case) AR09.4 AR301
Element: Address 1 This field contains the third line of AR501
address information.
ABS-ADDR4 Alpha 30 (Lower Case) AR09.4 AR301
Element: Address 1 This field contains the fourth line of AR501
address information.
ABS-CITY Alpha 18 (Lower Case) AR09.4 AR301
Element: City This field contains the city of the AR501
address.
ABS-STATE Alpha 2 AR09.4 AR301
Element: State or ProviThis field contains the two-character AR501
state code of the address.
ABS-ZIP Alpha 10 AR09.4 AR301
Element: Postal Code This field contains the postal code of AR501
the address.
ABS-COUNTRY Alpha 30 (Lower Case) AR09.4 AR301
Element: Country or OthThis field contains the country of the AR501
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
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
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 AR301
Element: Country Code The country code. Required for VAT and AR501
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
ABS-REGION Alpha 2 AR09.4 AR301
Element: Region Code The region code, if applicable for the AR501
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 AR501
BILLTO FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABSSET1 CUST-GROUP This path is used for record uniqueness. AR09.1 AR09.4
CUSTOMER AR155 AR301
BILL-TO AR42.2 AR42.6
AR501 AR502
AR560 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL80.1 BL820
BL92.1 BR00.1
BR00.2 BR02.3
BR11.1 BR120
BR121 BR122
...
ABSSET2 CUST-GROUP This path is used to select the default AR09.1 AR560
CUSTOMER bill to record. BL120 BL122
BILL-TO Subset BL130 BL20.1
Where DEFAULT-BILL = "Y" BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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 OE111
OE113 OE114
...
|