| 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) |