business logic query PaymentConditionStagedByPC

Parameters

iiParentPaymentConditionID

integer

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 name	data type	db field	description
tiparentpaymentcondition_id	integer	PaymentConditionStaged.PaymentCondition_ID	Credit Terms Code
tiPaymentCondition_ID	integer	PaymentCondition.PaymentCondition_ID	Record ID
ttPaymentConditionBaseDate	date	PaymentCondition.PaymentConditionBaseDate	Base Date
tiPaymentConditionBaseDays	integer	PaymentCondition.PaymentConditionBaseDays	Base Days
tcPaymentConditionCode	character	PaymentCondition.PaymentConditionCode	Credit Terms Code
tiPaymentConditionDayMthDisc	integer	PaymentCondition.PaymentConditionDayMthDisc	No of Periods
tiPaymentConditionDaysMonths	integer	PaymentCondition.PaymentConditionDaysMonths	No of Periods
tcPaymentConditionDescript	character	PaymentCondition.PaymentConditionDescript	Description
tiPaymentConditionDueDays	integer	PaymentCondition.PaymentConditionDueDays	Min Due Days
tiPaymentConditionGraceDay	integer	PaymentCondition.PaymentConditionGraceDay	Grace Days
tlPaymentConditionIsActive	logical	PaymentCondition.PaymentConditionIsActive	Active
tdPaymentConditionLateInt	decimal	PaymentCondition.PaymentConditionLateInt	Daily Overdue Int Percentage
tcPaymentConditionPaymentTyp	character	PaymentCondition.PaymentConditionPaymentTyp	Payment Type
tcPaymentConditionPdDiscType	character	PaymentCondition.PaymentConditionPdDiscType	Period Type
tdPaymentConditionPercentage	decimal	PaymentCondition.PaymentConditionPercentage	Discount Percentage
tcPaymentConditionPeriodType	character	PaymentCondition.PaymentConditionPeriodType	Period Type
tiPaymentConditionStaged_ID	integer	PaymentConditionStaged.PaymentConditionStaged_ID	Record ID
tdPaymentConditionStagedPerc	decimal	PaymentConditionStaged.PaymentConditionStagedPerc	Percentage
tiPaymentConditionSupDayDisc	integer	PaymentCondition.PaymentConditionSupDayDisc	Supplementary Days
tiPaymentConditionSupplDays	integer	PaymentCondition.PaymentConditionSupplDays	Supplementary Days
tdPaymentConditionTermsInt	decimal	PaymentCondition.PaymentConditionTermsInt	Terms 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