ty.sql

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

  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TUSU_SUBCOMPANY
  add constraint PK_USU_SUBCOMPANY primary key (CCODE)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TUSU_TABLEITEM /*10查询项目对照表*/
(
  CMODULE    VARCHAR2(3) not null,
  VCITEMCHI  VARCHAR2(30) not null,
  VCITEMENG  VARCHAR2(30) not null,
  VCITEMTYPE VARCHAR2(10) not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TUSU_TRADE/*11行业性质维护表*/
(
  VCNAME VARCHAR2(20) 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 TUSU_TRADE
  add constraint PK_USU_TRADE primary key (VCNAME)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TZW_KM<<YEAR>> /*12用点来分隔科目代码，并且把科目表拆分成科目表和科目余额表*/
(
  KMDM      VARCHAR2(40) not null,
  KMMC      VARCHAR2(40),
  KMMCENG   VARCHAR2(80),
  ZJM       VARCHAR2(4),
  KMLX      VARCHAR2(20) not null,
  KMJC      NUMBER not null,
  ISENDKM   NUMBER default -1,
  YEFX      CHAR(4) not null,
  ZYGS      VARCHAR2(10) default '金额式',
  HZDYKM    VARCHAR2(18),
  SLDW      VARCHAR2(10),
  WBDW      VARCHAR2(10),
  ISRJZ     NUMBER default 0,
  ISYHZ     NUMBER default 0,
  ISGRWLHS  NUMBER default 0,
  ISKHWLHS  NUMBER default 0,
  ISGYSWLHS NUMBER default 0,
  ISBMHS    NUMBER default 0,
  ISXMHS    NUMBER default 0,
  ISXJLLKM  NUMBER default 0,
  XJLLLB    VARCHAR2(10),
  JFKZE     NUMBER(15,2),
  DFKZE     NUMBER(15,2),
  YEKZE     NUMBER(15,2),
  KMQX      NUMBER default 0,
  CWFXLX    VARCHAR2(20),
  ISFC      NUMBER default 0,
  BUSE      NUMBER default 0,
  BADD      NUMBER default -1,
  CLAWLESS  VARCHAR2(255)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 60K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TZW_KM<<YEAR>>
  add constraint PK_ZW_KM<<YEAR>> primary key (KMDM)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 30K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TZW_BALANCE<<YEAR>> /*13科目余额表*/
(
  KMDM    VARCHAR2(40) not null,
  KMMC    VARCHAR2(40) not null,
  YEFX    CHAR(4) not null,
  BZ      VARCHAR2(10) default '人民币' not null,
  LJJSL00 NUMBER(15,3) default 0 not null,
  LJJWB00 NUMBER(15,2) default 0 not null,
  LJJ00   NUMBER(15,2) default 0 not null,
  LJDSL00 NUMBER(15,3) default 0 not null,
  LJDWB00 NUMBER(15,2) default 0 not null,
  LJD00   NUMBER(15,2) default 0 not null,
  LJJSL01 NUMBER(15,3) default 0 not null,
  LJJWB01 NUMBER(15,2) default 0 not null,
  LJJ01   NUMBER(15,2) default 0 not null,
  LJDSL01 NUMBER(15,3) default 0 not null,
  LJDWB01 NUMBER(15,2) default 0 not null,
  LJD01   NUMBER(15,2) default 0 not null,
  LJJSL02 NUMBER(15,3) default 0 not null,
  LJJWB02 NUMBER(15,2) default 0 not null,
  LJJ02   NUMBER(15,2) default 0 not null,
  LJDSL02 NUMBER(15,3) default 0 not null,
  LJDWB02 NUMBER(15,2) default 0 not null,
  LJD02   NUMBER(15,2) default 0 not null,
  LJJSL03 NUMBER(15,3) default 0 not null,
  LJJWB03 NUMBER(15,2) default 0 not null,
  LJJ03   NUMBER(15,2) default 0 not null,
  LJDSL03 NUMBER(15,3) default 0 not null,
  LJDWB03 NUMBER(15,2) default 0 not null,
  LJD03   NUMBER(15,2) default 0 not null,
  LJJSL04 NUMBER(15,3) default 0 not null,
  LJJWB04 NUMBER(15,2) default 0 not null,
  LJJ04   NUMBER(15,2) default 0 not null,
  LJDSL04 NUMBER(15,3) default 0 not null,
  LJDWB04 NUMBER(15,2) default 0 not null,
  LJD04   NUMBER(15,2) default 0 not null,
  LJJSL05 NUMBER(15,3) default 0 not null,
  LJJWB05 NUMBER(15,2) default 0 not null,
  LJJ05   NUMBER(15,2) default 0 not null,
  LJDSL05 NUMBER(15,3) default 0 not null,
  LJDWB05 NUMBER(15,2) default 0 not null,
  LJD05   NUMBER(15,2) default 0 not null,
  LJJSL06 NUMBER(15,3) default 0 not null,
  LJJWB06 NUMBER(15,2) default 0 not null,
  LJJ06   NUMBER(15,2) default 0 not null,
  LJDSL06 NUMBER(15,3) default 0 not null,
  LJDWB06 NUMBER(15,2) default 0 not null,
  LJD06   NUMBER(15,2) default 0 not null,
  LJJSL07 NUMBER(15,3) default 0 not null,
  LJJWB07 NUMBER(15,2) default 0 not null,
  LJJ07   NUMBER(15,2) default 0 not null,
  LJDSL07 NUMBER(15,3) default 0 not null,
  LJDWB07 NUMBER(15,2) default 0 not null,
  LJD07   NUMBER(15,2) default 0 not null,
  LJJSL08 NUMBER(15,3) default 0 not null,
  LJJWB08 NUMBER(15,2) default 0 not null,
  LJJ08   NUMBER(15,2) default 0 not null,
  LJDSL08 NUMBER(15,3) default 0 not null,
  LJDWB08 NUMBER(15,2) default 0 not null,
  LJD08   NUMBER(15,2) default 0 not null,
  LJJSL09 NUMBER(15,3) default 0 not null,
  LJJWB09 NUMBER(15,2) default 0 not null,
  LJJ09   NUMBER(15,2) default 0 not null,
  LJDSL09 NUMBER(15,3) default 0 not null,
  LJDWB09 NUMBER(15,2) default 0 not null,
  LJD09   NUMBER(15,2) default 0 not null,
  LJJSL10 NUMBER(15,3) default 0 not null,
  LJJWB10 NUMBER(15,2) default 0 not null,
  LJJ10   NUMBER(15,2) default 0 not null,
  LJDSL10 NUMBER(15,3) default 0 not null,
  LJDWB10 NUMBER(15,2) default 0 not null,
  LJD10   NUMBER(15,2) default 0 not null,
  LJJSL11 NUMBER(15,3) default 0 not null,
  LJJWB11 NUMBER(15,2) default 0 not null,
  LJJ11   NUMBER(15,2) default 0 not null,
  LJDSL11 NUMBER(15,3) default 0 not null,
  LJDWB11 NUMBER(15,2) default 0 not null,
  LJD11   NUMBER(15,2) default 0 not null,
  LJJSL12 NUMBER(15,3) default 0 not null,
  LJJWB12 NUMBER(15,2) default 0 not null,
  LJJ12   NUMBER(15,2) default 0 not null,
  LJDSL12 NUMBER(15,3) default 0 not null,
  LJDWB12 NUMBER(15,2) default 0 not null,
  LJD12   NUMBER(15,2) default 0 not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 150K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create unique index PK_ZW_BALANCE<<YEAR>> on TZW_BALANCE<<YEAR>> (KMDM,BZ)
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 30K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TZZRY /*14职工岗位变动表*/
(
  ZGBH    CHAR(20) not null,
  BMBH    CHAR(12),
  BMMC    CHAR(20),
  ZGXM    CHAR(20),
  GZZH    CHAR(20),
  ZZ      CHAR(4),
  SFZH    CHAR(18),
  XB      CHAR(2),
  MZ      CHAR(20),
  JGBH    CHAR(6),
  JG      CHAR(40),
  CSRQ    DATE,
  NL      NUMBER default 0,
  HY      CHAR(10),
  GRSF    CHAR(10),
  ZZMM    CHAR(10),
  SHBZH   CHAR(20),
  YLZHH   CHAR(20),
  GRYHZH  CHAR(20),
  GRYHDH  CHAR(2),
  WHCD    CHAR(10),
  BYYX    CHAR(40),
  BYSJ    DATE,
  ZY      CHAR(20),
  XW      CHAR(10),
  YZ      CHAR(10),
  CJGZSJ  DATE,
  JRBDWSJ DATE,
  GL      NUMBER default 0,
  RYFL    CHAR(20),
  GWGZ    CHAR(20),
  JSZC    CHAR(10),
  GZJB    CHAR(10),
  XZZW    CHAR(20),
  JTZZ    CHAR(40),
  YB      CHAR(6),
  DHHM    CHAR(40),
  HKSZD   CHAR(40),
  HKXZ    CHAR(10),
  GADQS   CHAR(10),
  LGQK    CHAR(10),
  LGSJ    DATE,
  XGFL    CHAR(10),
  XGSJ    DATE,
  BQYGL   NUMBER default 0,
  HTBZ    NUMBER default 0,
  GZLBID  NUMBER,
  KHH     CHAR(25),
  ZPFILE  CHAR(80),
  DADH    CHAR(20),
  KMDM    CHAR(40),
  TFNY    CHAR(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 TRS_TZZRY
  add constraint PK_RS_TZZRY primary key (ZGBH)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TJGDM /*15籍贯维护表*/
(
  CODE CHAR(6) not null,
  NAME CHAR(40),
  USED NUMBER default 0
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 220K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TRS_TJGDM
  add constraint PK_RS_TJGDM primary key (CODE)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 80K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TCON_DAITEM /*16数据备份-数据表清单*/
(
  CITMSYSCODING  CHAR(2) not null,
  CITMDACODING   VARCHAR2(8) not null,
  VCITMDACAPTION VARCHAR2(30),
  VCITMDANAME    VARCHAR2(30),
  CITMDAEDITION  CHAR(6),
  VCITMSYNOSIS   VARCHAR2(50),
  DITMREMOVE     DATE
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 20K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );