SUB-ZER0
Infinity Member
Golden Member
- Joined
- December 4, 2025
- Messages
- 1,238
- Reaction score
- 19,532
- Points
- 113
- Thread Author
- #1
Hello Darknetarmy Community
Today, I have shares the Xiaomi China Database for you to download. Thanks for reading and enjoy!
Today, I have shares the Xiaomi China Database for you to download. Thanks for reading and enjoy!
To see this hidden content, you need to "Reply & React" with one of the following reactions:
Quote:
"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"
Quote:
"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"
Quote:
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,,,,,,,,,,,,,
CSV files:
Service orders (Lenovo, Xiaomi)
Model warranty lists (PN, groups, regions)
Parts returns
Parts management (regional reports)
China warehouse map
Excel files (XLSX):
Shipping invoices ("bill_of_landing.xlsx")
Warehouse data ("brandWarehouse.xlsx")
Log files (TXT):
Email logs (e.g. "diff_mail.log.txt", "aspdelivery_mail.log.txt")
ERP synchronization logs
Shipping and inventory
SQL files:
Database dumps for inventory and ERP synchronization.
ZIP files:
Archives with additional data (e.g. "Good_Parts_Return.zip", "Xiaomi Aborad Mobile Phone Region Usage.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.
Service orders (Lenovo, Xiaomi)
Model warranty lists (PN, groups, regions)
Parts returns
Parts management (regional reports)
China warehouse map
Excel files (XLSX):
Shipping invoices ("bill_of_landing.xlsx")
Warehouse data ("brandWarehouse.xlsx")
Log files (TXT):
Email logs (e.g. "diff_mail.log.txt", "aspdelivery_mail.log.txt")
ERP synchronization logs
Shipping and inventory
SQL files:
Database dumps for inventory and ERP synchronization.
ZIP files:
Archives with additional data (e.g. "Good_Parts_Return.zip", "Xiaomi Aborad Mobile Phone Region Usage.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.