business logic query PaymentConditionByProperties

Description

Get Payment condition (credit term) based on the payment condition properties

Parameters

iiPaymentCondition_ID	integer
icPaymentConditionCode	character
ilPaymentConditionIsActive	logical
icPaymentConditionPaymentType	character
icPaymentConditionPdDiscType	character
idPaymentConditionPercentage	decimal

query condition

each PaymentCondition where

PaymentCondition.PaymentCondition_ID = iiPaymentCondition_ID AND
PaymentCondition.PaymentConditionCode = icPaymentConditionCode AND
PaymentCondition.PaymentConditionIsActive = ilPaymentConditionIsActive AND
PaymentCondition.PaymentConditionPdDiscType = icPaymentConditionPdDiscType AND
PaymentCondition.PaymentConditionPercentage = idPaymentConditionPercentage AND
PaymentCondition.PaymentConditionPaymentTyp = icPaymentConditionPaymentType

query resultset tqPaymentConditionByProperties

field name	data type	db field	description
tiPaymentCondition_ID	integer	PaymentCondition.PaymentCondition_ID	Record ID
tcPaymentConditionCode	character	PaymentCondition.PaymentConditionCode	Credit Terms Code
tlPaymentConditionIsActive	logical	PaymentCondition.PaymentConditionIsActive	Active
tcPaymentConditionPaymentTyp	character	PaymentCondition.PaymentConditionPaymentTyp	Payment Type
tcPaymentConditionPdDiscType	character	PaymentCondition.PaymentConditionPdDiscType	Period Type
tdPaymentConditionPercentage	decimal	PaymentCondition.PaymentConditionPercentage	Discount Percentage

Internal usage

QadFinancials

method BBankEntry.AdditionalUpdatesInvPrePayments
method BCDocument.AdditionalUpdatesPostingPrePaymentPayCond
method BCInvoice.CreateCInvoices
method BOpenBalance.GetInvoiceTypeChanges
method BDDocument.AdditionalUpdatesPostingPrePaymentPayCond
method BDebtor.ValidateComponent
method BDInvoice.CreateDInvoices
method BOpenItemAdjustment.OIAdjCommitSubCInvoice
method BOpenItemAdjustment.OIAdjCommitSubDInvoice