project QadFinancials > class BPaymentCondition > business logic query PaymentConditionByCode


Parameters


icPaymentConditionCodecharacter


query condition


  each PaymentCondition where
PaymentCondition.PaymentConditionCode = icPaymentConditionCode


query resultset tqPaymentConditionByCode


field namedata typedb fielddescription
tcCustomCombo0characterPaymentCondition.CustomCombo0Custom Combo Field
tcCustomCombo1characterPaymentCondition.CustomCombo1Custom Combo Field
tcCustomCombo2characterPaymentCondition.CustomCombo2Custom Combo Field
tcCustomCombo3characterPaymentCondition.CustomCombo3Custom Combo Field
tcCustomCombo4characterPaymentCondition.CustomCombo4Custom Combo Field
tcCustomCombo5characterPaymentCondition.CustomCombo5Custom Combo Field
tcCustomCombo6characterPaymentCondition.CustomCombo6Custom Combo Field
tcCustomCombo7characterPaymentCondition.CustomCombo7Custom Combo Field
tcCustomCombo8characterPaymentCondition.CustomCombo8Custom Combo Field
tcCustomCombo9characterPaymentCondition.CustomCombo9Custom Combo Field
ttCustomDate0datePaymentCondition.CustomDate0Custom Date Field
ttCustomDate1datePaymentCondition.CustomDate1Custom Date Field
ttCustomDate2datePaymentCondition.CustomDate2Custom Date Field
ttCustomDate3datePaymentCondition.CustomDate3Custom Date Field
ttCustomDate4datePaymentCondition.CustomDate4Custom Date Field
tdCustomDecimal0decimalPaymentCondition.CustomDecimal0Custom Decimal Field
tdCustomDecimal1decimalPaymentCondition.CustomDecimal1Custom Decimal Field
tdCustomDecimal2decimalPaymentCondition.CustomDecimal2Custom Decimal Field
tdCustomDecimal3decimalPaymentCondition.CustomDecimal3Custom Decimal Field
tdCustomDecimal4decimalPaymentCondition.CustomDecimal4Custom Decimal Field
tiCustomInteger0integerPaymentCondition.CustomInteger0Custom Integer Field
tiCustomInteger1integerPaymentCondition.CustomInteger1Custom Integer Field
tiCustomInteger2integerPaymentCondition.CustomInteger2Custom Integer Field
tiCustomInteger3integerPaymentCondition.CustomInteger3Custom Integer Field
tiCustomInteger4integerPaymentCondition.CustomInteger4Custom Integer Field
tcCustomLong0characterPaymentCondition.CustomLong0Custom Long Field
tcCustomLong1characterPaymentCondition.CustomLong1Custom Long Field
tcCustomNotecharacterPaymentCondition.CustomNoteCustom Note Field
tcCustomShort0characterPaymentCondition.CustomShort0Custom Short Field
tcCustomShort1characterPaymentCondition.CustomShort1Custom Short Field
tcCustomShort2characterPaymentCondition.CustomShort2Custom Short Field
tcCustomShort3characterPaymentCondition.CustomShort3Custom Short Field
tcCustomShort4characterPaymentCondition.CustomShort4Custom Short Field
tcCustomShort5characterPaymentCondition.CustomShort5Custom Short Field
tcCustomShort6characterPaymentCondition.CustomShort6Custom Short Field
tcCustomShort7characterPaymentCondition.CustomShort7Custom Short Field
tcCustomShort8characterPaymentCondition.CustomShort8Custom Short Field
tcCustomShort9characterPaymentCondition.CustomShort9Custom Short Field
ttLastModifiedDatedatePaymentCondition.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerPaymentCondition.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterPaymentCondition.LastModifiedUserLast Modified User
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
tiPaymentConditionSupDayDiscintegerPaymentCondition.PaymentConditionSupDayDiscSupplementary Days
tiPaymentConditionSupplDaysintegerPaymentCondition.PaymentConditionSupplDaysSupplementary Days
tdPaymentConditionTermsIntdecimalPaymentCondition.PaymentConditionTermsIntTerms Interest Percentage
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(PaymentCondition)


Internal usage


QadFinancials
method BOpenBalance.GetInvoiceTypeChanges
method BPaymentCondition.ApiLoadPaymentCondition