This file contains the detailed ceiling information for a activity, account
category and attribute maintained in Ceiling Levels (BR00.3). This file
includes the attribute value, ceiling amount, ceiling unit, tolerance amount
and tolerance unit. The file also stores the cumulative total billed amounts
and units, the total revenue amounts and units and the total applied tolerance
amounts and units for each attribute value ceiling record.
UPDATED BY
AC10.1 | AC120 | AC300 | BR00.1 | BR00.2 | BR00.3 |
BR120 | BR122 | BR130 | BR131 | BR140 | BR20.1 |
BR20.2 | BR20.3 | BR20.4 | BR20.5 | BR46.1 | BR46.2 |
BR46.4 | BR521 | BR530 | BR580 | BRIP.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CEX-ACTIVITY Element: Activity | Alpha 15 The activity associated with the ceiling and tolerance amounts maintained on Ceiling Levels (BR00.3). |
|
||||||||||||||
CEX-ACCT-CATEGORY Element: Acct 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. |
|
||||||||||||||
CEX-SUM-ACCT-CAT Element: Sum 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. |
|
||||||||||||||
CEX-MATRIX-CAT Element: Matrix Cat | Alpha 12 The billing category (attribute) associated with the activity ceiling records maintained in Ceiling Levels (BR00.3). |
|
||||||||||||||
CEX-MX-VALUE Element: Mx Value | Alpha 32 The attribute value associated with the billing category (attribute). The value is maintained on the Ceiling Levels (BR00.3). |
|
||||||||||||||
CEX-CEILING-AMT Element: Intl 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). |
|
||||||||||||||
CEX-CEILING-UNIT Element: Ceiling 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). |
|
||||||||||||||
CEX-TOT-BILLED-AMT Element: Intl Amt | Signed 18.2 The total billed amount for the attribute value associated with the ceiling record on Ceiling Levels (BR00.3). |
|
||||||||||||||
CEX-TOT-BILLED-UNT Element: Intl Amt | Signed 18.2 The total billed unit amount for the attribute value associated with the ceiling record on Ceiling Levels (BR00.3). |
|
||||||||||||||
CEX-TOT-REV-AMT Element: Intl Amt | Signed 18.2 The total revenue amount for the attribute value associated with ceiling record on Ceiling Levels (BR00.3). |
|
||||||||||||||
CEX-TOT-REV-UNIT Element: Tot Rev Unit | Signed 15.2 The total revenue unit for the attribute value associated with the ceiling record on Ceiling Levels (BR00.3). |
|
||||||||||||||
CEX-TOLERANCE-AMT Element: Intl 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). |
|
||||||||||||||
CEX-TOLERANCE-UNIT Element: Tolerance 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). |
|
||||||||||||||
CEX-APPLY-TOL-AMT Element: Intl 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). |
|
||||||||||||||
CEX-APPLY-TOL-UNIT Element: Apply 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). |
|
||||||||||||||
CEX-CTR-CAT-GRP Element: Ctr Cat Grp | Alpha 5 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CEXSET1 |
ACTIVITY ACCT-CATEGORY SUM-ACCT-CAT CTR-CAT-GRP MATRIX-CAT MX-VALUE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Acacctcat | ACACCTCAT |
Required
| |||
Acactivity | ACACTIVITY |
Required
| |||
Mxcatdef | MXCATDEF |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.