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

query filter (table tFilter)

tcBusinessFieldName	tcDataType	tcOperator
iiCompanyId	i
iiDInvoiceID	i	=
tDInvoiceDeduction.DInvoiceDeductionStatus	c	=,>=,>,<>,<=,<,begins,can-do,matches

Parameters (internal)

iiCompanyId	integer	Company id
iiDInvoiceID	integer

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 name	data type	db field	description
tiDInvoice_ID	integer	DInvoice.DInvoice_ID	Record ID
tcDInvoiceDeductionStatus	character	DInvoiceDeduction.DInvoiceDeductionStatus	Deduction Status
tiPaidDInvoice_ID	integer	DInvoiceDeduction.PaidDInvoice_ID	Link to PaidDInvoice
DInvoiceCustom	character	calculated	custom fields
DInvoiceDeductionCustom	character	calculated	custom fields
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(DInvoice),rowid(DInvoiceDeduction)

Internal usage

QadFinancials

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