Kingdee-采购管理-T_PUR_CATALOG-采购目录表

T_PUR_CATALOG

表描述：采购目录

表备注：Procurement Catalog

--建表脚本--

create table T_PUR_CATALOG(
    FID int default 0  comment '单据内码'
    ,FBILLNO nvarchar(30) default ''  comment '单据编号'
    ,FPURCHASEORGID int default 0  comment '采购组织'
    ,FUSEORGID int default 0  comment '使用组织'
    ,FNAME nvarchar(80) default ''  comment '名称'
    ,FDATE datetime default getdate()  comment '日期'
    ,FDESCRIPTION nvarchar(255) default ''  comment '描述'
    ,FSUPPLIERID int default 0  comment '供应商内码'
    ,FSUPPLYID int default 0  comment '供货方内码'
    ,FEFFECTIVEDATE datetime not null  comment '生效日期'
    ,FEXPIRYDATE datetime not null  comment '失效日期'
    ,FCATALOGOBJECT varchar(20) default ''''  comment '目录对象'
    ,FDOCUMENTSTATUS char(1) default ''''  comment '状态'
    ,FISUSE char(1) default ''0''  comment '启用'
    ,FFORBIDSTATUS char(1) default ''''  comment '禁用'
    ,FCREATORID int default 0  comment '创建人'
    ,FCREATEDATE datetime not null  comment '创建日期'
    ,FAPPROVERID int default 0  comment '审核人'
    ,FAPPROVEDATE datetime not null  comment '审核日期'
    ,FMODIFIERID int default 0  comment '修改人'
    ,FMODIFYDATE datetime not null  comment '修改日期'
    ,FFORBIDERID int default 0  comment '禁用人'
    ,FFORBIDDATE datetime not null  comment '禁用日期'
    ,FRECENTSTATISTICSDATE datetime not null  comment '最近统计日期'
    ,primary key (FID)
) comment = '采购目录'

--查询--

select FID as "fid",FBILLNO as "fbillno",FPURCHASEORGID as "fpurchaseorgid",FUSEORGID as "fuseorgid",FNAME as "fname",FDATE as "fdate",FDESCRIPTION as "fdescription",FSUPPLIERID as "fsupplierid",FSUPPLYID as "fsupplyid",FEFFECTIVEDATE as "feffectivedate",FEXPIRYDATE as "fexpirydate",FCATALOGOBJECT as "fcatalogobject",FDOCUMENTSTATUS as "fdocumentstatus",FISUSE as "fisuse",FFORBIDSTATUS as "fforbidstatus",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FAPPROVERID as "fapproverid",FAPPROVEDATE as "fapprovedate",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FFORBIDERID as "fforbiderid",FFORBIDDATE as "fforbiddate",FRECENTSTATISTICSDATE as "frecentstatisticsdate" from T_PUR_CATALOG

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

select FID as "单据内码",FBILLNO as "单据编号",FPURCHASEORGID as "采购组织",FUSEORGID as "使用组织",FNAME as "名称",FDATE as "日期",FDESCRIPTION as "描述",FSUPPLIERID as "供应商内码",FSUPPLYID as "供货方内码",FEFFECTIVEDATE as "生效日期",FEXPIRYDATE as "失效日期",FCATALOGOBJECT as "目录对象",FDOCUMENTSTATUS as "状态",FISUSE as "启用",FFORBIDSTATUS as "禁用",FCREATORID as "创建人",FCREATEDATE as "创建日期",FAPPROVERID as "审核人",FAPPROVEDATE as "审核日期",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FFORBIDERID as "禁用人",FFORBIDDATE as "禁用日期",FRECENTSTATISTICSDATE as "最近统计日期" from T_PUR_CATALOG

--INSERT脚本--

insert into T_PUR_CATALOG(FID,FBILLNO,FPURCHASEORGID,FUSEORGID,FNAME,FDATE,FDESCRIPTION,FSUPPLIERID,FSUPPLYID,FEFFECTIVEDATE,FEXPIRYDATE,FCATALOGOBJECT,FDOCUMENTSTATUS,FISUSE,FFORBIDSTATUS,FCREATORID,FCREATEDATE,FAPPROVERID,FAPPROVEDATE,FMODIFIERID,FMODIFYDATE,FFORBIDERID,FFORBIDDATE,FRECENTSTATISTICSDATE) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PUR_CATALOG set FID=?,FBILLNO=?,FPURCHASEORGID=?,FUSEORGID=?,FNAME=?,FDATE=?,FDESCRIPTION=?,FSUPPLIERID=?,FSUPPLYID=?,FEFFECTIVEDATE=?,FEXPIRYDATE=?,FCATALOGOBJECT=?,FDOCUMENTSTATUS=?,FISUSE=?,FFORBIDSTATUS=?,FCREATORID=?,FCREATEDATE=?,FAPPROVERID=?,FAPPROVEDATE=?,FMODIFIERID=?,FMODIFYDATE=?,FFORBIDERID=?,FFORBIDDATE=?,FRECENTSTATISTICSDATE=? where FID=?

--delete脚本--

delete from T_PUR_CATALOG where FID=?

--给字段加备注--

alter table T_PUR_CATALOG modify column FID int default 0  comment '单据内码';
alter table T_PUR_CATALOG modify column FBILLNO nvarchar(30) default ''  comment '单据编号';
alter table T_PUR_CATALOG modify column FPURCHASEORGID int default 0  comment '采购组织';
alter table T_PUR_CATALOG modify column FUSEORGID int default 0  comment '使用组织';
alter table T_PUR_CATALOG modify column FNAME nvarchar(80) default ''  comment '名称';
alter table T_PUR_CATALOG modify column FDATE datetime default getdate()  comment '日期';
alter table T_PUR_CATALOG modify column FDESCRIPTION nvarchar(255) default ''  comment '描述';
alter table T_PUR_CATALOG modify column FSUPPLIERID int default 0  comment '供应商内码';
alter table T_PUR_CATALOG modify column FSUPPLYID int default 0  comment '供货方内码';
alter table T_PUR_CATALOG modify column FEFFECTIVEDATE datetime not null  comment '生效日期';
alter table T_PUR_CATALOG modify column FEXPIRYDATE datetime not null  comment '失效日期';
alter table T_PUR_CATALOG modify column FCATALOGOBJECT varchar(20) default ''''  comment '目录对象';
alter table T_PUR_CATALOG modify column FDOCUMENTSTATUS char(1) default ''''  comment '状态';
alter table T_PUR_CATALOG modify column FISUSE char(1) default ''0''  comment '启用';
alter table T_PUR_CATALOG modify column FFORBIDSTATUS char(1) default ''''  comment '禁用';
alter table T_PUR_CATALOG modify column FCREATORID int default 0  comment '创建人';
alter table T_PUR_CATALOG modify column FCREATEDATE datetime not null  comment '创建日期';
alter table T_PUR_CATALOG modify column FAPPROVERID int default 0  comment '审核人';
alter table T_PUR_CATALOG modify column FAPPROVEDATE datetime not null  comment '审核日期';
alter table T_PUR_CATALOG modify column FMODIFIERID int default 0  comment '修改人';
alter table T_PUR_CATALOG modify column FMODIFYDATE datetime not null  comment '修改日期';
alter table T_PUR_CATALOG modify column FFORBIDERID int default 0  comment '禁用人';
alter table T_PUR_CATALOG modify column FFORBIDDATE datetime not null  comment '禁用日期';
alter table T_PUR_CATALOG modify column FRECENTSTATISTICSDATE datetime not null  comment '最近统计日期';