ACCUSTDTL – No description in the Lawson data dictionary
- System
- AC Billing Revenue (BR)
- Prefix
CMB- Primary key
COMPANY,CUSTOMER- Fields
- 3
- Updated by
- 1 program
- Referenced by
- 7 programs
ACCUSTDTL is a Lawson AC Billing Revenue table (prefix CMB); no description in the lawson data dictionary. It is indexed by COMPANY, CUSTOMER (CMBSET1). It is related 1:1 to ARCOMP and ARCUSTOMER. It is updated by BR16.2 and referenced by AC56.1, AC560, BR155, BR51.1, BR52.2, BR52.4 and BR52.5. The table has 3 fields, 1 index and 2 documented relations.
About ACCUSTDTL
No description in the Lawson data dictionary.
Fields (3)
Column = COBOL field name without the CMB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CMB-COMPANY PKCOMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | BR16.2 |
CMB-CUSTOMER PKCUSTOMER | Alpha 9 (Right Justified) | This field contains the number that represents a customer. | BR16.2 |
CMB-MAINT-RENEW-DTMAINT_RENEW_DT | Numeric 8 (yyyymmdd) | — | BR16.2 |
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 |
|---|---|---|---|---|
CMBSET1 | COMPANY, CUSTOMER | Primary | AC56.1, AC560, BR155, BR16.2, BR51.1, BR52.2, BR52.4, BR52.5 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Arcomp | ARCOMP | Required | CMB-COMPANY → ACO-COMPANY | |
| Arcustomer | ARCUSTOMER | Required | CMB-COMPANY → ACM-COMPANY, CMB-CUSTOMER → ACM-CUSTOMER |
Programs
Updated by (1)
- BR16.2 Customer Maintenance Renew Date