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