project QadFinancials > class BProjectReport > business logic query CInvoiceStages


Parameters


iiCInvoiceIdinteger


query condition


  each CInvoiceStage where
CInvoiceStage.CInvoice_ID = iiCInvoiceId


query resultset tqCInvoiceStages


field namedata typedb fielddescription
tdCInvoiceStageAmountCCdecimalCInvoiceStage.CInvoiceStageAmountCCCInvoiceStageAmountSC Staged payments credit terms details of the invoice. The amount to pay in SC for this stage.
tdCInvoiceStageAmountLCdecimalCInvoiceStage.CInvoiceStageAmountLCCInvoiceStageAmountBC Staged payments credit terms details of the invoice. The amount to pay in BC for this stage.
tdCInvoiceStageAmountTCdecimalCInvoiceStage.CInvoiceStageAmountTCCInvoiceStageAmountTC Staged payments credit terms details of the invoice. The amount to pay in TC for this stage.
ttCInvoiceStageDueDatedateCInvoiceStage.CInvoiceStageDueDateDue Date. The date when this stage should end.
tdCInvoiceStagePercentdecimalCInvoiceStage.CInvoiceStagePercentCInvoiceStagePercent 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(CInvoiceStage)


Internal usage


QadFinancials
method BProjectReport.CreditorAgeingAnalysisByProj