invantive documentation
Invantive Support ForumsLog In / Sign Up

subscription_report: Odoo itgen_odoo_subscription_report

read only per partition

  • Catalog: Odoo
  • Schema: sale
  • Label: itgen_odoo_subscription_report

Subscription Analysis

Can only retrieve data.

Table Columns

The columns of the table subscription_report 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
analytic_account_id varchar2
analytic_account_id_label varchar2
categ_id varchar2
categ_id_label varchar2
close_reason_id varchar2
close_reason_id_label varchar2
commercial_partner_id varchar2
commercial_partner_id_label varchar2
company_id varchar2
company_id_label varchar2
country_id varchar2
country_id_label varchar2
date_order datetime Order Date
display_name varchar2 Display Name
end_date datetime End Date
first_contract_date datetime First contract date
health varchar2 Health
id int32 ID
industry_id varchar2
industry_id_label varchar2
name varchar2 Name
next_invoice_date datetime Next Invoice Date
origin_order_id varchar2
origin_order_id_label varchar2
partner_id varchar2
partner_id_label varchar2
pricelist_id varchar2
pricelist_id_label varchar2
product_id varchar2
product_id_label varchar2
product_tmpl_id varchar2
product_tmpl_id_label varchar2
product_uom varchar2
product_uom_label varchar2
quantity numeric Quantity
recurrence_id varchar2
recurrence_id_label varchar2
recurring_monthly numeric Monthly Recurring Revenue
recurring_total numeric Recurring Amount
recurring_yearly numeric Yearly Recurring Revenue
stage_category varchar2 Stage Category
stage_id varchar2
stage_id_label varchar2
state varchar2 Status
team_id varchar2
team_id_label varchar2
template_id varchar2
template_id_label varchar2
to_renew boolean To Renew
user_id varchar2
user_id_label varchar2

Release Notes

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