A unique identifier for each order in the system, used for referencing and managing the order record.

The type of the order, which can indicate different categories or classifications of orders within the system. This could represent various order types such as 'Standard', 'Rush', or 'Backorder', and is used for managing and processing orders based on their classification.

A globally unique identifier for the order, ensuring it can be referenced across different systems and databases.

A hyperlink pointing to the order's detailed page or related resources for easier access and navigation.

The name assigned to the order, typically used for tracking, reporting, and identifying the order within the system.

The current status of the order, such as 'Pending', 'Shipped', 'Delivered', or 'Cancelled', indicating its progress in the order fulfillment cycle.

The user or system responsible for creating the order, providing accountability for its initiation.

The date and time when the order was first created in the system, used to track the order's entry into the system.

The user or system that last modified the order record, tracking changes and updates made after its creation.

The date and time when the order was last modified, helping to track the most recent updates.

The group to which the associated account belongs, used for segmentation and managing customer or partner relationships.

A unique identifier for the account placing the order, used to link the order to the specific account in the system.

The name of the account that placed the order, providing context for customer identification and order tracking.

The status indicating whether the order has been approved, pending approval, or rejected, used for internal process management.

The rule that determines the best discount for the order, ensuring the customer receives the most favorable discount available based on predefined criteria.

The first line of the billing address, providing the main street or location for invoice delivery.

The second line of the billing address, used to provide additional address information such as apartment numbers or building details.

The city where the billing address is located, helping to direct invoices to the correct geographical location.

The contact person at the billing address, typically the individual responsible for handling billing inquiries or issues.

The country associated with the billing address, important for managing international shipping or billing.

The first part of the postal code for the billing address, typically used in certain countries for more granular address identification.

The full postal code for the billing address, used to pinpoint the exact location of the billing address.

The state or province within the billing address, providing further specificity for address validation and shipping.

The exact timestamp when the order was recorded, marking the time when key actions or transactions related to the order occurred.

The planned date for delivering the order to the customer, providing expectations for delivery.

Any warnings or notes related to the delivery order, such as issues with shipping or stock availability that could delay the delivery.

Indicates whether the order is associated with delivery. A value of 'true' signifies that the order is specifically for delivery.

The rules governing how the delivery costs are handled in the order, such as 'Prepaid' or 'Cash on Delivery'.

The payment method applied to the delivery portion of the order, indicating how the delivery will be paid for (for example, 'Paid in advance').

The rank or priority assigned to the delivery for scheduling purposes, used to manage delivery sequences.

A legal disclaimer associated with the order, providing important terms and conditions regarding the order's processing or fulfillment.

An identifier linking the order to related entities or systems, allowing for easy cross-referencing between records.

The most recent date on which the inventory for this order was checked or updated, ensuring stock levels are accurate.

Indicates whether the order is locked for editing. A value of 'true' prevents further modifications to the order.

Indicates whether this order is a master order in a series of related orders, with 'true' identifying it as the primary order.

The date and time when the order was created via a mobile platform, indicating that the order was placed through a mobile interface.

A unique identifier for the mobile device used to place the order, helping track orders originating from specific devices.

The date and time when the order was last modified via a mobile device, allowing for tracking of mobile-based updates.

Additional comments or information related to the order, often used for special instructions or clarifications during fulfillment.

The date when the order was officially placed by the customer, used for record-keeping and tracking purposes.

The discount rule applied to the order, specifying how the discount is calculated based on the order's total or conditions.

The total amount of discount applied to the order, representing the reduction in price after applying the order discount rule.

The value of any free goods included in the order as part of promotions or discounts.

The full list price of the items ordered before applying any discounts, representing the total retail price.

The full list price of the items in the order in corporate currency, used for reporting in corporate financial systems.

The currency used for the order, reflecting the local currency in which the customer pays.

The net amount rule applied to the order, determining how the final amount due is calculated after applying discounts and adjustments.

The net amount rule applied to the order in corporate currency, used for corporate accounting or reporting.

The final amount due for the order after discounts, taxes, and other adjustments have been applied.

The final amount due for the order in corporate currency, ensuring consistency across global operations.

The total discount applied to the entire order, accounting for all applicable discounts and promotional offers.

The total profit from the order, calculated by subtracting the cost of goods sold from the order's revenue.

The total profit from the order in corporate currency, used for financial reporting in global currency.

The total quantity of items in the order, reflecting the total volume or number of products being ordered.

Indicates whether the order's lock can be overridden for further modifications. A value of 'true' allows the order to be unlocked.

The payment terms and rules applied to the order, such as 'Prepaid', 'Net 30', or 'Cash on Delivery'.

The specific payment method used for the order, detailing how the customer has paid or will pay for the order.

The email address where the order receipt will be sent, used for customer communication and record-keeping.

Indicates whether the customer has requested a receipt for the order. A value of 'true' indicates that the customer wants a receipt.

The first line of the shipping address, used to specify the street address where the order will be delivered.

The second line of the shipping address, used for apartment or unit numbers when needed.

The city where the order will be shipped, providing geographic location for delivery.

The country to which the order will be shipped, helping to manage international shipping logistics.

The first part of the postal code for the shipping address, typically used for more specific regional sorting.

The full postal code for the shipping address, helping to direct the delivery to the correct location.

The state or province of the shipping address, used to define the geographic area for delivery.

The date on which the customer signs to confirm receipt or acceptance of the order.

The signature of the customer or representative acknowledging the order, used as proof of receipt or agreement.

The overall status of the order, indicating whether it is 'Pending', 'Completed', 'Shipped', or 'Cancelled'.

Any warnings associated with the order, such as potential delays, pricing issues, or shipping constraints.

The priority level given to wholesalers in processing the order, indicating the order fulfillment priority.

The account placing the order, linking the order to the specific customer or company placing the order.

The assortment of products included in the order, describing the variety or categories of items being purchased.

The associated call or conversation related to the order, used for tracking customer service or sales interactions.

The contract associated with the order, referencing any terms, conditions, or agreements tied to the order.

The specific location where the order is to be delivered, used for managing delivery logistics.

The most recent inventory check related to the order, tracking stock levels and availability.

The campaign associated with the order, used for tracking orders related to specific marketing efforts or initiatives.

The parent order in cases where multiple orders are grouped together, helping to track larger transactions or shipments.

The party responsible for paying for the order, often different from the account placing the order.

The price book used for calculating the prices of the items in the order, based on agreed pricing terms.

The wholesaler partner associated with fulfilling the order, used to track the relationship for supply chain management.

The wholesaler fulfilling the order, identifying the source of the products in the order.

The individual or account responsible for managing or overseeing the order's completion.

The total list price for all items in the order before any discounts or adjustments.

The total list price for all items in the order in corporate currency, used for global reporting.

The final amount due for the order after all discounts and adjustments have been applied.

The final amount due for the order in corporate currency, ensuring consistency across global operations.

The full shipping address for the order, including all necessary address details for accurate delivery.

The total discount applied to the order, reflecting the sum of all discounts across items and shipping.

The identifier for the order in the legacy CRM system, used to maintain consistency across different systems.

The billing address for the order, where invoices and payment information are sent.

The shipping address for the order, specifying where the products are delivered.

Indicates whether a delivery discount has been applied to the order.

The quantity of items eligible for a delivery discount.

The total net amount of the order, including all components, taxes, and delivery fees.

The total net amount in corporate currency, used for financial reporting.

The combined discount for the entire order, including both product and delivery discounts.

The total value of the delivery discount applied to the order.

The value of the delivery discount in corporate currency.

The overall discount applied to the delivery portion of the order.

The total list price for the delivery portion of the order.

The delivery list price in corporate currency.

The final amount for the delivery portion after applying all relevant adjustments.

The delivery net amount in corporate currency.

The country of the user placing the order.

The country associated with the account placing the order.

The lifecycle stage of the order, representing its current status in the order processing pipeline.

The specific stage within the order's lifecycle, such as 'New', 'In Progress', or 'Completed'.

The unique identifier for the lifecycle stage the order is in.

The name or description of the stage the order is in, indicating the phase in the order lifecycle.