project QadFinancials > class BDInvoice > business logic query GetDeductionDetailByIDStatus


Parameters


iiCompanyIdintegerCompany id
icDeductionDetailStatuscharacter
iiDInvoice_IDinteger


query condition


  each DInvoice where
DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = iiDInvoice_ID

      each DInvoiceDeduction (inner-join) where
DInvoiceDeduction.DInvoice_ID = DInvoice.DInvoice_ID AND
DInvoiceDeduction.DInvoiceDeductionStatus can-do icDeductionDetailStatus


query resultset tqGetDeductionDetailByIDStatus


field namedata typedb fielddescription
tiDInvoice_IDintegerDInvoice.DInvoice_IDRecord ID
tiDInvoiceCurrency_IDintegerDInvoice.DInvoiceCurrency_IDCurrency Code
ttDInvoiceDatedateDInvoice.DInvoiceDateInvoice Date. This field indicates the invoice creation date.This field is normallly prior to the posting date and within the same accounting period as the posting date. The date must be within the upper and lower date limits of an open GL period.
The system uses the invoice date with the credit terms to calculate due date and discount date.
api annotation:This field defaults to the DInvoicePostingDate.
tcDInvoiceDeductionApRejComcharacterDInvoiceDeduction.DInvoiceDeductionApRejComApprove/Reject Comment
tcDInvoiceDeductionStatuscharacterDInvoiceDeduction.DInvoiceDeductionStatusDeduction Status
tdDInvoiceDeductionTCdecimalDInvoiceDeduction.DInvoiceDeductionTCDeduction TC
ttDInvoicePostingDatedateDInvoice.DInvoicePostingDatePosting Date. This field displays the date the sales-related invoice was generated by Invoice Post and Print.
This field is updated when the invoice is validated and saved.
api annotation:This field defaults from the invoice creation date.


Internal usage


QadFinancials
method BOpenItemAdjustment.ApiGetDeductionAmountByDInvIDStatus