---
title: "order_template (Odoo)"
description: "itgen_odoo_order_template"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.sale.order_template
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.sale.order_template
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# 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_close_limit` | `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_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `invoice_mail_template_id` | `varchar2` |  | [ ] |  |  |
| `invoice_mail_template_id_label` | `varchar2` |  | [ ] |  |  |
| `is_subscription` | `boolean` | Is Subscription | [ ] |  |  |
| `journal_id` | `varchar2` |  | [ ] |  | If set, subscriptions with this template will invoice in this journal; otherwise the sales journal with the lowest sequence is used. |
| `journal_id_label` | `varchar2` |  | [ ] |  | If set, subscriptions with this template will invoice in this journal; otherwise the sales journal with the lowest sequence is used. |
| `mail_template_id` | `varchar2` |  | [ ] |  | This e-mail template will be sent on confirmation. Leave empty to send nothing. |
| `mail_template_id_label` | `varchar2` |  | [ ] |  | This e-mail template will be sent on confirmation. Leave empty to send nothing. |
| `name` | `varchar2` | Quotation Template | [x] |  |  |
| `note` | `varchar2` | Terms and conditions | [ ] |  |  |
| `number_of_days` | `int32` | Quotation Duration | [ ] |  | Number of days for the validity date computation of the quotation |
| `recurrence_id` | `varchar2` |  | [ ] |  |  |
| `recurrence_id_label` | `varchar2` |  | [ ] |  |  |
| `recurring_rule_boundary` | `varchar2` | Duration | [ ] |  |  |
| `recurring_rule_count` | `int32` | End After | [ ] |  |  |
| `recurring_rule_type` | `varchar2` | Recurring Rule Type | [ ] |  | Contract duration |
| `require_payment` | `boolean` | Online Payment | [ ] |  | Request an online payment to the customer in order to confirm orders automatically. |
| `require_signature` | `boolean` | Online Signature | [ ] |  | Request a online signature to the customer in order to confirm orders automatically. |
| `sale_order_template_line_ids` | `varchar2` |  | [ ] |  |  |
| `sale_order_template_option_ids` | `varchar2` |  | [ ] |  |  |
| `user_closable` | `boolean` | Self closable | [ ] |  | If checked, the user will be able to close his account from the frontend |
| `write_date` | `datetime` | Last Updated on | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Odoo](/en/release-notes/drivers?driver=odoo)

