purchase_order


Description

Purchase Order

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('purchase_order_id_seq'::regclass)
account_move_purchase_order_rel.purchase_order_id account_move_purchase_order_rel_purchase_order_id_fkey C
bill_to_po_wizard.purchase_order_id bill_to_po_wizard_purchase_order_id_fkey N
purchase_order_line.order_id purchase_order_line_order_id_fkey C
purchase_order_stock_picking_rel.purchase_order_id purchase_order_stock_picking_rel_purchase_order_id_fkey C
partner_id int4 10 null
res_partner.id purchase_order_partner_id_fkey R

Vendor
dest_address_id int4 10 √ null
res_partner.id purchase_order_dest_address_id_fkey N

Dropship Address
currency_id int4 10 null
res_currency.id purchase_order_currency_id_fkey R

Currency
invoice_count int4 10 √ null

Bill Count
fiscal_position_id int4 10 √ null
account_fiscal_position.id purchase_order_fiscal_position_id_fkey N

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

Payment Terms
incoterm_id int4 10 √ null
account_incoterms.id purchase_order_incoterm_id_fkey N

Incoterm
user_id int4 10 √ null
res_users.id purchase_order_user_id_fkey N

Buyer
company_id int4 10 null
res_company.id purchase_order_company_id_fkey R

Company
create_uid int4 10 √ null
res_users.id purchase_order_create_uid_fkey N

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

Last Updated by
access_token varchar 2147483647 √ null

Security Token
name varchar 2147483647 null

Order Reference
priority varchar 2147483647 √ null

Priority
origin varchar 2147483647 √ null

Source Document
partner_ref varchar 2147483647 √ null

Vendor Reference
state varchar 2147483647 √ null

Status
invoice_status varchar 2147483647 √ null

Billing Status
notes text 2147483647 √ null

Terms and Conditions
amount_untaxed numeric 0 √ null

Untaxed Amount
amount_tax numeric 0 √ null

Taxes
amount_total numeric 0 √ null

Total
amount_total_cc numeric 0 √ null

Company Total
currency_rate numeric 0 √ null

Currency Rate
mail_reminder_confirmed bool 1 √ null

Reminder Confirmed
mail_reception_confirmed bool 1 √ null

Reception Confirmed
mail_reception_declined bool 1 √ null

Reception Declined
date_order timestamp 29,6 null

Order Deadline
date_approve timestamp 29,6 √ null

Confirmation Date
date_planned timestamp 29,6 √ null

Expected Arrival
date_calendar_start timestamp 29,6 √ null

Date Calendar Start
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
picking_type_id int4 10 null
stock_picking_type.id purchase_order_picking_type_id_fkey R

Deliver To
group_id int4 10 √ null
procurement_group.id purchase_order_group_id_fkey N

Procurement Group
incoterm_location varchar 2147483647 √ null

Incoterm Location
receipt_status varchar 2147483647 √ null

Receipt Status
effective_date timestamp 29,6 √ null

Arrival

Indexes

Constraint Name Type Sort Column(s)
purchase_order_pkey Primary key Asc id
purchase_order__company_id_index Performance Asc company_id
purchase_order__date_approve_index Performance Asc date_approve
purchase_order__date_order_index Performance Asc date_order
purchase_order__date_planned_index Performance Asc date_planned
purchase_order__name_index Performance Asc name
purchase_order__partner_id_index Performance Asc partner_id
purchase_order__priority_index Performance Asc priority
purchase_order__state_index Performance Asc state
purchase_order__user_id_index Performance Asc user_id

Relationships

Close relationships within degrees of separation