Fulfillment by TikTok

Schema Name - tiktok_source_data

FBT goods

Table Name: tiktok_shop_fbt_goods

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
open_id	String	TikTok user open ID
goods_id	String	Unique FBT goods identifier
downloaded_date	Date	Date the data was downloaded
goods_name	String	FBT goods name
reference_code	String	Seller reference code
image_url	String	Goods image URL
merchant_declaration_weight_value	Numeric	Merchant-declared weight value
merchant_declaration_weight_unit	String	Merchant-declared weight unit
merchant_declaration_dimension_width	Numeric	Merchant-declared width
merchant_declaration_dimension_length	Numeric	Merchant-declared length
merchant_declaration_dimension_height	Numeric	Merchant-declared height
merchant_declaration_dimension_unit	String	Merchant-declared dimension unit
warehouse_confirmation_weight_value	Numeric	Warehouse-confirmed weight value
warehouse_confirmation_weight_unit	String	Warehouse-confirmed weight unit
warehouse_confirmation_dimension_width	Numeric	Warehouse-confirmed width
warehouse_confirmation_dimension_length	Numeric	Warehouse-confirmed length
warehouse_confirmation_dimension_height	Numeric	Warehouse-confirmed height
warehouse_confirmation_dimension_unit	String	Warehouse-confirmed dimension unit
is_lot_control	Boolean	Whether lot control is enabled
is_expiration_management	Boolean	Whether expiration management is enabled
shelf_life_days	Integer	Total shelf life in days
inbound_cutoff_days	Integer	Days before expiration when inbound stops
expiration_alert_days	Integer	Days before expiration when alerts begin
sales_cutoff_days	Integer	Days before expiration when sales stop
handling_method	String	Handling method for expired goods
return_cycle	String	Return-cycle policy
lot_expiration_address_name	String	Lot-expiration contact name
lot_expiration_address_phone_number	String	Lot-expiration contact phone number
lot_expiration_address_postal_code	String	Lot-expiration address postal code
lot_expiration_address_region_code	String	Lot-expiration address region code
lot_expiration_address_state	String	Lot-expiration address state
lot_expiration_address_district	String	Lot-expiration address district
lot_expiration_address_city	String	Lot-expiration address city
lot_expiration_address_line_1	String	Lot-expiration address line 1
lot_expiration_address_line_2	String	Lot-expiration address line 2
lot_expiration_address_line_3	String	Lot-expiration address line 3
download_time	DateTime	Timestamp when the record was ingested

FBT goods barcodes

Table Name: tiktok_shop_fbt_goods_barcodes

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
open_id	String	TikTok user open ID
goods_id	String	FBT goods identifier
downloaded_date	Date	Date the data was downloaded
barcode_code	String	Barcode value
barcode_type	String	Barcode type
download_time	DateTime	Timestamp when the record was ingested

FBT goods SKU regions

Table Name: tiktok_shop_fbt_goods_sku_regions

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
open_id	String	TikTok user open ID
goods_id	String	FBT goods identifier
sku_id	String	SKU identifier
downloaded_date	Date	Date the data was downloaded
region	String	Available sales region
download_time	DateTime	Timestamp when the record was ingested

FBT goods SKUs

Table Name: tiktok_shop_fbt_goods_skus

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
open_id	String	TikTok user open ID
goods_id	String	FBT goods identifier
sku_id	String	FBT SKU identifier
downloaded_date	Date	Date the data was downloaded
sku_name	String	SKU variant name
sku_image_url	String	SKU image URL
matched	Boolean	Whether the SKU matches a TikTok Shop SKU
product_id	String	Matched product identifier
product_name	String	Matched product name
product_image_url	String	Matched product image URL
download_time	DateTime	Timestamp when the record was ingested

FBT inventory

Table Name: tiktok_shop_fbt_inventory

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
open_id	String	TikTok user open ID
fbt_warehouse_id	String	FBT warehouse identifier
downloaded_date	Date	Date the inventory snapshot was downloaded
goods_id	String	FBT goods identifier
goods_reference_code	String	Seller goods reference code
goods_name	String	FBT goods name
on_hand_total_quantity	Integer	Total on-hand quantity
on_hand_available_quantity	Integer	Available quantity
on_hand_reserved_quantity	Integer	Reserved quantity
on_hand_unfulfillable_quantity	Integer	Unfulfillable quantity
in_transit_quantity	Integer	Quantity in transit
download_time	DateTime	Timestamp when the record was ingested

FBT inventory records

Table Name: tiktok_shop_fbt_inventory_records

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
open_id	String	TikTok user open ID
fbt_warehouse_id	String	FBT warehouse identifier
downloaded_date	Date	Date the data was downloaded
goods_id	String	FBT goods identifier
goods_reference_code	String	Seller goods reference code
goods_name	String	FBT goods name
order_id	String	Related order or inbound identifier
order_type	String	Transaction type
create_time	Integer	Creation Unix timestamp
inventory_goods_type	String	Inventory goods type
initial_on_hand_quantity	Integer	Quantity before the transaction
final_on_hand_quantity	Integer	Quantity after the transaction
changed_quantity	Integer	Net quantity change
download_time	DateTime	Timestamp when the record was ingested

FBT inventory SKUs

Table Name: tiktok_shop_fbt_inventory_skus

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
open_id	String	TikTok user open ID
fbt_warehouse_id	String	FBT warehouse identifier
goods_id	String	FBT goods identifier
downloaded_date	Date	Date the inventory snapshot was downloaded
sku_id	String	FBT SKU identifier
sku_on_hand_total_quantity	Integer	Total on-hand quantity
sku_on_hand_available_quantity	Integer	Available on-hand quantity
sku_on_hand_reserved_quantity	Integer	Reserved on-hand quantity
download_time	DateTime	Timestamp when the record was ingested

FBT warehouse addresses

Table Name: tiktok_shop_fbt_warehouse_addresses

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
open_id	String	TikTok user open ID
fbt_warehouse_id	String	FBT warehouse identifier
downloaded_date	Date	Date the data was downloaded
postal_code	String	Postal code
region_code	String	Country or region code
state	String	State or province
district	String	District
city	String	City
address_line_1	String	Address line 1
address_line_2	String	Address line 2
address_line_3	String	Address line 3
download_time	DateTime	Timestamp when the record was ingested

FBT warehouse logistics services

Table Name: tiktok_shop_fbt_warehouse_logistics_services

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
open_id	String	TikTok user open ID
fbt_warehouse_id	String	FBT warehouse identifier
downloaded_date	Date	Date the data was downloaded
logistics_service_id	String	Logistics service identifier
logistics_service_name	String	Logistics service name
subscribed	Boolean	Whether the service is subscribed
download_time	DateTime	Timestamp when the record was ingested

FBT warehouse mappings

Table Name: tiktok_shop_fbt_warehouse_warehouse_ids

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
open_id	String	TikTok user open ID
fbt_warehouse_id	String	FBT warehouse identifier
downloaded_date	Date	Date the data was downloaded
warehouse_id	String	Linked TikTok warehouse identifier
download_time	DateTime	Timestamp when the record was ingested

FBT warehouses

Table Name: tiktok_shop_fbt_warehouses

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
open_id	String	TikTok user open ID
fbt_warehouse_id	String	Unique FBT warehouse identifier
downloaded_date	Date	Date the data was downloaded
name	String	FBT warehouse name
type	String	FBT warehouse type
subscribed	Boolean	Whether the seller is subscribed
download_time	DateTime	Timestamp when the record was ingested