|
ACFEEBAL FILE
The fee balance file stores cumulative costs, fee and overage which will be
used in calculating the billing and revenue fee amounts. All amounts stored
in the fee balance file are stored in contract currency.
REFERENCED BY
BR450
UPDATED BY
AC300 BR02.3 BR120 BR121 BR122 BR123
BR130 BR140 BR15.2 BR151 BR152 BR156
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR420
BR515 BR516 BR521 BR530
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FBL-CONTRACT Alpha 15 BR02.3 BR120
Element: Contract Activity Management contract. BR121 BR122
BR123 BR130
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR516 BR521
BR530
FBL-ACTIVITY Alpha 15 BR02.3 BR120
Element: Activity This is the posting level activity which BR121 BR122
had the transactions which generated the BR123 BR130
fee. BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR516 BR521
BR530
FBL-TYPE Alpha 2 BR02.3 BR120
Element: Type Type is used to determine whether the BR121 BR122
record is for billing fee or revenue BR123 BR130
fee. BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
B = Billing BR20.5 BR420
R = Revenue BR516 BR521
BR530
FBL-FEE-CD Alpha 5 BR02.3 BR120
Element: Fee Cd The fee code name will be a user defined BR121 BR122
identifier of the code that will be used BR123 BR130
to calculate fee. BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR516 BR521
BR530
FBL-COMPANY Numeric 4 BR130 BR516
Element: Company The GL company on the originating BR530
transaction.
FBL-ACCT-UNIT Alpha 15 BR130 BR516
Element: Acct Unit The GL accounting unit on the BR530
origination transaction.
FBL-CUM-AMOUNT Signed 18.2 BR02.3 BR20.1
Element: Intl Amt This field stores the cumulative amounts BR20.2 BR20.3
used to calculate fee. It is all costs BR20.4 BR20.5
available for billing and revenue based BR515 BR516
on the account categories set up as
drivers on fee code set up. This amount
will be stored in contract currency.
FBL-CUM-UNIT Signed 15.2 BR02.3 BR20.1
Element: Cum Unit This field stores the cumulative units BR20.2 BR20.3
used to calculate fee. It is all costs BR20.4 BR20.5
available for billing or revenue based BR515 BR516
on the account categories set up as
drivers on fee code set up.
FBL-CUM-FEE Signed 18.2 BR02.3 BR20.1
Element: Intl Amt BR20.2 BR20.3
BR20.4 BR20.5
FBL-CUM-OVERAGE Signed 18.2 BR02.3 BR20.1
Element: Intl Amt BR20.2 BR20.3
BR20.4 BR20.5
FBL-CUM-TOLERANCE Signed 18.2
Element: Intl Amt
FBL-BAL-RET-AMT Signed 18.2 BR02.3 BR122
Element: Intl Amt BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
FBL-BAL-BILL-AMT Signed 18.2 BR02.3 BR20.1
Element: Intl Amt BR20.2 BR20.3
BR20.4 BR20.5
FBL-BAL-REL-AMT Signed 18.2 BR02.3 BR120
Element: Intl Amt BR121 BR122
BR123 BR140
BR15.2 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521
ACFEEBAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBLSET1 CONTRACT AC300 BR02.3
ACTIVITY BR120 BR121
TYPE BR122 BR123
FEE-CD BR130 BR140
COMPANY BR151 BR152
ACCT-UNIT BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR521
BR530
FBLSET2 TYPE KeyChange BR120 BR121
CONTRACT BR122 BR123
ACTIVITY BR130 BR140
FEE-CD BR15.2 BR151
COMPANY BR152 BR156
ACCT-UNIT BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR450 BR515
BR516 BR521
BR530
ACFEEBAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Required
FBL-CONTRACT -> CNT-CONTRACT
|