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

唐山建站公司模板seo外链网站大全

唐山建站公司模板,seo外链网站大全,做卷子的网站,杭州建设招聘信息网站以报销单主表er_bxzb表为例,增加15个字段字段以及两个其他业务所需字段 1、先在er_bxzb增加字段 增加字段 alter table er_bxzb add no_invoice char(1) default(N);alter table er_bxzb add is_enabled_taxation_cloud char(1) default(N);alter table er_bxzb a…

以报销单主表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.yayakq.cn/news/892924/

相关文章:

  • 网站品牌推广设计泉州做网站的公司
  • 贵阳建站推广公司宝安新闻最新消息今天
  • 千图主站的功能介绍东莞网站建设业务的公司
  • 济南美赞网站建设公司wordpress自适应菜单
  • 空投注册送币网站怎么做四川建设网四川住建厅
  • 网站建设网络科技公司加盟狗和女人做的网站
  • 网站策划 要求企业所得税怎么算举例
  • 自己做网站步骤 域名成都网站外包公司
  • 网站建设建网站年轻的母亲网站建设介绍推广用语
  • wordpress站点标题副标题换行ios认证 东莞网站建设
  • 湖南营销型网站建设 皆来磐石网络关闭微信小程序入口
  • 做系统简单还是网站简单网站建设销售招聘
  • seo网站排名的软件德宏做网站
  • 电商类网站建设需要多少钱为什么我的网站备案通过还是显示未备案
  • 网站开发和移动开发WordPress卡密充值怎么用
  • 烟台做网站的价格建站收入
  • 企业建设好一个网站后_如何进行网站推广?免费域名注册网站哪个好
  • 卖建材的网站广州今天新闻
  • 成都企业网站seo技术响应式布局网站实例
  • 湖北省住房和城乡建设厅门户网站wordpress对接公众号源码
  • 如何做盗版小说网站安徽六安职业技术学院
  • 网站开发商品管理表字段折叠分类目录模板wordpress
  • 昌网站建设wordpress 内容页面
  • 江门网站制作方案定制网络推广培训哪里好
  • 制作网站域名需要多少钱泉州百度seo公司
  • 海外seo网站建设专业深圳网站建设公司
  • windows软件开发台州网站优化
  • 网站排名张家港电子商务网站建设与管理试卷6
  • 哪里有专业做网站的wordpress centos6
  • 湖南省建设信息网站网站建设哪里学