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