> For the complete documentation index, see [llms.txt](https://docs.intentwise.com/iac-source-data/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.intentwise.com/iac-source-data/tiktok-source-data/tiktok-shop-reports/orders-and-cancellations.md). # Orders and cancellations ## Orders and cancellations Schema Name - tiktok\_source\_data ### Cancellations Table Name: `tiktok_shop_cancellations` | Column Name | Data type | Description | | ----------------------------------- | --------- | ----------------------------------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `cancel_id` | String | Unique cancellation request identifier | | `order_id` | String | Original order identifier | | `downloaded_date` | Date | Date the data was downloaded | | `cancel_type` | String | Cancellation type: `CANCEL`, `RETURN`, or `REFUND_ONLY`. | | `cancel_status` | String | Current status of the cancellation request | | `role` | String | Who initiated the cancellation: `BUYER`, `SELLER`, or `PLATFORM`. | | `cancel_reason` | String | Cancellation reason code | | `cancel_reason_text` | String | Cancellation reason free-text description | | `refund_amount_currency` | String | Currency code for refund amounts | | `refund_amount_total` | Numeric | Total refund amount | | `refund_amount_subtotal` | Numeric | Subtotal refund | | `refund_amount_shipping_fee` | Numeric | Refund on shipping fee | | `refund_amount_tax` | Numeric | Refund on tax | | `refund_amount_retail_delivery_fee` | Numeric | Refund on retail delivery fee | | `refund_amount_buyer_service_fee` | Numeric | Refund on buyer service fee | | `create_time` | DateTime | Timestamp when the cancellation was created | | `update_time` | DateTime | Timestamp when the cancellation was last updated | | `download_time` | DateTime | Timestamp when the record was ingested | ### Cancellation Line Items Table Name: `tiktok_shop_cancellation_line_items` | Column Name | Data type | Description | | ----------------------------------- | --------- | ------------------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `cancel_id` | String | Cancellation request identifier | | `order_id` | String | Original order identifier | | `downloaded_date` | Date | Date the data was downloaded | | `cancel_line_item_id` | String | Unique identifier for this cancellation line item | | `order_line_item_id` | String | Original order line item ID being cancelled | | `sku_id` | String | SKU identifier | | `sku_name` | String | SKU display name or variant name | | `product_name` | String | Product name | | `seller_sku` | String | Seller-defined SKU code | | `product_image_url` | String | Product image URL | | `product_image_width` | Integer | Product image width in pixels | | `product_image_height` | Integer | Product image height in pixels | | `refund_amount_currency` | String | Currency code for refund amounts | | `refund_amount_total` | Numeric | Total refund amount for this line item | | `refund_amount_subtotal` | Numeric | Subtotal refund for the product | | `refund_amount_shipping_fee` | Numeric | Refund on shipping fee | | `refund_amount_tax` | Numeric | Refund on tax | | `refund_amount_retail_delivery_fee` | Numeric | Refund on retail delivery fee | | `refund_amount_buyer_service_fee` | Numeric | Refund on buyer service fee | | `download_time` | DateTime | Timestamp when the record was ingested | ### Cancellation Seller Actions Table Name: `tiktok_shop_cancellation_seller_actions` | Column Name | Data type | Description | | ----------------- | --------- | ------------------------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `cancel_id` | String | Cancellation request identifier | | `order_id` | String | Original order identifier | | `downloaded_date` | Date | Date the data was downloaded | | `action` | String | Seller action available, such as `APPROVE` or `REJECT`. | | `deadline` | DateTime | Deadline by which the seller must take this action | | `download_time` | DateTime | Timestamp when the record was ingested | ### Orders Table Name: `tiktok_shop_orders` | Column Name | Data type | Description | | ---------------------------------------- | --------- | ------------------------------------------------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `order_id` | String | Unique order identifier | | `downloaded_date` | Date | Date the data was downloaded | | `status` | String | Current order status, such as `UNPAID`, `SHIPPED`, `DELIVERED`, or `CANCELLED`. | | `order_type` | String | Order type: `NORMAL`, `REPLACEMENT`, or `EXCHANGE`. | | `fulfillment_type` | String | Fulfillment type: `TIKTOK` or `SELLER`. | | `delivery_type` | String | Delivery type | | `shipping_type` | String | Shipping type | | `create_time` | DateTime | Timestamp when the order was created | | `update_time` | DateTime | Timestamp when the order was last updated | | `paid_time` | DateTime | Timestamp when the order was paid | | `cancel_time` | DateTime | Timestamp when the order was cancelled | | `delivery_time` | DateTime | Timestamp when the order was delivered | | `rts_time` | DateTime | Ready-to-ship timestamp | | `collection_time` | DateTime | Timestamp when the carrier collected the order | | `request_cancel_time` | DateTime | Timestamp when cancellation was requested | | `rts_sla_time` | DateTime | SLA deadline for ready-to-ship | | `tts_sla_time` | DateTime | Time-to-ship SLA deadline | | `delivery_sla_time` | DateTime | Delivery SLA deadline | | `cancel_order_sla_time` | DateTime | Cancellation SLA deadline | | `shipping_due_time` | DateTime | Shipping due time | | `collection_due_time` | DateTime | Collection due time | | `delivery_due_time` | DateTime | Delivery due time | | `delivery_option_required_delivery_time` | DateTime | Required delivery time for the selected delivery option | | `pick_up_cut_off_time` | DateTime | Pick-up cut-off time | | `fast_dispatch_sla_time` | DateTime | Fast dispatch SLA deadline | | `release_date` | DateTime | Order release date | | `recommended_shipping_time` | DateTime | Recommended shipping time | | `buyer_user_id` | String | Buyer's TikTok user ID | | `buyer_email` | String | Buyer email address | | `buyer_message` | String | Message from buyer to seller | | `seller_note` | String | Internal note from seller | | `is_cod` | Boolean | Whether this is a cash-on-delivery order | | `is_sample_order` | Boolean | Whether this is a sample order | | `is_replacement_order` | Boolean | Whether this is a replacement order | | `replaced_order_id` | String | Original order ID that this order replaces | | `is_exchange_order` | Boolean | Whether this is an exchange order | | `exchange_source_order_id` | String | Source order ID for exchange orders | | `is_on_hold_order` | Boolean | Whether the order is on hold | | `is_buyer_request_cancel` | Boolean | Whether the buyer requested cancellation | | `has_updated_recipient_address` | Boolean | Whether the recipient address was updated | | `tracking_number` | String | Shipment tracking number | | `shipping_provider` | String | Shipping provider or carrier name | | `shipping_provider_id` | String | Shipping provider or carrier ID | | `warehouse_id` | String | Warehouse ID used for fulfillment | | `delivery_option_id` | String | Selected delivery option ID | | `delivery_option_name` | String | Selected delivery option name | | `cancel_reason` | String | Cancellation reason code | | `cancellation_initiator` | String | Who initiated the cancellation | | `split_or_combine_tag` | String | Tag indicating a split or combined order | | `auto_combine_group_id` | String | Auto-combine group identifier | | `commerce_platform` | String | Commerce platform source | | `need_upload_invoice` | String | Whether invoice upload is needed | | `cpf` | String | Brazilian CPF tax document number | | `cpf_name` | String | Name associated with the CPF number | | `consultation_id` | String | Consultation or chat session identifier | | `fast_delivery_program` | String | Fast delivery program type | | `fulfillment_priority_level` | Integer | Priority level for fulfillment | | `handling_duration_days` | Integer | Handling duration in days | | `handling_duration_type` | String | Handling duration type | | `payment_currency` | String | Currency code for payment amounts | | `payment_total_amount` | Numeric | Total order payment amount | | `payment_sub_total` | Numeric | Order subtotal before shipping and fees | | `payment_shipping_fee` | Numeric | Shipping fee paid by buyer | | `payment_original_total_product_price` | Numeric | Original total product price before discounts | | `payment_original_shipping_fee` | Numeric | Original shipping fee before discounts | | `payment_seller_discount` | Numeric | Total seller-funded discount | | `payment_platform_discount` | Numeric | Total platform-funded discount | | `payment_shipping_fee_seller_discount` | Numeric | Seller-funded shipping discount | | `payment_shipping_fee_platform_discount` | Numeric | Platform-funded shipping discount | | `payment_shipping_fee_cofunded_discount` | Numeric | Co-funded shipping discount | | `payment_tax` | Numeric | Total tax collected | | `payment_product_tax` | Numeric | Tax on products | | `payment_shipping_fee_tax` | Numeric | Tax on shipping fee | | `payment_retail_delivery_fee` | Numeric | Retail delivery fee | | `payment_small_order_fee` | Numeric | Small order fee | | `payment_buyer_service_fee` | Numeric | Buyer service fee | | `payment_handling_fee` | Numeric | Handling fee | | `payment_shipping_insurance_fee` | Numeric | Shipping insurance fee | | `payment_item_insurance_fee` | Numeric | Item insurance fee | | `payment_item_insurance_tax` | Numeric | Tax on item insurance | | `payment_method_name` | String | Payment method used, such as credit card or PayPal | | `recipient_name` | String | Recipient full name | | `recipient_first_name` | String | Recipient first name | | `recipient_last_name` | String | Recipient last name | | `recipient_first_name_local_script` | String | Recipient first name in local script | | `recipient_last_name_local_script` | String | Recipient last name in local script | | `recipient_phone_number` | String | Recipient phone number | | `recipient_full_address` | String | Full shipping address | | `recipient_address_detail` | String | Detailed address information | | `recipient_address_line1` | String | Address line 1 | | `recipient_address_line2` | String | Address line 2 | | `recipient_address_line3` | String | Address line 3 | | `recipient_address_line4` | String | Address line 4 | | `recipient_postal_code` | String | Recipient postal or ZIP code | | `recipient_region_code` | String | Recipient country or region code | | `recipient_post_town` | String | Recipient post town | | `delivery_preferences_drop_off_location` | String | Preferred delivery drop-off location | | `download_time` | DateTime | Timestamp when the record was ingested | ### Order Line Items Table Name: `tiktok_shop_order_line_items` | Column Name | Data type | Description | | ------------------------ | --------- | ---------------------------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `order_id` | String | Order identifier | | `line_item_id` | String | Unique order line item identifier | | `downloaded_date` | Date | Date the data was downloaded | | `sku_id` | String | SKU identifier | | `product_id` | String | Product identifier | | `product_name` | String | Product display name | | `sku_name` | String | SKU variant name | | `seller_sku` | String | Seller-defined SKU code | | `sku_image` | String | SKU image URL | | `sku_type` | String | SKU type: `NORMAL` or `COMBINED`. | | `order_type` | String | Order type: `NORMAL`, `REPLACEMENT`, or `EXCHANGE`. | | `original_price` | Numeric | Original listed price of the SKU | | `sale_price` | Numeric | Actual sale price after discounts | | `seller_discount` | Numeric | Discount amount applied by the seller | | `platform_discount` | Numeric | Discount amount applied by TikTok | | `pfand_fee` | Numeric | Deposit fee for applicable products | | `retail_delivery_fee` | Numeric | Retail delivery fee for this line item | | `buyer_service_fee` | Numeric | Buyer service fee | | `small_order_fee` | Numeric | Small order fee | | `gift_retail_price` | Numeric | Retail price when this is a gift item | | `package_id` | String | Package that shipped this line item | | `package_status` | String | Shipping package status | | `display_status` | String | Display status shown to the buyer | | `tracking_number` | String | Shipment tracking number | | `shipping_provider_id` | String | Shipping provider or carrier identifier | | `shipping_provider_name` | String | Shipping provider or carrier name | | `cancel_reason` | String | Cancellation reason when this item was cancelled | | `cancel_user` | String | Who cancelled the item: `BUYER`, `SELLER`, or `PLATFORM`. | | `rts_time` | DateTime | Ready-to-ship timestamp for this line item | | `handling_duration_days` | Integer | Handling duration in days | | `handling_duration_type` | String | Handling duration type: `WORKING_DAYS` or `CALENDAR_DAYS`. | | `is_gift` | Boolean | Whether this line item is a gift | | `is_dangerous_good` | Boolean | Whether this item is classified as dangerous goods | | `needs_prescription` | Boolean | Whether a prescription is required | | `currency` | String | Currency code for all monetary amounts | | `download_time` | DateTime | Timestamp when the record was ingested |