purchase_order_line

22 rows


Description

Purchase Order Line

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('purchase_order_line_id_seq'::regclass)
account_move_line.purchase_line_id account_move_line_purchase_line_id_fkey N
account_tax_purchase_order_line_rel.purchase_order_line_id account_tax_purchase_order_line_rel_purchase_order_line_id_fkey C
stock_move.purchase_line_id stock_move_purchase_line_id_fkey N
stock_move_created_purchase_line_rel.created_purchase_line_id stock_move_created_purchase_line__created_purchase_line_id_fkey C
sequence int4 10 √ null

Sequence
product_uom int4 10 √ null
uom_uom.id purchase_order_line_product_uom_fkey N

Unit of Measure
product_id int4 10 √ null
product_product.id purchase_order_line_product_id_fkey N

Product
order_id int4 10 null
purchase_order.id purchase_order_line_order_id_fkey C

Order Reference
company_id int4 10 √ null
res_company.id purchase_order_line_company_id_fkey N

Company
partner_id int4 10 √ null
res_partner.id purchase_order_line_partner_id_fkey N

Partner
currency_id int4 10 √ null
res_currency.id purchase_order_line_currency_id_fkey N

Currency
product_packaging_id int4 10 √ null
product_packaging.id purchase_order_line_product_packaging_id_fkey N

Packaging
create_uid int4 10 √ null
res_users.id purchase_order_line_create_uid_fkey N

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

Last Updated by
state varchar 2147483647 √ null

Status
qty_received_method varchar 2147483647 √ null

Received Qty Method
display_type varchar 2147483647 √ null

Display Type
analytic_distribution jsonb 2147483647 √ null

Analytic Distribution
name text 2147483647 null

Description
product_qty numeric 0 null

Quantity
discount numeric 0 √ null

Discount (%)
price_unit numeric 0 null

Unit Price
price_subtotal numeric 0 √ null

Subtotal
price_total numeric 0 √ null

Total
qty_invoiced numeric 0 √ null

Billed Qty
qty_received numeric 0 √ null

Received Qty
qty_received_manual numeric 0 √ null

Manual Received Qty
qty_to_invoice numeric 0 √ null

To Invoice Quantity
date_planned timestamp 29,6 √ null

Expected Arrival
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
product_uom_qty float8 17,17 √ null

Total Quantity
price_tax float8 17,17 √ null

Tax
product_packaging_qty float8 17,17 √ null

Packaging Quantity
orderpoint_id int4 10 √ null
stock_warehouse_orderpoint.id purchase_order_line_orderpoint_id_fkey N

Orderpoint
product_description_variants varchar 2147483647 √ null

Custom Description
propagate_cancel bool 1 √ null

Propagate cancellation
sale_order_id int4 10 √ null
sale_order.id purchase_order_line_sale_order_id_fkey N

Sale Order
sale_line_id int4 10 √ null
sale_order_line.id purchase_order_line_sale_line_id_fkey N

Origin Sale Item

Indexes

Constraint Name Type Sort Column(s)
purchase_order_line_pkey Primary key Asc id
purchase_order_line__date_planned_index Performance Asc date_planned
purchase_order_line__order_id_index Performance Asc order_id
purchase_order_line__orderpoint_id_index Performance Asc orderpoint_id
purchase_order_line__partner_id_index Performance Asc partner_id
purchase_order_line__product_id_index Performance Asc product_id
purchase_order_line__sale_line_id_index Performance Asc sale_line_id
purchase_order_line_analytic_distribution_accounts_gin_index Performance

Check Constraints

Constraint Name Constraint
purchase_order_line_accountable_required_fields (((display_type IS NOT NULL) OR ((product_id IS NOT NULL) AND (product_uom IS NOT NULL) AND (date_planned IS NOT NULL))))
purchase_order_line_non_accountable_null_fields (((display_type IS NULL) OR ((product_id IS NULL) AND (price_unit = (0)::numeric) AND (product_uom_qty = (0)::double precision) AND (product_uom IS NULL) AND (date_planned IS NULL))))

Relationships

Close relationships within degrees of separation