ALERT!
Click here to register with a few steps and explore all our cool stuff we have to offer!

Jump to content



Photo

Xiaomi China Database


  • This topic is locked This topic is locked
Xiaomi China Database

#1

zxcv16
zxcv16
    Offline
    23
    Rep
    1563
    Likes

    Veteran

Posts: 1109
Threads: 1048
Joined: Mar 06, 2023
Credits: 0

One year registered
#1

Xiaomi China Database

 

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.

 

Sample :

"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,,,,,,,,,,,,,

 

Download Link :

Hidden Content
You'll be able to see the hidden content once you reply to this topic or upgrade your account.


  • 2

#2

dlman2019
dlman2019
    Offline
    -2
    Rep
    17
    Likes

    Veteran

Posts: 1250
Threads: 29
Joined: Apr 23, 2019
Credits: 0

Five years registered
#2

thank you


  • 0

#3

pixelpot
pixelpot
    Offline
    0
    Rep
    1
    Likes

    Advanced Member

Posts: 101
Threads: 0
Joined: Aug 26, 2023
Credits: 0
One year registered
#3

 

 

nice catch. thanks


  • 0


 Users browsing this thread: and 1 guests