?? 財務管理系統.sql

?? 企業財務管理程序
?? SQL
?? 第 1 頁 / 共 2 頁
字號:
12 下一頁
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[分錄表_憑證編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[分錄表] DROP CONSTRAINT 分錄表_憑證編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[分錄表_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[分錄表] DROP CONSTRAINT 分錄表_科目代碼_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[本年分類帳簿_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[本年分類帳簿] DROP CONSTRAINT 本年分類帳簿_科目代碼_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[本年明細帳簿_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[本年明細帳簿] DROP CONSTRAINT 本年明細帳簿_科目代碼_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[本期分類帳簿_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[本期分類帳簿] DROP CONSTRAINT 本期分類帳簿_科目代碼_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[本期明細帳簿_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[本期明細帳簿] DROP CONSTRAINT 本期明細帳簿_科目代碼_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[分錄表temp_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[分錄表temp] DROP CONSTRAINT 分錄表temp_科目代碼_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[分錄表歷史_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[分錄表歷史] DROP CONSTRAINT 分錄表歷史_科目代碼_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[科目余額表_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[科目余額表] DROP CONSTRAINT 科目余額表_科目代碼_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[歷史分類帳簿_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[歷史分類帳簿] DROP CONSTRAINT 歷史分類帳簿_科目代碼_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[歷史明細帳簿_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[歷史明細帳簿] DROP CONSTRAINT 歷史明細帳簿_科目代碼_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[項目科目對照表_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[項目科目對照表] DROP CONSTRAINT 項目科目對照表_科目代碼_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_pz憑證刪除后]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_pz憑證刪除后]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_pz憑證錄入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_pz憑證錄入]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_pz憑證過帳]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_pz憑證過帳]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_pz調整憑證表]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_pz調整憑證表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[憑證表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[憑證表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[憑證表temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[憑證表temp]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[憑證表歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[憑證表歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[分錄表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[分錄表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[分錄表temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[分錄表temp]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[分錄表歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[分錄表歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[功能模塊]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[功能模塊]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[歷史分類帳簿]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[歷史分類帳簿]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[歷史明細帳簿]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[歷史明細帳簿]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[報表清單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[報表清單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[報表項目清單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[報表項目清單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[損益表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[損益表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[本年分類帳簿]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[本年分類帳簿]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[本年明細帳簿]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[本年明細帳簿]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[本期分類帳簿]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[本期分類帳簿]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[本期明細帳簿]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[本期明細帳簿]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[權限登記]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[權限登記]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[狀態表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[狀態表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[科目余額表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[科目余額表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[科目表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[科目表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[組別清單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[組別清單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[職工清單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[職工清單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[部門清單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[部門清單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[項目科目對照表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[項目科目對照表]
GO

CREATE TABLE [dbo].[憑證表] (
	[內部編號] [int] NULL ,
	[憑證狀態] [char] (10) NULL ,
	[會計期間] [int] NULL ,
	[憑證字號] [char] (4) NULL ,
	[憑證編號] [int] NOT NULL ,
	[順序號] [int] NULL ,
	[日期] [char] (10) NULL ,
	[附單據] [int] NULL ,
	[審核] [char] (20) NULL ,
	[過帳] [char] (20) NULL ,
	[制單] [char] (20) NULL ,
	[借方合計] [money] NULL ,
	[貸方合計] [money] NULL ,
	[過帳狀態] [char] (4) NULL ,
	[順序號碼] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[憑證表temp] (
	[內部編號] [int] NULL ,
	[憑證狀態] [char] (10) NULL ,
	[會計期間] [int] NULL ,
	[憑證字號] [char] (4) NULL ,
	[憑證編號] [int] NULL ,
	[順序號] [int] NULL ,
	[日期] [char] (10) NULL ,
	[附單據] [int] NULL ,
	[審核] [char] (20) NULL ,
	[過帳] [char] (20) NULL ,
	[制單] [char] (20) NULL ,
	[借方合計] [money] NULL ,
	[貸方合計] [money] NULL ,
	[順序號碼] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[憑證表歷史] (
	[內部編號] [int] NULL ,
	[憑證狀態] [char] (10) NULL ,
	[會計期間] [int] NULL ,
	[憑證字號] [char] (4) NULL ,
	[憑證編號] [int] NULL ,
	[順序號] [int] NULL ,
	[日期] [char] (10) NULL ,
	[附單據] [int] NULL ,
	[審核] [char] (20) NULL ,
	[過帳] [char] (20) NULL ,
	[制單] [char] (20) NULL ,
	[借方合計] [money] NULL ,
	[貸方合計] [money] NULL ,
	[過帳狀態] [char] (4) NULL ,
	[順序號碼] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[分錄表] (
	[內部編號] [int] IDENTITY (1, 1) NOT NULL ,
	[分錄編號] [int] NULL ,
	[會計期間] [int] NULL ,
	[憑證字號] [char] (4) NULL ,
	[憑證編號] [int] NOT NULL ,
	[摘要] [char] (40) NULL ,
	[科目代碼] [char] (20) NULL ,
	[借方] [money] NULL ,
	[貸方] [money] NULL ,
	[數量] [int] NULL ,
	[單價] [money] NULL ,
	[結算方式] [char] (10) NULL ,
	[結算號] [int] NULL ,
	[結算日期] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[分錄表temp] (
	[內部編號] [int] IDENTITY (1, 1) NOT NULL ,
	[分錄編號] [int] NULL ,
	[會計期間] [int] NULL ,
	[憑證字號] [char] (4) NULL ,
	[憑證編號] [int] NULL ,
	[摘要] [char] (40) NULL ,
	[科目代碼] [char] (20) NULL ,
	[借方] [money] NULL ,
	[貸方] [money] NULL ,
	[數量] [int] NULL ,
	[單價] [money] NULL ,
	[結算方式] [char] (10) NULL ,
	[結算號] [int] NULL ,
	[結算日期] [char] (10) NULL ,
	[附單據] [int] NULL ,
	[順序號碼] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[分錄表歷史] (
	[內部編號] [int] IDENTITY (1, 1) NOT NULL ,
	[分錄編號] [int] NULL ,
	[會計期間] [int] NULL ,
	[憑證字號] [char] (4) NULL ,
	[憑證編號] [int] NULL ,
	[摘要] [char] (40) NULL ,
	[科目代碼] [char] (20) NULL ,
	[借方] [money] NULL ,
	[貸方] [money] NULL ,
	[數量] [int] NULL ,
	[單價] [money] NULL ,
	[結算方式] [char] (10) NULL ,
	[結算號] [int] NULL ,
	[結算日期] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[功能模塊] (
	[模塊編號] [char] (50) NOT NULL ,
	[組別] [char] (20) NOT NULL ,
	[模塊] [char] (20) NOT NULL ,
	[描述] [varchar] (100) NULL ,
	[模塊類型] [int] NOT NULL ,
	[程序文件] [varchar] (100) NULL ,
	[菜單文件] [varchar] (100) NULL ,
	[打印文件] [varchar] (100) NULL ,
	[記帳參數] [varchar] (250) NULL ,
	[打印參數] [varchar] (250) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[歷史分類帳簿] (
	[科目代碼] [char] (20) NULL ,
	[期初余額] [char] (1) NULL ,
	[本期借方合計] [money] NULL ,
	[本期貸方合計] [money] NULL ,
	[本年借方累計] [money] NULL ,
	[本年貸方累計] [money] NULL ,
	[余額] [char] (1) NULL ,
	[摘要] [char] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[歷史明細帳簿] (
	[內部編號] [int] IDENTITY (1, 1) NOT NULL ,
	[分錄編號] [int] NULL ,
	[會計期間] [int] NULL ,
	[憑證字號] [char] (4) NULL ,
	[憑證編號] [int] NULL ,
	[摘要] [char] (40) NULL ,
	[科目代碼] [char] (20) NULL ,
	[借方] [money] NULL ,
	[貸方] [money] NULL ,
	[數量] [int] NULL ,
	[單價] [money] NULL ,
	[結算方式] [char] (10) NULL ,
	[結算號] [int] NULL ,
	[結算日期] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[報表清單] (
	[報表編號] [int] NULL ,
	[報表名稱] [char] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[報表項目清單] (
	[報表編號] [int] NULL ,
	[報表名稱] [char] (40) NULL ,
	[項目代碼] [int] NULL ,
	[項目名稱] [char] (40) NULL ,
	[行號] [int] NULL ,
	[計算方法] [char] (10) NULL ,
	[內部編號] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[損益表] (
	[項目] [char] (40) NULL ,
	[行號] [int] NULL ,
	[本月數] [money] NULL ,
	[本年累計數] [money] NULL ,
	[年份] [datetime] NULL ,
	[會計期間] [int] NULL ,
	[最后結算日期] [datetime] NULL ,
	[內部編號] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[本年分類帳簿] (
	[科目代碼] [char] (20) NULL ,
	[期初余額] [char] (1) NULL ,
	[本期借方合計] [money] NULL ,
	[本期貸方合計] [money] NULL ,
	[本年借方累計] [money] NULL ,
	[本年貸方累計] [money] NULL ,
	[余額] [char] (1) NULL ,
	[摘要] [char] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[本年明細帳簿] (
	[內部編號] [int] IDENTITY (1, 1) NOT NULL ,
	[分錄編號] [int] NULL ,
	[會計期間] [int] NULL ,
	[憑證字號] [char] (4) NULL ,
	[憑證編號] [int] NULL ,
	[摘要] [char] (40) NULL ,
	[科目代碼] [char] (20) NULL ,
	[借方] [money] NULL ,
	[貸方] [money] NULL ,
	[數量] [int] NULL ,
	[單價] [money] NULL ,
	[結算方式] [char] (10) NULL ,
	[結算號] [int] NULL ,
	[結算日期] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[本期分類帳簿] (
	[科目代碼] [char] (20) NULL ,
	[期初余額] [char] (1) NULL ,
	[本期借方合計] [money] NULL ,
	[本期貸方合計] [money] NULL ,
	[本年借方累計] [money] NULL ,
	[本年貸方累計] [money] NULL ,
	[余額] [char] (1) NULL ,
	[摘要] [char] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[本期明細帳簿] (
	[內部編號] [int] IDENTITY (1, 1) NOT NULL ,
	[分錄編號] [int] NULL ,
	[會計期間] [int] NULL ,
	[憑證字號] [char] (4) NULL ,
	[憑證編號] [int] NULL ,
	[摘要] [char] (40) NULL ,
	[科目代碼] [char] (20) NULL ,
	[借方] [money] NULL ,
	[貸方] [money] NULL ,
	[余額方向] [char] (4) NULL ,
	[余額] [money] NULL ,
	[數量] [int] NULL ,
	[單價] [money] NULL ,
	[結算方式] [char] (10) NULL ,
	[結算號] [int] NULL ,
	[結算日期] [char] (10) NULL ,
	[余額標記] [char] (4) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[權限登記] (
	[權限序號] [int] NOT NULL ,
	[編號] [char] (6) NOT NULL ,
	[編號類型] [int] NOT NULL ,
	[模塊編號] [char] (10) NOT NULL ,
	[選中標記] [char] (1) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[狀態表] (
	[內部編號] [int] IDENTITY (1, 1) NOT NULL ,
	[會計期間] [int] NULL ,
	[憑證字號] [char] (4) NULL ,
	[編號] [int] NULL ,
	[順序號] [int] NULL ,
	[分錄編號] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[科目余額表] (
	[科目代碼] [char] (20) NULL ,
	[期初借方余額] [money] NULL ,
	[期初貸方余額] [money] NULL ,
	[本期借方發生額] [money] NULL ,
	[本期貸方發生額] [money] NULL ,
	[本年借方累計發生額] [money] NULL ,
	[本年貸方累計發生額] [money] NULL ,
	[本期借方余額] [money] NULL ,
	[本期貸方余額] [money] NULL ,
	[最后結算分錄] [int] NULL ,
	[會計期間] [int] NULL ,
	[余額方向] [char] (4) NULL ,
12 下一頁
?? 文件大小 1145 K
?? 上傳用戶 wjm197811
?? 所屬分類企業管理
??? 相關標簽

#財務 #程序
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? 財務管理系統.sql

?? 快捷鍵說明
