- Joined
- June 14, 2024
- Messages
- 2,652
- Reaction score
- 36,831
- Points
- 113
- Thread Author
-
- #1
Xiaomi China Database
Xiaomi China Database
xlsx")
Warehouse data ("brandWarehouse.xlsx")
Log files (TXT):
Email los (e.. "diff_mail.lo.txt", "aspdelivery_mail.lo.txt")
ERP synchronization logs
Shipping and inventory
SQL files:
Database dumps for inventory and ERP synchronization.
ZIP files:
Archives with additional data (e.. "Good_Parts_Return.zip", "Xiaomi Aborad Mobile Phone Reion Usae.zip").
Other files:
Data is organized by topic (warranty, parts, warehouses, ERP logs).
Significant data sets are related to the Chinese regions and Xiaomi's overseas operations.
Text files and logs are related to shipping, warehousing, and system integration.
Sample :
Code:
"Master Data" " " " " " " " " " " " " " " " " " " " " " " "IW Consumption" " " " " " " " " " " " " " " " " " " "Inventory" " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " "PO Plan" "Cust INV" "WOI Check" " " " " " " " " " " "Pending IW Qty" " " " " " " " " " " "Pending OOW Qty" " " " " " " " " " " "PNA IW Qty" " " " " " " " " " " "PNA OOW Qty" " " " " " " " " " " "Recover Plan" "" "" "" "" "" "" "" "" "OOW Consumption" " " " " " " " " " " " " " " " "
"Vendor" "PN" "PN Descripition" "ABC" "Group" "Sub List" "Category" "Lifecycle" "Model" "RemainWarrantyMonth" "TTLShippingmentQty" "Remain Iw Qty" "2020-09-07" "2020-08-31" "2020-08-24" "2020-08-17" "2020-08-10" "2020-08-03" "2020-07-27" "2020-07-20" "Avg Usage In Last 8wk" "Avg Usage In Last 4wk" "WIP in CCI+ASP" "OTW to CWH From Maitrox" "OTW to CWH From CCI" "CWH" "CCI" "ASP PO(OOW Negative)" "ASP" "Russia CDC" "Russia Customs" "Poland CDC" "Poland Customs" "Egypt CDC" "Egypt Customs" "Czech CDC" "Czech Customs" "Indonesia CDC" "Indonesia Customs" "Malaysia CDC" "Malaysia Customs" "Vietnam CDC" "Vietnam Customs" "Singapore CDC" "Singapore Customs" "South Korea CDC" "South Korea Customs" "The Republic of Turkey CDC" "The Republic of Turkey Customs" "Thailand CDC" "Thailand Customs" "Non-EU-HK CDC" "Non-EU-HK Customs" "EU-HK CDC" "EU-HK Customs" "Packed" "Backorder" "Parts to Order" "Cust support" "WOI at ASP" "WOI ASP+CDC" "WOI ASP+CDC+Custom" "WOI ASP+CDC+Custom+HK" "WOI ASP+CDC+Custom+HK+Packed" "WOI ASP+CDC+Custom+HK+Packed+OPO" "Aging 0~3" "Aging 4~7" "Aging 8~10" "Aging 11~15" "Aging 16~30" "Aging >30" "OOW Aging 0~3" "OOW Aging 4~7" "OOW Aging 8~10" "OOW Aging 11~15" "OOW Aging 16~30" "OOW Aging >30" "PNA Aging 0~3" "PNA Aging 4~7" "PNA Aging 8~10" "PNA Aging 11~15" "PNA Aging 16~30" "PNA Aging >30" "OOW PNA Aging 0~3" "OOW PNA Aging 4~7" "OOW PNA Aging 8~10" "OOW PNA Aging 11~15" "OOW PNA Aging 16~30" "OOW PNA Aging >30" "qty1" "ETA1" "WOI1" "qty2" "ETA2" "WOI2" "qty3" "ETA3" "WOI3" "2020-09-07" "2020-08-31" "2020-08-24" "2020-08-17" "2020-08-10" "2020-08-03" "2020-07-27" "2020-07-20" "Avg OOW Usage In Last 8wk" "Avg OOW Usage In Last 4wk"
"Mixtech" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "11" "0" "0" "11" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"DNS Service" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "2" "0" "2" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"CTDI M?©xico" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"CEAT ?©lectronique" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"Service Trade" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "20" "0" "0" "20" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"Video Pacini Srl" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "10" "0" "0" "10" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"CITYLIGHT TELECOM-XM" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"PT-TEE" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "25" "0" "0" "25" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"ANOVO(B2X)" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "100" "0" "0" "100" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"ES-TPH（B2X）" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"POL(B2X)" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "37" "0" "0" "37" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"IDRAYESC001-test" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"IDUNIMSC" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"IDIXMESC" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"IDRAYESC" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"IDUNIESC" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"IDTAMESC" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"IDTAMMSC" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "4" "0" "0" "4" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"The Phone House" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"SGIXMESC" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "10" "0" "0" "10" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"THVSPMSC" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "1" "0" "1" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"MYSEMMSC" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "5" "0" "5" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"MYOSRMSC" "320177309069 " "SPK_BOX_Dust-proof net+Sponge_A13" "C" "" "" "Consumable" "EOS" "Redmi 4X" "-7.6" "952296" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "5" "0" "5" "205" "0" "226" "0" "0" "0" "0" "0" "31" "0" "0" "0" "5" "0" "0" "0" "0" "0" "35" "0" "0" "0" "0" "0" "32" "0" "0" "0" "0" "0" "E" "E" "E" "E" "E" "E" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
Code:
"Region" "Master PN" "Description" "Price" "Sub parts" "Group" "Category" "Model" "Product Line" "Lanuch time" "202010????†…耗用" "202011????†…耗用" "202012????†…耗用" "202101????†…耗用" "202102????†…耗用" "202103????†…耗用" "202104????†…耗用" "202105????†…耗用" "202106????†…耗用" "202107????†…耗用" "202108????†…耗用" "202109????†…耗用" "202110????†…耗用" "202010耗用" "202011耗用" "202012耗用" "202101耗用" "202102耗用" "202103耗用" "202104耗用" "202105耗用" "202106耗用" "202107耗用" "202108耗用" "202109耗用" "202110耗用" "?€»??†??²è€—用é‡?" "?€»????†…??†??²è€—用é‡?" "?€»????¤–??†??²è€—用é‡?" "?œ€?—©è€—用?œˆ?»½" "?œ€?™?耗用?œˆ?»½" "è?‘?››?‘¨?¹³??‡è€—用" "è?‘?…«?‘¨?¹³??‡è€—用" "Region Available" "Unit inventory" "PL HUB" "PL In Transit" "RU HUB" "RU In Transit" "HK EU HUB" "HK EU In Transit" "HK Non EU HUB" "HK Non EU In Transit" "Open PR" "LTB Balance"
"Russian Federation" "100003400003" "Screw-M1.4*30" "0.0246" "" "" "Consumable" "Redmi Note 5A,Redmi Note 4X,Redmi Note 5A Prime,Redmi 5A,Redmi 2 Pro,Redmi Note 5,Redmi S2,Redmi Note,Redmi 2" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "1" "1" "0" "" "2018-03" "0" "0" "236" "0" "255" "0" "1310" "0" "0" "0" "136" "0" "0" "0"
"Russian Federation" "100005300003" "Screw-M1.4*H3.0" "0.0300" "" "" "Consumable" "Mi 6,Mi Mix 2S,Mi 8 Lite" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "0" "0" "63" "2" "507" "0" "120" "0" "0" "0" "966" "0" "0" "0"
"Russian Federation" "100005501003" "Screw-M1.4*H3.8-Yellow zinc" "0.0300" "" "" "Consumable" "Mi 6" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "0" "0" "14" "0" "52" "0" "20" "0" "0" "0" "0" "0" "0" "0"
"Russian Federation" "100006100003" "Screw-M1.4*H3.0-SUS" "0.0200" "" "" "Consumable" "Mi 6,Mi 8 Lite" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "0" "0" "58" "1" "256" "0" "105" "0" "0" "0" "930" "0" "0" "0"
"Russian Federation" "100006300003" "Screw-M1.4*2.5" "0.0400" "100073300003, 1000769X00E3" "Consumable045" "Consumable" "Redmi 4X,Redmi 4A,Redmi 3S,Redmi 3 Pro,Redmi 4,Redmi 5 Plus,Redmi 5,Mi Pad,Redmi 6A,Redmi 6,Mi A2,Redmi 3,Redmi Go" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "4" "4" "0" "" "2018-03" "0" "0" "1294" "4" "1638" "0" "2057" "90" "0" "0" "11032" "0" "0" "0"
"Russian Federation" "100006600003" "Screw-M1.4*H2.3-Blue zinc" "0.0300" "" "" "Consumable" "Mi 6,Mi Mix 2S,Mi 8 Lite" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "1" "1" "0" "" "2018-06" "0" "0" "58" "2" "332" "0" "120" "0" "0" "0" "966" "0" "0" "0"
"Russian Federation" "100009100003" "Screw-M1.4*2.0L" "0.0200" "1000770X00E3" "Consumable064" "Consumable" "Redmi 4A,Redmi Note 4X,Mi A2,Redmi 8A,Redmi 8,Redmi 8A Pro,Redmi Note 9,Redmi Note 9(NFC)" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "1" "1" "0" "" "2018-03" "0" "0" "2571" "70" "2044" "0" "3274" "0" "0" "0" "3080" "0" "0" "0"
"Russian Federation" "100010600003" "Self-tapping screw-CB1.4*3.0*2.5*0.5" "0.0200" "" "" "Consumable" "Redmi Note 4X" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "2" "2" "0" "" "2018-03" "0" "0" "6" "0" "145" "0" "234" "0" "0" "0" "36" "0" "0" "0"
"Russian Federation" "100073000003" "Screw-M1.4*2.65*0.3" "0.0200" "" "" "Consumable" "Mi Max 2" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "0" "0" "17" "0" "46" "0" "9" "0" "0" "0" "0" "0" "0" "0"
"Russian Federation" "281091600000" "Speaker-Redmi 3S" "0.4500" "281091600008" "Speaker004" "Speaker" "Redmi 4A,Redmi 3S" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "164" "162" "2" "" "2020-05" "0" "0" "11" "0" "93" "0" "9" "0" "0" "0" "3" "0" "0" "0"
"Russian Federation" "282003400000" "Receiver-Redmi Note 3" "0.0300" "282003600000, 282003200000, 282003400005, 282003400007" "Receiver010" "Receiver" "Redmi 4A,Redmi Note 3 Pro,Redmi 3S,Redmi 3 Pro,Mi Max,Redmi 4,Redmi Note 3,Redmi 3,Redmi Note 2" "Phone" "" "1" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "1" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "130" "130" "0" "" "2020-10" "0" "0" "11" "0" "65" "0" "4" "0" "0" "0" "154" "0" "0" "0"
"Russian Federation" "282003500000" "Receiver" "0.3900" "482112000036, 282003500004, 282003500036" "Receiver005" "Receiver" "Redmi 4X,Redmi 4A,Mi A1,Redmi Note 4X,Redmi 4,Redmi Pro,Mi A2" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "361" "359" "2" "" "2020-09" "0" "0" "14" "0" "1167" "0" "23" "0" "0" "0" "143" "0" "0" "0"
"Russian Federation" "282004501000" "Receiver-Mi6" "0.0100" "282004200000" "Receiver002" "Receiver" "Mi 6" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "36" "34" "2" "" "2019-04" "0" "0" "6" "0" "43" "0" "22" "0" "0" "0" "21" "0" "0" "0"
"Russian Federation" "282004400000" "Receiver-Mi Max2" "0.0100" "" "" "Receiver" "Mi Max 2" "Phone" "" "2" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "2" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "9" "9" "0" "" "2020-10" "0" "0" "12" "0" "11" "0" "13" "0" "0" "0" "4" "0" "0" "0"
"Russian Federation" "28405000BF08" "Camera-Front" "0.0300" "" "" "Camera" "Mi Max 2,Mi Max" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "16" "15" "1" "" "2019-08" "0" "0" "8" "0" "19" "0" "2" "0" "0" "0" "2" "0" "0" "0"
"Russian Federation" "28405001BF02" "Camera-Front-Redmi4A" "4.1700" "" "" "Camera" "Redmi 4A" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "64" "64" "0" "" "2019-07" "0" "0" "10" "0" "19" "0" "3" "0" "0" "0" "2" "0" "0" "0"
"Russian Federation" "284105B01076" "Camera-Front-C6" "0.0400" "28405003BF05" "Camera009" "Camera" "Redmi 4A,Redmi Note 4X" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "47" "47" "0" "" "2019-04" "0" "0" "18" "0" "17" "0" "5" "0" "0" "0" "0" "0" "0" "0"
"Russian Federation" "28405008BF05" "Camera-Front-Redmi4X" "0.0300" "" "" "Camera" "Redmi 4X" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "27" "27" "0" "" "2019-07" "0" "0" "8" "0" "41" "0" "0" "0" "0" "0" "0" "0" "0" "0"
"Russian Federation" "28408000BF03" "Camera-Front-Mi6" "0.0100" "28408000BF00" "Camera018" "Camera" "Mi 6" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "8" "8" "0" "" "2019-07" "0" "0" "7" "0" "15" "0" "1" "0" "0" "0" "3" "0" "0" "0"
"Russian Federation" "28412000BF06" "Camera-Rear-Mi6" "0.0600" "" "" "Camera" "Mi 6" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "16" "15" "1" "" "2019-09" "0" "0" "3" "0" "15" "0" "0" "0" "0" "0" "21" "0" "0" "0"
"Russian Federation" "2841300CBA05" "Camera-Rear-Redmi4A" "6.1600" "28413009BA02" "Camera004" "Camera" "Redmi 4A" "Phone" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "129" "128" "1" "" "" "0" "0" "8" "0" "13" "3" "3" "0" "0" "0" "0" "0" "0" "0"
Code:
Brand,PN,Category,PartsGroup,Model Type,Model PN,Country,Region,Country available inventory,2018-11,2018-12,2019-01,2019-02,2019-03,2019-04,2019-05,2019-06,2019-07,2019-08,2019-09,2018-11,2018-12,2019-01,2019-02,2019-03,2019-04,2019-05,2019-06,2019-07,2019-08,2019-09,2019-10,2019-11
Xiaomi-Oversea,413500120080 ,Camera,,Redmi 5 Plus,950E70060009,Singapore,Asia,5,,,,,,,,,,,,,,,,,,,,,,,,
Xiaomi-Oversea,453000064027 ,Coaxial Cable,,Mi A3,95F9S0160021,Italy,Europe,4,,,,,,,,,,,1000,,,,,,,,,,,,,
Xiaomi-Oversea,3400568200A4 ,Key,,Mi 8 Pro,95E1S0150025,Slovakia,Europe,0,100,,,,,,,,,,,,,,,,,,,,,,,
Xiaomi-Oversea,413500120080 ,Camera,,Redmi 5 Plus,950E70060001,Singapore,Asia,5,,,,,,,,,,,,,,,,,,,,,,,,
Xiaomi-Oversea,5604100430B6 ,TP Module,,Mi A2,95D2S00D0011,Singapore,Asia,6,,,,,,,,,,,,,,,1,,,1,,,,,1,
Xiaomi-Oversea,413500120080 ,Camera,,Redmi 5 Plus,950E70060005,Singapore,Asia,5,,,,,,,,,,,,,,,,,,,,,,,,
Xiaomi-Oversea,414130430076 ,Camera,,Mi 9T,95F100150031,Thailand,Asia,4,,,,,,,,,500,,,,,,,,,,,,,1,,
Xiaomi-Oversea,470005700000 ,Charger,Charger002,Redmi Note 6 Pro,95E7T0080018,Malaysia,Asia,43,,,,,,,,,,,,,,,,,,,,,,,,
Xiaomi-Oversea,3015864000A4 ,Key,,Mi A3,95F9S0180004,Switzerland ,,0,,,,,,,,,,100,,,,,,,,,,,,,,
Xiaomi-Oversea,301557200093 ,Sim Card Holder,,Redmi Go,95C3G0160005,Thailand,Asia,9,,,,4000,,,,,,,,,,,,,,,,,,,,
Xiaomi-Oversea,482115700000 ,Speaker,,Mi A3,95F9S0180021,Egypt,Africa,0,,,,,,,,,,700,1500,,,,,,,,,,,,,
Xiaomi-Oversea,5606100640C7 ,TP Module,,Redmi Note 6 Pro,95E7T0030018,Indonesia,Asia,100,9000,9640,800,120,,60,,40,,,,,,,,,4,2,,1,1,1,1,2
Xiaomi-Oversea,4830402000B0 ,FPC,,Mi 9T,95F100150032,Egypt,Africa,10,,,,,,,,,,,500,,,,,,,,,,,,,TB_HIDE_CONTENT