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