|
|
ACCEILINGX FILE
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 AC310 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CEX-ACTIVITY Alpha 15 BR00.3
Element: Activity The activity associated with the ceiling
and tolerance amounts maintained on
Ceiling Levels (BR00.3).
CEX-ACCT-CATEGORY Alpha 5 BR00.3
Element: Acct Category 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 Alpha 5 BR00.3
Element: Sum Acct Cat 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 Alpha 12 BR00.3
Element: Matrix Cat The billing category (attribute)
associated with the activity ceiling
records maintained in Ceiling Levels
(BR00.3).
CEX-MX-VALUE Alpha 32 BR00.3
Element: Mx Value The attribute value associated with the
billing category (attribute). The value
is maintained on the Ceiling Levels
(BR00.3).
CEX-CEILING-AMT Signed 18.2 BR00.3
Element: Intl Amt 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 Signed 15.2 BR00.3
Element: Ceiling Unit 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 Signed 18.2 AC300 BR122
Element: Intl Amt The total billed amount for the BR140 BR20.1
attribute value associated with the BR20.2 BR20.3
ceiling record on Ceiling Levels BR20.4 BR20.5
(BR00.3). BR46.1 BR46.2
BR46.4 BR580
CEX-TOT-BILLED-UNT Signed 18.2 AC300 BR122
Element: Intl Amt The total billed unit amount for the BR140 BR20.1
attribute value associated with the BR20.2 BR20.3
ceiling record on Ceiling Levels BR20.4 BR20.5
(BR00.3). BR46.1 BR46.2
BR46.4 BR580
CEX-TOT-REV-AMT Signed 18.2 AC300 BR580
Element: Intl Amt The total revenue amount for the
attribute value associated with ceiling
record on Ceiling Levels (BR00.3).
CEX-TOT-REV-UNIT Signed 15.2 AC300 BR580
Element: Tot Rev Unit The total revenue unit for the attribute
value associated with the ceiling
record on Ceiling Levels (BR00.3).
CEX-TOLERANCE-AMT Signed 18.2 BR00.3
Element: Intl Amt 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 Signed 15.2 BR00.3
Element: Tolerance UnitThe 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 Signed 18.2 AC300 BR130
Element: Intl Amt The apply tolerance amount is the BR131 BR530
cumulative amount that has been billed BR580
against the tolerance amount for the
attribute value associated with the
ceiling record on Ceiling Levels
(BR00.3).
CEX-APPLY-TOL-UNIT Signed 15.2 AC300 BR580
Element: Apply Tol UnitThe 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 Alpha 5 BR00.3
Element: Ctr Cat Grp
ACCEILINGX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CEXSET1 ACTIVITY AC10.1 AC120
ACCT-CATEGORY AC300 AC310
SUM-ACCT-CAT BR00.3 BR120
CTR-CAT-GRP BR122 BR130
MATRIX-CAT BR131 BR140
MX-VALUE BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BR521 BR530
BR580
ACCEILINGX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|
