办公用品管理系统表

产品清单部门清单,序号代码材料名称单位进价售价安全库存期初数量期初单价期初金额序号部门,1001.0剪刀把财务,1002.0笔记本（大）销售,3.01003.0笔记本（小）3.0供应,4.01004.0资料册4.0后勤,5.01005.0资料夹5.0,6.01006.0文件栏套6.0,7.01007.0垃圾桶7.0,8.01008.0垃圾袋卷8.0,9.01009.0收据9.0,10.01010.0中性笔10.0,11.01011.0中性笔芯11.0,12.01012.0胶棒12.0,13.01013.0回形针13.0,14.01014.0订书机14.0,15.01015.0订书针15.0,16.01016.0计算器16.0,17.01017.0笔筒17.0,18.01018.0烟灰缸18.0,19.01019.0记号笔（大）19.0,20.01020.0标签纸张20.0,21.01021.0报销单21.0,22.01022.0差旅报销单22.0,23.01023.0档案袋23.0,24.01024.0针式打印纸（三联）箱24.0,25.01025.0计算器电池节25.0,26.01026.0大透明胶带卷26.0,27.01027.0印油瓶27.0,28.01028.0印泥盒28.0,29.01029.0便签纸29.0,30.01030.0大美工刀把30.0,31.01031.0大美工刀片31.0,32.01032.0一次性水杯（20个）32.0,33.01033.0一次性水杯（40个）33.0,34.01034.0A4打印纸34.0,35.01035.0维修工具（121件）套35.0,36.01036.0万能表36.0,37.01037.0中号燕尾夹37.0,38.01038.0透明文件夹38.0,39.01039.0网购便签纸39.0,40.01040.0请款单40.0,41.01041.0请假条41.0,42.01042.042.0,43.01043.043.0,44.01044.044.0,45.01045.045.0,46.01046.046.0,47.01047.047.0,48.01048.048.0,49.01049.049.0,50.01050.050.0,51.01051.051.0,52.01052.052.0,53.01053.053.0,54.01054.054.0,55.01055.055.0,56.01056.056.0,57.01057.057.0,58.01058.058.0,59.01059.059.0,60.01060.060.0,61.01061.061.0,62.01062.062.0,63.01063.063.0,64.01064.064.0,65.01065.065.0,66.01066.066.0,67.01067.067.0,68.01068.068.0,69.01069.069.0,70.01070.070.0,71.01071.071.0,72.01072.072.0,73.01073.073.0,74.01074.074.0,75.01075.075.0,76.01076.076.0,77.01077.077.0,78.01078.078.0,79.01079.079.0,80.01080.080.0,81.01081.081.0,82.01082.082.0,83.01083.083.0,84.01084.084.0,85.01085.085.0,86.01086.086.0,87.01087.087.0,88.01088.088.0,89.01089.089.0,90.01090.090.0,91.01091.091.0,92.01092.092.0,93.01093.093.0,94.01094.094.0,95.01095.095.0,96.01096.096.0,97.01097.097.0,98.01098.098.0,99.01099.099.0,100.01100.0100.0,办公用品管理系统,采购单输入表,供货单位:外采日期 :43446.0入库单号:,序号代码材料名称单位数量单价金额验收单号,1001.0剪刀把A0010.0,1002.0笔记本（大）本A002,1003.0笔记本（小）本A003,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,51.0,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0,62.0,63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0,100.0,经手人张三,出库单输入表,领用单位：日期 43461.0出库单号2.0,序号代码材料名称单位数量单价金额领用人,1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,51.0,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0,62.0,63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0,100.0,经手人,日期入库单号供货单位序号代码材料名称单位数量单价金额验收单号经手人,1001剪刀把A001,1002笔记本（大）本A002,1003笔记本（小）本4.04.0A003,日期出库单号领用单位序号代码材料名称单位数量单价金额领用人经手人,1001剪刀把,2.01002笔记本（大）本,3.01003笔记本（小）本,采购明细查询,开始日期43435.0截止日期43465.0,日期入库单号供货单位序号代码材料名称单位数量单价金额验收单号经手人,1001剪刀把A001,1002笔记本（大）本A002,1003笔记本（小）本4.04.0A003,领用明细查询,开始日期43435.0截止日期43465.0,日期出库单号领用单位序号代码材料名称单位数量单价金额领用人经手人,1001剪刀把,2.01002笔记本（大）本,3.01003笔记本（小）本,部门领用报表,领用单位销售开始日期43435.0截止日期43465.0,合计0.03.07.5,序号代码材料名称单位领用数量领用金额,1001.0剪刀把,2.01002.0笔记本（大）,3.01003.0笔记本（小）,4.01004.0资料册,5.01005.0资料夹,6.01006.0文件栏套,7.01007.0垃圾桶,8.01008.0垃圾袋卷,9.01009.0收据,10.01010.0中性笔,11.01011.0中性笔芯,12.01012.0胶棒,13.01013.0回形针,14.01014.0订书机,15.01015.0订书针,16.01016.0计算器,17.01017.0笔筒,18.01018.0烟灰缸,19.01019.0记号笔（大）,20.01020.0标签纸张,21.01021.0报销单,22.01022.0差旅报销单,23.01023.0档案袋,24.01024.0针式打印纸（三联）箱,25.01025.0计算器电池节,26.01026.0大透明胶带卷,27.01027.0印油瓶,28.01028.0印泥盒,29.01029.0便签纸,30.01030.0大美工刀把,31.01031.0大美工刀片,32.01032.0一次性水杯（20个）,33.01033.0一次性水杯（40个）,34.01034.0A4打印纸,35.01035.0维修工具（121件）套,36.01036.0万能表,37.01037.0中号燕尾夹,38.01038.0透明文件夹,39.01039.0网购便签纸,40.01040.0请款单,41.01041.0请假条,42.01042.0,43.01043.0,44.01044.0,45.01045.0,46.01046.0,47.01047.0,48.01048.0,49.01049.0,50.01050.0,51.01051.0,52.01052.0,53.01053.0,54.01054.0,55.01055.0,56.01056.0,57.01057.0,58.01058.0,59.01059.0,60.01060.0,61.01061.0,62.01062.0,63.01063.0,64.01064.0,65.01065.0,66.01066.0,67.01067.0,68.01068.0,69.01069.0,70.01070.0,71.01071.0,72.01072.0,73.01073.0,74.01074.0,75.01075.0,76.01076.0,77.01077.0,78.01078.0,79.01079.0,80.01080.0,81.01081.0,82.01082.0,83.01083.0,84.01084.0,85.01085.0,86.01086.0,87.01087.0,88.01088.0,89.01089.0,90.01090.0,91.01091.0,92.01092.0,93.01093.0,94.01094.0,95.01095.0,96.01096.0,97.01097.0,98.01098.0,99.01099.0,100.01100.0,材料汇总,开始日期43101.0,结束日期43465.0,代码材料名称单位期初数入库数出库数单价安全是否,数量数量库存请购,1001.0剪刀把,1002.0笔记本（大）,1003.0笔记本（小）4.04.0,1004.0资料册,1005.0资料夹,1006.0文件栏套,1007.0垃圾桶,1008.0垃圾袋卷,1009.0收据,1010.0中性笔,1011.0中性笔芯,1012.0胶棒,1013.0回形针,1014.0订书机,1015.0订书针,1016.0计算器,1017.0笔筒,1018.0烟灰缸,1019.0记号笔（大）,1020.0标签纸张,1021.0报销单,1022.0差旅报销单,1023.0档案袋,1024.0针式打印纸（三联）箱,1025.0计算器电池节,1026.0大透明胶带卷,1027.0印油瓶,1028.0印泥盒,1029.0便签纸,1030.0大美工刀把,1031.0大美工刀片,1032.0一次性水杯（20个）,1033.0一次性水杯（40个）,1034.0A4打印纸,1035.0维修工具（121件）套,1036.0万能表,1037.0中号燕尾夹,1038.0透明文件夹,1039.0网购便签纸,1040.0请款单,1041.0请假条,1042.0,1043.0,1044.0,1045.0,1046.0,1047.0,1048.0,1049.0,1050.0,1051.0,1052.0,1053.0,1054.0,1055.0,1056.0,1057.0,1058.0,1059.0,1060.0,1061.0,1062.0,1063.0,1064.0,1065.0,1066.0,1067.0,1068.0,1069.0,1070.0,1071.0,1072.0,1073.0,1074.0,1075.0,1076.0,1077.0,1078.0,1079.0,1080.0,1081.0,1082.0,1083.0,1084.0,1085.0,1086.0,1087.0,1088.0,1089.0,1090.0,1091.0,1092.0,1093.0,1094.0,1095.0,1096.0,1097.0,1098.0,1099.0,1100.0,合计:9.09.04.56.06.0,使用说明,序号表名用途,1.0采购表进行入库记录增删查改操作，单号，日期自动，也可手录,2.0领用表进行采购记录增删查改操作，单号，日期自动，也可手录,3.0采购记录存放入库明细记录,4.0领用记录存放出库明细记录,5.0采购明细查询点击查询按钮，选择起止日期，自动生成采购明细记录,6.0领用明细查询点击查询按钮，选择起止日期，自动生成领用明细记录,7.0部门报表点击查询按钮，选择起止日期和部门，自动生成部门领用明细汇总表,8.0材料报表录入起止日期，点击查询按钮，自动生成材料报表,必看：此模板为宏模板，若下载不能启用宏。可下载插件启用。插件安装后，重新下载打开模板即可正常使用。插件下载地址:https://pan.baidu.com/s/11AUFBYgjQKKMrGHcYOoKuw