Skip to main content
Aria Knowledge Central

Snowflake Available Objects

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.

VC

► Accounts

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
ACCOUNT_NO NUMBER The account number related to the customer referenced
USERID TEXT The userid for login related to the customer referenced
CLIENT_ACCOUNT_ID TEXT The clients unique identified for account related to the customer referenced
BALANCE NUMBER The clients balance for the customer referenced data
STATUS_NO NUMBER The clients status number on their account 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_no 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, used to authenticate a user.
SECRET_QUESTION_ANSWER TEXT The secret_question_answer for the referenced record, used to authenticate a user.
IS_TEST_ACCOUNT BOOLEAN Designates the record as a test account.
IS_INVOICE_APPROVAL_REQUIRED BOOLEAN Designates the record as requiring approval for invoices.
CURRENCY_CD TEXT The default_currency_cd for the referenced record.
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 Designates the record as a consumer account.
LOCALE_NO NUMBER The locale_no designating a geographic region for the referenced record.
LEGAL_ENTITY_NO NUMBER The legal_entity_no for the referenced record designating a unique organization
CLIENT_LEGAL_ENTITY_ID TEXT The client_legal_entity_id for the referenced record designating a unique organization
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 defining a unique method for customer communication.
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 designating a valid tax exemption.
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, defining the revenue recognition treatment.
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.

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
ACCOUNT_NO NUMBER The account number related to the customer referenced
USERID TEXT The userid for login related to the customer referenced
CLIENT_ACCOUNT_ID TEXT The clients unique identified for account related to the customer referenced
BALANCE NUMBER The clients balance for the customer referenced data
STATUS_NO NUMBER The clients status number on their account 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_no 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, used to authenticate a user.
SECRET_QUESTION_ANSWER TEXT The secret_question_answer for the referenced record, used to authenticate a user.
IS_TEST_ACCOUNT BOOLEAN Designates the record as a test account.
IS_INVOICE_APPROVAL_REQUIRED BOOLEAN Designates the record as requiring approval for invoices.
CURRENCY_CD TEXT The default_currency_cd for the referenced record.
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 Designates the record as a consumer account.
LOCALE_NO NUMBER The locale_no designating a geographic region for the referenced record.
LEGAL_ENTITY_NO NUMBER The legal_entity_no for the referenced record designating a unique organization
CLIENT_LEGAL_ENTITY_ID TEXT The client_legal_entity_id for the referenced record designating a unique organization
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 defining a unique method for customer communication.
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 designating a valid tax exemption.
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, defining the revenue recognition treatment.
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.
► Account Fields

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
FIELD_NAME TEXT The field_name for the referenced record.
FIELD_NO NUMBER The field_no for the referenced record.
FIELD_ORDER NUMBER The field_order for the referenced record.
DESCRIPTION TEXT The description of the field for the referenced record.
INPUT_TYPE_CD TEXT The input type code.
IS_REQUIRED BOOLEAN Is the account field required for data entry?
IS_RESTRICTED_TO_ALLOWED_VALUES BOOLEAN Is data entry restricted to allowed values
MAXIMUM_SELECTIONS NUMBER The maximum number of selections.
MINIMUM_SELECTIONS NUMBER The minimum number of selections.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
UPDATED_TSTAMP TIMESTAMP_NTZ The timestamp of the update milestone.

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
ACCOUNT_NO NUMBER The account number related to the customer referenced
FIELD_NAME TEXT The field_name for the referenced record.
FIELD_NO NUMBER The field_no for the referenced record.
► Account Coupon Assignment

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
ACCOUNT_NO NUMBER The account number related to the customer referenced
USERID TEXT The userid for login related to the customer referenced
CLIENT_ACCOUNT_ID TEXT The clients unique identified for account related to the customer referenced
COUPON_CODE TEXT The coupon_code for the referenced record.
CREATED_TSTAMP TIMESTAMP_NTZ The created timestamp for the referenced data.
CANCELLED_TSTAMP TIMESTAMP_NTZ The cancelled timestamp for the referenced data.
► Account Discount Rule Assignments

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
ASSIGNMENT_NO NUMBER The unique identifier for a assignment number.
ACCOUNT_NO NUMBER The account number related to the customer referenced
DISCOUNT_RULE_NO NUMBER The discount_rule_no for the referenced record.
BUNDLE_NO NUMBER The unique identifier for a bundle number.
SOURCE_COUPON_CODE TEXT The source_coupon_code for the referenced record.
OVERRIDE_MAX_APPLICATIONS NUMBER Override the maximum applications.
OVERRIDE_MAX_APPLICABLE_MONTHS NUMBER Override the maximum application months.
TOTAL_APPLICATIONS NUMBER The total number of applications.
ASSIGNED_TSTAMP TIMESTAMP_NTZ The timestamp of the assigned milestone.
UNASSIGNED_TSTAMP TIMESTAMP_NTZ The timestamp of the unassigned milestone.
EXPIRATION_DATE DATE The date of the expiration milestone.
► Billing Groups

FIeld

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
ACCOUNT_NO NUMBER The account number related to the customer referenced
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
NAME TEXT The billing groups name
DESCRIPTION TEXT A verbose description of the billing group.
STATUS_NO NUMBER The clients status number on their account for the customer referenced
NOTIFY_METHOD_NO NUMBER The unique identifier for a notify method number.
NOTIFICATION_TEMPLATE_GROUP_NO NUMBER The unique identifier for a notification template group number.
PRIMARY_PAYMENT_METHOD_NO NUMBER The unique identifier for a primary payment method number.
BACKUP_PAYMENT_METHOD_NO NUMBER The unique identifier for a backup payment method number.
STATEMENT_CONTACT_NO NUMBER The unique identifier for a statement contact number.
PAYMENT_TERM_NO NUMBER The payment_term_no for the referenced record.
CREDIT_NOTE_TEMPLATE_NO NUMBER The unique identifier for a credit note template number.
EAN_GLN_NUM TEXT The EAN or GLN number.
EAN_GLN_REQUISITION_NUM TEXT The EAN or GLN requisition number.
STATEMENT_TEMPLATE_NO NUMBER The unique identifier for a statement template number.
CREDIT_MEMO_TEMPLATE_NO NUMBER The unique identifier for a credit memo template number.
REBILL_TEMPLATE_NO NUMBER The unique identifier for a rebill template number.
► Chart of Accounts

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
CHART_OF_ACCOUNTS_NO NUMBER The unique identifier for a chart of accounts number.
CLIENT_CHART_OF_ACCOUNTS_ID TEXT The unique identifier for a client chart of accounts id.
DESCRIPTION TEXT A verbose description of the chart of accounts.
► Comments

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
COMMENT_NO NUMBER The unique identifier for a comment number.
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
APPLICATION_ID TEXT The unique identifier for a application.
APPLICATION_TSTAMP_TEXT TEXT A text string containing the application timestamp.
AUTHOR TEXT The creator of the comment.
COMMENT TEXT The verbose notes related to the account.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
► Contacts

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
ACCOUNT_NO NUMBER The account number related to the customer referenced
CONTACT_NO NUMBER The unique identifier for a contact number.
FIRST_NAME TEXT The contacts first name.
MIDDLE_INITIAL TEXT The contacts middle initial.
LAST_NAME TEXT The contacts surname or last name.
COMPANY_NAME TEXT The company name where applicable
BIRTHDATE DATE The contacts date of birth.
EMAIL TEXT The contacts email address.
STREET TEXT The contacts street address.
CITY TEXT The contacts city.
STATE_PROV TEXT The contacts state or province.
LOCALITY TEXT The contacts locality.
POSTAL_CODE TEXT The contacts postal code.
COUNTRY_CD TEXT The contacts country code.
PHONE TEXT The contacts phone number.
PHONE_EXT TEXT The contacts phone extension where applicable.
CELL_PHONE TEXT The contacts cellular phone number.
WORK_PHONE TEXT The contacts work phone number.
WORK_PHONE_EXT TEXT The contacts work phone extension where applicable.
FAX TEXT The contacts fax phone number.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
► Contracts

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
CONTRACT_NO NUMBER The unique identifier for a contract number.
CLIENT_CONTRACT_ID TEXT The unique identifier for a client contract id.
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
STATUS_NO NUMBER The clients status number on their account for the customer referenced
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.
START_DATE DATE The contract start date.
END_DATE DATE The contract end date.
CREATE_COMMENTS TEXT A verbose explanation of details related to the created referenced data.
UPDATE_COMMENTS TEXT A verbose explanation of details related to the updated referenced data.
END_ACTION_NO NUMBER The unique identifier for a end action number.
CONTRACT_MONTHS NUMBER The number of months duration for the contract terms.
EARLY_CANCEL_FEE NUMBER The contract cancellation fee where applicable.
SCOPE_NO NUMBER The unique identifier for a scope number.
► Coupons

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
COUPON_CODE TEXT The coupon_code for the referenced record.
APPLICATION_SCOPE_NO NUMBER The unique identifier for an application scope number
DESCRIPTION TEXT A verbose description of the coupon.
DISCOUNT_BUNDLE_NO NUMBER The unique identifier for a discount bundle number.
CLIENT_DISCOUNT_BUNDLE_ID TEXT The unique identifier for a client discount bundle number.
EXPIRE_DATE DATE The coupons expiration date.
IS_ACTIVE BOOLEAN Is the refernced data active?
MAXIMUM_USES NUMBER The maximum number of uses for the coupon.
START_DATE DATE The coupon start date.
TOTAL_USES NUMBER The total uses allowed for the coupon.
► Credit Memos

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
CREDIT_MEMO_NO NUMBER The unique identifier for a credit memo number.
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 currency amount.
COMMENTS TEXT A verbose explanation of details related to the referenced data.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
CREDIT_REASON_NO NUMBER The unique identifier for a credit reason number.
CREDIT_REASON_TYPE_NO NUMBER The unique identifier for a credit reason type.
CREDIT_REF_TYPE_NO NUMBER The unique identifier for a credit ref type number.
CURRENCY_CD TEXT The default_currency_cd for the referenced record.
CUSTOMER_NOTE TEXT The verbose customer note related to the credit memo record.
INVOICE_NO NUMBER The Aria facing unique identifier for an invoice.
► Discount Rules

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
DISCOUNT_RULE_NO NUMBER The discount_rule_no for the referenced record.
CLIENT_DISCOUNT_RULE_ID TEXT The unique identifier for a client discount rule id.
NAME TEXT The discount rule name.
DESCRIPTION TEXT A verbose description of the discount_rules.
EXTERNAL_DESCRIPTION TEXT A verbose external description of the discount_rules.
DISCOUNT_TYPE_CD TEXT The unique identifier for a discount type code.
FIXED_AMOUNT NUMBER The fixed currency amount.
PERCENT_AMOUNT NUMBER The percent currency amount.
CURRENCY_CD TEXT The default_currency_cd for the referenced record.
APPLICABLE_DURATION_TYPE_CD TEXT The unique identifier for a applicable duration type code.
MAXIMUM_APPLICABLE_DURATION NUMBER The maximum applicable duration of the discount rule referenced.
INVOICE_APPLICATION_SCOPE_CD TEXT The unique identifier for a invoice applicable scope code.
IS_INLINE_DISCOUNT BOOLEAN Is the record and online discount?
DISCOUNT_BEHAVIOR_CD TEXT The unique identifier for a discount behavior code.
DISCOUNT_SERVICE_NO NUMBER The discount_service_no for the referenced record.
DISCOUNT_SERVICE_CLIENT_ID TEXT The discount_service_client_id for the referenced record.
DISCOUNT_RULE_SCOPE_NO NUMBER The unique identifier for a discount rule scope number.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
REMAINDER_DISCOUNT_RULE_IND BOOLEAN The remainder discount rule indicator.
► Dunning Groups

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
DUNNING_GROUP_NO NUMBER The unique identifier for a dunning group number.
CLIENT_DUNNING_GROUP_ID TEXT The unique identifier for a client dunning group id.
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
DESCRIPTION TEXT A verbose description of the dunning groups.
DUNNING_PROCESS_NO NUMBER The uniqiue identifier for a dunning process.
CLIENT_DUNNING_PROCESS_ID TEXT The uniqiue identifier for a client dunning process id.
NAME TEXT The dunning group name.
DUNNING_GROUP_STATUS_NO NUMBER The unique identifier for the dunning group status number.
► Dunning Process

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
DUNNING_PROCESS_NO NUMBER The uniqiue identifier for a dunning process.
CLIENT_DUNNING_PROCESS_ID TEXT The uniqiue identifier for a client dunning process id.
NAME TEXT The dunning process name.
DESCRIPTION TEXT A verbose description of the dunning process.
COMPLETION_NOTIFICATION_TEMPLATE_NO NUMBER The unique identifier for a completion notification template number.
IS_DEFAULT BOOLEAN Is the record the default dunning process?
► Invoices

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
ACCOUNT_NO NUMBER The account number related to the customer referenced
USERID TEXT The userid for login related to the customer referenced
INVOICE_NO NUMBER The Aria facing unique identifier for an invoice.
STATUS_NO NUMBER The clients status number on their account for the customer referenced
BILLING_GROUP_NO NUMBER The designated billing group number for the referenced data.
STATEMENT_NO NUMBER The statement_no for the referenced record.
ORIGINAL_INVOICE_NO NUMBER The Aria facing unique identifier for an original invoice.
REBILL_INVOICE_NO NUMBER The Aria facing unique identifier for an rebill invoice.
REBILL_REASON_NO NUMBER The unique identifier for a rebill reason number.
TAXATION_ADDRESS_CONTACT_NO NUMBER The unique identifier for a taxation address contact number.
RECURRING_BILL_FROM DATE The recurring billing from date.
RECURRING_BILL_THROUGH DATE The recurring billing through date.
USAGE_FROM DATE The usage from date.
USAGE_THROUGH DATE The usage through date.
CURRENCY_CD TEXT The default_currency_cd for the referenced record.
AMOUNT NUMBER The currency amount.
INVOICE_BALANCE_FORWARD NUMBER The invoice forwarded balance currency amount.
TOTAL_DUE NUMBER The total currency amount due.
BILLED_TSTAMP TIMESTAMP_NTZ The timestamp of the billed milestone.
PAID_TSTAMP TIMESTAMP_NTZ The timestamp of the paid milestone.
CUSTOM_STATUS_LABEL TEXT A verbose custom status label of the invoices.
CUSTOM_STATUS_DESCRIPTION TEXT A verbose custom status description of the invoices.
INVOICE_COMMENTS TEXT A verbose explanation of details related to the invoice.
ADDITIONAL_COMMENTS TEXT A verbose explanation of additional comments.
CLIENT_NOTES TEXT A verbose explanation of client comments.
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.
INVOICE_USAGE_STATUS_CD TEXT The invoice usage status code.
INVOICE_TYPE_CD TEXT The invoice usage type code.
► Invoice Reversals

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
REVERSAL_NO NUMBER The unique identifier for the reversal number.
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 currency amount.
COMMENTS TEXT A verbose explanation of details related to the referenced data.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
CURRENCY_CD TEXT The unique identifier for a currency code.
► Non-Subscription Offerings

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
NONSUBSCRIPTION_OFFERING_NO NUMBER The nonsubscription_offering_no for the referenced record.
AUTO_CREATED_CREDIT_COMMENTS TEXT A automatically created explanation of details related to the referenced data.
AUTO_CREATED_CREDIT_SERVICE_NO NUMBER The automatical created credit service_no for the referenced record.
AUTO_CREATED_CREDIT_CLIENT_SERVICE_ID TEXT The unique identifier for the auto created credit client service id.
CLIENT_NONSUBSCRIPTION_OFFERING_ID TEXT The client nonsubscription offering id.
CLIENT_SKU TEXT The client SKU for the discount rule non subscription offering.
DESCRIPTION TEXT A verbose description of the non subscription offerings.
HAS_PURCHASE_RESTRICTION BOOLEAN Does the nonsubscription offering have a purchase restriction?
IS_ACTIVE BOOLEAN Is the referenced data active?
IS_AUTO_CREATE_CREDIT BOOLEAN Is the referenced data and auto created credit?
NAME TEXT The nonsubscription offering  name.
QUEUE_ACTIVATION_STATUS_NO NUMBER The unique identifier for a queue activation status number.
QUEUE_DATE DATE The date the record was queued.
CLIENT_SERVICE_ID TEXT The unique identifier for the client service id.
SERVICE_NO NUMBER The service_no for the referenced record.
STOCK_LEVEL NUMBER The stock level.
SUBUNIT_LABEL TEXT The subunit label.
SUBUNIT_QUANTITY NUMBER The subunit quantity.
► Non-Subscription Rate Schedules

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
SCHEDULE_NO NUMBER The schedule_no for the referenced record.
CLIENT_RATE_SCHEDULE_ID TEXT The client_rate_schedule_id for the referenced record.
NAME TEXT The nonsubscription offering rate schedule name.
CURRENCY_CD TEXT The default_currency_cd for the referenced record.
IS_TAX_INCLUSIVE BOOLEAN Is the tax line inclusive?
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
IS_DEFAULT_FOR_CURRENCY BOOLEAN Is the nonsubscription rate schedule the default for the currency
► Orders

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
ORDER_NO NUMBER The unique identifier for an order.
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 currency amount.
CLIENT_ORDER_ID TEXT The client order id.
COMMENTS TEXT A verbose explanation of details related to the referenced data.
CREATED_RECEIPT_ID TEXT The created receipt od.
CURRENCY_CD TEXT The default_currency_cd for the referenced record.
FULFILL_DATE DATE The date of the fulfillment milestone.
INVOICE_NO NUMBER The Aria facing unique identifier for an invoice.
CLIENT_PLAN_INSTANCE_ID TEXT The unique identifier for a client plan instance id.
PLAN_INSTANCE_NO NUMBER The plan_instance_no for the referenced record.
PURCHASE_ORDER_NUMBER TEXT The purchase order number.
STATEMENT_MESSAGE TEXT The message for the consumer on the statement.
STATUS_NO NUMBER The clients status number on their account for the customer referenced
UPDATED_RECEIPT_ID TEXT The updated receipt id.
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.
► Order Lines

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
ORDER_NO NUMBER The unique identifier for an order.
LINE_NO NUMBER The unique identifier for an order line.
NONSUBSCRIPTION_OFFERING_NO NUMBER The nonsubscription_offering_no for the referenced record.
CLIENT_NONSUBSCRIPTION_OFFERING_ID TEXT The client_nonsubscription_offering_id for the referenced record.
UNITS NUMBER The quantity of units for the referenced data.
UNIT_AMOUNT NUMBER The currency unit amount.
LINE_AMOUNT NUMBER The currency line amount.
LABEL TEXT The label o nthe order line.
LONG_DESCRIPTION TEXT A verbose long description of the order lines.
ALT_LABEL TEXT The alternatiev label on the order line.
LINE_COMMENTS TEXT A verbose explanation of details related to the referenced data.
SERVICE_LOCATION_NO NUMBER The unique identifier for the service location.
DESTINATION_CONTACT_NO NUMBER The unique identifier for a destination contact number.
IS_CUSTOM_RATED BOOLEAN Is the record custom rated?
► Payment Methods

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
ACCOUNT_NO NUMBER The account number related to the customer referenced
USERID TEXT The userid for login related to the customer referenced
CLIENT_ACCOUNT_ID TEXT The clients unique identified for account related to the customer referenced
PAYMENT_METHOD_NO NUMBER The unique identifier for a payment method number.
CLIENT_PAYMENT_METHOD_ID TEXT The unique identifier for a client payment method id.
NAME TEXT The payment methods name.
DESCRIPTION TEXT A verbose description of the payment method.
PAYMENT_METHOD_TYPE_NO NUMBER The unique identifier for a payment method type number.
PAYMENT_METHOD_STATUS_NO NUMBER The unique identifier for a payment method status number.
SUFFIX TEXT The suffix.
CC_TYPE TEXT The credit card type.
CC_EXPIRE_MM NUMBER The numeric month (MM) of expiration.
CC_EXPIRE_YYYY NUMBER The numeric year (YYYY) of expiration.
BILL_AGREEMENT_ID TEXT The billing agreement id.
BANK_ROUTING_NUM TEXT The bank routing number.
BILL_ADDRESS_CONTACT_NO NUMBER The unique identifier for a billing address contact number.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
UPDATED_TSTAMP TIMESTAMP_NTZ The original source system updated timestamp for the referenced data.
IS_PREPAID BOOLEAN Is the payment method prepaid?
IS_RELOADABLE BOOLEAN Is the payment method reloadable?
PREPAID_BALANCE NUMBER The currency amount of the prepaid balance.
PREPAID_CARD_TYPE TEXT The type of the prepaid card.
AFFLUENCE_TYPE TEXT The affluence type.
CC_ISSUING_COUNTRY TEXT The issuing country of the credit card.
CARD_PRODUCT_TYPE TEXT The card product type.
IS_DURBIN_REGULATED BOOLEAN Is the payment method durbin regulated?
IS_SIGNATURE_DEBIT BOOLEAN Is the payment method signature debit?
BANK_SWIFT_CD TEXT The swift system bank code.
BANK_COUNTRY_CD TEXT The country code of the bank referenced.
MANDATE_ID TEXT The mandate id.
BANK_ID_CD TEXT The bank id code.
BANK_BRANCH_CD TEXT The bank branch code.
MANDATE_AUTH_DATE DATE The date the mandate authorization starts.
CREATED_RECEIPT_ID TEXT The created_receipt_id for the referenced record.
► Payment Terms

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
PAYMENT_TERM_NO NUMBER The payment_term_no for the referenced record.
CLIENT_PAYMENT_TERM_ID TEXT The unique identifier for a client payment term id.
NAME TEXT The payment terms name.
DESCRIPTION TEXT A verbose description of the payment term.
IS_EAN_OR_GLN BOOLEAN Are the payment terms EAN or GLN?
ACCOUNT_GROUP_SCOPE_NO NUMBER The unique identifier for a account group scope number.
ACCOUNT_GROUP_NO NUMBER The unique identifier for a account group number.
CLIENT_ACCOUNT_GROUP_ID TEXT The unique identifier for a client account group id.
DAYS_UNTIL_DUE NUMBER The number of days until the payment is due.
DAYS_UNTIL_DUE_METHOD_NO NUMBER The unique identifier for a days untile due method number.
BILL_LAG_DAYS NUMBER The billing lag in number of days.
DISCOUNT_PERCENT NUMBER The discount percentage rate.
DISCOUNT_PERIOD NUMBER The discount period.
SURCHARGE_NO NUMBER The surcharge_no for the referenced record.
CLIENT_SURCHARGE_ID TEXT The client_surcharge_no for the referenced record.
AUTO_BILL_ORDERS BOOLEAN Should orders be auto billed?
PAYMENT_REMINDER_NO NUMBER The unique identifier for a payment reminder number.
PAYMENT_REMINDER_CONFIGURATIONS VARIANT The payment reminder configuration.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
► Pending Invoice Lines

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
INVOICE_NO NUMBER The Aria facing unique identifier for an invoice.
LINE_NO NUMBER The unique identifier for an invoice line.
ORDER_NO NUMBER The unique identifier for an order.
ORDER_LINE_NO NUMBER The unique identifier for an order line.
SURCHARGE_NO NUMBER The surcharge_no for the referenced record.
ADVANCE_BILLING_PERIOD_TOTAL_DAYS NUMBER The advance billing period total days.
BASE_PLAN_UNITS NUMBER The quantity of base plan units for the referenced data.
COMMENTS TEXT A verbose explanation of details related to the referenced data.
CREDIT_COUPON_CODE TEXT The credit coupon code.
CREDIT_REASON_NO NUMBER The unique identifier for a credit reason number.
END_DATE DATE The end date.
IS_TAX_RELATED BOOLEAN Is the record tax related?
NONSUBSCRIPTION_OFFERING_RATE_SCHEDULE_NO NUMBER The nonsubscription_offering_rate_schedule for the referenced record.
NONSUBSCRIPTION_OFFERING_CLIENT_RATE_SCHEDULE_ID TEXT The nonsubscription_offering_client_rate_schedule for the referenced record.
NONSUBSCRIPTION_OFFERING_RATE_SCHEDULE_TIER NUMBER The nonsubscription offering rate schedule tier.
PLAN_NO NUMBER The plan_no for the referenced record
CLIENT_PLAN_ID TEXT The unique identifier for a client plan record.
PLAN_INSTANCE_NO NUMBER The plan_instance_no for the referenced record.
CLIENT_PLAN_INSTANCE_ID TEXT The unique identifier for a client plan instance id.
PLAN_RATE_SCHEDULE_NO NUMBER The plan_rate_schedule_no for the referenced record.
CLIENT_PLAN_RATE_SCHEDULE_ID TEXT The client_plan_rate_schedule_id for the referenced record.
PLAN_RATE_SCHEDULE_SERVICE_TIER NUMBER The plan_rate_schedule_service_tier for the referenced record.
PRORATION_DESCRIPTION TEXT A verbose proration description of the pending invoice lines.
PRORATION_FACTOR NUMBER The proration factor.
PRORATION_OPERATION_TYPE_NO NUMBER The unique identifier for a proration operation type number.
PRORATION_REMAINING_DAYS NUMBER The days remaining for proration.
PURCHASE_ORDER_NUMBER TEXT The aria facing unique identifier for a purchase order.
RATE NUMBER The rate for the referenced data.
SERVICE_NO NUMBER The service_no for the referenced record.
CLIENT_SERVICE_ID TEXT The unique identifier for the client service id.
SERVICE_CREDIT_NO NUMBER The unique identifier for a service credit number.
SERVICE_CREDIT_SOURCE_TRANSACTION_NO NUMBER The unique identifier for a service credit source transaction.
START_DATE DATE The start date.
SURCHARGE_RATE_SCHEDULE_NO NUMBER The surcharge_rate_schedule_no for the referenced record.
SURCHARGE_RATE_SCHEDULE_TIER NUMBER The surcharge_rate_schedule_tier for the referenced record.
UNITS NUMBER The quantity of units for the referenced data.
USAGE_TYPE_NO NUMBER The unique identifier for a usage_type record.
USAGE_TYPE_CD TEXT The unique code for a usage_type record.
IS_CUSTOM_RATED BOOLEAN Is the record customer rated?
► Plans

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
PLAN_NO NUMBER The plan_no for the referenced record
CLIENT_PLAN_ID TEXT The unique identifier for a client plan record.
NAME TEXT The plan name.
DESCRIPTION TEXT A verbose description of the plan.
IS_ACTIVE BOOLEAN Is the refernced data active?
IS_SUPPLEMENTAL_PLAN BOOLEAN Is the referenced data a supplemental plan?
IS_TEMPLATE BOOLEAN Is the referenced data a template?
PRORATION_INVOICE_TIMING_CD NUMBER The proration invoice timing code.
STATEMENT_TEMPLATE_NO NUMBER The unique identifier for a statement template number.
NOTIFICATION_TEMPLATE_GROUP_NO NUMBER The unique identifier for a notification template group number.
CREDIT_NOTE_TEMPLATE_NO NUMBER The unique identifier for a credit note template number.
CREDIT_MEMO_TEMPLATE_NO NUMBER The unique identifier for a credit memo template number.
REBILL_TEMPLATE_NO NUMBER The unique identifier for a rebill template number.
HAS_PLAN_CANCELLATION_FEE BOOLEAN Does the plan have a cancellation fee?
CANCELLATION_MINIMUM_MONTHS NUMBER The minimum number of months before cancellation is allowed.
NONSUBSCRIPTION_OFFERING_BUNDLE_TYPE_CD TEXT The nonsubscription offering bundle type code.
AVAILABLE_NONSUBSCRIPTION_OFFERING_SCOPE_IND NUMBER The nonsubscription offering bundle scope indicator code.
DEFAULT_CURRENCY_CD TEXT The default_currency_cd for the referenced record.
INITIAL_FREE_PERIOD_QUANTITY NUMBER The qunatity of the initial free period.
INITIAL_FREE_PERIOD_TYPE_NO NUMBER The unique identifier for a initial free period type number.
INITIAL_PLAN_INSTANCE_STATUS_NO NUMBER The unique identifier for a initial plan instance status number.
PLAN_INSTANCE_STATUS_ROLLOVER_PERIOD_QUANTITY NUMBER The qunatity of the plan instance rollover period.
PLAN_INSTANCE_STATUS_ROLLOVER_PERIOD_TYPE_NO NUMBER The unique identifier for a plan instance status rollover period type number.
ROLLOVER_PLAN_INSTANCE_STATUS_NO NUMBER The unique identifier for a rollover plan instance status number.
ROLLOVER_PLAN_NO NUMBER The rollover_plan_no for the referenced record
ROLLOVER_PLAN_PERIOD_QUANTITY NUMBER The quantity of the rollover plan period.
ROLLOVER_PLAN_PERIOD_TYPE_NO NUMBER The unique identifier for a rollover plan period type number.
CONTRACT_COMPLETION_ROLLOVER_PLAN_NO NUMBER The contract_completion_rollover_plan_no for the referenced record
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
► Plan Instances

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
PLAN_INSTANCE_NO NUMBER The plan_instance_no for the referenced record.
CLIENT_PLAN_INSTANCE_ID TEXT The unique identifier for a client plan instance id.
MASTER_PLAN_INSTANCE_NO NUMBER The master_plan_instance_no for the referenced record.
PARENT_PLAN_INSTANCE_NO NUMBER The parent_plan_instance_no for the referenced record.
ACCOUNT_NO NUMBER The account number related to the customer referenced
PLAN_NO NUMBER The plan_no for the referenced record
PLAN_UNITS NUMBER The quantity of plan units for the referenced data.
BALANCE NUMBER The clients balance for the customer referenced data
LAST_BILL_DATE DATE The date the last bill.
NEXT_BILL_DATE DATE The date the next bill.
LAST_BILL_THROUGH_DATE DATE The date the last bill through bill.
LAST_ARREARS_BILL_THROUGH_DATE DATE The date the last arrears bill through.
LAST_ARREARS_RECURRING_BILL_THROUGH_DATE DATE The date the last arrears recurring bill through.
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 unique identifier for a status number.
STATUS_TSTAMP TIMESTAMP_NTZ The timestamp of the status update milestone.
TERMINATED_TSTAMP TIMESTAMP_NTZ The timestamp of the terminated milestone.
PROVISIONED_TSTAMP TIMESTAMP_NTZ The timestamp of the provisioned milestone.
RATE_SCHEDULE_NO NUMBER The rate_schedule_no for the referenced record.
CREATED_RECEIPT_ID TEXT The created_receipt_id for the referenced record.
DESCRIPTION TEXT A verbose description of the plan instances.
PURCHASE_ORDER_NUMBER TEXT The purchase order number.
IS_USAGE_POOLING_ENABLED BOOLEAN Is usage pooling enabled?
USAGE_POOLING_COUNTER NUMBER A counter for usage pooling
PROMOTION_CODE TEXT The promotional code.
BILL_LAG_DAYS NUMBER The number of billing lag days.
BILL_DAY NUMBER The date billing is processed.
DUNNING_STATE NUMBER The dunning state of the record.
DUNNING_STEP NUMBER The dunning step.
DUNNING_DEGRADE_DATE DATE The date of the dunning degrade milestone.
USAGE_ACCUMULATION_RESET_MONTHS NUMBER The usage accumulation reset months.
USAGE_ACCUMULATION_RESET_MONTHS_RENEWAL_OPTION NUMBER The usage accumulation reset months renewal option.
USAGE_ACCUMULATION_RESET_COUNTER NUMBER The usage accumulation reset counter.
BILLING_GROUP_NO NUMBER The designated billing group number for the referenced data.
DUNNING_GROUP_NO NUMBER The unique identifier for a dunning group number.
RESPONSIBILITY_LEVEL_NO NUMBER The unique identifier for a responsibility level number.
RESPONSIBLE_PLAN_INSTANCE_NO NUMBER The responsible_plan_instance_no for the referenced record.
► Plan Groups

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
PLAN_GROUP_NO NUMBER The unique identifier for a plan group number.
CLIENT_PLAN_GROUP_ID TEXT The unique identifier for a client plan group id.
NAME TEXT The plan group name.
DESCRIPTION TEXT A verbose description of the plan groups.
USAGE_NO NUMBER The unique identifier for a usage number.
► Plan Relationships

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
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 unique identifier for a client parent plan record.
CHILD_CLIENT_PLAN_ID TEXT The unique identifier for a client child plan record.
HAS_ACCOUNT_LIMITS BOOLEAN Are there account limits in effect?
IS_DEFAULT BOOLEAN Is the plan relationship default?
IS_REQUIRED BOOLEAN Is the plan relationship required?
MAXIMUM_UNITS NUMBER The maximum quantity of units for the referenced data.
MINIMUM_UNITS NUMBER The minimum quantity of units for the referenced data.
► Plan Rate Schedules

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
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 plan rate schedules start date for availability.
AVAILABLE_TO_DATE DATE The plan rate schedules end date for availability.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
CURRENCY_CD TEXT The default_currency_cd for the referenced record.
FOLLOWUP_DEFAULT_RATE_SCHEDULE_NO NUMBER The followup_default_rate_schedule_no for the referenced record.
IS_DEFAULT_FOR_CURRENCY BOOLEAN Is the plan rate schedule the default?
NAME TEXT The plan rate schedule name.
QUEUED_RATE_CHANGE_DATE DATE The date for the queued rate change.
RECURRING_BILLING_INTERVAL_VALUE NUMBER The unique identifier for a recurring billing interval value.
RECURRING_BILLING_INTERVAL_TYPE_NO NUMBER The unique identifier for a recurring billing interval type number.
USAGE_BILLING_INTERVAL_VALUE NUMBER The unique identifier for a usage billing interval value.
USAGE_BILLING_INTERVAL_TYPE_NO NUMBER The unique identifier for a usage billing interval type number.
► Plan Unit Instances

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
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.
UPDATED_TSTAMP TIMESTAMP_NTZ The original source system updated timestamp for the referenced data.
PLAN_INSTANCE_NO NUMBER The parent_plan_instance_no for the referenced record.
CLIENT_PLAN_INSTANCE_ID TEXT The unique identifier for a client plan instance id.
STATUS_NO NUMBER The clients status number on their account for the customer referenced
► Plan Instance Coupon Assignments

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
PLAN_INSTANCE_NO NUMBER The plan_instance_no for the referenced record.
COUPON_CODE TEXT The unique identifier for a coupon code.
CLIENT_PLAN_INSTANCE_ID TEXT The unique identifier for a client plan instance id.
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 cancelled timestamp for the referenced data.
► Plan Instance Discount Rule Assignments

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
ASSIGNMENT_NO NUMBER The unique identifier for a assignment number.
DISCOUNT_RULE_NO NUMBER The discount_rule_no for the referenced record.
BUNDLE_NO NUMBER The unique identifier for a bundle number.
PLAN_INSTANCE_NO NUMBER The plan_instance_no for the referenced record.
COUPON_CODE TEXT The unique identifier for a coupon code.
OVERRIDE_MAX_APPLICATIONS NUMBER The maximum number of override applications.
TOTAL_APPLICATIONS NUMBER THe total applications.
ASSIGNED_TSTAMP TIMESTAMP_NTZ The timestamp of the assigned milestone.
UNASSIGNED_TSTAMP TIMESTAMP_NTZ The timestamp of the unassigned milestone.
EXPIRATION_DATE DATE The date of the expiration milestone.
REMAINDER_DISCOUNT_FACTOR NUMBER The remainder of the discount factor.
► Product Fields

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
FIELD_NO NUMBER The field_no for the referenced record.
FIELD_NAME TEXT The field_name for the referenced record.
DESCRIPTION TEXT A verbose description of the product fields.
INPUT_TYPE TEXT The input type.
MAXIMUM_SELECTIONS NUMBER The maximum number of selections.
MINIMUM_SELECTIONS NUMBER The minimum number of selections.
► Product Field Categories

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
CATEGORY_NO NUMBER The unique identifier for a category number.
NAME TEXT The product field category name.
DESCRIPTION TEXT A verbose description of the product field categories.
► Queued Plan Instance Changes

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
QUEUE_NO NUMBER The unique indentifier for the queue
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
ALTERNATE_PLAN_INSTANCE_START_DATE DATE The date of the alternate plan instance start milestone.
ALTERNATE_PRORATION_START_DATE DATE The date of the alternate proration start milestone.
AUTO_CANCEL_INCOMPATIBLE_SUPP_PLANS BOOLEAN Auotmatically cancel incompatible supplemental plans.
AUTO_OFFSET_MONTHS_OPTION_NO NUMBER The unique identifier for a auto offset months option number.
CHANGE_TYPE_NO NUMBER The unique identifier for a change type number.
COMMENTS TEXT A verbose explanation of details related to the referenced data.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
EFFECTIVE_DATE DATE The date the record goes into effect.
EXECUTE_ON_ANNIVERSARY BOOLEAN Execute the queued plan on the anniversary.
FORCE_BILL_DATE_RESET_NO NUMBER The unique identifier for the force bill reset date
FORCE_MASTER_BILL_DATE_RESET_NO NUMBER The unique identifier for the force master bill reset date
INVOICE_UNBILLED_USAGE BOOLEAN The unbilled invoice usage.
INVOICING_OPTION_NO NUMBER The unique identifier for a invoice option number.
NSO_BILL_IMMEDIATELY BOOLEAN Bill immediately on the NSO
OFFSET_MONTHS NUMBER The number of offset months.
OVERRIDE_BILL_THROUGH_DATE DATE The date of the override bill through date milestone.
PLAN_INSTANCE_NO NUMBER The parent_plan_instance_no for the referenced record.
CLIENT_PLAN_INSTANCE_ID TEXT The unique identifier for a client plan instance id.
PIC_BILL_DAY NUMBER The PIC billing day.
PIC_BILL_LAG_DAYS NUMBER The PIC billing lag days.
PIC_CLIENT_PLAN_INSTANCE_ID TEXT The unique identifier for a pic client plan instance id.
PIC_PLAN_NO NUMBER The pic_plan_no for the referenced record
PIC_PLAN_UNITS NUMBER The quantity of plan units for the referenced data.
PIC_PURCHASE_ORDER_NUMBER TEXT The pic purchase order number.
PIC_PROMOTION_CODE TEXT The pic promotion code.
PIC_CLIENT_PLAN_ID TEXT The unique identifier for a pic client plan record.
PIC_PLAN_INSTANCE_STATUS_NO NUMBER The unique identifier for a pic plan instance status number.
PIC_PLAN_RATE_SCHEDULE_NO NUMBER The pic_plan_rate_schedule_no for the referenced record.
PIC_CLIENT_PLAN_RATE_SCHEDULE_ID TEXT The client_plan_rate_rate_schedule_id for the referenced record.
PIC_PLAN_INSTANCE_DESCRIPTION TEXT A verbose pic plan instance description.
PRORATION_DIRECTIVE_NO NUMBER The unique identifier for a proration directive number.
PRORATION_INVOICE_TIMING_OPTION_NO NUMBER The unique identifier for a proration invoice timing option number.
REMOVE_PLAN_INSTANCE_CUSTOM_RATES BOOLEAN Remove the plan instance custom rates.
RETROACTIVE_START_DATE DATE The retroactive start date.
STATUS_NO NUMBER The unique identifier for a status number.
STATUS_NO_UNTIL_ALTERNATE_START_DATE NUMBER The date the status no alternative starts.
UPDATED_TSTAMP TIMESTAMP_NTZ The original source system updated timestamp for the referenced data.
► Reasons

Field

Datatype

Description

CLIENT_NO NUMBER  
BATCH_ID NUMBER  
CHG_ID NUMBER  
EVENT_TSTAMP TIMESTAMP_NTZ  
EVENT_ID TEXT  
CREATETIME NUMBER  
ACTIONS TEXT  
REASON_NO NUMBER  
REASON_TYPE_NO NUMBER  
NAME TEXT  
ON_ACCOUNT_CREDIT_MEMO BOOLEAN  
CREATED_TSTAMP TIMESTAMP_NTZ  
► Recurring Credits

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
RECURRING_CREDIT_NO NUMBER The unique identifier for a recurring credit number.
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
CANCEL_COMMENTS TEXT A verbose explanation of details related to cancellation.
CANCEL_DATE DATE The date of the cancel milestone.
COMMENTS TEXT A verbose explanation of details 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 in months.
CREDIT_SERVICE_NO NUMBER The credit_service_no for the referenced record.
CREDIT_CLIENT_SERVICE_ID TEXT The unique identifier for the credit client service id.
CURRENCY_CD TEXT The currency code for the referenced record.
EXPIRATION_DATE DATE The date of the expiration milestone.
EXPIRATION_MONTHS NUMBER The months to expiration date.
EXPIRATION_TYPE_INDICATOR_CD TEXT The expiration type indicator code.
FIRST_CREDIT_DATE DATE The date of the first credit.
LAST_CREDIT_DATE DATE The date of the last credit.
MASTER_PLAN_INSTANCE_NO NUMBER The master_plan_instance_no for the referenced record.
MASTER_CLIENT_PLAN_INSTANCE_ID TEXT The unique identifier for a master client plan instance id.
NEXT_CREDIT_DATE DATE The date of the next credit.
NUMBER_OF_CREDITS_REMAINING NUMBER The number of credits remaining.
NUMBER_OF_CREDITS_REQUIRED NUMBER The number of credits required.
PERCENTAGE_SOURCE_PLAN_NO NUMBER The percentage_source_plan_no for the referenced record
PERCENTAGE_SOURCE_CLIENT_PLAN_ID TEXT The unique identifier for a percentage source client plan record.
PERCENTAGE_SOURCE_SERVICE_NO NUMBER The percentage_source_service_no for the referenced record.
PERCENTAGE_SOURCE_CLIENT_SERVICE_ID TEXT The unique identifier for the percentage source client service id.
REASON_NO NUMBER The unique identifier for a reason number.
RECURRING_CREDIT_AMOUNT NUMBER The currency recurring credit amount.
RECURRING_CREDIT_TYPE_NO NUMBER The unique identifier for a recurring credit type number.
SOURCE_COUPON_CODE TEXT The source_coupon_code for the referenced record.
STATUS_NO NUMBER The unique identifier for a status number.
USE_CHARGE_SERVICE BOOLEAN The use charge service
► Services

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
SERVICE_NO NUMBER The service_no for the referenced record.
CLIENT_SERVICE_ID TEXT The unique identifier for the client service id.
NAME TEXT The service name.
SERVICE_TYPE_CD TEXT The service type code.
IS_TAXABLE BOOLEAN Is the service taxable?
SERVICE_LOCATION_NO NUMBER The unique identifier for the service location.
IS_SERVICE_CREDITS_ELIGIBLE BOOLEAN Are the service credits eligible?
COMMODITY_CODE TEXT The commodity code.
TAX_SERVICE_GROUP_NO NUMBER The unique identifier for a tax service group number.
REVENUE_ACCOUNT_GL_CODE_NO NUMBER The unique identifier for a revenue account gl code number.
ACCOUNT_RECEIVABLE_GL_CODE_NO NUMBER The unique identifier for a accounts receivable gl code number.
DEFERRED_GL_CODE_NO NUMBER The unique identifier for a deferred gl code number.
► Service Credits

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
CREDIT_NO NUMBER The unique identifier for a credit number.
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 currency amount.
AMOUNT_REVERSED_FOR_ANNIVERSARY NUMBER The amount to be reversed on the anniversary.
CANCEL_USER TEXT The user cancelling the record.
CANCELLED_TSTAMP TIMESTAMP_NTZ The timestamp of the cancelled milestone.
COMMENTS TEXT A verbose explanation of details related to the referenced data.
CREATE_USER TEXT The user creating the record.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
CREDIT_REASON_NO NUMBER The unique identifier for a credit reason number.
CREDIT_REASON_TYPE_NO NUMBER The unique identifier for a credit  reason type number.
CREDIT_SERVICE_NO NUMBER The credit_service_no for the referenced record.
CREDIT_CLIENT_SERVICE_ID TEXT The unique identifier for the credit client service id.
CURRENCY_CD TEXT The currency code for the referenced record.
EXPIRY_MONTHS NUMBER The number of months to expiration.
EXPIRY_TSTAMP TIMESTAMP_NTZ The timestamp of the expiry milestone.
IS_ORDER_BASED BOOLEAN Is the service credit record order based?
MASTER_PLAN_INSTANCE_NO NUMBER The master_plan_instance_no for the referenced record.
MASTER_CLIENT_PLAN_INSTANCE_ID TEXT The unique identifier for a master client plan instance id.
ORIGINATING_COUPON_CODE TEXT The originating coupon code.
ORIGINATING_INVOICE_LINE_TRANSACTION_NO NUMBER The unique identifier for a originating invoice line transaction.
ORIGINATING_RECURRING_CREDIT_NO NUMBER The unique identifier for a originating recurring credit number.
REMAINING_DAYS_WHEN_PRORATED NUMBER The remaining days when prorated.
TOTAL_DAYS_WHEN_PRORATED NUMBER The total number of prorated days.
UNCONSUMED_AMOUNT NUMBER The unconsumed currency amount.
USE_CHARGE_SERVICE BOOLEAN The use charge service.
► Service Locations

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
SERVICE_LOCATION_NO NUMBER The unique identifier for the service location.
CLIENT_SERVICE_LOCATION_ID TEXT The client_service_location_id for the referenced record.
NAME TEXT The service location name.
IS_ACTIVE BOOLEAN Is the refernced data active?
TAX_ENGINE_SPECIFIC_LOCATION_ID TEXT Denotes a unique tax engine specific identifier.
COMPANY_NAME TEXT The legal company name of the entity referenced in the data.
STREET VARIANT The street address of the referenced data.
CITY TEXT The city address of the referenced data.
COUNTY TEXT The county 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.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
► Statements

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
STATEMENT_NO NUMBER The statement_no for the referenced record.
ACCOUNT_NO NUMBER The account number 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 unique identifier for a payment method number.
SEQ_STATEMENT_ID TEXT The sequence id of the statement.
STATEMENT_CONTACT_NO NUMBER The unique identifier for a statement contact number.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
DUE_DATE DATE The date payment is due.
DUE_DATE_PLUS_GRACE_PERIOD DATE The date payment is due with the addition of the grace period.
SENT_TSTAMP TIMESTAMP_NTZ The timestamp of the sent milestone.
RESENT_TSTAMP TIMESTAMP_NTZ The timestamp of the resent milestone.
STATUS_NO NUMBER The unique identifier for a status number.
IS_REBILL BOOLEAN Is this a rebill statement?
CURRENCY_CD TEXT The default_currency_cd for the referenced record.
NEW_CHARGES_AMOUNT NUMBER The currency new charges amount.
NEW_PAYMENTS_AMOUNT NUMBER The currency new payments amount.
BALANCE_FORWARD_AMOUNT NUMBER The currency balance forward amount.
TOTAL_OWED NUMBER The total currency amount owed.
UNAPPLIED_CREDIT_BALANCE NUMBER The currency amount of the unapplied credit balance.
UNAPPLIED_PAYMENT_BALANCE NUMBER The currency amount of the unapplied payment balance.
► Surcharges

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
SURCHARGE_NO NUMBER The surcharge_no for the referenced record.
CLIENT_SURCHARGE_ID TEXT The client_surcharge_no for the referenced record.
APPLICATION_SCOPE_NO NUMBER The unique identifier for a application scope number.
ASSIGNMENT_LEVEL_NO NUMBER The unique identifier for a assignment level number.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
DESCRIPTION TEXT A verbose description of the record referenced.
EXTERNAL_DESCRIPTION TEXT A verbose external description of the record referenced.
IS_APPLIED_BEFORE_DISCOUNT BOOLEAN Is the surcharge applied beforethe discount?
IS_INLINE_SURCHARGE BOOLEAN Is the surcharge inline?
NAME TEXT The surcharge name.
RATE_CALCULATION_TYPE_CD TEXT The rate calculation type code.
TAX_SERVICE_GROUP_NO NUMBER The unique identifier for a tax service group number.
TAX_SERVICE_CLIENT_GROUP_ID TEXT The unique identifier for a tax service client group id.
► Surcharge Rate Schedules

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
SURCHARGE_NO NUMBER The surcharge_no for the referenced record.
SCHEDULE_NO NUMBER The schedule_no for the referenced record.
CURRENCY_CD TEXT The default_currency_cd for the referenced record.
INCLUDE_ZERO_IN_RATE_TIER BOOLEAN Include zero in the rate tier?
IS_DEFAULT_FOR_CURRENCY BOOLEAN Is the surcharge rate schedule the default for currency?
MINIMUM_SURCHARGE_TO_APPLY NUMBER The minimum surcharge to apply,
NAME TEXT The surcharge rate schedule name.
► Transactions

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
TRANSACTION_NO NUMBER The unique identifier for a transaction.
TRANSACTION_TYPE_NO NUMBER The unique identifier for a transaction type number.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
SOURCE_NO NUMBER The source number.
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 currency code for the referenced record.
AMOUNT NUMBER The currency amount.
APPLIED_AMOUNT NUMBER The currency applied amount.
FULLY_APPLIED_TSTAMP TIMESTAMP_NTZ The timestamp of the fully applied milestone.
STATEMENT_NO NUMBER The statement_no for the referenced record.
MASTER_PLAN_INSTANCE_NO NUMBER The master_plan_instance_no for the referenced record.
CLIENT_MASTER_PLAN_INSTANCE_ID TEXT The unique identifier for a client master plan instance.
API_RECEIPT_ID TEXT The API receipt id.
VOIDED_TRANSACTION_NO NUMBER The unique identifier for a voided transaction.
VOIDING_TRANSACTION_NO NUMBER The unique identifier for a voiding transaction.
PAYMENT_TSTAMP TIMESTAMP_NTZ The timestamp of the payment milestone.
REFERENCE_ID TEXT The reference id.
COLLECTION_STATUS_NO NUMBER The unique identifier for a collection status number.
PAYMENT_METHOD_NO NUMBER The unique identifier for a payment method number.
CLIENT_PAYMENT_METHOD_ID TEXT The unique identifier for a client payment method id.
PROCESSOR_PAYMENT_ID TEXT The transaction processers payment id.
PAYMENT_PROCESSOR_NO NUMBER The unique identifier for a payment processor id.
PAYMENT_METHOD_TYPE_NO NUMBER The unique identifier for a payment method type number.
PROCESSOR_STATUS_CD TEXT The processor status code.
PROCESSOR_STATUS_LABEL TEXT The processor status label.
INVOICE_NO NUMBER The Aria facing unique identifier for an invoice.
LINE_NO NUMBER The unique identifier for an invoice line.
PLAN_NO NUMBER The plan_no for the referenced record
CLIENT_PLAN_ID TEXT The unique identifier for a client plan record.
PLAN_INSTANCE_NO NUMBER The plan_instance_no for the referenced record.
CLIENT_PLAN_INSTANCE_ID TEXT The unique identifier for a client plan instance id.
SERVICE_NO NUMBER The service_no for the referenced record.
CLIENT_SERVICE_ID TEXT The unique identifier for the client service id.
USAGE_TYPE_NO NUMBER The unique identifier for a usage_type record.
USAGE_TYPE_CD TEXT The unique code for a usage_type record.
ORDER_NO NUMBER The unique identifier for an order.
ORDER_LINE_NO NUMBER The unique identifier for an order line.
SURCHARGE_NO NUMBER The surcharge_no for the referenced record.
PLAN_RATE_SCHEDULE_NO NUMBER The plan_rate_rate_schedule_no for the referenced record.
CLIENT_PLAN_RATE_SCHEDULE_ID TEXT The client_plan_rate_rate_schedule_id for the referenced record.
PLAN_RATE_SCHEDULE_SERVICE_TIER NUMBER The plan rate schedule service tier.
SERVICE_CREDIT_NO NUMBER The unique identifier for a service credit number.
SERVICE_CREDIT_SOURCE_TRANSACTION_NO NUMBER The unique identifier for a service credit source transaction.
SERVICE_CREDIT_TARGET_TRANSACTION_NO NUMBER The unique identifier for a service credit target transaction.
CREDIT_COUPON_CODE TEXT The credit coupon code.
CREDIT_REASON_NO NUMBER The unique identifier for a credit reason number.
PURCHASE_ORDER_NUMBER TEXT The purchase order number.
START_DATE DATE The start date.
END_DATE DATE The end date.
RATE NUMBER The rate for the referenced data.
UNITS NUMBER The quantity of units for the referenced data.
BASE_PLAN_UNITS NUMBER The quantity of base plan units for the referenced data.
PROMPT_PAYMENT_DISCOUNT_AMOUNT NUMBER The currency prompt payment discount amount.
PROMPT_PAYMENT_DISCOUNT_CUTOFF_DATE DATE The date the prompt payment discount is cutoff.
PRORATION_FACTOR NUMBER The proration factor.
PRORATION_DESCRIPTION TEXT A verbose proration description of the record referenced.
PRORATION_REMAINING_DAYS NUMBER The number of days for proration.
ADVANCE_BILLING_PERIOD_TOTAL_DAYS NUMBER The advanced billing period totals days.
IS_TAX_RELATED BOOLEAN Is the record tax related?
COMMENTS TEXT A verbose explanation of details related to the referenced data.
SURCHARGE_RATE_SCHEDULE_NO NUMBER The surcharge_rate_rate_schedule_no for the referenced record.
SURCHARGE_RATE_SCHEDULE_TIER NUMBER The surcharge_rate_rate_schedule_tier for the referenced record.
PRORATION_OPERATION_TYPE_NO NUMBER The unique identifier for a proration operation type number.
IS_CUSTOM_RATED BOOLEAN Is the record custom rated?
FROM_ACCOUNT_NO NUMBER The unique identifier for a from account number.
FROM_CLIENT_ACCOUNT_ID TEXT The unique identifier for a from client account id.
FROM_MASTER_PLAN_INSTANCE_NO NUMBER The from_master_plan_instance_no for the referenced record.
FROM_CLIENT_MASTER_PLAN_INSTANCE_ID TEXT The unique identifier for a from client master plan instance.
TO_ACCOUNT_NO NUMBER The unique identifier for the to account number.
TO_CLIENT_ACCOUNT_ID TEXT The unique identifier for the to client account id.
TO_MASTER_PLAN_INSTANCE_NO NUMBER The to_master_plan_instance_no for the referenced record.
TO_CLIENT_MASTER_PLAN_INSTANCE_ID TEXT The unique identifier for a to client master plan instance.
WRITE_OFF_TSTAMP TIMESTAMP_NTZ The timestamp of the write off.
WRITE_OFF_REASON_NO NUMBER The unique identifier for the write off reason number.
SECONDARY_WRITE_OFF_REASON_NO NUMBER The unique identifier for a secondary write off reason number.
DISPUTE_HOLD_EXPIRE_DAYS NUMBER The number of holds days during a dispute.
REFUND_REASON_NO NUMBER The unique identifier for a refund reason number.
REVERSAL_NO NUMBER The unique identifier for the reversal number.
PROCESSED_TSTAMP TIMESTAMP_NTZ The timestamp for the processing milestone.
CREDIT_MEMO_NO NUMBER The unique identifier for a credit memo number.
INVOICE_LINE_TRANSACTION_NO NUMBER The unique identifier for a invoice line transaction.
► Transaction Applications

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
APPLICATION_NO NUMBER The unique identifier for an application number
PAYMENT_TRANSACTION_NO NUMBER The unique identifier for a payment transaction.
CHARGE_TRANSACTION_NO NUMBER The unique identifier for a charge transaction.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
APPLIED_AMOUNT NUMBER The currency applied amount.
ACCOUNT_NO NUMBER The account number related to the customer referenced
MASTER_PLAN_INSTANCE_NO NUMBER The master_plan_instance_no for the referenced record.
► Usage Records

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
USAGE_RECORD_NO NUMBER The unique identifier for a usage record.
CLIENT_USAGE_RECORD_ID TEXT The unique identifier for a client usage 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 currency amount.
BILLABLE_UNITS NUMBER The quantity of billable units for the referenced data.
CLIENT_EXCLUDE_REASON_CD NUMBER The client exclusion reason code.
COMMENTS TEXT A verbose explanation of details related to the referenced data.
EXCLUDE_TSTAMP TIMESTAMP_NTZ The timestamp for the exclude milestone.
EXCLUDE_USER TEXT The user for the exclude milestone.
EXCLUSION_COMMENTS TEXT A verbose explanation of details related to the exclusion.
INVOICE_NO NUMBER The Aria facing unique identifier for an invoice.
IS_EXCLUDED BOOLEAN Is the record excluded?
PLAN_NO NUMBER The plan_no for the referenced record
CLIENT_PLAN_ID TEXT The unique identifier for a client plan record.
PLAN_INSTANCE_NO NUMBER The plan_instance_no for the referenced record.
CLIENT_PLAN_INSTANCE_ID TEXT The unique identifier for a client plan instance id.
QUALIFIER_1 TEXT The first qualifier.
QUALIFIER_2 TEXT The second qualifier.
QUALIFIER_3 TEXT The third qualifier.
QUALIFIER_4 TEXT The fourth qualifier.
RATE NUMBER The rate for the referenced data.
TELCO_FROM TEXT The telco from.
TELCO_TO TEXT The telco to.
UNITS NUMBER The quantity of units for the referenced data.
PARENT_USAGE_RECORD_NO NUMBER The unique identifier for a parent usage record.
PARENT_CLIENT_USAGE_RECORD_ID TEXT The unique identifier for a client parent usage record.
USAGE_TSTAMP TIMESTAMP_NTZ The timestamp for the referenced usage.
USAGE_TYPE_NO NUMBER The unique identifier for a usage_type record.
USAGE_TYPE_CD TEXT The unique code for a usage_type record.
► Usage Types

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
USAGE_TYPE_NO NUMBER The unique identifier for a usage_type record.
USAGE_TYPE_CD TEXT The unique code for a usage_type record.
DESCRIPTION TEXT A verbose description of the record referenced.
DISPLAY_NAME TEXT The usage type display name.
NAME TEXT The usage type name.
USAGE_UNIT_TYPE_NO NUMBER The unique identifier for a usage unit type number.
CLIENT_USAGE_UNIT_TYPE_ID TEXT The unique identifier for a client usage unit type id.
► Usage Unit Types

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
USAGE_UNIT_TYPE_NO NUMBER The unique identifier for a usage unit type number.
CLIENT_USAGE_UNIT_TYPE_ID TEXT The unique identifier for a client usage unit type id.
DESCRIPTION TEXT A verbose description of the record referenced.
ABBREVIATION TEXT The abbreviation of the usage unit types.
DISPLAY_FORMAT_MASK TEXT The display format mask.

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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
► 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
  • Was this article helpful?