ACCEILING – Activity Ceiling
- System
- AC Billing Revenue (BR)
- Prefix
CEH- Primary key
ACTIVITY,ACCT-CATEGORY,SUM-ACCT-CAT,CTR-CAT-GRP,MATRIX-CAT- Fields
- 5
- Updated by
- 6 programs
- Referenced by
- 1 program
ACCEILING is the Activity Ceiling table in Lawson AC Billing Revenue (prefix CEH). It is indexed by ACTIVITY, ACCT-CATEGORY, SUM-ACCT-CAT, CTR-CAT-GRP, MATRIX-CAT (CEHSET1). It is related 1:1 to ACACCTCAT, ACACTIVITY and MXCATDEF. It is updated by AC10.1, AC120, AC300, BR00.1, BR00.2 and BR00.3 and referenced by BR03.1. The table has 5 fields, 1 index and 3 documented relations.
About ACCEILING
This file contains ceilings or billing maximums established and maintained via BR00.3 (Ceiling Levels). Ceilings can be established at the contract, activity, account category, summary account category and billing category level. Billing ceilings will be read up the activity level structure when running Billing and Revenue to determine amounts to bill, recognize revenue and apply to tolerances.
Fields (5)
Column = COBOL field name without the CEH- 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 |
|---|---|---|---|
#CEH-ACTIVITY PKACTIVITY | Alpha 15 | The activity associated with the ceiling and tolerance amounts maintained on Ceiling Levels (BR00.3). | BR00.3 |
#CEH-ACCT-CATEGORY PKACCT_CATEGORY | Alpha 5 | The account category associated with the activity maintained in Ceiling Levels (BR00.3). The account category or the summary account category are required. | BR00.3 |
#CEH-SUM-ACCT-CAT PKSUM_ACCT_CAT | Alpha 5 | The summary account category associated with the activity maintained in Ceiling Levels (BR00.3). The account category or the summary account category are required. | BR00.3 |
#CEH-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | The billing category (attribute) associated with the ceiling record maintained in Ceiling Levels (BR00.3). | BR00.3 |
#CEH-CTR-CAT-GRP PKCTR_CAT_GRP | Alpha 5 | — | BR00.3 |
Indexes (1)
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 |
|---|---|---|---|---|
CEHSET1 |
| Primary | AC10.1, AC120, AC300, BR00.1, BR00.2, BR00.3, BR03.1 |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Acacctcat | ACACCTCAT | Required |
| ||||
| Acactivity | ACACTIVITY | Required |
| ||||
| Mxcatdef | MXCATDEF | Required |
|
Programs
Updated by (6)
- AC10.1 Activity
- AC120 Level Reorganization
- AC300 Activity Group Purge
- BR00.1 Activity Billing
- BR00.2 Billing Detail
- BR00.3 Ceiling Levels
Referenced by (1)
- BR03.1 Billing Category Rates