| field name | data type | db field | description |
|---|
| tcCustomCombo0 | character | SODCategory.CustomCombo0 | |
| tcCustomCombo1 | character | SODCategory.CustomCombo1 | |
| tcCustomCombo2 | character | SODCategory.CustomCombo2 | |
| tcCustomCombo3 | character | SODCategory.CustomCombo3 | |
| tcCustomCombo4 | character | SODCategory.CustomCombo4 | |
| tcCustomCombo5 | character | SODCategory.CustomCombo5 | |
| tcCustomCombo6 | character | SODCategory.CustomCombo6 | |
| tcCustomCombo7 | character | SODCategory.CustomCombo7 | |
| tcCustomCombo8 | character | SODCategory.CustomCombo8 | |
| tcCustomCombo9 | character | SODCategory.CustomCombo9 | |
| ttCustomDate0 | date | SODCategory.CustomDate0 | |
| ttCustomDate1 | date | SODCategory.CustomDate1 | |
| ttCustomDate2 | date | SODCategory.CustomDate2 | |
| ttCustomDate3 | date | SODCategory.CustomDate3 | |
| ttCustomDate4 | date | SODCategory.CustomDate4 | |
| tdCustomDecimal0 | decimal | SODCategory.CustomDecimal0 | |
| tdCustomDecimal1 | decimal | SODCategory.CustomDecimal1 | |
| tdCustomDecimal2 | decimal | SODCategory.CustomDecimal2 | |
| tdCustomDecimal3 | decimal | SODCategory.CustomDecimal3 | |
| tdCustomDecimal4 | decimal | SODCategory.CustomDecimal4 | |
| tiCustomInteger0 | integer | SODCategory.CustomInteger0 | |
| tiCustomInteger1 | integer | SODCategory.CustomInteger1 | |
| tiCustomInteger2 | integer | SODCategory.CustomInteger2 | |
| tiCustomInteger3 | integer | SODCategory.CustomInteger3 | |
| tiCustomInteger4 | integer | SODCategory.CustomInteger4 | |
| tcCustomLong0 | character | SODCategory.CustomLong0 | |
| tcCustomLong1 | character | SODCategory.CustomLong1 | |
| tcCustomNote | character | SODCategory.CustomNote | |
| tcCustomShort0 | character | SODCategory.CustomShort0 | |
| tcCustomShort1 | character | SODCategory.CustomShort1 | |
| tcCustomShort2 | character | SODCategory.CustomShort2 | |
| tcCustomShort3 | character | SODCategory.CustomShort3 | |
| tcCustomShort4 | character | SODCategory.CustomShort4 | |
| tcCustomShort5 | character | SODCategory.CustomShort5 | |
| tcCustomShort6 | character | SODCategory.CustomShort6 | |
| tcCustomShort7 | character | SODCategory.CustomShort7 | |
| tcCustomShort8 | character | SODCategory.CustomShort8 | |
| tcCustomShort9 | character | SODCategory.CustomShort9 | |
| ttLastModifiedDate | date | SODCategory.LastModifiedDate | Last Modified Date |
| tiLastModifiedTime | integer | SODCategory.LastModifiedTime | Last Modified Time |
| tcLastModifiedUser | character | SODCategory.LastModifiedUser | Last Modified User |
| tiSODCategory_ID | integer | SODCategory.SODCategory_ID | record ID |
| tcSODCategoryCode | character | SODCategory.SODCategoryCode | SOD category code |
| tcSODCategoryDescription | character | SODCategory.SODCategoryDescription | SOD category description |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(SODCategory) |
each SODCategory where