ACBILLTO – Activity Bill To
- System
- AC Billing Revenue (BR)
- Prefix
ABL- Primary key
COMPANY,CUSTOMER,BILL-TO-GRP- Fields
- 4
- Updated by
- 1 program
- Referenced by
- 4 programs
ACBILLTO is the Activity Bill To table in Lawson AC Billing Revenue (prefix ABL). It is indexed by COMPANY, CUSTOMER, BILL-TO-GRP (ABLSET1). It is related 1:M to ACBILLTOX. It is updated by BR17.1 and referenced by BR11.1, BR20.7, BR211 and BR217. The table has 4 fields, 1 index and 1 documented relation.
About ACBILLTO
This file maintains a bill-to group for customer invoicing. A bill to group can be assigned to each customer invoice option. A bill to group is added and 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 (4)
Column = COBOL field name without the ABL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ABL-COMPANY PKCOMPANY | Numeric 4 | The company number represents an established AR company. The Bill to Group Company is maintained on Bill To Group (BR17.1). | BR17.1 |
ABL-CUSTOMER PKCUSTOMER | 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 |
ABL-BILL-TO-GRP PKBILL_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) and associated with the Customer(BR11.1). | BR17.1 |
ABL-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description of the Bill to Group maintained on Bill To Group (BR17.1). | BR17.1 |
Indexes (1)
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 |
|---|---|---|---|---|
ABLSET1 | COMPANY, CUSTOMER, BILL-TO-GRP | Primary | BR11.1, BR17.1, BR20.7, BR211, BR217 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acbilltox | ACBILLTOX | ABL-COMPANY → ABO-COMPANY, ABL-CUSTOMER → ABO-CUSTOMER, ABL-BILL-TO-GRP → ABO-BILL-TO-GRP, ABO-BILL-TO |
Programs
Updated by (1)
- BR17.1 Bill To Group