res_currency

170 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('res_currency_id_seq'::regclass)
account_account.currency_id account_account_currency_id_fkey N
account_accrued_orders_wizard.currency_id account_accrued_orders_wizard_currency_id_fkey N
account_analytic_line.currency_id account_analytic_line_currency_id_fkey N
account_bank_statement_line.currency_id account_bank_statement_line_currency_id_fkey N
account_bank_statement_line.foreign_currency_id account_bank_statement_line_foreign_currency_id_fkey N
account_journal.currency_id account_journal_currency_id_fkey N
account_move.currency_id account_move_currency_id_fkey R
account_move_line.company_currency_id account_move_line_company_currency_id_fkey N
account_move_line.currency_id account_move_line_currency_id_fkey R
account_partial_reconcile.credit_currency_id account_partial_reconcile_credit_currency_id_fkey N
account_partial_reconcile.debit_currency_id account_partial_reconcile_debit_currency_id_fkey N
account_payment.currency_id account_payment_currency_id_fkey N
account_payment_register.currency_id account_payment_register_currency_id_fkey N
account_payment_register.source_currency_id account_payment_register_source_currency_id_fkey N
mail_tracking_value.currency_id mail_tracking_value_currency_id_fkey N
payment_currency_rel.currency_id payment_currency_rel_currency_id_fkey C
payment_link_wizard.currency_id payment_link_wizard_currency_id_fkey N
payment_method_res_currency_rel.res_currency_id payment_method_res_currency_rel_res_currency_id_fkey C
payment_transaction.currency_id payment_transaction_currency_id_fkey R
product_pricelist.currency_id product_pricelist_currency_id_fkey R
product_pricelist_item.currency_id product_pricelist_item_currency_id_fkey N
product_supplierinfo.currency_id product_supplierinfo_currency_id_fkey R
purchase_order.currency_id purchase_order_currency_id_fkey R
purchase_order_line.currency_id purchase_order_line_currency_id_fkey N
res_company.currency_id res_company_currency_id_fkey R
res_country.currency_id res_country_currency_id_fkey N
res_currency_rate.currency_id res_currency_rate_currency_id_fkey C
res_partner_bank.currency_id res_partner_bank_currency_id_fkey N
sale_advance_payment_inv.currency_id sale_advance_payment_inv_currency_id_fkey N
sale_order.currency_id sale_order_currency_id_fkey R
sale_order_line.currency_id sale_order_line_currency_id_fkey N
name varchar 2147483647 null
symbol varchar 2147483647 null
decimal_places int4 10 √ null

Decimal Places
create_uid int4 10 √ null
res_users.id res_currency_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id res_currency_write_uid_fkey N

Last Updated by
full_name varchar 2147483647 √ null

Name
position varchar 2147483647 √ null

Symbol Position
currency_unit_label varchar 2147483647 √ null

Currency Unit
currency_subunit_label varchar 2147483647 √ null

Currency Subunit
rounding numeric 0 √ null

Rounding Factor
active bool 1 √ null

Active
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
res_currency_pkey Primary key Asc id
res_currency_unique_name Must be unique Asc name

Check Constraints

Constraint Name Constraint
res_currency_rounding_gt_zero ((rounding > (0)::numeric))

Relationships

Close relationships within degrees of separation