project QadFinancials > class BSafStructure > business logic query SafStructureLineForExcelInteg


query condition


  each SafStructureLine where

      first Saf (inner-join) where
Saf.Saf_ID = SafStructureLine.Saf_ID AND

      first SafConcept (inner-join) where
SafConcept.SafConcept_ID = SafStructureLine.SafConcept_ID AND


query resultset tqSafStructureLineForExcelInteg


field namedata typedb fielddescription
tcCustomCombo0characterSafStructureLine.CustomCombo0Custom Combo Field
tcCustomCombo1characterSafStructureLine.CustomCombo1Custom Combo Field
tcCustomCombo2characterSafStructureLine.CustomCombo2Custom Combo Field
tcCustomCombo3characterSafStructureLine.CustomCombo3Custom Combo Field
tcCustomCombo4characterSafStructureLine.CustomCombo4Custom Combo Field
tcCustomCombo5characterSafStructureLine.CustomCombo5Custom Combo Field
tcCustomCombo6characterSafStructureLine.CustomCombo6Custom Combo Field
tcCustomCombo7characterSafStructureLine.CustomCombo7Custom Combo Field
tcCustomCombo8characterSafStructureLine.CustomCombo8Custom Combo Field
tcCustomCombo9characterSafStructureLine.CustomCombo9Custom Combo Field
ttCustomDate0dateSafStructureLine.CustomDate0Custom Date Field
ttCustomDate1dateSafStructureLine.CustomDate1Custom Date Field
ttCustomDate2dateSafStructureLine.CustomDate2Custom Date Field
ttCustomDate3dateSafStructureLine.CustomDate3Custom Date Field
ttCustomDate4dateSafStructureLine.CustomDate4Custom Date Field
tdCustomDecimal0decimalSafStructureLine.CustomDecimal0Custom Decimal Field
tdCustomDecimal1decimalSafStructureLine.CustomDecimal1Custom Decimal Field
tdCustomDecimal2decimalSafStructureLine.CustomDecimal2Custom Decimal Field
tdCustomDecimal3decimalSafStructureLine.CustomDecimal3Custom Decimal Field
tdCustomDecimal4decimalSafStructureLine.CustomDecimal4Custom Decimal Field
tiCustomInteger0integerSafStructureLine.CustomInteger0Custom Integer Field
tiCustomInteger1integerSafStructureLine.CustomInteger1Custom Integer Field
tiCustomInteger2integerSafStructureLine.CustomInteger2Custom Integer Field
tiCustomInteger3integerSafStructureLine.CustomInteger3Custom Integer Field
tiCustomInteger4integerSafStructureLine.CustomInteger4Custom Integer Field
tcCustomLong0characterSafStructureLine.CustomLong0Custom Long Field
tcCustomLong1characterSafStructureLine.CustomLong1Custom Long Field
tcCustomNotecharacterSafStructureLine.CustomNoteCustom Note Field
tcCustomShort0characterSafStructureLine.CustomShort0Custom Short Field
tcCustomShort1characterSafStructureLine.CustomShort1Custom Short Field
tcCustomShort2characterSafStructureLine.CustomShort2Custom Short Field
tcCustomShort3characterSafStructureLine.CustomShort3Custom Short Field
tcCustomShort4characterSafStructureLine.CustomShort4Custom Short Field
tcCustomShort5characterSafStructureLine.CustomShort5Custom Short Field
tcCustomShort6characterSafStructureLine.CustomShort6Custom Short Field
tcCustomShort7characterSafStructureLine.CustomShort7Custom Short Field
tcCustomShort8characterSafStructureLine.CustomShort8Custom Short Field
tcCustomShort9characterSafStructureLine.CustomShort9Custom Short Field
tiSaf_IDintegerSafStructureLine.Saf_IDLink to Saf
tcSafCodecharacterSaf.SafCodeSAF Code
tiSafConcept_IDintegerSafStructureLine.SafConcept_IDLink to SafConcept
tcSafConceptCodecharacterSafConcept.SafConceptCodeSAF Concept Code
tiSafStructure_IDintegerSafStructureLine.SafStructure_IDLink to SafStructure
tiSafStructureLine_IDintegerSafStructureLine.SafStructureLine_IDRecord ID
tcSafStructureLineBComponentcharacterSafStructureLine.SafStructureLineBComponentBusiness Component
tiSafStructureLineNumberintegerSafStructureLine.SafStructureLineNumberLine Number
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(SafStructureLine),rowid(Saf),rowid(SafConcept)


Internal usage


QadFinancials
method BSafStructure.ApiLoadSafStructure