project QadFinancials > class BDPaymentSelection > business logic query DPaySelLineStageByDPaySelLine


Parameters


iiDPaySelLineIDinteger


query condition


  each DPaySelLineStg where
DPaySelLineStg.DPaySelLine_ID = iiDPaySelLineID

      first DInvoiceStage (inner-join) where
DInvoiceStage.DInvoiceStage_ID = DPaySelLineStg.DInvoiceStage_ID AND

          first PaymentConditionStaged (inner-join) where
PaymentConditionStaged.PaymentConditionStaged_ID = DInvoiceStage.PaymentConditionStaged_ID AND

              first PaymentCondition (inner-join) where
PaymentCondition.PaymentCondition_ID = PaymentConditionStaged.StagedPaymentCondition_ID AND

      each DPaySelPayRef (inner-join) where
DPaySelPayRef.DPaySelLine_ID = iiDPaySelLineID AND
DPaySelPayRef.DPaySelLineStg_id = DPaySelLineStg.DPaySelLineStg_id


query resultset tqDPaySelLineStageByDPaySelLine


field namedata typedb fielddescription
tiDInvoice_IDintegerDInvoiceStage.DInvoice_IDLink to DInvoice
tiDInvoiceStage_IDintegerDPaySelLineStg.DInvoiceStage_IDLink to DInvoiceStage
tiDInvoiceStage_ID1integerDInvoiceStage.DInvoiceStage_IDRecord ID
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.
tdDInvoiceStageAmtAppliedTCdecimalDInvoiceStage.DInvoiceStageAmtAppliedTCTC Applied Amount. CInvoiceStageAmtAppliedTC Staged payments credit terms details of the invoice. The amount paid in TC for this stage.
ttDInvoiceStageDiscDatedateDInvoiceStage.DInvoiceStageDiscDateCInvoiceDiscDate Payment discount due date. When the invoice is paid before this date a payment discount can be given.
tdDInvoiceStageDiscPercdecimalDInvoiceStage.DInvoiceStageDiscPercCInvoiceDiscPerc Payment discount percent. When the invoice is paid before the discount due date, this is the discount percentage that can be given.
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.
tiDPaySelLine_IDintegerDPaySelLineStg.DPaySelLine_IDLink to DPaySel
tiDPaySelLineStg_idintegerDPaySelLineStg.DPaySelLineStg_IDRecord ID
tdDPaySelLineStgDiscAmtTCdecimalDPaySelLineStg.DPaySelLineStgDiscAmtTCTC Discount Amount
tdDPaySelLineStgIntRatedecimalDPaySelLineStg.DPaySelLineStgIntRateInterest Rate
tdDPaySelLineStgOpenAmtTCdecimalDPaySelLineStg.DPaySelLineStgOpenAmtTCTC Open Amount
tdDPaySelLineStgOrigAmtTCdecimalDPaySelLineStg.DPaySelLineStgOrigAmtTCTC Orig Amount
tdDPaySelLineStgPaymAmtTCdecimalDPaySelLineStg.DPaySelLineStgPaymAmtTCTC Payment Amount
tcDPaySelLineStgStatuscharacterDPaySelLineStg.DPaySelLineStgStatusStatus
tcDPaySelPayRefBankRefcharacterDPaySelPayRef.DPaySelPayRefBankRefBank Reference
tcDPaySelPayRefCodecharacterDPaySelPayRef.DPaySelPayRefCodePayment Reference Code
tcPaymentConditionCodecharacterPaymentCondition.PaymentConditionCodeCredit Terms Code
tdPaymentConditionLateIntdecimalPaymentCondition.PaymentConditionLateIntDaily Overdue Int Percentage
tiPaymentConditionStaged_IDintegerDInvoiceStage.PaymentConditionStaged_IDCredit Terms Code
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(DPaySelLineStg),rowid(DInvoiceStage),rowid(PaymentConditionStaged),rowid(PaymentCondition),rowid(DPaySelPayRef)


Internal usage


QadFinancials
method BDCollection.RetrievePaySelInitial
method BDPaymentSelection.GetToPayObjectsInitialLoad