project QadFinancials > class BMfgSupplierQuery > business logic query GetvdmstrByBusinessRelation
Parameters
| iiBusinessRelation_ID | integer | |
| iiCompanyId | integer | Company id |
query condition
each BusinessRelation where
BusinessRelation.BusinessRelation_ID = iiBusinessRelation_ID
each Creditor (inner-join) where
Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND
first SharedSet (inner-join) where
SharedSet.SharedSet_ID = Creditor.SharedSet_ID AND
each DomainSharedSet (inner-join) where
DomainSharedSet.SharedSet_ID = SharedSet.SharedSet_ID AND
first Domains (inner-join) where
Domains.Domain_ID = DomainSharedSet.Domain_ID AND
each vd_mstr (inner-join) where
vd_mstr.vd_domain = Domains.DomainCode AND
vd_mstr.vd_addr = Creditor1.CreditorCode
first Lng (inner-join) where
Lng.Lng_ID = BusinessRelation.Lng_ID AND
query resultset tqGetvdmstrByBusinessRelation
| field name | data type | db field | description |
|---|
| tiBusinessRelation_ID | integer | BusinessRelation.BusinessRelation_ID | Record ID |
| tcBusinessRelationCode | character | BusinessRelation.BusinessRelationCode | Business Relation. A code to identify the business relation.
If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create. |
| tiLng_ID | integer | Lng.Lng_ID | Record ID |
| tcLngCode | character | Lng.LngCode | Language Code |
| tcvd_addr | character | vd_mstr.vd_addr | Supplier |
| tcvd_domain | character | vd_mstr.vd_domain | Domain |
| tcvd_lang | character | vd_mstr.vd_lang | Language |
| tcvd_sort | character | vd_mstr.vd_sort | Sort Name |
Internal usage
QadFinancials