sale_order_option

-1 rows


Description

Sale Options

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('sale_order_option_id_seq'::regclass)
order_id int4 10 √ null
sale_order.id sale_order_option_order_id_fkey C

Sales Order Reference
product_id int4 10 null
product_product.id sale_order_option_product_id_fkey R

Product
line_id int4 10 √ null
sale_order_line.id sale_order_option_line_id_fkey N

Line
sequence int4 10 √ null

Sequence
uom_id int4 10 null
uom_uom.id sale_order_option_uom_id_fkey R

Unit of Measure
create_uid int4 10 √ null
res_users.id sale_order_option_create_uid_fkey N

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

Last Updated by
name text 2147483647 null

Description
quantity numeric 0 null

Quantity
price_unit numeric 0 null

Unit Price
discount numeric 0 √ null

Discount (%)
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
sale_order_option_pkey Primary key Asc id
sale_order_option__order_id_index Performance Asc order_id

Relationships

Close relationships within degrees of separation