Finance reports

Finance reports

Schema Name - tiktok_source_data

Payments

Table Name: tiktok_shop_payments

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
payment_id	String	Unique payment identifier
downloaded_date	Date	Date the data was downloaded
create_time	DateTime	Timestamp when the payment was created
paid_time	DateTime	Timestamp when the payment was completed
status	String	Payment status, such as PROCESSING, PAID, or FAILED.
bank_account	String	Bank account receiving the payment
exchange_rate	Numeric	Exchange rate used for currency conversion
amount_value	Numeric	Payment amount in shop currency
amount_currency	String	Shop currency code
settlement_amount_value	Numeric	Settlement amount in the bank account currency
settlement_amount_currency	String	Settlement currency code
reserve_amount_value	Numeric	Amount held in reserve
reserve_amount_currency	String	Reserve currency code
payment_amount_before_exchange_value	Numeric	Payment amount before currency exchange
payment_amount_before_exchange_currency	String	Currency before exchange
download_time	DateTime	Timestamp when the record was ingested

Statements

Table Name: tiktok_shop_statements

Column Name	Data type	Description
id	Integer	Auto-increment surrogate key
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
statement_id	String	Unique financial statement identifier
downloaded_date	Date	Date the data was downloaded
statement_time	DateTime	Timestamp of the statement period
payment_status	String	Payment status for this statement
payment_id	String	Associated payment identifier
settlement_amount	Numeric	Net settlement amount
currency	String	Currency code
revenue_amount	Numeric	Total revenue in this statement
fee_amount	Numeric	Total fees in this statement
adjustment_amount	Numeric	Total adjustments in this statement
net_sales_amount	Numeric	Net sales after refunds
shipping_cost_amount	Numeric	Total shipping costs
download_time	DateTime	Timestamp when the record was ingested

Withdrawals

Table Name: tiktok_shop_withdrawals

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
withdrawal_id	String	Unique withdrawal request identifier
downloaded_date	Date	Date the data was downloaded
type	String	Withdrawal type
amount	Numeric	Withdrawal amount
currency	String	Currency code
status	String	Withdrawal status: PENDING, PROCESSING, COMPLETED, or FAILED.
create_time	DateTime	Timestamp when the withdrawal was created
download_time	DateTime	Timestamp when the record was ingested

Unsettled transactions

Table Name: tiktok_shop_unsettled_transactions

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
transaction_id	String	Unique unsettled transaction identifier
downloaded_date	Date	Date the data was downloaded
type	String	Transaction type
status	String	Transaction settlement status
currency	String	Currency code
estimated_settlement	String	Estimated settlement date range
unsettled_reason	String	Reason the transaction is unsettled
order_id	String	Associated order identifier
adjustment_id	String	Adjustment identifier
adjustment_order_id	String	Associated adjustment order
order_create_time	DateTime	Associated order creation time
order_delivery_time	DateTime	Associated order delivery time
est_adjustment_amount	Numeric	Estimated adjustment
est_settlement_amount	Numeric	Estimated settlement
est_revenue_amount	Numeric	Estimated revenue
est_shipping_cost_amount	Numeric	Estimated shipping cost
est_fee_tax_amount	Numeric	Estimated fee tax
sum_est_settlement_amount	Numeric	Total estimated settlement
sum_est_revenue_amount	Numeric	Total estimated revenue
sum_est_adjustment_amount	Numeric	Total estimated adjustments
sum_est_fee_amount	Numeric	Total estimated fees
revenue_subtotal_before_discount_amount	Numeric	Revenue before discounts
revenue_seller_discount_amount	Numeric	Seller discount
revenue_refund_subtotal_before_discount_amount	Numeric	Refunded subtotal before discounts
revenue_seller_discount_refund_amount	Numeric	Refunded seller discount
revenue_cod_service_fee_amount	Numeric	COD service fee revenue
revenue_refund_cod_service_fee_amount	Numeric	Refunded COD service fee
shipping_actual_shipping_fee_amount	Numeric	Actual shipping fee
shipping_shipping_fee_discount_amount	Numeric	Shipping discount
shipping_customer_paid_shipping_fee_amount	Numeric	Customer-paid shipping fee
shipping_return_shipping_fee_amount	Numeric	Return shipping fee
shipping_replacement_shipping_fee_amount	Numeric	Replacement shipping fee
shipping_exchange_shipping_fee_amount	Numeric	Exchange shipping fee
shipping_signature_confirmation_fee_amount	Numeric	Signature confirmation fee
shipping_shipping_insurance_fee_amount	Numeric	Shipping insurance fee
shipping_customer_shipping_fee_offset_amount	Numeric	Customer shipping offset
shipping_shipping_fee_subsidy_amount	Numeric	Shipping subsidy
shipping_platform_shipping_fee_discount_amount	Numeric	Platform shipping discount
shipping_fbm_shipping_cost_amount	Numeric	FBM shipping cost
shipping_fbt_shipping_cost_amount	Numeric	FBT shipping cost
shipping_promo_shipping_incentive_amount	Numeric	Promotional shipping incentive
shipping_fbt_fulfillment_fee_amount	Numeric	FBT fulfillment fee
shipping_seller_shipping_fee_discount_amount	Numeric	Seller shipping discount
fee_platform_commission_amount	Numeric	Platform commission
fee_referral_fee_amount	Numeric	Referral fee
fee_refund_administration_fee_amount	Numeric	Refund administration fee
fee_transaction_fee_amount	Numeric	Transaction fee
fee_credit_card_handling_fee_amount	Numeric	Credit-card handling fee
fee_affiliate_commission_amount	Numeric	Affiliate commission
fee_affiliate_commission_before_pit_amount	Numeric	Affiliate commission before PIT
fee_pit_withheld_from_ads_commission_amount	Numeric	PIT withheld from ads commission
fee_affiliate_partner_commission_amount	Numeric	Affiliate partner commission
fee_affiliate_ads_commission_amount	Numeric	Affiliate ads commission
fee_sfp_service_fee_amount	Numeric	Seller Fulfilled Prime fee
fee_live_specials_fee_amount	Numeric	Live specials fee
fee_bonus_cashback_service_fee_amount	Numeric	Bonus cashback service fee
fee_mall_service_fee_amount	Numeric	Mall service fee
fee_retail_delivery_fee_amount	Numeric	Retail delivery fee
fee_retail_delivery_fee_payment_amount	Numeric	Retail delivery fee payment
fee_retail_delivery_fee_refund_amount	Numeric	Retail delivery fee refund
tax_sales_tax_amount	Numeric	Sales tax
tax_sales_tax_payment_amount	Numeric	Sales tax payment
tax_sales_tax_refund_amount	Numeric	Sales tax refund
tax_vat_amount	Numeric	VAT
tax_import_vat_amount	Numeric	Import VAT
tax_customs_duty_amount	Numeric	Customs duty
tax_customs_clearance_amount	Numeric	Customs clearance
tax_sst_amount	Numeric	SST
tax_gst_amount	Numeric	GST
download_time	DateTime	Timestamp when the record was ingested