【正文】 ecimal(12,2), {年用量}zl_ncl decimal(12,2), {年初量}zl_njc decimal(12,2), {年進倉}zl_ncc decimal(12,2), {年出倉}zl_gxnf smallint NOT NULL,{更新數據年份}zl_gxyf smallint NOT NULL,{更新數據月份}zl_gxri smallint NOT NULL, {更新數據日}zl_nbcldecimal(12,2), {年不合格初量}zl_nh2bh decimal(12,2), {年合格不合格量}zl_nbh2h decimal(12,2), {年不合格合格量}zl_nbthjc decimal(12,2), {年不合格退貨進倉量}zl_nbbfcc decimal(12,2), {年不合格報廢出倉量}zl_nbthcc decimal(12,2), {年不合格退貨出倉量}zl_nbfhcc decimal(12,2) {年不合格發(fā)貨出倉量})。create unique index idx_zllsk on zllsk(zl_djh,zl_djnf,zl_djyf,zl_djri)。create unique index idx_zxmck on zxmck(zx_bm)。create table zxrtjk {紙箱日統計庫}(zx_bm char(8) NOT NULL, {編碼:紙箱名的拼音簡稱}zx_mc char(20), {名稱}zx_dw char(6), {單位} zx_gg char(12) NOT NULL, {規(guī)格}zx_ggm char(10), {規(guī)格名}zx_hh char(8) NOT NULL, {貨號}zx_tjnf smallint NOT NULL, {統計年份}zx_tjyf smallint NOT NULL, {統計月份}zx_tjri smallint NOT NULL, {統計日}zx_rdhl decimal(12,2), {日訂貨量}51 / 58zx_rydhl decimal(12,2),{日已到貨量}zx_ryl decimal(12,2), {日用量}zx_rjc decimal(12,2), {日進倉}zx_rcc decimal(12,2), {日出倉}zx_rh2bh decimal(12,2), {日合格不合格量}zx_rbh2h decimal(12,2), {日不合格合格量}zx_rbthjc decimal(12,2), {日不合格退貨進倉量}zx_rbbfcc decimal(12,2), {日不合格報廢出倉量}zx_rbthcc decimal(12,2), {日不合格退貨出倉量}zx_rbfhcc decimal(12,2) {日不合格發(fā)貨出倉量})。create table zxntjk {紙箱年統計庫}53 / 58(zx_bm char(8) NOT NULL, {編碼:紙箱名的拼音簡稱}zx_mc char(20), {名稱}zx_dw char(6), {單位} zx_gg char(12) NOT NULL, {規(guī)格}zx_ggm char(10), {規(guī)格名}zx_hh char(8) NOT NULL, {貨號}zx_tjnf smallint NOT NULL, {統計年份}zx_ndhl decimal(12,2), {年訂貨量}zx_nydhl decimal(12,2), {年已到貨量}zx_nyl decimal(12,2), {年用量}zx_ncl decimal(12,2), {年初量}zx_njc decimal(12,2), {年進倉}zx_ncc decimal(12,2), {年出倉}zx_gxnf smallint NOT NULL, {更新數據年份}zx_gxyf smallint NOT NULL, {更新數據月份}zx_gxri smallint NOT NULL,{更新數據日}zx_nbcl decimal(12,2), {年不合格初量}zx_nh2bh decimal(12,2), {年合格不合格量}zx_nbh2h decimal(12,2), {年不合格合格量}zx_nbthjc decimal(12,2), {年不合格退貨進倉量}zx_nbbfcc decimal(12,2), {年不合格報廢出倉量}54 / 58zx_nbthcc decimal(12,2), {年不合格退貨出倉量}zx_nbfhcc decimal(12,2) {年不合格發(fā)貨出倉量})。create unique index idx_zxlsk on zxlsk(zx_djh,zx_djnf,zx_djyf,zx_djri)。57 / 58create unique index idx_djlxk on djlxk(djlx)。{load from /home/sswh/src/dat/ insert into bcpcjk。}{等級號：1合格品2不合格品58 / 58}。create unique index idx_bcpdjk on bcpdjk(djh)。}create table bcpcjk{半成品車間庫}(cjh char(4) NOT NULL, {車間號}cjmc char(10) NOT NULL {車間名稱})。create unique index idx_zxddk on zxddk(zx_ddh,zx_bm,zx_gg,zx_ddnf,zx_ddyf,zx_ddri)。{load from /home/sswh/src/dat/ insert into zxntjk。create table zxytjk {紙箱月統計庫}(zx_bm char(8) NOT NULL, {編碼:紙箱名的拼音簡稱}zx_mc char(20), {名稱}zx_dw char(6), {單位} zx_gg char(12) NOT NULL, {規(guī)格}zx_ggm char(10), {規(guī)格名}zx_hh char(8) NOT NULL, {貨號}52 / 58zx_tjnf smallint NOT NULL, {統計年份}zx_tjyf smallint NOT NULL, {統計月份}zx_ydhl decimal(12,2), {月訂貨量}zx_yydhl decimal(12,2), {月已到貨量}zx_yyl decimal(12,2), {月用量}zx_ycl decimal(12,2), {月初量}zx_yjc decimal(12,2), {月進倉}zx_ycc decimal(12,2), {月出倉}zx_gxnf smallint NOT NULL, {更新數據年份}zx_gxyf smallint NOT NULL, {更新數據月份}zx_gxri smallint NOT NULL,{更新數據日}zx_ybcl decimal(12,2), {月不合格初量}zx_yh2bh decimal(12,2), {月合格不合格量}zx_ybh2h decimal(12,2), {月不合格合格量}zx_ybthjc decimal(12,2), {月不合格退貨進倉量}zx_ybbfcc decimal(12,2), {月不合格報廢出倉量}zx_ybthcc decimal(12,2), {月不合格退貨出倉量}zx_ybfhcc decimal(12,2) {月不合格發(fā)貨出倉量})。}create table zxggk {紙箱規(guī)格庫}(50 / 58zx_bm char(8) NOT NULL, {編碼:紙箱名的拼音簡稱}zx_mc char(20), {名稱}zx_dw char(6), {單位} zx_gg char(12) NOT NULL, {規(guī)格}zx_ggm char(10), {規(guī)格名}zx_hh char(8) NOT NULL, {貨號}zx_bzkc decimal(12,2) NOT NULL {標準庫存})。create unique index idx_zlddk on zlddk(zl_ddh,zl_bm,zl_gg,zl_ddnf,zl_ddyf,zl_ddri)。{load from /home/sswh/src/dat/ insert into zlntjk。create table zlytjk {珠類月統計庫}(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, {統計年份}zl_tjyf smallint NOT NULL, {統計月份}zl_ydhl decimal(12,2), {月訂貨量}zl_yydhl decimal(12,2), {月已到貨量}zl_yyl decimal(12,2), {月用量}zl_ycl decimal(12,2), {月初量}45 / 58zl_yjc decimal(12,2), {月進倉}zl_ycc decimal(12,2), {月出倉}zl_gxnf smallint NOT NULL,{更新數據年份}zl_gxyf smallint NOT NULL,{更新數據月份}zl_gxri smallint NOT NULL, {更新數據日}zl_ybcldecimal(12,2), {月不合格初量}zl_yh2bh decimal(12,2), {月合格不合格量}zl_ybh2h decimal(12,2), {月不合格合格量}zl_ybthjc decimal(12,2), {月不合格退貨進倉量}zl_ybbfcc decimal(12,2), {月不合格報廢出倉量}zl_ybthcc decimal(12,2), {月不合格退貨出倉量}zl_ybfhcc decimal(12,2) {月不合格發(fā)貨出倉量})。}create table zlggk {珠類規(guī)格庫}(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ī)格名}43 / 58zl_hh char(8) NOT NULL, {貨號}zl_bzkc decimal(12,2) NOT NULL {標準庫存})。create unique index idx_pjddk on pjddk(pj_ddh,pj_bm,pj_gg,pj_ddnf,pj_ddyf,pj_ddri)。{load from /home/sswh/src/dat/ insert into pjntjk。create table pjytjk {配件月統計庫}(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, {統計年份}37 / 58pj_tjyf smallint NOT NULL, {統計月份}pj_ydhl decimal(12,2), {月訂貨量}pj_yydhl decimal(12,2),{月已到貨量}pj_yyl decimal(12,2), {月用量}pj_ycl decimal(12,2), {月初量}pj_yjc decimal(12,2), {月進倉}pj_ycc decimal(12,2), {月出倉}pj_gxnf smallint NOT NULL, {更新數據年份}pj_gxyf smallint NOT NULL, {更新數據月份}pj_gxri smallint N