business logic query CInvoiceStageByDueDate

Parameters

iiCInvoice_ID	integer
itDueDate	date

query condition

each CInvoiceStage where

CInvoiceStage.CInvoice_ID = iiCInvoice_ID AND
CInvoiceStage.CInvoiceStageDueDate <= itDueDate

first PaymentConditionStaged (inner-join) where

PaymentConditionStaged.PaymentConditionStaged_ID = CInvoiceStage.PaymentConditionStaged_ID AND

first PaymentCondition (inner-join) where

PaymentCondition.PaymentCondition_ID = PaymentConditionStaged.StagedPaymentCondition_ID AND

query resultset tqCInvoiceStageByDueDate

field name	data type	db field	description
tiCInvoice_ID	integer	CInvoiceStage.CInvoice_ID	Link to CInvoice
tiCInvoiceStage_ID	integer	CInvoiceStage.CInvoiceStage_ID	Record ID
tdCInvoiceStageAmountTC	decimal	CInvoiceStage.CInvoiceStageAmountTC	CInvoiceStageAmountTC Staged payments credit terms details of the invoice. The amount to pay in TC for this stage.
tdCInvoiceStageAmtAppliedTC	decimal	CInvoiceStage.CInvoiceStageAmtAppliedTC	CInvoiceStageAmtAppliedTC Staged payments credit terms details of the invoice. The amount paid in TC for this stage.
ttCInvoiceStageDiscDate	date	CInvoiceStage.CInvoiceStageDiscDate	CInvoiceDiscDate Payment discount due date. When the invoice is paid before this date a payment discount can be given.
tdCInvoiceStageDiscPerc	decimal	CInvoiceStage.CInvoiceStageDiscPerc	CInvoiceDiscPerc Payment discount percent. When the invoice is paid before the discount due date, this is the discount percentage that can be given.
ttCInvoiceStageDueDate	date	CInvoiceStage.CInvoiceStageDueDate	Due Date. The date when this stage should end.
tdCInvoiceStagePercent	decimal	CInvoiceStage.CInvoiceStagePercent	CInvoiceStagePercent Staged payments credit terms details of the invoice. The percentage of the invoice total that this stage stands for.
tcPaymentConditionCode	character	PaymentCondition.PaymentConditionCode	Credit Terms Code
tdPaymentConditionPercentage	decimal	PaymentCondition.PaymentConditionPercentage	Discount Percentage
tiPaymentConditionStaged_ID	integer	CInvoiceStage.PaymentConditionStaged_ID	Discount Percentage
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(CInvoiceStage),rowid(PaymentConditionStaged),rowid(PaymentCondition)

Internal usage

QadFinancials

method BBankEntry.GetPossibleAllocationsCInvoice
method BCDocument.GetPossibleAllocationStages
method BCInvoice.CreateCInvoiceStageUpdate
method BOpenItemAdjustment.OIAdjApplyFilterCreditor
method BPaymentSelection.CreateProposedStagedLines