Activity Management Fee Detail

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 Element: Contract	Alpha 15 Activity Management contract.	BR15.2
FDT-FEE-CEILING Element: Intl Amt	Signed 18.2 The maximum fee amount for the contract.	BR15.2
FDT-TOTAL-BILL-FEE Element: Intl Amt	Signed 18.2 The accumulated total fee billed for the contract.	BR02.3 BR140 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
FDT-TOTAL-REV-FEE Element: Intl Amt	Signed 18.2 The accumulated toal fee recognized as revenue for the contract.	BR130 BR140 BR530
FDT-TOL-AMT-FEE Element: Intl Amt	Signed 18.2 The fee tolerance amount for the contract. Tolerance is equal to the amount of	BR15.2
FDT-APPLY-TOL-AMT Element: Intl Amt	Signed 18.2	BR140
FDT-RETAINAGE-TYPE Element: Retainage Type	Alpha 1 The 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	BR15.2
FDT-PERCENT Element: Percent	Signed 7.3 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.	BR15.2
FDT-BAL-RET-AMT Element: Intl Amt	Signed 18.2	BR02.3 BR140 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
FDT-BAL-BILL-AMT Element: Intl Amt	Signed 18.2	BR02.3 BR140 BR15.2 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
FDT-BAL-REL-AMT Element: Intl Amt	Signed 18.2	BR02.3 BR120 BR121 BR122 BR123 BR140 BR15.2 BR151 BR152 BR156 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR420 BR521
FDT-RET-CEILING Element: Intl Amt	Signed 18.2	BR15.2
FDT-UNBILL-CEILING Element: Intl Amt	Signed 18.2	BR15.2
FDT-BILL-FEE-CD Element: Bill Fee Cd	Alpha 5 Occurs 6 Times 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.	BR15.2
FDT-BILL-BASIS Element: Bill Basis	Alpha 1 Occurs 6 Times 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	BR15.2
FDT-BILL-FEE-RATE Element: Bill Fee Rate	Signed 13.4 Occurs 6 Times Occurs 3 times. The rate that will be used to calculate the billing fee for this contract. Only used if basis is amounts.	BR15.2
FDT-BILL-FEE-AMT Element: Intl Amt	Signed 18.2 Occurs 6 Times 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.	BR15.2
FDT-REV-FEE-CD Element: Rev Fee Cd	Alpha 5 Occurs 6 Times 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.	BR15.2
FDT-REV-BASIS Element: Rev Basis	Alpha 1 Occurs 6 Times 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	BR15.2
FDT-REV-FEE-RATE Element: Rev Fee Rate	Signed 13.4 Occurs 6 Times Occurs 3 times. The rate that will be used to calculate the revenue fee for this contract. Only used if basis is amounts.	BR15.2
FDT-REV-FEE-AMT Element: Intl Amt	Signed 18.2 Occurs 6 Times	BR15.2
FDT-BILL-PROCESSED Element: Bill Processed	Alpha 1 Occurs 6 Times Occurs 3 times. This field indicates whether or not billing 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	BR02.3 BR120 BR121 BR122 BR123 BR140 BR15.2 BR151 BR152 BR156 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR420 BR521
FDT-REV-PROCESSED Element: Rev Processed	Alpha 1 Occurs 6 Times Occurs 3 times. This field indicates 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	BR130 BR140 BR15.2 BR530
FDT-UNBILL-RET-AMT Element: Unbill Ret Amt	Derived Derived 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 Element: Calc Type	Alpha 1 This field contains the calculation type. 1 = Cost Amount 2 = Billable/Revenue Amount
FDT-CUM-OVERAGE Element: Intl Amt	Signed 18.2	BR02.3 BR140 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
FDT-PST-ACCT-CAT Element: Pst Acct Cat	Alpha 5	BR15.2
FDT-PST-GL-CODE Element: Pst Gl Code	Alpha 4	BR15.2
FDT-REV-CUM-OVRAGE Element: Intl Amt	Signed 18.2	BR140

ACFEEDTL FILE INDEX

ACFEEDTL FILE RELATIONS

ONE TO ONE RELATIONS

All trademarks and registered trademarks are the property of their respective owners.