Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACFEECD


                              ACFEECD 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 (Revenue Calculation) and BR120 (Invoice
Calculation).  The basis for fee is the cumulative cost amount available for
billing or revenue.

REFERENCED BY

BR120     BR121     BR122     BR123     BR130     BR140
BR151     BR152     BR156     BR20.1    BR20.2    BR20.3
BR20.4    BR20.5    BR215     BR420     BR450     BR515
BR516     BR521     BR530     BRIP.1

UPDATED BY

BR15.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FCD-FEE-CD             Alpha 5                                   BR15.1
Element: Fee Cd        The name of the code used to calculate
                       fee.

FCD-DESCRIPTION        Alpha 30  (Lower Case)                    BR15.1
Element: Description   This field displays the description.

FCD-FR-ACCT-CAT        Alpha 5                                   BR15.1
Element: Acct Category The "from" account category if an
                       account category range is defined.

FCD-TO-ACCT-CAT        Alpha 5                                   BR15.1
Element: Acct Category The "to" account category if an account
                       category range is defined.

FCD-CAT-GROUP          Alpha 15                                  BR15.1
Element: Cat Group     The account category group.  Account
                       category groups are defined via AC05.2
                       (Account Category Group).  An account
                       category group is a list of account
                       categories.

                         ACFEECD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FCDSET1   FEE-CD                                                 BR120   BR121
                                                                 BR122   BR123
                                                                 BR130   BR140
                                                                 BR15.1  BR15.2
                                                                 BR151   BR152
                                                                 BR156   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR215   BR420
                                                                 BR450   BR515
                                                                 BR516   BR521
                                                                 BR530   BRIP.1

                         ACFEECD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accatgrp       ACCATGRP     Not Required

                            FCD-CAT-GROUP    -> CGP-CAT-GROUP