project QadFinancials > class BCInvoice > business logic query CInvoiceForDomain
Parameters
| iiCompanyId | integer | Company id |
| iiCInvoiceID | integer | |
query condition
each CInvoice where
CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = iiCInvoiceID
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CInvoice.Company_ID AND
first Domains (inner-join) where
Domains.Domain_ID = Company.Domain_ID AND
query resultset tqCInvoiceForDomain
| 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 |
| tiDomain_ID | integer | Domains.Domain_ID | Record ID |
| tcDomainCode | character | Domains.DomainCode | Domain |
Internal usage
QadFinancials