Kingdee-采购管理-T_PUR_CATALOG_ISSUE-采购目录下发信息表

T_PUR_CATALOG_ISSUE

表描述：采购目录下发信息

表备注：存储价目表下发信息

--建表脚本--

create table T_PUR_CATALOG_ISSUE(
    FISSUEPKID varchar(36) default ''''  comment '主键'
    ,FID int not null  comment '单据内码'
    ,FISSUEORGID int not null  comment '下发组织'
    ,FISSUEMAN int not null  comment '下发人'
    ,FISSUEDATE datetime not null  comment '下发日期'
    ,primary key (FISSUEPKID)
) comment = '采购目录下发信息'

--查询--

select FISSUEPKID as "fissuepkid",FID as "fid",FISSUEORGID as "fissueorgid",FISSUEMAN as "fissueman",FISSUEDATE as "fissuedate" from T_PUR_CATALOG_ISSUE

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

select FISSUEPKID as "主键",FID as "单据内码",FISSUEORGID as "下发组织",FISSUEMAN as "下发人",FISSUEDATE as "下发日期" from T_PUR_CATALOG_ISSUE

--INSERT脚本--

insert into T_PUR_CATALOG_ISSUE(FISSUEPKID,FID,FISSUEORGID,FISSUEMAN,FISSUEDATE) values (?,?,?,?,?)

--UPDATE脚本--

update T_PUR_CATALOG_ISSUE set FISSUEPKID=?,FID=?,FISSUEORGID=?,FISSUEMAN=?,FISSUEDATE=? where FISSUEPKID=?

--delete脚本--

delete from T_PUR_CATALOG_ISSUE where FISSUEPKID=?

--给字段加备注--

alter table T_PUR_CATALOG_ISSUE modify column FISSUEPKID varchar(36) default ''''  comment '主键';
alter table T_PUR_CATALOG_ISSUE modify column FID int not null  comment '单据内码';
alter table T_PUR_CATALOG_ISSUE modify column FISSUEORGID int not null  comment '下发组织';
alter table T_PUR_CATALOG_ISSUE modify column FISSUEMAN int not null  comment '下发人';
alter table T_PUR_CATALOG_ISSUE modify column FISSUEDATE datetime not null  comment '下发日期';