About This Guide > FRWColDet
  
FRWColDet
Financial Report Writer Column GroupDetail
 
 
Field Name
Label
Col-Label
Format
Dec
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo2
Custom Combo Field
 
x(20)
 
 
CustomCombo3
Custom Combo Field
 
x(20)
 
 
CustomCombo4
Custom Combo Field
 
x(20)
 
 
CustomCombo5
Custom Combo Field
 
x(20)
 
 
CustomCombo6
Custom Combo Field
 
x(20)
 
 
CustomCombo7
Custom Combo Field
 
x(20)
 
 
CustomCombo8
Custom Combo Field
 
x(20)
 
 
CustomCombo9
Custom Combo Field
 
x(20)
 
 
CustomDate0
Custom Date Field
 
99/99/9999
 
 
CustomDate1
Custom Date Field
 
99/99/9999
 
 
CustomDate2
Custom Date Field
 
99/99/9999
 
 
CustomDate3
Custom Date Field
 
99/99/9999
 
 
CustomDate4
Custom Date Field
 
99/99/9999
 
 
CustomDecimal0
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal1
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal2
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal3
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal4
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomInteger0
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger1
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger2
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger3
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger4
Custom Integer Field
 
->,>>>,>>9
 
 
CustomLong0
Custom Long Field
 
x(255)
 
 
CustomLong1
Custom Long Field
 
x(255)
 
 
CustomNote
Custom Note Field
 
x(2000)
 
 
CustomShort0
Custom Short Field
 
x(20)
 
 
CustomShort1
Custom Short Field
 
x(20)
 
 
CustomShort2
Custom Short Field
 
x(20)
 
 
CustomShort3
Custom Short Field
 
x(20)
 
 
CustomShort4
Custom Short Field
 
x(20)
 
 
CustomShort5
Custom Short Field
 
x(20)
 
 
CustomShort6
Custom Short Field
 
x(20)
 
 
CustomShort7
Custom Short Field
 
x(20)
 
 
CustomShort8
Custom Short Field
 
x(20)
 
 
CustomShort9
Custom Short Field
 
x(20)
 
 
FRWAnCode_ID
Link to FRWAnCode
 
9999999999
 
 
FRWCol_ID
Link to FRWCol
 
9999999999
 
 
FRWColDet_ID
Record ID
 
9999999999
 
 
FRWColDetCalcFormula
Formula for Calcualted Column
 
x(20)
 
 
FRWColDetColumnType
Column Type
 
x(20)
 
 
FRWColDetCompareOffset
Number Periods Offset
 
99
 
 
FRWColDetCompareType
Period Compare Type
 
x(20)
 
 
FRWColDetFixedPeriodFrom
Fixed Period From
 
99
 
 
FRWColDetFixedPeriodTo
Fixed Period To
 
99
 
 
FRWColDetIsBracketNegative
Print negative amounts between brackets
Negative in Brackets
yes/no
 
 
FRWColDetIsFullAmount
Print Full Amount
Full Amount
yes/no
 
 
FRWColDetIsHiddenColumn
Hide On Report
 
yes/no
 
 
FRWColDetIsHideFuturePeriod
Hide Future Periods
 
yes/no
 
 
FRWColDetIsRedNegative
Print negative Amounts in Red
Negative in Red
yes/no
 
 
FRWColDetIsWithCurrSign
Print Currency Sign
 
yes/no
 
 
FRWColDetIsZeroSuppress
Zero Suppress
 
yes/no
 
 
FRWColDetLabel
Column Label
 
x(64)
 
 
FRWColDetLabelStyle
Label Style
 
x(20)
 
 
FRWColDetLeadTrailUnitLabel
Percentage Sign or Currency Sign Position
Sign Position
x(20)
 
 
FRWColDetMeasureStyle
Measure Style Tag
 
x(20)
 
 
FRWColDetMeasureType
Measure Type
 
x(20)
 
 
FRWColDetPeriodType
Period Type
 
x(20)
 
 
FRWColDetSeq
Column Sequence Number
 
9999
 
 
FRWColDetUnitLabel
Percentage or Currency Sign
Sign (%, $, ...)
x(20)
 
 
FRWColDetUnitType
Unit Type
 
x(20)
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
AnCodeIdx
no
FRWAnCode_ID
yes
no
 
ColIdx
no
FRWCol_ID
yes
no
 ∗
Prim
yes
FRWColDet_ID
yes
no
 
UniqIdx
yes
FRWColDetSeq
yes
no
 
 
 
FRWCol_ID
yes
no