project QadFinancials > class BDDocument > business logic query GetDeductionByDDocIDStatus
Parameters
| iiCompanyId | integer | Company id |
| iiDDocumentID | integer | |
| icDeductionStatusList | character | |
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}
each DInvoiceDeduction (inner-join) where
DInvoiceDeduction.DInvoice_ID = DInvoice.DInvoice_ID AND
DInvoiceDeduction.DInvoiceDeductionStatus can-do icDeductionStatusList
query resultset tqGetDeductionByDDocIDStatus
| 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