NC(65)元数据增加字段

2023-12-26 17:49:19

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

文章来源:https://blog.csdn.net/u010741112/article/details/135223946
本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。