Schema · Entity relationship diagram
TikTok Shop tables and relationships
Orders and finance (statements, fee-level transactions, payouts) with full history, shop, product and SKU analytics, videos, LIVEs and bestseller leaderboards.
ConnectSign in and approve
MarketsUS, UK, Germany, France, Spain, Italy
DestinationsAmazon Redshift, Google BigQuery, Snowflake, PostgreSQL, Amazon S3
ordershas one row per order line (keyline_item_id). Order-level amounts repeat on every line, so filteris_order_first_line = 1before summingorder_*columns.- The
bestselling_*tables are platform-wide top-100 leaderboards across all of TikTok Shop, so every shop gets the same rows. - Affiliate orders, samples and creator tables are on the TikTok Shop Affiliate page.
Primary keyForeign keyReferencesJoins on (not a key)
Drag to pan, scroll or pinch to zoom, click a table to see what it joins to.
Table reference
18 tables · click a table for its columnsorders59 columns · Ordersshow in diagram
Primary key: line_item_id
| Column | Type | Key | Description |
|---|---|---|---|
| order identity / status | |||
| order_idTikTok Shop order id. One order has one row per line item. Redshift DISTKEY. | varchar(64) | TikTok Shop order id. One order has one row per line item. Redshift DISTKEY. | |
| order_status | varchar(64) | ||
| order_type | varchar(64) | ||
| Opaque TikTok buyer id. The ONLY repeat-customer key available: TikTok does not expose buyer email and masks name/phone/address. | |||
| buyer_user_id | varchar(64) | ||
| create_time_utc | timestamp | ||
| order_date_ptRedshift SORTKEY. | date | Redshift SORTKEY. | |
| update_time_utc | timestamp | ||
| paid_time_utc | timestamp | ||
| delivery_time_utc | timestamp | ||
| cancel_reason | varchar(512) | ||
| is_cod | smallint | ||
| is_sample_order | smallint | ||
| fulfillment | |||
| fulfillment_type | varchar(64) | ||
| delivery_option_name | varchar(256) | ||
| shipping_provider | varchar(256) | ||
| payment_method_name | varchar(128) | ||
| warehouse_id | varchar(64) | ||
| seller_note | varchar(2048) | ||
| buyer_message | varchar(2048) | ||
| order-level money: REPEATED on every line of the order. Filter is_order_first_line = 1 before summing these. | |||
| currency | varchar(8) | ||
| order_total_amount | decimal(18,4) | ||
| order_sub_total | decimal(18,4) | ||
| order_shipping_fee | decimal(18,4) | ||
| order_seller_discount | decimal(18,4) | ||
| order_platform_discount | decimal(18,4) | ||
| order_original_total_product_price | decimal(18,4) | ||
| order_original_shipping_fee | decimal(18,4) | ||
| order_shipping_fee_seller_discount | decimal(18,4) | ||
| order_shipping_fee_platform_discount | decimal(18,4) | ||
| order_tax | decimal(18,4) | ||
| address (district_info L0..L3 flattened) | |||
| recipient_name | varchar(256) | ||
| recipient_phone | varchar(64) | ||
| full_address | varchar(1024) | ||
| postal_code | varchar(32) | ||
| region_code | varchar(8) | ||
| country | varchar(128) | ||
| state | varchar(128) | ||
| county | varchar(128) | ||
| city | varchar(128) | ||
| line item: these ARE safe to sum directly | |||
| line_item_idPrimary key. | varchar(64) | PK | Primary key. |
| product_id | varchar(64) | ||
| product_name | varchar(1024) | ||
| sku_id | varchar(64) | ||
| seller_sku | varchar(256) | ||
| sku_name | varchar(512) | ||
| sku_type | varchar(64) | ||
| line_original_price | decimal(18,4) | ||
| line_sale_price | decimal(18,4) | ||
| line_seller_discount | decimal(18,4) | ||
| line_platform_discount | decimal(18,4) | ||
| package_id | varchar(64) | ||
| package_status | varchar(64) | ||
| line_display_status | varchar(64) | ||
| line_shipping_provider_name | varchar(256) | ||
| line_tracking_number | varchar(128) | ||
| grain helpers + housekeeping | |||
| order_line_count | integer | ||
| is_order_first_line1 on the first line of each order. Filter on it before summing order-level (order_*) amounts. | smallint | 1 on the first line of each order. Filter on it before summing order-level (order_*) amounts. | |
| shop_id | varchar(64) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. | |
shop_performance_daily29 columns · Shop & product analyticsshow in diagram
Primary key: date
| Column | Type | Key | Description |
|---|---|---|---|
| datePrimary key. Redshift SORTKEY. | date | PK | Primary key. Redshift SORTKEY. |
| currency | varchar(8) | ||
| gmv | decimal(18,4) | ||
| orders | integer | ||
| sku_orders | integer | ||
| units_sold | integer | ||
| buyers | integer | ||
| avg_order_value | decimal(18,4) | ||
| refunds | decimal(18,4) | ||
| cancellations_and_returns | integer | ||
| product_impressions | bigint | ||
| product_page_views | bigint | ||
| avg_product_page_visitors | bigint | ||
| gmv_live | decimal(18,4) | ||
| gmv_video | decimal(18,4) | ||
| gmv_product_card | decimal(18,4) | ||
| impressions_live | bigint | ||
| impressions_video | bigint | ||
| impressions_product_card | bigint | ||
| page_views_live | bigint | ||
| page_views_video | bigint | ||
| page_views_product_card | bigint | ||
| buyers_live | integer | ||
| buyers_video | integer | ||
| buyers_product_card | integer | ||
| visitors_live | bigint | ||
| visitors_video | bigint | ||
| visitors_product_card | bigint | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
product_performance_daily9 columns · Shop & product analyticsshow in diagram
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| product_idJoins to orders.product_id. | varchar(64) | FK | Joins to orders.product_id. |
| currency | varchar(8) | ||
| gmv | decimal(18,4) | ||
| orders | integer | ||
| units_sold | integer | ||
| click_through_rate | decimal(10,6) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
sku_performance_daily9 columns · Shop & product analyticsshow in diagram
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateJoins to product_performance_daily.product_id,date. Redshift SORTKEY. | date | FK | Joins to product_performance_daily.product_id,date. Redshift SORTKEY. |
| sku_idJoins to orders.sku_id. | varchar(64) | FK | Joins to orders.sku_id. |
| product_idJoins to product_performance_daily.product_id,date. | varchar(64) | FK | Joins to product_performance_daily.product_id,date. |
| currency | varchar(8) | ||
| gmv | decimal(18,4) | ||
| sku_orders | integer | ||
| units_sold | integer | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
video_performance_daily9 columns · Videos & LIVEshow in diagram
Video & photo overview, daily (202509 shop_videos/overview_performance). Matches Seller Center's "Video & photo" view (photo-inclusive scope).
Primary key: date
| Column | Type | Key | Description |
|---|---|---|---|
| datePrimary key. Redshift SORTKEY. | date | PK | Primary key. Redshift SORTKEY. |
| currency | varchar(8) | ||
| gmv | decimal(18,4) | ||
| sku_orders | integer | ||
| avg_customers | integer | ||
| product_impressions | bigint | ||
| product_clicks | bigint | ||
| click_through_rate | decimal(10,6) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
videos7 columns · Videos & LIVEshow in diagram
Every video ever posted (identity only; the date window on the source endpoint scopes metrics, not membership — so this is complete history). "Video posts per day/week" = COUNT(*) grouped on video_post_time.
Primary key: video_id
| Column | Type | Key | Description |
|---|---|---|---|
| video_idPrimary key. | varchar(64) | PK | Primary key. |
| username | varchar(256) | ||
| title | varchar(1000) | ||
| video_post_timeRedshift SORTKEY. | timestamp | Redshift SORTKEY. | |
| duration_seconds | integer | ||
| product_ids | varchar(2000) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
video_performance_by_video14 columns · Videos & LIVEshow in diagram
Sales-active videos only, day x video grain (creator attribution).
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| video_idReferences videos.video_id. | varchar(64) | FK | References videos.video_id. |
| username | varchar(256) | ||
| video_post_time | timestamp | ||
| currency | varchar(8) | ||
| gmv | decimal(18,4) | ||
| gpm | decimal(18,4) | ||
| sku_orders | integer | ||
| items_sold | integer | ||
| avg_customers | integer | ||
| views | bigint | ||
| click_through_rate | decimal(10,6) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
live_performance17 columns · Videos & LIVEshow in diagram
One row per LIVE stream session (zero-sale sessions kept — session counts are a metric). Rates stored as fractions (0.0571 = 5.71%).
Primary key: live_id
| Column | Type | Key | Description |
|---|---|---|---|
| live_idPrimary key. | varchar(64) | PK | Primary key. |
| username | varchar(256) | ||
| title | varchar(500) | ||
| start_timeRedshift SORTKEY. | timestamp | Redshift SORTKEY. | |
| end_time | timestamp | ||
| currency | varchar(8) | ||
| gmv | decimal(18,4) | ||
| gmv_24h | decimal(18,4) | ||
| sku_orders | integer | ||
| created_sku_orders | integer | ||
| items_sold | integer | ||
| customers | integer | ||
| avg_price | decimal(18,4) | ||
| click_to_order_rate | decimal(10,6) | ||
| products_added | integer | ||
| different_products_sold | integer | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
live_product_performance21 columns · Videos & LIVEshow in diagram
Per-LIVE product breakdown (202512). Only the shop's OWN official/ marketing account lives have rows — affiliate creator lives return no data from TikTok. Join live_id to live_performance for session context.
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| live_idReferences live_performance.live_id. Redshift SORTKEY. | varchar(64) | FK | References live_performance.live_id. Redshift SORTKEY. |
| product_id | varchar(64) | ||
| product_name | varchar(1000) | ||
| currency | varchar(8) | ||
| direct_gmv | decimal(18,4) | ||
| avg_price | decimal(18,4) | ||
| sku_orders | integer | ||
| created_sku_orders | integer | ||
| main_orders | integer | ||
| customers | integer | ||
| items_sold | integer | ||
| payment_rate | decimal(10,6) | ||
| add_to_cart_count | integer | ||
| product_impressions | bigint | ||
| product_clicks | bigint | ||
| ctr | decimal(10,6) | ||
| main_order_ctor | decimal(10,6) | ||
| sku_order_ctor | decimal(10,6) | ||
| watch_gpm | decimal(18,4) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
bestselling_products10 columns · Bestsellers (platform-wide)show in diagram
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| time_slot | varchar(4) | ||
| rank | integer | ||
| product_id | varchar(64) | ||
| product_name | varchar(1000) | ||
| currency | varchar(8) | ||
| gmv_low | decimal(18,4) | ||
| gmv_high | decimal(18,4) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
bestselling_creators13 columns · Bestsellers (platform-wide)show in diagram
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| time_slot | varchar(4) | ||
| rank | integer | ||
| username | varchar(256) | ||
| nick_name | varchar(256) | ||
| open_id | varchar(128) | ||
| followers_count | bigint | ||
| likes_count | bigint | ||
| currency | varchar(8) | ||
| gmv_low | decimal(18,4) | ||
| gmv_high | decimal(18,4) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
bestselling_videos16 columns · Bestsellers (platform-wide)show in diagram
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| time_slot | varchar(4) | ||
| rank | integer | ||
| video_id | varchar(64) | ||
| nick_name | varchar(256) | ||
| duration_seconds | integer | ||
| likes | bigint | ||
| comments | bigint | ||
| publish_time | timestamp | ||
| top_product_id | varchar(64) | ||
| top_product_name | varchar(500) | ||
| currency | varchar(8) | ||
| gmv_low | decimal(18,4) | ||
| gmv_high | decimal(18,4) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
bestselling_lives15 columns · Bestsellers (platform-wide)show in diagram
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| time_slot | varchar(4) | ||
| rank | integer | ||
| live_id | varchar(64) | ||
| creator_name | varchar(256) | ||
| creator_nick_name | varchar(256) | ||
| open_id | varchar(128) | ||
| title | varchar(500) | ||
| start_time | timestamp | ||
| duration_seconds | integer | ||
| currency | varchar(8) | ||
| gmv_low | decimal(18,4) | ||
| gmv_high | decimal(18,4) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
finance_statements15 columns · Financeshow in diagram
One row per statement (a shop can get 2+ per day: orders + adjustments). Upsert key statement_id; re-pulled over a trailing window so payment status/payment_id updates land.
Primary key: statement_id
| Column | Type | Key | Description |
|---|---|---|---|
| statement_idPrimary key. | varchar(64) | PK | Primary key. |
| statement_time_utc | timestamp | ||
| statement_dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| currency | varchar(8) | ||
| settlement_amount | decimal(18,4) | ||
| revenue_amount | decimal(18,4) | ||
| net_sales_amount | decimal(18,4) | ||
| fee_amount | decimal(18,4) | ||
| shipping_cost_amount | decimal(18,4) | ||
| adjustment_amount | decimal(18,4) | ||
| payment_status | varchar(32) | ||
| payment_idReferences finance_payments.payment_id. | varchar(64) | FK | References finance_payments.payment_id. |
| payment_time_utc | timestamp | ||
| shop_id | varchar(64) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
finance_statement_transactions87 columns · Financeshow in diagram
One row per transaction in a statement: an ORDER settlement, an adjustment (type = the adjustment policy, e.g. CHARGE_BACK) or a RESERVE movement. Upsert key pk = md5(statement_id|transaction_id). Breakdown groups each sum to their parent amount: revenue_amount = gross_sales .. other_revenue_amount shipping_cost_amount = actual_shipping_fee .. other_shipping_amount fee_tax_amount = platform_commission .. other_tax_amount The "supplementary" columns are informational (TikTok reports them but they do not add into the settlement). breakdown_json keeps every non-zero breakdown value as returned, so new TikTok fee lines are never lost.
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| statement_idReferences finance_statements.statement_id. | varchar(64) | FK | References finance_statements.statement_id. |
| statement_time_utc | timestamp | ||
| statement_dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| transaction_id | varchar(64) | ||
| transaction_type | varchar(64) | ||
| order_idJoins to orders.order_id. Redshift DISTKEY. | varchar(64) | FK | Joins to orders.order_id. Redshift DISTKEY. |
| order_create_time_utc | timestamp | ||
| adjustment_id | varchar(64) | ||
| adjustment_order_id | varchar(64) | ||
| reserve_id | varchar(64) | ||
| reserve_status | varchar(32) | ||
| associated_order_id | varchar(64) | ||
| estimated_release_time_utc | timestamp | ||
| currency | varchar(8) | ||
| totals | |||
| settlement_amount | decimal(18,4) | ||
| revenue_amount | decimal(18,4) | ||
| shipping_cost_amount | decimal(18,4) | ||
| fee_tax_amount | decimal(18,4) | ||
| adjustment_amount | decimal(18,4) | ||
| reserve_amount | decimal(18,4) | ||
| revenue breakdown (sums to revenue_amount) | |||
| gross_sales_amount | decimal(18,4) | ||
| gross_sales_refund_amount | decimal(18,4) | ||
| seller_discount_amount | decimal(18,4) | ||
| seller_discount_refund_amount | decimal(18,4) | ||
| other_revenue_amount | decimal(18,4) | ||
| shipping breakdown (sums to shipping_cost_amount) | |||
| actual_shipping_fee_amount | decimal(18,4) | ||
| shipping_fee_discount_amount | decimal(18,4) | ||
| customer_paid_shipping_fee_amount | decimal(18,4) | ||
| return_shipping_fee_amount | decimal(18,4) | ||
| fbt_free_shipping_fee_amount | decimal(18,4) | ||
| fbt_fulfillment_fee_reimbursement_amount | decimal(18,4) | ||
| shipping_insurance_fee_amount | decimal(18,4) | ||
| signature_confirmation_fee_amount | decimal(18,4) | ||
| logistics_service_fee_amount | decimal(18,4) | ||
| other_shipping_amount | decimal(18,4) | ||
| shipping, informational (not addends): the TikTok Shop shipping incentive is part of shipping_fee_discount_amount | |||
| tts_shipping_incentive_amount | decimal(18,4) | ||
| fbt_fulfillment_fee_amount | decimal(18,4) | ||
| fbt_shipping_cost_amount | decimal(18,4) | ||
| fbm_shipping_cost_amount | decimal(18,4) | ||
| platform_shipping_fee_discount_amount | decimal(18,4) | ||
| seller_shipping_fee_discount_amount | decimal(18,4) | ||
| customer_shipping_fee_offset_amount | decimal(18,4) | ||
| fees + taxes (sum to fee_tax_amount) | |||
| platform_commission_amount | decimal(18,4) | ||
| referral_fee_amount | decimal(18,4) | ||
| refund_administration_fee_amount | decimal(18,4) | ||
| transaction_fee_amount | decimal(18,4) | ||
| credit_card_handling_fee_amount | decimal(18,4) | ||
| affiliate_commission_amount | decimal(18,4) | ||
| affiliate_partner_commission_amount | decimal(18,4) | ||
| affiliate_ads_commission_amount | decimal(18,4) | ||
| affiliate_commission_deposit_amount | decimal(18,4) | ||
| affiliate_commission_release_amount | decimal(18,4) | ||
| cofunded_creator_bonus_amount | decimal(18,4) | ||
| tap_shop_ads_commission_amount | decimal(18,4) | ||
| external_affiliate_marketing_fee_amount | decimal(18,4) | ||
| gmv_max_ad_fee_amount | decimal(18,4) | ||
| gmv_max_coupon_fee_amount | decimal(18,4) | ||
| smart_promotion_fee_amount | decimal(18,4) | ||
| campaign_period_fee_amount | decimal(18,4) | ||
| flash_sales_service_fee_amount | decimal(18,4) | ||
| sfp_service_fee_amount | decimal(18,4) | ||
| live_specials_fee_amount | decimal(18,4) | ||
| bonus_cashback_service_fee_amount | decimal(18,4) | ||
| voucher_xtra_service_fee_amount | decimal(18,4) | ||
| cofunded_promotion_service_fee_amount | decimal(18,4) | ||
| seller_growth_fee_amount | decimal(18,4) | ||
| epr_pob_service_fee_amount | decimal(18,4) | ||
| other_fee_amount | decimal(18,4) | ||
| sales_tax_on_fees_amount | decimal(18,4) | ||
| vat_amount | decimal(18,4) | ||
| import_vat_amount | decimal(18,4) | ||
| customs_duty_amount | decimal(18,4) | ||
| other_tax_amount | decimal(18,4) | ||
| supplementary (informational) | |||
| customer_payment_amount | decimal(18,4) | ||
| customer_refund_amount | decimal(18,4) | ||
| platform_discount_amount | decimal(18,4) | ||
| platform_discount_refund_amount | decimal(18,4) | ||
| seller_cofunded_discount_amount | decimal(18,4) | ||
| seller_cofunded_discount_refund_amount | decimal(18,4) | ||
| platform_cofunded_discount_amount | decimal(18,4) | ||
| platform_cofunded_discount_refund_amount | decimal(18,4) | ||
| sales_tax_amount | decimal(18,4) | ||
| retail_delivery_fee_amount | decimal(18,4) | ||
| breakdown_json | varchar(8000) | ||
| shop_id | varchar(64) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. | |
finance_payments14 columns · Financeshow in diagram
Payouts to the seller's bank account. Upsert key payment_id.
Primary key: payment_id
| Column | Type | Key | Description |
|---|---|---|---|
| payment_idPrimary key. | varchar(64) | PK | Primary key. |
| create_time_utcRedshift SORTKEY. | timestamp | Redshift SORTKEY. | |
| paid_time_utc | timestamp | ||
| status | varchar(32) | ||
| amount | decimal(18,4) | ||
| currency | varchar(8) | ||
| settlement_amount | decimal(18,4) | ||
| settlement_currency | varchar(8) | ||
| amount_before_exchange | decimal(18,4) | ||
| currency_before_exchange | varchar(8) | ||
| exchange_rate | decimal(18,6) | ||
| bank_account_last4 | varchar(4) | ||
| shop_id | varchar(64) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
finance_withdrawals8 columns · Financeshow in diagram
Seller balance movements: SETTLE (statement credited), WITHDRAW (payout), TRANSFER (platform subsidy/deduction), REVERSE (failed payout). Upsert key withdrawal_id.
Primary key: withdrawal_id
| Column | Type | Key | Description |
|---|---|---|---|
| withdrawal_idPrimary key. | varchar(64) | PK | Primary key. |
| withdrawal_type | varchar(32) | ||
| status | varchar(32) | ||
| amount | decimal(18,4) | ||
| currency | varchar(8) | ||
| create_time_utcRedshift SORTKEY. | timestamp | Redshift SORTKEY. | |
| shop_id | varchar(64) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
finance_unsettled_transactions32 columns · Financeshow in diagram
SNAPSHOT of transactions not yet settled (orders created since 2025-01-01), with TikTok's ESTIMATED amounts. Each run replaces the shop's rows (upsert key shop_id); once a transaction settles it leaves this table and appears in finance_statement_transactions with final amounts.
Primary key: shop_id, order_id
| Column | Type | Key | Description |
|---|---|---|---|
| transaction_id | varchar(64) | ||
| transaction_type | varchar(64) | ||
| status | varchar(32) | ||
| order_idPrimary key (with shop_id). Joins to orders.order_id. | varchar(64) | PK FK | Primary key (with shop_id). Joins to orders.order_id. |
| adjustment_id | varchar(64) | ||
| adjustment_order_id | varchar(64) | ||
| order_create_time_utcRedshift SORTKEY. | timestamp | Redshift SORTKEY. | |
| order_delivery_time_utc | timestamp | ||
| estimated_settlement_time_utc | timestamp | ||
| estimated_settlement_note | varchar(256) | ||
| unsettled_reason | varchar(512) | ||
| currency | varchar(8) | ||
| est_settlement_amount | decimal(18,4) | ||
| est_revenue_amount | decimal(18,4) | ||
| est_shipping_cost_amount | decimal(18,4) | ||
| est_fee_tax_amount | decimal(18,4) | ||
| est_adjustment_amount | decimal(18,4) | ||
| gross_sales_amount | decimal(18,4) | ||
| gross_sales_refund_amount | decimal(18,4) | ||
| seller_discount_amount | decimal(18,4) | ||
| seller_discount_refund_amount | decimal(18,4) | ||
| actual_shipping_fee_amount | decimal(18,4) | ||
| shipping_fee_discount_amount | decimal(18,4) | ||
| customer_paid_shipping_fee_amount | decimal(18,4) | ||
| platform_commission_amount | decimal(18,4) | ||
| referral_fee_amount | decimal(18,4) | ||
| affiliate_commission_amount | decimal(18,4) | ||
| affiliate_partner_commission_amount | decimal(18,4) | ||
| affiliate_ads_commission_amount | decimal(18,4) | ||
| breakdown_json | varchar(8000) | ||
| shop_idPrimary key (with order_id). | varchar(64) | PK | Primary key (with order_id). |
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |