BILLTO – Bill To

System
Accounts Receivable (AR)
Prefix
ABS
Primary key
CUST-GROUP, CUSTOMER, BILL-TO
Fields
18
Updated by
4 programs
Referenced by
285 programs

BILLTO is the Bill To table in Lawson Accounts Receivable (prefix ABS). It is indexed by CUST-GROUP, CUSTOMER, BILL-TO (ABSSET1); alternate indexes: ABSSET2. It is related 1:1 to BILLTOBOD. It is updated by AR09.1, AR09.4, AR301 and AR501 and referenced by AC56.1, AC560, AP125, AP126, AP131, AP20.1, AP20.2, AP20.3 and 277 more. The table has 18 fields, 2 indexes and 1 documented relation.

About BILLTO

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

Fields (18)

Column = COBOL field name without the ABS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ABS-CUST-GROUP PK
CUST_GROUP		Alpha 5Customer group. Used to identify a group of customer associated with one or more companies.AR09.4, AR301, AR501
#ABS-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)Customer number.AR09.4, AR301, AR501
#ABS-BILL-TO PK
BILL_TO		Numeric 4Bill to number.AR09.4, AR301, AR501
#ABS-NAME
NAME		Alpha 30 (Lower Case)Displays the company description.AR09.4, AR301, AR501
#ABS-CONTACT
CONTACT		Alpha 30 (Lower Case)Displays the company description.—
#ABS-ADDR1
ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information.AR09.4, AR301, AR501
#ABS-ADDR2
ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.AR09.4, AR301, AR501
#ABS-ADDR3
ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.AR09.4, AR301, AR501
#ABS-ADDR4
ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.AR09.4, AR301, AR501
#ABS-CITY
CITY		Alpha 18 (Lower Case)This field contains the city of the address.AR09.4, AR301, AR501
#ABS-STATE
STATE		Alpha 2This field contains the two-character state code of the address.AR09.4, AR301, AR501
#ABS-ZIP
ZIP		Alpha 10This field contains the postal code of the address.AR09.4, AR301, AR501
#ABS-COUNTRY
COUNTRY		Alpha 30 (Lower Case)This field contains the country of the address, or it can be used for additional information such as an attention name.AR09.4, AR301, AR501
#ABS-COUNTY
COUNTY		Alpha 25 (Lower Case)This field contains the county of the address, or it can be used for additional information such as an attention name.AR09.4, AR301, AR501
#ABS-DEFAULT-BILL
DEFAULT_BILL		Alpha 1Indicates if the address is the default billing address for the customer. Valid values are:
  • Y Yes
  • N No
AR09.4, AR301, AR501
#ABS-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).AR09.4, AR301, AR501
#ABS-REGION
REGION		Alpha 2The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)AR09.4, AR301, AR501
#ABS-E-MAIL-ADDRESS
E_MAIL_ADDRESS		Alpha 60 (Lower Case)Email address of related Bill To.AR09.4, AR301, AR501

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ABSSET1
  1. CUST-GROUP
  2. CUSTOMER
  3. BILL-TO
PrimaryAC56.1, AC560, AP125, AP126, AP131, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)
ABSSET2
  1. CUST-GROUP
  2. CUSTOMER
  3. BILL-TO
SubsetWhere DEFAULT-BILL = "Y"AR09.1, WH20.2, WH20.7

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
BILLTOBODBILLTO

One to one (1) — lookups and parents

RelationTableRulesConditionField map
BilltobodBILLTOBODNot Required, Delete Cascades
ABS-CUST-GROUP→YCK-CUST-GROUP
ABS-CUSTOMER→YCK-CUSTOMER
ABS-BILL-TO→YCK-BILL-TO

Programs

Updated by (4)

Referenced by (285)