Home > EssFldChgLog

EssFldChgLog

DataSet name: EssFldChgLog

Uses the new RulesAPI style

Description: Inv field change log

Last altered in the Yakima project.

EssChgLogID BigID 12
EssFldChgLogID BigID 12
OldValue Varchar 255 Value that the ESS user saw before changing.
NewValue Varchar 255 The value the ESS user entered.
ChgTS Timestamp 32 Timestamp of actual change.
EssFieldName RulesAPI name Varchar 18 Internal name of the field.
EssName Friendly Name of Field Varchar 80 Displayable, friendly name of the field.
HugeFlg Varchar 1 Indicates that the changes are too large to fit into the normal table, so they are in the EssHugeFldChg table.
HideInUI Varchar 1 Don't show this field in UI
LockSeqNbr *SYSTEM* Row Sequence Nbr Long 12

*EssChgLogID*		BigID	12
*EssFldChgLogID*		BigID	12
OldValue		Varchar	255	Value that the ESS user saw before changing.
NewValue		Varchar	255	The value the ESS user entered.
ChgTS		Timestamp	32	Timestamp of actual change.
EssFieldName	RulesAPI name	Varchar	18	Internal name of the field.
EssName	Friendly Name of Field	Varchar	80	Displayable, friendly name of the field.
HugeFlg		Varchar	1	Indicates that the changes are too large to fit into the normal table, so they are in the EssHugeFldChg table.
HideInUI		Varchar	1	Don't show this field in UI
LockSeqNbr	SYSTEM Row Sequence Nbr	Long	12