Kingdee-采购管理-T_PUR_MRAPP-退料申请表

T_PUR_MRAPP

表描述：退料申请

表备注：退料申请信息

--建表脚本--

create table T_PUR_MRAPP(
    FID int default 0  comment '单据内码'
    ,FBILLNO nvarchar(30) default ''  comment '单据编号'
    ,FDATE datetime default getdate()  comment '日期'
    ,FBILLTYPEID varchar(36) default ''''  comment '单据类型'
    ,FSUPPLIERID int default 0  comment '供应商内码'
    ,FRMTYPE varchar(20) not null  comment '退货类型'
    ,FPURCHASEORGID int default 0  comment '采购组织'
    ,FAPPORGID int default 0  comment '申请组织'
    ,FAPPDEPTID int default 0  comment '申请部门'
    ,FAPPLICANTID int default 0  comment '申请人'
    ,FRMMODE varchar(20) default ''''  comment '退货方式'
    ,FREPLENISHMODE varchar(20) default ''''  comment '补货方式'
    ,FRMREASON varchar(36) default ''''  comment '退货原因'
    ,FRMLOC nvarchar(120) default ''  comment '退货地点'
    ,FDOCUMENTSTATUS char(1) default ''''  comment '单据状态'
    ,FDESCRIPTION nvarchar(255) default ''  comment '描述'
    ,FCREATORID int default 0  comment '制单人'
    ,FCREATEDATE datetime default getdate()  comment '制单日期'
    ,FMODIFIERID int default 0  comment '最近修改人内码'
    ,FMODIFYDATE datetime not null  comment '最新修改日期'
    ,FAPPROVERID int default 0  comment '审核人内码'
    ,FAPPROVEDATE datetime not null  comment '审核日期'
    ,FCANCELSTATUS char(1) default ''''  comment '作废状态'
    ,FCANCELLERID int default 0  comment '作废人内码'
    ,FCANCELDATE datetime not null  comment '作废日期'
    ,FIsConvert char(1) default ''0''  comment '是否是单据转换'
    ,FBUSINESSTYPE nvarchar(20) default ''  comment '业务类型'
    ,FOBJECTTYPEID varchar(36) default ''''  comment '业务对象类型'
    ,FREQUIREORGID int default 0  comment '需求组织携带'
    ,FCorrespondOrgId int not null  comment '对应组织'
    ,FCONFIRMSTATUS char(1) default ''''  comment '确认状态'
    ,FCONFIRMERID int default 0  comment '确认人'
    ,FCONFIRMDATE datetime not null  comment '确认日期'
    ,FBILLTYPEIDVM varchar(36) default ''''  comment '协同虚拟单据类型'
    ,FCLOSERID int default 0  comment '关闭人'
    ,FCLOSEDATE datetime not null  comment '关闭日期'
    ,FCLOSESTATUS char(1) default ''''  comment '关闭状态'
    ,primary key (FID)
) comment = '退料申请'

--查询--

select FID as "fid",FBILLNO as "fbillno",FDATE as "fdate",FBILLTYPEID as "fbilltypeid",FSUPPLIERID as "fsupplierid",FRMTYPE as "frmtype",FPURCHASEORGID as "fpurchaseorgid",FAPPORGID as "fapporgid",FAPPDEPTID as "fappdeptid",FAPPLICANTID as "fapplicantid",FRMMODE as "frmmode",FREPLENISHMODE as "freplenishmode",FRMREASON as "frmreason",FRMLOC as "frmloc",FDOCUMENTSTATUS as "fdocumentstatus",FDESCRIPTION as "fdescription",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FAPPROVERID as "fapproverid",FAPPROVEDATE as "fapprovedate",FCANCELSTATUS as "fcancelstatus",FCANCELLERID as "fcancellerid",FCANCELDATE as "fcanceldate",FIsConvert as "fisconvert",FBUSINESSTYPE as "fbusinesstype",FOBJECTTYPEID as "fobjecttypeid",FREQUIREORGID as "frequireorgid",FCorrespondOrgId as "fcorrespondorgid",FCONFIRMSTATUS as "fconfirmstatus",FCONFIRMERID as "fconfirmerid",FCONFIRMDATE as "fconfirmdate",FBILLTYPEIDVM as "fbilltypeidvm",FCLOSERID as "fcloserid",FCLOSEDATE as "fclosedate",FCLOSESTATUS as "fclosestatus" from T_PUR_MRAPP

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

select FID as "单据内码",FBILLNO as "单据编号",FDATE as "日期",FBILLTYPEID as "单据类型",FSUPPLIERID as "供应商内码",FRMTYPE as "退货类型",FPURCHASEORGID as "采购组织",FAPPORGID as "申请组织",FAPPDEPTID as "申请部门",FAPPLICANTID as "申请人",FRMMODE as "退货方式",FREPLENISHMODE as "补货方式",FRMREASON as "退货原因",FRMLOC as "退货地点",FDOCUMENTSTATUS as "单据状态",FDESCRIPTION as "描述",FCREATORID as "制单人",FCREATEDATE as "制单日期",FMODIFIERID as "最近修改人内码",FMODIFYDATE as "最新修改日期",FAPPROVERID as "审核人内码",FAPPROVEDATE as "审核日期",FCANCELSTATUS as "作废状态",FCANCELLERID as "作废人内码",FCANCELDATE as "作废日期",FIsConvert as "是否是单据转换",FBUSINESSTYPE as "业务类型",FOBJECTTYPEID as "业务对象类型",FREQUIREORGID as "需求组织携带",FCorrespondOrgId as "对应组织",FCONFIRMSTATUS as "确认状态",FCONFIRMERID as "确认人",FCONFIRMDATE as "确认日期",FBILLTYPEIDVM as "协同虚拟单据类型",FCLOSERID as "关闭人",FCLOSEDATE as "关闭日期",FCLOSESTATUS as "关闭状态" from T_PUR_MRAPP

--INSERT脚本--

insert into T_PUR_MRAPP(FID,FBILLNO,FDATE,FBILLTYPEID,FSUPPLIERID,FRMTYPE,FPURCHASEORGID,FAPPORGID,FAPPDEPTID,FAPPLICANTID,FRMMODE,FREPLENISHMODE,FRMREASON,FRMLOC,FDOCUMENTSTATUS,FDESCRIPTION,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FAPPROVERID,FAPPROVEDATE,FCANCELSTATUS,FCANCELLERID,FCANCELDATE,FIsConvert,FBUSINESSTYPE,FOBJECTTYPEID,FREQUIREORGID,FCorrespondOrgId,FCONFIRMSTATUS,FCONFIRMERID,FCONFIRMDATE,FBILLTYPEIDVM,FCLOSERID,FCLOSEDATE,FCLOSESTATUS) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PUR_MRAPP set FID=?,FBILLNO=?,FDATE=?,FBILLTYPEID=?,FSUPPLIERID=?,FRMTYPE=?,FPURCHASEORGID=?,FAPPORGID=?,FAPPDEPTID=?,FAPPLICANTID=?,FRMMODE=?,FREPLENISHMODE=?,FRMREASON=?,FRMLOC=?,FDOCUMENTSTATUS=?,FDESCRIPTION=?,FCREATORID=?,FCREATEDATE=?,FMODIFIERID=?,FMODIFYDATE=?,FAPPROVERID=?,FAPPROVEDATE=?,FCANCELSTATUS=?,FCANCELLERID=?,FCANCELDATE=?,FIsConvert=?,FBUSINESSTYPE=?,FOBJECTTYPEID=?,FREQUIREORGID=?,FCorrespondOrgId=?,FCONFIRMSTATUS=?,FCONFIRMERID=?,FCONFIRMDATE=?,FBILLTYPEIDVM=?,FCLOSERID=?,FCLOSEDATE=?,FCLOSESTATUS=? where FID=?

--delete脚本--

delete from T_PUR_MRAPP where FID=?

--给字段加备注--

alter table T_PUR_MRAPP modify column FID int default 0  comment '单据内码';
alter table T_PUR_MRAPP modify column FBILLNO nvarchar(30) default ''  comment '单据编号';
alter table T_PUR_MRAPP modify column FDATE datetime default getdate()  comment '日期';
alter table T_PUR_MRAPP modify column FBILLTYPEID varchar(36) default ''''  comment '单据类型';
alter table T_PUR_MRAPP modify column FSUPPLIERID int default 0  comment '供应商内码';
alter table T_PUR_MRAPP modify column FRMTYPE varchar(20) not null  comment '退货类型';
alter table T_PUR_MRAPP modify column FPURCHASEORGID int default 0  comment '采购组织';
alter table T_PUR_MRAPP modify column FAPPORGID int default 0  comment '申请组织';
alter table T_PUR_MRAPP modify column FAPPDEPTID int default 0  comment '申请部门';
alter table T_PUR_MRAPP modify column FAPPLICANTID int default 0  comment '申请人';
alter table T_PUR_MRAPP modify column FRMMODE varchar(20) default ''''  comment '退货方式';
alter table T_PUR_MRAPP modify column FREPLENISHMODE varchar(20) default ''''  comment '补货方式';
alter table T_PUR_MRAPP modify column FRMREASON varchar(36) default ''''  comment '退货原因';
alter table T_PUR_MRAPP modify column FRMLOC nvarchar(120) default ''  comment '退货地点';
alter table T_PUR_MRAPP modify column FDOCUMENTSTATUS char(1) default ''''  comment '单据状态';
alter table T_PUR_MRAPP modify column FDESCRIPTION nvarchar(255) default ''  comment '描述';
alter table T_PUR_MRAPP modify column FCREATORID int default 0  comment '制单人';
alter table T_PUR_MRAPP modify column FCREATEDATE datetime default getdate()  comment '制单日期';
alter table T_PUR_MRAPP modify column FMODIFIERID int default 0  comment '最近修改人内码';
alter table T_PUR_MRAPP modify column FMODIFYDATE datetime not null  comment '最新修改日期';
alter table T_PUR_MRAPP modify column FAPPROVERID int default 0  comment '审核人内码';
alter table T_PUR_MRAPP modify column FAPPROVEDATE datetime not null  comment '审核日期';
alter table T_PUR_MRAPP modify column FCANCELSTATUS char(1) default ''''  comment '作废状态';
alter table T_PUR_MRAPP modify column FCANCELLERID int default 0  comment '作废人内码';
alter table T_PUR_MRAPP modify column FCANCELDATE datetime not null  comment '作废日期';
alter table T_PUR_MRAPP modify column FIsConvert char(1) default ''0''  comment '是否是单据转换';
alter table T_PUR_MRAPP modify column FBUSINESSTYPE nvarchar(20) default ''  comment '业务类型';
alter table T_PUR_MRAPP modify column FOBJECTTYPEID varchar(36) default ''''  comment '业务对象类型';
alter table T_PUR_MRAPP modify column FREQUIREORGID int default 0  comment '需求组织携带';
alter table T_PUR_MRAPP modify column FCorrespondOrgId int not null  comment '对应组织';
alter table T_PUR_MRAPP modify column FCONFIRMSTATUS char(1) default ''''  comment '确认状态';
alter table T_PUR_MRAPP modify column FCONFIRMERID int default 0  comment '确认人';
alter table T_PUR_MRAPP modify column FCONFIRMDATE datetime not null  comment '确认日期';
alter table T_PUR_MRAPP modify column FBILLTYPEIDVM varchar(36) default ''''  comment '协同虚拟单据类型';
alter table T_PUR_MRAPP modify column FCLOSERID int default 0  comment '关闭人';
alter table T_PUR_MRAPP modify column FCLOSEDATE datetime not null  comment '关闭日期';
alter table T_PUR_MRAPP modify column FCLOSESTATUS char(1) default ''''  comment '关闭状态';