NameDescriptionTypeAdditional information
InvoiceNumberPrefix

database reference = orders.invoicenum_prefix

 string

String length: inclusive between 0 and 50
InvoiceNumber

database reference = orders.invoicenum

 integer

None.
OrderID

Primary key. Auto-incremented. database reference = orders.orderid

 integer

None.
CustomerID

database reference = orders.ocustomerid

 integer

None.
OrderDate

database reference = orders.odate

 date

None.
OrderStatusID

database reference = orders.order_status

 integer

None.
LastUpdate

database reference = orders.last_update

 date

None.
UserID

database reference = orders.userid

 string

String length: inclusive between 0 and 50
SalesPerson

database reference = orders.salesperson

 string

String length: inclusive between 0 and 50
ContinueURL

Dynamically generated value. No database reference.

 string

None.
AlternateOrderID

Alternate OrderID

 string

None.
OrderType

OrderType

 string

None.
PaymentTokenID

PaymentTokenID

 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
BillingPaymentMethod

string

None.
BillingOnLinePayment

boolean

None.
BillingPaymentMethodID

database reference = orders.opaymethod

 string

None.
ShipmentList

Collection of Shipment

None.
OrderItemList

Collection of OrderItem

None.
PromotionList

Collection of Promotion

None.
OrderDiscount

OrderDiscountCoupon + OrderDiscountPromotion (Readonly)

 decimal number

None.
OrderDiscountCoupon

database reference = orders.coupondiscount (automatic promotion)

 decimal number

None.
OrderDiscountPromotion

database reference = orders.odiscount (coupon promotion)

 decimal number

None.
SalesTax

database reference = orders.otax

 decimal number

None.
SalesTax2

database reference = orders.otax2

 decimal number

None.
SalesTax3

database reference = orders.otax3

 decimal number

None.
OrderAmount

database reference = orders.orderamount

 decimal number

None.
AffiliateCommission

database reference = orders.affiliate_commission

 decimal number

None.
TransactionList

Collection of Transaction

None.
CardType

database reference = orders.ocardtype

 string

String length: inclusive between 0 and 50
CardNumber

database reference = orders.ocardno

 string

String length: inclusive between 0 and 255
CardName

database reference = orders.ocardname

 string

String length: inclusive between 0 and 200
CardExpirationMonth

database reference = orders.ocardexpiresmonth

 string

String length: inclusive between 0 and 10
CardExpirationYear

database reference = orders.ocardexpiresyear

 string

String length: inclusive between 0 and 10
CardIssueNumber

database reference = orders.ocardissuenum

 string

String length: inclusive between 0 and 10
CardStartMonth

database reference = orders.ocardstartmonth

 string

String length: inclusive between 0 and 10
CardStartYear

database reference = orders.ocardstartyear

 string

String length: inclusive between 0 and 10
CardAddress

database reference = orders.ocardaddress

 string

String length: inclusive between 0 and 150
CardVerification

database reference = orders.ocardverification

 string

String length: inclusive between 0 and 50
OfflinePaymentFieldList

Collection of OfflinePaymentField

None.
RewardPoints

string

None.
QuestionList

Collection of Question

None.
Referer

database reference = orders.referer

 string

String length: inclusive between 0 and 65535
IP

database reference = orders.ip

 string

String length: inclusive between 0 and 16
CustomerComments

database reference = orders.ocomment

 string

String length: inclusive between 0 and 65535
InternalComments

database reference = orders.ointernalcomment

 string

String length: inclusive between 0 and 65535
ExternalComments

database reference = orders.oexternalcomment

 string

String length: inclusive between 0 and 50