project QadFinancials > class BDInvoice > business logic query GetCompanyCodeByDInvoiceId
Parameters
| iiCompanyId | integer | Company id |
| iiDInvoiceId | integer | |
query condition
each DInvoice where
DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = iiDInvoiceId
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = DInvoice.Company_ID AND
query resultset tqGetCompanyCodeByDInvoiceId
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | DInvoice.Company_ID | Link to Company |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
Internal usage
QadFinancials