当前位置： 首页 > news >正文

NC（65）元数据增加字段

news 2025/9/16 0:22:46

以报销单主表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个自定义字段。如果要修改自定义字段的显示名称，需要修改数据类型，输入长度等属性，否则不能保存相关修改的记录。
在这里插入图片描述

http://www.lryc.cn/news/267918.html

相关文章：

  • SParC数据集介绍
  • OpenGL 绘制Mesh数据（Qt）
  • 9.传统的轨道画线算法（）
  • F (1164) : B DS二叉排序树_有效的二叉排序树
  • 结合el-upload修改支持上传图片、视频并预览
  • 1.SQL - 概述
  • GaussDB数据库表创建行访问控制策略
  • 提升设备巡检效率的关键:易点易动设备管理系统的应用
  • 【C++】STL 容器 - list 双向链表容器 ① ( 容器特点 | 容器操作时间复杂度 | 构造函数 )
  • [C/C++]数据结构 希尔排序
  • SQL进阶：子查询
  • 5、IDEA集成Git
  • oracle数据库sqlplus登录卡顿
  • 【C#】Visual Studio 2022 远程调试配置教程
  • LSTM的记忆能力实验
  • Unity之ShaderGraph如何实现瓶装水效果
  • 【python与机器学习3】感知机和门电路：与门，或门，非门等
  • 关键字：extends关键字
  • KEPServerEX 6 之【外篇-1】PTC-ThingWorx服务端软件安装 Tomcat10本地安装
  • （Mac上）使用Python进行matplotlib 画图时，中文显示不出来
  • 万能刷题小程序源码系统：功能强大+试题管理+题库分类+用户列表 附带完整的搭建教程
  • 5.2 显示窗口的内容（二）
  • SpringCloud 整合 Canal+RabbitMQ+Redis 实现数据监听
  • 一体机定制_工控触控一体机安卓主板方案
  • Android10.0 人脸解锁流程分析
  • P8598 [蓝桥杯 2013 省 AB] 错误票据
  • 【Android进阶篇】Android中PreferenceScreen的作用和详细用法介绍
  • test-03-java 单元测试框架 testNG 入门介绍 junit/junit5/testNG 详细对比
  • Maven 项目依赖仓库配置详解：pom.xml 中的 repositories 与 Maven 配置文件的调用顺序
  • JS深浅拷贝