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