project QadFinancials > class BPaymentCondition > business logic query PaymentConditionStagedByID


Parameters


iiPaymentConditionStagedIDinteger


query condition


  each PaymentConditionStaged where
PaymentConditionStaged.PaymentConditionStaged_ID = iiPaymentConditionStagedID

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


query resultset tqPaymentConditionStagedByID


field namedata typedb fielddescription
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
tiPaymentConditionSupDayDiscintegerPaymentCondition.PaymentConditionSupDayDiscSupplementary Days
tiPaymentConditionSupplDaysintegerPaymentCondition.PaymentConditionSupplDaysSupplementary Days
tdPaymentConditionTermsIntdecimalPaymentCondition.PaymentConditionTermsIntTerms Interest Percentage


Internal usage


QadFinancials
method BCInvoice.ValidateComponentPostDueDate
read related business field(s) on tCInvoiceStage.PaymentConditionStaged_ID
read related business field(s) on tDInvoiceStage.PaymentConditionStaged_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues