order: Odoo itgen_odoo_order
read only per partition
- Catalog:
Odoo - Schema:
pos - Label: itgen_odoo_order
Point of Sale Orders
Can only retrieve data.
Table Columns
The columns of the table order are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
access_ |
varchar2 |
Security Token | |||
access_ |
varchar2 |
Portal Access URL | Customer Portal URL | ||
access_ |
varchar2 |
Access warning | |||
account_ |
varchar2 |
||||
account_ |
varchar2 |
||||
amount_ |
numeric |
Paid | |||
amount_ |
numeric |
Returned | |||
amount_ |
numeric |
Taxes | |||
amount_ |
numeric |
Total | |||
cashier |
varchar2 |
Cashier | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
config_ |
varchar2 |
||||
config_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
crm_ |
varchar2 |
||||
crm_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
numeric |
Currency Rate | The rate of the currency to the currency of rate applicable at the date of the order | ||
date_ |
datetime |
Date | |||
display_ |
varchar2 |
Display Name | |||
employee_ |
varchar2 |
Person who uses the cash register. It can be a reliever, a student or an interim employee. | |||
employee_ |
varchar2 |
Person who uses the cash register. It can be a reliever, a student or an interim employee. | |||
failed_ |
boolean |
Failed Pickings | |||
fiscal_ |
varchar2 |
||||
fiscal_ |
varchar2 |
||||
has_ |
boolean |
Has Refundable Lines | |||
id |
int32 |
ID | |||
is_ |
boolean |
Is Invoiced | |||
is_ |
boolean |
Is Refunded | |||
is_ |
boolean |
Is this already tipped? | |||
is_ |
boolean |
Is Total Cost Computed | Allows to know if all the total cost of the order lines have already been computed | ||
lines |
varchar2 |
||||
margin |
numeric |
Margin | |||
margin_ |
numeric |
Margin (%) | |||
name |
varchar2 |
Order Ref | |||
nb_ |
int32 |
Number of Print | |||
note |
varchar2 |
Internal Notes | |||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
payment_ |
varchar2 |
||||
picking_ |
int32 |
Picking Count | |||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
pos_ |
varchar2 |
Receipt Number | |||
pricelist_ |
varchar2 |
||||
pricelist_ |
varchar2 |
||||
procurement_ |
varchar2 |
||||
procurement_ |
varchar2 |
||||
refund_ |
int32 |
Number of Refund Orders | |||
refunded_ |
varchar2 |
||||
refunded_ |
int32 |
Refunded Orders Count | |||
sale_ |
varchar2 |
Accounting journal used to post POS session journal entries and POS invoice payments. | |||
sale_ |
varchar2 |
Accounting journal used to post POS session journal entries and POS invoice payments. | |||
sale_ |
int32 |
Sale Order Count | |||
sequence_ |
int32 |
Sequence Number | A session-unique sequence number for the order | ||
session_ |
varchar2 |
||||
session_ |
varchar2 |
||||
session_ |
varchar2 |
||||
session_ |
varchar2 |
||||
shipping_ |
datetime |
Shipping Date | |||
state |
varchar2 |
Status | |||
tip_ |
numeric |
Tip Amount | |||
to_ |
boolean |
To invoice | |||
user_ |
varchar2 |
Person who uses the cash register. It can be a reliever, a student or an interim employee. | |||
user_ |
varchar2 |
Person who uses the cash register. It can be a reliever, a student or an interim employee. | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: