【正文】 管理系統(tǒng)需求規(guī)格說(shuō)明書(shū)1 前言 ......................................................................................................2 編寫(xiě)目的 ........................................................................................2 范圍 ................................................................................................2 參考資料 ........................................................................................22 概述 ......................................................................................................3 產(chǎn)品描述 ........................................................................................3 用戶特點(diǎn) ........................................................................................33 運(yùn)行環(huán)境 ..............................................................................................44 功能需求 ..............................................................................................4 頂層 ................................................................................................4 第 0 層 ............................................................................................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 前言 編寫(xiě)目的本手冊(cè)作為用戶與該系統(tǒng)軟件開(kāi)發(fā)維護(hù)人員共同遵守的軟件需求規(guī)范說(shuō)明。 表 3合格品月報(bào)表年 月 共 頁(yè) 第 頁(yè)貨 號(hào) 名 稱(chēng) 規(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)名稱(chēng)規(guī)格規(guī)格名單位車(chē)間退貨進(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 table pjrtjk {配件日統(tǒng)計(jì)庫(kù)}(pj_bm char(8) NOT NULL, {編碼:配件名的拼音簡(jiǎn)稱(chēng)}pj_mc char(20), {名稱(chēng)}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 unique index idx_pjlsk on pjlsk(pj_djh,pj_djnf,pj_djyf,pj_djri)。create table zlrtjk {珠類(lèi)日統(tǒng)計(jì)庫(kù)}(zl_bm char(8) NOT NULL, {編碼:珠類(lèi)名的拼音簡(jiǎn)稱(chēng)}zl_mc char(20), {名稱(chēng)}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 unique index idx_zllsk on zllsk(zl_djh,zl_djnf,zl_djyf,zl_djri)。create table zxrtjk {紙箱日統(tǒng)計(jì)庫(kù)}(zx_bm char(8) NOT NULL, {編碼:紙箱名的拼音簡(jiǎn)稱(chēng)}zx_mc char(20), {名稱(chēng)}zx_dw char(6), {