request_item |
Signature Request Item
Catalog: Odoo
Schema: sign
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 request_item are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
access_token |
string |
Security Token |
☑ |
|
access_url |
string |
Portal Access URL |
☐ |
Customer Portal URL |
access_via_link |
boolean |
Accessed Through Token |
☐ |
|
access_warning |
string |
Access warning |
☐ |
|
change_authorized |
boolean |
Change Authorized |
☐ |
If checked, recipient of a document with this role can be changed after having sent the request. Useful to replace a signatory who is out of office, etc. |
color |
int32 |
Color |
☐ |
|
communication_company_id_label |
string |
|
☐ |
|
communication_company_id |
string |
|
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
display_name |
string |
Display Name |
☐ |
|
frame_hash |
string |
Frame Hash |
☐ |
|
id |
int32 |
ID |
☐ |
|
is_mail_sent |
boolean |
Is Mail Sent |
☐ |
The signature mail has been sent. |
latitude |
decimal |
Latitude |
☐ |
|
longitude |
decimal |
Longitude |
☐ |
|
mail_sent_order |
int32 |
Mail Sent Order |
☐ |
|
partner_id_label |
string |
|
☐ |
|
partner_id |
string |
|
☐ |
|
reference |
string |
Document Name |
☐ |
This is how the document will be named in the mail |
role_id_label |
string |
|
☐ |
|
role_id |
string |
|
☐ |
|
sign_item_value_ids |
string |
|
☐ |
|
sign_request_id_label |
string |
|
☐ |
|
sign_request_id |
string |
|
☐ |
|
signature |
byte[] |
Signature |
☐ |
|
signed_without_extra_auth |
boolean |
Signed Without Extra Authentication |
☐ |
|
signer_email |
string |
☐ |
|
|
signing_date |
datetime |
Signed on |
☐ |
|
sms_number |
string |
Mobile |
☐ |
|
sms_token |
string |
SMS Token |
☐ |
|
state |
string |
State |
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826