2.3 BD基础--基础资料-库存（单位换算）

--建表脚本--

create table T_BD_UNITCONVERTRATE(

FUNITCONVERTRATEID int not null  comment '换算率内码'

,FMASTERID int not null  comment '分配内码'

,FBILLNO nvarchar(30) default ''  comment '单据编号'

,FFORMID varchar(36) not null  comment '单据类型'

,FMATERIALID int default 0  comment '物料代码'

,FCURRENTUNITID int not null  comment '当前单位内码'

,FDESTUNITID int not null  comment '目标单位内码'

,FCONVERTTYPE varchar(20) not null  comment '换算类型'

,FCONVERTNUMERATOR decimal(23,10) not null  comment '换算分子'

,FCONVERTDENOMINATOR decimal(23,10) not null  comment '换算分母'

,FCREATEORGID int not null  comment '创建组织'

,FUSEORGID int not null  comment '使用组织'

,FCREATORID int not null  comment '创建人'

,FCREATEDATE datetime default null  comment '创建日期'

,FMODIFIERID int not null  comment '修改人'

,FMODIFYDATE datetime default null  comment '修改日期'

,FAPPROVERID int default 0  comment '审核人'

,FAPPROVEDATE datetime default null  comment '审核日期'

,FFORBIDDERID int default 0  comment '禁用人'

,FFORBIDDATE datetime default null  comment '禁用日期'

,FDOCUMENTSTATUS char(1) not null  comment '数据状态'

,FFORBIDSTATUS char(1) not null  comment '禁用状态'

,FUNITID int default 0  comment '关联计量单位内码'

,primary key (FUNITCONVERTRATEID)

) comment = '单位换算'

--查询--

select FUNITCONVERTRATEID as "funitconvertrateid",FMASTERID as "fmasterid",FBILLNO as "fbillno",FFORMID as "fformid",FMATERIALID as "fmaterialid",FCURRENTUNITID as "fcurrentunitid",FDESTUNITID as "fdestunitid",FCONVERTTYPE as "fconverttype",FCONVERTNUMERATOR as "fconvertnumerator",FCONVERTDENOMINATOR as "fconvertdenominator",FCREATEORGID as "fcreateorgid",FUSEORGID as "fuseorgid",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FAPPROVERID as "fapproverid",FAPPROVEDATE as "fapprovedate",FFORBIDDERID as "fforbidderid",FFORBIDDATE as "fforbiddate",FDOCUMENTSTATUS as "fdocumentstatus",FFORBIDSTATUS as "fforbidstatus",FUNITID as "funitid" from T_BD_UNITCONVERTRATE

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

select FUNITCONVERTRATEID as "换算率内码",FMASTERID as "分配内码",FBILLNO as "单据编号",FFORMID as "单据类型",FMATERIALID as "物料代码",FCURRENTUNITID as "当前单位内码",FDESTUNITID as "目标单位内码",FCONVERTTYPE as "换算类型",FCONVERTNUMERATOR as "换算分子",FCONVERTDENOMINATOR as "换算分母",FCREATEORGID as "创建组织",FUSEORGID as "使用组织",FCREATORID as "创建人",FCREATEDATE as "创建日期",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FAPPROVERID as "审核人",FAPPROVEDATE as "审核日期",FFORBIDDERID as "禁用人",FFORBIDDATE as "禁用日期",FDOCUMENTSTATUS as "数据状态",FFORBIDSTATUS as "禁用状态",FUNITID as "关联计量单位内码" from T_BD_UNITCONVERTRATE

--INSERT脚本--

insert into T_BD_UNITCONVERTRATE(FUNITCONVERTRATEID,FMASTERID,FBILLNO,FFORMID,FMATERIALID,FCURRENTUNITID,FDESTUNITID,FCONVERTTYPE,FCONVERTNUMERATOR,FCONVERTDENOMINATOR,FCREATEORGID,FUSEORGID,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FAPPROVERID,FAPPROVEDATE,FFORBIDDERID,FFORBIDDATE,FDOCUMENTSTATUS,FFORBIDSTATUS,FUNITID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_BD_UNITCONVERTRATE set FUNITCONVERTRATEID=?,FMASTERID=?,FBILLNO=?,FFORMID=?,FMATERIALID=?,FCURRENTUNITID=?,FDESTUNITID=?,FCONVERTTYPE=?,FCONVERTNUMERATOR=?,FCONVERTDENOMINATOR=?,FCREATEORGID=?,FUSEORGID=?,FCREATORID=?,FCREATEDATE=?,FMODIFIERID=?,FMODIFYDATE=?,FAPPROVERID=?,FAPPROVEDATE=?,FFORBIDDERID=?,FFORBIDDATE=?,FDOCUMENTSTATUS=?,FFORBIDSTATUS=?,FUNITID=? where FUNITCONVERTRATEID=?

--delete脚本--

delete from T_BD_UNITCONVERTRATE where FUNITCONVERTRATEID=?

--给字段加备注--

alter table T_BD_UNITCONVERTRATE comment '单位换算';

alter table T_BD_UNITCONVERTRATE modify column FUNITCONVERTRATEID int not null  comment '换算率内码';

alter table T_BD_UNITCONVERTRATE modify column FMASTERID int not null  comment '分配内码';

alter table T_BD_UNITCONVERTRATE modify column FBILLNO nvarchar(30) default ''  comment '单据编号';

alter table T_BD_UNITCONVERTRATE modify column FFORMID varchar(36) not null  comment '单据类型';

alter table T_BD_UNITCONVERTRATE modify column FMATERIALID int default 0  comment '物料代码';

alter table T_BD_UNITCONVERTRATE modify column FCURRENTUNITID int not null  comment '当前单位内码';

alter table T_BD_UNITCONVERTRATE modify column FDESTUNITID int not null  comment '目标单位内码';

alter table T_BD_UNITCONVERTRATE modify column FCONVERTTYPE varchar(20) not null  comment '换算类型';

alter table T_BD_UNITCONVERTRATE modify column FCONVERTNUMERATOR decimal(23,10) not null  comment '换算分子';

alter table T_BD_UNITCONVERTRATE modify column FCONVERTDENOMINATOR decimal(23,10) not null  comment '换算分母';

alter table T_BD_UNITCONVERTRATE modify column FCREATEORGID int not null  comment '创建组织';

alter table T_BD_UNITCONVERTRATE modify column FUSEORGID int not null  comment '使用组织';

alter table T_BD_UNITCONVERTRATE modify column FCREATORID int not null  comment '创建人';

alter table T_BD_UNITCONVERTRATE modify column FCREATEDATE datetime default null  comment '创建日期';

alter table T_BD_UNITCONVERTRATE modify column FMODIFIERID int not null  comment '修改人';

alter table T_BD_UNITCONVERTRATE modify column FMODIFYDATE datetime default null  comment '修改日期';

alter table T_BD_UNITCONVERTRATE modify column FAPPROVERID int default 0  comment '审核人';

alter table T_BD_UNITCONVERTRATE modify column FAPPROVEDATE datetime default null  comment '审核日期';

alter table T_BD_UNITCONVERTRATE modify column FFORBIDDERID int default 0  comment '禁用人';

alter table T_BD_UNITCONVERTRATE modify column FFORBIDDATE datetime default null  comment '禁用日期';

alter table T_BD_UNITCONVERTRATE modify column FDOCUMENTSTATUS char(1) not null  comment '数据状态';

alter table T_BD_UNITCONVERTRATE modify column FFORBIDSTATUS char(1) not null  comment '禁用状态';

alter table T_BD_UNITCONVERTRATE modify column FUNITID int default 0  comment '关联计量单位内码';