project QadFinancials > class BCreditorReport > business logic query GetSAFDefaultByCreditor
Parameters
iiCompanyId | integer | Company id |
iiCreditor_ID | integer | |
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 name | data type | db field | description |
tiCreditor_ID | integer | Creditor.Creditor_ID | Record ID |
tiSaf_ID | integer | Saf.Saf_ID | Record ID |
tcSafCode | character | Saf.SafCode | SAF Code |
tiSafConcept_ID | integer | SafConcept.SafConcept_ID | Record ID |
tcSafConceptCode | character | SafConcept.SafConceptCode | SAF Concept Code |
tcSafConceptDescription | character | SafConcept.SafConceptDescription | SAF Concept Description |
tcSafDescription | character | Saf.SafDescription | SAF Description |
Internal usage
QadFinancials