143 lines
6.0 KiB
SQL
143 lines
6.0 KiB
SQL
create table HFDL_CHEKBILL_H (vbatchcode varchar2(50) null /*批次号*/,
|
|
dapplydate char(19) null /*报检日期*/,
|
|
unnastnum number(28,8) null /*不合格数量*/,
|
|
vrecheckreason varchar2(50) null /*复检原因*/,
|
|
vsourcecode varchar2(50) null /*来源单据号*/,
|
|
vmemo varchar2(50) null /*备注*/,
|
|
brecheck number(28,8) null /*不合格数量*/,
|
|
nnum number(28,8) null /*检验数量*/,
|
|
cunitid varchar2(20) null /*单位*/,
|
|
pk_batchcode varchar2(20) null /*批次号*/,
|
|
pk_chkdept varchar2(20) null /*检验部门*/,
|
|
pk_material varchar2(20) null /*物料编码*/,
|
|
pk_applydept varchar2(20) null /*报检部门*/,
|
|
pk_stockorg varchar2(20) null /*库存组织*/,
|
|
def40 varchar2(101) null /*自定义项40*/,
|
|
def39 varchar2(101) null /*自定义项39*/,
|
|
def38 varchar2(101) null /*自定义项38*/,
|
|
def37 varchar2(101) null /*自定义项37*/,
|
|
def36 varchar2(101) null /*自定义项36*/,
|
|
def35 varchar2(101) null /*自定义项35*/,
|
|
def34 varchar2(101) null /*自定义项34*/,
|
|
def33 varchar2(101) null /*自定义项33*/,
|
|
def32 varchar2(101) null /*自定义项32*/,
|
|
def31 varchar2(101) null /*自定义项31*/,
|
|
def30 varchar2(101) null /*自定义项30*/,
|
|
def29 varchar2(101) null /*自定义项29*/,
|
|
def28 varchar2(101) null /*自定义项28*/,
|
|
def27 varchar2(101) null /*自定义项27*/,
|
|
def26 varchar2(101) null /*自定义项26*/,
|
|
def25 varchar2(101) null /*自定义项25*/,
|
|
def24 varchar2(101) null /*自定义项24*/,
|
|
def23 varchar2(101) null /*自定义项23*/,
|
|
def22 varchar2(101) null /*自定义项22*/,
|
|
def21 varchar2(101) null /*自定义项21*/,
|
|
def20 varchar2(101) null /*自定义项20*/,
|
|
def19 varchar2(101) null /*自定义项19*/,
|
|
def18 varchar2(101) null /*自定义项18*/,
|
|
def17 varchar2(101) null /*自定义项17*/,
|
|
def16 varchar2(101) null /*自定义项16*/,
|
|
def15 varchar2(101) null /*自定义项15*/,
|
|
def14 varchar2(101) null /*自定义项14*/,
|
|
def13 varchar2(101) null /*自定义项13*/,
|
|
def12 varchar2(101) null /*自定义项12*/,
|
|
def11 varchar2(101) null /*自定义项11*/,
|
|
def10 varchar2(101) null /*自定义项10*/,
|
|
def9 varchar2(101) null /*自定义项9*/,
|
|
def8 varchar2(101) null /*自定义项8*/,
|
|
def7 varchar2(101) null /*自定义项7*/,
|
|
def6 varchar2(101) null /*自定义项6*/,
|
|
def5 varchar2(101) null /*自定义项5*/,
|
|
def4 varchar2(101) null /*自定义项4*/,
|
|
def3 varchar2(101) null /*自定义项3*/,
|
|
def2 varchar2(101) null /*自定义项2*/,
|
|
def1 varchar2(101) null /*自定义项1*/,
|
|
srcbilltype varchar2(50) null /*来源单据类型*/,
|
|
srcbillid varchar2(50) null /*来源单据id*/,
|
|
busitype varchar2(20) null /*业务类型*/,
|
|
billmaker varchar2(20) null /*制单人*/,
|
|
emendenum integer null /*修订枚举*/,
|
|
approvestatus integer null /*审批状态*/,
|
|
approvedate char(19) null /*审批时间*/,
|
|
approver varchar2(20) null /*审批人*/,
|
|
approvenote varchar2(50) null /*审批批语*/,
|
|
transtypepk varchar2(20) null /*交易类型pk*/,
|
|
transtype varchar2(50) null /*交易类型*/,
|
|
billtype varchar2(50) null /*单据类型*/,
|
|
billversionpk varchar2(50) null /*单据版本pk*/,
|
|
modifiedtime char(19) null /*最后修改时间1*/,
|
|
modifier varchar2(20) null /*最后修改人*/,
|
|
creationtime char(19) null /*创建时间*/,
|
|
creator varchar2(20) null /*创建人*/,
|
|
lastmaketime char(19) null /*最后修改时间*/,
|
|
maketime char(19) null /*制单时间*/,
|
|
pk_org_v varchar2(20) null /*组织多版本*/,
|
|
code varchar2(50) null /*code*/,
|
|
pk_group varchar2(20) null /*pk_group*/,
|
|
pk_org varchar2(20) null /*pk_org*/,
|
|
pk_chekbill_h char(20) not null /*主键*/,
|
|
ts char(19) default to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') null /*null*/,
|
|
dr integer null /*null*/,
|
|
constraint HFDL_CHEKBILL_H_PK primary key (pk_chekbill_h)
|
|
)
|
|
|
|
/
|
|
|
|
create table HFDL_CHEKBILL_B (uncheakbillid varchar2(50) null /*不合格明细id*/,
|
|
nunqualifiednum number(28,8) null /*不合格数量*/,
|
|
qualifiednum number(28,8) null /*合格数量*/,
|
|
vbatch varchar2(50) null /*批次号*/,
|
|
wastenum number(28,8) null /*报废数量*/,
|
|
nchecknum number(28,8) null /*检验数量*/,
|
|
def40 varchar2(101) null /*自定义项40*/,
|
|
def39 varchar2(101) null /*自定义项39*/,
|
|
def38 varchar2(101) null /*自定义项38*/,
|
|
def37 varchar2(101) null /*自定义项37*/,
|
|
def36 varchar2(101) null /*自定义项36*/,
|
|
def35 varchar2(101) null /*自定义项35*/,
|
|
def34 varchar2(101) null /*自定义项34*/,
|
|
def33 varchar2(101) null /*自定义项33*/,
|
|
def32 varchar2(101) null /*自定义项32*/,
|
|
def31 varchar2(101) null /*自定义项31*/,
|
|
def30 varchar2(101) null /*自定义项30*/,
|
|
def29 varchar2(101) null /*自定义项29*/,
|
|
def28 varchar2(101) null /*自定义项28*/,
|
|
def27 varchar2(101) null /*自定义项27*/,
|
|
def26 varchar2(101) null /*自定义项26*/,
|
|
def25 varchar2(101) null /*自定义项25*/,
|
|
def24 varchar2(101) null /*自定义项24*/,
|
|
def23 varchar2(101) null /*自定义项23*/,
|
|
def22 varchar2(101) null /*自定义项22*/,
|
|
def21 varchar2(101) null /*自定义项21*/,
|
|
def20 varchar2(101) null /*自定义项20*/,
|
|
def19 varchar2(101) null /*自定义项19*/,
|
|
def18 varchar2(101) null /*自定义项18*/,
|
|
def17 varchar2(101) null /*自定义项17*/,
|
|
def16 varchar2(101) null /*自定义项16*/,
|
|
def15 varchar2(101) null /*自定义项15*/,
|
|
def14 varchar2(101) null /*自定义项14*/,
|
|
def13 varchar2(101) null /*自定义项13*/,
|
|
def12 varchar2(101) null /*自定义项12*/,
|
|
def11 varchar2(101) null /*自定义项11*/,
|
|
def10 varchar2(101) null /*自定义项10*/,
|
|
def9 varchar2(101) null /*自定义项9*/,
|
|
def8 varchar2(101) null /*自定义项8*/,
|
|
def7 varchar2(101) null /*自定义项7*/,
|
|
def6 varchar2(101) null /*自定义项6*/,
|
|
def5 varchar2(101) null /*自定义项5*/,
|
|
def4 varchar2(101) null /*自定义项4*/,
|
|
def3 varchar2(101) null /*自定义项3*/,
|
|
def2 varchar2(101) null /*自定义项2*/,
|
|
def1 varchar2(101) null /*自定义项1*/,
|
|
srcrowno varchar2(50) null /*来源行号*/,
|
|
rowno varchar2(50) null /*行号*/,
|
|
pk_chekbill_b char(20) not null /*主键*/,
|
|
pk_dhjydmaster char(20) not null /*上层单据主键*/,
|
|
ts char(19) default to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') null /*null*/,
|
|
dr integer null /*null*/,
|
|
constraint HFDL_CHEKBILL_B_PK primary key (pk_chekbill_b)
|
|
)
|
|
|
|
/
|
|
|