project QadFinancials > class BProjectReport > business logic query DInvoiceStages


Parameters


iiDInvoiceIDinteger


query condition


  each DInvoiceStage where
DInvoiceStage.DInvoice_ID = iiDInvoiceID


query resultset tqDInvoiceStages


field namedata typedb fielddescription
tdDInvoiceStageAmountCCdecimalDInvoiceStage.DInvoiceStageAmountCCSC Amount. CInvoiceStageAmountSC Staged payments credit terms details of the invoice. The amount to pay in SC for this stage.
tdDInvoiceStageAmountLCdecimalDInvoiceStage.DInvoiceStageAmountLCBC Amount. CInvoiceStageAmountBC Staged payments credit terms details of the invoice. The amount to pay in BC for this stage.
tdDInvoiceStageAmountTCdecimalDInvoiceStage.DInvoiceStageAmountTCTC Amount. CInvoiceStageAmountTC Staged payments credit terms details of the invoice. The amount to pay in TC for this stage.
ttDInvoiceStageDueDatedateDInvoiceStage.DInvoiceStageDueDateDue Date. The date when this stage should end.
tdDInvoiceStagePercentagedecimalDInvoiceStage.DInvoiceStagePercentagePercentage. CInvoiceStagePercent Staged payments credit terms details of the invoice. The percentage of the invoice total that this stage stands for.
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(DInvoiceStage)


Internal usage


QadFinancials
method BProjectReport.DebtorAgeingAnalysisByProj