Kingdee-采购管理-T_PUR_CATALOGENTRY_R-采购目录_关联信息表

T_PUR_CATALOGENTRY_R

表描述：采购目录_关联信息

--建表脚本--

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 '最小装包数量基本单位';