Snowflake VM Object: Product Fields

Last updated
Save as PDF

► Product Fields

Field	Datatype	Description
CLIENT_NO	NUMBER	CLIENT_NO uniquely identifying each unique client
IS_DELETED	BOOLEAN	Denotes a True/False as to if the referenced data has been deleted via soft delete
REF_PK	TEXT	REF_PK The PK of the ref_type concatenated with a pipe as needed within the JSON
FIELD_NO	NUMBER	the field_no for the referenced record
FIELD_NAME	TEXT	the field_name for the referenced record
ALLOWED_VALUES	VARIANT	The allowable data values for the pull down lists related to the referenced data
DESCRIPTION	TEXT	The detailed description related to the referenced data
INPUT_TYPE	TEXT	the input_type for the referenced record
LOCALE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to the records locale
MAXIMUM_SELECTIONS	NUMBER	the maximum_selections for the referenced record
MINIMUM_SELECTIONS	NUMBER	the minimum_selections for the referenced record
OBJECT_TYPE_CONFIGURATIONS	VARIANT	An embedded one to many JSON subrecord related to object_type_configurations
PRODUCT_FIELD_CATEGORIES	VARIANT	An embedded one to many JSON subrecord related to product field categories
CREATED_BATCH_ID	NUMBER	The aria facing creation batch id assigned upon landing for the referenced data
CREATED_BATCH_TSTAMP	TIMESTAMP_NTZ	The aria facing batch timstamp assigned upon landing for the referenced data, showing its creation in snowflake
UPDATED_BATCH_ID	NUMBER	The aria facing update batch id assigned upon landing for the referenced data
UPDATED_BATCH_TSTAMP	TIMESTAMP_NTZ	The aria facing batch timstamp assigned upon landing for the referenced data, showing its update in snowflake