|
|
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 BR46.1
BR46.2 BR46.4 BR515 BR516 BRIP.1
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
BR521 BR530
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FDT-CONTRACT Alpha 15 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
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 BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
FDT-BAL-BILL-AMT Signed 18.2 BR02.3 BR140
Element: Intl Amt BR15.2 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
FDT-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
FDT-RET-CEILING Signed 18.2 BR15.2
Element: Intl Amt
FDT-UNBILL-CEILING Signed 18.2 BR15.2
Element: Intl Amt
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
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 BR123 BR140
this contract/fee code combination. Used BR15.2 BR151
to determine whether a fee code BR152 BR156
assignment can be modified or deleted. BR20.1 BR20.2
Y = Yes BR20.3 BR20.4
N = No BR20.5 BR420
BR521
FDT-REV-PROCESSED Alpha 1 Occurs 6 Times BR130 BR140
Element: Rev Processed Occurs 3 times. This field indicates BR15.2 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: Calc Type This field contains the calculation
type.
1 = Cost Amount
2 = Billable/Revenue Amount
FDT-CUM-OVERAGE Signed 18.2 BR02.3 BR140
Element: Intl Amt BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
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 BR123
BR130 BR140
BR15.1 BR15.2
BR151 BR152
BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR200 BR210
BR215 BR420
BR46.1 BR46.2
BR46.4 BR515
BR516 BR521
...
ACFEEDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Required
FDT-CONTRACT -> CNT-CONTRACT
|
