invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

order: Odoo itgen_odoo_order

read only per partition

  • Catálogo: Odoo
  • Esquema: purchase
  • Etiqueta: itgen_odoo_order

Orden de Compra

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla order. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos Label Required Marks Documentation
access_token varchar2 Security Token
access_url varchar2 Portal Access URL Customer Portal URL
access_warning varchar2 Access warning
activity_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
amount_tax numeric Taxes
amount_total numeric Total
amount_untaxed numeric Untaxed Amount
company_id varchar2
company_id_label varchar2
country_code varchar2 Country code The ISO country code in two chars.You can use this field for quick search.
create_date datetime Creado en
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
currency_rate numeric Tipo de cambio de la moneda Ratio between the purchase order currency and the company currency
date_approve datetime Confirmation Date
date_calendar_start datetime Date Calendar Start
date_order datetime Order Deadline Depicts the date within which the Quotation should be confirmed and converted into a purchase order.
date_planned datetime Expected Arrival Delivery date promised by vendor.This date is used to determine expected arrival of products.
default_location_dest_id_usage varchar2 Destination Location Type Technical field used to display the Drop Ship Address
dest_address_id varchar2 Put an address if you want to deliver directly from the vendor to the customer.Otherwise, keep empty to deliver to your own company.
dest_address_id_label varchar2 Put an address if you want to deliver directly from the vendor to the customer.Otherwise, keep empty to deliver to your own company.
display_name varchar2 Nombre para mostrar
effective_date datetime Arrival Completion date of the first receipt order.
fiscal_position_id varchar2
fiscal_position_id_label varchar2
group_id varchar2
group_id_label varchar2
has_message boolean Has Message
id int32 ID
incoming_picking_count int32 Incoming Shipment count
incoterm_id varchar2 International Commercial Terms are a series of predefined commercial terms used in international transactions.
incoterm_id_label varchar2 International Commercial Terms are a series of predefined commercial terms used in international transactions.
incoterm_location varchar2 Incoterm Location
invoice_count int32 Bill Count
invoice_ids varchar2
invoice_status varchar2 Estado de facturación
is_shipped boolean Is Shipped
mail_reception_confirmed boolean Reception Confirmed True if PO reception is confirmed by the vendor.
mail_reminder_confirmed boolean Reminder Confirmed True if the reminder email is confirmed by the vendor.
message_attachment_count int32 Número de archivos adjuntos
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Número de acciones Number of messages which requires an action
message_partner_ids varchar2
mrp_production_count int32 Count of MO Source
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Referencia del pedido
notes varchar2 Terms and Conditions
on_time_rate numeric On-Time Delivery Rate Over the past 12 months; the number of products received on time divided by the number of ordered products.
order_line varchar2
origin varchar2 Source Document Reference of the document that generated this purchase order request (e.g. a sales order)
partner_id varchar2 You can find a vendor by its Name, TIN, Email or Internal Reference.
partner_id_label varchar2 You can find a vendor by its Name, TIN, Email or Internal Reference.
partner_ref varchar2 Vendor Reference Reference of the sales order or bid sent by the vendor.It's used to do the matching when you receive the products as this reference is usually written on the delivery order sent by your vendor.
payment_term_id varchar2
payment_term_id_label varchar2
picking_ids varchar2
picking_type_id varchar2 This will determine operation type of incoming shipment
picking_type_id_label varchar2 This will determine operation type of incoming shipment
priority varchar2 Priority
product_id varchar2
product_id_label varchar2
receipt_reminder_email boolean Receipt Reminder Email Automatically send a confirmation email to the vendor X days before the expected receipt date, asking him to confirm the exact date.
receipt_status varchar2 Estado de la recepción
reminder_date_before_receipt int32 Days Before Receipt Number of days to send reminder email before the promised receipt date
sale_order_count int32 Number of Source Sale
state varchar2 Status
tax_country_id varchar2 Technical field to filter the available taxes depending on the fiscal country and fiscal position.
tax_country_id_label varchar2 Technical field to filter the available taxes depending on the fiscal country and fiscal position.
tax_totals varbinary Tax Totals
user_id varchar2
user_id_label varchar2
website_message_ids varchar2 Website communication history
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: