Lawson Insight Technical Documentation |
|
ACFEEBAL
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.
UPDATED BY
AC300 BR02.3 BR120 BR121 BR122 BR130
BR140 BR15.2 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 10 BR02.3 BR120
Element: Contract Activity Management contract. BR121 BR122
BR130 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 BR130 BR20.1
fee. 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 BR130 BR20.1
fee. BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR516
BR521 BR530
B = Billing
R = Revenue
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 BR130 BR20.1
to calculate fee. 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: Accounting UniThe 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
uwsed 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 This field stores the cumulative fee BR20.2 BR20.3
calculated the last time invoicing or BR20.4 BR20.5
revenue was run. This amount will be
stored in contract currency.
FBL-CUM-OVERAGE Signed 18.2 BR02.3 BR20.1
Element: Intl Amt This field stores the amount of fee that BR20.2 BR20.3
is over the maximum billing. This BR20.4 BR20.5
amount will be stored in contract
currency.
FBL-CUM-TOLERANCE Signed 18.2
Element: Intl Amt
FBL-BAL-RET-AMT Signed 18.2 BR02.3 BR122
Element: Intl Amt This field stores the amount of BR20.1 BR20.2
retention that has been held ot date. BR20.3 BR20.4
The value stored in this field will be BR20.5
in contract currency.
FBL-BAL-BILL-AMT Signed 18.2 BR02.3 BR20.1
Element: Intl Amt This field stores the amount of BR20.2 BR20.3
retention that has been billed to date. BR20.4 BR20.5
The value is stored in contract
currency.
FBL-BAL-REL-AMT Signed 18.2 BR02.3 BR120
Element: Intl Amt The amount of retention that has been BR121 BR122
released for billing. The value stored BR15.2 BR20.1
in this feild will be in contract BR20.2 BR20.3
currency. When a value is entered to BR20.4 BR20.5
release retention it should be entered BR420 BR521
in contract currency.
ACFEEBAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBLSET1 CONTRACT AC300 BR02.3
ACTIVITY BR120 BR121
TYPE BR122 BR130
FEE-CD BR140 BR20.1
COMPANY BR20.2 BR20.3
ACCT-UNIT BR20.4 BR20.5
BR420 BR521
BR530
FBLSET2 TYPE KeyChange BR120 BR121
CONTRACT BR122 BR130
ACTIVITY BR15.2 BR20.1
FEE-CD BR20.2 BR20.3
COMPANY BR20.4 BR20.5
ACCT-UNIT BR420 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
|