Younium schema and ERD

74 tables

Loading diagram…

account

booking

daily_order_metric_per_product

invoice

invoice_batch

journal

payment

product

quote

sales_order

simple_product

subscription

subscription_version

tax_template

user

account

string

invoice_batch_group_id

string

parent_account_id

string

account_number

string

account_type

string

inactive

boolean

invoice_delivery_method

string

accounts_receivable

string

currency_code

string

default_payment_term

string

account_address

string

account_id

string

description

string

name

string

street

string

street2

string

city

string

county

string

state

string

zip

string

country

string

_weld_synced

date

booking

string

currency

string

booking_type

string

account_category

string

change_type

string

cmrr_amount

double

cmrr_amount_in_base_currency

double

acv_amount

double

acv_amount_in_base_currency

double

booking_line

booking_id

string

created

date

modified

date

charge_name

string

charge_charge_number

string

charge_description

string

charge_id

string

charge_external_erp_id

string

charge_external_crm_id

string

chart_of_account

string

code

string

name

string

description

string

external_erp_id

string

external_crm_id

string

_weld_synced

date

country

string

name

string

two_alpha_code

string

three_alpha_code

string

active

boolean

custom_fields

string

_weld_synced

date

currency

string

code

string

description

string

_weld_synced

date

custom_field_configuration

string

key

string

name

string

default_value

string

field_type

string

entity

string

list

string

type_entity

string

entity_object

string

_weld_synced

date

daily_charge_metric

product_id

string

date

charge_id

string

name

string

charge_number

string

charge_plan_id

string

order_product_id

string

tcv_amount

double

tcv_currency_code

string

daily_order_metric_per_product

product_id

string

date

tcv_amount

double

tcv_currency_code

string

tcv_currency_conversion_date

date

tcv_base_currency_amount

double

tcv_base_currency_code

string

cmrr_amount

double

cmrr_currency_code

string

daily_order_metric_per_product_charge

product_id

string

charge_id

string

date

name

string

charge_number

string

charge_plan_id

string

order_product_id

string

tcv_amount

double

tcv_currency_code

string

document_template

string

description

string

document_type

string

_weld_synced

date

exchange_rate

string

from_currency

string

to_currency

string

rate

double

effective_from_date

date

effective_to_date

date

_weld_synced

date

invoice

string

account_id

string

payment_term_id

string

invoice_batch_id

string

invoice_number

string

status

string

account_name

string

account_account_number

string

account_external_erp_id

string

account_external_crm_id

string

notes

string

invoice_date

date

invoice_line

string

invoice_id

string

account_id

string

invoice_line_number

int

product_number

string

product_name

string

charge_description

string

charge_number

string

charge_name

string

charge_id

string

charge_external_erp_id

string

invoice_online_latest_payment_log

invoice_id

string

failed_payment

boolean

payment_description

string

timestamp

date

payout_id

string

is_payout

boolean

payment_intent_id

string

index

int

_weld_synced

date

invoice_batch

string

batch_number

string

target_date

date

invoice_date

date

batch_groups

string

created

date

modified

date

_weld_synced

date

invoice_batch_invoice

string

invoice_batch_id

string

invoice_number

string

status

string

invoice_date

date

currency

string

subtotal

double

total_amount

double

external_erp_id

string

external_crm_id

string

_weld_synced

date

invoice_batch_log

invoice_batch_id

string

entity_id

string

error_message

string

reference

string

entity_name

string

created

date

modified

date

_weld_synced

date

invoice_batch_group

string

code

string

description

string

_weld_synced

date

journal

string

journal_number

string

accounting_period_description

string

accounting_period_fiscal_year

int

accounting_period_fiscal_period

int

accounting_period_fiscal_quarter

int

accounting_period_calendar_year

int

accounting_period_calendar_month

int

accounting_period_start_date

date

journal_voucher

journal_id

string

invoice_id

string

invoice_line_id

string

payment_id

string

payment_settlement_id

string

transaction_number

string

effective_date

date

source

string

order_charge_number

string

order_charge_id

string

revenue_schedule_item_id

string

invoice_number

string

invoice_account_id

string

journal_voucher_transaction

journal_id

string

transaction_number

string

account

string

description

string

debit_amount

double

credit_amount

double

sales_currency_debit_amount

double

sales_currency_credit_amount

double

sales_currency

string

exchange_rate

double

custom_fields

string

index

int

_weld_synced

date

measurement

string

account_id

string

product_id

string

account_name

string

account_account_number

string

account_external_erp_id

string

account_external_crm_id

string

order_order_number

string

order_id

string

order_external_erp_id

string

order_external_crm_id

string

payment

string

payer_name

string

payer_information

string

payment_date

date

posted_date

date

reference

string

description

string

amount_amount

double

amount_currency_code

string

payment_settlement

payment_id

string

invoice_id

string

amount_amount

double

amount_currency_code

string

amount_currency_conversion_date

date

amount_base_currency_amount

double

amount_base_currency_code

string

invoice_invoice_number

string

invoice_status

string

invoice_invoice_date

date

payment_settlement_write_off

string

payment_id

string

settlement_invoice_id

string

amount_amount

double

amount_currency_code

string

amount_currency_conversion_date

date

amount_base_currency_amount

double

amount_base_currency_code

string

posting_text

string

financial_account_id

string

payment_write_off

string

payment_id

string

settlement_invoice_id

string

amount_amount

double

amount_currency_code

string

amount_currency_conversion_date

date

amount_base_currency_amount

double

amount_base_currency_code

string

posting_text

string

financial_account_id

string

payment_term

string

description

string

name

string

term_type

string

days

int

_weld_synced

date

product

string

product_number

string

name

string

product_type

string