account_analytic_account

-1 rows


Description

Analytic Account

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_analytic_account_id_seq'::regclass)
account_analytic_account_mrp_bom_rel.account_analytic_account_id account_analytic_account_mrp_b_account_analytic_account_id_fkey C
account_analytic_account_mrp_production_rel.account_analytic_account_id account_analytic_account_mrp_p_account_analytic_account_id_fkey C
account_analytic_account_mrp_workcenter_rel.account_analytic_account_id account_analytic_account_mrp_w_account_analytic_account_id_fkey C
account_analytic_line.account_id account_analytic_line_account_id_fkey R
account_analytic_line.x_plan2_id account_analytic_line_x_plan2_id_fkey N
account_analytic_line.x_plan3_id account_analytic_line_x_plan3_id_fkey N
sale_order.analytic_account_id sale_order_analytic_account_id_fkey N
plan_id int4 10 null
account_analytic_plan.id account_analytic_account_plan_id_fkey R

Plan
root_plan_id int4 10 √ null
account_analytic_plan.id account_analytic_account_root_plan_id_fkey N

Root Plan
company_id int4 10 √ null
res_company.id account_analytic_account_company_id_fkey N

Company
partner_id int4 10 √ null
res_partner.id account_analytic_account_partner_id_fkey N

Customer
create_uid int4 10 √ null
res_users.id account_analytic_account_create_uid_fkey N

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

Last Updated by
code varchar 2147483647 √ null

Reference
name jsonb 2147483647 null

Analytic Account
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)
account_analytic_account_pkey Primary key Asc id
account_analytic_account__code_index Performance Asc code

Relationships

Close relationships within degrees of separation