OrdersOnCountry
Fields
The following fields are defined in the OrdersOnCountry typed view
| Name |
Type |
Optional |
Read-only |
Max. length |
Precision |
Scale |
| CustomerId |
string (System.String) |
Yes |
|
5 |
0 |
0 |
| EmployeeId |
int (System.Int32) |
Yes |
|
0 |
10 |
0 |
| Freight |
decimal (System.Decimal) |
Yes |
|
0 |
19 |
4 |
| OrderDate |
datetime (System.DateTime) |
Yes |
|
0 |
0 |
0 |
| OrderId |
int (System.Int32) |
|
|
0 |
10 |
0 |
| RequiredDate |
datetime (System.DateTime) |
Yes |
|
0 |
0 |
0 |
| ShipAddress |
string (System.String) |
Yes |
|
60 |
0 |
0 |
| ShipCity |
string (System.String) |
Yes |
|
15 |
0 |
0 |
| ShipCountry |
string (System.String) |
Yes |
|
15 |
0 |
0 |
| ShipName |
string (System.String) |
Yes |
|
40 |
0 |
0 |
| ShippedDate |
datetime (System.DateTime) |
Yes |
|
0 |
0 |
0 |
| ShipVia |
int (System.Int32) |
Yes |
|
0 |
10 |
0 |
Mappings
Type of target: Stored procedure resultset
| Typed View Field |
Target field |
Nullable |
Type |
Length |
Precision |
Scale |
Type converter |
| CustomerId |
CustomerID |
Yes |
nchar |
5 |
0 |
0 |
|
| EmployeeId |
EmployeeID |
Yes |
int |
0 |
10 |
0 |
|
| Freight |
Freight |
Yes |
money |
0 |
19 |
4 |
|
| OrderDate |
OrderDate |
Yes |
datetime |
0 |
0 |
0 |
|
| OrderId |
OrderID |
|
int |
0 |
10 |
0 |
|
| RequiredDate |
RequiredDate |
Yes |
datetime |
0 |
0 |
0 |
|
| ShipAddress |
ShipAddress |
Yes |
nvarchar |
60 |
0 |
0 |
|
| ShipCity |
ShipCity |
Yes |
nvarchar |
15 |
0 |
0 |
|
| ShipCountry |
ShipCountry |
Yes |
nvarchar |
15 |
0 |
0 |
|
| ShipName |
ShipName |
Yes |
nvarchar |
40 |
0 |
0 |
|
| ShippedDate |
ShippedDate |
Yes |
datetime |
0 |
0 |
0 |
|
| ShipVia |
ShipVia |
Yes |
int |
0 |
10 |
0 |
|
Unmapped fields in target
| Target field |
Nullable |
Type |
Length |
Precision |
Scale |
| ShipRegion |
Yes |
nvarchar |
15 |
0 |
0 |
| ShipPostalCode |
Yes |
nvarchar |
10 |
0 |
0 |
Setting values
OrdersOnCountry (TypedView)
| Setting name |
Value |
| Typed view row base class name |
|
| Output type |
TypedDataTable |
CustomerId (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
EmployeeId (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
Freight (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
OrderDate (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
OrderId (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
RequiredDate (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
ShipAddress (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
ShipCity (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
ShipCountry (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
ShipName (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
ShippedDate (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
ShipVia (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
Attribute definitions per element
None.
Additional interface definitions per element
None.
Additional namespace definitions per element
None.