Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACFEEDTL


                             ACFEEDTL FILE

The ACFEECD (Fee Code) file maintains fee code names and descriptions, as well
as, the account category group or account category range tha make up the
valid account categories used to determine the driver for fee for each fee
code. Fee codes are defined on BR15.1 (Fee Code Setup).  On contracts awarded
to the government for government contracting clients, fee is the profit or
margin in addition to the costs that results from the contract.
Fee is calculated on a cumulative basis by BR130 and BR120.

All amounts in the fee code detail file are stored in contract currency.

REFERENCED BY

BR00.1    BR10.1    BR200     BR210     BR215     BR515
BR516     BRIP.1

UPDATED BY

AC300     BR02.3    BR120     BR121     BR122     BR130
BR140     BR15.2    BR20.1    BR20.2    BR20.3    BR20.4
BR20.5    BR420     BR521     BR530

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FDT-CONTRACT           Alpha 10                                  BR15.2
Element: Contract      Activity Management contract.

FDT-FEE-CEILING        Signed 18.2                               BR15.2
Element: Intl Amt      The maximum fee amount for the contract.

FDT-TOTAL-BILL-FEE     Signed 18.2                               BR02.3  BR140
Element: Intl Amt      The accumulated total fee billed for the  BR20.1  BR20.2
                       contract.                                 BR20.3  BR20.4
                                                                 BR20.5

FDT-TOTAL-REV-FEE      Signed 18.2                               BR130   BR140
Element: Intl Amt      The accumulated toal fee recognized as    BR530
                       revenue for the contract.

FDT-TOL-AMT-FEE        Signed 18.2                               BR15.2
Element: Intl Amt      The fee tolerance amount for the
                       contract.  Tolerance is equal to the
                       amount of

FDT-APPLY-TOL-AMT      Signed 18.2                               BR140
Element: Intl Amt      This field applies to revenue only. This
                       field accummulates the totla amount of
                       fee tolerance already used for this
                       contract.  This amount is used to
                       determine whether or not additonal fee
                       over the maximum is recognized as risk
                       revenue.  The value stored in this feld
                       will be in contract currency.

FDT-RETAINAGE-TYPE     Alpha 1                                   BR15.2
Element: Retainage TypeThe retention type field is used to
                       determine if the retention is a certain
                       percentage per invoice or if retention
                       begins after a certain percentage of the
                       total is reached.
                       1 = By Invoice
                       2 = By Total

FDT-PERCENT            Signed 7.3                                BR15.2
Element: Percent       The percentage determines how much
                       retention is held. It can either be a
                       percentage of each invoice, or it can be
                       a percentage of a total.

FDT-BAL-RET-AMT        Signed 18.2                               BR02.3  BR140
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.

FDT-BAL-BILL-AMT       Signed 18.2                               BR02.3  BR140
Element: Intl Amt      This field stores the amount of           BR15.2  BR20.1
                       retention that has been billed to date.   BR20.2  BR20.3
                       The value is stored in contract           BR20.4  BR20.5
                       currency.

FDT-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   BR140   BR15.2
                       in this feild will be in contract         BR20.1  BR20.2
                       currency.  When a value is entered to     BR20.3  BR20.4
                       release retention it should be entered    BR20.5  BR420
                       in contract currency.                     BR521

FDT-RET-CEILING        Signed 18.2                               BR15.2
Element: Intl Amt      For retention by invoice, the total
                       amount of retention that can be billed.
                       For retention by total, the total amount
                       of retention used with the retention
                       percentage to be determine how much fee
                       can be billed before retention starts.
                       The value entered in this field will be
                       in contract currency.

FDT-UNBILL-CEILING     Signed 18.2                               BR15.2
Element: Intl Amt      The amount of retention that has to be
                       held before billing can resume.  The
                       value stored in this field will be in
                       contract currency.

FDT-BILL-FEE-CD        Alpha 5 Occurs 6 Times                    BR15.2
Element: Bill Fee Cd   Occurs 3 times.  The billing fee code
                       name will be a user defined identifier
                       of the code that will be used to
                       calculate billing fee.

FDT-BILL-BASIS         Alpha 1 Occurs 6 Times                    BR15.2
Element: Bill Basis    Occurs 3 times.  The billing basis field
                       determines whether the billing fee
                       calculation is based on the accumulation
                       of cost amounts or cost units.
                       A = Amounts
                       U = Units

FDT-BILL-FEE-RATE      Signed 13.4 Occurs 6 Times                BR15.2
Element: Bill Fee Rate Occurs 3 times.  The rate that will be
                       used to calculate the billing fee for
                       this contract.  Only used if basis is
                       amounts.

FDT-BILL-FEE-AMT       Signed 18.2 Occurs 6 Times                BR15.2
Element: Intl Amt      Occurs 3 times.  THe amount that will be
                       used to calculate the billing fee for
                       this contract.  Only used if basis is
                       units.  This amount should be entered in
                       contract currency.

FDT-REV-FEE-CD         Alpha 5 Occurs 6 Times                    BR15.2
Element: Rev Fee Cd    Occurs 3 times.  The revenue fee code
                       name will be a user defined identifier
                       of the code that will be used to
                       calculate revenue fee.

FDT-REV-BASIS          Alpha 1 Occurs 6 Times                    BR15.2
Element: Rev Basis     Occurs 3 times.  The revenu basis field
                       determines whether the revenue fee
                       calculation is based on the accumulation
                       of cost amounts or cost units.
                       A = Amounts
                       U = Units

FDT-REV-FEE-RATE       Signed 13.4 Occurs 6 Times                BR15.2
Element: Rev Fee Rate  Occurs 3 times.  The rate that will be
                       used to calculate the revenue fee for
                       this contract.  Only used if basis is
                       amounts.

FDT-REV-FEE-AMT        Signed 18.2 Occurs 6 Times                BR15.2
Element: Intl Amt      Occurs 3 times.  The amount that will be
                       used to calculate the revenue fee for
                       this contract.  Only used if basis is
                       units.  This amount should be entered in
                       contract currency.

FDT-BILL-PROCESSED     Alpha 1 Occurs 6 Times                    BR02.3  BR120
Element: Bill ProcessedOccurs 3 times.  This field indicates     BR121   BR122
                       whether or not billing has occurred for   BR140   BR20.1
                       this contract/fee code combination. Used  BR20.2  BR20.3
                       to determine whether a fee code           BR20.4  BR20.5
                       assignment can be modified or deleted.    BR420   BR521
                       Y = Yes
                       N = No

FDT-REV-PROCESSED      Alpha 1 Occurs 6 Times                    BR130   BR140
Element: Rev Processed Occurs 3 times.  This field indicates     BR530
                       whether or not revenue has occurred for
                       this contract/fee code combination. Used
                       to determine whether a fee code
                       assignment can be modified or deleted.
                       Y = Yes
                       N = No

FDT-UNBILL-RET-AMT     Derived
Element: Unbill Ret AmtDerived field.  The amount of retention
                       that has been held to date but has not
                       been billed. The value calculated will
                       be in contract currency.

FDT-CALC-TYPE          Alpha 1
Element: Calculation TyThis field contains the calculation
                       type.
                       1 = Cost Amount
                       2 = Billable/Revenue Amount

FDT-CUM-OVERAGE        Signed 18.2                               BR02.3  BR140
Element: Intl Amt      This field stores the amount of fee that  BR20.1  BR20.2
                       is over the maximum billing.  This        BR20.3  BR20.4
                       amount will be stored in contract         BR20.5
                       currency.

FDT-PST-ACCT-CAT       Alpha 5                                   BR15.2
Element: Pst Acct Cat

FDT-PST-GL-CODE        Alpha 4                                   BR15.2
Element: Pst Gl Code

FDT-REV-CUM-OVRAGE     Signed 18.2
Element: Intl Amt

                         ACFEEDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FDTSET1   CONTRACT                                               AC300   BR00.1
                                                                 BR02.3  BR10.1
                                                                 BR120   BR121
                                                                 BR122   BR130
                                                                 BR140   BR15.1
                                                                 BR15.2  BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR200   BR210
                                                                 BR215   BR420
                                                                 BR515   BR516
                                                                 BR521   BR530
                                                                 BRIP.1

                         ACFEEDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntract      ACCNTRACT    Required

                            FDT-CONTRACT    -> CNT-CONTRACT