account_analytic_line

-1 rows


Description

Analytic Line

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_analytic_line_id_seq'::regclass)
account_analytic_line_stock_move_rel.account_analytic_line_id account_analytic_line_stock_move__account_analytic_line_id_fkey C
mrp_workorder_mo_analytic_rel.account_analytic_line_id mrp_workorder_mo_analytic_rel_account_analytic_line_id_fkey C
mrp_workorder_wc_analytic_rel.account_analytic_line_id mrp_workorder_wc_analytic_rel_account_analytic_line_id_fkey C
product_uom_id int4 10 √ null
uom_uom.id account_analytic_line_product_uom_id_fkey N

Unit of Measure
account_id int4 10 √ null
account_analytic_account.id account_analytic_line_account_id_fkey R

Project Account
partner_id int4 10 √ null
res_partner.id account_analytic_line_partner_id_fkey N

Partner
user_id int4 10 √ null
res_users.id account_analytic_line_user_id_fkey N

User
company_id int4 10 null
res_company.id account_analytic_line_company_id_fkey R

Company
currency_id int4 10 √ null
res_currency.id account_analytic_line_currency_id_fkey N

Currency
create_uid int4 10 √ null
res_users.id account_analytic_line_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Description
category varchar 2147483647 √ null

Category
date date 13 null

Date
amount numeric 0 null

Amount
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
unit_amount float8 17,17 √ null

Quantity
x_plan2_id int4 10 √ null
account_analytic_account.id account_analytic_line_x_plan2_id_fkey N

Departments
x_plan3_id int4 10 √ null
account_analytic_account.id account_analytic_line_x_plan3_id_fkey N

Internal
product_id int4 10 √ null
product_product.id account_analytic_line_product_id_fkey N

Product
general_account_id int4 10 √ null
account_account.id account_analytic_line_general_account_id_fkey R

Financial Account
journal_id int4 10 √ null
account_journal.id account_analytic_line_journal_id_fkey N

Financial Journal
move_line_id int4 10 √ null
account_move_line.id account_analytic_line_move_line_id_fkey C

Journal Item
code varchar 8 √ null

Code
ref varchar 2147483647 √ null

Ref.
so_line int4 10 √ null
sale_order_line.id account_analytic_line_so_line_fkey N

Sales Order Item

Indexes

Constraint Name Type Sort Column(s)
account_analytic_line_pkey Primary key Asc id
account_analytic_line__account_id_index Performance Asc account_id
account_analytic_line__date_index Performance Asc date
account_analytic_line__move_line_id_index Performance Asc move_line_id
account_analytic_line__so_line_index Performance Asc so_line
account_analytic_line__user_id_index Performance Asc user_id
account_analytic_line__x_plan2_id_index Performance Asc x_plan2_id
account_analytic_line__x_plan3_id_index Performance Asc x_plan3_id

Relationships

Close relationships within degrees of separation