项目生产管理系统表

,订单明细,序号名称规格单位数量单价总价,320.0677.0216640.0,DN600δ=10mm80.0501.040080.0,3.0DN500δ=10mm72.0398.028656.0,DN400δ=10mm76.0323.024548.0,DN300δ=10mm60.0231.013860.0,6.064.0162.010368.0,7.084.0162.013608.0,8.0DN700-600δ=12mm596.0596.0,9.0DN700-400δ=12mm839.0839.0,10.0DN400-200δ=10mm275.0275.0,11.0DN300-200δ=10mm170.0170.0,12.0DN900-500δ=12mm2885.02885.0,13.0DN700-700δ=12mm3066.03066.0,14.0DN400-400δ=10mm1517.01517.0,15.0DN400-200δ=10mm914.01828.0,16.0DN300-200δ=10mm795.0795.0,17.0DN200-200δ=8mm623.01246.0,18.0DN2678.02678.0,19.0DN900810.01620.0,20.0DN800686.01372.0,21.0DN60014.0495.06930.0,22.0DN500422.0844.0,23.0DN400330.01320.0,24.0DN300261.0522.0,25.0DN20016.0165.02640.0,26.0DN9002616.02616.0,27.0DN8001974.01974.0,28.0DN5001232.01232.0,29.0DN300830.0830.0,30.0DN2008.0495.03960.0,31.0玻璃钢碟阀DN6001419.07095.0,32.0玻璃钢碟阀DN400999.01998.0,33.0DN700-6002768.013840.0,34.0玻璃钢法兰盲板920.0,35.01218.0,36.0DN300δ=10mm306.01224.0,37.024.01748.041952.0,38.0DN600δ=10mm6.01025.06150.0,39.0DN500δ=10mm767.03835.0,40.0DN400δ=10mm518.02072.0,41.019.0149.02831.0,42.045°玻璃钢弯头1160.02320.0,43.0DN500-700δ=10mm575.0575.0,44.0DN500-500δ=10mm2295.02295.0,45.0,46.0玻璃钢盲板,47.0DN900δ=10mm2763.02763.0,48.0DN35022.0220.04840.0,49.0DN350335.0335.0,50.0DN400-3501220.01220.0,生产明细,序号日期名称规格单位数量备注,1.044269.0玻璃钢直管DN700δ=12mm米10.0,2.044262.0玻璃钢直管DN300δ=10mm米20.0,发货明细,序号日期名称规格单位数量备注,1.044262.0玻璃钢直管DN200δ=8mm米320.0,2.044262.0玻璃钢异径管DN700-400δ=12mm个400.0,订单统计报表,截至日期:44204.0,序号名称规格单位订单数量单价总价生产量未生产量已发数量已货金额未发数量库存量,320.0677.0216640.0320.0,DN600δ=10mm80.0501.040080.080.0,3.0DN500δ=10mm72.0398.028656.072.0,DN400δ=10mm76.0323.024548.076.0,DN300δ=10mm60.0231.013860.060.0,64.0162.010368.064.0,7.084.0162.013608.084.0,DN700-600δ=12mm596.0596.0,9.0DN700-400δ=12mm839.0839.0,10.0DN400-200δ=10mm275.0275.0,11.0DN300-200δ=10mm170.0170.0,12.0DN900-500δ=12mm2885.02885.0,13.0DN700-700δ=12mm3066.03066.0,DN400-400δ=10mm1517.01517.0,15.0DN400-200δ=10mm914.01828.0,DN300-200δ=10mm795.0795.0,17.0DN200-200δ=8mm623.01246.0,18.0DN2678.02678.0,DN900810.01620.0,20.0DN800686.01372.0,21.0DN600495.06930.0,DN500422.0844.0,23.0DN400330.01320.0,DN300261.0522.0,25.0DN200165.02640.0,26.0DN9002616.02616.0,27.0DN8001974.01974.0,28.0DN5001232.01232.0,29.0DN300830.0830.0,30.0DN200495.03960.0,31.0玻璃钢碟阀DN6001419.07095.0,32.0玻璃钢碟阀DN400999.01998.0,33.0DN700-6002768.013840.0,34.0玻璃钢法兰盲板920.0,35.01218.0,36.0DN300δ=10mm306.01224.0,37.01748.041952.0,38.0DN600δ=10mm1025.06150.0,39.0DN500δ=10mm767.03835.0,40.0DN400δ=10mm518.02072.0,41.0149.02831.0,42.045°玻璃钢弯头1160.02320.0,43.0DN500-700δ=10mm575.0575.0,44.0DN500-500δ=10mm2295.02295.0,45.0,46.0玻璃钢盲板,47.0DN900δ=10mm2763.02763.0,48.0DN350220.04840.0,49.0DN350335.0335.0,50.0DN400-3501220.01220.0,合计932.0488067.0大写金额:肆拾捌万捌仟零陆拾柒元整,生产报表,开始日期:44256.0截至日期:44286.0,序号名称规格单位生产数量备注,1.010.0 ,2.0DN600δ=10mm,3.0DN500δ=10mm,4.0DN400δ=10mm,5.0DN300δ=10mm20.0 ,6.0,7.0,8.0DN700-600δ=12mm,9.0DN700-400δ=12mm,10.0DN400-200δ=10mm,11.0DN300-200δ=10mm,12.0DN900-500δ=12mm,13.0DN700-700δ=12mm,14.0DN400-400δ=10mm,15.0DN400-200δ=10mm,16.0DN300-200δ=10mm,17.0DN200-200δ=8mm,18.0DN,19.0DN900,20.0DN800,21.0,22.0,23.0DN400,24.0DN300,25.0,26.0DN900,27.0DN800,28.0,29.0DN300,30.0,31.0玻璃钢碟阀,32.0玻璃钢碟阀DN400,33.0DN700-600,34.0玻璃钢法兰盲板,35.0,36.0DN300δ=10mm,37.0,38.0DN600δ=10mm,39.0DN500δ=10mm,40.0DN400δ=10mm,41.0,42.045°玻璃钢弯头,43.0DN500-700δ=10mm,44.0DN500-500δ=10mm,45.0,46.0,47.0DN900δ=10mm,48.0,49.0,50.0DN400-350,51.045°玻璃钢弯头,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0DN150δ=5mm,62.0DN80δ=5mm,63.0DN50δ=4mm,64.0DN600-500δ=10mm,65.0DN200-150δ=5mm,66.0DN150-150δ=5mm,67.0DN250,68.0,69.0DN50,70.0DN250,71.0,72.0,73.0,74.0,75.0玻璃钢止回阀,76.090°玻璃钢弯头DN600δ=10mm,77.0玻璃钢500*500*200集风罩δ=5mm,78.0玻璃钢法兰DN700,79.0玻璃钢三通DN200-200,80.0玻璃钢盖板600*1200,81.0玻璃钢盖板2700*3100,82.0玻璃钢盖板4000×1400δ=12mm块,83.0,84.090度玻璃钢弯头DN400,85.0玻璃钢法兰DN50,86.0玻璃钢法兰DN80,87.045度玻璃钢弯头DN700,88.0玻璃钢直管DN350,89.0玻璃钢500*500*8模板（中心带DN350孔）块,90.0玻璃钢600*400*600集风罩,合计30.0,未生产报表,截至日期:43929.0,序号名称规格单位数量单价金额备注,320.0677.0216640.0,DN600δ=10mm80.0501.040080.0,3.0DN500δ=10mm72.0398.028656.0,DN400δ=10mm76.0323.024548.0,DN300δ=10mm60.0231.013860.0,6.064.0162.010368.0,7.084.0162.013608.0,8.0DN700-600δ=12mm596.0596.0,9.0DN700-400δ=12mm839.0839.0,10.0DN400-200δ=10mm275.0275.0,11.0DN300-200δ=10mm170.0170.0,12.0DN900-500δ=12mm2885.02885.0,13.0DN700-700δ=12mm3066.03066.0,14.0DN400-400δ=10mm1517.01517.0,15.0DN400-200δ=10mm914.01828.0,16.0DN300-200δ=10mm795.0795.0,17.0DN200-200δ=8mm623.01246.0,18.0DN2678.02678.0,19.0DN900810.01620.0,20.0DN800686.01372.0,21.0DN60014.0495.06930.0,22.0DN500422.0844.0,23.0DN400330.01320.0,24.0DN300261.0522.0,25.0DN20016.0165.02640.0,26.0DN9002616.02616.0,27.0DN8001974.01974.0,28.0DN5001232.01232.0,29.0DN300830.0830.0,30.0DN2008.0495.03960.0,31.0玻璃钢碟阀DN6001419.07095.0,32.0玻璃钢碟阀DN400999.01998.0,33.0DN700-6002768.013840.0,34.0玻璃钢法兰盲板920.0,35.01218.0,36.0DN300δ=10mm306.01224.0,37.024.01748.041952.0,38.0DN600δ=10mm6.01025.06150.0,39.0DN500δ=10mm767.03835.0,40.0DN400δ=10mm518.02072.0,41.019.0149.02831.0,42.045°玻璃钢弯头1160.02320.0,43.0DN500-700δ=10mm575.0575.0,44.0DN500-500δ=10mm2295.02295.0,45.0,46.0玻璃钢盲板,47.0DN900δ=10mm2763.02763.0,48.0DN35022.0220.04840.0,49.0DN350335.0335.0,50.0DN400-3501220.01220.0,合计932.0488067.0,库存报表,截至日期:44283.0,序号名称规格单位生产量发货量库存量,1.0,2.0DN600δ=10mm,3.0DN500δ=10mm,4.0DN400δ=10mm,5.0DN300δ=10mm,6.0,7.0320.0-320.0,8.0DN700-600δ=12mm,9.0DN700-400δ=12mm400.0-400.0,DN400-200δ=10mm,11.0DN300-200δ=10mm,12.0DN900-500δ=12mm,13.0DN700-700δ=12mm,14.0DN400-400δ=10mm,15.0DN400-200δ=10mm,16.0DN300-200δ=10mm,17.0DN200-200δ=8mm,18.0DN,19.0DN900,DN800,21.0,22.0,23.0DN400,24.0DN300,25.0,26.0DN900,27.0DN800,28.0,29.0DN300,30.0,31.0玻璃钢碟阀,32.0玻璃钢碟阀DN400,33.0DN700-600,34.0玻璃钢法兰盲板,35.0,36.0DN300δ=10mm,37.0,38.0DN600δ=10mm,39.0DN500δ=10mm,40.0DN400δ=10mm,41.0,42.045°玻璃钢弯头,43.0DN500-700δ=10mm,44.0DN500-500δ=10mm,45.0,46.0,47.0DN900δ=10mm,48.0,49.0,50.0DN400-350,51.045°玻璃钢弯头,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0DN150δ=5mm,62.0DN80δ=5mm,63.0DN50δ=4mm,64.0DN600-500δ=10mm,65.0DN200-150δ=5mm,66.0DN150-150δ=5mm,67.0DN250,68.0,69.0DN50,70.0DN250,71.0,72.0,73.0,74.0,75.0玻璃钢止回阀,76.090°玻璃钢弯头DN600δ=10mm,77.0玻璃钢500*500*200集风罩δ=5mm,78.0玻璃钢法兰DN700,79.0玻璃钢三通DN200-200,80.0玻璃钢盖板600*1200,81.0玻璃钢盖板2700*3100,82.0玻璃钢盖板4000×1400δ=12mm块,83.0,84.090度玻璃钢弯头DN400,85.0玻璃钢法兰DN50,86.0玻璃钢法兰DN80,87.045度玻璃钢弯头DN700,88.0玻璃钢直管DN350,89.0玻璃钢500*500*8模板（中心带DN350孔）块,90.0玻璃钢600*400*600集风罩,合计30.0720.0-690.0,未发货报表,截至日期:44283.0,序号名称规格单位订单数量已发货数量未发货数量备注,DN600δ=10mm,DN500δ=10mm,DN400δ=10mm,DN300δ=10mm,7.084.0-236.0 ,DN700-600δ=12mm,9.0DN700-400δ=12mm400.0-399.0 ,DN400-200δ=10mm,DN300-200δ=10mm,DN900-500δ=12mm,13.0DN700-700δ=12mm,DN400-400δ=10mm,15.0DN400-200δ=10mm,DN300-200δ=10mm,17.0DN200-200δ=8mm,18.0DN,DN900,20.0DN800,21.0,23.0DN400,DN300,25.0,26.0DN900,27.0DN800,28.0,29.0DN300,31.0玻璃钢碟阀,32.0玻璃钢碟阀DN400,33.0DN700-600,34.0玻璃钢法兰盲板,35.0,36.0DN300δ=10mm,37.0,38.0DN600δ=10mm,39.0DN500δ=10mm,40.0DN400δ=10mm,41.0,42.045°玻璃钢弯头,43.0DN500-700δ=10mm,44.0DN500-500δ=10mm,45.0,46.0,47.0DN900δ=10mm,48.0,49.0,50.0DN400-350,51.045°玻璃钢弯头,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,61.0DN150δ=5mm,62.0DN80δ=5mm,63.0DN50δ=4mm,DN600-500δ=10mm,65.0DN200-150δ=5mm,66.0DN150-150δ=5mm,67.0DN250,68.0,69.0DN50,70.0DN250,71.0,73.0,74.0,75.0玻璃钢止回阀,90°玻璃钢弯头DN600δ=10mm,77.0玻璃钢500*500*200集风罩δ=5mm,78.0玻璃钢法兰DN700,79.0玻璃钢三通DN200-200,玻璃钢盖板600*1200,81.0玻璃钢盖板2700*3100,82.0玻璃钢盖板4000×1400δ=12mm块,83.0,84.090度玻璃钢弯头DN400,85.0玻璃钢法兰DN50,86.0玻璃钢法兰DN80,87.045度玻璃钢弯头DN700,88.0玻璃钢直管DN350,89.0玻璃钢500*500*8模板（中心带DN350孔）块,90.0玻璃钢600*400*600集风罩,合计1150.0720.0430.0,发货报表,开始日期:44256.0截至日期:44286.0,序号名称规格单位发货数量备注,1.0,2.0DN600δ=10mm,3.0DN500δ=10mm,4.0DN400δ=10mm,5.0DN300δ=10mm,6.0,7.0320.0 ,8.0DN700-600δ=12mm,9.0DN700-400δ=12mm400.0 ,10.0DN400-200δ=10mm,11.0DN300-200δ=10mm,12.0DN900-500δ=12mm,13.0DN700-700δ=12mm,14.0DN400-400δ=10mm,15.0DN400-200δ=10mm,16.0DN300-200δ=10mm,17.0DN200-200δ=8mm,18.0DN,19.0DN900,20.0DN800,21.0,22.0,23.0DN400,24.0DN300,25.0,26.0DN900,27.0DN800,28.0,29.0DN300,30.0,31.0玻璃钢碟阀,32.0玻璃钢碟阀DN400,33.0DN700-600,34.0玻璃钢法兰盲板,35.0,36.0DN300δ=10mm,37.0,38.0DN600δ=10mm,39.0DN500δ=10mm,40.0DN400δ=10mm,41.0,42.045°玻璃钢弯头,43.0DN500-700δ=10mm,44.0DN500-500δ=10mm,45.0,46.0,47.0DN900δ=10mm,48.0,49.0,50.0DN400-350,51.045°玻璃钢弯头,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0DN150δ=5mm,62.0DN80δ=5mm,63.0DN50δ=4mm,64.0DN600-500δ=10mm,65.0DN200-150δ=5mm,66.0DN150-150δ=5mm,67.0DN250,68.0,69.0DN50,70.0DN250,71.0,72.0,73.0,74.0,75.0玻璃钢止回阀,76.090°玻璃钢弯头DN600δ=10mm,77.0玻璃钢500*500*200集风罩δ=5mm,78.0玻璃钢法兰DN700,79.0玻璃钢三通DN200-200,80.0玻璃钢盖板600*1200,81.0玻璃钢盖板2700*3100,82.0玻璃钢盖板4000×1400δ=12mm块,83.0,84.090度玻璃钢弯头DN400,85.0玻璃钢法兰DN50,86.0玻璃钢法兰DN80,87.045度玻璃钢弯头DN700,88.0玻璃钢直管DN350,89.0玻璃钢500*500*8模板（中心带DN350孔）块,90.0玻璃钢600*400*600集风罩,合计720.0,发货对账单,开始日期:44256.0截至日期:44286.0,序号日期名称规格单位发货数量单价金额备注,1.044262.0玻璃钢直管DN200δ=8mm米320.0162.051840.0,2.044262.0玻璃钢异径管DN700-400δ=12mm个400.0839.0335600.0,合计720.0387440.0,使用说明,1.订单录入表，录入对应订单信息,2.生产录入表，日期，名称，规格，单位双击选择，其他手录,3.发货录入表，日期，名称，规格，单位双击选择，其他手录,4.订单统计报表，点击查询按钮，选择起止日期，自动生成对应统计报表,5.生产报表，点击查询按钮，选择起止日期，自动生成对应统计报表,6.未生产报表，点击无价格和带价格按钮，选择起止日期，自动生成对应格式统计报表,7.库存报表，点击查询按钮，选择起止日期，自动生成库存统计报表,8.未发货报表，点击查询按钮，选择起止日期，自动生成统计报表,9.发货报表，点击查询按钮，选择起止日期，自动生成统计报表,10.发货对账单，点击无价格和带价格按钮，选择起止日期，自动生成对应格式统计报表,