Snowflake VM Object: Payment Methods
- ► Payment Methods
-
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 ACCOUNT_NO NUMBER The account number related to the customer referenced PAYMENT_METHOD_NO NUMBER the payment_method_no for the referenced record USERID TEXT The userid for login related to the customer referenced AFFLUENCE_TYPE TEXT the affluence_type for the referenced record BANK_BRANCH_CD TEXT the bank_branch_cd for the referenced record BANK_COUNTRY_CD TEXT the bank_country_cd for the referenced record BANK_ID_CD TEXT the bank_id_cd for the referenced record BANK_ROUTING_NUM TEXT the bank_routing_num for the referenced record BANK_SWIFT_CD TEXT the bank_swift_cd for the referenced record BILL_ADDRESS_CONTACT_NO NUMBER the bill_address_contact_no for the referenced record BILL_AGREEMENT_ID TEXT the bill_agreement_id for the referenced record CARD_PRODUCT_TYPE TEXT the card_product_type for the referenced record CC_EXPIRE_MM NUMBER the cc_expire_mm for the referenced record CC_EXPIRE_YYYY NUMBER the cc_expire_yyyy for the referenced record CC_ISSUING_COUNTRY TEXT the cc_issuing_country for the referenced record CC_TYPE TEXT the cc_type for the referenced record CLIENT_PAYMENT_METHOD_ID TEXT the client_payment_method_id for the referenced record CONTACT_BIRTHDATE DATE the contact_birthdate for the referenced record CONTACT_CELL_PHONE TEXT The cellular phone number of the referenced data CONTACT_CITY TEXT The city address of the referenced data CONTACT_COMPANY_NAME TEXT The legal company name of the entity referenced in the data CONTACT_COUNTRY_CD TEXT The ISO country code of the address of the referenced data CONTACT_FAX TEXT The fax number of the referenced data CONTACT_FIRST_NAME TEXT The first name of the person referenced in the data CONTACT_LAST_NAME TEXT The last name of the person referenced in the data CONTACT_LOCALITY TEXT the contact_locality for the referenced record CONTACT_PHONE TEXT The phone number of the referenced data CONTACT_PHONE_EXT TEXT The phone numbers extension of the referenced data CONTACT_POSTAL_CODE TEXT The postal code of the address of the referenced data CONTACT_STREET VARIANT The street address of the referenced data CONTACT_WORK_PHONE TEXT The work phone number of the referenced data CONTACT_WORK_PHONE_EXT TEXT The work phone numbers extension of the referenced data CREATED_RECEIPT_ID TEXT the created_receipt_id for the referenced record CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data DESCRIPTION TEXT The detailed description related to the referenced data IS_CONSUMER_ACCOUNT BOOLEAN A True or False indicator showing if the record is a consumer account IS_DURBIN_REGULATED BOOLEAN A True or False indicator showing if the record is durbin regulated by the law IS_PREPAID BOOLEAN A True or False indicator showing if the record is prepaid IS_RELOADABLE BOOLEAN A True or False indicator showing if the record is reloadable IS_SIGNATURE_DEBT BOOLEAN A True or False indicator showing if the record is a signature debt MANDATE_AUTH_DATE DATE the mandate_auth_date for the referenced record MANDATE_ID TEXT the mandate_id for the referenced record NAME TEXT the name for the referenced record PAYMENT_METHOD_TYPE_NO NUMBER the payment_method_type_no for the referenced record PAYMENT_METHOD_TYPE_LABEL TEXT the payment_method_type_label for the referenced record PREPAID_BALANCE NUMBER the prepaid_balance for the referenced record PREPAID_CARD_TYPE TEXT the prepaid_card_type for the referenced record STATUS_NO NUMBER The clients status was updated at the timestamp for the customer referenced SUFFIX TEXT the suffix for the referenced record UPDATED_TSTAMP TIMESTAMP_NTZ The original source system updated timestamp for the referenced data 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