cf.sql

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

create table TCF_ITEM
(
  SIYEAR     NUMBER not null,
  CTYPECODE  CHAR(2) not null,
  CITEMCODE  CHAR(2) not null,
  VCITEMNAME VARCHAR2(60),
  BFLOWIN    NUMBER,
  IROW       NUMBER,
  BUSED      NUMBER default 0,
  BSYSDEF    NUMBER default 0,
  BMAYAPPEND NUMBER default -1,
  BFORMULA   NUMBER default 0,      /*是否用公式计算*/
  BALLOWEDIT NUMBER default -1 /* 是否允许填入拆分数据 */
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TCF_ITEM
  add constraint PK_CF_ITEM primary key (SIYEAR,CTYPECODE,CITEMCODE)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TCF_ONEONE<<YEAR>>
(
  TIORIGINKJQJ   NUMBER not null,
  CORIGINPZZL    CHAR(4) not null,
  CORIGINPZBH    CHAR(4) not null,
  DORIGINPZRQ    DATE not null,
  BSPECIAL       NUMBER not null,
  SISUBID        NUMBER not null,
  SIONEONEID     NUMBER,
  CFX            CHAR(2),
  DEJE           NUMBER(15,2) default 0,
  CKMDM          VARCHAR2(40),
  CKMMC          VARCHAR2(255),
  CPZZY          VARCHAR2(200),
  CFX2           CHAR(2),
  DEJE2          NUMBER(15,2) default 0,
  CKMDM2         VARCHAR2(40),
  CKMMC2         VARCHAR2(255),
  CPZZY2         VARCHAR2(200),
  CCASHDIRECTION CHAR(2),
  CITEMCODE      CHAR(4),
  DEITEMJE       NUMBER(15,2) default 0,
  BSPLITFLAG     NUMBER not null,
  BRIGHT         NUMBER default -1,
  CFHRMCODE      VARCHAR2(4),
  CFHRMNAME      CHAR(8)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 100K
    next 10K
    minextents 1
    maxextents 1024
    pctincrease 0
  );
create table TCF_REPORTDATA
(
  SIYEAR     NUMBER not null,
  TIPERIOD   NUMBER not null,
  VCCODE     VARCHAR2(4) not null,
  VCNAME     VARCHAR2(100),
  MVALUE     NUMBER(15,2) default 0,
  IROW       NUMBER,
  VCTYPENAME VARCHAR2(40)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 40K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TCF_REPORTDATA
  add constraint PK_CF_REPORTDATA primary key (SIYEAR,TIPERIOD,VCCODE)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 30K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TCF_SOURCE
(
  SIYEAR           NUMBER not null,
  CTYPECODE        CHAR(2) not null,
  CITEMCODE        CHAR(2) not null,
  TISTEP           NUMBER not null,
  CSYMBOL          CHAR(1) default '+',
  VCGETMETHOD      VARCHAR2(10),
  VCFORMULANAME    VARCHAR2(20),
  VCFORMULANAMEENG VARCHAR2(20),
  VCCOMMENT        VARCHAR2(100),
  VCFORMULA        VARCHAR2(200),
  MVALUE           NUMBER(15,2)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 20K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TCF_SOURCE
  add constraint PK_CF_SOURCE primary key (SIYEAR,CTYPECODE,CITEMCODE,TISTEP)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 20K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TCF_SPLITRESULT
(
  ID           VARCHAR2(38) not null,
  SIYEAR       NUMBER not null,
  TIORIGINKJQJ NUMBER not null,
  CORIGINPZZL  CHAR(4) not null,
  CORIGINPZBH  CHAR(4) not null,
  DORIGINPZRQ  DATE not null,
  SISUBID      NUMBER not null,
  SIORIGINJLHM NUMBER not null,
  CKMDM        VARCHAR2(40),
  CKMMC        VARCHAR2(255),
  CPZZY        VARCHAR2(200),
  CFX          CHAR(2),
  DEJE         NUMBER(15,2) default 0   /*金额*/
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 60K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );