/
搜索到
50
篇与
的结果
-
Kingdee-采购管理-T_PUR_CATALOG_ISSUE-采购目录下发信息表 T_PUR_CATALOG_ISSUE表描述：采购目录下发信息表备注：存储价目表下发信息主键字段名字段描述数据类型长度可空备注✓FISSUEPKID主键varchar36 默认值:''null FID单据内码int ✓默认值:0null FISSUEORGID下发组织int ✓ FISSUEMAN下发人int ✓ FISSUEDATE下发日期datetime ✓ --建表脚本--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 '下发日期'; -
Kingdee-采购管理-T_PUR_CATALOGENTRY_R-采购目录_关联信息表 T_PUR_CATALOGENTRY_R表描述：采购目录_关联信息主键字段名字段描述数据类型长度可空备注✓FENTRYID分录内码int 默认值:0null FID单据内码int 默认值:0null FPAYCONDITION付款条件int 默认值:0null FSETTLETYPEID结算方式int 默认值:0null FMinBasePackagingQty最小装包数量基本单位decimal23,10 默认值:0.0null--建表脚本--create table T_PUR_CATALOGENTRY_R( FENTRYID int default 0 comment '分录内码' ,FID int default 0 comment '单据内码' ,FPAYCONDITION int default 0 comment '付款条件' ,FSETTLETYPEID int default 0 comment '结算方式' ,FMinBasePackagingQty decimal(23,10) default 0.0 comment '最小装包数量基本单位' ,primary key (FENTRYID) ) comment = '采购目录_关联信息'--查询--select FENTRYID as "fentryid",FID as "fid",FPAYCONDITION as "fpaycondition",FSETTLETYPEID as "fsettletypeid",FMinBasePackagingQty as "fminbasepackagingqty" from T_PUR_CATALOGENTRY_R--查询(中文字段)--select FENTRYID as "分录内码",FID as "单据内码",FPAYCONDITION as "付款条件",FSETTLETYPEID as "结算方式",FMinBasePackagingQty as "最小装包数量基本单位" from T_PUR_CATALOGENTRY_R--INSERT脚本--insert into T_PUR_CATALOGENTRY_R(FENTRYID,FID,FPAYCONDITION,FSETTLETYPEID,FMinBasePackagingQty) values (?,?,?,?,?)--UPDATE脚本--update T_PUR_CATALOGENTRY_R set FENTRYID=?,FID=?,FPAYCONDITION=?,FSETTLETYPEID=?,FMinBasePackagingQty=? where FENTRYID=?--delete脚本--delete from T_PUR_CATALOGENTRY_R where FENTRYID=?--给字段加备注--alter table T_PUR_CATALOGENTRY_R modify column FENTRYID int default 0 comment '分录内码'; alter table T_PUR_CATALOGENTRY_R modify column FID int default 0 comment '单据内码'; alter table T_PUR_CATALOGENTRY_R modify column FPAYCONDITION int default 0 comment '付款条件'; alter table T_PUR_CATALOGENTRY_R modify column FSETTLETYPEID int default 0 comment '结算方式'; alter table T_PUR_CATALOGENTRY_R modify column FMinBasePackagingQty decimal(23,10) default 0.0 comment '最小装包数量基本单位';
-
Kingdee-采购管理-T_PUR_CATALOGENTRY_LK-采购目录明细关联关系表 T_PUR_CATALOGENTRY_LK表描述：采购目录明细关联关系表表备注：采购目录明细关联关系表主键字段名字段描述数据类型长度可空备注✓FLINKID主键int 默认值:0null FENTRYID当前分录idint ✓默认值:0null FFLOWID流程图标识varchar36 默认值:' 'null FFLOWLINEID流程图路线标识int 默认值:0null FRULEID转换规则标识varchar36 默认值:' 'null FSTABLEID来源表idINT ✓ FSTABLENAME源单表名varchar30 默认值:' 'null FSBILLID源单单据内码INT ✓ FSID源单单据行内码int ✓ FBASEUNITQTY控制字段decimal23,10 默认值:0null FBASEUNITQTYOLD控制字段旧值decimal23,10 默认值:0null--建表脚本--create table T_PUR_CATALOGENTRY_LK( FLINKID int default 0 comment '主键' ,FENTRYID int not null comment '当前分录id' ,FFLOWID varchar(36) default '' '' comment '流程图标识' ,FFLOWLINEID int default 0 comment '流程图路线标识' ,FRULEID varchar(36) default '' '' comment '转换规则标识' ,FSTABLEID INT not null comment '来源表id' ,FSTABLENAME varchar(30) default '' '' comment '源单表名' ,FSBILLID INT not null comment '源单单据内码' ,FSID int not null comment '源单单据行内码' ,FBASEUNITQTY decimal(23,10) default 0 comment '控制字段' ,FBASEUNITQTYOLD decimal(23,10) default 0 comment '控制字段旧值' ,primary key (FLINKID) ) comment = '采购目录明细关联关系表'--查询--select FLINKID as "flinkid",FENTRYID as "fentryid",FFLOWID as "fflowid",FFLOWLINEID as "fflowlineid",FRULEID as "fruleid",FSTABLEID as "fstableid",FSTABLENAME as "fstablename",FSBILLID as "fsbillid",FSID as "fsid",FBASEUNITQTY as "fbaseunitqty",FBASEUNITQTYOLD as "fbaseunitqtyold" from T_PUR_CATALOGENTRY_LK--查询(中文字段)--select FLINKID as "主键",FENTRYID as "当前分录id",FFLOWID as "流程图标识",FFLOWLINEID as "流程图路线标识",FRULEID as "转换规则标识",FSTABLEID as "来源表id",FSTABLENAME as "源单表名",FSBILLID as "源单单据内码",FSID as "源单单据行内码",FBASEUNITQTY as "控制字段",FBASEUNITQTYOLD as "控制字段旧值" from T_PUR_CATALOGENTRY_LK--INSERT脚本--insert into T_PUR_CATALOGENTRY_LK(FLINKID,FENTRYID,FFLOWID,FFLOWLINEID,FRULEID,FSTABLEID,FSTABLENAME,FSBILLID,FSID,FBASEUNITQTY,FBASEUNITQTYOLD) values (?,?,?,?,?,?,?,?,?,?,?)--UPDATE脚本--update T_PUR_CATALOGENTRY_LK set FLINKID=?,FENTRYID=?,FFLOWID=?,FFLOWLINEID=?,FRULEID=?,FSTABLEID=?,FSTABLENAME=?,FSBILLID=?,FSID=?,FBASEUNITQTY=?,FBASEUNITQTYOLD=? where FLINKID=?--delete脚本--delete from T_PUR_CATALOGENTRY_LK where FLINKID=?--给字段加备注--alter table T_PUR_CATALOGENTRY_LK modify column FLINKID int default 0 comment '主键'; alter table T_PUR_CATALOGENTRY_LK modify column FENTRYID int not null comment '当前分录id'; alter table T_PUR_CATALOGENTRY_LK modify column FFLOWID varchar(36) default '' '' comment '流程图标识'; alter table T_PUR_CATALOGENTRY_LK modify column FFLOWLINEID int default 0 comment '流程图路线标识'; alter table T_PUR_CATALOGENTRY_LK modify column FRULEID varchar(36) default '' '' comment '转换规则标识'; alter table T_PUR_CATALOGENTRY_LK modify column FSTABLEID INT not null comment '来源表id'; alter table T_PUR_CATALOGENTRY_LK modify column FSTABLENAME varchar(30) default '' '' comment '源单表名'; alter table T_PUR_CATALOGENTRY_LK modify column FSBILLID INT not null comment '源单单据内码'; alter table T_PUR_CATALOGENTRY_LK modify column FSID int not null comment '源单单据行内码'; alter table T_PUR_CATALOGENTRY_LK modify column FBASEUNITQTY decimal(23,10) default 0 comment '控制字段'; alter table T_PUR_CATALOGENTRY_LK modify column FBASEUNITQTYOLD decimal(23,10) default 0 comment '控制字段旧值';
-
Kingdee-采购管理-T_PUR_CATALOGENTRY-采购目录明细表 T_PUR_CATALOGENTRY表描述：采购目录明细主键字段名字段描述数据类型长度可空备注✓FENTRYID分录内码int 默认值:0null FID单据内码int 默认值:0null FSEQ行号int 默认值:0null FMATERIALID物料内码int 默认值:0null FUNITID单位int 默认值:0null FSUPMATID供应商对应物料代码nvarchar30 默认值:''null FSUPMATNAME供应商对应物料名称nvarchar30 默认值:''null FAUXPROPID辅助属性内码int 默认值:0null FEFFECTIVEDATE生效日期datetime ✓ FEXPIRYDATE失效日期datetime ✓ FFORBIDSTATUS禁用char1 默认值:''null FFORBIDERID禁用人int 默认值:0null FFORBIDDATE禁用日期datetime ✓ FDELIVERYMAXQTY交货上限decimal23,10 默认值:0.0null FDELIVERYMINQTY交货下限decimal23,10 默认值:0.0null FPlanDeliveryCycle计划交货周期decimal23,10 默认值:0null FORDERNUM订货次数decimal23,10 默认值:0null FTRYBATCHNUM试用批量decimal23,10 默认值:0null FMINORDERQTY最小订货数量decimal23,10 默认值:0.0null FMAXORDERQTY最大订货数量decimal23,10 默认值:0null FTAXRATE税率decimal19,6 默认值:0null FPLACEORIGINID原产地varchar36 默认值:''null FCERTORIGINAL原产地证书号nvarchar30 默认值:''null FCERTEFFECTIVEDATE证书生效日期datetime ✓ FCERTEXPIRYDATE证书失效日期datetime ✓ FMANUFACTURERID制造商int 默认值:0null FRISKRATING危险等级nvarchar30 默认值:''null FDANGGOODSID危险品标识号nvarchar30 默认值:''null FDANGGOODSLABEL危险品标签nvarchar30 默认值:''null FSRCBILLNO源单编号nvarchar30 默认值:''null FMATERIALTYPE物料类别int 默认值:0null FPRIMARYSUPPRO固定供应商char1 默认值:'0'null FETYSUPPLIERID供应商int 默认值:0null FSUPPLYSTATUS供货状态nvarchar20 默认值:''null FSUPPLYTYPE供货方式nvarchar20 默认值:''null FQUOTASTRATEGY配额策略nvarchar20 默认值:''null FQUOTARATIO配额比例%decimal19,6 默认值:0null FQUOTAORDER配额顺序int 默认值:0null FMINPACKAGINGQTY最小包装数量decimal23,10 默认值:0.0null FALLORDERQTY累计订货量decimal23,10 默认值:0.0null FALLORDERAMOUNT累计订货金额decimal23,10 默认值:0null FALLORDERNUM累计订货次数int 默认值:0null FFIRSTORDERDATE首次订货日期datetime ✓ FRECENTORDERDATE最近订货日期datetime ✓ FRECENTORDERNO最近订单编号nvarchar30 默认值:''null FBASEUNITID基本单位int 默认值:0null FMAXBASEORDERQTY最大订货数量基本单位decimal23,10 默认值:0null FMINBASEORDERQTY最小订货数量基本单位decimal23,10 默认值:0null FALLBASEORDERQTY累计订货量基本单位decimal23,10 默认值:0null--建表脚本--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 '累计订货量基本单位';
-
Kingdee-采购管理-T_PUR_CATALOG-采购目录表 T_PUR_CATALOG表描述：采购目录表备注：Procurement Catalog主键字段名字段描述数据类型长度可空备注✓FID单据内码int 默认值:0null FBILLNO单据编号nvarchar30 默认值:''null FPURCHASEORGID采购组织int 默认值:0null FUSEORGID使用组织int 默认值:0null FNAME名称nvarchar80 默认值:''null FDATE日期datetime 默认值:getdate()null FDESCRIPTION描述nvarchar255 默认值:''null FSUPPLIERID供应商内码int 默认值:0null FSUPPLYID供货方内码int 默认值:0null FEFFECTIVEDATE生效日期datetime ✓ FEXPIRYDATE失效日期datetime ✓ FCATALOGOBJECT目录对象varchar20 默认值:''枚举:物料: 物料类别: 默认为物料； FDOCUMENTSTATUS状态char1 默认值:''null FISUSE启用char1 默认值:'0'null FFORBIDSTATUS禁用char1 默认值:''null FCREATORID创建人int 默认值:0null FCREATEDATE创建日期datetime ✓ FAPPROVERID审核人int 默认值:0null FAPPROVEDATE审核日期datetime ✓ FMODIFIERID修改人int 默认值:0null FMODIFYDATE修改日期datetime ✓ FFORBIDERID禁用人int 默认值:0null FFORBIDDATE禁用日期datetime ✓ FRECENTSTATISTICSDATE最近统计日期datetime ✓ --建表脚本--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 '最近统计日期';
