Snowflake VM Object: Account Discount Rule Assignments
- ► Account 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 ACCOUNT_NO NUMBER The account number related to the customer referenced 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 USERID TEXT The userid for login related to the customer referenced CLIENT_ACCOUNT_ID TEXT The clients unique identified for account related to the customer referenced BUNDLE_NO NUMBER the bundle_no for the referenced record SOURCE_COUPON_CODE TEXT the source_coupon_code for the referenced record OVERRIDE_MAX_APPLICATIONS NUMBER the override_max_applications for the referenced record OVERRIDE_MAX_APPLICABLE_MONTHS NUMBER the override_max_applicable_months 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 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