Snowflake VM Object: Non-subscription Offerings
- ► Non-subscription Offerings
-
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 NONSUBSCRIPTION_OFFERING_NO TEXT the nonsubscription_offering_no for the referenced record AUTO_CREATED_CREDIT_COMMENTS TEXT the auto_created_credit_comments for the referenced record AUTO_CREATED_CREDIT_SERVICE TEXT the auto_created_credit_service for the referenced record CLIENT_NONSUBSCRIPTION_OFFERING_ID TEXT the client_nonsubscription_offering_id for the referenced record CLIENT_SKU TEXT the client_sku for the referenced record DESCRIPTION TEXT The detailed description related to the referenced data HAS_PURCHASE_RESTRICTION BOOLEAN the has_purchase_restriction for the referenced record IS_ACTIVE BOOLEAN A True or False indicator showing if the record is active IS_AUTO_CREATE_CREDIT BOOLEAN A True or False indicator showing if the record is an auto created credit LOCALE_DETAILS VARIANT An embedded one to many JSON subrecord related to the records locale NAME TEXT the name for the referenced record NONSUBSCRIPTION_OFFERING_RATE_SCHEDULES VARIANT An embedded one to many JSON subrecord related to nonsubscription offering rate schedules PRODUCT_FIELD_ASSIGNMENTS TEXT An embedded one to many JSON subrecord related to product field assignments QUEUE_ACTIVATION_STATUS TEXT the queue_activation_status for the referenced record QUEUE_DATE DATE the queue_date for the referenced record CLIENT_SERVICE_ID TEXT the client_service_id for the referenced record SERVICE_NO TEXT the service_no for the referenced record STOCK_LEVEL TEXT the stock_level for the referenced record SUBUNIT_LABEL TEXT the subunit_label for the referenced record SUBUNIT_QUANTITY NUMBER the subunit_quantity 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 NONSUBSCRIPTION_OFFERINGS VM_NSO_LOCALE_DETAILS NONSUBSCRIPTION_OFFERING_RATE_SCHEDULES NONSUBSCRIPTION_OFFERINGS VM_NSO_NONSUBSCRIPTION_OFFERING_RATE_SCHEDULES PRODUCT_FIELD_ASSIGNMENTS NONSUBSCRIPTION_OFFERINGS VM_NSO_PFA_VALUES PRODUCT_FIELD_ASSIGNMENTS NONSUBSCRIPTION_OFFERINGS VM_NSO_PFA_VALUE_LOCALE_DETAILS PRODUCT_FIELD_ASSIGNMENTS NONSUBSCRIPTION_OFFERINGS VM_NSO_PRODUCT_FIELD_ASSIGNMENTS