ACBILLTOX – Activity Bill To Detail

System: AC Billing Revenue (BR)
Prefix: ABO
Primary key: COMPANY, CUSTOMER, BILL-TO-GRP, BILL-TO
Fields: 5
Updated by: 1 program
Referenced by: 25 programs

ACBILLTOX is the Activity Bill To Detail table in Lawson AC Billing Revenue (prefix ABO). It is indexed by COMPANY, CUSTOMER, BILL-TO-GRP, BILL-TO (ABOSET1); alternate indexes: ABOSET2. It is related 1:1 to ACBILLTO, ARCOMP and BILLTO. It is updated by BR17.1 and referenced by BR00.1, BR00.2, BR02.3, BR120, BR121, BR122, BR123, BR140 and 17 more. The table has 5 fields, 2 indexes and 3 documented relations.

About ACBILLTOX

This file maintains the bill-to group detail for customer invoicing. A bill to group can be assigned to each customer invoice option. A bill to group is maintained via BR17 (Bill-to Group). The ACBILLTO file maintains the AR company, customer, group name and description. The ACBILLTOX file maintains the bill to's associated with the group. A bill-to group is made up of multiple bill-to addresses, which are defined in the AR Bill-To from (AR09.4). A bill-to group listing can be printed by running BR217 (Bill-To Group Listing).

Fields (5)

Column = COBOL field name without the ABO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`ABO-COMPANY` PK COMPANY	Numeric 4	The company number represents an established AR company. The company for the bill to group is maintained on the Bill to Group (BR17.1).	BR17.1
`ABO-CUSTOMER` PK CUSTOMER	Alpha 9 (Right Justified)	This field contains the number that represents a customer. The customer for the bill To group is maintained on Bill To Group (BR17.1).	BR17.1
`ABO-BILL-TO-GRP` PK BILL_TO_GRP	Numeric 4	Used to identify a group of AR bill-to addresses used for customer invoicing in the BR system. The bill to group is maintained on Bill To Group (BR17.1)	BR17.1
`ABO-BILL-TO` PK BILL_TO	Numeric 4	This field contains the mailing address for the invoice. Bill to addresses are maintained in the Accounts Receviable Bill To (AR09.4) and added in Bill To Group (BR17.1).	BR17.1
`ABO-PRIMARY-FLAG` PRIMARY_FLAG	Alpha 1	This flag identifies which bill-to address within a bill-to group should be used for invoicing and to send to the subsystems. This flag is maintained in Bill To Group (BR17.1)	BR17.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`ABOSET1`	`COMPANY`, `CUSTOMER`, `BILL-TO-GRP`, `BILL-TO`	Primary		BR17.1, BR217, BRIP.1
`ABOSET2`	`COMPANY`, `CUSTOMER`, `BILL-TO-GRP`, `BILL-TO`	Subset	Where PRIMARY-FLAG = "Y"	BR00.1, BR00.2, BR02.3, BR120, BR121, BR122, BR123, BR140 +16 more

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Field map
Acbillto	ACBILLTO	Required	`ABO-COMPANY` → `ABL-COMPANY`, `ABO-CUSTOMER` → `ABL-CUSTOMER`, `ABO-BILL-TO-GRP` → `ABL-BILL-TO-GRP`
Arcomp	ARCOMP	Required	`ABO-COMPANY` → `ACO-COMPANY`
Billto	BILLTO	Required	`ACO-CUST-GROUP` → `ABS-CUST-GROUP`, `ABO-CUSTOMER` → `ABS-CUSTOMER`, `ABO-BILL-TO` → `ABS-BILL-TO`

Programs

Updated by (1)

BR17.1 Bill To Group

Referenced by (25)

BR00.1 Activity Billing
BR00.2 Billing Detail
BR02.3 Retainer Invoice Entry
BR120 Invoice Calculation
BR121 Invoice Print and Interface
BR122 Online batch invoice process
BR123 Product Invoice Cancel
BR140 Billing and Revenue Backout
BR151 Product Invoicing
BR152 Maintenance Invoicing
BR156 Maintenance Quote
BR19.1 Single Invoice Calculation
BR20.1 Invoice Edit Contract
BR20.2 Invoice Edit Line
BR20.3 Invoice Edit Activity
BR20.4 Invoice Edit Activity and Account Category
BR20.5 Invoice Edit Transaction
BR21.1 Invoice Cancellation
BR217 Bill To Group Listing
BR420 Billing Invoice Report
BR46.1 Bill in Advance
BR46.2 Transfer Invoice Transaction
BR46.4 Split Transfer
BR521 Billing Import
BRIP.1 Invoice Print Program