Snowflake VC Object: Payment Methods

Last updated
Save as PDF

► Payment Methods

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.
ACCOUNT_NO	NUMBER	The account number related to the customer referenced
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
PAYMENT_METHOD_NO	NUMBER	The unique identifier for a payment method number.
CLIENT_PAYMENT_METHOD_ID	TEXT	The unique identifier for a client payment method id.
NAME	TEXT	The payment methods name.
DESCRIPTION	TEXT	A verbose description of the payment method.
PAYMENT_METHOD_TYPE_NO	NUMBER	The unique identifier for a payment method type number.
PAYMENT_METHOD_STATUS_NO	NUMBER	The unique identifier for a payment method status number.
SUFFIX	TEXT	The suffix.
CC_TYPE	TEXT	The credit card type.
CC_EXPIRE_MM	NUMBER	The numeric month (MM) of expiration.
CC_EXPIRE_YYYY	NUMBER	The numeric year (YYYY) of expiration.
BILL_AGREEMENT_ID	TEXT	The billing agreement id.
BANK_ROUTING_NUM	TEXT	The bank routing number.
BILL_ADDRESS_CONTACT_NO	NUMBER	The unique identifier for a billing address contact number.
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data.
UPDATED_TSTAMP	TIMESTAMP_NTZ	The original source system updated timestamp for the referenced data.
IS_PREPAID	BOOLEAN	Is the payment method prepaid?
IS_RELOADABLE	BOOLEAN	Is the payment method reloadable?
PREPAID_BALANCE	NUMBER	The currency amount of the prepaid balance.
PREPAID_CARD_TYPE	TEXT	The type of the prepaid card.
AFFLUENCE_TYPE	TEXT	The affluence type.
CC_ISSUING_COUNTRY	TEXT	The issuing country of the credit card.
CARD_PRODUCT_TYPE	TEXT	The card product type.
IS_DURBIN_REGULATED	BOOLEAN	Is the payment method durbin regulated?
IS_SIGNATURE_DEBIT	BOOLEAN	Is the payment method signature debit?
BANK_SWIFT_CD	TEXT	The swift system bank code.
BANK_COUNTRY_CD	TEXT	The country code of the bank referenced.
MANDATE_ID	TEXT	The mandate id.
BANK_ID_CD	TEXT	The bank id code.
BANK_BRANCH_CD	TEXT	The bank branch code.
MANDATE_AUTH_DATE	DATE	The date the mandate authorization starts.
CREATED_RECEIPT_ID	TEXT	The created_receipt_id for the referenced record.