rs.sql

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

create table TRS_TBJSJ
(
  SYBJ NUMBER,
  HTBJ NUMBER,
  ZSDQ NUMBER
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TBMDYMX
(
  BMDM CHAR(12),
  GWDM CHAR(20),
  RS   NUMBER default 0,
  RERS NUMBER default 0
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TBXJFBL
(
  ZGBH   CHAR(20) not null,
  DWJBYL NUMBER(9,2),
  DWBCYL NUMBER(9,2),
  DWYL   NUMBER(9,2),
  DWSY   NUMBER(9,2),
  DWSYU  NUMBER(9,2),
  DWGS   NUMBER(9,2),
  DWQT   NUMBER(9,2),
  GRJBYL NUMBER(9,2),
  GRBCYL NUMBER(9,2),
  GRYL   NUMBER(9,2),
  GRSY   NUMBER(9,2),
  GRQT   NUMBER(9,2)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TBXJFDW
(
  ZGBH CHAR(20) not null,
  JBYL NUMBER(9,2),
  BCYL NUMBER(9,2),
  YL   NUMBER(9,2),
  SY   NUMBER(9,2),
  SYU  NUMBER(9,2),
  GS   NUMBER(9,2),
  QT   NUMBER(9,2)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TBXJFDWJ
(
  ZGBH CHAR(20) not null,
  JS   NUMBER(9,2) default 0
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TBXJFGR
(
  ZGBH CHAR(20) not null,
  JBYL NUMBER(9,2),
  BCYL NUMBER(9,2),
  YL   NUMBER(9,2),
  SY   NUMBER(9,2),
  QT   NUMBER(9,2)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TBXJFGRJ
(
  ZGBH CHAR(20) not null,
  JS   NUMBER(9,2) default 0
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TBZDDY
(
  TABLENAME CHAR(20) not null,
  FIELDNAME CHAR(30) not null,
  CODE      CHAR(10) not null,
  STYLE     CHAR(10) not null
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 50K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TCKD
(
  BMBH CHAR(12),
  LBMC CHAR(30),
  LBDM CHAR(25),
  SLDW CHAR(10),
  CKSL NUMBER,
  JSR  CHAR(10),
  LLR  CHAR(10),
  SLRQ DATE,
  DJ   NUMBER(18),
  JE   NUMBER(18)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TFLZJSR
(
  FLDDATE DATE,
  FLJJ    NUMBER(9,2),
  LRLC    NUMBER(9,2),
  GHWJF   NUMBER(9,2),
  GLFZC   NUMBER(9,2),
  YYWZC   NUMBER(9,2),
  QTLY    NUMBER(9,2)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TFLZJZC
(
  FLDDATE DATE,
  JTFLBT  NUMBER(9,2),
  JTFLSS  NUMBER(9,2),
  JHSYBT  NUMBER(9,2),
  SZWXJJ  NUMBER(9,2),
  SHKNBT  NUMBER(9,2),
  WTXC    NUMBER(9,2),
  DJQNBT  NUMBER(9,2),
  JT      NUMBER(9,2),
  XLWS    NUMBER(9,2),
  QTFY    NUMBER(9,2)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_THTJC
(
  ZGBH   CHAR(20),
  SHBZ   NUMBER(18),
  DYQX   CHAR(20),
  YLBZ   NUMBER(18),
  JJBS   NUMBER(18),
  TXRQ   DATE,
  JBR    CHAR(10),
  SJZZRQ DATE
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_THTSJ
(
  HTBH   CHAR(15) not null,
  ZGBH   CHAR(20),
  YGWGZ  CHAR(20),
  SYQ    DATE,
  GZ     NUMBER(18),
  QDRQ   DATE,
  SXRQ   DATE,
  SYQMRQ DATE,
  HTNX   NUMBER,
  HTZZRQ DATE,
  HTZL   CHAR(20),
  QQSDW  CHAR(30),
  YXBZ   NUMBER default 0
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TJLQ
(
  ZGBH   CHAR(20),
  YLQ    NUMBER,
  YYLQ   NUMBER,
  JZRQ   DATE,
  YLLJ   NUMBER,
  YLQMQX CHAR(40),
  SCBXRQ DATE
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TLDSJSZ
(
  LRFS   NUMBER,
  KQJLDW NUMBER,
  GSJLDW NUMBER,
  DEJLDW NUMBER,
  HZRQ   NUMBER,
  BLYS   NUMBER
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TLDZY
(
  LX     CHAR(1),
  SSZGXM CHAR(20),
  SSRDW  CHAR(20),
  SSDB   CHAR(20),
  JSRDW  CHAR(20),
  SSRS   NUMBER,
  SLJG   CHAR(20),
  CLFS   CHAR(20),
  SSRQ   DATE,
  SLRQ   DATE,
  CLJSRQ DATE,
  SSYY   CHAR(20),
  CLJG   CHAR(20)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TLKD
(
  BMBH CHAR(12),
  LBMC CHAR(30),
  LBDM CHAR(25),
  SLDW CHAR(10),
  JKSL NUMBER,
  DJJE NUMBER(18),
  ZE   NUMBER(18),
  JSR  CHAR(10),
  SRRQ DATE
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TQTDM
(
  CODE CHAR(4) not null,
  NAME CHAR(20) not null,
  USED NUMBER default 0
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TRSCX
(
  BT CHAR(50) not null,
  LR VARCHAR2(255)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TYLJL
(
  ZGBH  CHAR(20),
  BXKJ  DATE,
  BXZZ  DATE,
  LJBXS NUMBER,
  BQZY  CHAR(50),
  JRR   CHAR(10)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TYPKC
(
  LBDM CHAR(25) not null,
  LBMC CHAR(30),
  SLDW CHAR(10),
  KCL  NUMBER
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TZGDE
(
  ZGBH CHAR(20) not null,
  XH   CHAR(20),
  TH   CHAR(20),
  MC   CHAR(20),
  GX   CHAR(20),
  SJSL NUMBER(9,2),
  DJGS NUMBER(9,2),
  DEGS NUMBER(9,2),
  SZGS NUMBER(9,2),
  TIME CHAR(10)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
create table TRS_TZGDEHZ
(
  ZGBH  CHAR(20) not null,
  XH    CHAR(20),
  TH    CHAR(20),
  MC    CHAR(20),
  GX    CHAR(20),
  SJSL  NUMBER(9,2),
  DJGS  NUMBER(9,2),
  DEGS  NUMBER(9,2),
  SZGS  NUMBER(9,2),