account: Odoo itgen_odoo_account
read only per partition
- Catalog:
Odoo - Schema:
amazon - Label: itgen_odoo_account
Amazon Account
Can only retrieve data.
Table Columns
The columns of the table account 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 |
|---|---|---|---|---|---|
access_ |
varchar2 |
LWA Access Token | The short-lived token used to query Amazon API on behalf of a seller. | ||
access_ |
datetime |
The moment at which the token becomes invalid. | |||
active |
boolean |
Active | If made inactive, this account will no longer be synchronized with Amazon. | ||
active_ |
varchar2 |
The marketplaces this account sells on. | |||
available_ |
varchar2 |
The marketplaces this account has access to. | |||
aws_ |
varchar2 |
AWS Access Key | The short-lived key used to identify the assumed ARN role on AWS. | ||
aws_ |
datetime |
The moment at which the AWS credentials become invalid. | |||
aws_ |
varchar2 |
AWS Secret Key | The short-lived key used to verify the access to the assumed ARN role on AWS. | ||
aws_ |
varchar2 |
AWS Session Token | The short-lived token used to query the SP-API with the assumed ARN role on AWS. | ||
base_ |
varchar2 |
The original sign-up marketplace of this account. Used for authentication only. | |||
base_ |
varchar2 |
The original sign-up marketplace of this account. Used for authentication only. | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
id |
int32 |
ID | |||
is_ |
boolean |
Is Follow Up Displayed | |||
last_ |
datetime |
Last Orders Sync | The last synchronization date for orders placed on this account. Orders whose status has not changed since this date will not be created nor updated in Odoo. | ||
location_ |
varchar2 |
The location of the stock managed by Amazon under the Amazon Fulfillment program. | |||
location_ |
varchar2 |
The location of the stock managed by Amazon under the Amazon Fulfillment program. | |||
name |
varchar2 |
Name | The user-defined name of the account. | ||
offer_ |
int32 |
Offer Count | |||
order_ |
int32 |
Order Count | |||
refresh_ |
varchar2 |
LWA Refresh Token | The long-lived token that can be exchanged for a new access token. | ||
restricted_ |
varchar2 |
Restricted Data Token | The short-lived token used instead of the LWA Access Token to access restricted data | ||
restricted_ |
datetime |
The moment at which the Restricted Data Token becomes invalid. | |||
seller_ |
varchar2 |
Seller Key | |||
team_ |
varchar2 |
The Sales Team assigned to Amazon orders for reporting | |||
team_ |
varchar2 |
The Sales Team assigned to Amazon orders for reporting | |||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
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: