sale_order

24 rows


Description

Sales Order

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('sale_order_id_seq'::regclass)
procurement_group.sale_id procurement_group_sale_id_fkey N
purchase_order_line.sale_order_id purchase_order_line_sale_order_id_fkey N
sale_advance_payment_inv_sale_order_rel.sale_order_id sale_advance_payment_inv_sale_order_rel_sale_order_id_fkey C
sale_order_cancel.order_id sale_order_cancel_order_id_fkey C
sale_order_discount.sale_order_id sale_order_discount_sale_order_id_fkey C
sale_order_line.order_id sale_order_line_order_id_fkey C
sale_order_mass_cancel_wizard_rel.sale_order_id sale_order_mass_cancel_wizard_rel_sale_order_id_fkey C
sale_order_option.order_id sale_order_option_order_id_fkey C
sale_order_tag_rel.order_id sale_order_tag_rel_order_id_fkey C
sale_order_transaction_rel.sale_order_id sale_order_transaction_rel_sale_order_id_fkey C
stock_picking.sale_id stock_picking_sale_id_fkey N
campaign_id int4 10 √ null
utm_campaign.id sale_order_campaign_id_fkey N

Campaign
source_id int4 10 √ null
utm_source.id sale_order_source_id_fkey N

Source
medium_id int4 10 √ null
utm_medium.id sale_order_medium_id_fkey N

Medium
company_id int4 10 null
res_company.id sale_order_company_id_fkey R

Company
partner_id int4 10 null
res_partner.id sale_order_partner_id_fkey R

Customer
journal_id int4 10 √ null
account_journal.id sale_order_journal_id_fkey N

Invoicing Journal
partner_invoice_id int4 10 null
res_partner.id sale_order_partner_invoice_id_fkey R

Invoice Address
partner_shipping_id int4 10 null
res_partner.id sale_order_partner_shipping_id_fkey R

Delivery Address
fiscal_position_id int4 10 √ null
account_fiscal_position.id sale_order_fiscal_position_id_fkey N

Fiscal Position
payment_term_id int4 10 √ null
account_payment_term.id sale_order_payment_term_id_fkey N

Payment Terms
pricelist_id int4 10 √ null
product_pricelist.id sale_order_pricelist_id_fkey N

Pricelist
currency_id int4 10 √ null
res_currency.id sale_order_currency_id_fkey R

Currency
user_id int4 10 √ null
res_users.id sale_order_user_id_fkey N

Salesperson
team_id int4 10 √ null
crm_team.id sale_order_team_id_fkey N

Sales Team
analytic_account_id int4 10 √ null
account_analytic_account.id sale_order_analytic_account_id_fkey N

Analytic Account
create_uid int4 10 √ null
res_users.id sale_order_create_uid_fkey N

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

Last Updated by
access_token varchar 2147483647 √ null

Security Token
name varchar 2147483647 null

Order Reference
state varchar 2147483647 √ null

Status
client_order_ref varchar 2147483647 √ null

Customer Reference
origin varchar 2147483647 √ null

Source Document
reference varchar 2147483647 √ null

Payment Ref.
signed_by varchar 2147483647 √ null

Signed By
invoice_status varchar 2147483647 √ null

Invoice Status
validity_date date 13 √ null

Expiration
note text 2147483647 √ null

Terms and conditions
currency_rate numeric 0 √ null

Currency Rate
amount_untaxed numeric 0 √ null

Untaxed Amount
amount_tax numeric 0 √ null

Taxes
amount_total numeric 0 √ null

Total
amount_to_invoice numeric 0 √ null

Amount to invoice
locked bool 1 √ null

Locked
require_signature bool 1 √ null

Online signature
require_payment bool 1 √ null

Online payment
create_date timestamp 29,6 √ null

Creation Date
commitment_date timestamp 29,6 √ null

Delivery Date
date_order timestamp 29,6 null

Order Date
signed_on timestamp 29,6 √ null

Signed On
write_date timestamp 29,6 √ null

Last Updated on
prepayment_percent float8 17,17 √ null

Prepayment percentage
pending_email_template_id int4 10 √ null
mail_template.id sale_order_pending_email_template_id_fkey N

Pending Email Template
sale_order_template_id int4 10 √ null
sale_order_template.id sale_order_sale_order_template_id_fkey N
incoterm int4 10 √ null
account_incoterms.id sale_order_incoterm_fkey N

Incoterm
warehouse_id int4 10 null
stock_warehouse.id sale_order_warehouse_id_fkey R

Warehouse
procurement_group_id int4 10 √ null
procurement_group.id sale_order_procurement_group_id_fkey N

Procurement Group
incoterm_location varchar 2147483647 √ null

Incoterm Location
picking_policy varchar 2147483647 null

Shipping Policy
delivery_status varchar 2147483647 √ null

Delivery Status
effective_date timestamp 29,6 √ null

Effective Date

Indexes

Constraint Name Type Sort Column(s)
sale_order_pkey Primary key Asc id
sale_order__campaign_id_index Performance Asc campaign_id
sale_order__company_id_index Performance Asc company_id
sale_order__create_date_index Performance Asc create_date
sale_order__medium_id_index Performance Asc medium_id
sale_order__partner_id_index Performance Asc partner_id
sale_order__partner_invoice_id_index Performance Asc partner_invoice_id
sale_order__partner_shipping_id_index Performance Asc partner_shipping_id
sale_order__source_id_index Performance Asc source_id
sale_order__state_index Performance Asc state
sale_order__user_id_index Performance Asc user_id
sale_order_date_order_id_idx Performance Desc/Desc date_order + id

Check Constraints

Constraint Name Constraint
sale_order_date_order_conditional_required (((((state)::text = 'sale'::text) AND (date_order IS NOT NULL)) OR ((state)::text <> 'sale'::text)))

Relationships

Close relationships within degrees of separation