pos_order


Description

Point of Sale Orders

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('pos_order_id_seq'::regclass)
account_move.reversed_pos_order_id account_move_reversed_pos_order_id_fkey N
account_payment.pos_order_id account_payment_pos_order_id_fkey N
payment_transaction.pos_order_id payment_transaction_pos_order_id_fkey N
pos_order_line.order_id pos_order_line_order_id_fkey C
pos_payment.pos_order_id pos_payment_pos_order_id_fkey C
procurement_group.pos_order_id procurement_group_pos_order_id_fkey N
stock_picking.pos_order_id stock_picking_pos_order_id_fkey N
user_id int4 10 √ null
res_users.id pos_order_user_id_fkey N

Employee
company_id int4 10 null
res_company.id pos_order_company_id_fkey R

Company
pricelist_id int4 10 √ null
product_pricelist.id pos_order_pricelist_id_fkey N

Pricelist
partner_id int4 10 √ null
res_partner.id pos_order_partner_id_fkey N

Customer
sequence_number int4 10 √ null

Sequence Number
session_id int4 10 null
pos_session.id pos_order_session_id_fkey R

Session
config_id int4 10 √ null
pos_config.id pos_order_config_id_fkey N

Point of Sale
account_move int4 10 √ null
account_move.id pos_order_account_move_fkey N

Invoice
procurement_group_id int4 10 √ null
procurement_group.id pos_order_procurement_group_id_fkey N

Procurement Group
nb_print int4 10 √ null

Number of Print
sale_journal int4 10 √ null
account_journal.id pos_order_sale_journal_fkey R

Sales Journal
fiscal_position_id int4 10 √ null
account_fiscal_position.id pos_order_fiscal_position_id_fkey N

Fiscal Position
create_uid int4 10 √ null
res_users.id pos_order_create_uid_fkey N

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

Last Updated by
access_token varchar 2147483647 √ null

Security Token
name varchar 2147483647 null

Order Ref
last_order_preparation_change varchar 2147483647 √ null

Last preparation change
state varchar 2147483647 √ null

Status
floating_order_name varchar 2147483647 √ null

Order Name
pos_reference varchar 2147483647 √ null

Receipt Number
ticket_code varchar 2147483647 √ null

Ticket Code
uuid varchar 2147483647 √ null

Uuid
email varchar 2147483647 √ null

Email
mobile varchar 2147483647 √ null

Mobile
shipping_date date 13 √ null

Shipping Date
general_note text 2147483647 √ null

General Note
amount_difference numeric 0 √ null

Difference
amount_tax numeric 0 null

Taxes
amount_total numeric 0 null

Total
amount_paid numeric 0 null

Paid
amount_return numeric 0 null

Returned
currency_rate numeric 0 √ null

Currency Rate
tip_amount numeric 0 √ null

Tip Amount
to_invoice bool 1 √ null

To invoice
is_tipped bool 1 √ null

Is this already tipped?
has_deleted_line bool 1 √ null

Has Deleted Line
date_order timestamp 29,6 √ null

Date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
next_online_payment_amount numeric 0 √ null

Next online payment amount to pay
table_id int4 10 √ null
restaurant_table.id pos_order_table_id_fkey N

Table
customer_count int4 10 √ null

Guests
takeaway bool 1 √ null

Take Away
table_stand_number varchar 2147483647 √ null

Table Stand Number
use_self_order_online_payment bool 1 √ null

Use Self Order Online Payment

Indexes

Constraint Name Type Sort Column(s)
pos_order_pkey Primary key Asc id
pos_order__account_move_index Performance Asc account_move
pos_order__company_id_index Performance Asc company_id
pos_order__date_order_index Performance Asc date_order
pos_order__partner_id_index Performance Asc partner_id
pos_order__pos_reference_index Performance Asc pos_reference
pos_order__session_id_index Performance Asc session_id
pos_order__state_index Performance Asc state
pos_order__table_id_index Performance Asc table_id
pos_order_uuid_unique Must be unique Asc uuid

Relationships

Close relationships within degrees of separation