mr.sql

一个用VB写的财务软件源码

  );
create table TMR_OFFSETSUB<<YEAR>>
(
  ID           NUMBER not null,
  SISERIAL     NUMBER not null,
  VCSUMMARY    VARCHAR2(100) default ' ' not null,
  CFX          CHAR(2) not null,
  DEJE         NUMBER(15,2) default 0 not null,
  VCREPORTITEM VARCHAR2(100) default ' ' not null,
  IITEMROW     NUMBER default 0 not null,
  ITEMID       NUMBER default 0 not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TMR_OFFSETSUB<<YEAR>>
  add constraint PK_MR_OFFSETSUB<<YEAR>> primary key (ID,SISERIAL)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TMR_PARAMETER
(
  ID          VARCHAR2(10) default '0' not null,
  COMPANYCODE VARCHAR2(10) not null,
  CYEAR       VARCHAR2(4) not null,
  CNAME       VARCHAR2(50) default ' ' not null,
  CVALUE      VARCHAR2(200) default '0' not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
alter table TMR_PARAMETER
  add constraint PK_MR_PARAMETER primary key (ID,COMPANYCODE,CYEAR)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
create table TMR_REPORT<<YEAR>>
(
  VCREPORTCODE VARCHAR2(10) not null,
  VCREPORTNAME VARCHAR2(50) not null,
  CREPORTTYPE  CHAR(4) not null,
  BTOTAL       NUMBER,
  BCOLLECT     NUMBER,
  BMERGE       NUMBER,
  BANALYSIS    NUMBER,
  SISERIAL     NUMBER default 0 not null,
  ID           NUMBER default 0,
  BACCESSORY   NUMBER default 0 not null,
  PARENTCODE   VARCHAR2(10) default ' ' not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
alter table TMR_REPORT<<YEAR>>
  add constraint PK_MR_REPORT<<YEAR>> primary key (VCREPORTCODE)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
create table TMR_REPORTAREA
(
  CYEAR        CHAR(4) not null,
  VCREPORTCODE VARCHAR2(10) not null,
  SISTARTROW   NUMBER not null,
  SISTARTCOL   NUMBER not null,
  SIENDROW     NUMBER not null,
  SIENDCOL     NUMBER not null,
  CAREATYPE    CHAR(4) not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TMR_REPORTAREA
  add constraint PK_MR_REPORTAREA primary key (CYEAR,VCREPORTCODE,SISTARTROW,SISTARTCOL,SIENDROW,SIENDCOL)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TMR_REPORTDATA<<YEAR>>
(
  REPORTCODE VARCHAR2(10) not null,
  ENTERCODE  VARCHAR2(25) not null,
  MONTH      NUMBER not null,
  IROWLABEL  NUMBER not null,
  COLLABEL   NUMBER not null,
  CELLDATA   NUMBER(15,4)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TMR_REPORTDATA<<YEAR>>
  add constraint PK_MR_REPORTDATA<<YEAR>> primary key (REPORTCODE,ENTERCODE,MONTH,IROWLABEL,COLLABEL)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TMR_REPORTEQUALIN
(
  CYEAR           CHAR(4) not null,
  VCREPORTCODE    VARCHAR2(10) not null,
  ISORTID         NUMBER not null,
  SIROWLABEL      NUMBER not null,
  SICOLLABEL      NUMBER not null,
  CCALCULATESIGN  CHAR(1) not null,
  SISTARTROWLABEL NUMBER not null,
  SIENDROWLABEL   NUMBER not null,
  SISTARTCOLLABEL NUMBER not null,
  SIENDCOLLABEL   NUMBER not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TMR_REPORTEQUALIN
  add constraint PK_MR_REPORTEQUALIN primary key (CYEAR,VCREPORTCODE,ISORTID)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TMR_REPORTEQUALOUT
(
  CYEAR          CHAR(4) not null,
  VCREPORTCODE   VARCHAR2(10) not null,
  ISORTID        NUMBER not null,
  SIROWLABEL     NUMBER not null,
  SICOLLABEL     NUMBER not null,
  CCALCULATESIGN CHAR(2) not null,
  VCREPORTCODE2  VARCHAR2(10) not null,
  VCGETTIME      CHAR(10) not null,
  SIROWLABEL2    NUMBER not null,
  SICOLLABEL2    NUMBER not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TMR_REPORTEQUALOUT
  add constraint PK_MR_REPORTEQUALOUT primary key (CYEAR,VCREPORTCODE,ISORTID)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TMR_REPORTFORMULA
(
  CYEAR        CHAR(4) not null,
  VCREPORTCODE VARCHAR2(10) not null,
  SIROWLABEL   NUMBER not null,
  SICOLLABEL   NUMBER not null,
  VCFORMULA    VARCHAR2(2000) not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TMR_REPORTFORMULA
  add constraint PK_MR_REPORTFORMULA primary key (CYEAR,VCREPORTCODE,SIROWLABEL,SICOLLABEL)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TMR_REPORTHEAD
(
  CYEAR        CHAR(4) not null,
  VCREPORTCODE VARCHAR2(10) not null,
  SICOLLABEL   NUMBER not null,
  SIBANISTER   NUMBER not null,
  SICOLSERIAL  NUMBER not null,
  VCCOLNAME    VARCHAR2(30) not null,
  CDATATYPE    CHAR(4) not null,
  BGETDATACOL  NUMBER,
  MERGECOLID   NUMBER default 0 not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TMR_REPORTHEAD
  add constraint PK_MR_REPORTHEAD primary key (CYEAR,VCREPORTCODE,SICOLLABEL)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TMR_REPORTITEM
(
  CYEAR        CHAR(4) not null,
  VCREPORTCODE VARCHAR2(10) not null,
  SIROWLABEL   NUMBER not null,
  SICOLLABEL   NUMBER not null,
  VCITEMNAME   VARCHAR2(100) not null,
  BMERGE       NUMBER,
  BANALYSIS    NUMBER,
  SIITEMCLASS  NUMBER,
  VCITEMBM     VARCHAR2(10)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TMR_REPORTITEM
  add constraint PK_MR_REPORTITEM primary key (CYEAR,VCREPORTCODE,SIROWLABEL,SICOLLABEL)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TMR_REPORTMODE
(
  CYEAR        CHAR(4) not null,
  CMONTH       CHAR(2) not null,
  VCREPORTCODE VARCHAR2(50) not null,
  LCONTENT     LONG RAW,
  LENGTH       NUMBER(10) default 0 not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
alter table TMR_REPORTMODE
  add constraint PK_MR_REPORTMODE primary key (CYEAR,CMONTH,VCREPORTCODE)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TMR_TEMPLETDETAIL<<YEAR>>
(
  CCODE CHAR(3) not null,
  JLHM  NUMBER not null,
  PZZY  VARCHAR2(200),
  KMDM  VARCHAR2(40),
  KMMC  VARCHAR2(255),
  JFGS  VARCHAR2(255),
  DFGS  VARCHAR2(255)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
create table TMR_TEMPLETMAIN<<YEAR>>
(
  CCODE     CHAR(3) not null,
  VCCOMMENT VARCHAR2(50),
  CPZZL     VARCHAR2(20) not null,
  TIFJZS    NUMBER default 0               /*附件张数*/
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
create table TMR_WBHL
(
  ID   VARCHAR2(4) not null,
  KJNF NUMBER not null,
  KJQJ NUMBER not null,
  WBBZ VARCHAR2(10) not null,
  HLDM VARCHAR2(4) not null,
  HLMC VARCHAR2(10) not null,
  HL   NUMBER(10,6) default 1 not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
comment on column TMR_WBHL.ID
  is '标识号';
comment on column TMR_WBHL.KJNF
  is '会计年份';
comment on column TMR_WBHL.KJQJ
  is '会计期间';
comment on column TMR_WBHL.WBBZ
  is '外币币种';
comment on column TMR_WBHL.HLDM
  is '汇率代码';
comment on column TMR_WBHL.HLMC
  is '汇率名称';
comment on column TMR_WBHL.HL
  is '汇率';
alter table TMR_WBHL
  add constraint PK_MR_WBHL primary key (ID)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
create table TMR_ZYWH
(
  DMID VARCHAR2(10) not null,
  NAME VARCHAR2(200),
  KMDM VARCHAR2(40)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
create sequence S_OFFSET<<YEAR>>_ID
minvalue 1
maxvalue 9999999999
start with 1
increment by 1
nocache;

create sequence S_OFFSETASSISTANT<<YEAR>>_ID
minvalue 1
maxvalue 9999999999
start with 1
increment by 1
nocache;

create sequence S_OFFSETDATA<<YEAR>>_ID
minvalue 1
maxvalue 9999999999
start with 1
increment by 1
nocache;

create sequence S_OFFSETDRAFT<<YEAR>>_ID
minvalue 1
maxvalue 9999999999
start with 1
increment by 1
nocache;

create sequence S_OFFSETEQUAL<<YEAR>>_ID
minvalue 1
maxvalue 9999999999
start with 1
increment by 1
nocache;

create sequence S_OFFSETITEM<<YEAR>>_ID
minvalue 1
maxvalue 9999999999
start with 534
increment by 1
nocache;