Name | Description | Type | Additional 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 |