Srl |
Catalog |
Schema |
Name |
Type |
Remark |
Processing Status |
1 |
|
public |
crm_activity_report |
VIEW |
|
Success |
|
No |
Column Name |
Type |
Size |
Decimals |
Nullable |
1 |
id |
int4 |
10 |
0 |
YES |
2 |
subtype_id |
int4 |
10 |
0 |
YES |
3 |
mail_activity_type_id |
int4 |
10 |
0 |
YES |
4 |
author_id |
int4 |
10 |
0 |
YES |
5 |
date |
timestamp |
29 |
6 |
YES |
6 |
subject |
varchar |
2147483647 |
0 |
YES |
7 |
lead_id |
int4 |
10 |
0 |
YES |
8 |
user_id |
int4 |
10 |
0 |
YES |
9 |
team_id |
int4 |
10 |
0 |
YES |
10 |
country_id |
int4 |
10 |
0 |
YES |
11 |
company_id |
int4 |
10 |
0 |
YES |
12 |
stage_id |
int4 |
10 |
0 |
YES |
13 |
partner_id |
int4 |
10 |
0 |
YES |
14 |
lead_type |
varchar |
2147483647 |
0 |
YES |
15 |
active |
bool |
1 |
0 |
YES |
16 |
probability |
float8 |
17 |
17 |
YES |
| |
Success |
2 |
|
public |
purchase_bill_union |
VIEW |
|
Success |
|
No |
Column Name |
Type |
Size |
Decimals |
Nullable |
1 |
id |
int4 |
10 |
0 |
YES |
2 |
name |
varchar |
2147483647 |
0 |
YES |
3 |
reference |
varchar |
2147483647 |
0 |
YES |
4 |
partner_id |
int4 |
10 |
0 |
YES |
5 |
date |
date |
13 |
0 |
YES |
6 |
amount |
numeric |
131089 |
0 |
YES |
7 |
currency_id |
int4 |
10 |
0 |
YES |
8 |
company_id |
int4 |
10 |
0 |
YES |
9 |
vendor_bill_id |
int4 |
10 |
0 |
YES |
10 |
purchase_order_id |
int4 |
10 |
0 |
YES |
| |
Success |
3 |
|
public |
purchase_report |
VIEW |
|
Success |
|
No |
Column Name |
Type |
Size |
Decimals |
Nullable |
1 |
id |
int4 |
10 |
0 |
YES |
2 |
date_order |
timestamp |
29 |
6 |
YES |
3 |
state |
varchar |
2147483647 |
0 |
YES |
4 |
date_approve |
date |
13 |
0 |
YES |
5 |
dest_address_id |
int4 |
10 |
0 |
YES |
6 |
partner_id |
int4 |
10 |
0 |
YES |
7 |
user_id |
int4 |
10 |
0 |
YES |
8 |
company_id |
int4 |
10 |
0 |
YES |
9 |
fiscal_position_id |
int4 |
10 |
0 |
YES |
10 |
product_id |
int4 |
10 |
0 |
YES |
11 |
product_tmpl_id |
int4 |
10 |
0 |
YES |
12 |
category_id |
int4 |
10 |
0 |
YES |
13 |
currency_id |
int4 |
10 |
0 |
YES |
14 |
product_uom |
int4 |
10 |
0 |
YES |
15 |
unit_quantity |
numeric |
131089 |
0 |
YES |
16 |
delay |
float8 |
17 |
17 |
YES |
17 |
delay_pass |
float8 |
17 |
17 |
YES |
18 |
nbr_lines |
int8 |
19 |
0 |
YES |
19 |
price_total |
numeric |
16 |
2 |
YES |
20 |
negociation |
numeric |
16 |
2 |
YES |
21 |
price_standard |
numeric |
16 |
2 |
YES |
22 |
price_average |
numeric |
16 |
2 |
YES |
23 |
country_id |
int4 |
10 |
0 |
YES |
24 |
commercial_partner_id |
int4 |
10 |
0 |
YES |
25 |
account_analytic_id |
int4 |
10 |
0 |
YES |
26 |
weight |
numeric |
131089 |
0 |
YES |
27 |
volume |
float8 |
17 |
17 |
YES |
28 |
picking_type_id |
int4 |
10 |
0 |
YES |
| |
Success |
4 |
|
public |
report_all_channels_sales |
VIEW |
|
Success |
|
No |
Column Name |
Type |
Size |
Decimals |
Nullable |
1 |
id |
int4 |
10 |
0 |
YES |
2 |
name |
varchar |
2147483647 |
0 |
YES |
3 |
partner_id |
int4 |
10 |
0 |
YES |
4 |
product_id |
int4 |
10 |
0 |
YES |
5 |
product_tmpl_id |
int4 |
10 |
0 |
YES |
6 |
date_order |
timestamp |
29 |
6 |
YES |
7 |
user_id |
int4 |
10 |
0 |
YES |
8 |
categ_id |
int4 |
10 |
0 |
YES |
9 |
company_id |
int4 |
10 |
0 |
YES |
10 |
price_total |
numeric |
131089 |
0 |
YES |
11 |
pricelist_id |
int4 |
10 |
0 |
YES |
12 |
analytic_account_id |
int4 |
10 |
0 |
YES |
13 |
country_id |
int4 |
10 |
0 |
YES |
14 |
team_id |
int4 |
10 |
0 |
YES |
15 |
price_subtotal |
numeric |
131089 |
0 |
YES |
16 |
product_qty |
numeric |
131089 |
0 |
YES |
| |
Success |
5 |
|
public |
report_pos_order |
VIEW |
|
Success |
|
No |
Column Name |
Type |
Size |
Decimals |
Nullable |
1 |
id |
int4 |
10 |
0 |
YES |
2 |
nbr_lines |
int8 |
19 |
0 |
YES |
3 |
date |
timestamp |
29 |
6 |
YES |
4 |
product_qty |
numeric |
131089 |
0 |
YES |
5 |
price_sub_total |
numeric |
131089 |
0 |
YES |
6 |
price_total |
numeric |
131089 |
0 |
YES |
7 |
total_discount |
numeric |
131089 |
0 |
YES |
8 |
average_price |
numeric |
131089 |
0 |
YES |
9 |
delay_validation |
int8 |
19 |
0 |
YES |
10 |
order_id |
int4 |
10 |
0 |
YES |
11 |
partner_id |
int4 |
10 |
0 |
YES |
12 |
state |
varchar |
2147483647 |
0 |
YES |
13 |
user_id |
int4 |
10 |
0 |
YES |
14 |
location_id |
int4 |
10 |
0 |
YES |
15 |
company_id |
int4 |
10 |
0 |
YES |
16 |
journal_id |
int4 |
10 |
0 |
YES |
17 |
product_id |
int4 |
10 |
0 |
YES |
18 |
product_categ_id |
int4 |
10 |
0 |
YES |
19 |
product_tmpl_id |
int4 |
10 |
0 |
YES |
20 |
config_id |
int4 |
10 |
0 |
YES |
21 |
pos_categ_id |
int4 |
10 |
0 |
YES |
22 |
pricelist_id |
int4 |
10 |
0 |
YES |
23 |
session_id |
int4 |
10 |
0 |
YES |
24 |
invoiced |
bool |
1 |
0 |
YES |
| |
Success |
6 |
|
public |
report_stock_forecast |
VIEW |
|
Success |
|
No |
Column Name |
Type |
Size |
Decimals |
Nullable |
1 |
id |
int4 |
10 |
0 |
YES |
2 |
product_id |
int4 |
10 |
0 |
YES |
3 |
date |
timestamptz |
35 |
6 |
YES |
4 |
quantity |
float8 |
17 |
17 |
YES |
5 |
cumulative_quantity |
float8 |
17 |
17 |
YES |
6 |
company_id |
int4 |
10 |
0 |
YES |
| |
Success |
7 |
|
public |
sale_report |
VIEW |
|
Success |
|
No |
Column Name |
Type |
Size |
Decimals |
Nullable |
1 |
id |
int4 |
10 |
0 |
YES |
2 |
product_id |
int4 |
10 |
0 |
YES |
3 |
product_uom |
int4 |
10 |
0 |
YES |
4 |
product_uom_qty |
numeric |
131089 |
0 |
YES |
5 |
qty_delivered |
numeric |
131089 |
0 |
YES |
6 |
qty_invoiced |
numeric |
131089 |
0 |
YES |
7 |
qty_to_invoice |
numeric |
131089 |
0 |
YES |
8 |
price_total |
numeric |
131089 |
0 |
YES |
9 |
price_subtotal |
numeric |
131089 |
0 |
YES |
10 |
untaxed_amount_to_invoice |
numeric |
131089 |
0 |
YES |
11 |
untaxed_amount_invoiced |
numeric |
131089 |
0 |
YES |
12 |
nbr |
int8 |
19 |
0 |
YES |
13 |
name |
varchar |
2147483647 |
0 |
YES |
14 |
date |
timestamp |
29 |
6 |
YES |
15 |
confirmation_date |
timestamp |
29 |
6 |
YES |
16 |
state |
varchar |
2147483647 |
0 |
YES |
17 |
partner_id |
int4 |
10 |
0 |
YES |
18 |
user_id |
int4 |
10 |
0 |
YES |
19 |
company_id |
int4 |
10 |
0 |
YES |
20 |
delay |
float8 |
17 |
17 |
YES |
21 |
categ_id |
int4 |
10 |
0 |
YES |
22 |
pricelist_id |
int4 |
10 |
0 |
YES |
23 |
analytic_account_id |
int4 |
10 |
0 |
YES |
24 |
team_id |
int4 |
10 |
0 |
YES |
25 |
product_tmpl_id |
int4 |
10 |
0 |
YES |
26 |
country_id |
int4 |
10 |
0 |
YES |
27 |
commercial_partner_id |
int4 |
10 |
0 |
YES |
28 |
weight |
numeric |
131089 |
0 |
YES |
29 |
volume |
float8 |
17 |
17 |
YES |
30 |
discount |
numeric |
131089 |
0 |
YES |
31 |
discount_amount |
numeric |
131089 |
0 |
YES |
32 |
order_id |
int4 |
10 |
0 |
YES |
33 |
warehouse_id |
int4 |
10 |
0 |
YES |
| |
Success |