| Table | Purpose | Columns | Rows | SIM/REAL | Downstream |
|---|
uc_tax_rate_card | HS code rate card | 0 | 0 | SIM_GENERATED 0 | Feeds import tax calc & quoting |
uc_tax_master | Tax master by period | 0 | 0 | SIM_GENERATED 0 | Aggregates uc_tax_detail |
uc_tax_detail | Tax detail per shipment/invoice | 0 | 0 | SIM_GENERATED 0 | Built from container lines & invoices |
uc_tax_confirmation | Tax confirmation (forward-only) | 0 | 0 | SIM_GENERATED 0 | Forward-only; filing = Human-Gate |
uc_containers | Container lifecycle + exception flag | 0 | 0 | SIM_GENERATED 0 | Feeds container follow-up alerts |
uc_container_lines | Container lines + landed cost | 0 | 0 | SIM_GENERATED 0 | Landed cost → product cost |
uc_scrm_customers | SCRM customers + follow-up states | 0 | 0 | SIM_GENERATED 0 | Drives repurchase reminders |
uc_scrm_followups | Follow-up events + AI drafts | 0 | 0 | SIM_GENERATED 0 | Feeds CS/sales boards |
uc_pod_merchants | POD merchants: craft/KYC/plan | 0 | 0 | SIM_GENERATED 0 | Partner reconciliation |
uc_pod_store_products | Merchant store products | 0 | 0 | SIM_GENERATED 0 | Feeds POD storefront |
uc_marketing_touch | Marketing touches | 0 | 0 | SIM_GENERATED 0 | Channel ROI pipeline |
dcs_final_live_module_record | V61 live records (44 modules) | 0 | 0 | SIM_GENERATED 0 | Main JOIN source for master tables |