Excel表格通用模板：简易仓库管理系统.xlsx

《Excel表格通用模板：简易仓库管理系统.xlsx》由会员分享，可在线阅读，更多相关《Excel表格通用模板：简易仓库管理系统.xlsx（697页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、简易仓库管理系统基基本本信信息息库库存存表表出出库库表表入入库库表表使使用用说说明明基础信息录入表仓库信息部门信息员工资料货品分类货品单位ID号仓库名称ID号 部门名称ID号 所在部门员工名称 ID号 中分类 所属仓库ID号单位名称101原材仓201生产部301仓库张三401螺母原材仓501只102辅料仓202仓库402螺丝原材仓502把503包返回主界面出入库类别外协/部门供应商/客户ID号类别名称ID号部门名称ID号供应商名称601采购入库701工模801 王子新材602领用出库702车床802 中科电气603废品退库703冲压803 致胜精密704品质804805库存表序序号号物物料料编

2、编码码物物料料名名称称规规格格及及型型号号单单位位单单价价 期期初初数数量量入入库库数数量量出出库库数数量量 结结存存数数量量1YC1001螺母M5只0.250100201302YC1002螺母M6只0.250100121383YC1003螺母M8只0.215010056944YC1004螺母M10只0.255010001505YC1005螺母M12只0.35000506YC1006螺母M14只0.45000507YC1007螺母M16只0.65000508YC1008螺母M18只15000509YC1009螺母M20只1.650005010YC1010螺母M22只25000501100012

3、000130001400015000160001700018000190002000021000220002300024000250002600027000280002900030000310003200033000340003500036000370003800039000400004100042000430004400045000460004700048000490005000051000520005300054000550005600057000580005900060000610006200063000640006500066000670006800069000700007100072

4、000730007400075000760007700078000790008000081000820008300084000850008600087000880008900090000910009200093000940009500096000970009800099000100000101000102000103000104000105000106000107000108000109000110000111000112000113000114000115000116000117000118000119000120000121000122000123000124000125000126000

5、127000128000129000130000131000132000133000134000135000136000137000138000139000140000141000142000143000144000145000146000147000148000149000150000151000152000153000154000155000156000157000158000159000160000161000162000163000164000165000166000167000168000169000170000171000172000173000174000175000176000

6、177000178000179000180000181000182000183000184000185000186000187000188000189000190000191000192000193000194000195000196000197000198000199000200000201000202000203000204000205000206000207000208000209000210000211000212000213000214000215000216000217000218000219000220000221000222000223000224000225000226000

7、227000228000229000230000231000232000233000234000235000236000237000238000239000240000241000242000243000244000245000246000247000248000249000250000251000252000253000254000255000256000257000258000259000260000261000262000263000264000265000266000267000268000269000270000271000272000273000274000275000276000

8、277000278000279000280000281000282000283000284000285000286000287000288000289000290000291000292000293000294000295000296000297000298000299000300000301000302000303000304000305000306000307000308000309000310000311000312000313000314000315000316000317000318000319000320000321000322000323000324000325000326000

9、327000328000329000330000331000332000333000334000335000336000337000338000339000340000341000342000343000344000345000346000347000348000349000350000351000352000353000354000355000356000357000358000359000360000361000362000363000364000365000366000367000368000369000370000371000372000373000374000375000376000

10、377000378000379000380000381000382000383000384000385000386000387000388000389000390000391000392000393000394000395000396000397000398000399000400000401000402000403000404000405000406000407000408000409000410000411000412000413000414000415000416000417000418000419000420000421000422000423000424000425000426000

11、427000428000429000430000431000432000433000434000435000436000437000438000439000440000441000442000443000444000445000446000447000448000449000450000451000452000453000454000455000456000457000458000459000460000461000462000463000464000465000466000467000468000469000470000471000472000473000474000475000476000

12、477000478000479000480000481000482000483000484000485000486000487000488000489000490000491000492000493000494000495000496000497000498000499000500000501000502000503000504000505000506000507000508000509000510000511000512000513000514000515000516000517000518000519000520000521000522000523000524000525000526000

13、527000528000529000530000531000532000533000534000535000536000537000538000539000540000541000542000543000544000545000546000547000548000549000550000551000552000553000554000555000556000557000558000559000560000561000562000563000564000565000566000567000568000569000570000571000572000573000574000575000576000

14、577000578000579000580000581000582000583000584000585000586000587000588000589000590000591000592000593000594000595000596000597000598000599000600000601000602000603000604000605000606000607000608000609000610000611000612000613000614000615000616000617000618000619000620000621000622000623000624000625000626000

15、627000628000629000630000631000632000633000634000635000636000637000638000639000640000641000642000643000644000645000646000647000648000649000650000651000652000653000654000655000656000657000658000659000660000661000662000663000664000665000666000667000668000669000670000671000672000673000674000675000676000

16、677000678000679000680000681000682000683000684000685000686000687000688000689000690000691000692000693000694000695000696000697000698000699000700000701000702000703000704000705000706000707000708000709000710000711000712000713000714000715000716000717000718000719000720000721000722000723000724000725000726000

17、727000728000729000730000731000732000733000734000735000736000737000738000739000740000741000742000743000744000745000746000747000748000749000750000751000752000753000754000755000756000757000758000759000760000761000762000763000764000765000766000767000768000769000770000771000772000773000774000775000776000

18、777000778000779000780000781000782000783000784000785000786000787000788000789000790000791000792000793000794000795000796000797000798000799000800000801000802000803000804000805000806000807000808000809000810000811000812000813000814000815000816000817000818000819000820000821000822000823000824000825000826000

19、827000828000829000830000831000832000833000834000835000836000837000838000839000840000841000842000843000844000845000846000847000848000849000850000851000852000853000854000855000856000857000858000859000860000861000862000863000864000865000866000867000868000869000870000871000872000873000874000875000876000

20、877000878000879000880000881000882000883000884000885000886000887000888000889000890000891000892000893000894000895000896000897000898000899000900000901000902000903000904000905000906000907000908000909000910000911000912000913000914000915000916000917000918000919000920000921000922000923000924000925000926000

21、927000928000929000930000931000932000933000934000935000936000937000938000939000940000941000942000943000944000945000946000947000948000949000950000951000952000953000954000955000956000957000958000959000960000961000962000963000964000965000966000967000968000969000970000971000972000973000974000975000976000

22、977000978000979000980000981000982000983000984000985000986000987000988000989000990000991000992000993000994000995000996000997000998000999000100000010010001002000100300010040001005000100600010070001008000100900010100001011000101200010130001014000101500010160001017000101800010190001020000102100010220001

23、023000102400010250001026000102700010280001029000103000010310001032000103300010340001035000103600010370001038000103900010400001041000104200010430001044000104500010460001047000104800010490001050000105100010520001053000105400010550001056000105700010580001059000106000010610001062000106300010640001065000

24、106600010670001068000106900010700001071000107200010730001074000107500010760001077000107800010790001080000108100010820001083000108400010850001086000108700010880001089000109000010910001092000109300010940001095000109600010970001098000109900011000001101000110200011030001104000110500011060001107000110800

25、011090001110000111100011120001113000111400011150001116000111700011180001119000112000011210001122000112300011240001125000112600011270001128000112900011300001131000113200011330001134000113500011360001137000113800011390001140000114100011420001143000114400011450001146000114700011480001149000115000011510

26、001152000115300011540001155000115600011570001158000115900011600001161000116200011630001164000116500011660001167000116800011690001170000117100011720001173000117400011750001176000117700011780001179000118000011810001182000118300011840001185000118600011870001188000118900011900001191000119200011930001194

27、000119500011960001197000119800011990001200000120100012020001203000120400012050001206000120700012080001209000121000012110001212000121300012140001215000121600012170001218000121900012200001221000122200012230001224000122500012260001227000122800012290001230000123100012320001233000123400012350001236000123

28、700012380001239000124000012410001242000124300012440001245000124600012470001248000124900012500001251000125200012530001254000125500012560001257000125800012590001260000126100012620001263000126400012650001266000126700012680001269000127000012710001272000127300012740001275000127600012770001278000127900012

29、800001281000128200012830001284000128500012860001287000128800012890001290000129100012920001293000129400012950001296000129700012980001299000130000013010001302000130300013040001305000130600013070001308000130900013100001311000131200013130001314000131500013160001317000131800013190001320000132100013220001

30、323000132400013250001326000132700013280001329000133000013310001332000133300013340001335000133600013370001338000133900013400001341000134200013430001344000134500013460001347000134800013490001350000135100013520001353000135400013550001356000135700013580001359000136000013610001362000136300013640001365000

31、136600013670001368000136900013700001371000137200013730001374000137500013760001377000137800013790001380000138100013820001383000138400013850001386000138700013880001389000139000013910001392000139300013940001395000139600013970001398000139900014000001401000140200014030001404000140500014060001407000140800

32、014090001410000141100014120001413000141400014150001416000141700014180001419000142000014210001422000142300014240001425000142600014270001428000142900014300001431000143200014330001434000143500014360001437000143800014390001440000144100014420001443000144400014450001446000144700014480001449000145000014510

33、001452000145300014540001455000145600014570001458000145900014600001461000146200014630001464000146500014660001467000146800014690001470000147100014720001473000147400014750001476000147700014780001479000148000014810001482000148300014840001485000148600014870001488000148900014900001491000149200014930001494

34、000149500014960001497000149800014990001500000150100015020001503000150400015050001506000150700015080001509000151000015110001512000151300015140001515000151600015170001518000151900015200001521000152200015230001524000152500015260001527000152800015290001530000153100015320001533000153400015350001536000153

35、700015380001539000154000015410001542000154300015440001545000154600015470001548000154900015500001551000155200015530001554000155500015560001557000155800015590001560000156100015620001563000156400015650001566000156700015680001569000157000015710001572000157300015740001575000157600015770001578000157900015

36、800001581000158200015830001584000158500015860001587000158800015890001590000159100015920001593000159400015950001596000159700015980001599000160000016010001602000160300016040001605000160600016070001608000160900016100001611000161200016130001614000161500016160001617000161800016190001620000162100016220001

37、623000162400016250001626000162700016280001629000163000016310001632000163300016340001635000163600016370001638000163900016400001641000164200016430001644000164500016460001647000164800016490001650000165100016520001653000165400016550001656000165700016580001659000166000016610001662000166300016640001665000

38、166600016670001668000166900016700001671000167200016730001674000167500016760001677000167800016790001680000168100016820001683000168400016850001686000168700016880001689000169000016910001692000169300016940001695000169600016970001698000169900017000001701000170200017030001704000170500017060001707000170800

39、017090001710000171100017120001713000171400017150001716000171700017180001719000172000017210001722000172300017240001725000172600017270001728000172900017300001731000173200017330001734000173500017360001737000173800017390001740000174100017420001743000174400017450001746000174700017480001749000175000017510

40、001752000175300017540001755000175600017570001758000175900017600001761000176200017630001764000176500017660001767000176800017690001770000177100017720001773000177400017750001776000177700017780001779000178000017810001782000178300017840001785000178600017870001788000178900017900001791000179200017930001794

41、000179500017960001797000179800017990001800000180100018020001803000180400018050001806000180700018080001809000181000018110001812000181300018140001815000181600018170001818000181900018200001821000182200018230001824000182500018260001827000182800018290001830000183100018320001833000183400018350001836000183

42、700018380001839000184000018410001842000184300018440001845000184600018470001848000184900018500001851000185200018530001854000185500018560001857000185800018590001860000186100018620001863000186400018650001866000186700018680001869000187000018710001872000187300018740001875000187600018770001878000187900018

43、800001881000188200018830001884000188500018860001887000188800018890001890000189100018920001893000189400018950001896000189700018980001899000190000019010001902000190300019040001905000190600019070001908000190900019100001911000191200019130001914000191500019160001917000191800019190001920000192100019220001

44、923000192400019250001926000192700019280001929000193000019310001932000193300019340001935000193600019370001938000193900019400001941000194200019430001944000194500019460001947000194800019490001950000195100019520001953000195400019550001956000195700019580001959000196000019610001962000196300019640001965000

45、196600019670001968000196900019700001971000197200019730001974000197500019760001977000197800019790001980000198100019820001983000198400019850001986000198700019880001989000199000019910001992000199300019940001995000199600019970001998000199900020000002001000200200020030002004000200500020060002007000200800

46、020090002010000201100020120002013000201400020150002016000201700020180002019000202000020210002022000202300020240002025000202600020270002028000202900020300002031000203200020330002034000203500020360002037000203800020390002040000204100020420002043000204400020450002046000204700020480002049000205000020510

47、002052000205300020540002055000205600020570002058000205900020600002061000206200020630002064000206500020660002067000206800020690002070000207100020720002073000207400020750002076000207700020780002079000208000020810002082000208300020840002085000208600020870002088000208900020900002091000209200020930002094

48、000209500020960002097000209800020990002100000210100021020002103000210400021050002106000210700021080002109000211000021110002112000211300021140002115000211600021170002118000211900021200002121000212200021230002124000212500021260002127000212800021290002130000213100021320002133000213400021350002136000213

49、700021380002139000214000021410002142000214300021440002145000214600021470002148000214900021500002151000215200021530002154000215500021560002157000215800021590002160000216100021620002163000216400021650002166000216700021680002169000217000021710002172000217300021740002175000217600021770002178000217900021

50、800002181000218200021830002184000218500021860002187000218800021890002190000219100021920002193000219400021950002196000219700021980002199000220000022010002202000220300022040002205000220600022070002208000220900022100002211000221200022130002214000221500022160002217000221800022190002220000222100022220002