⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 gd.sql

📁 一个用VB写的财务软件源码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
  JSR     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 50
  );

create table TGD_ZCSYNXTZ
(
  KPBH    CHAR(25) not null,
  DJH     CHAR(10) not null,
  BDRQ    CHAR(10),
  JSR     CHAR(10),
  BDYY    CHAR(40),
  BZ      CHAR(40),
  BDQSYNX NUMBER(5),
  BDHSYNX NUMBER(5),
  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_ZCTQYJL
(
  KPBH CHAR(25) not null,
  DJH  CHAR(10) not null,
  TYRQ CHAR(10),
  QYRQ CHAR(10),
  TYYY 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_ZCYZBD
(
  KPBH    CHAR(25) not null,
  BDLX    NUMBER(5) not null,
  DJH     CHAR(10) not null,
  BDRQ    CHAR(10),
  JSR     CHAR(10),
  BDYY    CHAR(40),
  BDJE    NUMBER(15,2),
  BDQJCZL NUMBER(15,4),
  BDHJCZL NUMBER(15,2),
  BDQYZ   NUMBER(15,2),
  BDQJCZ  NUMBER(15,2),
  BIZ     CHAR(10),
  HL      NUMBER(15,4),
  ZJLY    CHAR(30),
  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_ZCZJFFTZ
(
  KPBH    CHAR(25) not null,
  DJH     CHAR(10) not null,
  BDRQ    CHAR(10),
  JSR     CHAR(10),
  BDYY    CHAR(40),
  BDQZJFF CHAR(20),
  BDHZJFF CHAR(20),
  BDQZY   CHAR(40),
  BDQYZJE NUMBER(15,2),
  BDQYZJL NUMBER(15,6),
  BDQBJ   CHAR(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_ZCZJGS
(
  GSMC CHAR(20),
  YZLZ CHAR(200),
  YZLC CHAR(200),
  YZEZ CHAR(200),
  YZEC CHAR(200),
  FLAG CHAR(2)
)
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_ZCZTBD
(
  KPBH      CHAR(25) not null,
  DJH       CHAR(10) not null,
  BDRQ      CHAR(10),
  JSR       CHAR(10),
  BDYY      CHAR(40),
  BDQSYZK   CHAR(20),
  BDHSYZK   CHAR(20),
  BDQSYZKBH CHAR(4),
  BDHSYZKBH CHAR(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_ZDYBB
(
  ID      NUMBER(5) not null,
  BBMC    CHAR(20) not null,
  ITEM    CHAR(20),
  ITEMENG CHAR(40),
  ISFLXM  NUMBER(5) not null,
  SYFLAG  CHAR(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_ZJFS
(
  DM     CHAR(3) not null,
  MC     CHAR(20),
  DYRZKM 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_ZJGSXM
(
  XMMC CHAR(20),
  CODE 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 TGD_ZJJT
(
  KPBH   CHAR(25) not null,
  TIME   CHAR(7) not null,
  JTYZ   NUMBER(15,2),
  JTJCZ  NUMBER(15,2),
  JTSYNX NUMBER(5),
  BYZJ   NUMBER(15,2),
  BNLJZJ NUMBER(15,2),
  LJZJ   NUMBER(15,2),
  FPBMMC CHAR(20),
  ZJKMMC CHAR(40),
  ZCLBMC VARCHAR2(20),
  ZJRQ   CHAR(10),
  JSR    CHAR(10),
  HXBZ   NUMBER(5),
  FPXMMC CHAR(40),
  YZJL   NUMBER(15,6)
  DWZJ   NUMBER(18,2)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 520K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

create table TGD_ZJJTYZ
(
  JTYZ CHAR(10),
  SZRQ CHAR(10)
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );

INSERT INTO TGD_ASSETSORIGIN (CCODE,VCNAME)
VALUES ('01','自有资金');
INSERT INTO TGD_ASSETSORIGIN (CCODE,VCNAME)
VALUES ('02','对外筹资');
INSERT INTO TGD_ASSETSORIGIN (CCODE,VCNAME)
VALUES ('0201','银行借款');
INSERT INTO TGD_ASSETSORIGIN (CCODE,VCNAME)
VALUES ('0202','其他');

INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (54,'TGD_GDZCKP','固定资产卡片','预提修费科目','1','XFKM',40,NULL,0,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (7,'TGD_GDZCKP','固定资产卡片','类别编号','1','LBBH',10,NULL,-1,-1,0,'006');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (9,'TGD_GDZCKP','固定资产卡片','外币原值','2','WBYZ',15,2,-1,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (13,'TGD_GDZCKP','固定资产卡片','净残值','2','JCZ',15,2,-1,-1,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (15,'TGD_GDZCKP','固定资产卡片','开始使用日期','3','KSSYRQ',NULL,NULL,-1,-1,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (18,'TGD_GDZCKP','固定资产卡片','月折旧率','2','YZJL',15,4,-1,-1,0,'011');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (52,'TGD_GDZCKP','固定资产卡片','资金来源编号','1','ZJLYBM',2,NULL,-1,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (19,'TGD_GDZCKP','固定资产卡片','月折旧额','2','YZJE',15,2,-1,-1,0,'015');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (17,'TGD_GDZCKP','固定资产卡片','折旧方法','1','ZJFF',20,NULL,-1,-1,0,'010');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (21,'TGD_GDZCKP','固定资产卡片','累计折旧','2','LJZJ',15,2,-1,-1,0,'009');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (16,'TGD_GDZCKP','固定资产卡片','使用年限','2','SYNX',5,0,-1,-1,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (23,'TGD_GDZCKP','固定资产卡片','币种','1','BIZ',10,NULL,-1,-1,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (24,'TGD_GDZCKP','固定资产卡片','币种单位','1','BZDW',10,NULL,-1,-1,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (27,'TGD_GDZCKP','固定资产卡片','对应折旧科目','1','DYZJKM',40,NULL,-1,-1,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (26,'TGD_GDZCKP','固定资产卡片','折旧科目','1','ZJKM',40,NULL,-1,-1,1,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (1,'TGD_GDZCKP','固定资产卡片','卡片编号','1','KPBH',25,NULL,-1,-1,0,'004');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (33,'TGD_GDZCKP','固定资产卡片','注销人','1','ZXR',10,NULL,-1,0,0,'012');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (35,'TGD_GDZCKP','固定资产卡片','录入人','1','LRR',10,NULL,-1,-1,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (39,'TGD_GDZCKP','固定资产卡片','汇率','2','HL',15,4,-1,0,-1,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (45,'TGD_GDZCKP','固定资产卡片','电机数量','2','DJSL',5,0,-1,0,-1,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (49,'TGD_GDZCKP','固定资产卡片','摊销期','2','TXQ',38,NULL,-1,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (14,'TGD_GDZCKP','固定资产卡片','净值','2','JZ',15,2,-1,-1,0,'016');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (50,'TGD_GDZCKP','固定资产卡片','资产分类编号','1','ZCFLDM',10,NULL,-1,0,0,'014');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (51,'TGD_GDZCKP','固定资产卡片','资产分类名称','1','ZCFLMC',30,NULL,-1,0,0,'013');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (53,'TGD_GDZCKP','固定资产卡片','资金来源名称','1','ZJLYMC',30,NULL,-1,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (55,'TGD_GDZCKP','固定资产卡片','对应预提修费科目','1','XFDFKM',40,NULL,0,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (56,'TGD_GDZCKP','固定资产卡片','对应核算项目','1','FPXMMC',30,NULL,0,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (28,'TGD_GDZCKP','固定资产卡片','工作量单位','1','GZLDW',10,NULL,-1,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (2,'TGD_GDZCKP','固定资产卡片','固定资产编号','1','GDZCBH',20,NULL,-1,-1,-1,'004');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (3,'TGD_GDZCKP','固定资产卡片','固定资产名称','1','GDZCMC',40,NULL,-1,-1,-1,'004');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (5,'TGD_GDZCKP','固定资产卡片','部门名称','1','BMMC',20,NULL,-1,-1,0,'004');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (4,'TGD_GDZCKP','固定资产卡片','部门编号','1','BMBH',25,NULL,-1,-1,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (6,'TGD_GDZCKP','固定资产卡片','存放地点','1','CFDD',40,NULL,-1,-1,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (8,'TGD_GDZCKP','固定资产卡片','类别名称','1','LBMC',20,NULL,-1,-1,0,'008');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (10,'TGD_GDZCKP','固定资产卡片','原值','2','YZ',15,2,-1,-1,0,'007');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (12,'TGD_GDZCKP','固定资产卡片','净残值率','2','JCZL',15,4,-1,-1,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (48,'TGD_GDZCKP','固定资产卡片','月预提修费额','2','YTFY',15,2,0,0,0,'999');
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (105,'TGD_DEPARTMENT2003','部门','部门电话','1','CDEPPHONE',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
VALUES (108,'TGD_DEPARTMENT2003','部门','对应折旧科目','1','CGDKM',20,0,0,0,0,NULL);
INSERT INTO TGD_KPXM (ID,EBIAOM,CBIAOM,XMMC,LX,BMMC,ZSCD,XSCD,XT,BB,KXG,CXXM)
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -