file 74 订金与应收货款统计报表.xls

客户名单产品清单 客户代码客户名称产品代码产品名称单价 KF0001三友实业PD0001PHILIPS105CRT显示器788 KF0002明华集团PD0002PHILIPS105SCRT显示器988 KF0003华铁实业PD0003PHILIPS105TCRT显示器1088 KF0004大明集团PD0004PHILIPS105液晶显示器1188 KF0005鑫鑫实业PD0005PHILIPS107CRT显示器1288 KF0006吴氏集团PD0006PHILIPS107SCRT显示器1380 KF0007彬彬集团PD0007PHILIPS107TCRT显示器1488 KF0008创维新科PD0008PHILIPS107液晶显示器1588 KF0009宗胜实业PD0009PHILIPS109CRT显示器1688 KF0010佳佳公司PD0010PHILIPS109SCRT显示器1788 KF0011长安科技PD0011PHILIPS109TCRT显示器1888 KF0012APD0012PHILIPS109液晶显示器1988 KF0013BPD0013PHILIPS170CRT显示器2088 KF0014CPD0014PHILIPS170SCRT显示器2188 KF0015DPD0015PHILIPS170TCRT显示器2388 PD0016PHILIPS170液晶显示器2588 PD0017PHILIPS180CRT显示器2788 PD0018PHILIPS180SCRT显示器2988 PD0019PHILIPS180TCRT显示器3188 PD0020PHILIPS180液晶显示器3788 日日期期客客户户代代码码客客户户名名称称订订单单号号订订购购商商品品代代码码商商品品名名称称单单价价数数量量 2011 11 1 KF0001三友实业20111020 001 PD0001PHILIPS105CRT显示器78820 2011 11 5 KF0008创维新科20111020 002 PD0004PHILIPS105液晶显示器1188100 2011 11 6 KF0002明华集团20111020 003 PD0004PHILIPS105液晶显示器1188200 2011 11 7 KF0003华铁实业20111020 004 PD0006PHILIPS107SCRT显示器1380320 2011 11 8 KF0003华铁实业20111020 005 PD0007PHILIPS107TCRT显示器1488510 2011 11 8 KF0004大明集团20111020 006 PD0008PHILIPS107液晶显示器1588200 2011 11 8 KF0005鑫鑫实业20111020 007 PD0006PHILIPS107SCRT显示器1380450 2011 11 8 KF0006吴氏集团20111020 008 PD0004PHILIPS105液晶显示器1188630 2011 11 9 KF0007彬彬集团20111020 009 PD0002PHILIPS105SCRT显示器988120 2011 11 9 KF0003华铁实业20111020 010 PD0001PHILIPS105CRT显示器78880 2011 11 9 KF0003华铁实业20111020 011 PD0004PHILIPS105液晶显示器118890 2011 11 10 KF0004大明集团20111020 012 PD0004PHILIPS105液晶显示器118850 2011 11 10 KF0001三友实业20111020 013 PD0006PHILIPS107SCRT显示器138045 2011 11 10 KF0008创维新科20111020 014 PD0007PHILIPS107TCRT显示器1488120 2011 11 10 KF0002明华集团20111020 015 PD0008PHILIPS107液晶显示器158870 2011 11 12 KF0003华铁实业20111020 016 PD0009PHILIPS109CRT显示器168880 2011 11 12 KF0003华铁实业20111020 017 PD0010PHILIPS109SCRT显示器178820 2011 11 12 KF0004大明集团20111020 018 PD0011PHILIPS109TCRT显示器188812 2011 11 13 KF0005鑫鑫实业20111020 019 PD0012PHILIPS109液晶显示器198820 2011 11 14 KF0003华铁实业20111020 020 PD0013PHILIPS170CRT显示器208820 2011 11 15 KF0004大明集团20111020 021 PD0014PHILIPS170SCRT显示器218830 2011 11 16 KF0006吴氏集团20111020 022 PD0015PHILIPS170TCRT显示器238850 2011 11 17 KF0009宗胜实业20111020 023 PD0005PHILIPS107CRT显示器128850 2011 11 18 KF0010佳佳公司20111020 024 PD0007PHILIPS107TCRT显示器1488100 2011 11 19 KF0012A20111020 025 PD0002PHILIPS105SCRT显示器988200 2011 11 20 KF0013B20111020 026 PD0008PHILIPS107液晶显示器1588300 合合计计3 38 88 87 7 货货款款订订金金支支付付比比例例订订金金数数额额 1576020 3152 11880020 23760 23760020 47520 44160020 88320 75888020 151776 31760020 63520 62100020 124200 74844020 149688 11856020 23712 6304020 12608 10692020 21384 5940020 11880 6210020 12420 17856020 35712 11116020 22232 13504020 27008 3576020 7152 2265620 4531 2 3976020 7952 4176020 8352 6564020 13128 11940020 23880 6440020 12880 14880020 29760 19760020 39520 47640020 95280 1 10 06 61 13 32 27 7 2 2 订订金金与与应应收收货货款款统统计计报报表表 客户代码KF0003客户名称华铁实业订单数量7 货款总额1583000已收订金总额316600应收账款余额1266400 订单与应收账款明细 日期订单号商品名称单价数量货款总额 2011 11 120111020 004PHILIPS107SCRT显示器1380 00320 00441600 00 2011 11 820111020 005PHILIPS107TCRT显示器1488 00510 00758880 00 2011 11 920111020 010PHILIPS105CRT显示器788 0080 0063040 00 2011 11 920111020 011PHILIPS105液晶显示器1188 0090 00106920 00 2011 11 1220111020 016PHILIPS109CRT显示器1688 0080 00135040 00 2011 11 1220111020 017PHILIPS109SCRT显示器1788 0020 00357