project QadFinancials > class BPaymentCondition > business logic query PaymentConditionStagedByPC


Parameters


iiParentPaymentConditionIDinteger


query condition


  each PaymentConditionStaged where
PaymentConditionStaged.PaymentCondition_ID = iiParentPaymentConditionID

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


query resultset tqPaymentConditionStagedByPC


field namedata typedb fielddescription
tiparentpaymentcondition_idintegerPaymentConditionStaged.PaymentCondition_IDCredit Terms Code
tiPaymentCondition_IDintegerPaymentCondition.PaymentCondition_IDRecord ID
ttPaymentConditionBaseDatedatePaymentCondition.PaymentConditionBaseDateBase Date
tiPaymentConditionBaseDaysintegerPaymentCondition.PaymentConditionBaseDaysBase Days
tcPaymentConditionCodecharacterPaymentCondition.PaymentConditionCodeCredit Terms Code
tiPaymentConditionDayMthDiscintegerPaymentCondition.PaymentConditionDayMthDiscNo of Periods
tiPaymentConditionDaysMonthsintegerPaymentCondition.PaymentConditionDaysMonthsNo of Periods
tcPaymentConditionDescriptcharacterPaymentCondition.PaymentConditionDescriptDescription
tiPaymentConditionDueDaysintegerPaymentCondition.PaymentConditionDueDaysMin Due Days
tiPaymentConditionGraceDayintegerPaymentCondition.PaymentConditionGraceDayGrace Days
tlPaymentConditionIsActivelogicalPaymentCondition.PaymentConditionIsActiveActive
tdPaymentConditionLateIntdecimalPaymentCondition.PaymentConditionLateIntDaily Overdue Int Percentage
tcPaymentConditionPaymentTypcharacterPaymentCondition.PaymentConditionPaymentTypPayment Type
tcPaymentConditionPdDiscTypecharacterPaymentCondition.PaymentConditionPdDiscTypePeriod Type
tdPaymentConditionPercentagedecimalPaymentCondition.PaymentConditionPercentageDiscount Percentage
tcPaymentConditionPeriodTypecharacterPaymentCondition.PaymentConditionPeriodTypePeriod Type
tiPaymentConditionStaged_IDintegerPaymentConditionStaged.PaymentConditionStaged_IDRecord ID
tdPaymentConditionStagedPercdecimalPaymentConditionStaged.PaymentConditionStagedPercPercentage
tiPaymentConditionSupDayDiscintegerPaymentCondition.PaymentConditionSupDayDiscSupplementary Days
tiPaymentConditionSupplDaysintegerPaymentCondition.PaymentConditionSupplDaysSupplementary Days
tdPaymentConditionTermsIntdecimalPaymentCondition.PaymentConditionTermsIntTerms Interest Percentage


Internal usage


QadFinancials
method BCInvoice.CreateCInvoicesPayment
method BCInvoice.DefaultValuesPaymentCondition
method BDInvoice.AutoPopulateInvoiceStage
method BDInvoice.DefaultDuedatesForDeduction
method BDInvoice.DefaultValuesDueDates
method BDInvoice.DefaultValuesPaymentCondition
method BDInvoiceJournalEntry.CalculateInvoiceDueDates
method BVAT.CalculateTax

QadFitnesse
method BCInvoice.ApiGetStagedPaymentConditions