{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["新格式","Sheet1","Sheet3"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"新格式","index":0,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,0,1,17],[3,0,3,3],[4,0,4,17]]}
[]
["无锡微纳产业发展有限公司预收、收款、预收冲应收、押金、退费数据"]
[]
["资料区间:2022-05-13~2022-05-17"]
[]
["固定勿删","固定勿删","客商名称","固定勿删","固定勿删","固定勿删","固定勿删","固定勿删","摘要及辅助","类别","固定勿删","固定勿删","固定勿删","固定勿删","金额（元）","固定勿删","固定勿删","固定勿删","收款银行账号"]
[null,null,"捷捷微电（无锡）科技有限公司",{"$nulls":5},"**（银行）收到**（公司）预收款***（到账日期）","收到预收款（除电费以外）220301","","",null,null,"=预收款到账金额",null,null,null,"=预收款到账银行名称及账号"]
[null,null,"无锡盛赛传感科技有限公司",{"$nulls":5},"**（银行）收到**（公司）预充电费***（到账日期）","收到预收款-电费2203020201","","",null,null,"=预收款到账金额",null,null,null,"=预收款到账银行名称及账号"]
[null,null,"无锡胜脉电子有限公司",{"$nulls":5},"**（银行）收到**（公司）首次入驻款#（楼栋房间号、楼栋房间号）【***（首笔款房租期间）】首笔房租&收入&种类&园区","收到首笔款112202","","",null,null,"=对应账单收款核销掉的金额",null,null,null,"=收款到账银行名称及账号"]
[null,null,"无锡胜脉电子有限公司",{"$nulls":5},"**（银行）收到**（公司）首次入驻款#（楼栋房间号、楼栋房间号）【***（首笔款物业费期间）】首笔物业费&收入&种类&园区","收到首笔款112202",{"$nulls":4},"=对应账单收款核销掉的金额",null,null,null,"=收款到账银行名称及账号"]
[null,null,"无锡胜脉电子有限公司",{"$nulls":5},"**（银行）收到**（公司）首次入驻款#（楼栋房间号、楼栋房间号）-入驻押金","收押金22419901",{"$nulls":4},"=对应保证金收款金额",null,null,null,"=收款到账银行名称及账号"]
[null,null,"无锡胜脉电子有限公司",{"$nulls":5},"**（银行）收到**（公司）款项&收入&种类&园区","收款凭证（到账核销）112202",{"$nulls":4},"=对应收款核销金额",null,null,null,"=收款到账银行名称及账号"]
[null,null,"无锡胜脉电子有限公司",{"$nulls":5},"**（银行）退还**（公司）入驻押金#（楼栋房间号、楼栋房间号）-抵应收款&收入&种类&园区","退房屋保证金112202",{"$nulls":4},"=对应退款金额",null,null,null,"=退保证金所选的银行名称及账号"]
[null,null,"无锡胜脉电子有限公司",{"$nulls":5},"**（银行）退还**（公司）入驻押金#（楼栋房间号、楼栋房间号）-抵退房房源修复费&收入&种类&园区","退房屋保证金112202",{"$nulls":4},"=对应退款金额",null,null,null,"=退保证金所选的银行名称及账号"]
[null,null,"无锡胜脉电子有限公司",{"$nulls":5},"**（银行）退还**（公司）入驻押金#（楼栋房间号、楼栋房间号）--抵退房电费&收入&种类&园区","退房屋保证金112202",{"$nulls":4},"=对应退款金额",null,null,null,"=退保证金所选的银行名称及账号"]
[null,null,"无锡胜脉电子有限公司",{"$nulls":5},"**银行退还**公司入驻押金#（楼栋房间号、楼栋房间号）","退房屋保证金1002-**",{"$nulls":4},"=对应退款金额",null,null,null,"=退保证金所选的银行名称及账号"]
[null,null,"无锡芯智感科技有限公司",{"$nulls":5},"**（公司）预收款项冲应收款项&收入&种类&园区","预收冲应收（除电费外）112202","","",null,null,"=对应预收款核销掉的金额",null,null,null,"/"]
[null,null,"无锡天青元储智能科技有限公司",{"$nulls":5},"**（公司）预收电费冲应收电费&收入&种类&园区","预收冲应收（电费）112202","","",null,null,"=对应预收款核销掉的金额",null,null,null,"/"]
[]
["注：备注栏中***表示系统动态数据；（）表示对动态数据的解释；&为固定符号，后面表示NC辅助项，需要系统自动根据对照关系显示对应的值（部分需要转化为NC编码）；#为固定符号，后面跟房间号，多房间号间用“、”隔开。"]
[null,"资料区间查取预收款到账日期、预收款核销日期、收款核销对应的到账日期、保证金到账日期、退费日期，查所选区间的所有数据清单"]
[null,"第一-第六行为固定，不可删除，列也不可删除、不可互换。"]
[{"$nulls":9},"预收类型","辅助核算"]
[{"$nulls":9},"电费预收",220302]
[{"$nulls":9},"其他",220301]

{"sheet":"Sheet1","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["预收、收款、预收核销"]
["类型","企业名称","统一信用代码","日期","收款银行","收款账号","费用类型","楼盘","房间号","房间用途","款项名称","金额（元）"]
["收款核销","无锡艾迪尔系统集成有限公司","91320211301985376L","2022-03-21","江苏银行","XXXXXXXXX","收房租","一期","一期/A栋/A-203,一期/A栋/A-204","办公楼","2022.3.12-2022.4.11房租",10000]
["收款核销","无锡艾迪尔系统集成有限公司","91320211301985376L","2022-03-21","江苏银行","XXXXXXXXX","收物业费","一期","一期/A栋/A-203,一期/A栋/A-204","办公楼","2022.3.12-2022.4.11物业费",2000]
["收款核销","无锡艾迪尔系统集成有限公司","91320211301985376L","2022-04-22","江苏银行","XXXXXXXXX","收水费","一期","一期/A栋/A-203,一期/A栋/A-204","商铺","5月水费",300]
["预收款","无锡艾迪尔系统集成有限公司","91320211301985376L","2022-04-22","江苏银行","XXXXXXXXX","电费预收","/","/","/","/",10000]
["预收款核销","无锡艾迪尔系统集成有限公司","91320211301985376L","2022-04-22","江苏银行","XXXXXXXXX","收电费","一期","一期/A栋/A-203,一期/A栋/A-204","研发","5月电费",800]
["预收款","无锡艾迪尔系统集成有限公司","91320211301985376L","2022-04-22","江苏银行","XXXXXXXXX","房租物业预收","/","/","/","/",20000]
["预收款核销","无锡艾迪尔系统集成有限公司","91320211301985376L","2022-03-21","江苏银行","XXXXXXXXX","房租核销","一期","一期/A栋/A-203,一期/A栋/A-204","研发","2022.3.12-2022.4.11房租",10000]
["预收款核销","无锡艾迪尔系统集成有限公司","91320211301985376L","2022-04-22","江苏银行","XXXXXXXXX","物业费核销","一期","一期/A栋/A-203,一期/A栋/A-204","办公楼","2022.3.12-2022.4.11物业费",10000]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}