| field name | data type | description |
|---|
| FRWRepMstr_ID | integer | |
| FRWCol_ID | integer | |
| FRWTreeNode_ID | integer | |
| FRWAnCode_ID | integer | |
| FRWCube_ID | integer | |
| FRWChart_ID | integer | |
| FRWRepMstrCode | character | |
| FRWRepMstrDescription | character | |
| FRWRepMstrTitle | character | |
| FRWRepMstrTitleStyle | character | |
| FRWRepMstrCOADetDef | character | |
| FRWRepMstrXBRLFileBase | character | |
| FRWRepMstrLabelForCode | character | |
| FRWRepMstrCodeDescOption | character | |
| FRWRepMstrIsNegAmntBracket | logical | |
| FRWRepMstrThousandMillion | character | |
| FRWRepMstrIndentPixels | integer | |
| FRWRepMstrXBRLNameSpace | character | |
| FRWRepMstrXBRLNSPrefix | character | |
| FRWRepMstrXBRLReportType | character | |
| FRWRepMstrXBRLLocalNS | character | |
| FRWRepMstrIsZeroSuppres | logical | |
| FRWRepMstrZeroSuppressType | character | |
| FRWRepMstrLevelsToPrint | integer | |
| FRWRepMstrNumberOfDecimals | integer | |
| FRWRepMstrSubTitle | character | |
| FRWRepMstrPrintTransactions | character | |
| FRWRepMstrMaxPostingline | integer | |
| tcFRWChartCode | character | |
| tcFRWColCode | character | |
| tcFRWTreeNodeCode | character | |
| tcFRWColDescription | character | |
| tcFRWChartDescription | character | |
| tcFRWRepMstrRoles | character | Comma seperated list of the roles, which are calculated in the child table FRWRepMstrRole. |
| tcFRWTreeNodeDescription | character | |
| CustomShort0 | character | |
| CustomShort1 | character | |
| CustomShort2 | character | |
| CustomShort3 | character | |
| CustomShort4 | character | |
| CustomShort5 | character | |
| CustomShort6 | character | |
| CustomShort7 | character | |
| CustomShort8 | character | |
| CustomShort9 | character | |
| CustomCombo0 | character | |
| CustomCombo1 | character | |
| CustomCombo2 | character | |
| CustomCombo3 | character | |
| CustomCombo4 | character | |
| CustomCombo5 | character | |
| CustomCombo6 | character | |
| CustomCombo7 | character | |
| CustomCombo8 | character | |
| CustomCombo9 | character | |
| CustomLong0 | character | |
| CustomLong1 | character | |
| CustomNote | character | |
| CustomDate0 | date | |
| CustomDate1 | date | |
| CustomDate2 | date | |
| CustomDate3 | date | |
| CustomDate4 | date | |
| CustomInteger0 | integer | |
| CustomInteger1 | integer | |
| CustomInteger2 | integer | |
| CustomInteger3 | integer | |
| CustomInteger4 | integer | |
| CustomDecimal0 | decimal(4) | |
| CustomDecimal1 | decimal(4) | |
| CustomDecimal2 | decimal(4) | |
| CustomDecimal3 | decimal(4) | |
| CustomDecimal4 | decimal(4) | |
| LastModifiedDate | date | |
| LastModifiedTime | integer | |
| LastModifiedUser | character | |
| QADC01 | character | unused QAD reserved field |
| QADC02 | character | unused QAD reserved field |
| QADT01 | date | unused QAD reserved field |
| QADD01 | decimal(10) | unused QAD reserved field |
| tc_Rowid | character | |
| tc_ParentRowid | character | |
| tc_Status | character | |
QadFinancials