【正文】 管理系統(tǒng)需求規(guī)格說明書1 前言 ......................................................................................................2 編寫目的 ........................................................................................2 范圍 ................................................................................................2 參考資料 ........................................................................................22 概述 ......................................................................................................3 產(chǎn)品描述 ........................................................................................3 用戶特點 ........................................................................................33 運行環(huán)境 ..............................................................................................44 功能需求 ..............................................................................................4 頂層 ................................................................................................4 第 0 層 ............................................................................................5 第 1 層 ............................................................................................9 系統(tǒng)維護 ..................................................................................9 訂單維護 ................................................................................12 單據(jù)維護 ................................................................................14 隨機查詢 ................................................................................17 統(tǒng)計打印 ................................................................................195 附件 ....................................................................................................222 / 58 附件一（報表樣式） ..................................................................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 附件三（表結構） ......................................................................283 / 581 前言 編寫目的本手冊作為用戶與該系統(tǒng)軟件開發(fā)維護人員共同遵守的軟件需求規(guī)范說明。 表 3合格品月報表年 月 共 頁 第 頁貨 號 名 稱 規(guī) 格規(guī)格名單 位標準庫存月進倉 月出倉 現(xiàn)有庫存制表日期： 表 4不合格品月報表年 月 共 頁 第 頁26 / 58貨號名稱規(guī)格規(guī)格名單位車間退貨進倉合格轉不合格進倉報廢出倉數(shù)量發(fā)貨出倉數(shù)量退貨出倉數(shù)量現(xiàn)有庫存制表日期：說明：月報表分為合格品與不合格打印，合格品月報表打印時要求同時打印出標準庫存，不合格品月報表中的數(shù)據(jù)從月統(tǒng)計庫中取。create table pjrtjk {配件日統(tǒng)計庫}(pj_bm char(8) NOT NULL, {編碼:配件名的拼音簡稱}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, {貨號}pj_tjnf smallint NOT NULL, {統(tǒng)計年份}pj_tjyf smallint NOT NULL, {統(tǒng)計月份}pj_tjri smallint NOT NULL, {統(tǒng)計日}pj_rdhl decimal(12,2), {日訂貨量}pj_rydhl decimal(12,2), {日已到貨量}36 / 58pj_ryl decimal(12,2), {日用量}pj_rjc decimal(12,2), {日進倉}pj_rcc decimal(12,2), {日出倉}pj_rh2bh decimal(12,2), {日合格不合格量}pj_rbh2h decimal(12,2), {日不合格合格量}pj_rbthjc decimal(12,2), {日不合格退貨進倉量}pj_rbbfcc decimal(12,2), {日不合格報廢出倉量}pj_rbthcc decimal(12,2), {日不合格退貨出倉量}pj_rbfhcc decimal(12,2) {日不合格發(fā)貨出倉量})。create unique index idx_pjlsk on pjlsk(pj_djh,pj_djnf,pj_djyf,pj_djri)。create table zlrtjk {珠類日統(tǒng)計庫}(zl_bm char(8) NOT NULL, {編碼:珠類名的拼音簡稱}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, {貨號}zl_tjnf smallint NOT NULL, {統(tǒng)計年份}zl_tjyf smallint NOT NULL, {統(tǒng)計月份}zl_tjri smallint NOT NULL, {統(tǒng)計日}zl_rdhl decimal(12,2), {日訂貨量}zl_rydhl decimal(12,2), {日已到貨量}zl_ryl decimal(12,2), {日用量}zl_rjc decimal(12,2), {日進倉}zl_rcc decimal(12,2), {日出倉}zl_rh2bh decimal(12,2), {日合格不合格量}44 / 58zl_rbh2h decimal(12,2), {日不合格合格量}zl_rbthjc decimal(12,2), {日不合格退貨進倉量}zl_rbbfcc decimal(12,2), {日不合格報廢出倉量}zl_rbthcc decimal(12,2), {日不合格退貨出倉量}zl_rbfhcc decimal(12,2) {日不合格發(fā)貨出倉量})。create unique index idx_zllsk on zllsk(zl_djh,zl_djnf,zl_djyf,zl_djri)。create table zxrtjk {紙箱日統(tǒng)計庫}(zx_bm char(8) NOT NULL, {編碼:紙箱名的拼音簡稱}zx_mc char(20), {名稱}zx_dw char(6), {