Column Naming Conventions

Suffixes are used to indicate columns that must contain specific values. The following table shows the standard suffixes for column names and their possible values.

Suffix	Value
_AMT	This column contains a currency amount.
_CD	The column value is based on the contents of the List of Values (LOV).
_DT	This column contains a date or datetime value.
_FLG	This column contains a Boolean value where Y indicates Yes or True; N indicates No or False.
_ID	This column contains ROW_ID values.
_NUM	This column contains a number or an identifying alphanumeric value.
_TEXT	This column contains text data.
_TM	This column contains a time value.
_TS	This column contains a timestamp value.