Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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.

REFERENCED BY

BR450

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FBL-CONTRACT           Alpha 15                                  BR02.3  BR120
Element: Contract      Activity Management contract.             BR121   BR122
                                                                 BR123   BR130
                                                                 BR140   BR151
                                                                 BR152   BR156
                                                                 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  BR123   BR130
                       fee.                                      BR140   BR151
                                                                 BR152   BR156
                                                                 BR20.1  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      BR123   BR130
                       fee.                                      BR140   BR151
                                                                 BR152   BR156
                                                                 BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                       B = Billing                               BR20.5  BR420
                       R = Revenue                               BR516   BR521
                                                                 BR530

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  BR123   BR130
                       to calculate fee.                         BR140   BR151
                                                                 BR152   BR156
                                                                 BR20.1  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: Acct Unit     The 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
                       used 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                                                BR20.2  BR20.3
                                                                 BR20.4  BR20.5

FBL-CUM-OVERAGE        Signed 18.2                               BR02.3  BR20.1
Element: Intl Amt                                                BR20.2  BR20.3
                                                                 BR20.4  BR20.5

FBL-CUM-TOLERANCE      Signed 18.2
Element: Intl Amt

FBL-BAL-RET-AMT        Signed 18.2                               BR02.3  BR122
Element: Intl Amt                                                BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5

FBL-BAL-BILL-AMT       Signed 18.2                               BR02.3  BR20.1
Element: Intl Amt                                                BR20.2  BR20.3
                                                                 BR20.4  BR20.5

FBL-BAL-REL-AMT        Signed 18.2                               BR02.3  BR120
Element: Intl Amt                                                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                                               AC300   BR02.3
          ACTIVITY                                               BR120   BR121
          TYPE                                                   BR122   BR123
          FEE-CD                                                 BR130   BR140
          COMPANY                                                BR151   BR152
          ACCT-UNIT                                              BR156   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR420   BR521
                                                                 BR530

FBLSET2   TYPE          KeyChange                                BR120   BR121
          CONTRACT                                               BR122   BR123
          ACTIVITY                                               BR130   BR140
          FEE-CD                                                 BR15.2  BR151
          COMPANY                                                BR152   BR156
          ACCT-UNIT                                              BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5  BR420
                                                                 BR450   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