sf.sql

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

create table TYSYF_BADACCOUNTKM<<YEAR>>
(
  KMDM   VARCHAR2(40) not null,
  KMMC   VARCHAR2(40),
  KMTYPE CHAR(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 TYSYF_BILLTYPE
(
  CCODE   CHAR(6) not null,
  CNAME   CHAR(40) not null,
  CNUMBER NUMBER not null,
  CYEAR   CHAR(4) not null,
  ISDQR   NUMBER default 0 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 TYSYF_BILLTYPE
  add constraint PK_YSYF_BILLTYPE 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 TYSYF_FZ<<YEAR>>
(
  ID         NUMBER not null,
  KMDM       VARCHAR2(40) not null,
  GRWL_CODE  CHAR(20),
  KHWL_CODE  CHAR(12),
  GYSWL_CODE CHAR(12),
  BMDM       CHAR(12),
  XMDM       CHAR(30),
  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 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TYSYF_FZ<<YEAR>>
  add constraint PK_YSYF_FZ<<YEAR>> primary key (ID)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
create table TYSYF_PZSJ<<YEAR>>
(
  CKIND        VARCHAR2(4) not null,
  DDATE        DATE not null,
  ACCESSORYNUM NUMBER,
  CBRIEF       CHAR(255),
  CJDPZ        CHAR(2) not null,
  CKMDM        CHAR(18) not null,
  JE           NUMBER(15,2) default 0,
  SL           NUMBER(15,4) default 0,
  WB           NUMBER(15,2) default 0,
  CZDNAME      CHAR(8),
  CSHNAME      CHAR(8),
  CBILLTYPE    CHAR(40),
  CBILLCODE    CHAR(30),
  CXMDM        CHAR(30),
  CBMDM        CHAR(12),
  CWORKCODE    CHAR(20),
  CCUSCODE     CHAR(12),
  CVENCODE     CHAR(12),
  HXFLAG       NUMBER default 0,
  HL           NUMBER(15,8),
  CPERSONCODE  CHAR(20),
  CBILLDATE    DATE,
  CPZCODE      CHAR(4) not null,
  CKMMC        CHAR(255) not null,
  RECORDCODE   NUMBER not null,
  KJQJ         NUMBER not null,
  MODIFYFLAG   CHAR(1) default ' ',
  HXDATE       DATE,
  QCFLAG       NUMBER default 0,
  CYSYFID      CHAR(8) default '00000000',
  MATURITY     DATE,
  CMATURITY    DATE
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 120K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TYSYF_PZSJ<<YEAR>>
  add constraint PK_YSYFPZSJ<<YEAR>> primary key (CKIND,DDATE,CPZCODE,RECORDCODE,CYSYFID)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );