{"section":"tutorials","requestedLocale":"en","requestedSlug":"orders-data-pipeline-beta","locale":"en","slug":"orders-data-pipeline-beta","path":"docs/en/tutorials/beta/vtex-data-pipeline-beta/orders-data-pipeline-beta.md","branch":"main","content":"The order dataset is composed of two main tables: `orders_historical` and `orders_latest`. These tables include several `SUPER` fields that encompass information such acquired items, shipping details, related sellers, payments, among others.\n\nWe have implemented special auxiliary tables, such as `orders_shipping` and `orders_items` to help manage this data, which can be a complex task due to the 1-to-N relationship between many of the `SUPER` fields and the orders and the amount of information they contain.\n\nWhen running analyses, it's common to create direct selections in the `SUPER` fields to highlight specific parts for extraction. You can also join one of the main tables (`orders` or `latest`) to the auxiliary tables, using orderid as key.\n\nThis method allows you to efficiently extract specific information, enabling a detailed analysis of the orders and their related components.\n\nThis section includes the following information:\n\n- [Characteristics of order data](#data-characteristics)\n- [Table: orders_latest](#table-orders_latest)\n- [Table: orders_historical](#table-orders_historical)\n- [Table: orders_totals](#table-orders_totals)\n- [Table: orders_shipping](#table-orders_shipping)\n- [Table: orders_sellers](#table-orders_sellers)\n- [Table: orders_rateandbenefitsidentifiers](#table-orders_rateandbenefitsidentifiers)\n- [Table: orders_payments](#table-orders_payments)\n- [Table: orders_packages](#table-orders_packages)\n- [Table: orders_items](#table-orders_items)\n- [Table: orders_extra_info](#table-orders-extra-info)\n- [Table: orders_custom_fields](#table-orders-custom-fields)\n- [Table: orders_custom_apps](#table-orders-custom-apps)\n- [Analyses with order data](#analyses-with-order-data)\n- [Correlations with other data](#correlations-with-other-data)\n\n## Data characteristics\n\n|**Characteristic**|**Description**|\n| - | - |\n|**Data source**|The data of the order set come from the [OMS (Order Management System)](/en/docs/tutorials/orders-overview).|\n|**Availability**|Order data can be accessed through the [Orders report](/en/docs/tutorials/exporting-orders-in-orders-module) in the VTEX Admin and also through the[ Orders APIs](https://developers.vtex.com/docs/api-reference/orders-api#get-/api/oms/pvt/orders?endpoint=get-/api/oms/pvt/orders). Keep in mind that the data available through the API may not be structured exactly the same way as it is in the Data Pipeline dataset.|\n|**History**|The data is retained for two years, from 2022 for clients who already use the VTEX platform.|\n|**Minimum update interval**|One hour.|\n\n## Table: `orders_latest`\n\nThe *latest* table stores the latest status of each order, including details such as update date, order ID, and customer information. The table fields are described below:\n\n|**Column name**|**Field type**|**Description**|\n| - | - | - |\n|orderid|character varying(16383)|Unique identifier of the order.|\n|hostname|character varying(16383)|Name of the host related to the order.|\n|value|double precision|Total amount of the order.|\n|totals|super|Summary of order totals, such as subtotal, taxes, discounts, etc.|\n|creationdate|timestamp with time zone|Date and time the order was created.|\n|items|super|Detailed information about the order items.|\n|clientprofiledata_userprofileid|character varying(65535)|Profile ID of the user in the customer management system.|\n|shippingdata_address_city|character varying(65535)|Shipping city of the order.|\n|shippingdata_address_state|character varying(65535)|Shipping state of the order.|\n|shippingdata_address_country|character varying(65535)|Shipping country of the order.|\n|shippingdata_logisticsinfo|super|Logistical information about order shipment.|\n|sellers|super|Information about the sellers associated with the order.|\n|storepreferencesdata_countrycode|character varying(65535)|Country code of the store.|\n|storepreferencesdata_timezone|character varying(65535)|Time zone of the store.|\n|storepreferencesdata_currencycode|character varying(65535)|Code of the currency used in the store.|\n|packages|super|Details about the packaging used for order items.|\n|origin|character varying(16383)|Source of the order.|\n|iscompleted|boolean|Specifies whether the order is completed.|\n|affiliateid|character varying(16383)|Affiliate ID associated with the order.|\n|status|character varying(16383)|Current status of the order.|\n|authorizeddate|timestamp with time zone|Date and time of order authorization.|\n|invoiceddate|timestamp with time zone|Date and time of issue of order invoice.|\n|marketplaceorderid|character varying(16383)|Order ID in the marketplace.|\n|marketplaceservicesendpoint|character varying(16383)|Service endpoint of the marketplace.|\n|lastchange|timestamp with time zone|Date and time of the last change to the order.|\n|marketingdata_utmsource|character varying(65535)|UTM source for marketing purposes.|\n|marketingdata_utmmedium|character varying(65535)|UTM medium for marketing purposes.|\n|marketingdata_utmcampaign|character varying(65535)|UTM campaign for marketing purposes.|\n|marketingdata_utmpartner|character varying(65535)|UTM partner for marketing purposes.|\n|marketingdata_utmipage|character varying(65535)|UTM page for marketing purposes.|\n|marketingdata_utmipart|character varying(65535)|UTM part for marketing purposes.|\n|marketingdata_utmicampaign|character varying(65535)|Alternative UTM campaign for marketing purposes.|\n|marketingdata_coupon|character varying(65535)|Discount coupon code applied to the order.|\n|marketingdata_marketingtags|super|Marketing tags associated with the order.|\n|marketplace_name|character varying(65535)|Name of the marketplace associated with the order.|\n|marketplace_iscertified|super|Specifies whether the marketplace is certified.|\n|marketplace_baseurl|character varying(65535)|Base URL of the marketplace.|\n|contextdata_loggedin|super|Specifies whether the user was logged in while placing the order.|\n|contextdata_useragent|character varying(65535)|User agent used when placing the order.|\n|contextdata_userid|character varying(65535)|ID of the user who placed the order.|\n|rateandbenefitsidentifiers|super|Identifiers of charges and promotions applied to the order.|\n|transactions|super|Details of the financial transactions of the order.|\n|giftcards|super|Information about gift cards used in the order.|\n|saleschannel|character varying(16383)|Sales channel through which the order was placed.|\n|batch_id|character varying(13)|Identifier used when data is loaded into the table for quality control of data ingestion.|\n|sellerorderid|character varying(16383)|Order ID assigned by the seller.|\n|ordergroup|character varying(16383)|Order group this order belongs to.|\n|workflowisinerror|boolean|Specifies whether there was an error in the order workflow.|\n|clientprofiledata_email|character varying(256)|Email of the customer profile associated with the order.|\n|changesattachment_id|character varying(256)|ID of the customization attachment of the order.|\n|changesattachment_changesdat a|super|Details of changes made to the order.|\n|shippingdata_postal_code|character varying(256)|Postal code of the order's shipping address.|\n|seller_parent_account| character varying(100)| Outline the parent account of the given store. If the current store is the parent, then the value is null.|\n\n## Table: `orders_historical`\n\nThe `historical` table stores a complete record of all order updates. The table fields are described below:\n\n|**Column name**|**Field type**|**Description**|\n| - | - | - |\n|orderid|character varying(16383)|Unique identifier for each order, usually used as the primary key.|\n|hostname|character varying(16383)|Name of the host associated with the order, which indicates the server or domain that is managing the order.|\n|value|double precision|Total monetary value of the order. It may include taxes, discounts, and shipping costs.|\n|totals|super|Summary of order totals. It may be broken down into subtotals, taxes, discounts, etc.|\n|creationdate|timestamp with time zone|Date and time the order was created, including time zone.|\n|items|super|Detailed information about the order items. It may include SKU, quantity, price, and item-specific discounts.|\n|clientprofiledata_userprofileid|character varying(65535)|User profile identifier of the customer who placed the order.|\n|shippingdata_address_city|character varying(65535)|City portion of the order's shipping address.|\n|shippingdata_address_state|character varying(65535)|State or region portion of the order's shipping address.|\n|shippingdata_address_country|character varying(65535)|Country portion of the order's shipping address.|\n|shippingdata_logisticsinfo|super|Logistical information related to the order shipment. It may include carrier details and tracking information.|\n|sellers|super|Information about the sellers associated with the order. It may include seller IDs and names.|\n|storepreferencesdata_countryc ode|character varying(65535)|Country code of the store where the order was placed.|\n|storepreferencesdata_timezone|character varying(65535)|Time zone of the store where the order was placed.|\n|storepreferencesdata_currency code|character varying(65535)|Currency code used in the order transaction.|\n|packages|super|Details about packaging of order items. It may include packaging types and dimensions.|\n|origin|character varying(16383)|Source of the order, including where and how the order was started.|\n|iscompleted|boolean|Specifies whether the order was completed.|\n|affiliateid|character varying(16383)|Identifier of an affiliate or reference source associated with the order.|\n|status|character varying(16383)|Current status of the order, such as 'pending', 'shipped', or 'completed'.|\n|authorizeddate|timestamp with time zone|Date and time the order was authorized.|\n|invoiceddate|timestamp with time zone|Date and time the order invoice was issued.|\n|marketplaceorderid|character varying(16383)|Order identifier within a marketplace, if applicable.|\n|marketplaceservicesendpoint|character varying(16383)|Endpoint or URL for marketplace services related to the order.|\n|lastchange|timestamp with time zone|Date and time of the last change made to the order.|\n|marketingdata_utmsource|character varying(65535)|UTM source parameter in marketing data, indicating the traffic or campaign origin.|\n|marketingdata_utmmedium|character varying(65535)|UTM medium parameter in marketing data, indicating the campaign medium (e.g., email, social).|\n|marketingdata_utmcampaign|character varying(65535)|UTM campaign parameter in marketing data, indicating the specific campaign name or code.|\n|marketingdata_utmpartner|character varying(65535)|UTM partner parameter, indicating a marketing partnership or collaborator.|\n|marketingdata_utmpartner|character varying(65535)|UTM page parameter. It may indicate the specific page or location of the campaign.|\n|marketingdata_utmipart|character varying(65535)|UTM part parameter. It may indicate a specific component or section of the marketing campaign.|\n|marketingdata_utmicampaign|character varying(65535)|UTM alternative campaign parameter for additional campaign tracking.|\n|marketingdata_coupon|character varying(65535)|Coupon code used, if any, for applying discounts to the order.|\n|marketingdata_marketingtags|super|Tags or keywords associated with the order's marketing efforts.|\n|marketplace_name|character varying(65535)|Name of the marketplace where the order was placed, if applicable.|\n|marketplace_iscertified|super|Specifies whether the marketplace where the order was placed is certified or recognized.|\n|marketplace_baseurl|character varying(65535)|Base URL of the marketplace where the order was placed.|\n|contextdata_loggedin|super|Specifies whether the user was logged in when placing the order.|\n|contextdata_useragent|character varying(65535)|User-agent string of the browser or device used when placing the order.|\n|contextdata_userid|character varying(65535)|ID of the user who placed the order.|\n|rateandbenefitsidentifiers|super|Identifiers of charges and promotions applied to the order, such as loyalty points or member discounts.|\n|transactions|super|Detailed information about the financial transactions associated with the order.|\n|giftcards|super|Information about gift cards used in the order.|\n|saleschannel|character varying(16383)|Sales channel through which the order was placed (online store, physical store, or others).|\n|batch_id|character varying(13)|Identifier used when data is loaded into the table for quality control of data ingestion.|\n|sellerorderid|character varying(16383)|An order ID assigned by the seller, different from the main order ID.|\n|ordergroup|character varying(16383)|Order group the order belongs to, used to group several orders together.|\n|workflowisinerror|boolean|Specifies whether there was an error in the order processing workflow.|\n|clientprofiledata_email|character varying(256)|Email address of the customer associated with the order.|\n|changesattachment_id|character varying(256)|Unique identifier for a change operation related to the order.|\n|changesattachment_changesda ta|super|Details of changes made to the order, such as adding or removing items and other modifications.|\n|shippingdata_postal_code|character varying(256)|Postal code of the order's shipping address.|  \n|seller_parent_account| character varying(100)| Outline the parent account of the given store. If the current store is the parent, then the value is null.|\n\n## Table: `orders_totals`\n\nThe *totals* table provides a summary of the totals related to each order, including total order amount, applied discounts, and taxes. The table fields are described below:\n\n|**Column name**|**Field type**|**Description**|\n| - | - | - |\n|orderid|character varying(16383)|Unique identifier for each order. This is usually joined with the 'orderid' column of the 'vtex.orders_latest' table for cross-analysis.|\n|hostname|character varying(16383)|Name of the host associated with the order, which indicates the server or domain that is managing the order.|\n|creationdate|timestamp with time zone|Date and time the order was created, including time zone.|\n|lastchange|timestamp with time zone|Date and time of the last change made to the order, reflecting the most recent status or content update.|\n|status|character varying(16383)|Current status of the order. This is frequently joined with the 'status' column of the 'vtex.orders_latest' table to track status changes.|\n|totals_id|character varying(65535)|Unique identifier for order totals, used to reference specific details of the order total.|\n|totals_name|character varying(65535)|Name or description of the order totals, giving an overview of what the total represents (for example: subtotal, taxes, discounts).|\n|totals_value|double precision|Numeric value associated with order totals, such as the total amount, subtotal, taxes, discounts, etc.|\n|batch_id| character varying(13) |Identifier used when data is loaded into the table for quality control of data ingestion.|  \n\n## Table: `orders_shipping`\n\nThe *shipping* table contains order shipping information, such as shipping address, shipping costs, and logistics service providers. \n\nThe table fields are described below:\n\n|**Column name**|**Field type**|**Description**|\n| - | - | - |\n|orderid|character varying(16383)|Unique identifier for each order.|\n|hostname|character varying(16383)|Name of the host related to the order. This is frequently joined with 'hostname' from the 'vtex.client_registry_gold' table.|\n|creationdate|timestamp with time zone|Date and time the order was created, including time zone.|\n|lastchange|timestamp with time zone|Date and time of the last change to the order.|\n|status|character varying(16383)|Current status of the order.|\n|shippingdata_address_city|character varying(65535)|City of the order's shipping address.|\n|shippingdata_address_state|character varying(65535)|State of the order's shipping address.|\n|shippingdata_address_country|character varying(65535)|Country of the order's shipping address.|\n|deliveryids|super|Identifiers associated with order delivery.|\n|shippingestimate|character varying(65535)|Estimated shipping time.|\n|pickupstoreinfo_ispickupstore|boolean|Specifies whether the pickup location is a physical store.|\n|pickupstoreinfo_friendlyname|character varying(65535)|Friendly name of the pickup location.|\n|pickupstoreinfo_dockid|character varying(65535)|Pickup location identifier.|\n|deliverychannel|character varying(65535)|Delivery channel used for the order.|\n|deliverywindow|character varying(65535)|Estimated time window for delivery.|\n|sellingprice|double precision|Sales price of the order item.|\n|listprice|double precision|List price of the order item.|\n|price|double precision|Final price of the order item.|\n|shippingestimatedate|timestamp with time zone|Estimated shipping date for the order.|\n|selecteddeliverychannel|character varying(65535)|Delivery channel selected for the order.|\n|selectedsla|character varying(65535)|Service level agreement (SLA) selected for the order.|\n|deliverychannels|super|Delivery channels available for the order.|\n|slas|super|Available SLAs for the order.|\n|pickupdistance|double precision|Distance to the pickup location.|\n|batch_id|character varying(13)|Identifier used when data is loaded into the table for quality control of data ingestion.|\n|shippingdata_postal_code|character varying(256)|Postal code of the order's shipping address.|  \n\n## Table: `orders_sellers`\n\nThe *sellers* table stores the list of sellers related to each order. The table fields are described below:  \n\n|**Column name**|**Field type**|**Description**|\n| - | - | - |\n|orderid|character varying(16383)|Unique identifier for each order. This is frequently joined with the 'orderid' column of the 'vtex.orders_historical' table for cross-analysis.|\n|hostname|character varying(16383)|Name of the host associated with the order, which indicates the server or domain that is managing the order.|\n|creationdate|timestamp with time zone|Date and time the order was created, including time zone.|\n|lastchange|timestamp with time zone|Date and time of the last change made to the order, reflecting the most recent status or content update.|\n|status|character varying(16383)|Current status of the order.|\n|id|character varying(65535)|Unique identifier, generally used to refer to a specific element within a larger context.|\n|name|character varying(65535)|Name or title of the referenced element, providing a human-readable identification.|\n|logo|character varying(65535)|Path or URL to the associated logo, often used for branding or visual identification.|\n|fulfillmentendpoint|character varying(65535)|Endpoint or URL for fulfillment services that specifies where order fulfillment operations are managed.|\n|subsellerid|character varying(65535)|Identifier for a subseller or secondary seller associated with the order or operation.|\n|batch_id|character varying(13)|Identifier used when data is loaded into the table for quality control of data ingestion.|  \n\n## Table: `orders_rateandbenefitsidentifiers`\n\nThe *rateandbenefitsidentifiers* table contains data about promotions applied to orders. The table fields are described below: \n\n|**Column name**|**Field type**|**Description**|\n| - | - | - |\n|orderid|character varying(16383)|Unique identifier for each order.|\n|hostname|character varying(16383)|Name of the host associated with the order, which indicates the server or domain that is managing the order.|\n|creationdate|timestamp with time zone|Date and time the order was created, including time zone.|\n|lastchange|timestamp with time zone|Date and time of the last change made to the order, reflecting the most recent status or content update.|\n|status|character varying(16383)|Current status of the order.|\n|rateandbenefitsidentifiers_id|character varying(65535)|Unique identifier for surcharge and promotion identifiers associated with the order.|\n|rateandbenefitsidentifiers_name|character varying(65535)|Name or title of surcharge and promotion identifiers, providing clear identification for the promotion or surcharge.|\n|rateandbenefitsidentifiers_featur ed|boolean|Specifies whether surcharge and promotion identifiers are highlighted or have a special feature.|\n|rateandbenefitsidentifiers_descri ption|character varying(65535)|Detailed description of surcharge and promotion identifiers, explaining their features or benefits.|\n|batch_id|character varying(13)|Identifier used when data is loaded into the table for quality control of data ingestion.|  \n\n## Table: `orders_payments`\n\nThe *payments* table contains payment method information. The table fields are described below:  \n\n|**Column name**|**Field type**|**Description**|\n| - | - | - |\n|orderid|character varying(16383)|Unique identifier for each order. This is frequently joined with the 'orderid' column of the 'vtex.orders_latest' table.|\n|hostname|character varying(16383)|Name of the host associated with the order, which indicates the server or domain that is managing the order.|\n|creationdate|timestamp with time zone|Date and time the order was created, including time zone.|\n|lastchange|timestamp with time zone|Date and time of the last change made to the order, reflecting the most recent status or content update.|\n|status|character varying(16383)|Current status of the order.|\n|transactions_merchantname|character varying(65535)|Name of the merchant associated with the order transaction.|\n|group|character varying(65535)|Group or category the order or element belongs to.|\n|installments|integer|Number of installments to pay the order.|\n|value|double precision|Monetary value associated with the transaction or order element.|\n|transactions_paymentsystemname|character varying(65535)|Name of the payment system used in the transaction.|\n|transactions_paymentsystem|character varying(65535)|Identifier of the payment system used in the transaction.|\n|giftcards_id|character varying(65535)|Unique identifier of the gift card used in the order.|\n|giftcards_name|character varying(65535)|Name of the gift card used.|\n|giftcards_caption|character varying(65535)|Description or caption of the gift card used.|\n|giftcards_value|double precision|Monetary value of the gift card.|\n|giftcards_balance|double precision|Remaining gift card balance after use.|\n|giftcards_provider|character varying(65535)|Gift card provider or issuer.|\n|giftcards_groupname|character varying(65535)|Name of the group or category the gift card belongs to.|\n|giftcards_inuse|boolean|Specifies whether the gift card is in use or has been used in the order.|\n|giftcards_isspecialcard|boolean|Specifies whether this is a special or promotional gift card.|\n|batch_id|character varying(13)|Identifier used when data is loaded into the table for quality control of data ingestion.|\n|transactions_transactionid|character varying(65535)|Unique identifier of the financial transaction associated with the order.|\n|transactions_referencevalue|double precision|Transaction reference value. This will probably be the total amount before discounts or charges.|\n\n## Table: `orders_packages`\n\nThe *packages* table stores product packaging and shipping information. The table fields are described below:\n\n|**Column name**|**Field type**|**Description**|\n| - | - | - |\n|orderid|character varying(16383)|Unique identifier for each order.|\n|hostname|character varying(16383)|Name of the host associated with the order, which indicates the server or domain that is managing the order.|\n|creationdate|timestamp with time zone|Date and time the order was created, including time zone.|\n|lastchange|timestamp with time zone|Date and time of the last change made to the order, reflecting the most recent status or content update.|\n|status|character varying(16383)|Current status of the order.|\n|courier|character varying(65535)|Name of the carrier company or delivery service associated with the order.|\n|invoicenumber|character varying(65535)|Invoice number associated with the order.|\n|invoicevalue|double precision|Total amount indicated on the order invoice.|\n|invoiceurl|character varying(65535)|URL to access the electronic invoice for the order.|\n|issuancedate|timestamp with time zone|Date of issue of the order invoice.|\n|trackingnumber|character varying(65535)|Tracking number associated with order delivery.|\n|invoicekey|character varying(65535)|Unique key that identifies the order invoice.|\n|trackingurl|character varying(65535)|URL for tracking order delivery.|\n|embeddedinvoice|character varying(65535)|Embedded information or details of the order invoice.|\n|type|character varying(65535)|Type or category of the element or service associated with the order.|\n|courierstatus_delivereddate|timestamp with time zone|Delivery date of the order as recorded by the carrier service.|\n|courierstatus_status|character varying(65535)|Current delivery status as recorded by the carrier service.|\n|courierstatus_finished|boolean|Specifies whether the delivery process has been completed.|\n|courierstatus_data|super|Detailed data about the delivery status provided by the carrier service.|\n|cfop|character varying(65535)|Código Fiscal de Operações e Prestações (CFOP) code associated with the order in Brazil.|\n|packages_lastchange|timestamp with time zone|Date and time of the last change recorded in the order packages.|\n|volumes|integer|Total number of packages in the order.|\n|batch_id|character varying(13)|Identifier used when data is loaded into the table for quality control of data ingestion.|\n\n## Table: `orders_items`\n\nThe *items* table stores details about the individual items in each order, including SKU, quantity, price, and discounts. The table fields are described below:\n\n|**Column name**|**Field type**|**Description**|\n| - | - | - |\n|orderid|character varying(16383)|Unique identifier for each order. This is usually joined with the 'orderid' column of the 'vtex.orders_latest' table.|\n|hostname|character varying(16383)|Name of the host associated with the order. This is frequently joined with columns from other tables, such as 'vtex.client_registry_gold.hostname'.|\n|creationdate|timestamp with time zone|Date and time the order was created, including time zone.|\n|lastchange|timestamp with time zone|Date and time of the last change made to the order.|\n|status|character varying(16383)|Current status of the order.|\n|tax|double precision|Tax amount applied to the order.|\n|id|character varying(65535)|Unique identifier, frequently joined with 'sku_id' from the 'vtex.fulfillment_simulations_ca_silver' table.|\n|productid|character varying(65535)|Product identifier associated with the order.|\n|quantity|integer|Product quantity in the order.|\n|seller|character varying(65535)|Identifier or name of the product seller.|\n|sellersku|character varying(65535)|Product SKU as listed by the seller.|\n|pricevaliduntil|timestamp with time zone|Date and time the product price is valid through.|\n|name|character varying(65535)|Name of the product.|\n|additionalinfo_brandname|character varying(65535)|Product brand name.|\n|additionalinfo_brandid|character varying(65535)|Product brand identifier.|\n|additionalinfo_caregoriesid|character varying(65535)|Category identifiers associated with the product.|\n|additionalinfo_dimension_cubicw eight|double precision|Cubic weight of the product for shipping purposes.|\n|additionalinfo_dimension_height|double precision|Product height.|\n|additionalinfo_dimension_length|double precision|Product length.|\n|additionalinfo_dimension_weight|double precision|Product weight.|\n|additionalinfo_dimension_width|double precision|Product width.|\n|price|double precision|Product price.|\n|pricetags|super|Price tags associated with the product. This may include discounts and offers.|\n|sellingprice|double precision|Sales price of the product.|\n|listprice|double precision|List price of the product.|\n|imageurl|character varying(65535)|Product image URL.|\n|measurementunit|character varying(65535)|Unit of measure of the product.|\n|unitmultiplier|double precision|Unit multiplier for the product, used in price and quantity calculations.|\n|batch_id|character varying(13)|Identifier used when data is loaded into the table for quality control of data ingestion.|\n|uniqueid|character varying(65535)|Unique id of the given item, which can be used to join this row with other tables.|\n\n## Table: `orders_extra_info`\n\nStores general order information recorded in the OMS system, including creation and update timestamps, client identification, order items, custom data, change attachments, and batch control.  \n\n| Column name                         | Column type               | Column description                                                                                     |\n|-------------------------------------|----------------------------|---------------------------------------------------------------------------------------------------------|\n| orderid                             | character varying(255)     | Unique identifier of the order in the OMS system. Used as a linking key with other order tables.       |\n| hostname                            | character varying(255)     | Hostname where the order was created. Used together with orderid as a linking key.                     |\n| creationdate                        | timestamp with time zone   | Date and time when the order was created in the OMS system.                                            |\n| lastchange                          | timestamp with time zone   | Date and time of the last modification made to the order.                                              |\n| clientprofiledata_corporatename    | character varying(65535)   | Corporate name of the client when it's a B2B sale or legal entity.                                     |\n| clientprofiledata_corporatedocument| character varying(65535)   | Corporate document of the client (CNPJ/Tax ID) when it's a B2B sale or legal entity.                   |\n| clientprofiledata_iscorporate      | boolean                    | Boolean flag indicating whether the order is from a corporate client (legal entity) or individual.     |\n| items                               | super                      | JSON structure (SUPER) containing detailed information about order items.                              |\n| customdata_customapps              | super                      | JSON structure (SUPER) containing custom data from specific applications associated with the order.    |\n| customdata_customfields            | super                      | JSON structure (SUPER) containing additional custom fields configured for the order.                   |\n| changesattachment_id               | character varying(65535)   | Unique identifier of attachments related to changes made to the order.                                 |\n| changesattachment_changesdata      | super                      | JSON structure (SUPER) with detailed data about changes and attachments associated with the order.     |\n| batch_id                            | character varying(13)      | Processing batch identifier used for data ingestion and update control.                                |\n| changesattachment_href             | character varying(65535)   | URL or reference to the attachment related to changes made to the order.                               |\n| has_change_v2                       | boolean                    | Boolean flag indicating whether the order has changes in the new version (v2) of the attachment.       |\n\n## Table: `orders_custom_fields`\n\nStores custom fields configured for orders in the OMS. Includes the type and value of each field, linked to specific entities such as orders or items, enabling flexible data modeling.\n\n| Column name        | Column type               | Column description                                                                 |\n|--------------------|---------------------------|-------------------------------------------------------------------------------------|\n| orderid            | character varying(255)     | Unique identifier of the order in the OMS system. Used as a linking key.           |\n| hostname           | character varying(255)     | Host/account name where the order was created.                                     |\n| creationdate       | timestamp with time zone   | Date and time when the order was created in the OMS system.                        |\n| lastchange         | timestamp with time zone   | Date and time of the last modification made to the order.                          |\n| linked_entity_id   | character varying(65535)   | Unique identifier of the entity the custom field is linked to.                     |\n| linked_entity_type | character varying(65535)   | Type of the entity that the custom field is linked to (e.g., order, item, etc.).   |\n| field_key          | character varying(65535)   | The property name/key from the custom fields JSON object.                          |\n| field_value        | character varying(65535)   | The property value corresponding to the field_key.                                 |\n| batch_id           | character varying(13)      | Processing batch identifier used for data ingestion and update control.            |\n\n### Table: `orders_custom_apps`\n\nRecords custom data from specific applications integrated with the order. Each entry represents an application field with its version, key, and value, enabling tracking of OMS custom extensions.\n\n| Column name     | Column type               | Column description                                                                 |\n|------------------|---------------------------|-------------------------------------------------------------------------------------|\n| orderid          | character varying(255)     | Unique identifier of the order in the OMS system. Used as a linking key.           |\n| hostname         | character varying(255)     | Host/account name where the order was created.                                     |\n| creationdate     | timestamp with time zone   | Date and time when the order was created in the OMS system.                        |\n| lastchange       | timestamp with time zone   | Date and time of the last modification made to the order.                          |\n| customapps_id    | character varying(65535)   | Unique identifier of the custom application.                                       |\n| customapps_major | character varying(65535)   | Major version or classification of the custom application.                         |\n| field_key        | character varying(65535)   | Property name/key from the custom application fields JSON object.                  |\n| field_value      | character varying(65535)   | Property value corresponding to the field_key.                                     |\n| batch_id         | character varying(13)      | Processing batch identifier used for data ingestion and update control.            |\n\n## Analyses with order data\n\nOrder data can be used in the following analyses:\n\n- **Ecommerce website sales analysis:** Evaluate sales volume, identify best-selling products, analyze seasonal trends, and get insights into consumer behavior.  \n- **Order cancellation rate analysis:** Look into cancellation reasons, identify patterns related to specific products or logistical problems, and develop strategies to reduce cancellation rates.  \n- **SKU performance:** Analyze the performance of individual SKUs, understand market demand, and make adjustments to inventory and marketing strategies.  \n\n## Correlations with other data\n\nThe order dataset has correlations with the following sets of the VTEX data ecosystem:\n\n- **Navigation:** Correlating navigation data with orders offers insights into consumer behavior and the purchasing journey, which helps optimize the user experience.  \n- **Promotions:** Interaction with promotion data is key for assessing the effectiveness of promotional campaigns on order volumes and types.  \n- **Transactions:** Joint analysis with transaction data can reveal payment patterns, consumer preferences, and payment processing efficiency.   \n\n### Discover other datasets\n\n- [Inventory](/en/docs/tutorials/inventory-data-pipeline-beta)\n- [Navegation](/en/docs/tutorials/navigation-data-pipeline)   \n- [Payments](/en/docs/tutorials/payments)   \n- [Prices](/en/docs/tutorials/prices-data-pipeline-beta)  \n- [Promotions](/en/docs/tutorials/promotions)\n- [Gift cards](/en/docs/tutorials/gift-card-data-pipeline)\n- [Bridge logs](/en/docs/tutorials/bridge-logs-data-pipeline)"}