材料进出库存月报表系统.xlsx

《材料进出库存月报表系统.xlsx》由会员分享，可在线阅读，更多相关《材料进出库存月报表系统.xlsx（9页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、基基础础数数据据表表供供应应商商编编号号供供应应商商名名称称材材料料编编码码材材料料类类别别规规格格型型号号单单位位单单价价YQJ-0001新为电子DZ0001电阻25支0.25YQJ-0002新为电子DZ0002电阻32支0.33YQJ-0003三河集团DZ0003电阻100支0.58YQJ-0004元丰今日DZ0004电阻320支0.89JCK-0001金元电器DZ0005电阻29支0.21JCK-0002金元电器DZ0006电阻30支0.36JCK-0003盛华DR0001电容10F支0.78JCK-0004恒杰电子DR0002电容18F支0.65JCK-0005华声集团DR0003电容

2、50F支0.75XSQ-0001海域电子DR0004电容100F支0.85XSQ-0002海域电子DR0005电容25F支0.9XSQ-0003创维科技DR0006电容0.5F支0.55XSQ-0004宏图三胞JCK001集成块AEu8139支58.5XSQ-0005罗利亚JCK002集成块AEu8120支75.6SRQ-0001克罗保JCK003集成块AEu8141支124.85TX-0001志邦JCK004集成块AEu8152支320YZB-0001佳缘电器JCK005集成块AEu8143支70YZB-0002时代电子JCK006集成块AEu9144支185YZB-0003思创科技JCK0

3、07集成块AEu8145支412.5材材料料入入库库明明细细表表月月日日供供货货商商编编号号供供货货商商名名称称凭凭证证号号材材料料编编码码类类别别规规格格型型号号65XSQ-0001海域电子2012060001DR0004电容100F65XSQ-0002海域电子2012060001DR0005电容25F66XSQ-0001海域电子2012060001DR0004电容100F67XSQ-0003创维科技2012060001DR0006电容0.5F610XSQ-0004宏图三胞2012060001JCK001集成块AEu8139615XSQ-0002海域电子2012060001DR0005电容2

4、5F622XSQ-0001海域电子2012060001DR0004电容100F623XSQ-0002海域电子2012060001DR0005电容25F625XSQ-0001海域电子2012060001DR0004电容100F61JCK-0005华声集团2012060001DR0003电容50F63JCK-0005华声集团2012060001DR0003电容50F65JCK-0005华声集团2012060001DR0003电容50F67JCK-0005华声集团2012060001DR0003电容50F611XSQ-0003创维科技2012060001DR0006电容0.5F615JCK-0003

5、盛华2012060001DR0001电容10F620JCK-0003盛华2012060001DR0001电容10F625JCK-0003盛华2012060001DR0001电容10F625JCK-0003盛华2012060001DR0001电容10F627JCK-0003盛华2012060001DR0001电容10F615XSQ-0003创维科技2012060001DR0006电容0.5F624XSQ-0003创维科技2012060001DR0006电容0.5F63JCK-0004恒杰电子2012060001DR0002电容18F65JCK-0004恒杰电子2012060001DR0002电容

6、18F67JCK-0004恒杰电子2012060001DR0002电容18F67JCK-0004恒杰电子2012060001DR0002电容18F68XSQ-0002海域电子2012060001DR0005电容25F68XSQ-0002海域电子2012060001DR0005电容25F68XSQ-0002海域电子2012060001DR0005电容25F610XSQ-0002海域电子2012060001DR0005电容25F615XSQ-0005罗利亚2012060001JCK002集成块AEu8120621XSQ-0005罗利亚2012060001JCK002集成块AEu8120627XSQ

7、-0002海域电子2012060001DR0005电容25F65YZB-0001佳缘电器2012060001JCK005集成块AEu814366YZB-0001佳缘电器2012060001JCK005集成块AEu8143618YZB-0001佳缘电器2012060001JCK005集成块AEu8143625YZB-0001佳缘电器2012060001JCK005集成块AEu814361JCK-0002金元电器2012060001DZ0006电阻3061JCK-0002金元电器2012060001DZ0006电阻3062JCK-0004恒杰电子2012060001DR0002电容18F62JCK

8、-0003盛华2012060001DR0001电容10F63JCK-0003盛华2012060001DR0001电容10F63JCK-0001金元电器2012060001DZ0005电阻2965JCK-0002金元电器2012060001DZ0006电阻30612JCK-0003盛华2012060001DR0001电容10F615JCK-0001金元电器2012060001DZ0005电阻29615JCK-0002金元电器2012060001DZ0006电阻30618JCK-0001金元电器2012060001DZ0005电阻29618JCK-0002金元电器2012060001DZ0006电

9、阻30620JCK-0001金元电器2012060001DZ0005电阻29620JCK-0002金元电器2012060001DZ0006电阻30626JCK-0001金元电器2012060001DZ0005电阻29628JCK-0002金元电器2012060001DZ0006电阻30615SRQ-0001克罗保2012060001JCK003集成块AEu8141627SRQ-0001克罗保2012060001JCK003集成块AEu8141618XSQ-0004宏图三胞2012060001JCK001集成块AEu8139625XSQ-0005罗利亚2012060001JCK002集成块AEu

10、812066YZB-0002时代电子2012060001JCK006集成块AEu9144618YZB-0002时代电子2012060001JCK006集成块AEu9144625YZB-0002时代电子2012060001JCK006集成块AEu9144625YZB-0002时代电子2012060001JCK006集成块AEu9144630YZB-0002时代电子2012060001JCK006集成块AEu914466YZB-0003思创科技2012060001JCK007集成块AEu8145618YZB-0003思创科技2012060001JCK007集成块AEu8145618YZB-0003

11、思创科技2012060001JCK007集成块AEu8145625YZB-0003思创科技2012060001JCK007集成块AEu814561YQJ-0004元丰今日2012060001DZ0004电阻32065YQJ-0004元丰今日2012060001DZ0004电阻320610YQJ-0004元丰今日2012060001DZ0004电阻320612YQJ-0001新为电子2012060001DZ0001电阻25618YQJ-0001新为电子2012060001DZ0001电阻25618YQJ-0002新为电子2012060001DZ0002电阻3268YQJ-0003三河集团2012

12、060001DZ0003电阻100613YQJ-0003三河集团2012060001DZ0003电阻100618YQJ-0003三河集团2012060001DZ0003电阻100625YQJ-0003三河集团2012060001DZ0003电阻10067YQJ-0002新为电子2012060001DZ0002电阻32618TX-0001志邦2012060001JCK004集成块AEu8152625TX-0001志邦2012060001JCK004集成块AEu8152625TX-0001志邦2012060001JCK004集成块AEu8152627TX-0001志邦2012060001JCK00

13、4集成块AEu8152单单位位入入库库数数量量单单价价金金额额支1000.8585支7520.9676.8支8000.85680支1000.5555支2000058.51170000支6000.9540支3200.85272支4100.9369支5000.85425支7820.75586.5支1000.7575支2000.75150支4510.75338.25支50000.552750支45000.783510支5200.78405.6支6000.78468支4000.78312支1000.7878支8500.55467.5支2000.55110支1000.6565支7100.65461.5支

14、2000.65130支6000.65390支1000.990支50000.94500支15000.91350支50000.94500支780075.6589680支56075.642336支2000.9180支2007014000支5207036400支10007070000支4007028000支5400.36194.4支4560.36164.16支2150.65139.75支20000.781560材材料料入入库库明明细细表表支30000.782340支2000.2142支2010.3672.36支50000.783900支30000.21630支6000.36216支8500.21178

15、.5支7800.36280.8支9600.21201.6支6500.36234支5000.21105支12000.36432支500124.8562425支500124.8562425支90058.552650支30075.622680支52018596200支1000185185000支50018592500支900185166500支1500185277500支520412.5214500支1000412.5412500支500412.5206250支800412.5330000支6300.89560.7支6500.89578.5支78000.896942支10000.25250支1200

16、0.25300支4500.33148.5支35000.582030支12000.58696支6200.58359.6支60200.583491.6支5000.33165支1000320320000支20032064000支56003201792000支10032032000本月领取情况记录表月月日日 部部门门编编码码部部门门名名称称凭凭证证号号材材料料编编码码材材料料类类别别规规格格型型号号单单位位申申领领数数量量61KB001一车间2012060001DZ0001电阻25支200061KB001一车间2012060001DZ0002电阻32支750061KB001一车间2012060001D

17、Z0003电阻100支80061KB001一车间2012060001DZ0004电阻320支120061KB001一车间2012060001DZ0005电阻29支50061KB001一车间2012060001DZ0006电阻30支30065KB002二车间2012060001DR0001电容10F支20065KB003三车间2012060001DR0002电容18F支100610KB002二车间2012060001DR0003电容50F支520610KB003三车间2012060001DR0004电容100F支620610KB002二车间2012060001DR0005电容25F支400610

18、KB003三车间2012060001DR0006电容0.5F支500610KB004四车间2012060001JCK001集成块AEu8139支300610KB004四车间2012060001JCK002集成块AEu8120支200610KB004四车间2012060001JCK003集成块AEu8141支200610KB004四车间2012060001JCK004集成块AEu8152支50612KB004四车间2012060001JCK005集成块AEu8143支15612KB004四车间2012060001JCK006集成块AEu9144支20615KB004四车间2012060001JC

19、K007集成块AEu8145支66615KB004四车间2012060001DZ0001电阻25支200615KB004四车间2012060001DZ0002电阻32支300615KB004四车间2012060001DZ0003电阻100支40615KB004四车间2012060001DZ0004电阻320支80619KB005五车间2012060001DZ0005电阻29支95619KB006维修部2012060001DZ0006电阻30支20619KB007综合部2012060001DR0001电容10F支10619KB005五车间2012060001DR0002电容18F支20619KB

20、006维修部2012060001DR0003电容50F支14619KB007综合部2012060001DR0004电容100F支253619KB001一车间2012060001DR0005电容25F支241619KB002二车间2012060001DR0006电容0.5F支263623KB003三车间2012060001JCK001集成块AEu8139支55623KB004四车间2012060001JCK002集成块AEu8120支78625KB005五车间2012060001JCK003集成块AEu8141支98625KB006维修部2012060001JCK004集成块AEu8152支56

21、625KB007综合部2012060001JCK005集成块AEu8143支25625KB001一车间2012060001JCK006集成块AEu9144支45625KB002二车间2012060001JCK007集成块AEu8145支65625KB003三车间2012060001DZ0001电阻25支78626KB004四车间2012060001DZ0002电阻32支52628KB005五车间2012060001DZ0003电阻100支52628KB006维修部2012060001DZ0004电阻320支10628KB007综合部2012060001DZ0001电阻25支55628KB003

22、三车间2012060001DZ0002电阻32支12628KB004四车间2012060001DZ0003电阻100支10金额合计：189242.78实实发发数数量量数数量量单单位位成成本本金金额额20000.25500.075000.332475.08000.58464.012000.891068.05000.21105.03000.36108.02000.78156.01000.6565.05200.75390.06200.85527.04000.9360.05000.55275.030058.517550.020075.615120.0200124.8524970.05032016000

23、.015701050.0201853700.066412.527225.02000.2550.03000.3399.0400.5823.2800.8971.2950.2120.0200.367.2100.787.8200.6513.0140.7510.52530.85215.12410.9216.92630.55144.75558.53217.57875.65896.898124.8512235.35632017920.025701750.0451858325.065412.526812.5780.2519.5520.3317.2520.5830.2100.898.9550.2513.8120

24、.334.0100.585.8本月领取情况记录表材材料料进进出出库库存存月月报报表表公司名称华云信息有限公司制表部门品管部合合 计计 金金 额额156,737.356,389,778.62材材料料材材料料名名 称称单单上上 月月 结结 存存本本 月月 进进 货货编编码码类类别别及及规规格格型型号号位位单单价价数数量量金金额额单单价价数数量量金金额额DZ0001电阻25支0.25500.00125.000.252200550DZ0002电阻32支0.3310000.003300.000.33950313.5DZ0003电阻100支0.58820.00475.600.58113406577.2DZ

25、0004电阻320支0.891580.001406.200.8990808081.2DZ0005电阻29支0.21700.00147.000.2155101157.1DZ0006电阻30支0.36980.00352.800.3644271593.72DR0001电容10F支0.78700.00546.000.781612012573.6DR0002电容18F支0.65850.00552.500.6518251186.25DR0003电容50F支0.75456.00342.000.7515331149.75DR0004电容100F支0.851470.001249.500.8517201462DR

26、0005电容25F支0.90840.00756.000.91356212205.8DR0006电容0.5F支0.55521.00286.550.5561503382.5JCK001集成块AEu8139支58.50146.008541.0058.5209001222650JCK002集成块AEu8120支75.60300.0022680.0075.68660654696JCK003集成块AEu8141支124.85452.0056432.20124.851000124850JCK004集成块AEu8152支320.00125.0040000.0032069002208000JCK005集成块AE

27、u8143支70.0041.002870.00702120148400JCK006集成块AEu9144支185.0050.009250.001854420817700JCK007集成块AEu8145支412.5018.007425.00412.528201163250制表时间2012/6/30单位元189,242.786,357,273.19唯唯一一性性本本 月月 出出 货货本本 月月 结结 存存单单价价数数量量金金额额单单价价数数量量金金额额0.252333.00583.250.2536791.7510.337864.002595.120.3330861018.3810.58902.0052

28、3.160.58112586529.6410.891290.001148.100.8993708339.3010.21595.00124.950.2156151179.1510.36320.00115.200.3650871831.3210.78210.00163.800.781661012955.8010.65120.0078.000.6525551660.7510.75534.00400.500.7514551091.2510.85873.00742.050.8523171969.4510.9641.00576.900.91376112384.9010.55763.00419.650.5559083249.40158.5355.0020767.5058.5206911210423.50175.6278.0021016.8075.68682656359.201124.85298.0037205.30124.851154144076.901320106.0033920.0032069192214080.0017040.002800.00702121148470.00118565.0012025.001854405814925.001412.5131.0054037.50412.527071116637.501材材料料进进出出库库存存月月报报表表