project QadFinancials > class BDInvoice > business logic (internal API) query DInvoiceDedStatusByDInvoiceID


query filter (table tFilter)


tcBusinessFieldNametcDataTypetcOperator
iiCompanyIdi
iiDInvoiceIDi=
tDInvoiceDeduction.DInvoiceDeductionStatusc=,>=,>,<>,<=,<,begins,can-do,matches


Parameters (internal)


iiCompanyIdintegerCompany id
iiDInvoiceIDinteger


query condition


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

      each DInvoiceDeduction (inner-join) where
DInvoiceDeduction.DInvoice_ID = DInvoice.DInvoice_ID AND


query resultset tqDInvoiceDedStatusByDInvoiceID


field namedata typedb fielddescription
tiDInvoice_IDintegerDInvoice.DInvoice_IDRecord ID
tcDInvoiceDeductionStatuscharacterDInvoiceDeduction.DInvoiceDeductionStatusDeduction Status
tiPaidDInvoice_IDintegerDInvoiceDeduction.PaidDInvoice_IDLink to PaidDInvoice
DInvoiceCustomcharactercalculatedcustom fields
DInvoiceDeductionCustomcharactercalculatedcustom fields
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(DInvoice),rowid(DInvoiceDeduction)


Internal usage


QadFinancials
method BBankEntry.GetPossibleAllocationsDInvoice
method BDebtor.GetDebtorInvoiceData
method BDebtorReport.CalculateDIDeductionStatus
method BDebtorReport.CalDeductionStatus
method BDPaymentSelection.GetDInvoiceDeductionStatus