project QadFinancials > class BPaymentSelection > business logic query PaySelLineStageByPaySelLine


Parameters


iiPaySelLineIDinteger


query condition


  each PaySelLineStage where
PaySelLineStage.PaySelLine_ID = iiPaySelLineID

      first CInvoiceStage (outer-join) where
CInvoiceStage.CInvoiceStage_ID = PaySelLineStage.CInvoiceStage_ID AND

          first PaymentConditionStaged (outer-join) where
PaymentConditionStaged.PaymentConditionStaged_ID = CInvoiceStage.PaymentConditionStaged_ID AND

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


query resultset tqPaySelLineStageByPaySelLine


field namedata typedb fielddescription
tiCInvoice_IDintegerCInvoiceStage.CInvoice_IDLink to CInvoice
tiCInvoiceStage_IDintegerPaySelLineStage.CInvoiceStage_IDLink to CInvoiceStage
ttCInvoiceStageDiscDatedateCInvoiceStage.CInvoiceStageDiscDateCInvoiceDiscDate Payment discount due date. When the invoice is paid before this date a payment discount can be given.
tdCInvoiceStageDiscPercdecimalCInvoiceStage.CInvoiceStageDiscPercCInvoiceDiscPerc Payment discount percent. When the invoice is paid before the discount due date, this is the discount percentage that can be given.
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.
tcCInvoiceStageTSMNumbercharacterCInvoiceStage.CInvoiceStageTSMNumberPayment Reference
tiDInvoiceStage_IDintegerPaySelLineStage.DInvoiceStage_IDLink to DInvoiceStage
tiPaymentCondition_IDintegerPaymentCondition.PaymentCondition_IDRecord ID
tcPaymentConditionCodecharacterPaymentCondition.PaymentConditionCodeCredit Terms Code
tcPaymentConditionDescriptcharacterPaymentCondition.PaymentConditionDescriptDescription
tdPaymentConditionPercentagedecimalPaymentCondition.PaymentConditionPercentageDiscount Percentage
tiPaySelLine_IDintegerPaySelLineStage.PaySelLine_IDLink to PaySelLine
tiPaySelLineStage_IDintegerPaySelLineStage.PaySelLineStage_IDRecord ID
tdPaySelLineStageDiscAmntTCdecimalPaySelLineStage.PaySelLineStageDiscAmntTCDiscount Amount
tdPaySelLineStageIntAmtTCdecimalPaySelLineStage.PaySelLineStageIntAmtTCInterest Amount
tdPaySelLineStageOpenAmntTCdecimalPaySelLineStage.PaySelLineStageOpenAmntTCOpen Amount
tdPaySelLineStageOrigAmntTCdecimalPaySelLineStage.PaySelLineStageOrigAmntTCOriginal Amount
tdPaySelLineStagePaymAmntTCdecimalPaySelLineStage.PaySelLineStagePaymAmntTCPayment Amount
tdPaySelLineStageWHTAmtTCdecimalPaySelLineStage.PaySelLineStageWHTAmtTCTC WHT Amount
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(PaySelLineStage),rowid(CInvoiceStage),rowid(PaymentConditionStaged),rowid(PaymentCondition)


Internal usage


QadFinancials
method BPaymentSelection.FillProDataSetPayment
method BPaymentSelection.GetToPayObjectsInitialLoad