ACCLGTRANS – Ceiling Level Transactions

System: AC Billing Revenue (BR)
Prefix: CGT
Primary key: ATN-OBJ-ID, LEVEL
Fields: 6
Updated by: 22 programs
Referenced by: 4 programs

ACCLGTRANS is the Ceiling Level Transactions table in Lawson AC Billing Revenue (prefix CGT). It is indexed by ATN-OBJ-ID, LEVEL (CGTSET1); alternate indexes: CGTSET2 and CGTSET3. It is updated by AC300, AC311, BR02.3, BR120, BR121, BR122, BR123, BR140 and 14 more and referenced by AC310, BR10.1, BR450 and BR580. The table has 6 fields, 3 indexes and 0 documented relations.

About ACCLGTRANS

This file contains the exceeded amounts for billed transactions that are applied to the ceilings in Activity Billing (BR00.1), Billing Detail (BR00.2), Ceiling Levels (BR00.3) and Contract Detail (BR10.2). The file includes the transaction obj id, activity, contract, ceiling level, and the exceed amount and units.

Fields (6)

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

Field / column	Type	Description & values	Updated by
`CGT-ATN-OBJ-ID` PK ATN_OBJ_ID	Numeric 12	The system-defined object id associated with the Activity Management transaction (ACTRANS).	BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +12 more
`CGT-LEVEL` PK LEVEL	Numeric 1	The level at which the ceiling is maintained. Posting or Summary Ceiling Levels Contract Ceiling Levels 9 - Contract (BR10.2)_ `1` ACBILLX (BR00.2) `2` ACCEILING (BR00.3) `3` ACBILL (BR00.1) `4` Not used `5` ACBILLX (BR00.2) `6` ACCEILING (BR00.3) `7` ACBILL (BR00.1) `8` Not used	BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +12 more
`CGT-ACTIVITY` ACTIVITY	Alpha 15	The activity associated with the activity transaction.	BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +12 more
`CGT-CONTRACT` CONTRACT	Alpha 15	The contract associated with the activity.	BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +12 more
`CGT-EXCEED-AMT` EXCEED_AMT	Signed 18.2	The amount That is over the billing activity ceiling maintained in Billing (BR00.1) or Billing Detail (BR00.2) or Ceiling Levels (BR00.3).	BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +12 more
`CGT-EXCEED-UNIT` EXCEED_UNIT	Signed 15.2	The unit amount that is related to the exceed amount that is over the ceiling.	BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +12 more

Indexes (3)

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

Index	Keys	Flags	Used in
`CGTSET1`	`ATN-OBJ-ID`, `LEVEL`	Primary	AC300, AC310, AC311, BR02.3, BR120, BR121, BR122, BR123 +16 more
`CGTSET2`	`CONTRACT`, `ATN-OBJ-ID`, `LEVEL`	KeyChange	BR10.1, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +8 more
`CGTSET3`	`ACTIVITY`, `ATN-OBJ-ID`, `LEVEL`	KeyChange	BR450

Programs

Updated by (22)

AC300 Activity Group Purge
AC311 Purge and Archive
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
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
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

Referenced by (4)

AC310 Transaction Consolidation
BR10.1 Contract Parameters
BR450 Activity Aging
BR580 Applied Balance Rebuild