Snowflake Available Objects VM

Last updated
Save as PDF

What data is available?

These are the current Objects available in Snowflake. More objects are added with each new release. Expand an Object below to view it's relevant fields.

VM

► 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

► Account Coupon Assignments

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
COUPON_CODE	TEXT	The aria facing unique identifier code for a coupon
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data
CANCELLED_TSTAMP	TIMESTAMP_NTZ	The original source system cancelled 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

► Account Discount Rule Assignments

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
ASSIGNMENT_NO	NUMBER	the assignment_no for the referenced record
ACCOUNT_NO	NUMBER	The account number related to the customer referenced
DISCOUNT_RULE_NO	NUMBER	the discount_rule_no for the referenced record
CLIENT_DISCOUNT_RULE_ID	TEXT	the client_discount_rule_id for the referenced record
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
BUNDLE_NO	NUMBER	the bundle_no for the referenced record
SOURCE_COUPON_CODE	TEXT	the source_coupon_code for the referenced record
OVERRIDE_MAX_APPLICATIONS	NUMBER	the override_max_applications for the referenced record
OVERRIDE_MAX_APPLICABLE_MONTHS	NUMBER	the override_max_applicable_months for the referenced record
TOTAL_APPLICATIONS	NUMBER	the total_applications for the referenced record
ASSIGNED_TSTAMP	TIMESTAMP_NTZ	the assigned_tstamp for the referenced record
UNASSIGNED_TSTAMP	TIMESTAMP_NTZ	the unassigned_tstamp for the referenced record
EXPIRATION_DATE	DATE	the expiration_date for the referenced record
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

► Account Fields

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
FIELD_NO	NUMBER	the field_no for the referenced record
FIELD_NAME	TEXT	the field_name for the referenced record
DESCRIPTION	TEXT	The detailed description related to the referenced data
IS_REQUIRED	BOOLEAN	A True or False indicator showing if the record is mandatory
INPUT_TYPE_CD	TEXT	the input_type_cd for the referenced record
MINIMUM_SELECTIONS	NUMBER	the minimum_selections for the referenced record
MAXIMUM_SELECTIONS	NUMBER	the maximum_selections 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
IS_RESTRICTED_TO_ALLOWED_VALUES	BOOLEAN	A True or False indicator showing if the record is restricted to allowed values
FIELD_ORDER	NUMBER	the field_order for the referenced record
ALLOWED_VALUES	VARIANT	The allowable data values for the pull down lists related to the referenced data
LOCALE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to the records locale
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
ALLOWED_VALUES	ACCOUNT_FIELDS	VM_AF_ALLOWED_VALUES
LOCALE_DETAILS	ACCOUNT_FIELDS	VM_AF_LD_ALLOWED_VALUES
LOCALE_DETAILS	ACCOUNT_FIELDS	VM_AF_LOCALE_DETAILS

► Account Probes

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
PROBE_NO	TEXT	the probe_no for the referenced record
EVENT_TSTAMP	TIMESTAMP_NTZ	EVENT_TSTAMP of the JSON record
INJECTED_HOST	TEXT	the injected_host for the referenced record
INJECTED_TSTAMP	TIMESTAMP_NTZ	the injected_tstamp for the referenced record
INJECTED_TYPE	TEXT	the injected_type for the referenced record
PROCESSED_HOST	TEXT	the processed_host for the referenced record
PROCESSED_TSTAMP	TIMESTAMP_NTZ	the processed_tstamp for the referenced record
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

► Billing Groups

Field	Datatype	Description
UPDATED_BATCH_TSTAMP	TIMESTAMP_NTZ	The aria facing batch timstamp assigned upon landing for the referenced data, showing its update in snowflake
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
BILLING_GROUP_NO	NUMBER	The designated billing group number for the referenced data
CLIENT_BILLING_GROUP_ID	TEXT	the client_billing_group_id for the referenced 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
NAME	TEXT	the name for the referenced record
DESCRIPTION	TEXT	The detailed description related to the referenced data
STATUS_NO	NUMBER	The clients status was updated at the timestamp for the customer referenced
NOTIFY_METHOD_NO	NUMBER	the notify_method_no for the referenced record
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
PRIMARY_PAYMENT_METHOD_NO	NUMBER	the primary_payment_method_no for the referenced record
CLIENT_PRIMARY_PAYMENT_METHOD_ID	TEXT	the client_primary_payment_method_id for the referenced record
BACKUP_PAYMENT_METHOD_NO	NUMBER	the backup_payment_method_no for the referenced record
CLIENT_BACKUP_PAYMENT_METHOD_ID	TEXT	the client_backup_payment_method_id for the referenced record
STATEMENT_CONTACT_NO	NUMBER	the statement_contact_no for the referenced record
PAYMENT_TERM_NO	NUMBER	the payment_term_no for the referenced record
CLIENT_PAYMENT_TERM_ID	TEXT	the client_payment_term_id for the referenced record
CREDIT_NOTE_TEMPLATE_NO	NUMBER	the credit_note_template_no for the referenced record
CLIENT_CREDIT_NOTE_TEMPLATE_ID	TEXT	the client_credit_note_template_id for the referenced record
EAN_GLN_NUM	TEXT	the ean_gln_num for the referenced record
EAN_GLN_REQUISITION_NUM	TEXT	the ean_gln_requisition_num for the referenced record
STATEMENT_TEMPLATE_NO	NUMBER	the statement_template_no for the referenced record
CLIENT_STATEMENT_TEMPLATE_ID	TEXT	the client_statement_template_id for the referenced record
CREDIT_MEMO_TEMPLATE_NO	NUMBER	the credit_memo_template_no for the referenced record
CLIENT_CREDIT_MEMO_TEMPLATE_ID	TEXT	the client_credit_memo_template_id for the referenced record
REBILL_TEMPLATE_NO	NUMBER	the rebill_template_no for the referenced record
CLIENT_REBILL_TEMPLATE_ID	TEXT	the client_rebill_template_id for the referenced record
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
COLLECTION_ACCOUNT_GROUPS	VARIANT	An embedded one to many JSON subrecord related to collection account groups
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
BCC_EMAIL_ADDRESSES	BILLING_GROUPS	VM_BG_BCC_EMAIL_ADDRESSES
CC_EMAIL_ADDRESSES	BILLING_GROUPS	VM_BG_CC_EMAIL_ADDRESSES
COLLECTION_ACCOUNT_GROUPS	BILLING_GROUPS	VM_BG_COLLECTION_ACCOUNT_GROUPS

► Catalog Probes

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
PROBE_NO	TEXT	the probe_no for the referenced record
EVENT_TSTAMP	TIMESTAMP_NTZ	EVENT_TSTAMP of the JSON record
INJECTED_HOST	TEXT	the injected_host for the referenced record
INJECTED_TYPE	TEXT	the injected_type for the referenced record
INJECTED_TSTAMP	TIMESTAMP_NTZ	the injected_tstamp for the referenced record
PROCESSED_HOST	TEXT	the processed_host for the referenced record
PROCESSED_TSTAMP	TIMESTAMP_NTZ	the processed_tstamp for the referenced record
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

► Chart Of 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
CHART_OF_ACCOUNTS_NO	NUMBER	the chart_of_accounts_no for the referenced record
CLIENT_CHART_OF_ACCOUNTS_ID	TEXT	the client_chart_of_accounts_id for the referenced record
DESCRIPTION	TEXT	The detailed description related to 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

► Comments

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
COMMENT_NO	NUMBER	the comment_no for the referenced record
ACCOUNT_NO	NUMBER	The account number related to the customer referenced
USERID	TEXT	The userid for login related to the customer referenced
APPLICATION_ID	TEXT	the application_id for the referenced record
APPLICATION_TSTAMP_TEXT	TEXT	the application_tstamp_text for the referenced record
AUTHOR	TEXT	the author for the referenced record
COMMENTS	TEXT	The detailed comments related to the referenced data
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created 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

► Contacts

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
CONTACT_NO	NUMBER	the contact_no for the referenced 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
FIRST_NAME	TEXT	The first name of the person referenced in the data
MIDDLE_INITIAL	TEXT	The middle initial of the person referenced in the data
LAST_NAME	TEXT	The last name of the person referenced in the data
COMPANY_NAME	TEXT	The legal company name of the entity referenced in the data
STREET	VARIANT	The contacts street address.
CITY	TEXT	The city address of the referenced data
LOCALITY	TEXT	the locality for the referenced record
STATE_PROV	TEXT	The state or province address of the referenced data
COUNTRY_CD	TEXT	The ISO country code of the address of the referenced data
POSTAL_CODE	TEXT	The postal code of the address of the referenced data
PHONE	TEXT	The phone number of the referenced data
PHONE_EXT	TEXT	The phone numbers extension of the referenced data
CELL_PHONE	TEXT	The cellular phone number of the referenced data
WORK_PHONE	TEXT	The work phone number of the referenced data
WORK_PHONE_EXT	TEXT	The work phone numbers extension of the referenced data
FAX	TEXT	The fax number of the referenced data
EMAIL	TEXT	The email of the referenced person or entity
BIRTHDATE	DATE	The birthdate of the referenced person
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created 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
Child Views
Variant	Source Table	Child View Name
STREET	CONTACTS

► Coupons

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
COUPON_CODE	TEXT	The aria facing unique identifier code for a coupon
SCOPE_NO	TEXT	the scope_no for the referenced record
CREDIT_TEMPLATES	VARIANT	An embedded one to many JSON subrecord related to credit templates
DESCRIPTION	TEXT	The detailed description related to the referenced data
DISCOUNT_BUNDLES	TEXT	the discount_bundles for the referenced record
DISCOUNT_RULES	VARIANT	An embedded one to many JSON subrecord related to discount rules
EXPIRE_DATE	DATE	the expire_date for the referenced record
IS_ACTIVE	BOOLEAN	A True or False indicator showing if the record is active
LOCALE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to the records locale
MAXIMUM_USES	NUMBER	the maximum_uses for the referenced record
START_DATE	DATE	the start_date for the referenced record
TOTAL_USES	NUMBER	the total_uses for the referenced record
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
CREDIT_TEMPLATES	COUPONS	VM_COUPON_CREDIT_TEMPLATES
DISCOUNT_RULES	COUPONS	VM_COUPON_DISCOUNT_RULES
LOCALE_DETAILS	COUPONS	VM_COUPON_LOCALE_DETAILS

► Credit Memos

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
CREDIT_MEMO_NO	NUMBER	the credit_memo_no for the referenced record
ACCOUNT_NO	NUMBER	The account number related to the customer referenced
USERID	TEXT	The userid for login related to the customer referenced
AMOUNT	NUMBER	The amount of the referenced transaction value in the asociated currency
COMMENTS	TEXT	The detailed comments related to the referenced data
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data
CREDIT_REASON_NO	NUMBER	the credit_reason_no for the referenced record
CREDIT_REF_TYPE_NO	NUMBER	the credit_ref_type_no for the referenced record
CURRENCY_CD	TEXT	The ISO currency code of the referenced data
CUSTOMER_NOTE	TEXT	the customer_note for the referenced record
INVOICE_NO	NUMBER	The aria facing unique identifier for an invoice
LINES	VARIANT	An embedded one to many JSON subrecord related to lines
TAX_DETAILS	VARIANT	An embedded one to many JSON subrecord related to tax details
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
LINES	CREDIT_MEMOS	VM_CM_LINES
TAX_DETAILS	CREDIT_MEMOS	VM_CM_TAX_DETAILS

► Dunning Groups

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
DUNNING_GROUP_NO	NUMBER	the dunning_group_no for the referenced record
CLIENT_DUNNING_GROUP_ID	TEXT	the client_dunning_group_id for the referenced record
ACCOUNT_NO	NUMBER	The account number related to the customer referenced
USERID	TEXT	The userid for login related to the customer referenced
DESCRIPTION	TEXT	The detailed description related to the referenced data
DUNNING_PROCESS	TEXT	the dunning_process for the referenced record
NAME	TEXT	the name for the referenced record
DUNNING_STATUS_NO	NUMBER	the dunning_status_no for the referenced record
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

► Invoices

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
INVOICE_NO	NUMBER	The aria facing unique identifier for an invoice
STATUS_NO	NUMBER	The clients status was updated at the timestamp for the customer referenced
INVOICE_TYPE_CD	TEXT	the invoice_type_cd for the referenced 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
BILLING_GROUP_NO	NUMBER	The designated billing group number for the referenced data
CLIENT_BILLING_GROUP_ID	TEXT	the client_billing_group_id for the referenced record
STATEMENT_NO	VARIANT	the statement_no for the referenced record
ORIGINAL_INVOICE_NO	NUMBER	the original_invoice_no for the referenced record
REBILL_INVOICE_NO	NUMBER	the rebill_invoice_no for the referenced record
REBILL_REASON_NO	NUMBER	the rebill_reason_no for the referenced record
TAXATION_ADDRESS_CONTACT_NO	VARIANT	the taxation_address_contact_no for the referenced record
RECURRING_BILL_FROM	DATE	the recurring_bill_from for the referenced record
RECURRING_BILL_THROUGH	DATE	the recurring_bill_through for the referenced record
USAGE_FROM	DATE	the usage_from for the referenced record
USAGE_THROUGH	DATE	the usage_through for the referenced record
CURRENCY_CD	TEXT	The ISO currency code of the referenced data
AMOUNT	NUMBER	The amount of the referenced transaction value in the asociated currency
INVOICE_BALANCE_FORWARD	NUMBER	the invoice_balance_forward for the referenced record
TOTAL_DUE	NUMBER	the total_due for the referenced record
BILLED_TSTAMP	TIMESTAMP_NTZ	the billed_tstamp for the referenced record
PAID_TSTAMP	TIMESTAMP_NTZ	the paid_tstamp for the referenced record
CUSTOM_STATUS_LABEL	TEXT	the custom_status_label for the referenced record
CUSTOM_STATUS_DESCRIPTION	TEXT	the custom_status_description for the referenced record
INVOICE_COMMENTS	TEXT	the invoice_comments for the referenced record
ADDITIONAL_COMMENTS	TEXT	The additional comments related to the referenced data
CLIENT_NOTES	TEXT	the client_notes 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
LINES	VARIANT	An embedded one to many JSON subrecord related to lines
PENDING_LINES	VARIANT	An embedded one to many JSON subrecord related to pending_lines
TAX_DETAILS	VARIANT	An embedded one to many JSON subrecord related to tax details
PENDING_TAX_DETAILS	VARIANT	An embedded one to many JSON subrecord related to pending_tax_details
INVOICE_USAGE_STATUS_CD	TEXT	the invoice_usage_status_cd for the referenced record
DISCOUNT_DETAILS	VARIANT	An embedded one to many JSON subrecord related to discount details
PENDING_DISCOUNT_DETAILS	VARIANT	An embedded one to many JSON subrecord related to pending_discount_details
SURCHARGE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to surcharge_details
PENDING_SURCHARGE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to pending_surcharge_details
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
DISCOUNT_DETAILS	INVOICES	VM_INVOICE_DISCOUNT_DETAILS
LINES	INVOICES	VM_INVOICE_LINES
PENDING_DISCOUNT_DETAILS	INVOICES	VM_INVOICE_PENDING_DISCOUNT_DETAILS
PENDING_LINES	INVOICES	VM_INVOICE_PENDING_LINES
PENDING_SURCHARGE_DETAILS	INVOICES	VM_INVOICE_PENDING_SURCHARGE_DETAILS
PENDING_TAX_DETAILS	INVOICES	VM_INVOICE_PENDING_TAX_DETAILS
SURCHARGE_DETAILS	INVOICES	VM_INVOICE_SURCHARGE_DETAILS
TAX_DETAILS	INVOICES	VM_INVOICE_TAX_DETAILS

► Invoice Reversals

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
REVERSAL_NO	NUMBER	the reversal_no for the referenced record
ACCOUNT_NO	NUMBER	The account number related to the customer referenced
USERID	TEXT	The userid for login related to the customer referenced
AMOUNT	NUMBER	The amount of the referenced transaction value in the asociated currency
COMMENTS	TEXT	The detailed comments related to the referenced data
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data
CURRENCY_CD	TEXT	The ISO currency code of the referenced data
LINES	VARIANT	An embedded one to many JSON subrecord related to lines
TAX_DETAILS	VARIANT	An embedded one to many JSON subrecord related to tax details
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
LINES	INVOICE_REVERSALS	VM_IR_LINES
TAX_DETAILS	INVOICE_REVERSALS	VM_IR_TAX_DETAILS

► Lookups

LOOKUP_NAME	TEXT	the lookup_name for the referenced record
ID	TEXT	the id for the referenced record
LOM	TEXT	the lom for the referenced record
TAB	TEXT	the tab for the referenced record
COLUMN_NAME	TEXT	the column_name for the referenced record
DESCR	TEXT	the descr for the referenced record
OVERFLOW	TEXT	the overflow for the referenced record

► Non-subscription Offerings

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
NONSUBSCRIPTION_OFFERING_NO	TEXT	the nonsubscription_offering_no for the referenced record
AUTO_CREATED_CREDIT_COMMENTS	TEXT	the auto_created_credit_comments for the referenced record
AUTO_CREATED_CREDIT_SERVICE	TEXT	the auto_created_credit_service for the referenced record
CLIENT_NONSUBSCRIPTION_OFFERING_ID	TEXT	the client_nonsubscription_offering_id for the referenced record
CLIENT_SKU	TEXT	the client_sku for the referenced record
DESCRIPTION	TEXT	The detailed description related to the referenced data
HAS_PURCHASE_RESTRICTION	BOOLEAN	the has_purchase_restriction for the referenced record
IS_ACTIVE	BOOLEAN	A True or False indicator showing if the record is active
IS_AUTO_CREATE_CREDIT	BOOLEAN	A True or False indicator showing if the record is an auto created credit
LOCALE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to the records locale
NAME	TEXT	the name for the referenced record
NONSUBSCRIPTION_OFFERING_RATE_SCHEDULES	VARIANT	An embedded one to many JSON subrecord related to nonsubscription offering rate schedules
PRODUCT_FIELD_ASSIGNMENTS	TEXT	An embedded one to many JSON subrecord related to product field assignments
QUEUE_ACTIVATION_STATUS	TEXT	the queue_activation_status for the referenced record
QUEUE_DATE	DATE	the queue_date for the referenced record
CLIENT_SERVICE_ID	TEXT	the client_service_id for the referenced record
SERVICE_NO	TEXT	the service_no for the referenced record
STOCK_LEVEL	TEXT	the stock_level for the referenced record
SUBUNIT_LABEL	TEXT	the subunit_label for the referenced record
SUBUNIT_QUANTITY	NUMBER	the subunit_quantity for the referenced record
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
LOCALE_DETAILS	NONSUBSCRIPTION_OFFERINGS	VM_NSO_LOCALE_DETAILS
NONSUBSCRIPTION_OFFERING_RATE_SCHEDULES	NONSUBSCRIPTION_OFFERINGS	VM_NSO_NONSUBSCRIPTION_OFFERING_RATE_SCHEDULES
PRODUCT_FIELD_ASSIGNMENTS	NONSUBSCRIPTION_OFFERINGS	VM_NSO_PFA_VALUES
PRODUCT_FIELD_ASSIGNMENTS	NONSUBSCRIPTION_OFFERINGS	VM_NSO_PFA_VALUE_LOCALE_DETAILS
PRODUCT_FIELD_ASSIGNMENTS	NONSUBSCRIPTION_OFFERINGS	VM_NSO_PRODUCT_FIELD_ASSIGNMENTS

► Orders

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
ORDER_NO	NUMBER	the order_no for the referenced record
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
AMOUNT	NUMBER	The amount of the referenced transaction value in the asociated currency
CLIENT_ORDER_ID	TEXT	the client_order_id for the referenced record
COMMENTS	TEXT	The detailed comments related to the referenced data
CREATED_RECEIPT_ID	TEXT	the created_receipt_id for the referenced record
CURRENCY_CD	TEXT	The ISO currency code of the referenced data
FULFILL_DATE	DATE	the fulfill_date for the referenced record
INVOICE_NO	NUMBER	The aria facing unique identifier for an invoice
LINES	VARIANT	An embedded one to many JSON subrecord related to lines
CLIENT_PLAN_INSTANCE_ID	TEXT	The occurrence (instance) of a plan for the referenced data
PLAN_INSTANCE_NO	NUMBER	The Aria facing unique identifier for a plan_instance
PURCHASE_ORDER_NUMBER	TEXT	The aria facing unique identifier for a purchase order
STATEMENT_MESSAGE	TEXT	the statement_message for the referenced record
STATUS_NO	NUMBER	The clients status was updated at the timestamp for the customer referenced
UPDATED_RECEIPT_ID	TEXT	the updated_receipt_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
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
LINES	ORDERS

► 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

► Pending Invoice Lines

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
INVOICE_NO	NUMBER	The aria facing unique identifier for an invoice
LINE_NO	NUMBER	the line_no for the referenced record
ADVANCE_BILLING_PERIOD_TOTAL_DAYS	NUMBER	the advance_billing_period_total_days for the referenced record
BASE_PLAN_UNITS	NUMBER	the base_plan_units for the referenced record
COMMENTS	TEXT	The detailed comments related to the referenced data
CREDIT_COUPON	TEXT	the credit_coupon for the referenced record
CREDIT_REASON	TEXT	the credit_reason for the referenced record
END_DATE	DATE	the end_date for the referenced record
IS_TAX_RELATED	BOOLEAN	A True or False indicator showing if the record is tax related
NONSUBSCRIPTION_OFFERING_RATE_SCHEDULE	TEXT	the nonsubscription_offering_rate_schedule for the referenced record
NONSUBSCRIPTION_OFFERING_RATE_SCHEDULE_TIER	TEXT	the nonsubscription_offering_rate_schedule_tier for the referenced record
PLAN_NO	NUMBER	The Aria facing unique identifier for a plan
PLAN_INSTANCE_NO	NUMBER	The Aria facing unique identifier for a plan_instance
PLAN_RATE_SCHEDULE	VARIANT	An embedded one to many JSON subrecord related to plan_rate_schedule
PLAN_RATE_SCHEDULE_SERVICE_TIER	TEXT	the plan_rate_schedule_service_tier for the referenced record
PRORATION_DESCRIPTION	TEXT	the proration_description for the referenced record
PRORATION_FACTOR	TEXT	the proration_factor for the referenced record
PRORATION_OPERATION_TYPE	TEXT	the proration_operation_type for the referenced record
PRORATION_REMAINING_DAYS	NUMBER	the proration_remaining_days for the referenced record
PURCHASE_ORDER_NUMBER	TEXT	The aria facing unique identifier for a purchase order
RATE	NUMBER	the rate for the referenced record
SERVICE_NO	NUMBER	the service_no for the referenced record
CLIENT_SERVICE_ID	TEXT	the client_service_id for the referenced record
SERVICE_CREDIT	TEXT	the service_credit for the referenced record
SERVICE_CREDIT_SOURCE_TRANSACTION	VARIANT	An embedded one to many JSON subrecord related to service_credit_source_transaction
START_DATE	DATE	the start_date for the referenced record
SURCHARGE_RATE_SCHEDULE	VARIANT	An embedded one to many JSON subrecord related to surcharge_rate_schedule
SURCHARGE_RATE_SCHEDULE_TIER	VARIANT	An embedded one to many JSON subrecord related to surcharge_rate_schedule_tier
UNITS	NUMBER	the units for the referenced record
USAGE_TYPE	TEXT	the usage_type for the referenced record
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

► Plans

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
PLAN_NO	NUMBER	The Aria facing unique identifier for a plan
CLIENT_PLAN_ID	TEXT	The client facing unique identifier for a plan
NAME	TEXT	the name for the referenced record
DESCRIPTION	TEXT	The detailed description related to the referenced data
IS_ACTIVE	BOOLEAN	A True or False indicator showing if the record is active
IS_SUPPLEMENTAL_PLAN	BOOLEAN	A True or False indicator showing if the record is a supplemental plan
IS_TEMPLATE	BOOLEAN	A True or False indicator showing if the record is a template
PRODUCT_FIELD_CATEGORIES	VARIANT	An embedded one to many JSON subrecord related to product field categories
PRORATION_INVOICE_TIMING_CD	NUMBER	the proration_invoice_timing_cd for the referenced record
STATEMENT_TEMPLATE_NO	NUMBER	the statement_template_no for the referenced record
CLIENT_STATEMENT_TEMPLATE_ID	TEXT	the client_statement_template_id for the referenced record
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
CREDIT_NOTE_TEMPLATE_NO	NUMBER	the credit_note_template_no for the referenced record
CLIENT_CREDIT_NOTE_TEMPLATE_ID	TEXT	the client_credit_note_template_id for the referenced record
CREDIT_MEMO_TEMPLATE_NO	NUMBER	the credit_memo_template_no for the referenced record
CLIENT_CREDIT_MEMO_TEMPLATE_ID	TEXT	the client_credit_memo_template_id for the referenced record
REBILL_TEMPLATE_NO	NUMBER	the rebill_template_no for the referenced record
CLIENT_REBILL_TEMPLATE_ID	TEXT	the client_rebill_template_id for the referenced record
HAS_PLAN_CANCELLATION_FEE	BOOLEAN	the has_plan_cancellation_fee for the referenced record
CANCELLATION_MINIMUM_MONTHS	NUMBER	the cancellation_minimum_months for the referenced record
SURCHARGES	VARIANT	An embedded one to many JSON subrecord related to surcharges
SERVICE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to service details
PLAN_RATE_SCHEDULES	VARIANT	An embedded one to many JSON subrecord related to plan_rate_schedules
NONSUBSCRIPTION_OFFERING_BUNDLE_TYPE_CD	TEXT	the nonsubscription_offering_bundle_type_cd for the referenced record
NONSUBSCRIPTION_OFFERING_INDIVIDUALS	VARIANT	An embedded one to many JSON subrecord related to nonsubscription offering individuals
NONSUBSCRIPTION_OFFERING_GROUP	VARIANT	An embedded one to many JSON subrecord related to nonsubscription offering group
AVAILABLE_NONSUBSCRIPTION_OFFERING_SCOPE_IND	NUMBER	the available_nonsubscription_offering_scope_ind for the referenced record
AVAILABLE_NONSUBSCRIPTION_OFFERINGS	VARIANT	An embedded one to many JSON subrecord related to available nonsubscription offerings
DEFAULT_CURRENCY_CD	TEXT	the default_currency_cd for the referenced record
INITIAL_FREE_PERIOD_QUANTITY	NUMBER	the initial_free_period_quantity for the referenced record
INITIAL_FREE_PERIOD_TYPE_NO	NUMBER	the initial_free_period_type_no for the referenced record
INITIAL_PLAN_INSTANCE_STATUS_NO	NUMBER	the initial_plan_instance_status_no for the referenced record
PLAN_INSTANCE_STATUS_ROLLOVER_PERIOD_QUANTITY	NUMBER	the plan_instance_status_rollover_period_quantity for the referenced record
PLAN_INSTANCE_STATUS_ROLLOVER_PERIOD_TYPE_NO	NUMBER	the plan_instance_status_rollover_period_type_no for the referenced record
ROLLOVER_PLAN_INSTANCE_STATUS_NO	NUMBER	the rollover_plan_instance_status_no for the referenced record
ROLLOVER_PLAN_NO	NUMBER	the rollover_plan_no for the referenced record
CLIENT_ROLLOVER_PLAN_ID	TEXT	the client_rollover_plan_id for the referenced record
ROLLOVER_PLAN_PERIOD_QUANTITY	NUMBER	the rollover_plan_period_quantity for the referenced record
ROLLOVER_PLAN_PERIOD_TYPE_NO	NUMBER	the rollover_plan_period_type_no for the referenced record
CONTRACT_COMPLETION_ROLLOVER_PLAN_NO	NUMBER	the contract_completion_rollover_plan_no for the referenced record
CLIENT_CONTRACT_COMPLETION_ROLLOVER_PLAN_ID	TEXT	the client_contract_completion_rollover_plan_id for the referenced record
CONTRACT_COMPLETION_ROLLOVER_RATE_SCHEDULES	VARIANT	An embedded one to many JSON subrecord related to contract completion rollover rate schedule
LOCALE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to the records locale
PRODUCT_FIELD_ASSIGNMENTS	VARIANT	An embedded one to many JSON subrecord related to product field assignments
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created 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
Child Views
Variant	Source Table	Child View Name
AVAILABLE_NONSUBSCRIPTION_OFFERINGS	PLANS	VM_PLAN_AVAILABLE_NONSUBSCRIPTION_OFFERINGS
CONTRACT_COMPLETION_ROLLOVER_RATE_SCHEDULES	PLANS	VM_PLAN_CONTRACT_COMPLETION_ROLLOVER_RATE_SCHEDULES
LOCALE_DETAILS	PLANS	VM_PLAN_LOCALE_DETAILS
NONSUBSCRIPTION_OFFERING_GROUP	PLANS	VM_PLAN_NONSUBSCRIPTION_OFFERING_GROUPS
NONSUBSCRIPTION_OFFERING_GROUP	PLANS	VM_PLAN_NSOG_PLAN_NONSUBSCRIPTION_OFFERINGS_NONSUBSCRIPTION_OFFERING_SCHEDULE_ASSIGNMENTS
NONSUBSCRIPTION_OFFERING_INDIVIDUALS	PLANS	VM_PLAN_NONSUBSCRIPTION_OFFERING_INDIVIDUALS
PLAN_RATE_SCHEDULES	PLANS	VM_PLAN_PLAN_RATE_SCHEDULES
PRODUCT_FIELD_ASSIGNMENTS	PLANS	VM_PLAN_PFA_VALUES
PRODUCT_FIELD_ASSIGNMENTS	PLANS	VM_PLAN_PFA_VALUE_LOCALE_DETAILS
PRODUCT_FIELD_ASSIGNMENTS	PLANS	VM_PLAN_PRODUCT_FIELD_ASSIGNMENTS
PRODUCT_FIELD_CATEGORIES	PLANS	VM_PLAN_PRODUCT_FIELD_CATEGORIES
SERVICE_DETAILS	PLANS	VM_PLAN_SD_USAGE_THRESHOLDS
SERVICE_DETAILS	PLANS	VM_PLAN_SD_UT_LEVELS
SERVICE_DETAILS	PLANS	VM_PLAN_SERVICE_DETAILS
SURCHARGES	PLANS	VM_PLAN_SURCHARGES

► Plan Instances

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
PLAN_INSTANCE_NO	NUMBER	The Aria facing unique identifier for a plan_instance
CLIENT_PLAN_INSTANCE_ID	TEXT	The occurrence (instance) of a plan for the referenced data
MASTER_PLAN_INSTANCE_NO	NUMBER	The Aria facing unique identifier for an master plan instance
MASTER_CLIENT_PLAN_INSTANCE_ID	TEXT	The client facing unique identifier for an master plan instance
PARENT_PLAN_INSTANCE_NO	NUMBER	the parent_plan_instance_no for the referenced record
PARENT_CLIENT_PLAN_INSTANCE_ID	TEXT	the parent_client_plan_instance_id for the referenced 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
PLAN_NO	NUMBER	The Aria facing unique identifier for a plan
CLIENT_PLAN_ID	TEXT	The client facing unique identifier for a plan
PLAN_UNITS	NUMBER	the plan_units for the referenced record
LAST_BILL_DATE	DATE	the last_bill_date for the referenced record
NEXT_BILL_DATE	DATE	the next_bill_date for the referenced record
LAST_BILL_THROUGH_DATE	DATE	the last_bill_through_date for the referenced record
LAST_ARREARS_BILL_THROUGH_DATE	DATE	the last_arrears_bill_through_date for the referenced record
LAST_ARREARS_RECURRING_BILL_THROUGH_DATE	DATE	the last_arrears_recurring_bill_through_date 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
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
TERMINATED_TSTAMP	TIMESTAMP_NTZ	the terminated_tstamp for the referenced record
PROVISIONED_TSTAMP	TIMESTAMP_NTZ	the provisioned_tstamp for the referenced record
RATE_SCHEDULE_NO	NUMBER	the rate_schedule_no for the referenced record
CLIENT_RATE_SCHEDULE_ID	TEXT	the client_rate_schedule_id for the referenced record
CREATED_RECEIPT_ID	TEXT	the created_receipt_id for the referenced record
DESCRIPTION	TEXT	The detailed description related to the referenced data
PURCHASE_ORDER_NUMBER	TEXT	The aria facing unique identifier for a purchase order
IS_USAGE_POOLING_ENABLED	BOOLEAN	A True or False indicator showing if the record has usage pooling enabled
USAGE_POOLING_COUNTER	NUMBER	the usage_pooling_counter for the referenced record
PROMOTION_CODE	TEXT	the promotion_code for the referenced record
BILL_LAG_DAYS	NUMBER	the bill_lag_days for the referenced record
BILL_DAY	NUMBER	the bill_day for the referenced record
DUNNING_STATE	NUMBER	the dunning_state for the referenced record
DUNNING_STEP	NUMBER	the dunning_step for the referenced record
DUNNING_DEGRADE_DATE	DATE	the dunning_degrade_date for the referenced record
USAGE_ACCUMULATION_RESET_MONTHS	NUMBER	the usage_accumulation_reset_months for the referenced record
USAGE_ACCUMULATION_RESET_MONTHS_RENEWAL_OPTION	NUMBER	the usage_accumulation_reset_months_renewal_option for the referenced record
USAGE_ACCUMULATION_RESET_COUNTER	NUMBER	the usage_accumulation_reset_counter for the referenced record
PRODUCT_FIELDS	VARIANT	An embedded one to many JSON subrecord related to product fields
CUSTOM_RATES	VARIANT	An embedded one to many JSON subrecord related to custom rates
SERVICE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to service details
BILLING_GROUP_NO	NUMBER	The designated billing group number for the referenced data
CLIENT_BILLING_GROUP_ID	TEXT	the client_billing_group_id for the referenced record
DUNNING_GROUP_NO	NUMBER	the dunning_group_no for the referenced record
CLIENT_DUNNING_GROUP_ID	TEXT	the client_dunning_group_id for the referenced record
RESPONSIBILITY_LEVEL_NO	NUMBER	the responsibility_level_no for the referenced record
RESPONSIBLE_PLAN_INSTANCE_NO	NUMBER	the responsible_plan_instance_no for the referenced record
RESPONSIBLE_CLIENT_PLAN_INSTANCE_ID	TEXT	the responsible_client_plan_instance_id for the referenced record
SURCHARGES	VARIANT	An embedded one to many JSON subrecord related to surcharges
BALANCE	NUMBER	The clients balance owed on their account for the customer referenced
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
CUSTOM_RATES	PLAN_INSTANCES	VM_PI_CUSTOM_RATES
PRODUCT_FIELDS	PLAN_INSTANCES	VM_PI_PF_VALUES
PRODUCT_FIELDS	PLAN_INSTANCES	VM_PI_PRODUCT_FIELDS
SERVICE_DETAILS	PLAN_INSTANCES	VM_PI_SERVICE_DETAILS
SURCHARGES	PLAN_INSTANCES	VM_PI_SURCHARGES

► Plan Instance Coupon Assignments

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
PLAN_INSTANCE_NO	NUMBER	The Aria facing unique identifier for a plan_instance
COUPON_CODE	TEXT	The aria facing unique identifier code for a coupon
CLIENT_PLAN_INSTANCE_ID	TEXT	The occurrence (instance) of a plan for the referenced data
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
CANCELLED_TSTAMP	TIMESTAMP_NTZ	The original source system cancelled 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

► Plan Instance Discount Rule Assignments

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
ASSIGNMENT_NO	NUMBER	the assignment_no for the referenced record
DISCOUNT_RULE_NO	NUMBER	the discount_rule_no for the referenced record
CLIENT_DISCOUNT_RULE_ID	TEXT	the client_discount_rule_id for the referenced record
BUNDLE_NO	NUMBER	the bundle_no for the referenced record
PLAN_INSTANCE_NO	NUMBER	The Aria facing unique identifier for a plan_instance
CLIENT_PLAN_INSTANCE_ID	TEXT	The occurrence (instance) of a plan for the referenced data
COUPON_CODE	TEXT	The aria facing unique identifier code for a coupon
OVERRIDE_MAX_APPLICATIONS	NUMBER	the override_max_applications for the referenced record
TOTAL_APPLICATIONS	NUMBER	the total_applications for the referenced record
ASSIGNED_TSTAMP	TIMESTAMP_NTZ	the assigned_tstamp for the referenced record
UNASSIGNED_TSTAMP	TIMESTAMP_NTZ	the unassigned_tstamp for the referenced record
EXPIRATION_DATE	DATE	the expiration_date for the referenced record
REMAINDER_DISCOUNT_FACTOR	NUMBER	the remainder_discount_factor for the referenced record
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

► Plan Rate Schedules

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
SCHEDULE_NO	NUMBER	the schedule_no for the referenced record
CLIENT_RATE_SCHEDULE_ID	TEXT	the client_rate_schedule_id for the referenced record
AVAILABLE_FROM_DATE	DATE	the available_from_date for the referenced record
AVAILABLE_TO_DATE	DATE	the available_to_date for the referenced record
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data
CURRENCY_CODE	TEXT	the currency_code for the referenced record
FOLLOWUP_DEFAULT_RATE_SCHEDULE	TEXT	the followup_default_rate_schedule for the referenced record
IS_DEFAULT_FOR_CURRENCY	BOOLEAN	A True or False indicator showing if the record is the default for currency
LOCALE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to the records locale
NAME	TEXT	the name for the referenced record
QUEUED_RATE_CHANGE_DATE	DATE	the queued_rate_change_date for the referenced record
RECURRING_BILLING_INTERVAL_TYPE	NUMBER	the recurring_billing_interval_type for the referenced record
RECURRING_BILLING_INTERVAL_TYPE_NO	NUMBER	the recurring_billing_interval_type_no for the referenced record
TIERS	VARIANT	An embedded one to many JSON subrecord related to tiers
USAGE_BILLING_INTERVAL_TYPE	NUMBER	the usage_billing_interval_type for the referenced record
USAGE_BILLING_INTERVAL_TYPE_NO	NUMBER	the usage_billing_interval_type_no for the referenced record
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
LOCALE_DETAILS	PLAN_RATE_SCHEDULES	VM_PRS_LOCALE_DETAILS
TIERS	PLAN_RATE_SCHEDULES	VM_PRS_TIERS
TIERS	PLAN_RATE_SCHEDULES	VM_PRS_TIERS_LOCALE_DETAILS

► Plan Relationships

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
PARENT_PLAN_NO	NUMBER	the parent_plan_no for the referenced record
CHILD_PLAN_NO	NUMBER	the child_plan_no for the referenced record
PARENT_CLIENT_PLAN_ID	TEXT	the parent_client_plan_id for the referenced record
CHILD_CLIENT_PLAN_ID	TEXT	the child_client_plan_id for the referenced record
HAS_ACCOUNT_LIMITS	BOOLEAN	the has_account_limits for the referenced record
IS_DEFAULT	BOOLEAN	A True or False indicator showing if the record is the default
IS_REQUIRED	BOOLEAN	A True or False indicator showing if the record is mandatory
MAXIMUM_UNITS	NUMBER	the maximum_units for the referenced record
MINIMUM_UNITS	NUMBER	the minimum_units for the referenced record
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

► Plan Unit Instances

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
PLAN_UNIT_INSTANCE_NO	NUMBER	the plan_unit_instance_no for the referenced record
CLIENT_PLAN_UNIT_INSTANCE_ID	TEXT	the client_plan_unit_instance_id for the referenced record
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data
PLAN_INSTANCE_NO	NUMBER	The Aria facing unique identifier for a plan_instance
CLIENT_PLAN_INSTANCE_ID	TEXT	The occurrence (instance) of a plan for the referenced data
PRODUCT_FIELDS	VARIANT	An embedded one to many JSON subrecord related to product fields
SERVICES	VARIANT	An embedded one to many JSON subrecord related to services
PLAN_UNIT_INSTANCE_STATUS_NO	NUMBER	the plan_unit_instance_status_no for the referenced record
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
PRODUCT_FIELDS	PLAN_UNIT_INSTANCES	VM_PUI_PF_VALUES
PRODUCT_FIELDS	PLAN_UNIT_INSTANCES	VM_PUI_PRODUCT_FIELDS
SERVICES	PLAN_UNIT_INSTANCES	VM_PUI_SERVICES

► Product Fields

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
FIELD_NO	NUMBER	the field_no for the referenced record
FIELD_NAME	TEXT	the field_name for the referenced record
ALLOWED_VALUES	VARIANT	The allowable data values for the pull down lists related to the referenced data
DESCRIPTION	TEXT	The detailed description related to the referenced data
INPUT_TYPE	TEXT	the input_type for the referenced record
LOCALE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to the records locale
MAXIMUM_SELECTIONS	NUMBER	the maximum_selections for the referenced record
MINIMUM_SELECTIONS	NUMBER	the minimum_selections for the referenced record
OBJECT_TYPE_CONFIGURATIONS	VARIANT	An embedded one to many JSON subrecord related to object_type_configurations
PRODUCT_FIELD_CATEGORIES	VARIANT	An embedded one to many JSON subrecord related to product field categories
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
ALLOWED_VALUES	PRODUCT_FIELDS	VM_PF_ALLOWED_VALUES
LOCALE_DETAILS	PRODUCT_FIELDS	VM_PF_LD_ALLOWED_VALUES
LOCALE_DETAILS	PRODUCT_FIELDS	VM_PF_LOCALE_DETAILS
OBJECT_TYPE_CONFIGURATIONS	PRODUCT_FIELDS	VM_PF_OBJECT_TYPE_CONFIGURATIONS
PRODUCT_FIELD_CATEGORIES	PRODUCT_FIELDS	VM_PF_PRODUCT_FIELD_CATEGORIES

► Product Field Categories

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
CATEGORY_NO	NUMBER	the category_no for the referenced record
CATEGORY_NAME	TEXT	the category_name for the referenced record
CATEGORY_DESCRIPTION	TEXT	the category_description for the referenced record
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

► Queued Plan Instance Changes

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
QUEUE_NO	NUMBER	the queue_no for the referenced record
ACCOUNT_NO	NUMBER	The account number related to the customer referenced
USERID	TEXT	The userid for login related to the customer referenced
AMOUNT	NUMBER	The amount of the referenced transaction value in the asociated currency
ALL_RATES	VARIANT	An embedded one to many JSON subrecord related to all rates
ALTERNATE_PLAN_INSTANCE_START_DATE	DATE	the alternate_plan_instance_start_date for the referenced record
ALTERNATE_PRORATION_START_DATE	DATE	the alternate_proration_start_date for the referenced record
AUTO_CANCEL_INCOMPATIBLE_SUPP_PLANS	TEXT	the auto_cancel_incompatible_supp_plans for the referenced record
AUTO_OFFSET_MONTHS_OPTION	TEXT	the auto_offset_months_option for the referenced record
BILLING_GROUP_NO	NUMBER	The designated billing group number for the referenced data
CHANGE_TYPE_NO	NUMBER	the change_type_no for the referenced record
COMMENTS	TEXT	The detailed comments related to the referenced data
COUPON_CHANGES	VARIANT	An embedded one to many JSON subrecord related to coupon changes
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data
CURRENT_PI_STATUS_LABEL	TEXT	the current_pi_status_label for the referenced record
CURRENT_PLAN_NAME	TEXT	the current_plan_name for the referenced record
CURRENT_PLAN_NO	NUMBER	the current_plan_no for the referenced record
CURRENT_RATE_SCHEDULE_NO	NUMBER	the current_rate_schedule_no for the referenced record
CURRENT_UNITS	NUMBER	the current_units for the referenced record
EFFECTIVE_DATE	DATE	the effective_date for the referenced record
EXECUTE_ON_ANNIVERSARY	BOOLEAN	the execute_on_anniversary for the referenced record
FORCE_BILL_DATE_RESET	BOOLEAN	the force_bill_date_reset for the referenced record
FORCE_MASTER_BILL_DATE_RESET	BOOLEAN	the force_master_bill_date_reset for the referenced record
INVOICE_UNBILLED_USAGE	NUMBER	the invoice_unbilled_usage for the referenced record
INVOICING_OPTION_NO	NUMBER	the invoicing_option_no for the referenced record
NSO_BILL_IMMEDIATELY	BOOLEAN	the nso_bill_immediately for the referenced record
NSO_ITEMS	VARIANT	An embedded one to many JSON subrecord related to nso items
OFFSET_MONTHS	NUMBER	the offset_months for the referenced record
OVERRIDE_BILL_THROUGH_DATE	DATE	the override_bill_through_date for the referenced record
PARENT_CLIENT_PLAN_INSTANCE_ID	TEXT	the parent_client_plan_instance_id for the referenced record
PLAN_INSTANCE_NO	NUMBER	The Aria facing unique identifier for a plan_instance
CLIENT_PLAN_INSTANCE_ID	TEXT	The occurrence (instance) of a plan for the referenced data
PLAN_INSTANCE_CHANGE_BILL_DAY	NUMBER	the plan_instance_change_bill_day for the referenced record
PLAN_INSTANCE_CHANGE_BILL_LAG_DAYS	NUMBER	the plan_instance_change_bill_lag_days for the referenced record
PLAN_INSTANCE_CHANGE_CLIENT_PLAN_INSTANCE_ID	TEXT	the plan_instance_change_client_plan_instance_id for the referenced record
PLAN_INSTANCE_CHANGE_CUSTOM_RATES	VARIANT	An embedded one to many JSON subrecord related to plan_instance_change_custom_rates
PLAN_INSTANCE_CHANGE_PLAN_NO	NUMBER	the plan_instance_change_plan_no for the referenced record
PLAN_INSTANCE_CHANGE_CLIENT_PLAN_ID	TEXT	the plan_instance_change_client_plan_id for the referenced record
PLAN_INSTANCE_DESCRIPTION	TEXT	the plan_instance_description for the referenced record
PLAN_UNITS	NUMBER	the plan_units for the referenced record
PROMOTION_CODE	TEXT	the promotion_code for the referenced record
PURCHASE_ORDER_NUMBER	TEXT	The aria facing unique identifier for a purchase order
SCHEDULE_NO	NUMBER	the schedule_no for the referenced record
CLIENT_RATE_SCHEDULE_ID	TEXT	the client_rate_schedule_id for the referenced record
PLAN_INSTANCE_CHANGE_STATUS_NO	NUMBER	the plan_instance_change_status_no for the referenced record
PRODUCT_FIELD_CHANGES	VARIANT	An embedded one to many JSON subrecord related to product_field_changes
PRORATION_DIRECTIVE_NO	NUMBER	the proration_directive_no for the referenced record
PRORATION_INVOICE_TIMING_OPTION	TEXT	the proration_invoice_timing_option for the referenced record
REMOVE_PLAN_INSTANCE_CUSTOM_RATES	BOOLEAN	the remove_plan_instance_custom_rates for the referenced record
RETROACTIVE_START_DATE	DATE	the retroactive_start_date for the referenced record
STATUS_NO	NUMBER	The clients status was updated at the timestamp for the customer referenced
STATUS_UNTIL_ALTERNATE_START_DATE	DATE	the status_until_alternate_start_date for the referenced record
SURCHARGE_CHANGES	VARIANT	An embedded one to many JSON subrecord related to surcharge_changes
TARGET_PI_STATUS_LABEL	TEXT	the target_pi_status_label for the referenced record
TARGET_PLAN_NAME	TEXT	the target_plan_name 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
Child Views
Variant	Source Table	Child View Name
COUPON_CHANGES	QUEUED_PLAN_INSTANCE_CHANGES	VM_QPIC_COUPON_CHANGES
NSO_ITEMS	QUEUED_PLAN_INSTANCE_CHANGES	VM_QPIC_NSO_ITEMS
PIC_CUSTOM_RATES	QUEUED_PLAN_INSTANCE_CHANGES	VM_QPIC_PIC_CUSTOM_RATES
PRODUCT_FIELDS_CHANGES	QUEUED_PLAN_INSTANCE_CHANGES	VM_QPIC_PFC_VALUES
PRODUCT_FIELDS_CHANGES	QUEUED_PLAN_INSTANCE_CHANGES	VM_QPIC_PRODUCT_FIELD_CHANGES
SURCHARGE_CHANGES	QUEUED_PLAN_INSTANCE_CHANGES	VM_QPIC_SURCHARGE_CHANGES

► Recurring Credits

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
RECURRING_CREDIT_NO	NUMBER	the recurring_credit_no for the referenced record
ACCOUNT_NO	NUMBER	The account number related to the customer referenced
USERID	TEXT	The userid for login related to the customer referenced
CANCEL_COMMENTS	TEXT	the cancel_comments for the referenced record
CANCEL_DATE	DATE	the cancel_date for the referenced record
COMMENTS	TEXT	The detailed comments 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_months for the referenced record
CREDIT_SERVICE	TEXT	the credit_service for the referenced record
CURRENCY_CD	TEXT	The ISO currency code of the referenced data
ELIGIBLE_PLAN_INSTANCES	VARIANT	An embedded one to many JSON subrecord related to eligible plan instances
ELIGIBLE_PLANS	VARIANT	An embedded one to many JSON subrecord related to eligible plans
ELIGIBLE_SERVICE_TYPES	VARIANT	An embedded one to many JSON subrecord related to eligible service types
EXPIRATION_DATE	DATE	the expiration_date for the referenced record
EXPIRATION_MONTHS	NUMBER	the expiration_months for the referenced record
EXPIRATION_TYPE_INDICATOR	TEXT	the expiration_type_indicator for the referenced record
FIRST_CREDIT_DATE	DATE	the first_credit_date for the referenced record
LAST_CREDIT_DATE	DATE	the last_credit_date for the referenced record
MASTER_PLAN_INSTANCE_NO	NUMBER	The Aria facing unique identifier for an master plan instance
MASTER_CLIENT_PLAN_INSTANCE_ID	TEXT	The client facing unique identifier for an master plan instance
NEXT_CREDIT_DATE	DATE	the next_credit_date for the referenced record
NUMBER_OF_CREDITS_REMAINING	NUMBER	the number_of_credits_remaining for the referenced record
NUMBER_OF_CREDITS_REQUIRED	NUMBER	the number_of_credits_required for the referenced record
PERCENTAGE_SOURCE_PLAN	NUMBER	the percentage_source_plan for the referenced record
PERCENTAGE_SOURCE_SERVICE	NUMBER	the percentage_source_service for the referenced record
REASON_NO	NUMBER	the reason_no for the referenced record
RECURRING_CREDIT_AMOUNT	NUMBER	the recurring_credit_amount for the referenced record
RECURRING_CREDIT_TYPE_NO	NUMBER	the recurring_credit_type_no for the referenced record
SOURCE_COUPON	TEXT	the source_coupon for the referenced record
STATUS_NO	NUMBER	The clients status was updated at the timestamp for the customer referenced
USE_CHARGE_SERVICE	BOOLEAN	the use_charge_service for the referenced record
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
ELIGIBLE_PLANS	RECURRING_CREDITS	VM_RC_ELIGIBLE_PLANS
ELIGIBLE_PLAN_INSTANCES	RECURRING_CREDITS	VM_RC_ELIGIBLE_PLAN_INSTANCES
ELIGIBLE_SERVICE_TYPES	RECURRING_CREDITS	VM_RC_ELIGIBLE_SERVICE_TYPES

► Services

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
SERVICE_NO	NUMBER	the service_no for the referenced record
CLIENT_SERVICE_ID	TEXT	the client_service_id for the referenced record
NAME	TEXT	the name for the referenced record
SERVICE_TYPE_CD	TEXT	the service_type_cd for the referenced record
IS_TAXABLE	BOOLEAN	A True or False indicator showing if the record is taxable
SERVICE_LOCATION_NO	VARIANT	the service_location_no for the referenced record
CLIENT_SERVICE_LOCATION_ID	TEXT	the client_service_location_id for the referenced record
IS_SERVICE_CREDITS_ELIGIBLE	BOOLEAN	A True or False indicator showing if the record is the service credit eligible
COMMODITY_CODE	TEXT	the commodity_code for the referenced record
PRODUCT_FIELD_ASSIGNMENTS	VARIANT	An embedded one to many JSON subrecord related to product field assignments
LOCALE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to the records locale
TAX_SERVICE_GROUP_NO	NUMBER	the tax_service_group_no for the referenced record
TAX_SERVICE_CLIENT_GROUP_ID	TEXT	the tax_service_client_group_id for the referenced record
REVENUE_ACCOUNT_GL_CODE_NO	NUMBER	the revenue_account_gl_code_no for the referenced record
REVENUE_ACCOUNT_GL_CODE_ID	TEXT	the revenue_account_gl_code_id for the referenced record
ACCOUNT_RECEIVABLE_GL_CODE_NO	NUMBER	the account_receivable_gl_code_no for the referenced record
ACCOUNT_RECEIVABLE_GL_CODE_ID	TEXT	the account_receivable_gl_code_id for the referenced record
DEFERRED_GL_CODE_NO	NUMBER	the deferred_gl_code_no for the referenced record
DEFERRED_GL_CODE_ID	TEXT	the deferred_gl_code_id for the referenced record
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
LOCALE_DETAILS	SERVICES	VM_SERVICE_LOCALE_DETAILS
PRODUCT_FIELD_ASSIGNMENTS	SERVICES	VM_SERVICE_PFA_VALUES
PRODUCT_FIELD_ASSIGNMENTS	SERVICES	VM_SERVICE_PFA_VALUE_LOCALE_DETAILS
PRODUCT_FIELD_ASSIGNMENTS	SERVICES	VM_SERVICE_PRODUCT_FIELD_ASSIGNMENTS

► Service Credits

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
CREDIT_NO	NUMBER	the credit_no for the referenced record
ACCOUNT_NO	NUMBER	The account number related to the customer referenced
USERID	TEXT	The userid for login related to the customer referenced
AMOUNT	NUMBER	The amount of the referenced transaction value in the asociated currency
AMOUNT_REVERSED_FOR_ANNIVERSARY	NUMBER	the amount_reversed_for_anniversary for the referenced record
CANCEL_USER	TEXT	the cancel_user for the referenced record
CANCELLED_TSTAMP	TIMESTAMP_NTZ	The original source system cancelled timestamp for the referenced data
COMMENTS	TEXT	The detailed comments related to the referenced data
CREATE_USER	TEXT	the create_user for the referenced record
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data
CREDIT_REASON_NO	NUMBER	the credit_reason_no for the referenced record
CREDIT_SERVICE_NO	NUMBER	the credit_service_no for the referenced record
CREDIT_CLIENT_SERVICE_ID	TEXT	the credit_client_service_id for the referenced record
CURRENCY_CODE	TEXT	the currency_code for the referenced record
EXPIRY_MONTHS	NUMBER	the expiry_months for the referenced record
EXPIRY_TSTAMP	TIMESTAMP_NTZ	the expiry_tstamp for the referenced record
IS_ORDER_BASED	BOOLEAN	A True or False indicator showing if the record is the order based
MASTER_PLAN_INSTANCE_NO	NUMBER	The Aria facing unique identifier for an master plan instance
MASTER_CLIENT_PLAN_INSTANCE_NO	TEXT	the master_client_plan_instance_no for the referenced record
ORIGINATING_COUPON	TEXT	the originating_coupon for the referenced record
ORIGINATING_INVOICE_LINE_TRANSACTION_NO	NUMBER	the originating_invoice_line_transaction_no for the referenced record
ORIGINATING_RECURRING_CREDIT	NUMBER	the originating_recurring_credit for the referenced record
REMAINING_DAYS_WHEN_PRORATED	NUMBER	the remaining_days_when_prorated for the referenced record
SERVICE_CREDIT_ELIGIBILITIES	VARIANT	An embedded one to many JSON subrecord related to service_credit_eligibilities
TOTAL_DAYS_WHEN_PRORATED	NUMBER	the total_days_when_prorated for the referenced record
UNCONSUMED_AMOUNT	NUMBER	the unconsumed_amount for the referenced record
USE_CHARGE_SERVICE	BOOLEAN	the use_charge_service for the referenced record
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
SERVICE_CREDIT_ELIGIBILITIES	SERVICE_CREDITS	VM_SC_SERVICE_CREDIT_ELIGIBILITIES

► Statements

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
STATEMENT_NO	NUMBER	the statement_no for the referenced 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
INVOICE_NO	NUMBER	The aria facing unique identifier for an invoice
BILLING_GROUP_NO	NUMBER	The designated billing group number for the referenced data
PAYMENT_METHOD_NO	NUMBER	the payment_method_no for the referenced record
MASTER_PLAN_INSTANCES	VARIANT	An embedded one to many JSON subrecord related to master plan instances
SEQ_STATEMENT_ID	TEXT	the seq_statement_id for the referenced record
STATEMENT_CONTACT_NO	NUMBER	the statement_contact_no for the referenced record
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data
DUE_DATE	DATE	the due_date for the referenced record
DUE_DATE_PLUS_GRACE_PERIOD	DATE	the due_date_plus_grace_period for the referenced record
SENT_TSTAMP	TIMESTAMP_NTZ	the sent_tstamp for the referenced record
RESENT_TSTAMP	TIMESTAMP_NTZ	the resent_tstamp for the referenced record
STATUS_NO	NUMBER	The clients status was updated at the timestamp for the customer referenced
IS_REBILL	BOOLEAN	A True or False indicator showing if the record is a rebill
CURRENCY_CD	TEXT	The ISO currency code of the referenced data
NEW_CHARGES_AMOUNT	NUMBER	the new_charges_amount for the referenced record
NEW_PAYMENTS_AMOUNT	NUMBER	the new_payments_amount for the referenced record
BALANCE_FORWARD_AMOUNT	NUMBER	the balance_forward_amount for the referenced record
TOTAL_OWED	NUMBER	the total_owed for the referenced record
UNAPPLIED_CREDIT_BALANCE	NUMBER	the unapplied_credit_balance for the referenced record
UNAPPLIED_PAYMENT_BALANCE	NUMBER	the unapplied_payment_balance for the referenced record
TRANSACTIONS	VARIANT	the transactions for the referenced record
MPI_TRANSFERS_IN	VARIANT	An embedded one to many JSON subrecord related to MPI transfers in
MPI_TRANSFERS_OUT	VARIANT	An embedded one to many JSON subrecord related to MPI transfers out
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
MASTER_PLAN_INSTANCES	STATEMENTS	VM_STATEMENT_MASTER_PLAN_INSTANCES
MPI_TRANSFERS_IN	STATEMENTS	VM_STATEMENT_MPI_TRANSFERS_IN
MPI_TRANSFERS_OUT	STATEMENTS	VM_STATEMENT_MPI_TRANSFERS_OUT
TRANSACTIONS	STATEMENTS	VM_STATEMENT_TRANSACTIONS

► Surcharges

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
SURCHARGE_NO	NUMBER	the surcharge_no for the referenced record
CLIENT_SURCHARGE_ID	TEXT	the client_surcharge_id for the referenced record
APPLICATION_SCOPE_NO	NUMBER	the application_scope_no for the referenced record
ASSIGNMENT_LEVEL_NO	NUMBER	the assignment_level_no 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
EXTERNAL_DESCRIPTION	TEXT	the external_description for the referenced record
IS_APPLIED_BEFORE_DISCOUNT	BOOLEAN	the is_applied_before_discount for the referenced record
IS_INLINE_SURCHARGE	BOOLEAN	A True or False indicator showing if the record is an inline surcharge
LOCALE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to the records locale
SURCHARGE_NAME	TEXT	the surcharge_name for the referenced record
NONSUBSCRIPTION_OFFERINGS	VARIANT	An embedded one to many JSON subrecord related to nonsubscription offerings
PLAN_SERVICE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to plan_service_details
PLANS	VARIANT	An embedded one to many JSON subrecord related to plans
RATE_CALCULATION_TYPE	TEXT	the rate_calculation_type for the referenced record
SERVICES	VARIANT	An embedded one to many JSON subrecord related to services
SURCHARGE_RATE_SCHEDULES	VARIANT	An embedded one to many JSON subrecord related to surcharge_rate_schedules
TAX_SERVICE_GROUP	TEXT	the tax_service_group for the referenced record
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
LOCALE_DETAILS	SURCHARGES	VM_SURCHARGE_LOCALE_DETAILS
NONSUBSCRIPTION_OFFERINGS	SURCHARGES	VM_SURCHARGE_NONSUBSCRIPTION_OFFERINGS
PLANS	SURCHARGES	VM_SURCHARGE_PLANS
PLAN_SERVICE_DETAILS	SURCHARGES	VM_SPSD_SERVICES
PLAN_SERVICE_DETAILS	SURCHARGES	VM_SURCHARGE_PLAN_SERVICE_DETAILS
SERVICES	SURCHARGES	VM_SURCHARGE_SERVICES
SURCHARGE_RATE_SCHEDULES	SURCHARGES	VM_SURCHARGE_SURCHARGE_RATE_SCHEDULES

► Surcharge Rate Schedules

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
SURCHARGE_NO	NUMBER	the surcharge_no for the referenced record
SCHEDULE_NO	NUMBER	the schedule_no for the referenced record
CURRENCY_CODE	TEXT	the currency_code for the referenced record
INCLUDE_ZERO_IN_RATE_TIER	BOOLEAN	the include_zero_in_rate_tier for the referenced record
IS_DEFAULT_FOR_CURRENCY	BOOLEAN	A True or False indicator showing if the record is the default for currency
LOCALE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to the records locale
MINIMUM_SURCHARGE_TO_APPLY	NUMBER	the minimum_surcharge_to_apply for the referenced record
NAME	TEXT	the name for the referenced record
SURCHARGE_RATE_SCHEDULE_TIERS	VARIANT	An embedded one to many JSON subrecord related to surcharge_rate_schedule_tiers
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
LOCALE_DETAILS	SURCHARGE_RATE_SCHEDULES	VM_SRS_LOCALE_DETAILS
SURCHARGE_RATE_SCHEDULE_TIERS	SURCHARGE_RATE_SCHEDULES	VM_SRS_TIERS
SURCHARGE_RATE_SCHEDULE_TIERS	SURCHARGE_RATE_SCHEDULES	VM_SRS_TIERS_LOCALE_DETAILS

► Transactions

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
TRANSACTION_NO	NUMBER	the transaction_no for the referenced record
TRANSACTION_TYPE_NO	NUMBER	the transaction_type_no for the referenced record
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data
SOURCE_NO	NUMBER	the source_no for the referenced 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
CURRENCY_CD	TEXT	The ISO currency code of the referenced data
AMOUNT	NUMBER	The amount of the referenced transaction value in the asociated currency
APPLIED_AMOUNT	NUMBER	The applied amount of the referenced transaction value in the asociated currency
FULLY_APPLIED_TSTAMP	TIMESTAMP_NTZ	the fully_applied_tstamp for the referenced record
STATEMENT_NO	NUMBER	the statement_no for the referenced record
MASTER_PLAN_INSTANCE_NO	NUMBER	The Aria facing unique identifier for an master plan instance
MASTER_CLIENT_PLAN_INSTANCE_ID	TEXT	The client facing unique identifier for an master plan instance
API_RECEIPT_ID	TEXT	the api_receipt_id for the referenced record
TRANSACTION_SUPP_FIELDS	VARIANT	An embedded one to many JSON subrecord related to transaction_supp_fields
VOIDED_TRANSACTION_NO	NUMBER	the voided_transaction_no for the referenced record
VOIDING_TRANSACTION_NO	NUMBER	the voiding_transaction_no for the referenced record
APPLICATIONS	VARIANT	An embedded one to many JSON subrecord related to applications
PAYMENT_TSTAMP	TIMESTAMP_NTZ	the payment_tstamp for the referenced record
REFERENCE_ID	TEXT	the reference_id for the referenced record
COLLECTION_STATUS_NO	NUMBER	the collection_status_no for the referenced record
PAYMENT_METHOD_NO	NUMBER	the payment_method_no for the referenced record
CLIENT_PAYMENT_METHOD_ID	TEXT	the client_payment_method_id for the referenced record
PROCESSOR_PAYMENT_ID	TEXT	the processor_payment_id for the referenced record
PAYMENT_PROCESSOR_NO	NUMBER	the payment_processor_no for the referenced record
PAYMENT_METHOD_TYPE_NO	NUMBER	the payment_method_type_no for the referenced record
PROCESSOR_STATUS_CD	TEXT	the processor_status_cd for the referenced record
PROCESSOR_STATUS_LABEL	TEXT	the processor_status_label for the referenced record
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
APPLICATIONS	TRANSACTIONS
TRANSACTION_SUPP_FIELDS	TRANSACTIONS	VM_TRANSACTION_SUPP_FIELDS

► Transaction Applications

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
APPLICATION_NO	NUMBER	the application_no for the referenced record
PAYMENT_TRANSACTION_NO	NUMBER	the payment_transaction_no for the referenced record
CHARGE_TRANSACTION_NO	NUMBER	the charge_transaction_no for the referenced record
CREATED_TSTAMP	DATE	The original source system created timestamp for the referenced data
APPLIED_AMOUNT	NUMBER	The applied amount of the referenced transaction value in the asociated currency
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
MASTER_PLAN_INSTANCE_NO	NUMBER	The Aria facing unique identifier for an master plan instance
MASTER_CLIENT_PLAN_INSTANCE_ID	TEXT	The client facing unique identifier for an master plan instance
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

► Usage Records

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
USAGE_RECORD_NO	NUMBER	the usage_record_no for the referenced record
CLIENT_USAGE_RECORD_ID	TEXT	the client_usage_record_id for the referenced 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
AMOUNT	NUMBER	The amount of the referenced transaction value in the asociated currency
BILLABLE_UNITS	NUMBER	the billable_units for the referenced record
CLIENT_EXCLUDE_REASON_CD	NUMBER	the client_exclude_reason_cd for the referenced record
COMMENTS	TEXT	The detailed comments related to the referenced data
EXCLUDE_TSTAMP	TIMESTAMP_NTZ	the exclude_tstamp for the referenced record
EXCLUDE_USER	TEXT	the exclude_user for the referenced record
EXCLUSION_COMMENTS	TEXT	the exclusion_comments for the referenced record
INVOICE	VARIANT	An embedded one to many JSON subrecord related to invoices
IS_EXCLUDED	BOOLEAN	A True or False indicator showing if the record is excluded
PLAN_NO	NUMBER	The Aria facing unique identifier for a plan
CLIENT_PLAN_ID	TEXT	The client facing unique identifier for a plan
PLAN_INSTANCE_NO	NUMBER	The Aria facing unique identifier for a plan_instance
CLIENT_PLAN_INSTANCE_ID	TEXT	The occurrence (instance) of a plan for the referenced data
QUALIFIER_1	TEXT	the qualifier_1 for the referenced record
QUALIFIER_2	TEXT	the qualifier_2 for the referenced record
QUALIFIER_3	TEXT	the qualifier_3 for the referenced record
QUALIFIER_4	TEXT	the qualifier_4 for the referenced record
RATE	NUMBER	the rate for the referenced record
TELCO_FROM	DATE	the telco_from for the referenced record
TELCO_TO	DATE	the telco_to for the referenced record
UNITS	NUMBER	the units for the referenced record
USAGE_RECORD_PARENT	NUMBER	the usage_record_parent for the referenced record
USAGE_TSTAMP	TIMESTAMP_NTZ	the usage_tstamp for the referenced record
USAGE_TYPE_NO	NUMBER	the usage_type_no for the referenced record
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

► Usage Types

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
USAGE_TYPE_NO	NUMBER	the usage_type_no for the referenced record
USAGE_TYPE_CD	TEXT	the usage_type_cd for the referenced record
DESCRIPTION	TEXT	The detailed description related to the referenced data
DISPLAY_NAME	TEXT	the display_name for the referenced record
LOCALE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to the records locale
NAME	TEXT	the name for the referenced record
PRODUCT_FIELD_ASSIGNMENTS	VARIANT	An embedded one to many JSON subrecord related to product field assignments
USAGE_UNIT_TYPE_NO	NUMBER	the usage_unit_type_no for the referenced record
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
LOCALE_DETAILS	USAGE_TYPES	VM_UT_LOCALE_DETAILS
PRODUCT_FIELD_ASSIGNMENTS	USAGE_TYPES	VM_UT_PFA_LOCALE_DETAILS
PRODUCT_FIELD_ASSIGNMENTS	USAGE_TYPES	VM_UT_PFA_VALUES
PRODUCT_FIELD_ASSIGNMENTS	USAGE_TYPES	VM_UT_PRODUCT_FIELD_ASSIGNMENTS