| CrossTab |
1996 |
BIGINT |
|
1996 |
| |
1997 |
BIGINT |
|
1997 |
| |
1998 |
BIGINT |
|
1998 |
| |
All |
BIGINT |
|
All |
| |
Country |
LONGVARCHAR |
|
Country |
| |
Name |
LONGVARCHAR |
|
Name |
| Customers union All |
CompanyName |
VARCHAR |
Customers (Table) |
CompanyName |
| EmployeesList |
Birth |
TIMESTAMP |
Employees (Table) |
BirthDate |
| |
First name |
VARCHAR |
Employees (Table) |
FirstName |
| |
Home phone |
VARCHAR |
Employees (Table) |
HomePhone |
| |
Last name |
|
|
'<a id="' || "Employees"."EmployeeID" || '">' || "Employees"."LastName" || '</a>' |
| |
Manager |
|
|
'<a href="#' || "ReportingTo"."EmployeeID" || '">' || "ReportingTo"."LastName" || '</a>' |
| |
Phone |
INTEGER |
Employees (Table) |
Extension |
| |
Title |
VARCHAR |
Employees (Table) |
Title |
| Orders_CalculatedField |
OrderDate |
TIMESTAMP |
Orders (Table) |
OrderDate |
| |
OrderID |
BIGINT |
Orders (Table) |
OrderID |
| |
ShipAddress |
VARCHAR |
Orders (Table) |
ShipAddress |
| |
ShipCity |
VARCHAR |
Orders (Table) |
ShipCity |
| |
SumOfDetails |
|
|
SUM( "Order Details"."UnitPrice" * "Order Details"."Quantity" * ( 1 - "Order Details"."Discount" ) ) |
| Query1 |
1997Q1 |
DOUBLE |
|
1997Q1 |
| |
1997Q2 |
DOUBLE |
|
1997Q2 |
| |
1997Q3 |
DOUBLE |
|
1997Q3 |
| |
1997Q4 |
DOUBLE |
|
1997Q4 |
| |
All |
DOUBLE |
|
All |
| |
Customer |
VARCHAR |
SYSTEM_SUBQUERY |
Customer |
| |
Name |
VARCHAR |
SYSTEM_SUBQUERY |
Name |
