Snowflake VM Object: Accounts

Last updated
Save as PDF

► Accounts

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
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
BALANCE	NUMBER	The clients balance owed on their account for the customer referenced
STATUS_NO	NUMBER	The clients status was updated at the timestamp for the customer referenced
STATUS_TSTAMP	TIMESTAMP_NTZ	The clients status was updated at the timestamp for the customer referenced
PARENT_ACCOUNT_NO	NUMBER	the parent_account_no for the referenced record
PARENT_USERID	TEXT	the parent_userid for the referenced record
PARENT_CLIENT_ACCOUNT_ID	TEXT	the parent_client_account_id for the referenced record
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
SECRET_QUESTION	TEXT	the secret_question for the referenced record
SECRET_QUESTION_ANSWER	TEXT	the secret_question_answer for the referenced record
IS_TEST_ACCOUNT	BOOLEAN	A True or False indicator showing if the record is a test account
IS_INVOICE_APPROVAL_REQUIRED	BOOLEAN	A True or False indicator showing if the record requires invoice approval
CURRENCY_CD	TEXT	The ISO currency code of the referenced data
UPDATED_RECEIPT_ID	TEXT	the updated_receipt_id for the referenced record
CREATED_RECEIPT_ID	TEXT	the created_receipt_id for the referenced record
SEQUENCE_FUNCTIONAL_GROUP_NO	NUMBER	the sequence_functional_group_no for the referenced record
CLIENT_SEQUENCE_FUNCTIONAL_GROUP_ID	TEXT	the client_sequence_functional_group_id for the referenced record
START_DATE	DATE	the start_date for the referenced record
ADMIN_CONTACT_NO	NUMBER	the admin_contact_no for the referenced record
IS_CONSUMER_ACCOUNT	BOOLEAN	A True or False indicator showing if the record is a consumer account
LOCALE_NO	NUMBER	the locale_no for the referenced record
LEGAL_ENTITY_NO	NUMBER	the legal_entity_no for the referenced record
CLIENT_LEGAL_ENTITY_ID	TEXT	the client_legal_entity_id for the referenced record
IS_ANONYMIZED	BOOLEAN	A True or False indicator showing if the record is anonymized for PII protection
NOTIFY_METHOD_NO	NUMBER	the notify_method_no for the referenced record
FUNCTIONAL_ACCOUNT_GROUPS	VARIANT	An embedded one to many JSON subrecord related to functional account groups
COLLECTION_ACCOUNT_GROUPS	VARIANT	An embedded one to many JSON subrecord related to collection account groups
ACCOUNT_FIELDS	VARIANT	An embedded one to many JSON subrecord related to account fields
TAX_EXEMPTION_LEVEL_NO	NUMBER	the tax_exemption_level_no for the referenced record
NOTIFICATION_OVERRIDES	VARIANT	An embedded one to many JSON subrecord related to notification overrides
NOTIFICATION_TEMPLATE_GROUP_NO	NUMBER	the notification_template_group_no for the referenced record
CLIENT_NOTIFICATION_TEMPLATE_GROUP_ID	TEXT	the client_notification_template_group_id for the referenced record
SURCHARGES	VARIANT	An embedded one to many JSON subrecord related to surcharges
REVREC_PROFILE_NUMBER	NUMBER	the revrec_profile_number for the referenced record
PURCHASE_ORDER_NUMBER	TEXT	The aria facing unique identifier for a purchase order
CC_EMAIL_ADDRESSES	VARIANT	An embedded one to many JSON subrecord related to cc email addresses
BCC_EMAIL_ADDRESSES	VARIANT	An embedded one to many JSON subrecord related to bcc email addresses
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
Child Views
Variant	Source Table	Child View Name
ACCOUNT_FIELDS	ACCOUNTS	VM_ACCOUNT_ACCOUNT_FIELDS
ACCOUNT_FIELDS	ACCOUNTS	VM_ACCOUNT_AF_VALUES
BCC_EMAIL_ADDRESSES	ACCOUNTS	VM_ACCOUNT_BCC_EMAIL_ADDRESSES
CC_EMAIL_ADDRESSES	ACCOUNTS	VM_ACCOUNT_CC_EMAIL_ADDRESSES
COLLECTION_ACCOUNT_GROUPS	ACCOUNTS	VM_ACCOUNT_COLLECTION_ACCOUNT_GROUPS
FUNCTIONAL_ACCOUNT_GROUPS	ACCOUNTS	VM_ACCOUNT_FUNCTIONAL_ACCOUNT_GROUPS
NOTIFICATION_OVERRIDES	ACCOUNTS	VM_ACCOUNT_NOTIFICATION_OVERRIDES
SURCHARGES	ACCOUNTS	VM_ACCOUNT_SURCHARGES