Snowflake VM Object: Usage Types
- ► Usage Types
-
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 USAGE_TYPE_NO NUMBER the usage_type_no for the referenced record USAGE_TYPE_CD TEXT the usage_type_cd for the referenced record DESCRIPTION TEXT The detailed description related to the referenced data DISPLAY_NAME TEXT the display_name for the referenced record LOCALE_DETAILS VARIANT An embedded one to many JSON subrecord related to the records locale NAME TEXT the name for the referenced record PRODUCT_FIELD_ASSIGNMENTS VARIANT An embedded one to many JSON subrecord related to product field assignments USAGE_UNIT_TYPE_NO NUMBER the usage_unit_type_no for the referenced record 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
LOCALE_DETAILS USAGE_TYPES VM_UT_LOCALE_DETAILS PRODUCT_FIELD_ASSIGNMENTS USAGE_TYPES VM_UT_PFA_LOCALE_DETAILS PRODUCT_FIELD_ASSIGNMENTS USAGE_TYPES VM_UT_PFA_VALUES PRODUCT_FIELD_ASSIGNMENTS USAGE_TYPES VM_UT_PRODUCT_FIELD_ASSIGNMENTS