ACFEEBAL

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.
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
BR450 BR515 BR516 BR521 BR530

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


ACFEEBAL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Required
FBL-CONTRACT->CNT-CONTRACT


File created: Thu Jun 09 11:10:52 2016

Home
Contact Us



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