Skip to main content
Aria Knowledge Central

Snowflake Available Objects VM

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

 

  • Was this article helpful?