| usedCoupons | Array of objects | 
| Array | id | integer |  | code | string |  | value | string |  | order |  |  | coupon |  | 
 | 
| uspsShipment | Array of objects | 
| Array | id | integer |  | transactionId | string |  | order |  |  | requestData | Array |  | responseData | Array |  | printDate | integer |  | price | string |  | shipmentId | string |  | trackingNumber | string |  | trackingData | Array |  | labelURL | string |  | labelContent | Array | 
 | 
| capostParcels | Array of objects | 
| Array | id | integer |  | number | integer |  | status | string |  | quoteType | string |  | order |  |  | items | Array |  | shipment |  |  | boxWeight | string |  | boxWidth | string |  | boxLength | string |  | boxHeight | string |  | isDocument | boolean |  | isUnpackaged | boolean |  | isMailingTube | boolean |  | isOversized | boolean |  | notifyOnShipment | boolean |  | notifyOnException | boolean |  | notifyOnDelivery | boolean |  | optSignature | boolean |  | optCoverage | string |  | optAgeProof | string |  | optWayToDeliver | string |  | optNonDelivery | string | 
 | 
| capostReturns | Array of objects | 
| Array | id | integer |  | items | Array |  | links | Array |  | order |  |  | status | string |  | date | integer |  | lastRenewDate | integer |  | notes | string |  | adminNotes | string |  | trackingPin | string | 
 | 
| capostOffice | object | 
| | id | integerUnique ID |  | order |  |  | officeId | stringThe internal Canada Post assigned unique ID for a Post Office
(Field pattern: "\d{10}", has leading zeros) |  | name | stringThe name assigned to the Post Office
(Max length: 40) |  | location | stringThe location of a Post Office. This is used to distinguish among various Post Offices that have similar names.
(Max length: 40) |  | distance | stringThe distance (in KM) to the Post Office from the location specified in the query
(min: 0, max: 99999.99, fraction: 2) |  | bilingualDesignation | booleanTrue indicates that the Post Office provides bilingual services (English and French) |  | city | stringMunicipality in which the Post Office is located
(Max length: 40) |  | latitude | stringThe latitude of the Post Office
(min: 40, max: 90, fraction: 5) |  | longitude | stringThe longitude of the Post Office
(min: -150, max: -50, fraction: 5) |  | postalCode | stringThe Postal Code of the Post Office |  | province | stringThe province where the Post Office is located |  | officeAddress | stringStreet number and name for a Post Office
(Max length: 64) |  | workingHours | ArrayWorking hours list | 
 | 
| giftWrapping | boolean | 
| greetingMessage | string | 
| mailchimpStoreId | string | 
| mandrill_mails | Array of objects | 
| Array | mail_id | string |  | opened | boolean |  | clicked | boolean |  | ip | string |  | country_short | string |  | mobile | boolean |  | os_family | string |  | ua_family | string |  | order |  | 
 | 
| not_finished_order | object | 
| | usedCoupons | ArrayUsed coupons |  | uspsShipment | ArrayUSPS Shipments |  | capostParcels | ArrayCanada Post parcels (reference to the Canada Post parcels model) |  | capostReturns | ArrayReference to the Canada Post returns model |  | capostOffice |  |  | giftWrapping | boolean |  | greetingMessage | string |  | mailchimpStoreId | stringMailchimp store id |  | mandrill_mails | ArrayMandrill e-mail messages |  | not_finished_order |  |  | pbOrder |  |  | conversation |  |  | order_id | integerOrder unique id |  | profile |  |  | orig_profile |  |  | shipping_id | integerShipping method unique id |  | shipping_method_name | stringShipping method name |  | payment_method_name | stringPayment method name |  | tracking | stringShipping tracking code |  | date | integerOrder creation timestamp |  | lastRenewDate | integerLast order renew date |  | paymentStatus | object |  | | id | integerID |  | code | stringStatus code |  | position | integerPosition | 
 |  | shippingStatus | object |  | | id | integerID |  | code | stringStatus code |  | position | integerPosition | 
 |  | notes | stringCustomer notes |  | adminNotes | stringAdmin notes |  | details | ArrayOrder details |  | trackingNumbers | ArrayOrder tracking numbers |  | events | ArrayOrder events queue |  | items | ArrayOrder items |  | surcharges | ArrayOrder surcharges |  | payment_transactions | ArrayPayment transactions |  | currency |  |  | orderNumber | stringUnique order identificator (it is working for orders only, not for cart entities) |  | recent | booleanRecent flag: true if order's statuses were not changed manually by an administrator, otherwise - false |  | xcPendingExport | booleanFlag to exporting entities |  | total | stringTotal |  | subtotal | stringSubtotal | 
 | 
| pbOrder | object | 
| | id | integerID |  | ormus | stringOrder ID returned by PB |  | transactionId | stringTransaction ID |  | order |  |  | parcels | ArrayParcels association |  | createOrderResponse | object |  |  | 
 | 
| conversation | object | 
| | id | integerUnique ID |  | messages | ArrayMessages |  | order |  |  | members | ArrayConversation members | 
 | 
| order_id | integer | 
| profile | object | 
| | gaClientId | stringGoogle analytics cid |  | socialLoginProvider | stringAuth provider (facebook, google, etc.) |  | socialLoginId | stringAuth provider-unique user id (for ex. facebook user id) |  | pictureUrl | stringProfile picture url |  | mail_chimp_lists | ArrayMailChimp lists |  | mail_chimp_interests | ArrayMailChimp lists |  | mail_chimp_segments | ArrayMailChimp segments |  | auth_phone_number | stringAuthentication phone number |  | auth_phone_code | stringAuthentication phone country code |  | authy_id | integerID in Authy |  | conversations | ArrayCoupons |  | profile_id | integerProfile unique ID |  | login | stringLogin (e-mail) |  | password | stringPassword |  | password_hint | stringPassword hint |  | password_hint_answer | stringPassword hint answer |  | passwordResetKey | stringPassword reset key (for 'Forgot password') |  | passwordResetKeyDate | integerTimestamp of reset key creation date |  | access_level | integerAccess level |  | cms_profile_id | integerCMS profile Id |  | cms_name | stringCMS name |  | added | integerTimestamp of profile creation date |  | first_login | integerTimestamp of first login event |  | last_login | integerTimestamp of last login event |  | status | stringProfile status |  | statusComment | stringStatus comment (reason) |  | referer | stringReferer |  | order |  |  | event | ArrayRelation to an event |  | language | stringLanguage code |  | last_shipping_id | integerLast selected shipping id |  | last_payment_id | integerLast selected payment id |  | membership | object (Membership: many-to-one relation with memberships table)Membership: many-to-one relation with memberships table |  |  |  | pending_membership | object (Pending membership: many-to-one relation with memberships table)Pending membership: many-to-one relation with memberships table |  |  |  | addresses | ArrayAddress book: one-to-many relation with address book entity |  | roles | ArrayRoles |  | anonymous | booleanFlag of anonymous profile (used for checkout process only) |  | forceChangePassword | booleanFlag if the user needs to change the password.
The customers only |  | dateOfLoginAttempt | integerDate of last login attempt |  | countOfLoginAttempts | integerCount of login attempt |  | searchFakeField | stringFake field for search |  | xcPendingExport | booleanFlag to exporting entities |  | lastCheckoutEmail | stringCheckout email | 
 | 
| orig_profile | object | 
| | gaClientId | stringGoogle analytics cid |  | socialLoginProvider | stringAuth provider (facebook, google, etc.) |  | socialLoginId | stringAuth provider-unique user id (for ex. facebook user id) |  | pictureUrl | stringProfile picture url |  | mail_chimp_lists | ArrayMailChimp lists |  | mail_chimp_interests | ArrayMailChimp lists |  | mail_chimp_segments | ArrayMailChimp segments |  | auth_phone_number | stringAuthentication phone number |  | auth_phone_code | stringAuthentication phone country code |  | authy_id | integerID in Authy |  | conversations | ArrayCoupons |  | profile_id | integerProfile unique ID |  | login | stringLogin (e-mail) |  | password | stringPassword |  | password_hint | stringPassword hint |  | password_hint_answer | stringPassword hint answer |  | passwordResetKey | stringPassword reset key (for 'Forgot password') |  | passwordResetKeyDate | integerTimestamp of reset key creation date |  | access_level | integerAccess level |  | cms_profile_id | integerCMS profile Id |  | cms_name | stringCMS name |  | added | integerTimestamp of profile creation date |  | first_login | integerTimestamp of first login event |  | last_login | integerTimestamp of last login event |  | status | stringProfile status |  | statusComment | stringStatus comment (reason) |  | referer | stringReferer |  | order |  |  | event | ArrayRelation to an event |  | language | stringLanguage code |  | last_shipping_id | integerLast selected shipping id |  | last_payment_id | integerLast selected payment id |  | membership | object (Membership: many-to-one relation with memberships table)Membership: many-to-one relation with memberships table |  |  |  | pending_membership | object (Pending membership: many-to-one relation with memberships table)Pending membership: many-to-one relation with memberships table |  |  |  | addresses | ArrayAddress book: one-to-many relation with address book entity |  | roles | ArrayRoles |  | anonymous | booleanFlag of anonymous profile (used for checkout process only) |  | forceChangePassword | booleanFlag if the user needs to change the password.
The customers only |  | dateOfLoginAttempt | integerDate of last login attempt |  | countOfLoginAttempts | integerCount of login attempt |  | searchFakeField | stringFake field for search |  | xcPendingExport | booleanFlag to exporting entities |  | lastCheckoutEmail | stringCheckout email | 
 | 
| shipping_id | integer | 
| shipping_method_name | string | 
| payment_method_name | string | 
| tracking | string | 
| date | integer | 
| lastRenewDate | integer | 
| paymentStatus | object | 
| | id | integerID |  | code | stringStatus code |  | position | integerPosition | 
 | 
| shippingStatus | object | 
| | id | integerID |  | code | stringStatus code |  | position | integerPosition | 
 | 
| notes | string | 
| adminNotes | string | 
| details | Array of objects | 
| Array | detail_id | integer |  | name | string |  | label | string |  | value | string |  | order |  | 
 | 
| trackingNumbers | Array of objects | 
| Array | tracking_id | integer |  | value | string |  | order |  | 
 | 
| events | Array of objects | 
| Array | event_id | integer |  | date | integer |  | code | string |  | description | string |  | data | Array |  | comment | string |  | details | Array |  | order |  |  | author |  | 
 | 
| items | Array of objects | 
| Array | privateAttachments | Array |  | categoryAdded | string |  | pinCodes | Array |  | vatRate | string |  | capostParcelItems | Array |  | capostReturnItems | Array |  | customerAttachments | Array |  | parcelItems | Array |  | variant |  |  | item_id | integer |  | object |  |  | name | string |  | sku | string |  | price | string |  | itemNetPrice | string |  | discountedSubtotal | string |  | amount | integer |  | order |  |  | surcharges | Array |  | attributeValues | Array |  | total | string |  | subtotal | string | 
 | 
| surcharges | Array of objects | 
| Array | owner |  |  | id | integer |  | type | string |  | code | string |  | class | string |  | include | boolean |  | available | boolean |  | value | string |  | name | string |  | weight | integer | 
 | 
| payment_transactions | Array of objects | 
| Array | transaction_id | integer |  | date | integer |  | publicTxnId | string |  | method_name | string |  | method_local_name | string |  | status | string |  | value | string |  | note | string |  | type | string |  | public_id | string |  | order |  |  | payment_method | object |  | | method_id | integerPayment method unique id |  | service_name | stringMethod service name (gateway or API name) |  | class | stringProcess class name |  | moduleName | stringSpecific module family name |  | orderby | integerPosition |  | adminOrderby | integerPosition in popup |  | enabled | booleanEnabled status |  | moduleEnabled | booleanModule enabled status |  | added | booleanAdded status |  | type | stringType |  | settings | ArraySettings |  | fromMarketplace | booleanFlag:
1 - method has been got from marketplace,
0 - method has been added after distr or module installation |  | iconURL | stringPayment method icon URL (used for methods from marketplace) |  | countries | ArrayCountries of merchant (merchants from these countries can sign up and use this method) |  | exCountries | ArrayExcluded countries (merchants from these countries cannot sign up for payment account) | 
 |  | data | Array |  | backend_transactions | Array |  | currency |  | 
 | 
| currency | object | 
| | currency_id | integerCurrency unique id (ISO 4217 number) |  | code | stringCurrency code (ISO 4217 alpha-3) |  | symbol | stringSymbol |  | prefix | stringPrefix |  | suffix | stringSuffix |  | e | stringNumber of digits after the decimal separator. |  | decimalDelimiter | stringDecimal part delimiter |  | thousandDelimiter | stringThousand delimier |  | orders | ArrayOrders |  | countries | ArrayCountries | 
 | 
| orderNumber | string | 
| recent | boolean | 
| xcPendingExport | boolean | 
| total | string | 
| subtotal | string |