| field name | data type | db field | description |
|---|
| tiFRWAnCode_ID | integer | FRWColDet.FRWAnCode_ID | Link to FRWAnCode |
| tiFRWCol_ID | integer | FRWColDet.FRWCol_ID | Link to FRWCol |
| tiFRWColDet_ID | integer | FRWColDet.FRWColDet_ID | Record ID |
| tcFRWColDetCalcFormula | character | FRWColDet.FRWColDetCalcFormula | Formula for Calcualted Column |
| tcFRWColDetColumnType | character | FRWColDet.FRWColDetColumnType | Column Type |
| tiFRWColDetCompareOffset | integer | FRWColDet.FRWColDetCompareOffset | Number Periods Offset |
| tcFRWColDetCompareType | character | FRWColDet.FRWColDetCompareType | Period Compare Type |
| tiFRWColDetFixedPeriodFrom | integer | FRWColDet.FRWColDetFixedPeriodFrom | Fixed Period From |
| tiFRWColDetFixedPeriodTo | integer | FRWColDet.FRWColDetFixedPeriodTo | Fixed Period To |
| tlFRWColDetIsBracketNegative | logical | FRWColDet.FRWColDetIsBracketNegative | Print negative amounts between brackets |
| tlFRWColDetIsFullAmount | logical | FRWColDet.FRWColDetIsFullAmount | Print Full Amount |
| tlFRWColDetIsHiddenColumn | logical | FRWColDet.FRWColDetIsHiddenColumn | Hide On Report |
| tlFRWColDetIsHideFuturePeriod | logical | FRWColDet.FRWColDetIsHideFuturePeriod | Hide Future Periods |
| tlFRWColDetIsRedNegative | logical | FRWColDet.FRWColDetIsRedNegative | Print negative Amounts in Red |
| tlFRWColDetIsWithCurrSign | logical | FRWColDet.FRWColDetIsWithCurrSign | Print Currency Sign |
| tlFRWColDetIsZeroSuppress | logical | FRWColDet.FRWColDetIsZeroSuppress | Zero Suppress |
| tcFRWColDetLabel | character | FRWColDet.FRWColDetLabel | Column Label |
| tcFRWColDetLabelStyle | character | FRWColDet.FRWColDetLabelStyle | Label Style |
| tcFRWColDetLeadTrailUnitLabel | character | FRWColDet.FRWColDetLeadTrailUnitLabel | Percentage Sign or Currency Sign Position |
| tcFRWColDetMeasureStyle | character | FRWColDet.FRWColDetMeasureStyle | Measure Style Tag |
| tcFRWColDetMeasureType | character | FRWColDet.FRWColDetMeasureType | Measure Type |
| tcFRWColDetPeriodType | character | FRWColDet.FRWColDetPeriodType | Period Type |
| tiFRWColDetSeq | integer | FRWColDet.FRWColDetSeq | Column Sequence Number |
| tcFRWColDetUnitLabel | character | FRWColDet.FRWColDetUnitLabel | Percentage or Currency Sign |
| tcFRWColDetUnitType | character | FRWColDet.FRWColDetUnitType | Unit Type |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(FRWColDet) |
each FRWColDet where