project QadFinancials > class BQFRWCube > dataset BQFRWCube

class dataset

object identification

primary key
QFRWCube_ID
object identity
QFRWCube_ID

table tQFRWCube

Annotation

<QUERYTYPE=Application Table - Master Data>

field namedata typemnd.description
QFRWCube_IDintegeryesRecord ID
Company_IDintegeryesLink to Company
FRWCube_IDintegeryesLink to FRWCube
CostCentre_IDintegernoLink to CostCentre
Currency_IDintegeryesLink to Currency
Division_IDintegernoLink to Division
GL_IDintegeryesLink to GL
IntercoBusinessRelation_IDintegernoLink to BusinessRelation
Journal_IDintegeryesLink to Journal
Period_IDintegeryesLink to Period
Project_IDintegernoLink to Project
Layer_IDintegernoLink to Layer
PostingHist_IDintegernoLink to PostingHist
QFRWCubeDebitLCdecimal(4)noBC Debit
QFRWCubeCreditLCdecimal(4)noBC Credit
QFRWCubeDebitTCdecimal(4)noTC Debit
QFRWCubeCreditTCdecimal(4)noTC Credit
QFRWCubeDebitCCdecimal(4)noSC Debit
QFRWCubeCreditCCdecimal(4)noSC Credit
QFRWCubeQTYdecimal(10)noQuantity
QFRWCubeInfocharacter(40)noInfo
QFRWCubeETimedecimal(4)noTime (s)
QFRWCubePostingDatedatenoPosting Date
QFRWCubePHLastModifiedDatedatenoLast Modified Date PH
QFRWCubePHLastModifiedTimeintegernoLast Modified Time PH
PeriodYearPeriodintegernoYear / GL Period
JournalTypeCodecharacter(30)noDaybook Type
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tQFRWCubeSaf

Annotation

<QUERYTYPE=Application Table - Master Data>

field namedata typemnd.description
QFRWCubeSaf_IDintegeryesRecord ID
QFRWCube_IDintegeryesLink to QFRWCube
Saf_IDintegeryesLink to Saf
SafStructure_IDintegeryesLink to SafStructure
QFRWCubeSafParentTypecharacter(20)yesSAF Parent Type
QFRWCubeSafInputSequenceintegernoSAF Input Sequence
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tQFRWCube.tc_Rowid
tc_Statuscharacternoupdate status

table tQFRWCubeSkip

Annotation

<QUERYTYPE=Application Table - Master Data>

field namedata typemnd.description
QFRWCubeSkip_IDintegeryesRecord ID
QFRWCube_IDintegernoLink to QFRWCube
FRWCube_IDintegernoLink to FRWCube
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tQFRWCube.tc_Rowid
tc_Statuscharacternoupdate status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter