ACCEILINGX – Activity Ceiling Detail
- System
- AC Billing Revenue (BR)
- Prefix
CEX- Primary key
ACTIVITY,ACCT-CATEGORY,SUM-ACCT-CAT,CTR-CAT-GRP,MATRIX-CAT,MX-VALUE- Fields
- 16
- Updated by
- 23 programs
- Referenced by
- 0 programs
ACCEILINGX is the Activity Ceiling Detail table in Lawson AC Billing Revenue (prefix CEX). It is indexed by ACTIVITY, ACCT-CATEGORY, SUM-ACCT-CAT, CTR-CAT-GRP, MATRIX-CAT, MX-VALUE (CEXSET1). It is related 1:1 to ACACCTCAT, ACACTIVITY and MXCATDEF. It is updated by AC10.1, AC120, AC300, BR00.1, BR00.2, BR00.3, BR120, BR122 and 15 more. The table has 16 fields, 1 index and 3 documented relations.
About ACCEILINGX
No description in the Lawson data dictionary.
Fields (16)
Column = COBOL field name without the CEX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CEX-ACTIVITY PKACTIVITY | Alpha 15 | The activity associated with the ceiling and tolerance amounts maintained on Ceiling Levels (BR00.3). | BR00.3 |
CEX-ACCT-CATEGORY PKACCT_CATEGORY | Alpha 5 | The account category associated with the activity maintained on Ceiling Levels (BR00.3). The account category or the summary account category are required. | BR00.3 |
CEX-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 |
CEX-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | The billing category (attribute) associated with the activity ceiling records maintained in Ceiling Levels (BR00.3). | BR00.3 |
CEX-MX-VALUE PKMX_VALUE | Alpha 32 | The attribute value associated with the billing category (attribute). The value is maintained on the Ceiling Levels (BR00.3). | BR00.3 |
CEX-CEILING-AMTCEILING_AMT | Signed 18.2 | The ceiling amount is the maximum amount that can be billed against the attribute value associated with the ceiling record maintained on Ceiling Levels (BR00.3). | BR00.3 |
CEX-CEILING-UNITCEILING_UNIT | Signed 15.2 | The ceiling unit is the maximum unit amount that can be billed against the attribute value associated with the ceiling record maintained on Ceiling Levels (BR00.3). | BR00.3 |
CEX-TOT-BILLED-AMTTOT_BILLED_AMT | Signed 18.2 | The total billed amount for the attribute value associated with the ceiling record on Ceiling Levels (BR00.3). | AC300, BR122, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 +5 more |
CEX-TOT-BILLED-UNTTOT_BILLED_UNT | Signed 18.2 | The total billed unit amount for the attribute value associated with the ceiling record on Ceiling Levels (BR00.3). | AC300, BR122, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 +5 more |
CEX-TOT-REV-AMTTOT_REV_AMT | Signed 18.2 | The total revenue amount for the attribute value associated with ceiling record on Ceiling Levels (BR00.3). | AC300, BR580 |
CEX-TOT-REV-UNITTOT_REV_UNIT | Signed 15.2 | The total revenue unit for the attribute value associated with the ceiling record on Ceiling Levels (BR00.3). | AC300, BR580 |
CEX-TOLERANCE-AMTTOLERANCE_AMT | Signed 18.2 | The tolerance amount is the maximum amount above the Ceiling amount that can be billed against the attribute value associated with the ceiling record maintained in Ceiling Levels (BR00.3). | BR00.3 |
CEX-TOLERANCE-UNITTOLERANCE_UNIT | Signed 15.2 | The tolerance unit is the maximum unit amount above the ceiling unit amount that can be billed against the attribute value associated with the ceiling record maintained in Ceiling Levels (BR00.3). | BR00.3 |
CEX-APPLY-TOL-AMTAPPLY_TOL_AMT | Signed 18.2 | The apply tolerance amount is the cumulative amount that has been billed against the tolerance amount for the attribute value associated with the ceiling record on Ceiling Levels (BR00.3). | AC300, BR130, BR131, BR530, BR580 |
CEX-APPLY-TOL-UNITAPPLY_TOL_UNIT | Signed 15.2 | The apply tolerance unit is the cumulative unit amount that has been billed against the tolerance unit amount for the attribute value associated with the ceiling on Ceiling Levels (BR00.3). | AC300, BR580 |
CEX-CTR-CAT-GRP PKCTR_CAT_GRP | Alpha 5 | — | BR00.3 |
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 |
|---|---|---|---|---|
CEXSET1 | ACTIVITY, ACCT-CATEGORY, SUM-ACCT-CAT, CTR-CAT-GRP, MATRIX-CAT, MX-VALUE | Primary | AC10.1, AC120, AC300, BR00.1, BR00.2, BR00.3, BR120, BR122 +15 more |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acacctcat | ACACCTCAT | Required | CEX-ACCT-CATEGORY → AAX-ACCT-CATEGORY | |
| Acactivity | ACACTIVITY | Required | CEX-ACTIVITY → ACV-ACTIVITY | |
| Mxcatdef | MXCATDEF | Required | CEX-MATRIX-CAT → MXC-MATRIX-CAT |
Programs
Updated by (23)
- AC10.1 Activity
- AC120 Level Reorganization
- AC300 Activity Group Purge
- BR00.1 Activity Billing
- BR00.2 Billing Detail
- BR00.3 Ceiling Levels
- BR120 Invoice Calculation
- BR122 Online batch invoice process
- BR130 Revenue Calculation
- BR131 Revenue Realization
- BR140 Billing and Revenue Backout
- 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
- BR46.1 Bill in Advance
- BR46.2 Transfer Invoice Transaction
- BR46.4 Split Transfer
- BR521 Billing Import
- BR530 Revenue Import
- BR580 Applied Balance Rebuild
- BRIP.1 Invoice Print Program