project QadFinancials > class BBillReport > business logic query GetDDocInvXrefByDinvoiceId
Parameters
| iiCompanyId | integer | Company id |
| iiDInvoiceId | integer | |
query condition
each DDocumentInvoiceXref where
DDocumentInvoiceXref.DInvoice_ID = iiDInvoiceId
first DDocument (inner-join) where
DDocument.Company_Id = iiCompanyId AND
DDocument.DDocument_ID = DDocumentInvoiceXref.DDocument_ID AND
query resultset tqGetDDocInvXrefByDinvoiceId
| field name | data type | db field | description |
|---|
| tiDDocument_ID | integer | DDocument.DDocument_ID | Record ID |
| tiDDocumentInvoiceXref_ID | integer | DDocumentInvoiceXref.DDocumentInvoiceXref_ID | Record ID |
Internal usage
QadFinancials