记录版本发布数据库sql

1、2017-3-71、数据库执行语句NETOBDCinsert into gx_log(gxsj,gxbbh) values(sysdate,'20170307');- Add/modify columnsalter table JJ_H add isdyxz NUMBER(1) default 0;- Add comments to the columnscomment on column JJ_H.isdyxz is '1表示抵押新增'UPDATE SYS_YWLAYOUT SET POPDIALOG='xsk_h_duox|1,xsk_zrz_lpb

2、|1' where (ywlx='B2004' OR YWLX='B2005') and templatecode='h'commit;- Add/modify columnsalter table QUERY_HY_APPLY add CXZLYTQT varchar2(500); alter table QUERY_HY_APPLY add CXNRQT varchar2(500);- Add comments to the columnscomment on column QUERY_HY_APPLY.CXZLYTQTis '

3、;对外资料其他用途'comment on column QUERY_HY_APPLY.CXNRQTis '对外其他内容'- Add/modify columnsalter table QUERY_ALL_APPLY add CXZLYTQT varchar2(500); alter table QUERY_ALL_APPLY add CXNRQT varchar2(500);- Add comments to the columnscomment on column QUERY_ALL_APPLY.CXZLYTQTis '对外资料其他用途'comment

4、 on column QUERY_ALL_APPLY.CXNRQTis '拟对外其他内容'update sys_receive_setting set ywlxname='集体土地所变更登记（空间范围不变）' where ywlx='B1001'update sys_receive_setting set ywlxname='林地使用权变更登记（空间范围不变）' where ywlx='B3002' update sys_ywlayout set popdialog='xsk_yg_fwyw' wh

5、ere ywlx='O2001001' and tabname='房屋信息' update sys_ywlayout set popdialog='' where ywlx='O2001001' and tabname='宗地信息'commit;delete from sys_receive_setting t where ywlx='B300201'delete from sys_receive_setting t where ywlx='B100101'commit;insert

6、 into sys_receive_setting (ID, QSLX_CODE, DJLX_CODE, WNAME, BOOK_NODE, RECEIVE_ACTION, ARCHIVE_ACTION, BOOK_ACTION,YWLX, DJB_TABLE, YWLXNAME, ARCHIVE_NODE,_NODE, REGISTERBOOK_NODE, BDCLX, BDCLXNAME, YQSLX_CODE, SELECTMODE,FILTER, ISVISIBLE, ZSPZ, TEMPID, SUSPENDSTATUSTIP, CONTINUESTATUSTIP, CSYJ, FS

7、YJ, HDYJ, GSTEMPLATE, ABORT_NODE, TYPEID,EXAMINEJD, FILEPUSH_NODE, SMSTEMPLATE)values ('DE18D7FDC97F421FA93B546C6227CD39', '1001', 'B', '集体土地所变更登记', '','AnTu.Bdc.Business.Receive.ReceiveHandles.FirstRegister.Gytd', 'AssetUnitBus.ZDAssetUnitBus.JTTD

8、SYQCHBus','Djb.ZD.JTTDSYQSCDJ', 'B100101', 'DJB_TDSYQ', '集体土地所变更登记（空间范围变化）', '', '登簿', '登簿', '1', '土地', '', 0, 'and regexp_like(bdcdyh,''JA'') and PRE_ZDDM is not null', 1, '不动产:不动产1,不动产2,

9、不动产3', '0e3a4166-2488-47b8-b0ff-28d542aa4ffc', '8|正在中，不能办理登记业务！$1|正在办理中，不能进行登记。$64|已注销，不能进行登记。$4|正在抵押中，不能办理此登记业务！', '', '需要审核', '审核通过', '审核通过', '', '', 269, '', '', '');insert into sys_receive_setting (ID, QS

10、LX_CODE, DJLX_CODE, WNAME, BOOK_NODE, RECEIVE_ACTION, ARCHIVE_ACTION, BOOK_ACTION,YWLX, DJB_TABLE, YWLXNAME, ARCHIVE_NODE,_NODE, REGISTERBOOK_NODE, BDCLX, BDCLXNAME, YQSLX_CODE, SELECTMODE,FILTER, ISVISIBLE, ZSPZ, TEMPID, SUSPENDSTATUSTIP, CONTINUESTATUSTIP, CSYJ, FSYJ, HDYJ, GSTEMPLATE, ABORT_NODE,

11、 TYPEID, EXAMINEJD, FILEPUSH_NODE, SMSTEMPLATE)values ('3EF106CCA90D4DBA8F939EA8308DC1B6', '3002', 'B', '林地使用权变更登记', '','AnTu.Bdc.Business.Receive.ReceiveHandles.FirstRegister.Gytd', 'AssetUnitBus.ZDAssetUnitBus.LDSYQCHBus', 'Djb.LD.LDSYQCS

12、DJ', 'B300201', 'DJB_LQ', '林地使用权变更登记（空间范围变化）', '', '登簿', '登簿', '3', '林地', '', 0,'and regexp_like(bdcdyh,''GJZE'') and PRE_ZDDM is not null', 1, '不动产:不动产1,不动产2,不动产权3', '9414BD9D059D4F6797AB

13、B0BDE86CB98D', '8|正在中，不能办理登记业务！$1|正在办理中，不能进行登记。$64|已注销，不能进行登记。$4|正在抵押中，不能办理此登记业务！', '', '需要审核', '审核通过', '审核通过', '', '', 282, 'commit;', '', '');insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCO

14、LS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('940F7905B4C4486C825DFE52FD69AA49', 'B100101', 'zdxx', '', '', 'BDCDYH,ZDDM,DJH', 101, '集体土地所记（空间范围变化）-宗地信息', '宗地信息', '', 'zjk_zd

15、', '', '');变更登insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('D3C8FBF5FA9E46A69C2B10D783702D0A', 'B100101', 'ywxx', '', '

16、9;, 'APPLICATE_REASON', 300, '集体土地所记（空间范围变化）-业务信息', '业务信息', '', '', '', '');变更登insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values

17、 ('1DF00D1FD2D24905881EA81130DCDFE7', 'B100101', 'qlr', '', '', '', 402, '集体土地所-权利人', '权利人', '0', '', '', '');变更登记（空间范围变化）insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READON

18、LYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('5BBED0C3D7CD40EFBD8182C20FBF9D43', 'B100101', 'dlr', '', '', '', 999, '集体土地所变更登记（空间范围变化）-人', '人', '', '', '', '');inse

19、rt into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('50C1546A45B14928A0BDF8CC9BAA477C', 'B100101', 'zdyt', '', 'TBZFW', '', 102, '集体土地所围变

20、化）-宗地用途', '宗地用途', '', 'addOneRow', '', '');变更登记（空间范insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('76E4D77848AF4EC9AFC6C0ACA233CECC&

21、#39;, 'B300201', 'zdyt', '', 'TBZFW', '', 102, '林地使用权变更登记（空间范围变化）-宗地用途', '宗地用途', '', '', '', '');insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME,

22、DLRGX, POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('9412B6E0BCE24FFBA9B72CF063175549', 'B300201', 'zdxx', '', '', '', 101, '林地使用权变更登记（空间范围变化）-宗地信息', '宗地信息', '', 'zjk_zd', '', '');insert into sys_ywlayou

23、t (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX, POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('8D172B4CC9DE45A9AA0F95A28F972334', 'B300201', 'ywxx', '', '', 'APPLICATE_REASON', 300, '林地使用权变更登记（空间范围

24、变化）-业务信息', '业务信息', '', '', '', '');insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX, POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('678C84D4914A45549FBC60E635511A16', 'B300

25、201', 'qlr', '', '', '', 402, '林地使用权变更登记（空间范围变化）-权利人', '权利人', '0', '', '', '');insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX, POPDIALOG, SIMP

26、LEPOPDIALOG, GRIDSTYLE)values ('3F5C6EED9C694427B9422BD9C7C9B511', 'B300201', 'dlr', '', '', '', 999, '林地使用权变更登记（空间范围变化）-人', '人', '', '', '', '');insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPL

27、ATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX, POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('46B1EA904B274CF180AA7D5D0A827F41', 'B300201', 'yzdxx', '', '', '', 103, '林地使用权变更登记（空间范围变化）-原宗地信息', '原宗地信息', '', '

28、', '', '');insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX, POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('9D4632E9B85D49E195315DDDC2EA5E46', 'B300201', 'yqlr', '', ''

29、, '', 403, '林地使用权变更登记（空间范围变化）-原权利人', '原权利人', '1', '', '', '');insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX, POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('FE44C22A4

30、5E845E8B0041AB79606AA6C', 'B100101', 'yzdxx', '', '', '', 103, '集体土地所化）-原宗地信息', '原宗地信息', '', '', '', '');变更登记（空间范围变insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SOR

31、T, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('8B8783113F544876A892C07E7409FADA', 'B100101', 'yqlr', '', '', '', 403, '集体土地所-原权利人', '原权利人', '1', '', '', '');commit;变更登记（空间范围变化）

32、insert into sys_receive_setting (ID, QSLX_CODE, DJLX_CODE, WNAME, BOOK_NODE, RECEIVE_ACTION, ARCHIVE_ACTION, BOOK_ACTION,YWLX, DJB_TABLE, YWLXNAME, ARCHIVE_NODE,_NODE, REGISTERBOOK_NODE, BDCLX, BDCLXNAME, YQSLX_CODE, SELECTMODE,FILTER, ISVISIBLE, ZSPZ, TEMPID, SUSPENDSTATUSTIP, CONTINUESTATUSTIP, CS

33、YJ, FSYJ, HDYJ, GSTEMPLATE, ABORT_NODE, TYPEID,EXAMINEJD, FILEPUSH_NODE, SMSTEMPLATE)values ('74DF795284B44834BF5132CC5243057A', '2001', 'M', '国有建设用地使用权及房屋所预告登记', '','AnTu.Bdc.Business.Receive.ReceiveHandles.FirstRegister.FDCQ2_DH', '', 'Dj

34、b.YG.YGDJ', 'M2001', 'DJB_YGDJ', '国有建设用地使用权及房屋所预告变更登记', '', '登簿', '登簿', '2', '土地/房屋', '', 1, 'and regexp_like(bdcdyh,''GBSX'')and ygdjzl in (''1'',''2'')', 1, '不动产登

35、记证明:不动产登记证明-底图版', '5CE211F646DE469DBB29AA66BCCE54D0', '4|正在抵押中，不能办理此登记业务！$8|正在中，不能办理登记业务！$64|已注销，不能进行登记。$1|正在办理中，不能进行登记。', '16|预态，是否继续办理该业务？', '需要审核', '审核通过', '审核通过', '', '', 276, '', '', '');insert into sys_

36、receive_setting (ID, QSLX_CODE, DJLX_CODE, WNAME, BOOK_NODE, RECEIVE_ACTION, ARCHIVE_ACTION, BOOK_ACTION,YWLX, DJB_TABLE, YWLXNAME, ARCHIVE_NODE,_NODE, REGISTERBOOK_NODE, BDCLX, BDCLXNAME, YQSLX_CODE, SELECTMODE,FILTER, ISVISIBLE, ZSPZ, TEMPID, SUSPENDSTATUSTIP, CONTINUESTATUSTIP, CSYJ, FSYJ, HDYJ,

37、GSTEMPLATE, ABORT_NODE, TYPEID,EXAMINEJD, FILEPUSH_NODE, SMSTEMPLATE)values ('6C5C66DD00F24EEEB6422B8C3BE4E7CB', '2001', 'M', '国有建设用地使用权及房屋所预告登记', '','AnTu.Bdc.Business.Receive.ReceiveHandles.FirstRegister.FDCQ2_DH', '', 'Djb.YG.YGDJ',

38、'M2001001', 'DJB_YGDJ', '国有建设用地使用权及房屋所抵押预告变更登记', '', '登簿', '登簿', '2', '土地/房屋', '2001', 0, 'andregexp_like(bdcdyh,''GBSX'') and ygdjzl in (''3'',''4'')', 1, '不动产登记证明:不动产

39、登记证明-底图版','F5D3A44F432849FDBBD2D6FCDA729776', '8|正在中，不能办理登记业务！$1|正在办理中，不能进行登记。$64|已注销，不能进行登记。', '16|预commit;态，是否继续办理该业务？', '需要审核', '审核通过', '审核通过', '', '', 277, '', '', '');insert into sys_ywlayout (ID, YWLX,

40、TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX, POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('6437AFEE7E3546028945AA9A21D57257', 'M2001001', 'ywxx', 'ygdj', 'ZZLX,GYLX', 'APPLICATE_REASON', 300, '国有建设用地使用权及房屋所

41、抵押预告变更登记-业务信息', '业务信息', '', 'SAVE_JTYWXX', '', '');insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('90AF7622AEC84EB59512A29077E225A3&

42、#39;, 'M2001001', 'yqlr', '', '', '', 403, '国有建设用地使用权及房屋所预告变更登记-义务人', '义务人', '1', 'addOneRow,SAVE_JTYWR', '', '');抵押insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT,

43、YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('5CC8CB7D3D2A472BA5CE6EB28E2FB273', 'M2001001', 'qlr', '', '', '', 402, '国有建设用地使用权及房屋所告变更登记-权利人', '权利人', '0', 'SAVE_JTQLR', '', '');抵

44、押预insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('32DC3635DBA844A58D15F58C8029A8B7', 'M2001001', 'dlr', '', '', '', 999, '国有建设用地

45、使用权及房屋所抵押预告变更登记-人', '人', '', 'SAVE_JTDLR', '', '');insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('C2C04576DC4C409084DBA0525FD90C8A&

46、#39;, 'M2001001', 'h', '', 'TDSYQR,MJDW,ZYJ', 'BDCDYH', 203, '国有建设用地使用权及房屋所抵押预告变更登记-房屋信息', '房屋信息', '', 'xsk_yg_fwyw','addOneRow,xsk_zd,xsk_h_danx,h_createbdcdyh', 'showdel');insert into sys_ywlayout (ID, YWLX, TE

47、MPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX, POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('89B5CCB9CF7144DEBE912ED3B0A1E678', 'M2001001', 'zdxx', '', 'QSFJ,SYQMJ', 'READONLYALL', 101, '国有建设用地使用权及房屋所抵押预告变更登记-宗

48、地信息', '宗地信息', '', '', '', '');insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX, POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('AB1FB317D615454087742F9790B27EB4', 'M2001'

49、;, 'ywxx', 'ygdj', 'ZZLX,GYLX,BDBZZQSE,ZWLXQSSJ,ZWLXJSSJ','APPLICATE_REASON', 300, '国有建设用地使用权及房屋所'');预告变更登记-业务信息', '业务信息', '', 'SAVE_JTYWXX', '',insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS,

50、 READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('75E1ABC8BAB044F4B1C25B4122A31FEB', 'M2001', 'yqlr', '', '', '', 403, '国有建设用地使用权及房屋所登记-义务人', '义务人', '1', 'addOneRow,SAVE_JTYWR',

51、 '', '');预告变更insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('EA4537D3B69B4A4ABA40E8801CC64B8D', 'M2001', 'qlr', '', '', '

52、;', 402, '国有建设用地使用权及房屋所登记-权利人', '权利人', '0', 'SAVE_JTQLR', '', '');预告变更insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('5F353D

53、385DAF4A97A0554820F7FAEB74', 'M2001', 'dlr', '', '', '', 999, '国有建设用地使用权及房屋所预告变更登记-人', '人', '', 'SAVE_JTDLR', '', '');insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS,

54、SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('3C951A3EC51A4B5384EC6B85B4B52219', 'M2001', 'h', '', 'TDSYQR,MJDW,ZYJ', 'BDCDYH', 203, '国有建设用地使用权及房屋所'showdel');预告变更登记-房屋信息', '房屋信息', '', '

55、;xsk_yg_fwyw', 'addOneRow,xsk_zd,xsk_h_danx,h_createbdcdyh',insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX, POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('D5EAB5BDF7924E4B83BCC8BE2F53BF51', 'M2001',

56、 'zdxx', '', 'QSFJ,SYQMJ', 'READONLYALL', 101, '国有建设用地使用权及房屋所预告变更登记-宗地信息', '宗地信息', '', '', '', '');insert into sys_ywlayout (ID, YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,

57、POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('228BCC752EE5401283C9744EDBA52B0A', 'M2001', 'zdyt', '', '', '', 102, '国有建设用地使用权及房屋所登记-宗地用途', '宗地用途', '', '', '', '');预告变更insert into sys_ywlayout (ID, YWLX,

58、TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('454E1FCAE1F346C5BB1BFC00E6A2F134', 'M2001001', 'zdyt', '', '', '', 102, '国有建设用地使用权及房屋所预告变更登记-宗地用途', '宗地用途

59、9;, '', '', '', ''); commit;抵押-集体建设用地使用权及房屋所首次登记（大证）insert into sys_receive_setting (QSLX_CODE, DJLX_CODE, WNAME, BOOK_NODE, RECEIVE_ACTION, ARCHIVE_ACTION, BOOK_ACTION,YWLX, DJB_TABLE, YWLXNAME, ARCHIVE_NODE,_NODE, REGISTERBOOK_NODE, BDCLX, BDCLXNAME, YQSLX_CODE, SEL

60、ECTMODE,FILTER, ISVISIBLE, ZSPZ, TEMPID, SUSPENDSTATUSTIP, CONTINUESTATUSTIP, CSYJ, FSYJ, HDYJ, GSTEMPLATE, ABORT_NODE, TYPEID,EXAMINEJD, FILEPUSH_NODE, SMSTEMPLATE)values ('2003', 'A', '国有建设用地使用权及房屋所初始登记（大证）', null,'AnTu.Bdc.Business.Receive.ReceiveHandles.FirstRegister.

61、FDCQ1', 'AssetUnitBus.FDCAssetUnitBus.FDCQ1Bus', 'Djb.FD.FDCQ1SCDJ', 'A200301', 'DJB_FDCQ1', '集体建设用地使用权及房屋所首次登记（大证）', null, '登簿', '登簿', '2','土地/房屋', null, 0, 'and regexp_like(bdcdyh,''JBSX'') and (status

62、is null or status = 0) and BDCDYH not in (selectG.BDCDYH from BDCINFO.XS_GYDY G where G.BDCDYH is not null)', 1, '不动产-房屋:不动产1,不动产2,不动产4', 'db25cb6c-ee01-4b82-9e54-8587e1065cbc', '8|正在中，不能办理登记业务！$1|正在办理中，不能进行登记。$2|已存在权属关系，不能再次办理首次登记。$64|已注销，不能进行登记。$4|正在抵押中，不能办理此登记业务！', nul

63、l, '需要审核', '审核通过', '审核通过', '', null, 272, '', null, null);insert into sys_ywlayout (YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('A200301', 'zdxx', null

64、, 'QSFJ,SYQMJ', 'READONLYALL', 101, '集体建设用地使用权及房屋所宗地信息', '宗地信息', null, 'xsk_zrz', null, null);初始登记（大证）-insert into sys_ywlayout (YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)va

65、lues ('A200301', 'zdyt', null, 'TBZFW', null, 102, '集体建设用地使用权及房屋所地用途', null, null, null, null);初始登记（大证）-宗地用途', '宗insert into sys_ywlayout (YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GR

66、IDSTYLE)values ('A200301', 'ljz', null, null, 'LJZH,L逻辑幢', null, null, null, null);C', 202, '集体建设用地使用权及房屋所初始登记（大证）-逻辑幢', 'insert into sys_ywlayout (YWLX, TEMPLATECODE, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX, POPDIALOG, SIMPLEPOP

67、DIALOG, GRIDSTYLE)values ('A200301', 'zrz', null, 'ZDDM,TDSYQR,FDCJYJG', 'BDCDYH,ZRZH,ZDDM,QLLX|4', 201, '集体建设用地使用权及房屋所有权初始登记（大证）-物信息', '物信息', null, null, 'xsk_zd,zrz_createbdcdyh', null);insert into sys_ywlayout (YWLX, TEMPLATECODE, SUBTEMPLAT

68、ECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('A200301', 'dlr', null, null, null, 999, '集体建设用地使用权及房屋所null, null, null);初始登记（大证）-人', '人', null,insert into sys_ywlayout (YWLX, TEMPLATECODE, SUBTEMPLATECODE, HI

69、DCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('A200301', 'ywxx', null, null, 'APPLICATE_REASON', 300, '集体建设用地使用权及房屋所信息', '业务信息', null, null, null, null);初始登记（大证）-业务insert into sys_ywlayout (YWLX, TEMPLATECODE

70、, SUBTEMPLATECODE, HIDCOLS, READONLYCOLS, SORT, YWLXNAME, TABNAME, DLRGX,POPDIALOG, SIMPLEPOPDIALOG, GRIDSTYLE)values ('A200301', 'qlr', null, null, null, 402, '集体建设用地使用权及房屋所null, null, null);commit;初始登记（大证）-权利人', '权利人', '0',BDCINFO- Add/modify columnsalter table XS_YGDJ add lybdcqzh VARCHAR2(2000);- Add comments to the columnscomment on column XS_YGDJ.lybdcqzh is '来源不动产权证号'- Add/modify columnsalter table LS_YGDJ add lybdcqzh VARCHAR2(2000);- Add comments to the columnscomment on column LS_YGDJ.lybdcqzh is &#