project QadFinancials > class BCInvoice > business logic query CInvoiceForSharedSet
Description
Cinvoice to shared set
Parameters
iiCompanyId | integer | Company id |
iiCInvoiceID | integer | CInvoice ID |
icSharedSetType | character | Shared Set Type |
query condition
each CInvoice where
CInvoice.Company_Id = iiCompanyId AND
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CInvoice.Company_ID AND
each CompanySharedSet (inner-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.Company_ID = Company.Company_ID AND
first SharedSet (inner-join) where
SharedSet.SharedSet_ID = CompanySharedSet.SharedSet_ID AND
query resultset tqCInvoiceForSharedSet
field name | data type | db field | description |
tiCInvoice_ID | integer | CInvoice.CInvoice_ID | Record ID |
tiCompany_ID | integer | Company.Company_ID | Record ID |
tcCompanyCode | character | Company.CompanyCode | Entity Code |
tiSharedSet_ID | integer | SharedSet.SharedSet_ID | Record ID |
tcSharedSetCode | character | SharedSet.SharedSetCode | Shared Set Code |
tcSharedSetTypeCode | character | SharedSet.SharedSetTypeCode | Shared Set Type |
Internal usage
QadFinancials