📄 4.变动管理.sql
字号:
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbqfd',
'dba',
'ggxh',
'规格型号',
0 ,
'规格型号',
0,
23 ,
0 ,
77 ,
526 ,
'N',
'规格型号' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_mask,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbqfd',
'dba',
'yz',
'原值',
0 ,
'原值',
0,
24 ,
'[General]',
0 ,
77 ,
389 ,
'N',
'原值' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_mask,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbqfd',
'dba',
'ljzj',
'累计折旧',
0 ,
'累计折旧',
0,
24 ,
'[General]',
0 ,
77 ,
389 ,
'N',
'累计折旧' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_mask,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbqfd',
'dba',
'jz',
'净值',
0 ,
'净值',
0,
24 ,
'[General]',
0 ,
77 ,
389 ,
'N',
'净值' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbqfd',
'dba',
'sybm',
'使用部门',
0 ,
'使用部门',
0,
23 ,
0 ,
77 ,
983 ,
'N',
'使用部门' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbqfd',
'dba',
'qfyy',
'启封原因',
0 ,
'启封原因',
0,
23 ,
0 ,
77 ,
2350 ,
'N',
'启封原因' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbqfd',
'dba',
'spyj',
'审批意见',
0 ,
'审批意见',
0,
23 ,
0 ,
77 ,
2350 ,
'N',
'审批意见' ) ;
CREATE TABLE "dba"."sbbfd"
("id" char(22) NOT NULL ,
"bh" char(22) NOT NULL ,
"bfrq" date ,
"sbbh" char(12) ,
"sbmc" char(40) ,
"ggxh" char(20) ,
"sybm" char(40) ,
"yz" numeric(12,2) ,
"jz" numeric(12,2) ,
"qlfy" numeric(12,2) ,
"jcz" numeric(5,0) ,
"bfspyj" varchar(100) ,
"bfyy" varchar(200) ,
"klypj" varchar(200) ,
"bfjsjd" varchar(200) ) ;
CREATE UNIQUE INDEX "sbbfd"
ON "dba"."sbbfd"
("id" ) ;
insert into "dba".pbcattbl
(pbt_tnam,
pbt_ownr,
pbd_fhgt,
pbd_fwgt,
pbd_fitl,
pbd_funl,
pbd_fchr,
pbd_fptc,
pbd_ffce,
pbh_fhgt,
pbh_fwgt,
pbh_fitl,
pbh_funl,
pbh_fchr,
pbh_fptc,
pbh_ffce,
pbl_fhgt,
pbl_fwgt,
pbl_fitl,
pbl_funl,
pbl_fchr,
pbl_fptc,
pbl_ffce,
pbt_cmnt)
values
('sbbfd',
'dba',
-9,
400,
'N',
'N',
0,
34,
'Arial',
-9,
400,
'N',
'N',
134,
2,
'宋体',
-9,
400 ,
'N',
'N',
0,
34,
'Arial',
'设备报废单') ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbbfd',
'dba',
'id',
'序列号',
0 ,
'序列号',
0,
23 ,
0 ,
77 ,
567 ,
'N',
'序列号' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbbfd',
'dba',
'bh',
'设备序列号',
0 ,
'设备序列号',
0,
23 ,
0 ,
77 ,
567 ,
'N',
'设备序列号' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbbfd',
'dba',
'bfrq',
'报废日期',
0 ,
'报废日期',
0,
23 ,
0 ,
77 ,
247 ,
'N',
'报废日期' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbbfd',
'dba',
'sbbh',
'设备编号',
0 ,
'设备编号',
0,
23 ,
0 ,
77 ,
343 ,
'N',
'设备编号' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbbfd',
'dba',
'sbmc',
'设备名称',
0 ,
'设备名称',
0,
23 ,
0 ,
77 ,
983 ,
'N',
'设备名称' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbbfd',
'dba',
'ggxh',
'规格型号',
0 ,
'规格型号',
0,
23 ,
0 ,
77 ,
526 ,
'N',
'规格型号' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbbfd',
'dba',
'sybm',
'使用部门',
0 ,
'使用部门',
0,
23 ,
0 ,
77 ,
983 ,
'N',
'使用部门' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_mask,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbbfd',
'dba',
'yz',
'原值',
0 ,
'原值',
0,
24 ,
'[General]',
0 ,
77 ,
389 ,
'N',
'原值' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_mask,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbbfd',
'dba',
'jz',
'净值',
0 ,
'净值',
0,
24 ,
'[General]',
0 ,
77 ,
389 ,
'N',
'净值' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_mask,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbbfd',
'dba',
'qlfy',
'清理费用',
0 ,
'清理费用',
0,
24 ,
'[General]',
0 ,
77 ,
389 ,
'N',
'清理费用' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_mask,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbbfd',
'dba',
'jcz',
'净残值',
0 ,
'净残值',
0,
24 ,
'[General]',
0 ,
77 ,
229 ,
'N',
'净残值' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbbfd',
'dba',
'bfspyj',
'报废审批意见',
0 ,
'报废审批意见',
0,
23 ,
0 ,
77 ,
2350 ,
'N',
'报废审批意见' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbbfd',
'dba',
'bfyy',
'报废原因',
0 ,
'报废原因',
0,
23 ,
0 ,
77 ,
4641 ,
'N',
'报废原因' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbbfd',
'dba',
'klypj',
'可利用配件',
0 ,
'可利用配件',
0,
23 ,
0 ,
77 ,
4641 ,
'N',
'可利用配件' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbbfd',
'dba',
'bfjsjd',
'报废技术鉴定',
0 ,
'报废技术鉴定',
0,
23 ,
0 ,
77 ,
4641 ,
'N',
'报废技术鉴定' ) ;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -