project QadFinancials > class BCreditorReport > business logic query CInvoiceStageByInvoice


Parameters


iiCInvoiceIdinteger


query condition


  each CInvoiceStage where
CInvoiceStage.CInvoice_ID = iiCInvoiceId


query resultset tqCInvoiceStageByInvoice


field namedata typedb fielddescription
tiCInvoice_IDintegerCInvoiceStage.CInvoice_IDLink to CInvoice
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.
tdCInvoiceStageAmtAppliedTCdecimalCInvoiceStage.CInvoiceStageAmtAppliedTCCInvoiceStageAmtAppliedTC Staged payments credit terms details of the invoice. The amount paid in TC for this stage.
ttCInvoiceStageDueDatedateCInvoiceStage.CInvoiceStageDueDateDue Date. The date when this stage should end.


Internal usage


QadFinancials
method BCreditorReport.CreditorAgeingABackwards
method BCreditorReport.CreditorAgeingAnalysisCurrent