gd.sql

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

create table TGD_YTXF
(
  KPBH  CHAR(25) not null,
  YTNY  CHAR(7) not null,
  BYYTE NUMBER(15,2),
  LJYT  NUMBER(15,2),
  ZYTE  NUMBER(15,2),
  YTYZ  NUMBER(15,2),
  TXQ   NUMBER(5) not null,
  NYTL  NUMBER(15,4)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 30K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

create table TGD_ZCBMFA
(
  BMFS  CHAR(1) not null,
  BMGZ  CHAR(1),
  XHCD  CHAR(1),
  BMFGF CHAR(1),
  ZXYZ  NUMBER(15,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 TGD_ZCBMZY
(
  KPBH    CHAR(25) not null,
  DJH     CHAR(10) not null,
  BDRQ    CHAR(10),
  JSR     CHAR(10),
  BDYY    CHAR(40),
  BDQBM   CHAR(20),
  BDQDD   CHAR(40),
  BDHBM   CHAR(20),
  BDHDD   CHAR(40),
  BDQBMBH CHAR(12),
  BDHBMBH CHAR(12),
  BDQZY   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 TGD_ZCDXJL
(
  KPBH CHAR(25) not null,
  DJH  CHAR(10) not null,
  KSRQ CHAR(10),
  JSRQ CHAR(10),
  XLYY CHAR(40),
  BZ   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 TGD_ZCFL
(
  DM CHAR(10) not null,
  MC VARCHAR2(30) 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 TGD_ZCFSSB
(
  KPBH CHAR(25) not null,
  SBBH CHAR(25) not null,
  SBMC CHAR(40),
  XH   CHAR(25),
  JZ   NUMBER(15,2),
  SL   NUMBER(5),
  DW   CHAR(10),
  SYRQ CHAR(10),
  BZ   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 TGD_ZCGZZLTZ
(
  KPBH    CHAR(25) not null,
  DJH     CHAR(10) not null,
  BDRQ    CHAR(10),
  JSR     CHAR(10),
  BDYY    CHAR(40),
  BDQGZZL NUMBER(15,4),
  BDHGZZL NUMBER(15,4),
  BDQYZJE NUMBER(15,2),
  BDQYZJL NUMBER(15,2),
  BDQZJFF VARCHAR2(40),
  BDQZY   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 TGD_ZCJCZLBD
(
  KPBH    CHAR(25) not null,
  DJH     CHAR(10) not null,
  BDRQ    CHAR(10),
  JSR     CHAR(10),
  BDYY    CHAR(40),
  BDQJCZ  NUMBER(15,2),
  BDHJCZ  NUMBER(15,2),
  BDQJCZL NUMBER(15,4),
  BDHJCZL NUMBER(15,4),
  BDQZY   CHAR(40),
  BDQZJFF 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 TGD_ZCJS
(
  KPBH  CHAR(25) not null,
  JSRQ  CHAR(10),
  JSFS  CHAR(20),
  QLSR  NUMBER(15,2),
  QLFY  NUMBER(15,2),
  QLYY  CHAR(40),
  JSR   CHAR(10),
  ZXRQ  CHAR(10),
  BDQZY CHAR(40)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 20K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

create table TGD_ZCJZZB
(
  KPBH     CHAR(25) not null,
  DJH      CHAR(10) not null,
  LJJZZB   NUMBER(18,2),
  YZ       NUMBER(18,2),
  LJZJ     NUMBER(18,2),
  JZJE     NUMBER(18,2),
  JSR      CHAR(10),
  BDRQ     CHAR(10),
  BDYY     CHAR(40),
  BDQZY    CHAR(40),
  BDQYZJE  NUMBER(15,2),
  BDQYZJL  NUMBER(15,6),
  BDQYZJFF VARCHAR2(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 TGD_ZCLB
(
  DM     VARCHAR2(10) not null,
  MC     VARCHAR2(20),
  SYNX   NUMBER(5),
  JLDW   CHAR(10),
  JTSX   CHAR(20),
  ZJFF   CHAR(20),
  KPYS   CHAR(20),
  ZCKM   CHAR(40),
  ZJKM   CHAR(40),
  TXQ    NUMBER(5),
  YTXFL  NUMBER(15,4),
  XFKM   CHAR(40),
  JZZBKM 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 TGD_ZCLBJS
(
  JC NUMBER(5) not null,
  WS NUMBER(5)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

create table TGD_ZCLBTZ
(
  KPBH      CHAR(25) not null,
  DJH       CHAR(10) not null,
  BDRQ      CHAR(10),
  JSR       CHAR(10),
  BDYY      CHAR(40),
  BDQZCLB   CHAR(20),
  BDHZCLB   CHAR(20),
  BDQZCLBBH CHAR(12),
  BDHZCLBBH CHAR(12),
  TXQ       NUMBER(5),
  YTFL      NUMBER(15,4),
  BDQZY     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 TGD_ZCLJZJTZ
(
  KPBH    CHAR(25) not null,
  DJH     CHAR(10) not null,
  BDRQ    CHAR(10),
  JSR     CHAR(10),
  BDYY    CHAR(40),
  BDQLJZJ NUMBER(15,2),
  BDHLJZJ NUMBER(15,2),
  BDQZY   CHAR(40),
  BDQYZJE NUMBER(15,2),
  BDQYZJL NUMBER(15,6),
  BDQZJFF 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 TGD_ZCPG
(
  KPBH    CHAR(25) not null,
  DJH     CHAR(10),
  PGQYZ   NUMBER(15,2),
  PGHYZ   NUMBER(15,2),
  PGQLJZJ NUMBER(15,2),
  PGHLJZJ NUMBER(15,2),
  PGQJZ   NUMBER(15,2),
  PGHJZ   NUMBER(15,2),
  PGQJCZL NUMBER(15,4),
  PGHJCZL NUMBER(15,4),
  PGQSYNX NUMBER(5),
  PGHSYNX NUMBER(5),
  PGQGZZL NUMBER(5),
  PGHGZZL NUMBER(5),
  PGQJZZB NUMBER(18),
  PGHJZZB NUMBER(18),
  PGRQ    CHAR(10) not null,