客户欠款管理系统

业务员客户简码客户全称项目2015年末余额1月发生额2月发生额2.29余款汇总汇总汇总1HZH-ARD欠款金额03505390HZH-ARD实收金额-350-539HZH-ARD优惠金额HZH-ARD备注1.14交行350发代收WBS-AGT欠款金额59900.515501550WBS-AGT实收金额-59900WBS-AGT优惠金额-0.5WBS-AGT备注01.11交通59900HGT-ABZ欠款金额0174770HGT-ABZ实收金额-17477HGT-ABZ优惠金额HGT-ABZ备注02.29交通17477QSK-ATG欠款金额015000QSK-ATG实收金额-1500QSK-ATG优惠金额QSK-ATG备注2月1日1500FWH-BTD欠款金额00FWH-BTD实收金额FWH-BTD优惠金额FWH-BTD备注FWH-BHM欠款金额6000-14000FWH-BHM实收金额-3000-1600FWH-BHM优惠金额FWH-BHM备注1.14平安30001.22现金1600HWX-TLJ欠款金额044000HWX-TLJ实收金额-1320-3080HWX-TLJ优惠金额HWX-TLJ备注12-14订金13201-8转3080平安FWH-BSB欠款金额052278750059778FWH-BSB实收金额FWH-BSB优惠金额FWH-BSB备注FWH-BER欠款金额032000FWH-BER实收金额-3200FWH-BER优惠金额FWH-BER备注1月29日招行3200FWH-BJH欠款金额0470470FWH-BJH实收金额-470FWH-BJH优惠金额FWH-BJH备注2.26发代收FWH-CJY欠款金额600011007100FWH-CJY实收金额FWH-CJY优惠金额FWH-CJY备注HJT-ZFF欠款金额05005000HJT-ZFF实收金额-500-500HJT-ZFF优惠金额HJT-ZFF备注1.6/2501.9/2502.20/2.29HJT-ZJU欠款金额05000HJT-ZJU实收金额-500HJT-ZJU优惠金额HJT-ZJU备注1.7现金500FWH-CBR欠款金额0FWH-CBR实收金额FWH-CBR优惠金额FWH-CBR备注FWH-CMK欠款金额63237312.53599.5FWH-CMK实收金额-100003月欠款回款明细FWH-CMK优惠金额-36FWH-CMK备注1月29交行10000FWH-CXH欠款金额138002054021840FWH-CXH实收金额-12500FWH-CXH优惠金额FWH-CXH备注1.29交行12500ZJM-DXG欠款金额1800012080240014480ZJM-DXG实收金额-6000ZJM-DXG优惠金额-12000ZJM-DXG备注1.1/60001.27/12000LQQ-DYK欠款金额01000LQQ-DYK实收金额-100LQQ-DYK优惠金额LQQ-DYK备注1.6发代收HJT-DDO欠款金额05400HJT-DDO实收金额-540HJT-DDO优惠金额HJT-DDO备注XSKD001563LQQ-DCT欠款金额0200200LQQ-DCT实收金额LQQ-DCT优惠金额LQQ-DCT备注HWH-JXY欠款金额00HWH-JXY实收金额-1500HWH-JXY优惠金额HWH-JXY备注2.29交行FWH-FLE欠款金额0FWH-FLE实收金额FWH-FLE优惠金额FWH-FLE备注SSO-YMJ欠款金额042751350SSO-YMJ实收金额-2925SSO-YMJ优惠金额SSO-YMJ备注1.26工商2925LQQ-FQS欠款金额020000LQQ-FQS实收金额-2000LQQ-FQS优惠金额LQQ-FQS备注1.26转交行QSK-FYZ欠款金额00QSK-FYZ实收金额QSK-FYZ优惠金额QSK-FYZ备注QSK-FWY欠款金额0QSK-FWY实收金额QSK-FWY优惠金额QSK-FWY备注QSK-GZY欠款金额0QSK-GZY实收金额QSK-GZY优惠金额QSK-GZY备注LQQ-HHJ欠款金额029000LQQ-HHJ实收金额-2900LQQ-HHJ优惠金额LQQ-HHJ备注2.7兴业2900HJT-FXS欠款金额010600HJT-FXS实收金额-1060HJT-FXS优惠金额HJT-FXS备注1.13转交行1060LQQ-FQM欠款金额027000LQQ-FQM实收金额-2700LQQ-FQM优惠金额LQQ-FQM备注1.8交1800/1.12现900HWX-QDM欠款金额015000HWX-QDM实收金额-1500HWX-QDM优惠金额HWX-QDM备注2.3兴业WBS-GZZ欠款金额60042507001620WBS-GZZ实收金额-4150WBS-GZZ优惠金额WBS-GZZ备注02.01转招商4150元LQQ-GZC欠款金额0LQQ-GZC实收金额LQQ-GZC优惠金额LQQ-GZC备注ZJM-GTD欠款金额05000ZJM-GTD实收金额-500ZJM-GTD优惠金额ZJM-GTD备注01.19转招商500HJT-GTW欠款金额0484484HJT-GTW实收金额HJT-GTW优惠金额HJT-GTW备注HWH-GZQ欠款金额00HWH-GZQ实收金额HWH-GZQ优惠金额HWH-GZQ备注HWX-HTY欠款金额04007000HWX-HTY实收金额-400-700HWX-HTY优惠金额HWX-HTY备注1.23招行4002.29招行700FWH-HTG欠款金额0FWH-HTG实收金额FWH-HTG优惠金额FWH-HTG备注HZH-HXC欠款金额034803480HZH-HXC实收金额HZH-HXC优惠金额HZH-HXC备注QSK-HRK欠款金额2857521009975QSK-HRK实收金额-20700QSK-HRK优惠金额QSK-HRK备注1月18日20700元HJT-HFD欠款金额04500HJT-HFD实收金额-450HJT-HFD优惠金额HJT-HFD备注XSKD001510HZH-HXI欠款金额01200HZH-HXI实收金额-120HZH-HXI优惠金额HZH-HXI备注1.27发代收QSK-HQW欠款金额020200QSK-HQW实收金额-2020QSK-HQW优惠金额QSK-HQW备注22交420/28交1600FWH-HPP欠款金额211715200506011431FWH-HPP实收金额-10000-10000FWH-HPP优惠金额FWH-HPP备注1.7收100002.2收10000HGT-JHX欠款金额0HGT-JHX实收金额HGT-JHX优惠金额HGT-JHX备注SSO-JXD欠款金额06273.76273.7SSO-JXD实收金额SSO-JXD优惠金额SSO-JXD备注LQQ-JYY欠款金额0075LQQ-JYY实收金额-75LQQ-JYY优惠金额LQQ-JYY备注代收SSO-JLB欠款金额1605010001000SSO-JLB实收金额-12550SSO-JLB优惠金额-3500SSO-JLB备注01.19转平安12550元FWH-JDZ欠款金额025000FWH-JDZ实收金额-2500FWH-JDZ优惠金额FWH-JDZ备注1.7招行2500元FWH-JZY欠款金额91501650018750FWH-JZY实收金额-6900FWH-JZY优惠金额FWH-JZY备注1.4招商6900元DHK-JYU欠款金额018001800DHK-JYU实收金额DHK-JYU优惠金额DHK-JYU备注FWH-JBL欠款金额041000FWH-JBL实收金额-3100-800FWH-JBL优惠金额-200FWH-JBL备注1.15现3100优惠200元1.21现金800元HJT-KXS欠款金额76.80HJT-KXS实收金额-76.8HJT-KXS优惠金额HJT-KXS备注XSKD001541XSKD001554FWH-KMC欠款金额0FWH-KMC实收金额FWH-KMC优惠金额FWH-KMC备注HWX-LXW欠款金额0900450HWX-LXW实收金额-450HWX-LXW优惠金额HWX-LXW备注2-3月支付宝HGT-YHZ欠款金额0HGT-YHZ实收金额HGT-YHZ优惠金额HGT-YHZ备注HWX-LXA欠款金额046080HWX-LXA实收金额-4600HWX-LXA优惠金额-8HWX-LXA备注优惠8元；1.22支付宝WBS-LRX欠款金额2800200032005200WBS-LRX实收金额-2800WBS-LRX优惠金额WBS-LRX备注2.2收2800ZJM-LYD欠款金额03990ZJM-LYD实收金额-399ZJM-LYD优惠金额ZJM-LYD备注1.6发代收LHJ-LHJ欠款金额9083.653470108013633LHJ-LHJ实收金额LHJ-LHJ优惠金额LHJ-LHJ备注HGT-LYW欠款金额00HGT-LYW实收金额HGT-LYW优惠金额HGT-LYW备注HGT-LZP欠款金额0HGT-LZP实收金额HGT-LZP优惠金额HGT-LZP备注TYQ-MTS欠款金额052800TYQ-MTS实收金额-5280TYQ-MTS优惠金额TYQ-MTS备注1.11招行5280HGT-MYX欠款金额11100535046009450HGT-MYX实收金额-11600HGT-MYX优惠金额HGT-MYX备注1.5收11600FWH-NTG欠款金额08000FWH-NTG实收金额-800FWH-NTG优惠金额FWH-NTG备注2.24微信800ZJM-PRX欠款金额458013034745079501680ZJM-PRX实收金额-9140-7974ZJM-PRX优惠金额ZJM-PRX备注1.13交行91401.28交货7974FWZ-QXY欠款金额0FWZ-QXY实收金额FWZ-QXY优惠金额FWZ-QXY备注HWX-QLQ欠款金额0HWX-QLQ实收金额HWX-QLQ优惠金额HWX-QLQ备注FWH-HYO欠款金额720079207920FWH-HYO实收金额-7200FWH-HYO优惠金额FWH-HYO备注1.12招行7200HZH-RTK欠款金额8139.8-1700HZH-RTK实收金额-7469.8-500HZH-RTK优惠金额HZH-RTK备注1.27交7469.81.29收500WBS-RYJ欠款金额14080448018560WBS-RYJ实收金额-11840WBS-RYJ优惠金额WBS-RYJ备注平安HGT-SHJ欠款金额010000HGT-SHJ实收金额-1000HGT-SHJ优惠金额HGT-SHJ备注1.19发代收HWX-SJD欠款金额22251090019700HWX-SJD实收金额-15095HWX-SJD优惠金额HWX-SJD备注2.29平安15095FWH-STH欠款金额056000FWH-STH实收金额-5600有些没出库FWH-STH优惠金额FWH-STH备注1.25招行5600QSK-SWD欠款金额4052.8914097.557000QSK-SWD实收金额-1700-610-20366QSK-SWD优惠金额-3549QSK-SWD备注1.4收17002.1收6102.2收款QSK-HWE欠款金额0QSK-HWE实收金额QSK-HWE优惠金额QSK-HWE备注HWX-NLT欠款金额01090810908HWX-NLT实收金额HWX-NLT优惠金额HWX-NLT备注SSO-HSY欠款金额5432.4810141256571.48SSO-HSY实收金额SSO-HSY优惠金额SSO-HSY备注FWH-JYB欠款金额011000FWH-JYB实收金额-500-600FWH-JYB优惠金额FWH-JYB备注1.8收5001.29收600QSK-JXF欠款金额0167100QSK-JXF实收金额-5950-5380-5380QSK-JXF优惠金额