invantive documentation
Forum di supporto InvantiveAccedi / Registrati

order: Odoo itgen_odoo_order

read only per partition

  • Catalogo: Odoo
  • Schema: pos
  • Etichetta: itgen_odoo_order

Point of Sale Orders

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella order. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
access_token varchar2 Security Token
access_url varchar2 Portal Access URL Customer Portal URL
access_warning varchar2 Access warning
account_move varchar2
account_move_label varchar2
amount_paid numeric Paid
amount_return numeric Returned
amount_tax numeric Taxes
amount_total numeric Total
cashier varchar2 Cashier
company_id varchar2
company_id_label varchar2
config_id varchar2
config_id_label varchar2
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
crm_team_id varchar2
crm_team_id_label varchar2
currency_id varchar2
currency_id_label varchar2
currency_rate numeric Tasso di cambio della valuta The rate of the currency to the currency of rate applicable at the date of the order
date_order datetime Date
display_name varchar2 Nome visualizzato
employee_id varchar2 Person who uses the cash register.It can be a reliever, a student or an interim employee.
employee_id_label varchar2 Person who uses the cash register.It can be a reliever, a student or an interim employee.
failed_pickings boolean Failed Pickings
fiscal_position_id varchar2
fiscal_position_id_label varchar2
has_refundable_lines boolean Has Refundable Lines
id int32 ID
is_invoiced boolean È stato fatturato
is_refunded boolean Is Refunded
is_tipped boolean Is this already tipped?
is_total_cost_computed 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_percent numeric Margin (%)
name varchar2 Order Ref
nb_print int32 Number of Print
note varchar2 Note interne
partner_id varchar2
partner_id_label varchar2
payment_ids varchar2
picking_count int32 Picking Count
picking_ids varchar2
picking_type_id varchar2
picking_type_id_label varchar2
pos_reference varchar2 Numero di ricevuta
pricelist_id varchar2
pricelist_id_label varchar2
procurement_group_id varchar2
procurement_group_id_label varchar2
refund_orders_count int32 Number of Refund Orders
refunded_order_ids varchar2
refunded_orders_count int32 Refunded Orders Count
sale_journal varchar2 Accounting journal used to post POS session journal entries and POS invoice payments.
sale_journal_label varchar2 Accounting journal used to post POS session journal entries and POS invoice payments.
sale_order_count int32 Sale Order Count
sequence_number int32 Numero di sequenza A session-unique sequence number for the order
session_id varchar2
session_id_label varchar2
session_move_id varchar2
session_move_id_label varchar2
shipping_date datetime Data di spedizione
state varchar2 Status
tip_amount numeric Tip Amount
to_invoice boolean To invoice
user_id varchar2 Person who uses the cash register.It can be a reliever, a student or an interim employee.
user_id_label varchar2 Person who uses the cash register.It can be a reliever, a student or an interim employee.
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: