Snowflake VC Object: Discount Rules

Last updated
Save as PDF

► Discount Rules

Field	Datatype	Description
CLIENT_NO	NUMBER	CLIENT_NO uniquely identifying each unique client
BATCH_ID	NUMBER	BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID	NUMBER	CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP	TIMESTAMP_NTZ	EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID	TEXT	EVENT_ID for the change JSON record
CREATETIME	NUMBER	CREATETIME createtime of the changed JSON record
ACTIONS	TEXT	ACTIONS for create, load, update, delete determining processing behavior for the record.
DISCOUNT_RULE_NO	NUMBER	The discount_rule_no for the referenced record.
CLIENT_DISCOUNT_RULE_ID	TEXT	The unique identifier for a client discount rule id.
NAME	TEXT	The discount rule name.
DESCRIPTION	TEXT	A verbose description of the discount_rules.
EXTERNAL_DESCRIPTION	TEXT	A verbose external description of the discount_rules.
DISCOUNT_TYPE_CD	TEXT	The unique identifier for a discount type code.
FIXED_AMOUNT	NUMBER	The fixed currency amount.
PERCENT_AMOUNT	NUMBER	The percent currency amount.
CURRENCY_CD	TEXT	The default_currency_cd for the referenced record.
APPLICABLE_DURATION_TYPE_CD	TEXT	The unique identifier for a applicable duration type code.
MAXIMUM_APPLICABLE_DURATION	NUMBER	The maximum applicable duration of the discount rule referenced.
INVOICE_APPLICATION_SCOPE_CD	TEXT	The unique identifier for a invoice applicable scope code.
IS_INLINE_DISCOUNT	BOOLEAN	Is the record and online discount?
DISCOUNT_BEHAVIOR_CD	TEXT	The unique identifier for a discount behavior code.
DISCOUNT_SERVICE_NO	NUMBER	The discount_service_no for the referenced record.
DISCOUNT_SERVICE_CLIENT_ID	TEXT	The discount_service_client_id for the referenced record.
DISCOUNT_RULE_SCOPE_NO	NUMBER	The unique identifier for a discount rule scope number.
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data.
REMAINDER_DISCOUNT_RULE_IND	BOOLEAN	The remainder discount rule indicator.