ACFEEDTL – Activity Management Fee Detail

System
AC Billing Revenue (BR)
Prefix
FDT
Primary key
CONTRACT
Fields
29
Updated by
20 programs
Referenced by
11 programs

ACFEEDTL is the Activity Management Fee Detail table in Lawson AC Billing Revenue (prefix FDT). It is indexed by CONTRACT (FDTSET1). It is related 1:1 to ACCNTRACT. It is updated by AC300, BR02.3, BR120, BR121, BR122, BR123, BR130, BR140 and 12 more and referenced by BR00.1, BR10.1, BR200, BR210, BR215, BR46.1, BR46.2, BR46.4 and 3 more. The table has 29 fields, 1 index and 1 documented relation.

About ACFEEDTL

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.

Fields (29)

Column = COBOL field name without the FDT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
FDT-CONTRACT PK
CONTRACT		Alpha 15Activity Management contract.BR15.2
FDT-FEE-CEILING
FEE_CEILING		Signed 18.2The maximum fee amount for the contract.BR15.2
FDT-TOTAL-BILL-FEE
TOTAL_BILL_FEE		Signed 18.2The accumulated total fee billed for the contract.BR02.3, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5
FDT-TOTAL-REV-FEE
TOTAL_REV_FEE		Signed 18.2The accumulated toal fee recognized as revenue for the contract.BR130, BR140, BR530
FDT-TOL-AMT-FEE
TOL_AMT_FEE		Signed 18.2The fee tolerance amount for the contract. Tolerance is equal to the amount ofBR15.2
FDT-APPLY-TOL-AMT
APPLY_TOL_AMT		Signed 18.2—BR140
FDT-RETAINAGE-TYPE
RETAINAGE_TYPE		Alpha 1The 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
PERCENT		Signed 7.3The 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
BAL_RET_AMT		Signed 18.2—BR02.3, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5
FDT-BAL-BILL-AMT
BAL_BILL_AMT		Signed 18.2—BR02.3, BR140, BR15.2, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5
FDT-BAL-REL-AMT
BAL_REL_AMT		Signed 18.2—BR02.3, BR120, BR121, BR122, BR123, BR140, BR15.2, BR151 +9 more
FDT-RET-CEILING
RET_CEILING		Signed 18.2—BR15.2
FDT-UNBILL-CEILING
UNBILL_CEILING		Signed 18.2—BR15.2
FDT-BILL-FEE-CD
BILL_FEE_CD		Alpha 5 Occurs 6 Times ×6Occurs 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
BILL_BASIS		Alpha 1 Occurs 6 Times ×6Occurs 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
BILL_FEE_RATE		Signed 13.4 Occurs 6 Times ×6Occurs 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
BILL_FEE_AMT		Signed 18.2 Occurs 6 Times ×6Occurs 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
REV_FEE_CD		Alpha 5 Occurs 6 Times ×6Occurs 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
REV_BASIS		Alpha 1 Occurs 6 Times ×6Occurs 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
REV_FEE_RATE		Signed 13.4 Occurs 6 Times ×6Occurs 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
REV_FEE_AMT		Signed 18.2 Occurs 6 Times ×6—BR15.2
FDT-BILL-PROCESSED
BILL_PROCESSED		Alpha 1 Occurs 6 Times ×6Occurs 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 +9 more
FDT-REV-PROCESSED
REV_PROCESSED		Alpha 1 Occurs 6 Times ×6Occurs 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
UNBILL_RET_AMT		DerivedDerived 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
CALC_TYPE		Alpha 1This field contains the calculation type.
  • 1 Cost Amount
  • 2 Billable/Revenue Amount
—
FDT-CUM-OVERAGE
CUM_OVERAGE		Signed 18.2—BR02.3, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5
FDT-PST-ACCT-CAT
PST_ACCT_CAT		Alpha 5—BR15.2
FDT-PST-GL-CODE
PST_GL_CODE		Alpha 4—BR15.2
FDT-REV-CUM-OVRAGE
REV_CUM_OVRAGE		Signed 18.2—BR140

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
FDTSET1CONTRACTPrimaryAC300, BR00.1, BR02.3, BR10.1, BR120, BR121, BR122, BR123 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AccntractACCNTRACTRequiredFDT-CONTRACT → CNT-CONTRACT

Programs

Updated by (20)

Referenced by (11)