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. |
|
||||||||||||||||||||
FBL-ACTIVITY Element: Activity | Alpha 15 This is the posting level activity which had the transactions which generated the fee. |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
FBL-COMPANY Element: Company | Numeric 4 The GL company on the originating transaction. |
|
||||||||||||||||||||
FBL-ACCT-UNIT Element: Acct Unit | Alpha 15 The GL accounting unit on the origination transaction. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
FBL-CUM-FEE Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||
FBL-CUM-OVERAGE Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||
FBL-CUM-TOLERANCE Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||
FBL-BAL-RET-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||
FBL-BAL-BILL-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||
FBL-BAL-REL-AMT Element: Intl Amt | Signed 18.2 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
FBLSET1 |
CONTRACT ACTIVITY TYPE FEE-CD COMPANY ACCT-UNIT |
|
| ||||||||||||||||||||||||||||
FBLSET2 |
TYPE CONTRACT ACTIVITY FEE-CD COMPANY ACCT-UNIT |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Accntract | ACCNTRACT |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.