Kingdee-采购管理-T_PUR_CATALOGENTRY-采购目录明细表

T_PUR_CATALOGENTRY

表描述：采购目录明细

--建表脚本--

create table T_PUR_CATALOGENTRY(
    FENTRYID int default 0  comment '分录内码'
    ,FID int default 0  comment '单据内码'
    ,FSEQ int default 0  comment '行号'
    ,FMATERIALID int default 0  comment '物料内码'
    ,FUNITID int default 0  comment '单位'
    ,FSUPMATID nvarchar(30) default ''  comment '供应商对应物料代码'
    ,FSUPMATNAME nvarchar(30) default ''  comment '供应商对应物料名称'
    ,FAUXPROPID int default 0  comment '辅助属性内码'
    ,FEFFECTIVEDATE datetime not null  comment '生效日期'
    ,FEXPIRYDATE datetime not null  comment '失效日期'
    ,FFORBIDSTATUS char(1) default ''''  comment '禁用'
    ,FFORBIDERID int default 0  comment '禁用人'
    ,FFORBIDDATE datetime not null  comment '禁用日期'
    ,FDELIVERYMAXQTY decimal(23,10) default 0.0  comment '交货上限'
    ,FDELIVERYMINQTY decimal(23,10) default 0.0  comment '交货下限'
    ,FPlanDeliveryCycle decimal(23,10) default 0  comment '计划交货周期'
    ,FORDERNUM decimal(23,10) default 0  comment '订货次数'
    ,FTRYBATCHNUM decimal(23,10) default 0  comment '试用批量'
    ,FMINORDERQTY decimal(23,10) default 0.0  comment '最小订货数量'
    ,FMAXORDERQTY decimal(23,10) default 0  comment '最大订货数量'
    ,FTAXRATE decimal(19,6) default 0  comment '税率'
    ,FPLACEORIGINID varchar(36) default ''''  comment '原产地'
    ,FCERTORIGINAL nvarchar(30) default ''  comment '原产地证书号'
    ,FCERTEFFECTIVEDATE datetime not null  comment '证书生效日期'
    ,FCERTEXPIRYDATE datetime not null  comment '证书失效日期'
    ,FMANUFACTURERID int default 0  comment '制造商'
    ,FRISKRATING nvarchar(30) default ''  comment '危险等级'
    ,FDANGGOODSID nvarchar(30) default ''  comment '危险品标识号'
    ,FDANGGOODSLABEL nvarchar(30) default ''  comment '危险品标签'
    ,FSRCBILLNO nvarchar(30) default ''  comment '源单编号'
    ,FMATERIALTYPE int default 0  comment '物料类别'
    ,FPRIMARYSUPPRO char(1) default ''0''  comment '固定供应商'
    ,FETYSUPPLIERID int default 0  comment '供应商'
    ,FSUPPLYSTATUS nvarchar(20) default ''  comment '供货状态'
    ,FSUPPLYTYPE nvarchar(20) default ''  comment '供货方式'
    ,FQUOTASTRATEGY nvarchar(20) default ''  comment '配额策略'
    ,FQUOTARATIO decimal(19,6) default 0  comment '配额比例%'
    ,FQUOTAORDER int default 0  comment '配额顺序'
    ,FMINPACKAGINGQTY decimal(23,10) default 0.0  comment '最小包装数量'
    ,FALLORDERQTY decimal(23,10) default 0.0  comment '累计订货量'
    ,FALLORDERAMOUNT decimal(23,10) default 0  comment '累计订货金额'
    ,FALLORDERNUM int default 0  comment '累计订货次数'
    ,FFIRSTORDERDATE datetime not null  comment '首次订货日期'
    ,FRECENTORDERDATE datetime not null  comment '最近订货日期'
    ,FRECENTORDERNO nvarchar(30) default ''  comment '最近订单编号'
    ,FBASEUNITID int default 0  comment '基本单位'
    ,FMAXBASEORDERQTY decimal(23,10) default 0  comment '最大订货数量基本单位'
    ,FMINBASEORDERQTY decimal(23,10) default 0  comment '最小订货数量基本单位'
    ,FALLBASEORDERQTY decimal(23,10) default 0  comment '累计订货量基本单位'
    ,primary key (FENTRYID)
) comment = '采购目录明细'

--查询--

select FENTRYID as "fentryid",FID as "fid",FSEQ as "fseq",FMATERIALID as "fmaterialid",FUNITID as "funitid",FSUPMATID as "fsupmatid",FSUPMATNAME as "fsupmatname",FAUXPROPID as "fauxpropid",FEFFECTIVEDATE as "feffectivedate",FEXPIRYDATE as "fexpirydate",FFORBIDSTATUS as "fforbidstatus",FFORBIDERID as "fforbiderid",FFORBIDDATE as "fforbiddate",FDELIVERYMAXQTY as "fdeliverymaxqty",FDELIVERYMINQTY as "fdeliveryminqty",FPlanDeliveryCycle as "fplandeliverycycle",FORDERNUM as "fordernum",FTRYBATCHNUM as "ftrybatchnum",FMINORDERQTY as "fminorderqty",FMAXORDERQTY as "fmaxorderqty",FTAXRATE as "ftaxrate",FPLACEORIGINID as "fplaceoriginid",FCERTORIGINAL as "fcertoriginal",FCERTEFFECTIVEDATE as "fcerteffectivedate",FCERTEXPIRYDATE as "fcertexpirydate",FMANUFACTURERID as "fmanufacturerid",FRISKRATING as "friskrating",FDANGGOODSID as "fdanggoodsid",FDANGGOODSLABEL as "fdanggoodslabel",FSRCBILLNO as "fsrcbillno",FMATERIALTYPE as "fmaterialtype",FPRIMARYSUPPRO as "fprimarysuppro",FETYSUPPLIERID as "fetysupplierid",FSUPPLYSTATUS as "fsupplystatus",FSUPPLYTYPE as "fsupplytype",FQUOTASTRATEGY as "fquotastrategy",FQUOTARATIO as "fquotaratio",FQUOTAORDER as "fquotaorder",FMINPACKAGINGQTY as "fminpackagingqty",FALLORDERQTY as "fallorderqty",FALLORDERAMOUNT as "fallorderamount",FALLORDERNUM as "fallordernum",FFIRSTORDERDATE as "ffirstorderdate",FRECENTORDERDATE as "frecentorderdate",FRECENTORDERNO as "frecentorderno",FBASEUNITID as "fbaseunitid",FMAXBASEORDERQTY as "fmaxbaseorderqty",FMINBASEORDERQTY as "fminbaseorderqty",FALLBASEORDERQTY as "fallbaseorderqty" from T_PUR_CATALOGENTRY

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

select FENTRYID as "分录内码",FID as "单据内码",FSEQ as "行号",FMATERIALID as "物料内码",FUNITID as "单位",FSUPMATID as "供应商对应物料代码",FSUPMATNAME as "供应商对应物料名称",FAUXPROPID as "辅助属性内码",FEFFECTIVEDATE as "生效日期",FEXPIRYDATE as "失效日期",FFORBIDSTATUS as "禁用",FFORBIDERID as "禁用人",FFORBIDDATE as "禁用日期",FDELIVERYMAXQTY as "交货上限",FDELIVERYMINQTY as "交货下限",FPlanDeliveryCycle as "计划交货周期",FORDERNUM as "订货次数",FTRYBATCHNUM as "试用批量",FMINORDERQTY as "最小订货数量",FMAXORDERQTY as "最大订货数量",FTAXRATE as "税率",FPLACEORIGINID as "原产地",FCERTORIGINAL as "原产地证书号",FCERTEFFECTIVEDATE as "证书生效日期",FCERTEXPIRYDATE as "证书失效日期",FMANUFACTURERID as "制造商",FRISKRATING as "危险等级",FDANGGOODSID as "危险品标识号",FDANGGOODSLABEL as "危险品标签",FSRCBILLNO as "源单编号",FMATERIALTYPE as "物料类别",FPRIMARYSUPPRO as "固定供应商",FETYSUPPLIERID as "供应商",FSUPPLYSTATUS as "供货状态",FSUPPLYTYPE as "供货方式",FQUOTASTRATEGY as "配额策略",FQUOTARATIO as "配额比例%",FQUOTAORDER as "配额顺序",FMINPACKAGINGQTY as "最小包装数量",FALLORDERQTY as "累计订货量",FALLORDERAMOUNT as "累计订货金额",FALLORDERNUM as "累计订货次数",FFIRSTORDERDATE as "首次订货日期",FRECENTORDERDATE as "最近订货日期",FRECENTORDERNO as "最近订单编号",FBASEUNITID as "基本单位",FMAXBASEORDERQTY as "最大订货数量基本单位",FMINBASEORDERQTY as "最小订货数量基本单位",FALLBASEORDERQTY as "累计订货量基本单位" from T_PUR_CATALOGENTRY

--INSERT脚本--

insert into T_PUR_CATALOGENTRY(FENTRYID,FID,FSEQ,FMATERIALID,FUNITID,FSUPMATID,FSUPMATNAME,FAUXPROPID,FEFFECTIVEDATE,FEXPIRYDATE,FFORBIDSTATUS,FFORBIDERID,FFORBIDDATE,FDELIVERYMAXQTY,FDELIVERYMINQTY,FPlanDeliveryCycle,FORDERNUM,FTRYBATCHNUM,FMINORDERQTY,FMAXORDERQTY,FTAXRATE,FPLACEORIGINID,FCERTORIGINAL,FCERTEFFECTIVEDATE,FCERTEXPIRYDATE,FMANUFACTURERID,FRISKRATING,FDANGGOODSID,FDANGGOODSLABEL,FSRCBILLNO,FMATERIALTYPE,FPRIMARYSUPPRO,FETYSUPPLIERID,FSUPPLYSTATUS,FSUPPLYTYPE,FQUOTASTRATEGY,FQUOTARATIO,FQUOTAORDER,FMINPACKAGINGQTY,FALLORDERQTY,FALLORDERAMOUNT,FALLORDERNUM,FFIRSTORDERDATE,FRECENTORDERDATE,FRECENTORDERNO,FBASEUNITID,FMAXBASEORDERQTY,FMINBASEORDERQTY,FALLBASEORDERQTY) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PUR_CATALOGENTRY set FENTRYID=?,FID=?,FSEQ=?,FMATERIALID=?,FUNITID=?,FSUPMATID=?,FSUPMATNAME=?,FAUXPROPID=?,FEFFECTIVEDATE=?,FEXPIRYDATE=?,FFORBIDSTATUS=?,FFORBIDERID=?,FFORBIDDATE=?,FDELIVERYMAXQTY=?,FDELIVERYMINQTY=?,FPlanDeliveryCycle=?,FORDERNUM=?,FTRYBATCHNUM=?,FMINORDERQTY=?,FMAXORDERQTY=?,FTAXRATE=?,FPLACEORIGINID=?,FCERTORIGINAL=?,FCERTEFFECTIVEDATE=?,FCERTEXPIRYDATE=?,FMANUFACTURERID=?,FRISKRATING=?,FDANGGOODSID=?,FDANGGOODSLABEL=?,FSRCBILLNO=?,FMATERIALTYPE=?,FPRIMARYSUPPRO=?,FETYSUPPLIERID=?,FSUPPLYSTATUS=?,FSUPPLYTYPE=?,FQUOTASTRATEGY=?,FQUOTARATIO=?,FQUOTAORDER=?,FMINPACKAGINGQTY=?,FALLORDERQTY=?,FALLORDERAMOUNT=?,FALLORDERNUM=?,FFIRSTORDERDATE=?,FRECENTORDERDATE=?,FRECENTORDERNO=?,FBASEUNITID=?,FMAXBASEORDERQTY=?,FMINBASEORDERQTY=?,FALLBASEORDERQTY=? where FENTRYID=?

--delete脚本--

delete from T_PUR_CATALOGENTRY where FENTRYID=?

--给字段加备注--

alter table T_PUR_CATALOGENTRY modify column FENTRYID int default 0  comment '分录内码';
alter table T_PUR_CATALOGENTRY modify column FID int default 0  comment '单据内码';
alter table T_PUR_CATALOGENTRY modify column FSEQ int default 0  comment '行号';
alter table T_PUR_CATALOGENTRY modify column FMATERIALID int default 0  comment '物料内码';
alter table T_PUR_CATALOGENTRY modify column FUNITID int default 0  comment '单位';
alter table T_PUR_CATALOGENTRY modify column FSUPMATID nvarchar(30) default ''  comment '供应商对应物料代码';
alter table T_PUR_CATALOGENTRY modify column FSUPMATNAME nvarchar(30) default ''  comment '供应商对应物料名称';
alter table T_PUR_CATALOGENTRY modify column FAUXPROPID int default 0  comment '辅助属性内码';
alter table T_PUR_CATALOGENTRY modify column FEFFECTIVEDATE datetime not null  comment '生效日期';
alter table T_PUR_CATALOGENTRY modify column FEXPIRYDATE datetime not null  comment '失效日期';
alter table T_PUR_CATALOGENTRY modify column FFORBIDSTATUS char(1) default ''''  comment '禁用';
alter table T_PUR_CATALOGENTRY modify column FFORBIDERID int default 0  comment '禁用人';
alter table T_PUR_CATALOGENTRY modify column FFORBIDDATE datetime not null  comment '禁用日期';
alter table T_PUR_CATALOGENTRY modify column FDELIVERYMAXQTY decimal(23,10) default 0.0  comment '交货上限';
alter table T_PUR_CATALOGENTRY modify column FDELIVERYMINQTY decimal(23,10) default 0.0  comment '交货下限';
alter table T_PUR_CATALOGENTRY modify column FPlanDeliveryCycle decimal(23,10) default 0  comment '计划交货周期';
alter table T_PUR_CATALOGENTRY modify column FORDERNUM decimal(23,10) default 0  comment '订货次数';
alter table T_PUR_CATALOGENTRY modify column FTRYBATCHNUM decimal(23,10) default 0  comment '试用批量';
alter table T_PUR_CATALOGENTRY modify column FMINORDERQTY decimal(23,10) default 0.0  comment '最小订货数量';
alter table T_PUR_CATALOGENTRY modify column FMAXORDERQTY decimal(23,10) default 0  comment '最大订货数量';
alter table T_PUR_CATALOGENTRY modify column FTAXRATE decimal(19,6) default 0  comment '税率';
alter table T_PUR_CATALOGENTRY modify column FPLACEORIGINID varchar(36) default ''''  comment '原产地';
alter table T_PUR_CATALOGENTRY modify column FCERTORIGINAL nvarchar(30) default ''  comment '原产地证书号';
alter table T_PUR_CATALOGENTRY modify column FCERTEFFECTIVEDATE datetime not null  comment '证书生效日期';
alter table T_PUR_CATALOGENTRY modify column FCERTEXPIRYDATE datetime not null  comment '证书失效日期';
alter table T_PUR_CATALOGENTRY modify column FMANUFACTURERID int default 0  comment '制造商';
alter table T_PUR_CATALOGENTRY modify column FRISKRATING nvarchar(30) default ''  comment '危险等级';
alter table T_PUR_CATALOGENTRY modify column FDANGGOODSID nvarchar(30) default ''  comment '危险品标识号';
alter table T_PUR_CATALOGENTRY modify column FDANGGOODSLABEL nvarchar(30) default ''  comment '危险品标签';
alter table T_PUR_CATALOGENTRY modify column FSRCBILLNO nvarchar(30) default ''  comment '源单编号';
alter table T_PUR_CATALOGENTRY modify column FMATERIALTYPE int default 0  comment '物料类别';
alter table T_PUR_CATALOGENTRY modify column FPRIMARYSUPPRO char(1) default ''0''  comment '固定供应商';
alter table T_PUR_CATALOGENTRY modify column FETYSUPPLIERID int default 0  comment '供应商';
alter table T_PUR_CATALOGENTRY modify column FSUPPLYSTATUS nvarchar(20) default ''  comment '供货状态';
alter table T_PUR_CATALOGENTRY modify column FSUPPLYTYPE nvarchar(20) default ''  comment '供货方式';
alter table T_PUR_CATALOGENTRY modify column FQUOTASTRATEGY nvarchar(20) default ''  comment '配额策略';
alter table T_PUR_CATALOGENTRY modify column FQUOTARATIO decimal(19,6) default 0  comment '配额比例%';
alter table T_PUR_CATALOGENTRY modify column FQUOTAORDER int default 0  comment '配额顺序';
alter table T_PUR_CATALOGENTRY modify column FMINPACKAGINGQTY decimal(23,10) default 0.0  comment '最小包装数量';
alter table T_PUR_CATALOGENTRY modify column FALLORDERQTY decimal(23,10) default 0.0  comment '累计订货量';
alter table T_PUR_CATALOGENTRY modify column FALLORDERAMOUNT decimal(23,10) default 0  comment '累计订货金额';
alter table T_PUR_CATALOGENTRY modify column FALLORDERNUM int default 0  comment '累计订货次数';
alter table T_PUR_CATALOGENTRY modify column FFIRSTORDERDATE datetime not null  comment '首次订货日期';
alter table T_PUR_CATALOGENTRY modify column FRECENTORDERDATE datetime not null  comment '最近订货日期';
alter table T_PUR_CATALOGENTRY modify column FRECENTORDERNO nvarchar(30) default ''  comment '最近订单编号';
alter table T_PUR_CATALOGENTRY modify column FBASEUNITID int default 0  comment '基本单位';
alter table T_PUR_CATALOGENTRY modify column FMAXBASEORDERQTY decimal(23,10) default 0  comment '最大订货数量基本单位';
alter table T_PUR_CATALOGENTRY modify column FMINBASEORDERQTY decimal(23,10) default 0  comment '最小订货数量基本单位';
alter table T_PUR_CATALOGENTRY modify column FALLBASEORDERQTY decimal(23,10) default 0  comment '累计订货量基本单位';