| Name | Description | Type | Additional information |
|---|---|---|---|
| OrderId | integer |
None. |
|
| OrderItemId | integer |
None. |
|
| ParentID | string |
None. |
|
| OrderCancelRefundReturnId | integer |
None. |
|
| Flag | integer |
None. |
|
| Quantity | integer |
None. |
|
| Amount | decimal number |
None. |
|
| UnitPrice | decimal number |
None. |
|
| OrderGUID | globally unique identifier |
None. |
|
| OrderStatusId | integer |
None. |
|
| OrderNumber | string |
None. |
|
| CreatedOn | date |
None. |
|
| CustGUID | globally unique identifier |
None. |
|
| OrderAmount | decimal number |
None. |
|
| USDRate | decimal number |
None. |
|
| ShippingMasterId | integer |
None. |
|
| ShipPercent | decimal number |
None. |
|
| ShipAmount | decimal number |
None. |
|
| ShipDiscountAmt | decimal number |
None. |
|
| OrderDiscount | decimal number |
None. |
|
| OrderDiscountAmt | decimal number |
None. |
|
| SaleTaxTotal | decimal number |
None. |
|
| OrderComment | string |
None. |
|
| OrderPlacedFrom | string |
None. |
|
| ShipMethodName | string |
None. |
|
| Key1 | string |
None. |
|
| Key2 | string |
None. |
|
| CashPointEarned | decimal number |
None. |
|
| CashPointUsed | decimal number |
None. |
|
| GiftWrapText | string |
None. |
|
| GiftWrapPrice | decimal number |
None. |
|
| StatusChangeComment | string |
None. |
|
| StatusChangeFees | decimal number |
None. |
|
| ShippingDate | date |
None. |
|
| ShippingTransNo | string |
None. |
|
| IsFreeShipping | boolean |
None. |
|
| RMA | integer |
None. |
|
| IsRequestCancel | boolean |
None. |
|
| CancelReason | string |
None. |
|
| IsCreditPurchase | boolean |
None. |
|
| IsPaymentPending | boolean |
None. |
|
| CreditAmount | decimal number |
None. |
|
| CancelRefundAmount | decimal number |
None. |
|
| IsStandardShipping | boolean |
None. |
|
| Currency | string |
None. |
|
| ClientId | integer |
None. |
|
| CreatedBy | integer |
None. |
|
| BillingAddressId | integer |
None. |
|
| ShippingAddressId | integer |
None. |
|
| OrderDate | date |
None. |
|
| CancelledDate | date |
None. |
|
| ReturnedDate | date |
None. |
|
| TransactionGuid | globally unique identifier |
None. |
|
| ShipMethodId | integer |
None. |
|
| ModifiedOn | date |
None. |
|
| ModifiedBy | integer |
None. |
|
| OrderStatus | string |
None. |
|
| CustomerId | integer |
None. |
|
| GUID | globally unique identifier |
None. |
|
| Title | string |
None. |
|
| FirstName | string |
None. |
|
| LastName | string |
None. |
|
| string |
None. |
||
| Company | string |
None. |
|
| Mobile | string |
None. |
|
| Phone | string |
None. |
|
| PhoneExtension | string |
None. |
|
| Fax | string |
None. |
|
| FaxExtension | string |
None. |
|
| Password | string |
None. |
|
| SecurityQuestion | string |
None. |
|
| SecurityAnswer | string |
None. |
|
| RegistrationDate | date |
None. |
|
| AllowCC | boolean |
None. |
|
| AllowCheck | boolean |
None. |
|
| AllowCash | boolean |
None. |
|
| AllowWire | boolean |
None. |
|
| CustomerGroupId | integer |
None. |
|
| Type | string |
None. |
|
| Extra1 | string |
None. |
|
| Extra2 | string |
None. |
|
| IsActive | boolean |
None. |
|
| IsLogicalDeleted | boolean |
None. |
|
| CreatedOn1 | date |
None. |
|
| CreatedBy1 | integer |
None. |
|
| ModifiedOn1 | date |
None. |
|
| ModifiedBy1 | integer |
None. |
|
| ClientId1 | integer |
None. |
|
| SortOrder | integer |
None. |
|
| PreferredLanguageId | integer |
None. |
|
| ProfilePic | string |
None. |
|
| IsVerifiedByAdmin | boolean |
None. |
|
| Token | globally unique identifier |
None. |
|
| Designation | string |
None. |
|
| CompanyType | string |
None. |
|
| IsDownload | boolean |
None. |
|
| CashPoints | decimal number |
None. |
|
| CreditBalance | decimal number |
None. |
|
| CreditLimit | decimal number |
None. |
|
| IsAllowCreditPurchase | boolean |
None. |
|
| Comment | string |
None. |
|
| IsApplyForBusinessCreditAccount | boolean |
None. |
|
| WalletBalance | decimal number |
None. |
|
| WalletAmtUsed | decimal number |
None. |
|
| IndustryType | string |
None. |
|
| IPAddress | string |
None. |
|
| BrowserInfo | string |
None. |
|
| EncryptedSecretGUID | string |
None. |
|
| IndustryIds | string |
None. |
|
| IsGuest | boolean |
None. |
|
| OTP | string |
None. |
|
| OTPExpiry | date |
None. |
|
| NewsLetterSubscribed | boolean |
None. |
|
| OrderTaxId | integer |
None. |
|
| OrderGUID1 | globally unique identifier |
None. |
|
| CountryCode | string |
None. |
|
| CountryTaxAmount | decimal number |
None. |
|
| CreatedOn2 | date |
None. |
|
| TaxTypeId | integer |
None. |
|
| TaxTypeAmount | decimal number |
None. |
|
| CouponCode | string |
None. |
|
| CouponValue | decimal number |
None. |
|
| IsCancelAll | boolean |
None. |
|
| RefundAmount | decimal number |
None. |
|
| RefundCommentByAdmin | string |
None. |
|
| IsOrderLevelRefund | boolean |
None. |
|
| XpressDeliveryAmount | decimal number |
None. |
|
| IsXpressDelivery | boolean |
None. |
|
| DeliveryChargeAmount | decimal number |
None. |
|
| RefundModeId | integer |
None. |
|
| TotalOrderAmount | decimal number |
None. |
|
| IsReturnAll | boolean |
None. |
|
| PaymentTypes | string |
None. |
|
| TransactionAmount | decimal number |
None. |
|
| AuthorizeDotNetCustomerProfileId | string |
None. |
|
| TaxNumber | string |
None. |
|
| AdminCancelComment | string |
None. |
|
| SkuTypeId | integer |
None. |
