NameDescriptionTypeAdditional 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.