project QadFinancials > class BPosting > business logic query PostingSafByIDs

Description

Returns posting saf records based on IDs

Parameters


iiPostingSafIdintegerPostingSafId
iiPostingLineIdintegerPostingLineId
iiSafIdintegerSafID
iiSafStructureIdintegerSafStructureID

query condition


  each PostingSaf where
PostingSaf.PostingSaf_ID = iiPostingSafId AND
PostingSaf.PostingLine_ID = iiPostingLineId AND
PostingSaf.Saf_ID = iiSafId AND
PostingSaf.SafStructure_ID = iiSafStructureId

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

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

      first SafStructure (inner-join) where
SafStructure.SafStructure_ID = PostingSaf.SafStructure_ID AND

query resultset tqPostingSafByIDs


field namedata typedb fielddescription
tcCustomCombo0characterPostingSaf.CustomCombo0Custom Combo Field
tcCustomCombo1characterPostingSaf.CustomCombo1Custom Combo Field
tcCustomCombo2characterPostingSaf.CustomCombo2Custom Combo Field
tcCustomCombo3characterPostingSaf.CustomCombo3Custom Combo Field
tcCustomCombo4characterPostingSaf.CustomCombo4Custom Combo Field
tcCustomCombo5characterPostingSaf.CustomCombo5Custom Combo Field
tcCustomCombo6characterPostingSaf.CustomCombo6Custom Combo Field
tcCustomCombo7characterPostingSaf.CustomCombo7Custom Combo Field
tcCustomCombo8characterPostingSaf.CustomCombo8Custom Combo Field
tcCustomCombo9characterPostingSaf.CustomCombo9Custom Combo Field
ttCustomDate0datePostingSaf.CustomDate0Custom Date Field
ttCustomDate1datePostingSaf.CustomDate1Custom Date Field
ttCustomDate2datePostingSaf.CustomDate2Custom Date Field
ttCustomDate3datePostingSaf.CustomDate3Custom Date Field
ttCustomDate4datePostingSaf.CustomDate4Custom Date Field
tdCustomDecimal0decimalPostingSaf.CustomDecimal0Custom Decimal Field
tdCustomDecimal1decimalPostingSaf.CustomDecimal1Custom Decimal Field
tdCustomDecimal2decimalPostingSaf.CustomDecimal2Custom Decimal Field
tdCustomDecimal3decimalPostingSaf.CustomDecimal3Custom Decimal Field
tdCustomDecimal4decimalPostingSaf.CustomDecimal4Custom Decimal Field
tiCustomInteger0integerPostingSaf.CustomInteger0Custom Integer Field
tiCustomInteger1integerPostingSaf.CustomInteger1Custom Integer Field
tiCustomInteger2integerPostingSaf.CustomInteger2Custom Integer Field
tiCustomInteger3integerPostingSaf.CustomInteger3Custom Integer Field
tiCustomInteger4integerPostingSaf.CustomInteger4Custom Integer Field
tcCustomLong0characterPostingSaf.CustomLong0Custom Long Field
tcCustomLong1characterPostingSaf.CustomLong1Custom Long Field
tcCustomNotecharacterPostingSaf.CustomNoteCustom Note Field
tcCustomShort0characterPostingSaf.CustomShort0Custom Short Field
tcCustomShort1characterPostingSaf.CustomShort1Custom Short Field
tcCustomShort2characterPostingSaf.CustomShort2Custom Short Field
tcCustomShort3characterPostingSaf.CustomShort3Custom Short Field
tcCustomShort4characterPostingSaf.CustomShort4Custom Short Field
tcCustomShort5characterPostingSaf.CustomShort5Custom Short Field
tcCustomShort6characterPostingSaf.CustomShort6Custom Short Field
tcCustomShort7characterPostingSaf.CustomShort7Custom Short Field
tcCustomShort8characterPostingSaf.CustomShort8Custom Short Field
tcCustomShort9characterPostingSaf.CustomShort9Custom Short Field
tiPostingLine_IDintegerPostingSaf.PostingLine_IDLink to PostingLine
tiPostingSaf_IDintegerPostingSaf.PostingSaf_IDRecord ID
tiPostingSafInputSequenceintegerPostingSaf.PostingSafInputSequenceSequence number of this SAF within all the SAF lines for the same posting line.
tcPostingSafParentTypecharacterPostingSaf.PostingSafParentTypeParent Type. Indicates the parent type of this SAF record.
tiSaf_IDintegerPostingSaf.Saf_IDSAF Code
tcSafCodecharacterSaf.SafCodeSAF Code
tcSafConceptCodecharacterSafConcept.SafConceptCodeSAF Concept Code
tiSafStructure_IDintegerPostingSaf.SafStructure_IDStructure Code
tcSafStructureCodecharacterSafStructure.SafStructureCodeStructure Code

Internal usage


QadFinancials
method BJournalEntry.DumpJEDetForConsolid
method BJournalEntry.DumpJESumForConsolid
method BSafStructure.GetSafStructureIsReferenced