wizard |
Configure the rental of a product
Catalog: Odoo
Schema: rental
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table wizard are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
currency_id_label |
string |
|
☐ |
|
currency_id |
string |
|
☐ |
|
display_name |
string |
Display Name |
☐ |
|
duration_unit |
string |
Unit |
☑ |
|
duration |
int32 |
Duration |
☐ |
The duration unit is based on the unit of the rental pricing rule. |
id |
int32 |
ID |
☐ |
|
is_product_storable |
boolean |
Is Product Storable |
☐ |
|
lot_ids |
string |
|
☐ |
Only available serial numbers are suggested. |
pickup_date |
datetime |
Pickup |
☑ |
|
pricelist_id_label |
string |
|
☐ |
|
pricelist_id |
string |
|
☐ |
|
pricing_explanation |
string |
Price Computation |
☐ |
Helper text to understand rental price computation. |
pricing_id_label |
string |
|
☐ |
Best Pricing Rule based on duration |
pricing_id |
string |
|
☐ |
Best Pricing Rule based on duration |
product_id_label |
string |
|
☐ |
Product to rent (has to be rentable) |
product_id |
string |
|
☐ |
Product to rent (has to be rentable) |
product_uom_id |
string |
Product UoM |
☐ |
|
qty_available_during_period |
decimal |
Quantity available for given period (Stock - In Rent) |
☐ |
|
quantity |
decimal |
Quantity |
☑ |
|
rentable_lot_ids |
string |
|
☐ |
|
rentable_qty |
decimal |
Quantity available in stock for given period |
☐ |
|
rental_order_line_id_label |
string |
|
☐ |
|
rental_order_line_id |
string |
|
☐ |
|
rented_lot_ids |
string |
|
☐ |
|
rented_qty_during_period |
decimal |
Quantity reserved |
☐ |
Quantity reserved by other Rental lines during the given period |
return_date |
datetime |
Return |
☑ |
|
tracking |
string |
Tracking |
☐ |
Ensure the traceability of a storable product in your warehouse. |
unit_price |
decimal |
Unit Price |
☑ |
This price is based on the rental price rule that gives the cheapest price for requested duration. |
uom_id_label |
string |
|
☐ |
|
uom_id |
string |
|
☐ |
|
warehouse_id_label |
string |
|
☐ |
|
warehouse_id |
string |
|
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826