Name | Description | Type | Additional information |
---|---|---|---|
OrderKey |
database reference = orders.orderkey |
string |
String length: inclusive between 0 and 16 |
OrderDate |
database reference = orders.odate |
date |
None. |
OrderAmount |
database reference = orders.orderamount |
decimal number |
None. |
OrderWeight |
Dynamically generated value. No database reference. |
decimal number |
None. |
LastUpdate |
database reference = orders.last_update |
date |
None. |
CheckoutURL |
Dynamically generated value. No database reference. |
string |
None. |
CustomerId |
database reference = orders.ocustomerid |
integer |
None. |
BillingFirstName |
database reference = orders.ofirstname |
string |
String length: inclusive between 0 and 100 |
BillingLastName |
database reference = orders.olastname |
string |
String length: inclusive between 0 and 100 |
BillingCompany |
database reference = orders.ocompany |
string |
String length: inclusive between 0 and 255 |
BillingAddress |
database reference = orders.oaddress |
string |
String length: inclusive between 0 and 200 |
BillingAddress2 |
database reference = orders.oaddress2 |
string |
String length: inclusive between 0 and 50 |
BillingCity |
database reference = orders.ocity |
string |
String length: inclusive between 0 and 100 |
BillingState |
database reference = orders.ostate |
string |
String length: inclusive between 0 and 100 |
BillingZipCode |
database reference = orders.ozip |
string |
String length: inclusive between 0 and 20 |
BillingCountry |
database reference = orders.ocountry |
string |
String length: inclusive between 0 and 50 |
BillingPhoneNumber |
database reference = orders.ophone |
string |
String length: inclusive between 0 and 30 |
BillingEmail |
database reference = orders.oemail |
string |
String length: inclusive between 0 and 100 |
ShipmentFirstName |
database reference = orders.oshipfirstname |
string |
String length: inclusive between 0 and 100 |
ShipmentLastName |
database reference = orders.oshiplastname |
string |
String length: inclusive between 0 and 50 |
ShipmentCompany |
database reference = orders.oshipcompany |
string |
String length: inclusive between 0 and 200 |
ShipmentAddress |
database reference = orders.oshipaddress |
string |
String length: inclusive between 0 and 255 |
ShipmentAddress2 |
database reference = orders.oshipaddress2 |
string |
String length: inclusive between 0 and 50 |
ShipmentCity |
database reference = orders.oshipcity |
string |
String length: inclusive between 0 and 50 |
ShipmentState |
database reference = orders.oshipstate |
string |
String length: inclusive between 0 and 50 |
ShipmentZipCode |
database reference = orders.oshipzip |
string |
String length: inclusive between 0 and 20 |
ShipmentCountry |
database reference = orders.oshipcountry |
string |
String length: inclusive between 0 and 50 |
ShipmentPhone |
database reference = orders.oshipphone |
string |
String length: inclusive between 0 and 50 |
ShipmentEmail |
database reference = orders.oshipemail |
string |
String length: inclusive between 0 and 100 |
CartItemList | Collection of CartItem |
None. |