Activity Ceiling Detail

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.3	BR00.1	BR00.2
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).	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.	BR00.3
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.	BR00.3
CEX-MATRIX-CAT Element: Matrix Cat	Alpha 12 The billing category (attribute) associated with the activity ceiling records maintained in Ceiling Levels (BR00.3).	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).	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).	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).	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).	AC300 BR122 BR140 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR46.1 BR46.2 BR46.4 BR580 BRIP.1
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).	AC300 BR122 BR140 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR46.1 BR46.2 BR46.4 BR580 BRIP.1
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).	AC300 BR580
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).	AC300 BR580
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).	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).	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).	AC300 BR130 BR131 BR530 BR580
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).	AC300 BR580
CEX-CTR-CAT-GRP Element: Ctr Cat Grp	Alpha 5	BR00.3

ACCEILINGX FILE INDEX

ACCEILINGX FILE RELATIONS

ONE TO ONE RELATIONS

All trademarks and registered trademarks are the property of their respective owners.