PLM内容专辑（三）

栏目：云星空知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

PLM内容专辑（三）

--建表脚本--

create table T_PLM_CFG_ERPBOMFIELD_L(

FPKID bigint not null comment 'FPKID'

,FID bigint not null comment 'FID'

,FLocaleID int not null comment 'FLocaleID'

,FNAME nvarchar(500) not null comment '名称'

,FELEMENTTYPE nvarchar(50) not null comment '元素类型'

,primary key (FPKID)

) comment = 'erpbom字段多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FNAME as "fname",FELEMENTTYPE as "felementtype" from T_PLM_CFG_ERPBOMFIELD_L

--查询(中文字段)--

select FPKID as "FPKID",FID as "FID",FLocaleID as "FLocaleID",FNAME as "名称",FELEMENTTYPE as "元素类型" from T_PLM_CFG_ERPBOMFIELD_L

--INSERT脚本--

insert into T_PLM_CFG_ERPBOMFIELD_L(FPKID,FID,FLocaleID,FNAME,FELEMENTTYPE) values (?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_ERPBOMFIELD_L set FPKID=?,FID=?,FLocaleID=?,FNAME=?,FELEMENTTYPE=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_ERPBOMFIELD_L where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_ERPBOMFIELD_L comment 'erpbom字段多语言';

alter table T_PLM_CFG_ERPBOMFIELD_L modify column FPKID bigint not null comment 'FPKID';

alter table T_PLM_CFG_ERPBOMFIELD_L modify column FID bigint not null comment 'FID';

alter table T_PLM_CFG_ERPBOMFIELD_L modify column FLocaleID int not null comment 'FLocaleID';

alter table T_PLM_CFG_ERPBOMFIELD_L modify column FNAME nvarchar(500) not null comment '名称';

alter table T_PLM_CFG_ERPBOMFIELD_L modify column FELEMENTTYPE nvarchar(50) not null comment '元素类型';

--建表脚本--

create table T_PLM_CFG_ERPMATFIELD_L(

FPKID bigint not null comment 'FPKID'

,FID bigint not null comment 'FID'

,FLocaleID int not null comment 'FLocaleID'

,FNAME nvarchar(500) not null comment '名称'

,FELEMENTTYPE nvarchar(50) not null comment '元素类型'

,primary key (FPKID)

) comment = 'erp物料字段多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FNAME as "fname",FELEMENTTYPE as "felementtype" from T_PLM_CFG_ERPMATFIELD_L

--查询(中文字段)--

select FPKID as "FPKID",FID as "FID",FLocaleID as "FLocaleID",FNAME as "名称",FELEMENTTYPE as "元素类型" from T_PLM_CFG_ERPMATFIELD_L

--INSERT脚本--

insert into T_PLM_CFG_ERPMATFIELD_L(FPKID,FID,FLocaleID,FNAME,FELEMENTTYPE) values (?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_ERPMATFIELD_L set FPKID=?,FID=?,FLocaleID=?,FNAME=?,FELEMENTTYPE=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_ERPMATFIELD_L where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_ERPMATFIELD_L comment 'erp物料字段多语言';

alter table T_PLM_CFG_ERPMATFIELD_L modify column FPKID bigint not null comment 'FPKID';

alter table T_PLM_CFG_ERPMATFIELD_L modify column FID bigint not null comment 'FID';

alter table T_PLM_CFG_ERPMATFIELD_L modify column FLocaleID int not null comment 'FLocaleID';

alter table T_PLM_CFG_ERPMATFIELD_L modify column FNAME nvarchar(500) not null comment '名称';

alter table T_PLM_CFG_ERPMATFIELD_L modify column FELEMENTTYPE nvarchar(50) not null comment '元素类型';

--建表脚本--

create table T_PLM_CFG_ERPTEMPLATE(

FCATEGORYID bigint not null comment '业务类型id'

,FOBJECTID bigint not null comment 'erp对象fid'

,FTEMPLATETYPE char(1) default '''' comment '操作类型'

,primary key (FCATEGORYID)

) comment = 'erp模板对象配置'

--查询--

select FCATEGORYID as "fcategoryid",FOBJECTID as "fobjectid",FTEMPLATETYPE as "ftemplatetype" from T_PLM_CFG_ERPTEMPLATE

--查询(中文字段)--

select FCATEGORYID as "业务类型id",FOBJECTID as "erp对象fid",FTEMPLATETYPE as "操作类型" from T_PLM_CFG_ERPTEMPLATE

--INSERT脚本--

insert into T_PLM_CFG_ERPTEMPLATE(FCATEGORYID,FOBJECTID,FTEMPLATETYPE) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_ERPTEMPLATE set FCATEGORYID=?,FOBJECTID=?,FTEMPLATETYPE=? where FCATEGORYID=?

--delete脚本--

delete from T_PLM_CFG_ERPTEMPLATE where FCATEGORYID=?

--给字段加备注--

alter table T_PLM_CFG_ERPTEMPLATE comment 'erp模板对象配置';

alter table T_PLM_CFG_ERPTEMPLATE modify column FCATEGORYID bigint not null comment '业务类型id';

alter table T_PLM_CFG_ERPTEMPLATE modify column FOBJECTID bigint not null comment 'erp对象fid';

alter table T_PLM_CFG_ERPTEMPLATE modify column FTEMPLATETYPE char(1) default '''' comment '操作类型';

--建表脚本--

create table T_PLM_CFG_FIELDGROUP(

FID bigint not null comment 'FID'

,FMasterID bigint not null comment 'FMasterID'

,FCODE nvarchar(50) not null comment '编码'

,FSN int not null comment '字段排序'

,primary key (FID)

) comment = '字段分组'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCODE as "fcode",FSN as "fsn" from T_PLM_CFG_FIELDGROUP

--查询(中文字段)--

select FID as "FID",FMasterID as "FMasterID",FCODE as "编码",FSN as "字段排序" from T_PLM_CFG_FIELDGROUP

--INSERT脚本--

insert into T_PLM_CFG_FIELDGROUP(FID,FMasterID,FCODE,FSN) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FIELDGROUP set FID=?,FMasterID=?,FCODE=?,FSN=? where FID=?

--delete脚本--

delete from T_PLM_CFG_FIELDGROUP where FID=?

--给字段加备注--

alter table T_PLM_CFG_FIELDGROUP comment '字段分组';

alter table T_PLM_CFG_FIELDGROUP modify column FID bigint not null comment 'FID';

alter table T_PLM_CFG_FIELDGROUP modify column FMasterID bigint not null comment 'FMasterID';

alter table T_PLM_CFG_FIELDGROUP modify column FCODE nvarchar(50) not null comment '编码';

alter table T_PLM_CFG_FIELDGROUP modify column FSN int not null comment '字段排序';

--建表脚本--

create table T_PLM_CFG_FIELDGROUPCFG(

FID bigint not null comment 'FID'

,FMasterID bigint not null comment 'FMasterID'

,FFIELDGROUP bigint not null comment '字段分组'

,FGROUPREADONLY char(1) not null comment '只读'

,FGROUPHIDE char(1) not null comment '隐藏'

,FGROUPREQUIRE char(1) not null comment '必填'

,FPROCESSID nvarchar(250) not null comment '流程实例'

,FNODEID nvarchar(250) not null comment '流程节点'

,primary key (FID)

) comment = '字段分组流程节点配置'

--查询--

select FID as "fid",FMasterID as "fmasterid",FFIELDGROUP as "ffieldgroup",FGROUPREADONLY as "fgroupreadonly",FGROUPHIDE as "fgrouphide",FGROUPREQUIRE as "fgrouprequire",FPROCESSID as "fprocessid",FNODEID as "fnodeid" from T_PLM_CFG_FIELDGROUPCFG

--查询(中文字段)--

select FID as "FID",FMasterID as "FMasterID",FFIELDGROUP as "字段分组",FGROUPREADONLY as "只读",FGROUPHIDE as "隐藏",FGROUPREQUIRE as "必填",FPROCESSID as "流程实例",FNODEID as "流程节点" from T_PLM_CFG_FIELDGROUPCFG

--INSERT脚本--

insert into T_PLM_CFG_FIELDGROUPCFG(FID,FMasterID,FFIELDGROUP,FGROUPREADONLY,FGROUPHIDE,FGROUPREQUIRE,FPROCESSID,FNODEID) values (?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FIELDGROUPCFG set FID=?,FMasterID=?,FFIELDGROUP=?,FGROUPREADONLY=?,FGROUPHIDE=?,FGROUPREQUIRE=?,FPROCESSID=?,FNODEID=? where FID=?

--delete脚本--

delete from T_PLM_CFG_FIELDGROUPCFG where FID=?

--给字段加备注--

alter table T_PLM_CFG_FIELDGROUPCFG comment '字段分组流程节点配置';

alter table T_PLM_CFG_FIELDGROUPCFG modify column FID bigint not null comment 'FID';

alter table T_PLM_CFG_FIELDGROUPCFG modify column FMasterID bigint not null comment 'FMasterID';

alter table T_PLM_CFG_FIELDGROUPCFG modify column FFIELDGROUP bigint not null comment '字段分组';

alter table T_PLM_CFG_FIELDGROUPCFG modify column FGROUPREADONLY char(1) not null comment '只读';

alter table T_PLM_CFG_FIELDGROUPCFG modify column FGROUPHIDE char(1) not null comment '隐藏';

alter table T_PLM_CFG_FIELDGROUPCFG modify column FGROUPREQUIRE char(1) not null comment '必填';

alter table T_PLM_CFG_FIELDGROUPCFG modify column FPROCESSID nvarchar(250) not null comment '流程实例';

alter table T_PLM_CFG_FIELDGROUPCFG modify column FNODEID nvarchar(250) not null comment '流程节点';

--建表脚本--

create table T_PLM_CFG_FIELDGROUP_L(

FPKID bigint not null comment 'FPKID'

,FID bigint not null comment 'FID'

,FLocaleID bigint not null comment 'FLocaleID'

,FNAME nvarchar(50) not null comment '名称'

,primary key (FPKID)

) comment = '字段分组多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FNAME as "fname" from T_PLM_CFG_FIELDGROUP_L

--查询(中文字段)--

select FPKID as "FPKID",FID as "FID",FLocaleID as "FLocaleID",FNAME as "名称" from T_PLM_CFG_FIELDGROUP_L

--INSERT脚本--

insert into T_PLM_CFG_FIELDGROUP_L(FPKID,FID,FLocaleID,FNAME) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FIELDGROUP_L set FPKID=?,FID=?,FLocaleID=?,FNAME=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_FIELDGROUP_L where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_FIELDGROUP_L comment '字段分组多语言';

alter table T_PLM_CFG_FIELDGROUP_L modify column FPKID bigint not null comment 'FPKID';

alter table T_PLM_CFG_FIELDGROUP_L modify column FID bigint not null comment 'FID';

alter table T_PLM_CFG_FIELDGROUP_L modify column FLocaleID bigint not null comment 'FLocaleID';

alter table T_PLM_CFG_FIELDGROUP_L modify column FNAME nvarchar(50) not null comment '名称';

--建表脚本--

create table T_PLM_CFG_FIELD_C(

FID bigint not null comment 'FID'

,FCONNECTOR nvarchar(50) not null comment '物料连接符'

,FINITDEFAULT nvarchar(50) not null comment '物料默认值'

,FBOMCONNECTOR nvarchar(50) not null comment 'bom连接符'

,FINITBOMDEFAULT nvarchar(50) not null comment 'bom默认值'

,FINITDEFAULTID nvarchar(50) default '' comment '物料默认值id'

,FINITBOMDEFAULTID nvarchar(50) default '' comment 'bom默认值id'

,primary key (FID)

) comment = '字段配置'

--查询--

select FID as "fid",FCONNECTOR as "fconnector",FINITDEFAULT as "finitdefault",FBOMCONNECTOR as "fbomconnector",FINITBOMDEFAULT as "finitbomdefault",FINITDEFAULTID as "finitdefaultid",FINITBOMDEFAULTID as "finitbomdefaultid" from T_PLM_CFG_FIELD_C

--查询(中文字段)--

select FID as "FID",FCONNECTOR as "物料连接符",FINITDEFAULT as "物料默认值",FBOMCONNECTOR as "bom连接符",FINITBOMDEFAULT as "bom默认值",FINITDEFAULTID as "物料默认值id",FINITBOMDEFAULTID as "bom默认值id" from T_PLM_CFG_FIELD_C

--INSERT脚本--

insert into T_PLM_CFG_FIELD_C(FID,FCONNECTOR,FINITDEFAULT,FBOMCONNECTOR,FINITBOMDEFAULT,FINITDEFAULTID,FINITBOMDEFAULTID) values (?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FIELD_C set FID=?,FCONNECTOR=?,FINITDEFAULT=?,FBOMCONNECTOR=?,FINITBOMDEFAULT=?,FINITDEFAULTID=?,FINITBOMDEFAULTID=? where FID=?

--delete脚本--

delete from T_PLM_CFG_FIELD_C where FID=?

--给字段加备注--

alter table T_PLM_CFG_FIELD_C comment '字段配置';

alter table T_PLM_CFG_FIELD_C modify column FID bigint not null comment 'FID';

alter table T_PLM_CFG_FIELD_C modify column FCONNECTOR nvarchar(50) not null comment '物料连接符';

alter table T_PLM_CFG_FIELD_C modify column FINITDEFAULT nvarchar(50) not null comment '物料默认值';

alter table T_PLM_CFG_FIELD_C modify column FBOMCONNECTOR nvarchar(50) not null comment 'bom连接符';