Snowflake VC Object: Recurring Credits

Last updated
Save as PDF

► Recurring Credits

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.
RECURRING_CREDIT_NO	NUMBER	The unique identifier for a recurring credit number.
ACCOUNT_NO	NUMBER	The account number related to the customer referenced
CLIENT_ACCOUNT_ID	TEXT	The clients unique identified for account related to the customer referenced
USERID	TEXT	The userid for login related to the customer referenced
CANCEL_COMMENTS	TEXT	A verbose explanation of details related to cancellation.
CANCEL_DATE	DATE	The date of the cancel milestone.
COMMENTS	TEXT	A verbose explanation of details related to the referenced data.
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data.
CREDIT_INTERVAL_MONTHS	NUMBER	The credit interval in months.
CREDIT_SERVICE_NO	NUMBER	The credit_service_no for the referenced record.
CREDIT_CLIENT_SERVICE_ID	TEXT	The unique identifier for the credit client service id.
CURRENCY_CD	TEXT	The currency code for the referenced record.
EXPIRATION_DATE	DATE	The date of the expiration milestone.
EXPIRATION_MONTHS	NUMBER	The months to expiration date.
EXPIRATION_TYPE_INDICATOR_CD	TEXT	The expiration type indicator code.
FIRST_CREDIT_DATE	DATE	The date of the first credit.
LAST_CREDIT_DATE	DATE	The date of the last credit.
MASTER_PLAN_INSTANCE_NO	NUMBER	The master_plan_instance_no for the referenced record.
MASTER_CLIENT_PLAN_INSTANCE_ID	TEXT	The unique identifier for a master client plan instance id.
NEXT_CREDIT_DATE	DATE	The date of the next credit.
NUMBER_OF_CREDITS_REMAINING	NUMBER	The number of credits remaining.
NUMBER_OF_CREDITS_REQUIRED	NUMBER	The number of credits required.
PERCENTAGE_SOURCE_PLAN_NO	NUMBER	The percentage_source_plan_no for the referenced record
PERCENTAGE_SOURCE_CLIENT_PLAN_ID	TEXT	The unique identifier for a percentage source client plan record.
PERCENTAGE_SOURCE_SERVICE_NO	NUMBER	The percentage_source_service_no for the referenced record.
PERCENTAGE_SOURCE_CLIENT_SERVICE_ID	TEXT	The unique identifier for the percentage source client service id.
REASON_NO	NUMBER	The unique identifier for a reason number.
RECURRING_CREDIT_AMOUNT	NUMBER	The currency recurring credit amount.
RECURRING_CREDIT_TYPE_NO	NUMBER	The unique identifier for a recurring credit type number.
SOURCE_COUPON_CODE	TEXT	The source_coupon_code for the referenced record.
STATUS_NO	NUMBER	The unique identifier for a status number.
USE_CHARGE_SERVICE	BOOLEAN	The use charge service