Snowflake VM Object: Plan Instance Discount Rule Assignments
- ► Plan Instance Discount Rule Assignments
-
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 ASSIGNMENT_NO NUMBER the assignment_no for the referenced record DISCOUNT_RULE_NO NUMBER the discount_rule_no for the referenced record CLIENT_DISCOUNT_RULE_ID TEXT the client_discount_rule_id for the referenced record BUNDLE_NO NUMBER the bundle_no for the referenced record PLAN_INSTANCE_NO NUMBER The Aria facing unique identifier for a plan_instance CLIENT_PLAN_INSTANCE_ID TEXT The occurrence (instance) of a plan for the referenced data COUPON_CODE TEXT The aria facing unique identifier code for a coupon OVERRIDE_MAX_APPLICATIONS NUMBER the override_max_applications for the referenced record TOTAL_APPLICATIONS NUMBER the total_applications for the referenced record ASSIGNED_TSTAMP TIMESTAMP_NTZ the assigned_tstamp for the referenced record UNASSIGNED_TSTAMP TIMESTAMP_NTZ the unassigned_tstamp for the referenced record EXPIRATION_DATE DATE the expiration_date for the referenced record REMAINDER_DISCOUNT_FACTOR NUMBER the remainder_discount_factor 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