sale_order_line

50 rows


Description

Sales Order Line

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('sale_order_line_id_seq'::regclass)
account_analytic_line.so_line account_analytic_line_so_line_fkey N
account_tax_sale_order_line_rel.sale_order_line_id account_tax_sale_order_line_rel_sale_order_line_id_fkey C
product_attribute_custom_value.sale_order_line_id product_attribute_custom_value_sale_order_line_id_fkey C
product_template_attribute_value_sale_order_line_rel.sale_order_line_id product_template_attribute_value_sale_o_sale_order_line_id_fkey C
purchase_order_line.sale_line_id purchase_order_line_sale_line_id_fkey N
sale_order_line_invoice_rel.order_line_id sale_order_line_invoice_rel_order_line_id_fkey C
sale_order_option.line_id sale_order_option_line_id_fkey N
stock_move.sale_line_id stock_move_sale_line_id_fkey N
order_id int4 10 null
sale_order.id sale_order_line_order_id_fkey C

Order Reference
sequence int4 10 √ null

Sequence
company_id int4 10 √ null
res_company.id sale_order_line_company_id_fkey N

Company
currency_id int4 10 √ null
res_currency.id sale_order_line_currency_id_fkey N

Currency
order_partner_id int4 10 √ null
res_partner.id sale_order_line_order_partner_id_fkey N

Customer
salesman_id int4 10 √ null
res_users.id sale_order_line_salesman_id_fkey N

Salesperson
product_id int4 10 √ null
product_product.id sale_order_line_product_id_fkey R

Product
product_uom int4 10 √ null
uom_uom.id sale_order_line_product_uom_fkey R

Unit of Measure
product_packaging_id int4 10 √ null
product_packaging.id sale_order_line_product_packaging_id_fkey N

Packaging
create_uid int4 10 √ null
res_users.id sale_order_line_create_uid_fkey N

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

Last Updated by
state varchar 2147483647 √ null

Order Status
display_type varchar 2147483647 √ null

Display Type
qty_delivered_method varchar 2147483647 √ null

Method to update delivered qty
invoice_status varchar 2147483647 √ null

Invoice Status
analytic_distribution jsonb 2147483647 √ null

Analytic Distribution
name text 2147483647 null

Description
product_uom_qty numeric 0 null

Quantity
price_unit numeric 0 null

Unit Price
discount numeric 0 √ null

Discount (%)
price_subtotal numeric 0 √ null

Subtotal
price_total numeric 0 √ null

Total
price_reduce_taxexcl numeric 0 √ null

Price Reduce Tax excl
price_reduce_taxinc numeric 0 √ null

Price Reduce Tax incl
qty_delivered numeric 0 √ null

Delivery Quantity
qty_invoiced numeric 0 √ null

Invoiced Quantity
qty_to_invoice numeric 0 √ null

Quantity To Invoice
untaxed_amount_invoiced numeric 0 √ null

Untaxed Invoiced Amount
untaxed_amount_to_invoice numeric 0 √ null

Untaxed Amount To Invoice
is_downpayment bool 1 √ null

Is a down payment
is_expense bool 1 √ null

Is expense
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
price_tax float8 17,17 √ null

Total Tax
product_packaging_qty float8 17,17 √ null

Packaging Quantity
customer_lead float8 17,17 null

Lead Time
route_id int4 10 √ null
stock_route.id sale_order_line_route_id_fkey R

Route

Indexes

Constraint Name Type Sort Column(s)
sale_order_line_pkey Primary key Asc id
sale_order_line__company_id_index Performance Asc company_id
sale_order_line__order_id_index Performance Asc order_id
sale_order_line__order_partner_id_index Performance Asc order_partner_id
sale_order_line__product_id_index Performance Asc product_id
sale_order_line_analytic_distribution_accounts_gin_index Performance

Check Constraints

Constraint Name Constraint
sale_order_line_accountable_required_fields (((display_type IS NOT NULL) OR ((product_id IS NOT NULL) AND (product_uom IS NOT NULL))))
sale_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)::numeric) AND (product_uom IS NULL) AND (customer_lead = (0)::double precision))))

Relationships

Close relationships within degrees of separation