rs.sql

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

  MONTH 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_TZGGS
(
  ZGBH    CHAR(20) not null,
  GSXM    CHAR(4),
  COUNTER 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_TZGGSF
(
  ZGBH    CHAR(20),
  FLDDATE DATE,
  DWFDFY  NUMBER(9,2),
  TCFDFY  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_TZGGSHZ
(
  ZGBH    CHAR(20) not null,
  DLBZTG  NUMBER(9,2),
  YCLQFTG NUMBER(9,2),
  SBJCTG  NUMBER(9,2),
  WSCRWTG NUMBER(9,2),
  HD      NUMBER(9,2),
  XX      NUMBER(9,2),
  JJRJB   NUMBER(9,2),
  GZRJB   NUMBER(9,2),
  GXJJB   NUMBER(9,2),
  MONTH   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_TZGGW
(
  ZGBH    CHAR(20) not null,
  GWMC    CHAR(20),
  GWDM    CHAR(4),
  COUNTER 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_TZGGWHZ
(
  ZGBH    CHAR(20) not null,
  GWDM    CHAR(4),
  GWMC    CHAR(20),
  COUNTER NUMBER(9,2),
  MONTH   CHAR(7),
  GZHF    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_TZGKQ
(
  ZGBH    CHAR(20) not null,
  KQXM    CHAR(4),
  COUNTER 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_TZGKQHZ
(
  ZGBH  CHAR(20) not null,
  KGCS  NUMBER(9,2),
  KGSS  NUMBER(9,2),
  CDCS  NUMBER(9,2),
  CDSS  NUMBER(9,2),
  ZTCS  NUMBER(9,2),
  ZTSS  NUMBER(9,2),
  MONTH 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_TZGQJ
(
  ZGBH    CHAR(20) not null,
  QJXM    CHAR(4),
  COUNTER 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_TZGQJHZ
(
  ZGBH  CHAR(20) not null,
  BJ    NUMBER(9,2),
  SJ    NUMBER(9,2),
  GJ    NUMBER(9,2),
  GXJ   NUMBER(9,2),
  JJ    NUMBER(9,2),
  TQJ   NUMBER(9,2),
  HJ    NUMBER(9,2),
  SAJ   NUMBER(9,2),
  BLJ   NUMBER(9,2),
  CJ    NUMBER(9,2),
  GSJ   NUMBER(9,2),
  NXJ   NUMBER(9,2),
  MONTH 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_TZGSYF
(
  ZGBH    CHAR(20),
  FLDDATE DATE,
  DWFDFY  NUMBER(9,2),
  TCFDFY  NUMBER(9,2),
  GRFDFY  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_TZGYLF
(
  ZGBH    CHAR(20),
  FLDDATE DATE,
  DWFDFY  NUMBER(9,2),
  TCFDFY  NUMBER(9,2),
  GRFDFY  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_TZGZFF
(
  ZGBH    CHAR(20),
  FLDDATE DATE,
  ZFGJJ   NUMBER(9,2),
  ZFFZF   NUMBER(9,2),
  JFZC    NUMBER(9,2),
  XSF     NUMBER(9,2),
  ZFBT    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_TZGZS
(
  ZGBH CHAR(20),
  ZSH  CHAR(25),
  ZSLB CHAR(10),
  FZRQ DATE,
  YXNX NUMBER,
  DQSJ DATE,
  FZJG CHAR(30),
  RRSJ DATE,
  BZ   CHAR(50)
)
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_TZZRYGW
(
  ZGBH CHAR(20) not null,
  GWMC CHAR(20),
  BDSJ DATE,
  BDFS CHAR(10),
  BDSM CHAR(40)
)
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_TZZRYGZ
(
  ZGBH   CHAR(20) not null,
  YGZJE  NUMBER(15,2),
  XGZJE  NUMBER(15,2),
  BDPZSJ DATE,
  BDJS   NUMBER,
  BDJE   NUMBER(15,2),
  TZSJ   DATE,
  YJWJ   CHAR(40)
)
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_TZZRYJF
(
  ZGBH CHAR(20) not null,
  JZZL CHAR(20),
  JZRQ DATE,
  JZYY CHAR(40),
  PZDW CHAR(40),
  JCRQ DATE,
  JCYY CHAR(40)
)
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_TZZRYJL
(
  ZGBH CHAR(20) not null,
  QSSJ DATE,
  ZZSJ DATE,
  SZDW CHAR(40),
  CSGZ CHAR(20),
  DRZW CHAR(20),
  ZMR  CHAR(8)
)
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_TZZRYJS
(
  ZGBH   CHAR(20) not null,
  ZYJSMC CHAR(20),
  QDFS   CHAR(10),
  QDSJ   DATE,
  PRZW   CHAR(20),
  PRQSSJ DATE,
  PRZZSJ DATE,
  PRDW   CHAR(40),
  SPDW   CHAR(40)
)
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_TZZRYJT
(
  ZGBH CHAR(20) not null,
  XM   CHAR(20),
  GX   CHAR(10),
  CSRQ DATE,
  GZDW CHAR(40),
  ZW   CHAR(20),
  ZZMM CHAR(10),
  LXDH CHAR(40)
)
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_TZZRYPS
(
  ZGBH   CHAR(20) not null,
  PXFS   CHAR(10),
  QSSJ   DATE,
  JSSJ   DATE,
  PXQX   NUMBER,
  ZY     CHAR(20),
  PXDWMC CHAR(40),
  PXNR   CHAR(40),
  PXJF   NUMBER(15,2),
  PXJG   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_TZZRYWJ
(
  ZGBH CHAR(20) not null,
  GZJL 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_TZZRYXX
(
  ZGBH CHAR(20) not null,
  SJ   DATE,
  LB   CHAR(20),
  RR   CHAR(100),
  BZ   CHAR(50)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );