project QadFinancials > class BCreditorReport > business logic query GetSAFDefaultByCreditor


Parameters


iiCompanyIdintegerCompany id
iiCreditor_IDinteger


query condition


  each Creditor where
Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.Creditor_ID = iiCreditor_ID

      each CreditorSafDefault (inner-join) where
CreditorSafDefault.Creditor_ID = Creditor.Creditor_ID AND

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

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


query resultset tqGetSAFDefaultByCreditor


field namedata typedb fielddescription
tiCreditor_IDintegerCreditor.Creditor_IDRecord ID
tiSaf_IDintegerSaf.Saf_IDRecord ID
tcSafCodecharacterSaf.SafCodeSAF Code
tiSafConcept_IDintegerSafConcept.SafConcept_IDRecord ID
tcSafConceptCodecharacterSafConcept.SafConceptCodeSAF Concept Code
tcSafConceptDescriptioncharacterSafConcept.SafConceptDescriptionSAF Concept Description
tcSafDescriptioncharacterSaf.SafDescriptionSAF Description


Internal usage


QadFinancials
method BCreditorReport.CreditorMasterCard