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