order_template: Odoo itgen_odoo_order_template
read only per partition
- Catalog:
Odoo - Schema:
sale - Label: itgen_odoo_order_template
Quotation Template
Can only retrieve data.
Table Columns
The columns of the table order_template 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 |
|---|---|---|---|---|---|
active |
boolean |
Active | If unchecked, it will allow you to hide the quotation template without removing it. | ||
auto_ |
int32 |
Automatic Closing | Unpaid subscription after the due date majored by this number of days will be automatically closed by the subscriptions expiration scheduled action. If the chosen payment method has failed to renew the subscription after this time, the subscription is automatically closed. | ||
color |
int32 |
Color | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
id |
int32 |
ID | |||
invoice_ |
varchar2 |
||||
invoice_ |
varchar2 |
||||
is_ |
boolean |
Is Subscription | |||
journal_ |
varchar2 |
If set, subscriptions with this template will invoice in this journal; otherwise the sales journal with the lowest sequence is used. | |||
journal_ |
varchar2 |
If set, subscriptions with this template will invoice in this journal; otherwise the sales journal with the lowest sequence is used. | |||
mail_ |
varchar2 |
This e-mail template will be sent on confirmation. Leave empty to send nothing. | |||
mail_ |
varchar2 |
This e-mail template will be sent on confirmation. Leave empty to send nothing. | |||
name |
varchar2 |
Quotation Template | |||
note |
varchar2 |
Terms and conditions | |||
number_ |
int32 |
Quotation Duration | Number of days for the validity date computation of the quotation | ||
recurrence_ |
varchar2 |
||||
recurrence_ |
varchar2 |
||||
recurring_ |
varchar2 |
Duration | |||
recurring_ |
int32 |
End After | |||
recurring_ |
varchar2 |
Recurring Rule Type | Contract duration | ||
require_ |
boolean |
Online Payment | Request an online payment to the customer in order to confirm orders automatically. | ||
require_ |
boolean |
Online Signature | Request a online signature to the customer in order to confirm orders automatically. | ||
sale_ |
varchar2 |
||||
sale_ |
varchar2 |
||||
user_ |
boolean |
Self closable | If checked, the user will be able to close his account from the frontend | ||
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: