NC（65）元数据增加字段
以报销单主表er_bxzb表为例，增加15个字段字段以及两个其他业务所需字段
1、先在er_bxzb增加字段
增加字段
alter table er_bxzb add no_invoice char(1) default('N');alter table er_bxzb add is_enabled_taxation_cloud char(1) default('N');alter table er_bxzb add zyx31 nvarchar(101) default('~');
alter table er_bxzb add zyx32 nvarchar(101) default('~');
alter table er_bxzb add zyx33 nvarchar(101) default('~');
alter table er_bxzb add zyx34 nvarchar(101) default('~');
alter table er_bxzb add zyx35 nvarchar(101) default('~');
alter table er_bxzb add zyx36 nvarchar(101) default('~');
alter table er_bxzb add zyx37 nvarchar(101) default('~');
alter table er_bxzb add zyx38 nvarchar(101) default('~');
alter table er_bxzb add zyx39 nvarchar(101) default('~');
alter table er_bxzb add zyx40 nvarchar(101) default('~');
alter table er_bxzb add zyx41 nvarchar(101) default('~');
alter table er_bxzb add zyx42 nvarchar(101) default('~');
alter table er_bxzb add zyx43 nvarchar(101) default('~');
alter table er_bxzb add zyx44 nvarchar(101) default('~');
alter table er_bxzb add zyx45 nvarchar(101) default('~');
这里设置的默认值无效，数据库中字段显示还是null，不知为啥，有知道的，请留言指导，感谢！
删除字段
--删除字段，需先删除依赖。依赖如何知道，可以执行删除字段语句，会报错提示，这样就可以得到依赖了。
alter table er_bxzb drop constraint DF__er_bxzb__no_invo__0D6BB239;alter table er_bxzb drop column no_invoice;alter table er_bxzb drop constraint DF__er_bxzb__is_enab__1E963E3B;alter table er_bxzb drop column is_enabled_taxation_cloud;alter table er_bxzb drop constraint DF__er_bxzb__zyx31__0F53FAAB;alter table er_bxzb drop column zyx31;alter table er_bxzb drop constraint DF__er_bxzb__zyx32__10481EE4;alter table er_bxzb drop column zyx32;alter table er_bxzb drop constraint DF__er_bxzb__zyx33__113C431D;alter table er_bxzb drop column zyx33;alter table er_bxzb drop constraint DF__er_bxzb__zyx34__12306756;alter table er_bxzb drop column zyx34;alter table er_bxzb drop constraint DF__er_bxzb__zyx35__13248B8F;alter table er_bxzb drop column zyx35;alter table er_bxzb drop constraint DF__er_bxzb__zyx36__1418AFC8;alter table er_bxzb drop column zyx36;alter table er_bxzb drop constraint DF__er_bxzb__zyx37__150CD401;alter table er_bxzb drop column zyx37;alter table er_bxzb drop constraint DF__er_bxzb__zyx38__1600F83A;alter table er_bxzb drop column zyx38;alter table er_bxzb drop constraint DF__er_bxzb__zyx39__16F51C73;alter table er_bxzb drop column zyx39;alter table er_bxzb drop constraint DF__er_bxzb__zyx40__17E940AC;alter table er_bxzb drop column zyx40;alter table er_bxzb drop constraint DF__er_bxzb__zyx41__18DD64E5;alter table er_bxzb drop column zyx41;alter table er_bxzb drop constraint DF__er_bxzb__zyx42__19D1891E;alter table er_bxzb drop column zyx42;alter table er_bxzb drop constraint DF__er_bxzb__zyx43__1AC5AD57;alter table er_bxzb drop column zyx43;alter table er_bxzb drop constraint DF__er_bxzb__zyx44__1BB9D190;alter table er_bxzb drop column zyx44;alter table er_bxzb drop constraint DF__er_bxzb__zyx45__1CADF5C9;alter table er_bxzb drop column zyx45;2、给元数据相关表插入新增的字段数据记录，主要有三张表需要插入相关记录：md_property、md_ormap、md_column
md_property:
--生成主键 select lower(NEWID());
--md_property表的 id 列的值跟 md_ormap表的 attributeid 列的值必须一样INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 1, null, null, 170, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'N', N'BS000010000100001032', 300, N'N', null, N'无发票类报销', null, N'N', null, N'N', null, N'N', N'ddf88bcc-776a-4445-9124-e464208e98a3', N'0', N'Y', null, null, null, N'no_invoice', N'N', N'N', 0, N'N', null, null, 0, 0);
INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 1, null, null, 171, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'N', N'BS000010000100001032', 300, N'N', null, N'是否启用税务云', null, N'N', null, N'N', null, N'N', N'4abc4d05-a246-4979-967c-55de08fc03ef', N'0', N'Y', null, null, null, N'is_enabled_taxation_cloud', N'N', N'N', 0, N'N', null, null, 0, 0);INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 101, null, null, 172, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'Y', N'BS000010000100001056', 300, null, null, N'自定义项31', null, N'N', null, N'N', null, N'N', N'98f49bad-9b73-447a-8b42-93b0c7ded35c', N'0', N'Y', null, null, null, N'zyx31', N'N', N'Y', 0, N'N', null, '2UC000-000773', 0, 0);
INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 101, null, null, 173, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'Y', N'BS000010000100001056', 300, null, null, N'自定义项32', null, N'N', null, N'N', null, N'N', N'1104d7ed-a341-4e50-a75b-b2bb56b9d788', N'0', N'Y', null, null, null, N'zyx32', N'N', N'Y', 0, N'N', null, '2UC000-000774', 0, 0);INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 101, null, null, 174, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'Y', N'BS000010000100001056', 300, null, null, N'自定义项33', null, N'N', null, N'N', null, N'N', N'535d0a5b-65ff-4b74-90e4-9ddd8e804992', N'0', N'Y', null, null, null, N'zyx33', N'N', N'Y', 0, N'N', null, '2UC000-000775', 0, 0);
INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 101, null, null, 175, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'Y', N'BS000010000100001056', 300, null, null, N'自定义项34', null, N'N', null, N'N', null, N'N', N'478fa985-9a9e-43a3-ac2b-226e1f8d10c7', N'0', N'Y', null, null, null, N'zyx34', N'N', N'Y', 0, N'N', null, '2UC000-000776', 0, 0);INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 101, null, null, 176, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'Y', N'BS000010000100001056', 300, null, null, N'自定义项35', null, N'N', null, N'N', null, N'N', N'7de41ac9-788c-4b2c-9cce-fef84f51f0fa', N'0', N'Y', null, null, null, N'zyx35', N'N', N'Y', 0, N'N', null, '2UC000-000777', 0, 0);
INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 101, null, null, 177, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'Y', N'BS000010000100001056', 300, null, null, N'自定义项36', null, N'N', null, N'N', null, N'N', N'fc3ad678-8ad8-41c8-b0ef-6fb67f4d3be2', N'0', N'Y', null, null, null, N'zyx36', N'N', N'Y', 0, N'N', null, '2UC000-000778', 0, 0);INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 101, null, null, 178, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'Y', N'BS000010000100001056', 300, null, null, N'自定义项37', null, N'N', null, N'N', null, N'N', N'a65f65ef-e106-4f38-b757-f390fd6443ef', N'0', N'Y', null, null, null, N'zyx37', N'N', N'Y', 0, N'N', null, '2UC000-000779', 0, 0);
INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 101, null, null, 179, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'Y', N'BS000010000100001056', 300, null, null, N'自定义项38', null, N'N', null, N'N', null, N'N', N'a2742748-2396-47fd-80d9-20738989b14c', N'0', N'Y', null, null, null, N'zyx38', N'N', N'Y', 0, N'N', null, '2UC000-000780', 0, 0);INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 101, null, null, 180, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'Y', N'BS000010000100001056', 300, null, null, N'自定义项39', null, N'N', null, N'N', null, N'N', N'4ebd5c81-a77b-4046-9e0b-1753110f9338', N'0', N'Y', null, null, null, N'zyx39', N'N', N'Y', 0, N'N', null, '2UC000-000781', 0, 0);
INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 101, null, null, 181, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'Y', N'BS000010000100001056', 300, null, null, N'自定义项40', null, N'N', null, N'N', null, N'N', N'92eed774-dc7f-46ee-ab18-a7849ae0dbc5', N'0', N'Y', null, null, null, N'zyx40', N'N', N'Y', 0, N'N', null, '2UC000-000783', 0, 0);INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 101, null, null, 182, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'Y', N'BS000010000100001056', 300, null, null, N'自定义项41', null, N'N', null, N'N', null, N'N', N'27933d1b-8029-444d-9de9-45b411db77ff', N'0', N'Y', null, null, null, N'zyx41', N'N', N'Y', 0, N'N', null, '22011EXP-000093', 0, 0);
INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 101, null, null, 183, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'Y', N'BS000010000100001056', 300, null, null, N'自定义项42', null, N'N', null, N'N', null, N'N', N'39c5fb2f-c181-448b-9200-b4804a320716', N'0', N'Y', null, null, null, N'zyx42', N'N', N'Y', 0, N'N', null, '22011EXP-000091', 0, 0);INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 101, null, null, 184, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'Y', N'BS000010000100001056', 300, null, null, N'自定义项43', null, N'N', null, N'N', null, N'N', N'0a1fff48-f9f8-435a-88df-de9ce6f5ae2f', N'0', N'Y', null, null, null, N'zyx43', N'N', N'Y', 0, N'N', null, '22011EXP-000092', 0, 0);
INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 101, null, null, 185, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'Y', N'BS000010000100001056', 300, null, null, N'自定义项44', null, N'N', null, N'N', null, N'N', N'1579a43b-e28b-4bd1-987c-3ff8c7d50bbf', N'0', N'Y', null, null, null, N'zyx44', N'N', N'Y', 0, N'N', null, '22011EXP-000101', 0, 0);INSERT INTO md_property (accessorclassname, accesspower, accesspowergroup, attrlength, attrmaxvalue, attrminvalue, attrsequence, calculation, classid, createindustry, createtime, creator, customattr, datatype, datatypestyle, defaultvalue, description, displayname, dr, dynamicattr, dynamictable, fixedlength, help, hided, id, industry, isactive, isauthen, modifier, modifytime, name, notserialize, nullable, precise, readonly, refmodelname, resid, versiontype, visibility) VALUES (null, N'N', null, 101, null, null, 186, N'N', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'0', null, null, N'Y', N'BS000010000100001056', 300, null, null, N'自定义项45', null, N'N', null, N'N', null, N'N', N'3a5190fc-5d24-4df7-9126-89db11f08258', N'0', N'Y', null, null, null, N'zyx45', N'N', N'Y', 0, N'N', null, '22011EXP-000100', 0, 0);
md_ormap:
--生成主键 select lower(NEWID());
--md_ormap表的 attributeid 列的值跟 md_property表的 id 列的值必须一样INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'ddf88bcc-776a-4445-9124-e464208e98a3', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@no_invoice', null, N'er_bxzb');
INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'4abc4d05-a246-4979-967c-55de08fc03ef', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@is_enabled_taxation_cloud', null, N'er_bxzb');INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'98f49bad-9b73-447a-8b42-93b0c7ded35c', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@zyx31', null, N'er_bxzb');
INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'1104d7ed-a341-4e50-a75b-b2bb56b9d788', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@zyx32', null, N'er_bxzb');INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'535d0a5b-65ff-4b74-90e4-9ddd8e804992', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@zyx33', null, N'er_bxzb');
INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'478fa985-9a9e-43a3-ac2b-226e1f8d10c7', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@zyx34', null, N'er_bxzb');INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'7de41ac9-788c-4b2c-9cce-fef84f51f0fa', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@zyx35', null, N'er_bxzb');
INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'fc3ad678-8ad8-41c8-b0ef-6fb67f4d3be2', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@zyx36', null, N'er_bxzb');INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'a65f65ef-e106-4f38-b757-f390fd6443ef', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@zyx37', null, N'er_bxzb');
INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'a2742748-2396-47fd-80d9-20738989b14c', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@zyx38', null, N'er_bxzb');INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'4ebd5c81-a77b-4046-9e0b-1753110f9338', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@zyx39', null, N'er_bxzb');
INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'92eed774-dc7f-46ee-ab18-a7849ae0dbc5', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@zyx40', null, N'er_bxzb');INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'27933d1b-8029-444d-9de9-45b411db77ff', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@zyx41', null, N'er_bxzb');
INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'39c5fb2f-c181-448b-9200-b4804a320716', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@zyx42', null, N'er_bxzb');INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'0a1fff48-f9f8-435a-88df-de9ce6f5ae2f', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@zyx43', null, N'er_bxzb');
INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'1579a43b-e28b-4bd1-987c-3ff8c7d50bbf', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@zyx44', null, N'er_bxzb');INSERT INTO md_ormap (attributeid, classid, columnid, dr, tableid) VALUES (N'3a5190fc-5d24-4df7-9126-89db11f08258', N'd9b9f860-4dc7-47fa-a7d5-7a5d91f39290', N'er_bxzb@@@zyx45', null, N'er_bxzb');
md_column:
INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (1, 170, 0, null, null, N'N', null, N'无发票类报销', null, N'N', null, null, N'er_bxzb@@@no_invoice', null, null, null, N'Y', null, null, N'no_invoice', N'N', N'N', 0, null, N'char', N'er_bxzb', 0);
INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (1, 171, 0, null, null, N'N', null, N'是否启用税务云', null, N'N', null, null, N'er_bxzb@@@is_enabled_taxation_cloud', null, null, null, N'Y', null, null, N'is_enabled_taxation_cloud', N'N', N'N', 0, null, N'char', N'er_bxzb', 0);INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (101, 172, 0, null, null, null, null, N'自定义项31', null, N'N', null, null, N'er_bxzb@@@zyx31', null, null, null, N'Y', null, null, N'zyx31', N'Y', N'N', 0, '2UC000-000773', N'varchar', N'er_bxzb', 0);
INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (101, 173, 0, null, null, null, null, N'自定义项32', null, N'N', null, null, N'er_bxzb@@@zyx32', null, null, null, N'Y', null, null, N'zyx32', N'Y', N'N', 0, '2UC000-000774', N'varchar', N'er_bxzb', 0);INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (101, 174, 0, null, null, null, null, N'自定义项31', null, N'N', null, null, N'er_bxzb@@@zyx33', null, null, null, N'Y', null, null, N'zyx33', N'Y', N'N', 0, '2UC000-000775', N'varchar', N'er_bxzb', 0);
INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (101, 175, 0, null, null, null, null, N'自定义项34', null, N'N', null, null, N'er_bxzb@@@zyx34', null, null, null, N'Y', null, null, N'zyx34', N'Y', N'N', 0, '2UC000-000776', N'varchar', N'er_bxzb', 0);INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (101, 176, 0, null, null, null, null, N'自定义项35', null, N'N', null, null, N'er_bxzb@@@zyx35', null, null, null, N'Y', null, null, N'zyx35', N'Y', N'N', 0, '2UC000-000777', N'varchar', N'er_bxzb', 0);
INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (101, 177, 0, null, null, null, null, N'自定义项36', null, N'N', null, null, N'er_bxzb@@@zyx36', null, null, null, N'Y', null, null, N'zyx36', N'Y', N'N', 0, '2UC000-000778', N'varchar', N'er_bxzb', 0);INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (101, 178, 0, null, null, null, null, N'自定义项37', null, N'N', null, null, N'er_bxzb@@@zyx37', null, null, null, N'Y', null, null, N'zyx37', N'Y', N'N', 0, '2UC000-000779', N'varchar', N'er_bxzb', 0);
INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (101, 179, 0, null, null, null, null, N'自定义项38', null, N'N', null, null, N'er_bxzb@@@zyx38', null, null, null, N'Y', null, null, N'zyx38', N'Y', N'N', 0, '2UC000-000780', N'varchar', N'er_bxzb', 0);INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (101, 180, 0, null, null, null, null, N'自定义项39', null, N'N', null, null, N'er_bxzb@@@zyx39', null, null, null, N'Y', null, null, N'zyx39', N'Y', N'N', 0, '2UC000-000781', N'varchar', N'er_bxzb', 0);
INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (101, 181, 0, null, null, null, null, N'自定义项40', null, N'N', null, null, N'er_bxzb@@@zyx40', null, null, null, N'Y', null, null, N'zyx40', N'Y', N'N', 0, '2UC000-000783', N'varchar', N'er_bxzb', 0);INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (101, 182, 0, null, null, null, null, N'自定义项41', null, N'N', null, null, N'er_bxzb@@@zyx41', null, null, null, N'Y', null, null, N'zyx41', N'Y', N'N', 0, '22011EXP-000093', N'varchar', N'er_bxzb', 0);
INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (101, 183, 0, null, null, null, null, N'自定义项42', null, N'N', null, null, N'er_bxzb@@@zyx42', null, null, null, N'Y', null, null, N'zyx42', N'Y', N'N', 0, '22011EXP-000091', N'varchar', N'er_bxzb', 0);INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (101, 184, 0, null, null, null, null, N'自定义项43', null, N'N', null, null, N'er_bxzb@@@zyx43', null, null, null, N'Y', null, null, N'zyx43', N'Y', N'N', 0, '22011EXP-000092', N'varchar', N'er_bxzb', 0);
INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (101, 185, 0, null, null, null, null, N'自定义项44', null, N'N', null, null, N'er_bxzb@@@zyx44', null, null, null, N'Y', null, null, N'zyx44', N'Y', N'N', 0, '22011EXP-000101', N'varchar', N'er_bxzb', 0);INSERT INTO md_column (columnlength, columnsequence, columntype, createtime, creator, defaultvalue, description, displayname, dr, forlocale, groupid, help, id, identitied, incrementseed, incrementstep, isactive, modifier, modifytime, name, nullable, pkey, precise, resid, sqldatetype, tableid, versiontype) VALUES (101, 186, 0, null, null, null, null, N'自定义项45', null, N'N', null, null, N'er_bxzb@@@zyx45', null, null, null, N'Y', null, null, N'zyx45', N'Y', N'N', 0, '22011EXP-000100', N'varchar', N'er_bxzb', 0);3、在元数据文件(nchome\modules\erm\METADATA\expenseaccount.bmf)的< attributelist > </ attributelist>属性最后插入如下内容：
<celllist><entity accessorClassName="nc.md.model.access.javamap.AggVOStyle" bizItfImpClassName="" componentID="34191cb9-6aa7-414d-bd1e-0d9091e554af" createIndustry="0" createTime="2010-01-18 09:32:58" creator="" czlist="" description="" displayName="报销单" fullClassName="nc.vo.ep.bx.BXHeaderVO" height="265" help="BUSILOG" id="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" industryChanged="false" isAuthen="true" isCreateSQL="true" isExtendBean="false" isPrimary="true" isSource="false" keyAttributeId="34fa6b97-93ec-4cb8-8cf1-bd506527302e" modInfoClassName="" modifier="" modifyIndustry="0" modifyTime="2022-01-20 16:48:15" name="bxzb" resid="22011EXP-000090" stereoType="" tableName="er_bxzb" userDefClassName="" versionType="0" visibility="public" width="133" x="298" y="203"><attributelist><-- 以下位需要插入的字段呢容 -><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001032" dataTypeStyle="SINGLE" dbtype="char" defaultValue="N" description="" displayName="无发票类报销" dynamic="false" dynamicTable="" fieldName="no_invoice" fieldType="char" fixedLength="false" forLocale="false" help="" id="ddf88bcc-776a-4445-9124-e464208e98a3" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="false" isReadOnly="false" isShare="false" isSource="true" length="1" maxValue="" minValue="" modifyIndustry="0" name="no_invoice" notSerialize="false" precise="" refModelName="" resid="" sequence="170" typeDisplayName="UFBoolean" typeName="UFBoolean" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001032" dataTypeStyle="SINGLE" dbtype="char" defaultValue="N" description="" displayName="是否启用税务云" dynamic="false" dynamicTable="" fieldName="is_enabled_taxation_cloud" fieldType="char" fixedLength="false" forLocale="false" help="" id="4abc4d05-a246-4979-967c-55de08fc03ef" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="false" isReadOnly="false" isShare="false" isSource="true" length="1" maxValue="" minValue="" modifyIndustry="0" name="is_enabled_taxation_cloud" notSerialize="false" precise="" refModelName="" resid="" sequence="171" typeDisplayName="UFBoolean" typeName="UFBoolean" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001056" dataTypeStyle="SINGLE" dbtype="varchar" defaultValue="" description="" displayName="自定义项31" dynamic="false" dynamicTable="" fieldName="zyx30" fieldType="varchar" fixedLength="false" forLocale="false" help="" id="98f49bad-9b73-447a-8b42-93b0c7ded35c" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="true" isReadOnly="false" isShare="false" isSource="true" length="101" maxValue="" minValue="" modifyIndustry="0" name="zyx31" notSerialize="false" precise="" refModelName="" resid="2UC000-000773" sequence="172" typeDisplayName="自定义项" typeName="CUSTOM" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001056" dataTypeStyle="SINGLE" dbtype="varchar" defaultValue="" description="" displayName="自定义项32" dynamic="false" dynamicTable="" fieldName="zyx30" fieldType="varchar" fixedLength="false" forLocale="false" help="" id="1104d7ed-a341-4e50-a75b-b2bb56b9d788" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="true" isReadOnly="false" isShare="false" isSource="true" length="101" maxValue="" minValue="" modifyIndustry="0" name="zyx32" notSerialize="false" precise="" refModelName="" resid="2UC000-000774" sequence="173" typeDisplayName="自定义项" typeName="CUSTOM" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001056" dataTypeStyle="SINGLE" dbtype="varchar" defaultValue="" description="" displayName="自定义项33" dynamic="false" dynamicTable="" fieldName="zyx30" fieldType="varchar" fixedLength="false" forLocale="false" help="" id="535d0a5b-65ff-4b74-90e4-9ddd8e804992" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="true" isReadOnly="false" isShare="false" isSource="true" length="101" maxValue="" minValue="" modifyIndustry="0" name="zyx33" notSerialize="false" precise="" refModelName="" resid="2UC000-000775" sequence="174" typeDisplayName="自定义项" typeName="CUSTOM" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001056" dataTypeStyle="SINGLE" dbtype="varchar" defaultValue="" description="" displayName="自定义项34" dynamic="false" dynamicTable="" fieldName="zyx30" fieldType="varchar" fixedLength="false" forLocale="false" help="" id="478fa985-9a9e-43a3-ac2b-226e1f8d10c7" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="true" isReadOnly="false" isShare="false" isSource="true" length="101" maxValue="" minValue="" modifyIndustry="0" name="zyx34" notSerialize="false" precise="" refModelName="" resid="2UC000-000776" sequence="175" typeDisplayName="自定义项" typeName="CUSTOM" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001056" dataTypeStyle="SINGLE" dbtype="varchar" defaultValue="" description="" displayName="自定义项35" dynamic="false" dynamicTable="" fieldName="zyx30" fieldType="varchar" fixedLength="false" forLocale="false" help="" id="7de41ac9-788c-4b2c-9cce-fef84f51f0fa" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="true" isReadOnly="false" isShare="false" isSource="true" length="101" maxValue="" minValue="" modifyIndustry="0" name="zyx35" notSerialize="false" precise="" refModelName="" resid="2UC000-000777" sequence="176" typeDisplayName="自定义项" typeName="CUSTOM" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001056" dataTypeStyle="SINGLE" dbtype="varchar" defaultValue="" description="" displayName="自定义项36" dynamic="false" dynamicTable="" fieldName="zyx30" fieldType="varchar" fixedLength="false" forLocale="false" help="" id="fc3ad678-8ad8-41c8-b0ef-6fb67f4d3be2" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="true" isReadOnly="false" isShare="false" isSource="true" length="101" maxValue="" minValue="" modifyIndustry="0" name="zyx36" notSerialize="false" precise="" refModelName="" resid="2UC000-000778" sequence="177" typeDisplayName="自定义项" typeName="CUSTOM" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001056" dataTypeStyle="SINGLE" dbtype="varchar" defaultValue="" description="" displayName="自定义项37" dynamic="false" dynamicTable="" fieldName="zyx30" fieldType="varchar" fixedLength="false" forLocale="false" help="" id="a65f65ef-e106-4f38-b757-f390fd6443ef" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="true" isReadOnly="false" isShare="false" isSource="true" length="101" maxValue="" minValue="" modifyIndustry="0" name="zyx37" notSerialize="false" precise="" refModelName="" resid="2UC000-000779" sequence="178" typeDisplayName="自定义项" typeName="CUSTOM" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001056" dataTypeStyle="SINGLE" dbtype="varchar" defaultValue="" description="" displayName="自定义项38" dynamic="false" dynamicTable="" fieldName="zyx30" fieldType="varchar" fixedLength="false" forLocale="false" help="" id="a2742748-2396-47fd-80d9-20738989b14c" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="true" isReadOnly="false" isShare="false" isSource="true" length="101" maxValue="" minValue="" modifyIndustry="0" name="zyx38" notSerialize="false" precise="" refModelName="" resid="2UC000-000780" sequence="179" typeDisplayName="自定义项" typeName="CUSTOM" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001056" dataTypeStyle="SINGLE" dbtype="varchar" defaultValue="" description="" displayName="自定义项39" dynamic="false" dynamicTable="" fieldName="zyx30" fieldType="varchar" fixedLength="false" forLocale="false" help="" id="4ebd5c81-a77b-4046-9e0b-1753110f9338" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="true" isReadOnly="false" isShare="false" isSource="true" length="101" maxValue="" minValue="" modifyIndustry="0" name="zyx30" notSerialize="false" precise="" refModelName="" resid="2UC000-000781" sequence="180" typeDisplayName="自定义项" typeName="CUSTOM" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001056" dataTypeStyle="SINGLE" dbtype="varchar" defaultValue="" description="" displayName="自定义项40" dynamic="false" dynamicTable="" fieldName="zyx30" fieldType="varchar" fixedLength="false" forLocale="false" help="" id="92eed774-dc7f-46ee-ab18-a7849ae0dbc5" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="true" isReadOnly="false" isShare="false" isSource="true" length="101" maxValue="" minValue="" modifyIndustry="0" name="zyx40" notSerialize="false" precise="" refModelName="" resid="2UC000-000783" sequence="181" typeDisplayName="自定义项" typeName="CUSTOM" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001056" dataTypeStyle="SINGLE" dbtype="varchar" defaultValue="" description="" displayName="自定义项41" dynamic="false" dynamicTable="" fieldName="zyx30" fieldType="varchar" fixedLength="false" forLocale="false" help="" id="27933d1b-8029-444d-9de9-45b411db77ff" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="true" isReadOnly="false" isShare="false" isSource="true" length="101" maxValue="" minValue="" modifyIndustry="0" name="zyx41" notSerialize="false" precise="" refModelName="" resid="22011EXP-000093" sequence="182" typeDisplayName="自定义项" typeName="CUSTOM" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001056" dataTypeStyle="SINGLE" dbtype="varchar" defaultValue="" description="" displayName="自定义项42" dynamic="false" dynamicTable="" fieldName="zyx30" fieldType="varchar" fixedLength="false" forLocale="false" help="" id="39c5fb2f-c181-448b-9200-b4804a320716" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="true" isReadOnly="false" isShare="false" isSource="true" length="101" maxValue="" minValue="" modifyIndustry="0" name="zyx42" notSerialize="false" precise="" refModelName="" resid="22011EXP-000091" sequence="183" typeDisplayName="自定义项" typeName="CUSTOM" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001056" dataTypeStyle="SINGLE" dbtype="varchar" defaultValue="" description="" displayName="自定义项43" dynamic="false" dynamicTable="" fieldName="zyx30" fieldType="varchar" fixedLength="false" forLocale="false" help="" id="0a1fff48-f9f8-435a-88df-de9ce6f5ae2f" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="true" isReadOnly="false" isShare="false" isSource="true" length="101" maxValue="" minValue="" modifyIndustry="0" name="zyx43" notSerialize="false" precise="" refModelName="" resid="22011EXP-000092" sequence="184" typeDisplayName="自定义项" typeName="CUSTOM" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001056" dataTypeStyle="SINGLE" dbtype="varchar" defaultValue="" description="" displayName="自定义项44" dynamic="false" dynamicTable="" fieldName="zyx30" fieldType="varchar" fixedLength="false" forLocale="false" help="" id="1579a43b-e28b-4bd1-987c-3ff8c7d50bbf" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="true" isReadOnly="false" isShare="false" isSource="true" length="101" maxValue="" minValue="" modifyIndustry="0" name="zyx44" notSerialize="false" precise="" refModelName="" resid="22011EXP-000101" sequence="185" typeDisplayName="自定义项" typeName="CUSTOM" versionType="0" visibility="public"/><attribute accessStrategy="" accesspower="false" accesspowergroup="" calculation="false" classID="d9b9f860-4dc7-47fa-a7d5-7a5d91f39290" createIndustry="0" dataType="BS000010000100001056" dataTypeStyle="SINGLE" dbtype="varchar" defaultValue="" description="" displayName="自定义项45" dynamic="false" dynamicTable="" fieldName="zyx30" fieldType="varchar" fixedLength="false" forLocale="false" help="" id="3a5190fc-5d24-4df7-9126-89db11f08258" industryChanged="false" isActive="true" isAuthorization="true" isDefaultDimensionAttribute="false" isDefaultMeasureAttribute="false" isFeature="false" isGlobalization="false" isHide="false" isKey="false" isNullable="true" isReadOnly="false" isShare="false" isSource="true" length="101" maxValue="" minValue="" modifyIndustry="0" name="zyx45" notSerialize="false" precise="" refModelName="" resid="22011EXP-000100" sequence="186" typeDisplayName="自定义项" typeName="CUSTOM" versionType="0" visibility="public"/></attributelist>
4、用集团管理员登录，然后在元数据管理节点升级元数据
5、重启服务，清除缓存。
6、报销单用户自定义属性设置那里，表头只显示30个属性，现增加了15个，即总共45个，如何显示45个呢？
如下图：
在【用户自定义属性组】节点中，修改用户自定义属性数量即可。
注意：组编码直接填写功能注册中的功能编码即可，数量填写自定义字段的数量，比如有20个自定义字段则填写20，若出现多组自定义字段时，则需要填写前缀，比如vbdef与def，vdef配置哪组则填写那组的前缀，只有一组不填写。
8、自此，打开【用户自定义属性设置】节点，看到有新增的15个自定义字段。如果要修改自定义字段的显示名称，需要修改数据类型，输入长度等属性，否则不能保存相关修改的记录。
相关文章：
NC（65）元数据增加字段
以报销单主表er_bxzb表为例，增加15个字段字段以及两个其他业务所需字段 1、先在er_bxzb增加字段 增加字段 alter table er_bxzb add no_invoice char(1) default(N);alter table er_bxzb add is_enabled_taxation_cloud char(1) default(N);alter table er_bxzb a…...
SParC数据集介绍
导语 SParC是Text-to-SQL领域的一个多轮查询数据集。本篇博客将对该数据集论文和数据格式进行简要介绍。 SParC数据集概述 SParC是一个跨领域的多轮Text-to-SQL数据集。它包含有4298个问题轮次，大约有12k的自然语言问句到SQL标注的Question-SQL对。这些问题来自于…...
OpenGL 绘制Mesh数据（Qt）
文章目录 一、简介二、实现代码三、实现效果一、简介 Mesh数据的结构主要就是点与三角面片，因此本质上仍然是对三角面片进行绘制。这里我们借助VCG这个库实现对Mesh数据的读取，这个库相对简单轻巧，很方便使用。 二、实现代码 由于修改的部分很多，我们逐一进行解释一下： --…...
9.传统的轨道画线算法（）
轨道画线分为以下步骤： 1.读取摄像头图片 2.图片灰度处理，截取轨道区域的图片 3.中值滤波处理，并区域取均值后做期望差的绝对值。本人通过一些轨道图片实验，用这种方法二值化得到的效果比caany算子等方法的效果好 4.二值化后再…...
 : B DS二叉排序树_有效的二叉排序树)
F (1164) : B DS二叉排序树_有效的二叉排序树
Description 给你一个二叉树，判断其是否是一个有效的二叉排序树。 有效的二叉排序树定义如下： 1. 结点的左子树只包含小于当前结点的数。 2. 结点的右子树只包含大于当前结点的数。 3. 所有左子树和右子树自身必须也是二叉排序树。 Input 第一行输…...
结合el-upload修改支持上传图片、视频并预览
结合element plus的el-upload标签，实现上传图片和视频，并支持在线预览和放大 1、html部分 <el-form-item label"活动照片、视频"><el-uploadv-model:file-list"state.photoList":action"state.uploadUrl"accept…...
1.SQL - 概述
1. SQL语句分类 • 数据定义语言：简称DDL(Data Definition Language)，用来定义数据库对象：数据库，表，列等。关键字：create，alter，drop等 • 数据操作语言：简称DML(Data …...
GaussDB数据库表创建行访问控制策略
目录 一、前言 二、GaussDB中的行访问控制 1、CREATE ROW LEVEL SECURITY POLICY语法 2、ALTER ROW LEVEL SECURITY POLICY语法 3、ROW LEVEL SECURITY策略与适配SQL语法关系 三、GaussDB中的行访问控制策略示例 1、实现GaussDB行访问控制的一般步骤 2、行访问控制策略…...
提升设备巡检效率的关键:易点易动设备管理系统的应用
随着互联网技术的发展,智慧设备管理已成为各行各业提升运营效率的重要选择。相比传统的手动巡检方式,采用设备管理系统可以实现物联网技术给企业带来更高效的运营方式。其中,易点易动作为一款成熟的设备管理系统,其广泛应用于提升设备巡检效率这一领域发挥了很好的作用。 采用易…...
【C++】STL 容器 - list 双向链表容器 ① ( 容器特点 | 容器操作时间复杂度 | 构造函数 )
文章目录 一、 list 双向链表容器简介1、容器特点2、容器操作时间复杂度3、遍历访问5、头文件 二、 list 双向链表容器 构造函数1、默认无参构造函数2、创建包含 n 个相同元素的 list 双向链表3、使用初始化列表构造 list 双向链表4、使用另外一个 list 容器 构造 list 双向链表…...
[C/C++]数据结构 希尔排序
🥦前言: 希尔排序也称 “缩小增量排序”，它也是一种插入类排序的方法,在学习希尔排序之前我们首先了解一下直接插入排序. 一: 🚩直接插入排序 1.1 🌟排序思路 直接插入排序的基本原理是将一条记录插入到已排好的有序表中&#x…...
SQL进阶：子查询
一般情况下，我们都是直接对表进行查询，但有时候，想要的数据可能通过一次select 获取不到，需要嵌套select，这样就形成了子查询。 子查询可以位于查询语句的任意位置，主要的注意点在于用于不同的位置，和不同的关键字一起使用时，需要注意返回的列的数量和行的数量。 位于…...
5、IDEA集成Git
IDEA集成Git 1. 配置Git忽略文件2. 定位Git程序3. 初始化本地库、添加暂存区、提交到本地库4. 切换版本5. 创建分支和切换分支6. 合并分支7. 解决冲突 1. 配置Git忽略文件 问题1：为什么要忽略他们？ 与项目的实际功能无关，不参与服务器上部署…...
oracle数据库sqlplus登录卡顿
问题描述 新安装了一套oracle 11.2.0.1 版本的数据库服务器，出现了在服务器本地通过sqlplus / as sysdba登录的时候很快，但是通过监听登录的时候就非常的慢，卡顿，大概需要1分钟多的时间才能登进数据库。 之前安装了好几套oracle …...
【C#】Visual Studio 2022 远程调试配置教程
在某些特殊的情况下，开发机和调试机可能不是同一台设备，此时就需要远程调试了。 开发机配置 首先需要确保两台机器在同一局域网下。 创建共享文件夹 随便找个地方新建一个文件夹，用来放编译结果。例如我这里是 D:\DebuggingWorkspace\。 …...
LSTM的记忆能力实验
长短期记忆网络（Long Short-Term Memory Network，LSTM）是一种可以有效缓解长程依赖问题的循环神经网络．LSTM 的特点是引入了一个新的内部状态（Internal State) 和门控机制（Gating Mechanism）&am…...
Unity之ShaderGraph如何实现瓶装水效果
前言 有一个场景在做效果时，有一个水瓶放到桌子上的设定，但是模型只做了个水瓶，里面是空的，所以我就想办法，如何做出来瓶中装睡的效果，最好是能跟随瓶子有液体流动的效果。 如下图所示： 水面实现 水面效果 液体颜色设置 因为液体有边缘颜色和内里面颜色，所以要分开…...
【python与机器学习3】感知机和门电路：与门，或门，非门等
目录 1 电子和程序里的与门，非门，或门，与非门 ，或非门，异或门 1.1 基础电路 1.2 所有的电路情况 1.3 电路的符号 1.4 各种电路对应的实际电路图 2 各种具体的电路 2.1 与门（and gate） 2…...
关键字：extends关键字
在 Java 中，extends 是一个关键字，用于表示继承关系。当一个类使用 extends 关键字时，它表示该类是一个子类，并且继承了父类的属性和方法。 以下是 extends 关键字的解析： 语法： 描述： ChildC…...
KEPServerEX 6 之【外篇-1】PTC-ThingWorx服务端软件安装 Tomcat10本地安装
本文目标： 安装 Java 和 Apache Tomcat ，为ThingWorx安装做基础。 ----------------------------------------------------------------------- 安装重点 --------------------------------------------------------------------- 1. 安装 Java 11 / JDK 11 添加系…...
PPTist：4大突破性功能重塑Web端演示文稿创作体验
PPTist：4大突破性功能重塑Web端演示文稿创作体验 【免费下载链接】PPTist PowerPoint-ist（/pauəpɔintist/）, An online presentation application that replicates most of the commonly used features of MS PowerPoint, allowing for the…...
实测Qwen-Image-Edit-2511：输入一张图，输出360°环绕视角，效果太强了
实测Qwen-Image-Edit-2511：输入一张图，输出360环绕视角，效果太强了 1. 引言：单图变多视角的技术突破 想象一下，你只需要一张普通的商品照片，就能自动生成360度全方位的展示效果。这不是科幻电影里的场景&…...
Netbird iOS客户端连接问题分析与解决方案
Netbird iOS客户端连接问题分析与解决方案 Netbird作为一款优秀的P2P网络工具，在跨平台使用中可能会遇到一些兼容性问题。近期iOS客户端出现的连接异常现象引起了开发者社区的关注。本文将深入分析该问题的技术背景，并提供有效的解决方案。 问题现象描述…...
markdown基础语法及效果演示
[toc] 自动生成目录 文章目录标题二级标题# 标题 一级标题 标题 - 无序列表 无序列表无序列表 # 二级标题 二级标题 代码块： python print(“hello world!”) #代码块 print("hello world!") #代码块>引用 引用 >>二级引用 二级引用 - […...
OpenClaw+SecGPT-14B：个人安全实验室自动化搭建全指南
OpenClawSecGPT-14B：个人安全实验室自动化搭建全指南 1. 为什么需要自动化安全实验室 作为一名长期从事安全研究的工程师，我深刻体会到传统手工分析的低效与局限。每次分析新样本时，都需要重复搭建环境、配置工具、收集威胁情报，…...
域名过期后会不会影响网站的SEO排名
域名过期后是否会影响网站的SEO排名：深入探讨与解决方案 在当今互联网时代，域名是网站的核心标识，它不仅代表了网站的身份，还在搜索引擎优化（SEO）中扮演着重要角色。有时我们可能会面临域名过期的情况&…...
告别繁琐文字提取：Text-Grab本地化OCR工具效率提升指南
告别繁琐文字提取：Text-Grab本地化OCR工具效率提升指南 【免费下载链接】Text-Grab Use OCR in Windows quickly and easily with Text Grab. With optional background process and notifications. 项目地址: https://gitcode.com/gh_mirrors/te/Text-Grab …...
开源心电监测终极指南：AD8232心率监测器的精准监测与实时分析方案
开源心电监测终极指南：AD8232心率监测器的精准监测与实时分析方案 【免费下载链接】AD8232_Heart_Rate_Monitor AD8232 Heart Rate Monitor 项目地址: https://gitcode.com/gh_mirrors/ad/AD8232_Heart_Rate_Monitor AD8232心率监测器是一款基于专业心电传感…...
CasRel关系抽取完整流程：从原始文本清洗、NER预处理到SPO抽取
CasRel关系抽取完整流程：从原始文本清洗、NER预处理到SPO抽取 1. 什么是CasRel关系抽取？ CasRel（Cascade Binary Tagging Framework）是一个专门从文本中自动提取"谁-做了什么-对谁"这种关系信息的AI模型。想象一下&am…...
Hunyuan-MT-7B多场景实践：像素语言传送门在独立游戏开发、字幕生成、文档本地化中的三重应用
Hunyuan-MT-7B多场景实践：像素语言传送门在独立游戏开发、字幕生成、文档本地化中的三重应用 1. 像素语言传送门：当翻译遇见16-bit冒险 在独立游戏开发者的工作台上，一款名为"像素语言传送门"的工具正在改变传统翻译体验。这款基…...