project QadFinancials > class BDDocument > business logic query GetDeductionByDDocumentID
Parameters
| iiCompanyId | integer | Company id |
| iiDDocumentID | integer | |
query condition
each DDocumentInvoiceXref where
DDocumentInvoiceXref.DDocument_ID = iiDDocumentID
first DInvoice (inner-join) where
DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = DDocumentInvoiceXref.DInvoice_ID AND
DInvoice.DInvoiceType = {&INVOICETYPE-DEDUCTION}
query resultset tqGetDeductionByDDocumentID
| field name | data type | db field | description |
|---|
| tiDDocument_ID | integer | DDocumentInvoiceXref.DDocument_ID | Link to DDocument |
| tiDDocumentInvoiceXref_ID | integer | DDocumentInvoiceXref.DDocumentInvoiceXref_ID | Record ID |
| tiDInvoice_ID | integer | DDocumentInvoiceXref.DInvoice_ID | Link to DInvoice |
Internal usage
QadFinancials