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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
FBLSET1
  1. CONTRACT
  2. ACTIVITY
  3. TYPE
  4. FEE-CD
  5. COMPANY
  6. ACCT-UNIT
PrimaryAC300, BR02.3, BR120, BR121, BR122, BR123, BR130, BR140 +11 more
FBLSET2
  1. TYPE
  2. CONTRACT
  3. ACTIVITY
  4. FEE-CD
  5. COMPANY
  6. ACCT-UNIT
KeyChangeBR120, BR121, BR122, BR123, BR130, BR140, BR15.2, BR151 +13 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACCNTRACTACFEEBAL

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AccntractACCNTRACTRequired
FBL-CONTRACT→CNT-CONTRACT

Programs

Updated by (22)

Referenced by (1)