ACHISTCLG – Billing Overage

System
AC Billing Revenue (BR)
Prefix
HCT
Primary key
OBJ-ID, LINE-NBR, ATN-OBJ-ID, LEVEL
Fields
7
Updated by
9 programs
Referenced by
11 programs

ACHISTCLG is the Billing Overage table in Lawson AC Billing Revenue (prefix HCT). It is indexed by OBJ-ID, LINE-NBR, ATN-OBJ-ID, LEVEL (HCTSET1); alternate indexes: HCTSET2. It is updated by BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 and 1 more and referenced by BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 and 3 more. The table has 7 fields, 2 indexes and 0 documented relations.

About ACHISTCLG

No description in the Lawson data dictionary.

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
HCT-OBJ-ID PK
OBJ_ID
Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.BRIP.1
HCT-CONTRACT
CONTRACT
Alpha 15Activity Management contract.BRIP.1
HCT-ATN-OBJ-ID PK
ATN_OBJ_ID
Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.BRIP.1
HCT-LEVEL PK
LEVEL
Numeric 1BRIP.1
HCT-AMOUNT
AMOUNT
Signed 18.2BRIP.1
HCT-UNIT
UNIT
Signed 15.2BRIP.1
HCT-LINE-NBR PK
LINE_NBR
Numeric 6This field contains the line number.BRIP.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
HCTSET1OBJ-ID, LINE-NBR, ATN-OBJ-ID, LEVELPrimaryBR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +12 more
HCTSET2CONTRACT, OBJ-ID, LINE-NBR, ATN-OBJ-ID, LEVELKeyChange

Programs

Updated by (9)

Referenced by (11)