[SOLD!] 9,071,287 rows of Chinese customers purchases
(9,071,287 rows not related to my other CN 200M leak. )
Samples
{
"_id":"pos_10143",
"_index":"",
"_score":null,
"_source":{
"@timestamp":"2022-11-10T12:18:28.522Z",
"@version":"1",
"achievamt":435,
"achievpayamt":435,
"actqty":1,
"amount":435,
"barcode":"DZWI-T9B40198V01L",
"baseamount":1690,
"baseprice":1690,
"billdate":"2020-01-11T00:00:00.000Z",
"billid":4637,
"billno":"PS2086-2020-01-12-0006",
"billtype":1,
"billtypename":"销售",
"brandid":1,
"brandname":"梵思诺",
"brandno":"0",
"businesstype":"possale",
"categoryid":1,
"categoryname":"默认品类",
"colorid":400,
"colorlabelid":0,
"colorlablename":"",
"colorname":"黑色",
"colorno":"98V",
"corpid":0,
"createtime":"2020-01-11 00:00:00",
"custcity":"",
"custcityid":0,
"custcounty":"",
"custcountyid":0,
"custextend1":"",
"custextend10":"",
"custextend2":"",
"custextend3":"",
"custextend4":"",
"custextend5":"",
"custextend6":"",
"custextend7":"",
"custextend8":"",
"custextend9":"",
"customerid":0,
"customername":"",
"customerno":"",
"custprovince":"",
"custprovinceid":0,
"custtypename":"",
"custypeid":0,
"datedate":"20200111",
"datemonth":"202001",
"dateweek":"202002",
"dateyear":"2020",
"departmentid":170,
"deptcity":"深圳市",
"deptcityid":440300,
"deptcode":"27550027",
"deptcounty":"盐田区",
"deptcountyid":440308,
"deptcustomer":"",
"deptdistrictid":13,
"deptdistrictleader":"",
"deptdistrictleaderid":0,
"deptdistrictname":"折扣店铺",
"deptextend1":null,
"deptextend10":null,
"deptextend2":"新渠道",
"deptextend3":"折扣店",
"deptextend4":"63",
"deptextend5":"其它",
"deptextend6":"T",
"deptextend7":"奥莱",
"deptextend8":null,
"deptextend9":null,
"deptkind":1,
"deptname":"深圳大梅沙奥特莱斯折扣店",
"deptprovince":"广东省",
"deptprovinceid":440000,
"depttypeid":7,
"depttypename":"总公司直营店",
"difqty":0,
"direction":-1,
"discamount":0,
"discountrate":1,
"empcity":"",
"empcityid":null,
"empcounty":"",
"empcountyid":null,
"empextend1":null,
"empextend10":null,
"empextend11":null,
"empextend12":null,
"empextend13":null,
"empextend14":null,
"empextend15":null,
"empextend16":null,
"empextend17":null,
"empextend18":null,
"empextend19":null,
"empextend2":null,
"empextend20":null,
"empextend21":null,
"empextend22":null,
"empextend23":null,
"empextend24":null,
"empextend25":null,
"empextend3":null,
"empextend4":null,
"empextend5":null,
"empextend6":null,
"empextend7":null,
"empextend8":null,
"empextend9":null,
"empprovince":"",
"empprovinceid":null,
"goodsattr":"1",
"goodsbaseprice_string":"1690.00",
"goodsbelong":"1",
"goodsdesigner":"",
"goodsextend1":null,
"goodsextend10":null,
"goodsextend11":null,
"goodsextend12":null,
"goodsextend13":null,
"goodsextend14":null,
"goodsextend15":null,
"goodsextend16":null,
"goodsextend17":null,
"goodsextend18":null,
"goodsextend19":null,
"goodsextend2":null,
"goodsextend20":null,
"goodsextend3":null,
"goodsextend4":null,
"goodsextend5":null,
"goodsextend6":null,
"goodsextend7":null,
"goodsextend8":"卫衣",
"goodsextend9":null,
"goodsid":6469,
"goodsmaterialflag":0,
"goodsname":"女装卫衣",
"goodsno":"DZWI-T9B401",
"goodspurchaseamount":185.76,
"goodspurchaseprice_string":"185.76",
"goodspurchaser":"",
"goodsretailprice_string":"1690.00",
"goodsseason":"秋冬特价",
"goodsseasonid":5,
"goodssex":"女",
"goodssexid":2,
"goodssupplierid":0,
"goodssuppliername":"",
"goodstype1id":2,
"goodstype1name":"上装",
"goodstype2id":29,
"goodstype2name":"卫衣",
"goodstype3id":507,
"goodstype3name":"无分类",
"goodsyear":"2019",
"goodsyearid":19,
"guidedeptcode":null,
"guidedeptid":null,
"guidedeptname":null,
"guideid":0,
"guidename":null,
"guideno":null,
"id":10143,
"insidecode":"",
"invoicetype":"pos",
"nontaxamtsum":0,
"noticeqty":1,
"onlineflag":0,
"patternid":1,
"patternname":"无",
"patternno":"0",
"payamt":435,
"price":1690,
"purchaseamount":0,
"purchaseprice":0,
"rdepartmentid":0,
"rdeptcity":"",
"rdeptcityid":0,
"rdeptcode":"",
"rdeptcounty":"",
"rdeptcountyid":0,
"rdeptcustomer":"",
"rdeptdistrictid":0,
"rdeptdistrictleader":"",
"rdeptdistrictleaderid":0,
"rdeptdistrictname":"",
"rdeptkind":0,
"rdeptname":"",
"rdeptprovince":"",
"rdeptprovinceid":0,
"rdepttypeid":0,
"rdepttypename":"",
"sizeid":8,
"sizeindex":107,
"sizename":"01L",
"sizeno":"01L",
"sourceid":0,
"sourcename":"",
"stockamt":0,
"stockbaseamt":0,
"stockqty":0,
"submitflag":2,
"submittime":"2020-01-10T16:00:00.000Z",
"supcity":"",
"supcityid":0,
"supcounty":"",
"supcountyid":0,
"supextend1":"",
"supextend10":"",
"supextend2":"",
"supextend3":"",
"supextend4":"",
"supextend5":"",
"supextend6":"",
"supextend7":"",
"supextend8":"",
"supextend9":"",
"suppliergoodsno":"",
"supplierid":0,
"suppliername":"",
"supplierno":"",
"supprovince":"",
"supprovinceid":0,
"suptypeid":0,
"suptypename":"",
"tags":[
"_rubyexception"
],
"type":"",
"updatedtime":"2020-01-11T00:00:00.000Z",
"vipbegindate":"2011-10-18",
"vipbirthday":"1975-06-25",
"vipcity":"",
"vipcityid":null,
"vipcode":"13970809992",
"vipcounty":"",
"vipcountyid":null,
"vipextend1":null,
"vipextend10":null,
"vipextend2":null,
"vipextend3":null,
"vipextend4":null,
"vipextend5":null,
"vipextend6":null,
"vipextend7":null,
"vipextend8":null,
"vipextend9":null,
"vipid":13787,
"vipmobile":"13970809992",
"vipname":"刘桂萍",
"vipprovince":"",
"vipprovinceid":null,
"vipsex":2,
"viptypeid":5,
"viptypename":"铂金卡"
},
"_type":"doc",
"sort":[
8
]
}More: https://pastehub.net/3a37a4e4614