【正文】 .......................5 第 1 層 ............................................................................................9 系統(tǒng)維護(hù) ..................................................................................9 訂單維護(hù) ................................................................................12 單據(jù)維護(hù) ................................................................................14 隨機(jī)查詢 ................................................................................17 統(tǒng)計(jì)打印 ................................................................................195 附件 ....................................................................................................222 / 58 附件一（報(bào)表樣式） ..................................................................22 表 1.........................................................................................22 表 2.........................................................................................22 表 3.........................................................................................23 表 4.........................................................................................23 表 5.........................................................................................23 表 6.........................................................................................24 表 7.........................................................................................24 表 8.........................................................................................24 表 9.........................................................................................25 表 10.......................................................................................25 表 11.......................................................................................25 表 12.......................................................................................25 表 13.......................................................................................26 附件二(輸入輸出界面) ...............................................................26 圖 1.........................................................................................26 圖 2.........................................................................................27 附件三（表結(jié)構(gòu)） ......................................................................283 / 581 前言 編寫目的本手冊(cè)作為用戶與該系統(tǒng)軟件開發(fā)維護(hù)人員共同遵守的軟件需求規(guī)范說(shuō)明。采購(gòu)部供貨單位半 成 品倉(cāng) 庫(kù) 加工車間生產(chǎn)車間廢品回收處5 / 58可同時(shí)操作人員數(shù)目未加限制，視機(jī)器性能而定。 表 3合格品月報(bào)表年 月 共 頁(yè) 第 頁(yè)貨 號(hào) 名 稱 規(guī) 格規(guī)格名單 位標(biāo)準(zhǔn)庫(kù)存月進(jìn)倉(cāng) 月出倉(cāng) 現(xiàn)有庫(kù)存制表日期： 表 4不合格品月報(bào)表年 月 共 頁(yè) 第 頁(yè)26 / 58貨號(hào)名稱規(guī)格規(guī)格名單位車間退貨進(jìn)倉(cāng)合格轉(zhuǎn)不合格進(jìn)倉(cāng)報(bào)廢出倉(cāng)數(shù)量發(fā)貨出倉(cāng)數(shù)量退貨出倉(cāng)數(shù)量現(xiàn)有庫(kù)存制表日期：說(shuō)明：月報(bào)表分為合格品與不合格打印，合格品月報(bào)表打印時(shí)要求同時(shí)打印出標(biāo)準(zhǔn)庫(kù)存，不合格品月報(bào)表中的數(shù)據(jù)從月統(tǒng)計(jì)庫(kù)中取。create unique index idx_pjmck on pjmck(pj_bm)。create table pjrtjk {配件日統(tǒng)計(jì)庫(kù)}(pj_bm char(8) NOT NULL, {編碼:配件名的拼音簡(jiǎn)稱}pj_mc char(20), {名稱}pj_dw char(6), {單位} pj_gg char(16) NOT NULL, {規(guī)格}pj_ggm char(10), {規(guī)格名}pj_hh char(8) NOT NULL, {貨號(hào)}pj_tjnf smallint NOT NULL, {統(tǒng)計(jì)年份}pj_tjyf smallint NOT NULL, {統(tǒng)計(jì)月份}pj_tjri smallint NOT NULL, {統(tǒng)計(jì)日}pj_rdhl decimal(12,2), {日訂貨量}pj_rydhl decimal(12,2), {日已到貨量}36 / 58pj_ryl decimal(12,2), {日用量}pj_rjc decimal(12,2), {日進(jìn)倉(cāng)}pj_rcc decimal(12,2), {日出倉(cāng)}pj_rh2bh decimal(12,2), {日合格不合格量}pj_rbh2h decimal(12,2), {日不合格合格量}pj_rbthjc decimal(12,2), {日不合格退貨進(jìn)倉(cāng)量}pj_rbbfcc decimal(12,2), {日不合格報(bào)廢出倉(cāng)量}pj_rbthcc decimal(12,2), {日不合格退貨出倉(cāng)量}pj_rbfhcc decimal(12,2) {日不合格發(fā)貨出倉(cāng)量})。create table pjntjk {配件年統(tǒng)計(jì)庫(kù)}(38 / 58pj_bm char(8) NOT NULL, {編碼:配件名的拼音簡(jiǎn)稱}pj_mc char(20), {名稱}pj_dw char(6), {單位} pj_gg char(16) NOT NULL, {規(guī)格}pj_ggm char(10), {規(guī)格名}pj_hh char(8) NOT NULL, {貨號(hào)}pj_tjnf smallint NOT NULL, {統(tǒng)計(jì)年份}pj_ndhl decimal(12,2), {年訂貨量}pj_nydhl decimal(12,2),{年已到貨量}pj_nyl decimal(12,2), {年用量}pj_ncl decimal(12,2), {年初量}pj_njc decimal(12,2), {年進(jìn)倉(cāng)}pj_ncc decimal(12,2), {年出倉(cāng)}pj_gxnf smallint NOT NULL, {更新數(shù)據(jù)年份}pj_gxyf smallint NOT NULL, {更新數(shù)據(jù)月份}pj_gxri smallint NOT NULL, {更新數(shù)據(jù)日}pj_nbcldecimal(12,2), {年不合格初量}pj_nh2bh decimal(12,2), {年合格不合格量}pj_nbh2h decimal(12,2), {年不合格合格量}pj_nbthjc decimal(12,2), {年不合格退貨進(jìn)倉(cāng)量}pj_nbbfcc decimal(12,2), {年不合格報(bào)廢出倉(cāng)量}pj_nbthcc decimal(12,2), {年不合格退貨出倉(cāng)量}39 / 58pj_nbfhcc decimal(12,2) {年不合格發(fā)貨出倉(cāng)量})。create unique index idx_pjlsk on pjlsk(pj_djh,pj_djnf,pj_djyf,pj_djri)。create unique index idx_zlmck on zlmck(zl_bm)。create table zlrtjk {珠類日統(tǒng)計(jì)庫(kù)}(zl_bm char(8) NOT NULL, {編碼:珠類名的拼音簡(jiǎn)稱}zl_mc char(20), {名稱}zl_dw char(6), {單位} zl_gg char(12) NOT NULL, {規(guī)格}zl_ggmchar(10), {規(guī)格名}zl_hh char(8) NOT NULL, {貨號(hào)}zl_tjnf smallint NOT NULL, {統(tǒng)計(jì)年份}zl_tjyf smallint NOT NULL, {統(tǒng)計(jì)月份}zl_tjri smallint NOT NULL, {統(tǒng)計(jì)日}zl_rdhl decimal(12,2), {日訂貨量}zl_rydhl decimal(12,2), {日已到貨量}zl_ryl decimal(12,2), {日用量}zl_rjc decimal(12,2), {日進(jìn)倉(cāng)}zl_rcc decimal(12,2), {日出倉(cāng)}zl_rh2bh decimal(12,2), {日合格不合格量}44 / 58zl_rbh2h decimal(12,2), {日不合格合格量}zl_rbthjc decimal(12,2), {日不合格退貨進(jìn)倉(cāng)量}zl_rbbfcc decimal(12,2), {日不合格報(bào)廢出倉(cāng)量}zl_rbthcc decimal(12,2), {日不合格退貨出倉(cāng)量}zl_rbfhcc decimal(12,2) {日不合格發(fā)貨出倉(cāng)量})。create table zlntjk {珠類年統(tǒng)計(jì)庫(kù)}(zl_bm char(8) NOT NULL, {編碼:珠類名的拼音簡(jiǎn)稱}zl_mc char(20), {名稱}zl_dw char(6), {單位} zl_gg char(12) NOT NULL, {規(guī)格}zl_ggmchar(10), {規(guī)格名}46 / 58zl_hh char(8) NOT NULL, {貨號(hào)}zl_tjnf smallint NOT NULL, {統(tǒng)計(jì)年份}zl_ndhl decimal(12,2), {年訂貨量}zl_nydhl decimal(12,2), {年已到貨量}zl_nyl d