Column Name Suffixes
Updated
by
Nick de Bie
The suffixes found at the end of some column names indicate the type of values found in the column.
For example, EMPLOYEE_FULL_NAME_TX indicates the data in that column is plain text.
Suffix | Name | Type | Description |
_PK | Primary Key | Relation Key | Distinctive value for individual records |
_ID | Identification | Identification | Reference number |
_CD | Code | Number | Reference code |
_FL | Flag | Number | Indicator for which row is the actual value |
_DT | Date | Date | Date field |
_XX_TX | Language & Text | Text | Text value with language indication (NL, FR, DE) |
_NB | Number | Number | Number field |
_KV | Key Value | Object | JSON (JavaScript Object Notation) value for collecting various data in one cell |
_AMT | Amount | Number | Amount value |
_PCT | Percent | Number | Percentage value |
