Kingdee-采购管理-T_PUR_CATALOGENTRY_LK-采购目录明细关联关系表

T_PUR_CATALOGENTRY_LK

表描述：采购目录明细关联关系表

表备注：采购目录明细关联关系表

--建表脚本--

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 '控制字段旧值';