Introducing the Smile public schema
Introducing the Smile public schema
Who should use Smile public schema?
What can you do with Smile public schema?
Will the tables change after an upgrade?
How does Smile public schema work?
Using the Smile public schema
Using the Smile public schema
Accessing the schema
Joining informational tables
Wildcard queries
Working with customer identifiers
Working with customer identifiers
Working with custom fields
Working with custom fields
cf(uid)
cf(uid, code)
cf_tx_item(tx_item, code)
cf_line_item(line_item, code)
Data dictionary
Informational tables
Data types
access_server
access_server_vendor
account
account_address
account_audit_log
account_balance
account_contact
account_cost_centre
account_disposition
account_payment_configuration
account_payment_option
account_purchase_order
account_terms
account_type
address_type
calendar
company
connection_type
contract
crm_contact
crm_contact_type
currency
current_connections
custom_fields
destination
destination_type
discount
line_item
office
operator
payment
payment_plan
payment_plan_frequency_type
payment_plan_status
payment_status
payment_type
payment_type_processing_mode
plan
plan_option
plan_option_display_type
plan_option_group
policy_group
policy_type
prepaid_duration_type
prepaid_priority
prepaid_type
prepaid_voucher
prepaid_voucher_batch
prepaid_voucher_type
quantity_type
quanity_type_units
rating_cycle
rating_period
rating_period_prerate_status
rating_period_status
rating_subscription_status
recurring_charge
recurring_charge_frequency_type
recurring_charge_mode
recurring_charge_prorata_behaviour
reporting_account
service
subscription
subscription_address
subscription_audit_log
subscription_contact
subscription_contract
subscription_plan
subscription_plan_schedule
subscription_plan_schedule_item
subscription_plan_schedule_item_option
subscription_policy
subscription_prepaid
subscription_rating_error
subscription_rating_status
subscription_status
subservice
szu
tariff
tariff_type
tax_schedule
tax_schedule_item
ticket
ticket_action
ticket_group
ticket_priority
ticket_status
ticket_status_log
ticket_type
timesheet
timezone
tx
tx_aged
tx_allocation
tx_detail
tx_disposition
tx_item
tx_type
xdr
xdr_rated
xdr_rating
xdr_type
Account group
Account group diagram
Company group
Company group diagram
Subscription group
Subscription group diagram
Subscription_prepaid group
Subscription Prepaid group diagram
Ticket group
Ticket group diagram
Transactions group
Transactions group diagram
XDR group
XDR group diagram