--建表脚本--

create table T_BD_AUXPTYVALCOM(

FID int not null  comment '辅助属性值组合内码'

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

,FBILLNO nvarchar(30) not null  comment '单据编码'

,FMATERIALID int not null  comment '物料内码'

,FCREATORID int not null  comment '创建人'

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

,FMODIFIERID int not null  comment '修改人'

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

,FAPPROVERID int default 0  comment '审核人'

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

,FFORBIDDERID int default 0  comment '禁用人'

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

,FOPERATIONSTATUS char(1) not null  comment '业务状态'

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

,primary key (FID)

) comment = '辅助属性值组合'

--查询--

select FID as "fid",FFORMID as "fformid",FBILLNO as "fbillno",FMATERIALID as "fmaterialid",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FAPPROVERID as "fapproverid",FAPPROVEDATE as "fapprovedate",FFORBIDDERID as "fforbidderid",FFORBIDDATE as "fforbiddate",FOPERATIONSTATUS as "foperationstatus",FFORBIDSTATUS as "fforbidstatus" from T_BD_AUXPTYVALCOM

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

select FID as "辅助属性值组合内码",FFORMID as "单据类型",FBILLNO as "单据编码",FMATERIALID as "物料内码",FCREATORID as "创建人",FCREATEDATE as "创建日期",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FAPPROVERID as "审核人",FAPPROVEDATE as "审核日期",FFORBIDDERID as "禁用人",FFORBIDDATE as "禁用日期",FOPERATIONSTATUS as "业务状态",FFORBIDSTATUS as "禁用状态" from T_BD_AUXPTYVALCOM

--INSERT脚本--

insert into T_BD_AUXPTYVALCOM(FID,FFORMID,FBILLNO,FMATERIALID,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FAPPROVERID,FAPPROVEDATE,FFORBIDDERID,FFORBIDDATE,FOPERATIONSTATUS,FFORBIDSTATUS) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_BD_AUXPTYVALCOM set FID=?,FFORMID=?,FBILLNO=?,FMATERIALID=?,FCREATORID=?,FCREATEDATE=?,FMODIFIERID=?,FMODIFYDATE=?,FAPPROVERID=?,FAPPROVEDATE=?,FFORBIDDERID=?,FFORBIDDATE=?,FOPERATIONSTATUS=?,FFORBIDSTATUS=? where FID=?

--delete脚本--

delete from T_BD_AUXPTYVALCOM where FID=?

--给字段加备注--

alter table T_BD_AUXPTYVALCOM comment '辅助属性值组合';

alter table T_BD_AUXPTYVALCOM modify column FID int not null  comment '辅助属性值组合内码';

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

alter table T_BD_AUXPTYVALCOM modify column FBILLNO nvarchar(30) not null  comment '单据编码';

alter table T_BD_AUXPTYVALCOM modify column FMATERIALID int not null  comment '物料内码';

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

alter table T_BD_AUXPTYVALCOM modify column FCREATEDATE datetime not null  comment '创建日期';

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

alter table T_BD_AUXPTYVALCOM modify column FMODIFYDATE datetime not null  comment '修改日期';

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

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

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

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

alter table T_BD_AUXPTYVALCOM modify column FOPERATIONSTATUS char(1) not null  comment '业务状态';

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

--建表脚本--

create table T_BD_AUXPTYVALCOMENTRY(

FENTRYID int not null  comment '分录内码'

,FID int not null  comment '辅助属性值组合内码'

,FISEFFECTIVE char(1) not null  comment '有效'

,FSEQ int not null  comment '序号'

,FENTRYMATERIALID int not null  comment '物料内码'

,primary key (FENTRYID)

) comment = '辅助属性值组合表体'

--查询--

select FENTRYID as "fentryid",FID as "fid",FISEFFECTIVE as "fiseffective",FSEQ as "fseq",FENTRYMATERIALID as "fentrymaterialid" from T_BD_AUXPTYVALCOMENTRY

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

select FENTRYID as "分录内码",FID as "辅助属性值组合内码",FISEFFECTIVE as "有效",FSEQ as "序号",FENTRYMATERIALID as "物料内码" from T_BD_AUXPTYVALCOMENTRY

--INSERT脚本--

insert into T_BD_AUXPTYVALCOMENTRY(FENTRYID,FID,FISEFFECTIVE,FSEQ,FENTRYMATERIALID) values (?,?,?,?,?)

--UPDATE脚本--

update T_BD_AUXPTYVALCOMENTRY set FENTRYID=?,FID=?,FISEFFECTIVE=?,FSEQ=?,FENTRYMATERIALID=? where FENTRYID=?

--delete脚本--

delete from T_BD_AUXPTYVALCOMENTRY where FENTRYID=?

--给字段加备注--

alter table T_BD_AUXPTYVALCOMENTRY comment '辅助属性值组合表体';

alter table T_BD_AUXPTYVALCOMENTRY modify column FENTRYID int not null  comment '分录内码';

alter table T_BD_AUXPTYVALCOMENTRY modify column FID int not null  comment '辅助属性值组合内码';

alter table T_BD_AUXPTYVALCOMENTRY modify column FISEFFECTIVE char(1) not null  comment '有效';

alter table T_BD_AUXPTYVALCOMENTRY modify column FSEQ int not null  comment '序号';

alter table T_BD_AUXPTYVALCOMENTRY modify column FENTRYMATERIALID int not null  comment '物料内码';

--建表脚本--

create table T_BD_AUXPTYVALUE(

FAUXPTYVALUEID int not null  comment '辅助属性值内码'

,FMATERIALID int not null  comment '物料内码'

,FMATERIALAUXPROPERTYID int not null  comment '辅助属性内码'

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

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

,FCREATORID int not null  comment '创建人'

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

,FMODIFIERID int not null  comment '修改人'

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

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

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

,FAPPROVERID int default 0  comment '审核人'

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

,FFORBIDDERID int default 0  comment '禁用人'

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

,FISSYSPREINSERT char(1) not null  comment '是否系统后台添加'

,primary key (FAUXPTYVALUEID)

) comment = '辅助属性值'

--查询--

select FAUXPTYVALUEID as "fauxptyvalueid",FMATERIALID as "fmaterialid",FMATERIALAUXPROPERTYID as "fmaterialauxpropertyid",FFORMID as "fformid",FBILLNO as "fbillno",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FOPERATIONSTATUS as "foperationstatus",FFORBIDSTATUS as "fforbidstatus",FAPPROVERID as "fapproverid",FAPPROVEDATE as "fapprovedate",FFORBIDDERID as "fforbidderid",FFORBIDDATE as "fforbiddate",FISSYSPREINSERT as "fissyspreinsert" from T_BD_AUXPTYVALUE

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

select FAUXPTYVALUEID as "辅助属性值内码",FMATERIALID as "物料内码",FMATERIALAUXPROPERTYID as "辅助属性内码",FFORMID as "单据类型",FBILLNO as "单据编号",FCREATORID as "创建人",FCREATEDATE as "创建日期",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FOPERATIONSTATUS as "数据状态",FFORBIDSTATUS as "禁用状态",FAPPROVERID as "审核人",FAPPROVEDATE as "审核日期",FFORBIDDERID as "禁用人",FFORBIDDATE as "禁用日期",FISSYSPREINSERT as "是否系统后台添加" from T_BD_AUXPTYVALUE

--INSERT脚本--

insert into T_BD_AUXPTYVALUE(FAUXPTYVALUEID,FMATERIALID,FMATERIALAUXPROPERTYID,FFORMID,FBILLNO,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FOPERATIONSTATUS,FFORBIDSTATUS,FAPPROVERID,FAPPROVEDATE,FFORBIDDERID,FFORBIDDATE,FISSYSPREINSERT) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_BD_AUXPTYVALUE set FAUXPTYVALUEID=?,FMATERIALID=?,FMATERIALAUXPROPERTYID=?,FFORMID=?,FBILLNO=?,FCREATORID=?,FCREATEDATE=?,FMODIFIERID=?,FMODIFYDATE=?,FOPERATIONSTATUS=?,FFORBIDSTATUS=?,FAPPROVERID=?,FAPPROVEDATE=?,FFORBIDDERID=?,FFORBIDDATE=?,FISSYSPREINSERT=? where FAUXPTYVALUEID=?

--delete脚本--

delete from T_BD_AUXPTYVALUE where FAUXPTYVALUEID=?

--给字段加备注--

alter table T_BD_AUXPTYVALUE comment '辅助属性值';

alter table T_BD_AUXPTYVALUE modify column FAUXPTYVALUEID int not null  comment '辅助属性值内码';

alter table T_BD_AUXPTYVALUE modify column FMATERIALID int not null  comment '物料内码';

alter table T_BD_AUXPTYVALUE modify column FMATERIALAUXPROPERTYID int not null  comment '辅助属性内码';

alter table T_BD_AUXPTYVALUE modify column FFORMID varchar(36) default ''''  comment '单据类型';

alter table T_BD_AUXPTYVALUE modify column FBILLNO nvarchar(30) not null  comment '单据编号';

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

alter table T_BD_AUXPTYVALUE modify column FCREATEDATE datetime not null  comment '创建日期';

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

alter table T_BD_AUXPTYVALUE modify column FMODIFYDATE datetime not null  comment '修改日期';

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

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

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

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

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

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

alter table T_BD_AUXPTYVALUE modify column FISSYSPREINSERT char(1) not null  comment '是否系统后台添加';

--建表脚本--

create table T_BD_AUXPTYVALUEENTITY(

FENTRYID int not null  comment '分录内码'

,FAUXPTYVALUEID int not null  comment '辅助属性值内码'

,FAUXPTYID nvarchar(36) not null  comment '辅助属性内码'

,FAUXPTYNUMBER nvarchar(30) not null  comment '辅助属性编码'

,FISSELECT char(1) not null  comment '选择'

,FISDEFAULT char(1) not null  comment '默认'

,FISDISABLE char(1) not null  comment '禁用'

,FSEQ int not null  comment '序号'

,FDISPLAYSEQ int not null  comment '显示顺序'

,primary key (FENTRYID)

) comment = '辅助属性值表体'

--查询--

select FENTRYID as "fentryid",FAUXPTYVALUEID as "fauxptyvalueid",FAUXPTYID as "fauxptyid",FAUXPTYNUMBER as "fauxptynumber",FISSELECT as "fisselect",FISDEFAULT as "fisdefault",FISDISABLE as "fisdisable",FSEQ as "fseq",FDISPLAYSEQ as "fdisplayseq" from T_BD_AUXPTYVALUEENTITY

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

select FENTRYID as "分录内码",FAUXPTYVALUEID as "辅助属性值内码",FAUXPTYID as "辅助属性内码",FAUXPTYNUMBER as "辅助属性编码",FISSELECT as "选择",FISDEFAULT as "默认",FISDISABLE as "禁用",FSEQ as "序号",FDISPLAYSEQ as "显示顺序" from T_BD_AUXPTYVALUEENTITY

--INSERT脚本--

insert into T_BD_AUXPTYVALUEENTITY(FENTRYID,FAUXPTYVALUEID,FAUXPTYID,FAUXPTYNUMBER,FISSELECT,FISDEFAULT,FISDISABLE,FSEQ,FDISPLAYSEQ) values (?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_BD_AUXPTYVALUEENTITY set FENTRYID=?,FAUXPTYVALUEID=?,FAUXPTYID=?,FAUXPTYNUMBER=?,FISSELECT=?,FISDEFAULT=?,FISDISABLE=?,FSEQ=?,FDISPLAYSEQ=? where FENTRYID=?

--delete脚本--

delete from T_BD_AUXPTYVALUEENTITY where FENTRYID=?

--给字段加备注--

alter table T_BD_AUXPTYVALUEENTITY comment '辅助属性值表体';

alter table T_BD_AUXPTYVALUEENTITY modify column FENTRYID int not null  comment '分录内码';

alter table T_BD_AUXPTYVALUEENTITY modify column FAUXPTYVALUEID int not null  comment '辅助属性值内码';

alter table T_BD_AUXPTYVALUEENTITY modify column FAUXPTYID nvarchar(36) not null  comment '辅助属性内码';

alter table T_BD_AUXPTYVALUEENTITY modify column FAUXPTYNUMBER nvarchar(30) not null  comment '辅助属性编码';

alter table T_BD_AUXPTYVALUEENTITY modify column FISSELECT char(1) not null  comment '选择';

alter table T_BD_AUXPTYVALUEENTITY modify column FISDEFAULT char(1) not null  comment '默认';

alter table T_BD_AUXPTYVALUEENTITY modify column FISDISABLE char(1) not null  comment '禁用';

alter table T_BD_AUXPTYVALUEENTITY modify column FSEQ int not null  comment '序号';

alter table T_BD_AUXPTYVALUEENTITY modify column FDISPLAYSEQ int not null  comment '显示顺序';

--建表脚本--

create table T_BD_AUXPTYVALUEENTITY_L(

FPKID int not null  comment '词条id'

,FENTRYID int not null  comment '辅助属性值分录内码'

,FLOCALEID int not null  comment '语言标识'

,FAUXPTYNAME nvarchar(80) default ''  comment '辅助属性值名称'

,primary key (FPKID)

) comment = '辅助属性值多语言'

--查询--

select FPKID as "fpkid",FENTRYID as "fentryid",FLOCALEID as "flocaleid",FAUXPTYNAME as "fauxptyname" from T_BD_AUXPTYVALUEENTITY_L

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

select FPKID as "词条id",FENTRYID as "辅助属性值分录内码",FLOCALEID as "语言标识",FAUXPTYNAME as "辅助属性值名称" from T_BD_AUXPTYVALUEENTITY_L

--INSERT脚本--

insert into T_BD_AUXPTYVALUEENTITY_L(FPKID,FENTRYID,FLOCALEID,FAUXPTYNAME) values (?,?,?,?)

--UPDATE脚本--

update T_BD_AUXPTYVALUEENTITY_L set FPKID=?,FENTRYID=?,FLOCALEID=?,FAUXPTYNAME=? where FPKID=?

--delete脚本--

delete from T_BD_AUXPTYVALUEENTITY_L where FPKID=?

--给字段加备注--

alter table T_BD_AUXPTYVALUEENTITY_L comment '辅助属性值多语言';

alter table T_BD_AUXPTYVALUEENTITY_L modify column FPKID int not null  comment '词条id';

alter table T_BD_AUXPTYVALUEENTITY_L modify column FENTRYID int not null  comment '辅助属性值分录内码';

alter table T_BD_AUXPTYVALUEENTITY_L modify column FLOCALEID int not null  comment '语言标识';

alter table T_BD_AUXPTYVALUEENTITY_L modify column FAUXPTYNAME nvarchar(80) default ''  comment '辅助属性值名称';

--建表脚本--

create table T_BD_FLEXAUXPROPERTY(

FID int not null  comment '辅助属性内码'

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

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

,FNUMBER nvarchar(30) not null  comment '编码'

,FVALUETYPE int not null  comment '值类型'

,FVALUESOURCE varchar(36) not null  comment '值来源'

,FVALUELIMIT int not null  comment '值约束'

,FISSYSPRESET char(1) not null  comment '系统预设'

,FFLEXNUMBER nvarchar(50) not null  comment '辅助属性维度数据对应编码'

,FCREATORID int not null  comment '创建人'

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

,FMODIFIERID int not null  comment '修改人'

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

,FAUDITORID int not null  comment '审核人'

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

,FFORBIDDERID int not null  comment '禁用人'

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

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

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

,FCUSTOMDATATYPE varchar(50) default ''''  comment '自定义数据类型'

,FCUSTOMDATAPRECISION int default 0  comment '自定义维度整数精度'

,FCUSTOMDATAACCURACY int default 0  comment '自定义维度小数精度'

,FCUSTOMDATAMIN varchar(50) default ''''  comment '自定义维度最小值'

,FCUSTOMDATAMAX varchar(50) default ''''  comment '自定义维度最大值'

,FCUSTOMDATASTRMAXLEN int default 0  comment '自定义维度字符长度'

,FISSETBYMATERIAL char(1) not null  comment '按物料设置辅助属性值'

,FCOLWIDTH int not null  comment '固定列宽'

,FTRIMONNUMBER char(1) not null  comment '清除首尾空格'

,primary key (FID)

) comment = '辅助属性'

--查询--

select FID as "fid",FMASTERID as "fmasterid",FFORMID as "fformid",FNUMBER as "fnumber",FVALUETYPE as "fvaluetype",FVALUESOURCE as "fvaluesource",FVALUELIMIT as "fvaluelimit",FISSYSPRESET as "fissyspreset",FFLEXNUMBER as "fflexnumber",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FAUDITORID as "fauditorid",FAUDITDATE as "fauditdate",FFORBIDDERID as "fforbidderid",FFORBIDDATE as "fforbiddate",FDOCUMENTSTATUS as "fdocumentstatus",FFORBIDSTATUS as "fforbidstatus",FCUSTOMDATATYPE as "fcustomdatatype",FCUSTOMDATAPRECISION as "fcustomdataprecision",FCUSTOMDATAACCURACY as "fcustomdataaccuracy",FCUSTOMDATAMIN as "fcustomdatamin",FCUSTOMDATAMAX as "fcustomdatamax",FCUSTOMDATASTRMAXLEN as "fcustomdatastrmaxlen",FISSETBYMATERIAL as "fissetbymaterial",FCOLWIDTH as "fcolwidth",FTRIMONNUMBER as "ftrimonnumber" from T_BD_FLEXAUXPROPERTY

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

select FID as "辅助属性内码",FMASTERID as "分配后内码",FFORMID as "单据类型",FNUMBER as "编码",FVALUETYPE as "值类型",FVALUESOURCE as "值来源",FVALUELIMIT as "值约束",FISSYSPRESET as "系统预设",FFLEXNUMBER as "辅助属性维度数据对应编码",FCREATORID as "创建人",FCREATEDATE as "创建日期",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FAUDITORID as "审核人",FAUDITDATE as "审核日期",FFORBIDDERID as "禁用人",FFORBIDDATE as "禁用日期",FDOCUMENTSTATUS as "数据状态",FFORBIDSTATUS as "禁用状态",FCUSTOMDATATYPE as "自定义数据类型",FCUSTOMDATAPRECISION as "自定义维度整数精度",FCUSTOMDATAACCURACY as "自定义维度小数精度",FCUSTOMDATAMIN as "自定义维度最小值",FCUSTOMDATAMAX as "自定义维度最大值",FCUSTOMDATASTRMAXLEN as "自定义维度字符长度",FISSETBYMATERIAL as "按物料设置辅助属性值",FCOLWIDTH as "固定列宽",FTRIMONNUMBER as "清除首尾空格" from T_BD_FLEXAUXPROPERTY

--INSERT脚本--

insert into T_BD_FLEXAUXPROPERTY(FID,FMASTERID,FFORMID,FNUMBER,FVALUETYPE,FVALUESOURCE,FVALUELIMIT,FISSYSPRESET,FFLEXNUMBER,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FAUDITORID,FAUDITDATE,FFORBIDDERID,FFORBIDDATE,FDOCUMENTSTATUS,FFORBIDSTATUS,FCUSTOMDATATYPE,FCUSTOMDATAPRECISION,FCUSTOMDATAACCURACY,FCUSTOMDATAMIN,FCUSTOMDATAMAX,FCUSTOMDATASTRMAXLEN,FISSETBYMATERIAL,FCOLWIDTH,FTRIMONNUMBER) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_BD_FLEXAUXPROPERTY set FID=?,FMASTERID=?,FFORMID=?,FNUMBER=?,FVALUETYPE=?,FVALUESOURCE=?,FVALUELIMIT=?,FISSYSPRESET=?,FFLEXNUMBER=?,FCREATORID=?,FCREATEDATE=?,FMODIFIERID=?,FMODIFYDATE=?,FAUDITORID=?,FAUDITDATE=?,FFORBIDDERID=?,FFORBIDDATE=?,FDOCUMENTSTATUS=?,FFORBIDSTATUS=?,FCUSTOMDATATYPE=?,FCUSTOMDATAPRECISION=?,FCUSTOMDATAACCURACY=?,FCUSTOMDATAMIN=?,FCUSTOMDATAMAX=?,FCUSTOMDATASTRMAXLEN=?,FISSETBYMATERIAL=?,FCOLWIDTH=?,FTRIMONNUMBER=? where FID=?

--delete脚本--

delete from T_BD_FLEXAUXPROPERTY where FID=?

--建表脚本--

create table T_BD_FLEXAUXPROPERTYENTITY(

FENTRYID int not null  comment '分录内码'

,FID int not null  comment '辅助属性内码'

,FISENABLE char(1) not null  comment '启用'

,FORGANIZATIONID int not null  comment '组织内码'

,primary key (FENTRYID)

) comment = '辅助属性表体'

--查询--

select FENTRYID as "fentryid",FID as "fid",FISENABLE as "fisenable",FORGANIZATIONID as "forganizationid" from T_BD_FLEXAUXPROPERTYENTITY

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

select FENTRYID as "分录内码",FID as "辅助属性内码",FISENABLE as "启用",FORGANIZATIONID as "组织内码" from T_BD_FLEXAUXPROPERTYENTITY

--INSERT脚本--

insert into T_BD_FLEXAUXPROPERTYENTITY(FENTRYID,FID,FISENABLE,FORGANIZATIONID) values (?,?,?,?)

--UPDATE脚本--

update T_BD_FLEXAUXPROPERTYENTITY set FENTRYID=?,FID=?,FISENABLE=?,FORGANIZATIONID=? where FENTRYID=?

--delete脚本--

delete from T_BD_FLEXAUXPROPERTYENTITY where FENTRYID=?

--建表脚本--

create table T_BD_FLEXAUXPROPERTY_L(

FPKID int not null  comment '词条id'

,FID int not null  comment '辅助属性内码'

,FLOCALEID int not null  comment '语言标识'

,FNAME nvarchar(255) not null  comment '名称'

,FDESCRIPTION nvarchar(255) not null  comment '描述'

,primary key (FPKID)

) comment = '辅助属性多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLOCALEID as "flocaleid",FNAME as "fname",FDESCRIPTION as "fdescription" from T_BD_FLEXAUXPROPERTY_L

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

select FPKID as "词条id",FID as "辅助属性内码",FLOCALEID as "语言标识",FNAME as "名称",FDESCRIPTION as "描述" from T_BD_FLEXAUXPROPERTY_L

--INSERT脚本--

insert into T_BD_FLEXAUXPROPERTY_L(FPKID,FID,FLOCALEID,FNAME,FDESCRIPTION) values (?,?,?,?,?)

--UPDATE脚本--

update T_BD_FLEXAUXPROPERTY_L set FPKID=?,FID=?,FLOCALEID=?,FNAME=?,FDESCRIPTION=? where FPKID=?

--delete脚本--

delete from T_BD_FLEXAUXPROPERTY_L where FPKID=?