ACFEEBAL – The fee balance file stores cumulative costs, fee and overage which will be used in calculating the billing and revenue…

System
AC Billing Revenue (BR)
Prefix
FBL
Primary key
CONTRACT, ACTIVITY, TYPE, FEE-CD, COMPANY, ACCT-UNIT
Fields
14
Updated by
22 programs
Referenced by
1 program

ACFEEBAL is the The fee balance file stores cumulative costs, fee and overage which will be used in calculating the billing and revenue… table in Lawson AC Billing Revenue (prefix FBL). It is indexed by CONTRACT, ACTIVITY, TYPE, FEE-CD, COMPANY, ACCT-UNIT (FBLSET1); alternate indexes: FBLSET2. It is related 1:1 to ACCNTRACT. It is updated by AC300, BR02.3, BR120, BR121, BR122, BR123, BR130, BR140 and 14 more and referenced by BR450. The table has 14 fields, 2 indexes and 1 documented relation.

About 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.

Fields (14)

Column = COBOL field name without the FBL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
FBL-CONTRACT PK
CONTRACT		Alpha 15Activity Management contract.BR02.3, BR120, BR121, BR122, BR123, BR130, BR140, BR151 +11 more
FBL-ACTIVITY PK
ACTIVITY		Alpha 15This is the posting level activity which had the transactions which generated the fee.BR02.3, BR120, BR121, BR122, BR123, BR130, BR140, BR151 +11 more
FBL-TYPE PK
TYPE		Alpha 2Type 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 +11 more
FBL-FEE-CD PK
FEE_CD		Alpha 5The 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 +11 more
FBL-COMPANY PK
COMPANY		Numeric 4The GL company on the originating transaction.BR130, BR516, BR530
FBL-ACCT-UNIT PK
ACCT_UNIT		Alpha 15The GL accounting unit on the origination transaction.BR130, BR516, BR530
FBL-CUM-AMOUNT
CUM_AMOUNT		Signed 18.2This 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
CUM_UNIT		Signed 15.2This 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
CUM_FEE		Signed 18.2—BR02.3, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5
FBL-CUM-OVERAGE
CUM_OVERAGE		Signed 18.2—BR02.3, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5
FBL-CUM-TOLERANCE
CUM_TOLERANCE		Signed 18.2——
FBL-BAL-RET-AMT
BAL_RET_AMT		Signed 18.2—BR02.3, BR122, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5
FBL-BAL-BILL-AMT
BAL_BILL_AMT		Signed 18.2—BR02.3, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5
FBL-BAL-REL-AMT
BAL_REL_AMT		Signed 18.2—BR02.3, BR120, BR121, BR122, BR123, BR140, BR15.2, BR151 +9 more

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
FBLSET1CONTRACT, ACTIVITY, TYPE, FEE-CD, COMPANY, ACCT-UNITPrimaryAC300, BR02.3, BR120, BR121, BR122, BR123, BR130, BR140 +11 more
FBLSET2TYPE, CONTRACT, ACTIVITY, FEE-CD, COMPANY, ACCT-UNITKeyChangeBR120, BR121, BR122, BR123, BR130, BR140, BR15.2, BR151 +13 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AccntractACCNTRACTRequiredFBL-CONTRACT → CNT-CONTRACT

Programs

Updated by (22)

Referenced by (1)