EXTRAVALUE

This source table stores information about CLASSIC / Back Office user defined fields, also known as Extras.

Columns

Column	Data type	Description
BUILDID	VARCHAR	Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows.
CATEGORY	VARCHAR	The category of the Extra Value.
CDCSTATUS	VARCHAR	For Avionté internal use only.
DATEENTERED	TIMESTAMP_NTZ	The date the Extra Value record was created.
DATEVALUE	TIMESTAMP_NTZ	If the Extra Value is a date type, the value will be stored in this field.
EXTRAVALUEGUID	VARCHAR	The unique identifier for the Extra Value record, formatted as a GUID.
FKGUID	VARCHAR	The the unique identifier for the Foreign Key, formatted as a GUID.
LABELCONFIGCHOICEID	NUMBER	The unique identifier for the Config Choice Label, formatted as a GUID.
LASTUPDATEDDATE	TIMESTAMP_NTZ	The timestamp when the row was last updated.
NUMERICVALUE	FLOAT	If the Extra Value is a numeric type, the value will be stored in this field.
OFFSETVALUE	NUMBER	For Avionté internal use only.
SORTORDER	NUMBER	The sort order for the Extra Value records.
USERGUID	VARCHAR	The User GUID for the person that created the Extra Value.
VALUE	VARCHAR	If the Extra Value is a character type, the value will be stored in this field.