tcBusinessFieldName | tcDataType | tcOperator |
iiPaymentConditionId | i | = |
icPaymentConditionCode | c | = |
tPaymentCondition.LastModifiedDate | t | =,>=,>,<>,<=,< |
tPaymentCondition.LastModifiedTime | i | =,>=,>,<>,<=,< |
tPaymentCondition.LastModifiedUser | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPaymentCondition.PaymentConditionBaseDate | t | =,>=,>,<>,<=,< |
tPaymentCondition.PaymentConditionBaseDays | i | =,>=,>,<>,<=,< |
tPaymentCondition.PaymentConditionCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPaymentCondition.PaymentConditionDayMthDisc | i | =,>=,>,<>,<=,< |
tPaymentCondition.PaymentConditionDaysMonths | i | =,>=,>,<>,<=,< |
tPaymentCondition.PaymentConditionDescript | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPaymentCondition.PaymentConditionDueDays | i | =,>=,>,<>,<=,< |
tPaymentCondition.PaymentConditionGraceDay | i | =,>=,>,<>,<=,< |
tPaymentCondition.PaymentConditionIsActive | l | =,<> |
tPaymentCondition.PaymentConditionLateInt | d | =,>=,>,<>,<=,< |
tPaymentCondition.PaymentConditionPaymentTyp | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPaymentCondition.PaymentConditionPdDiscType | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPaymentCondition.PaymentConditionPercentage | d | =,>=,>,<>,<=,< |
tPaymentCondition.PaymentConditionPeriodType | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPaymentCondition.PaymentConditionSupDayDisc | i | =,>=,>,<>,<=,< |
tPaymentCondition.PaymentConditionSupplDays | i | =,>=,>,<>,<=,< |
tPaymentCondition.PaymentConditionTermsInt | d | =,>=,>,<>,<=,< |
field name | data type | db field | description |
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 |
PaymentConditionCustom | character | calculated | custom fields |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(PaymentCondition) |