Invoices
Fields
The following fields are defined in the Invoices typed view
| Name |
Type |
Optional |
Read-only |
Max. length |
Precision |
Scale |
| Address |
string (System.String) |
Yes |
|
60 |
0 |
0 |
| City |
string (System.String) |
Yes |
|
15 |
0 |
0 |
| Country |
string (System.String) |
Yes |
|
15 |
0 |
0 |
| CustomerId |
string (System.String) |
Yes |
|
5 |
0 |
0 |
| CustomerName |
string (System.String) |
|
|
40 |
0 |
0 |
| Discount |
single (System.Single) |
|
|
0 |
0 |
0 |
| ExtendedPrice |
decimal (System.Decimal) |
Yes |
|
0 |
19 |
4 |
| Freight |
decimal (System.Decimal) |
Yes |
|
0 |
19 |
4 |
| OrderDate |
datetime (System.DateTime) |
Yes |
|
0 |
0 |
0 |
| OrderId |
int (System.Int32) |
|
|
0 |
0 |
0 |
| PostalCode |
string (System.String) |
Yes |
|
10 |
0 |
0 |
| ProductId |
int (System.Int32) |
|
|
0 |
0 |
0 |
| ProductName |
string (System.String) |
|
|
40 |
0 |
0 |
| Quantity |
short (System.Int16) |
|
|
0 |
0 |
0 |
| Region |
string (System.String) |
Yes |
|
15 |
0 |
0 |
| RequiredDate |
datetime (System.DateTime) |
Yes |
|
0 |
0 |
0 |
| Salesperson |
string (System.String) |
|
|
31 |
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 |
| ShipperName |
string (System.String) |
|
|
40 |
0 |
0 |
| ShipPostalCode |
string (System.String) |
Yes |
|
10 |
0 |
0 |
| ShipRegion |
string (System.String) |
Yes |
|
15 |
0 |
0 |
| UnitPrice |
decimal (System.Decimal) |
|
|
0 |
19 |
4 |
Mappings
Type of target: View
| Typed View Field |
Target field |
Nullable |
Type |
Length |
Precision |
Scale |
Type converter |
| Address |
Address |
Yes |
nvarchar |
60 |
0 |
0 |
|
| City |
City |
Yes |
nvarchar |
15 |
0 |
0 |
|
| Country |
Country |
Yes |
nvarchar |
15 |
0 |
0 |
|
| CustomerId |
CustomerID |
Yes |
nchar |
5 |
0 |
0 |
|
| CustomerName |
CustomerName |
|
nvarchar |
40 |
0 |
0 |
|
| Discount |
Discount |
|
real |
0 |
24 |
0 |
|
| ExtendedPrice |
ExtendedPrice |
Yes |
money |
0 |
19 |
4 |
|
| Freight |
Freight |
Yes |
money |
0 |
19 |
4 |
|
| OrderDate |
OrderDate |
Yes |
datetime |
0 |
0 |
0 |
|
| OrderId |
OrderID |
|
int |
0 |
10 |
0 |
|
| PostalCode |
PostalCode |
Yes |
nvarchar |
10 |
0 |
0 |
|
| ProductId |
ProductID |
|
int |
0 |
10 |
0 |
|
| ProductName |
ProductName |
|
nvarchar |
40 |
0 |
0 |
|
| Quantity |
Quantity |
|
smallint |
0 |
5 |
0 |
|
| Region |
Region |
Yes |
nvarchar |
15 |
0 |
0 |
|
| RequiredDate |
RequiredDate |
Yes |
datetime |
0 |
0 |
0 |
|
| Salesperson |
Salesperson |
|
nvarchar |
31 |
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 |
|
| ShipperName |
ShipperName |
|
nvarchar |
40 |
0 |
0 |
|
| ShipPostalCode |
ShipPostalCode |
Yes |
nvarchar |
10 |
0 |
0 |
|
| ShipRegion |
ShipRegion |
Yes |
nvarchar |
15 |
0 |
0 |
|
| UnitPrice |
UnitPrice |
|
money |
0 |
19 |
4 |
|
Setting values
Invoices (TypedView)
| Setting name |
Value |
| Typed view row base class name |
|
| Output type |
TypedDataTable |
Address (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
City (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
Country (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
CustomerId (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
CustomerName (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
Discount (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
ExtendedPrice (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 |
PostalCode (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
ProductId (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
ProductName (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
Quantity (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
Region (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
RequiredDate (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
Salesperson (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 |
ShipperName (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
ShipPostalCode (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
ShipRegion (TypedViewField)
| Setting name |
Value |
| Generate as nullable type |
True |
UnitPrice (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.