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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#CGT-ATN-OBJ-ID PKATN_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 PKLEVEL | Numeric 1 | The level at which the ceiling is maintained. Posting or Summary Ceiling Levels Contract Ceiling Levels 9 - Contract (BR10.2)_
| BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +12 more |
#CGT-ACTIVITY SET3ACTIVITY | Alpha 15 | The activity associated with the activity transaction. | BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +12 more |
#CGT-CONTRACT SET2CONTRACT | Alpha 15 | The contract associated with the activity. | BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +12 more |
#CGT-EXCEED-AMTEXCEED_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-UNITEXCEED_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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CGTSET1 |
| Primary | AC300, AC310, AC311, BR02.3, BR120, BR121, BR122, BR123 +16 more | |
CGTSET2 |
| KeyChange | BR10.1, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +8 more | |
CGTSET3 |
| 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