project QadFinancials > class BAltCOAStruct > business logic query AltCOAStructDetPrim


Parameters


iiAltCOAStructDetIdinteger
icAltCOAStructDetCodecharacter
icAltCOAStructCodecharacter


query condition


  each AltCOAStructDet where
AltCOAStructDet.AltCOAStructDet_ID = iiAltCOAStructDetId AND
AltCOAStructDet.AltCOAStructDetCode = icAltCOAStructDetCode

      first AltCOAStruct (inner-join) where
AltCOAStruct.AltCOAStruct_ID = AltCOAStructDet.AltCOAStruct_ID AND
AltCOAStruct.AltCOAStructCode = icAltCOAStructCode


query resultset tqAltCOAStructDetPrim


field namedata typedb fielddescription
tiAltCOAStruct_IDintegerAltCOAStruct.AltCOAStruct_IDAlternate COA Structure
tcAltCOAStructCodecharacterAltCOAStruct.AltCOAStructCodeCode
tiAltCOAStructDet_IDintegerAltCOAStructDet.AltCOAStructDet_IDAlternate COA
tcAltCOAStructDetCodecharacterAltCOAStructDet.AltCOAStructDetCodeAlternate COA


Internal usage


QadFinancials
method BCOACrossRef.ValidateComponentPre
read related business field(s) on tAltCOAStructDet.ParentAltCOAStructDet_ID
read related business field(s) on tCOACrossRefDet.TargetAltCOAStructDet_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues