unique identifier access key. each brand has it own unique key.
order details
order id
order sequential code
external code
indicates if order has delivery windows by order or product
BY_PRODUCT, BY_ORDER customer id
customer code
sales representative code
seller email
order status
DRAFT, IN_REVISION, ON_APPROVAL, APPROVED, SENT, CANCELED, ABANDONED, REJECTED, SUGGESTED order type
PRE_ORDER, READY_FOR_DELIVERY, BOTH order subtotal
order discount
order total charges
order total shipping cost
order total value
order total pieces: sum of all pieces
order total items: its calculated by group of [product - color - availability - delivery window]
order synchronization status
SUCCESS, SUCCESS_RESET, ERROR, NOT_SYNCHRONIZED, PROCESSING, PROCESSING_AFTER_RESET order creation date
order or relations max changed date
order description
order archived
consultant code
consultant name
price table code
order items
order conditions
order split settings
gateway payments
price composition