field name | data type | db field | description |
tcCustomCombo0 | character | PaymentCondition.CustomCombo0 | Custom Combo Field |
tcCustomCombo1 | character | PaymentCondition.CustomCombo1 | Custom Combo Field |
tcCustomCombo2 | character | PaymentCondition.CustomCombo2 | Custom Combo Field |
tcCustomCombo3 | character | PaymentCondition.CustomCombo3 | Custom Combo Field |
tcCustomCombo4 | character | PaymentCondition.CustomCombo4 | Custom Combo Field |
tcCustomCombo5 | character | PaymentCondition.CustomCombo5 | Custom Combo Field |
tcCustomCombo6 | character | PaymentCondition.CustomCombo6 | Custom Combo Field |
tcCustomCombo7 | character | PaymentCondition.CustomCombo7 | Custom Combo Field |
tcCustomCombo8 | character | PaymentCondition.CustomCombo8 | Custom Combo Field |
tcCustomCombo9 | character | PaymentCondition.CustomCombo9 | Custom Combo Field |
ttCustomDate0 | date | PaymentCondition.CustomDate0 | Custom Date Field |
ttCustomDate1 | date | PaymentCondition.CustomDate1 | Custom Date Field |
ttCustomDate2 | date | PaymentCondition.CustomDate2 | Custom Date Field |
ttCustomDate3 | date | PaymentCondition.CustomDate3 | Custom Date Field |
ttCustomDate4 | date | PaymentCondition.CustomDate4 | Custom Date Field |
tdCustomDecimal0 | decimal | PaymentCondition.CustomDecimal0 | Custom Decimal Field |
tdCustomDecimal1 | decimal | PaymentCondition.CustomDecimal1 | Custom Decimal Field |
tdCustomDecimal2 | decimal | PaymentCondition.CustomDecimal2 | Custom Decimal Field |
tdCustomDecimal3 | decimal | PaymentCondition.CustomDecimal3 | Custom Decimal Field |
tdCustomDecimal4 | decimal | PaymentCondition.CustomDecimal4 | Custom Decimal Field |
tiCustomInteger0 | integer | PaymentCondition.CustomInteger0 | Custom Integer Field |
tiCustomInteger1 | integer | PaymentCondition.CustomInteger1 | Custom Integer Field |
tiCustomInteger2 | integer | PaymentCondition.CustomInteger2 | Custom Integer Field |
tiCustomInteger3 | integer | PaymentCondition.CustomInteger3 | Custom Integer Field |
tiCustomInteger4 | integer | PaymentCondition.CustomInteger4 | Custom Integer Field |
tcCustomLong0 | character | PaymentCondition.CustomLong0 | Custom Long Field |
tcCustomLong1 | character | PaymentCondition.CustomLong1 | Custom Long Field |
tcCustomNote | character | PaymentCondition.CustomNote | Custom Note Field |
tcCustomShort0 | character | PaymentCondition.CustomShort0 | Custom Short Field |
tcCustomShort1 | character | PaymentCondition.CustomShort1 | Custom Short Field |
tcCustomShort2 | character | PaymentCondition.CustomShort2 | Custom Short Field |
tcCustomShort3 | character | PaymentCondition.CustomShort3 | Custom Short Field |
tcCustomShort4 | character | PaymentCondition.CustomShort4 | Custom Short Field |
tcCustomShort5 | character | PaymentCondition.CustomShort5 | Custom Short Field |
tcCustomShort6 | character | PaymentCondition.CustomShort6 | Custom Short Field |
tcCustomShort7 | character | PaymentCondition.CustomShort7 | Custom Short Field |
tcCustomShort8 | character | PaymentCondition.CustomShort8 | Custom Short Field |
tcCustomShort9 | character | PaymentCondition.CustomShort9 | Custom Short Field |
ttLastModifiedDate | date | PaymentCondition.LastModifiedDate | Last Modified Date |
tiLastModifiedTime | integer | PaymentCondition.LastModifiedTime | Last Modified Time |
tcLastModifiedUser | character | PaymentCondition.LastModifiedUser | Last Modified User |
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 |
tiPaymentConditionSupDayDisc | integer | PaymentCondition.PaymentConditionSupDayDisc | Supplementary Days |
tiPaymentConditionSupplDays | integer | PaymentCondition.PaymentConditionSupplDays | Supplementary Days |
tdPaymentConditionTermsInt | decimal | PaymentCondition.PaymentConditionTermsInt | Terms Interest Percentage |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(PaymentCondition) |