Snowflake VM Object: Product Fields
- ► 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 Child Views Variant
Source Table
Child View Name
ALLOWED_VALUES PRODUCT_FIELDS VM_PF_ALLOWED_VALUES LOCALE_DETAILS PRODUCT_FIELDS VM_PF_LD_ALLOWED_VALUES LOCALE_DETAILS PRODUCT_FIELDS VM_PF_LOCALE_DETAILS OBJECT_TYPE_CONFIGURATIONS PRODUCT_FIELDS VM_PF_OBJECT_TYPE_CONFIGURATIONS PRODUCT_FIELD_CATEGORIES PRODUCT_FIELDS VM_PF_PRODUCT_FIELD_CATEGORIES