Snowflake VM Object: Non-subscription Offerings

Last updated
Save as PDF

► 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