【正文】 LL ,[余額方向] [char] (4) NULL ,[余額] [money] NULL ,[數(shù)量] [int] NULL ,[單價] [money] NULL ,[結(jié)算方式] [char] (10) NULL , [結(jié)算號] [int] NULL , [結(jié)算日期] [char] (10) NULL , [余額標(biāo)記] [char] (4) NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[本期匯總帳簿] ( [科目代碼] [char] (20) NOT NULL ,[會計期間] [int] NULL , [期初余額] [money] NULL , [本期借方合計] [money] NULL , [本期貸方合計] [money] NULL , [本年借方累計] [money] NULL , [本年貸方累計] [money] NULL , [余額] [money] NULL , [余額方向] [char] (4) NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[科目余額表] ([科目代碼] [char] (20) NULL ,[期初借方余額] [money] NULL , [期初貸方余額] [money] NULL ,[本期借方發(fā)生額] [money] NULL ,[本期貸方發(fā)生額] [money] NULL , [本年借方累計發(fā)生額] [money] NULL , [本年貸方累計發(fā)生額] [money] NULL , [本期借方余額] [money] NULL ,[本期貸方余額] [money] NULL ,[最后結(jié)算分錄] [int] NULL ,[會計期間] [int] NULL , [余額方向] [char] (4) NULL , [內(nèi)部編號] [int] IDENTITY (1, 1) NOT NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[科目表] ( [科目代碼] [char] (20) NOT NULL , [科目名稱] [char] (20) NULL , [助記碼] [char] (20) NULL ,[科目類別] [char] (20) NULL , [是否存貨科目] [char] (10) NULL , [余額方向] [char] (4) NULL , [數(shù)量單位] [char] (10) NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[系統(tǒng)參數(shù)表] ([編號] [int] IDENTITY (1, 1) NOT NULL ,[參數(shù)名稱] [char] (20) NULL ,[取值] [int] NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[資產(chǎn)負債表] ( [會計期間] [int] NOT NULL ,[現(xiàn)金及現(xiàn)金等價物] [money] NULL , [應(yīng)收帳款] [money] NULL , [壞帳準(zhǔn)備] [money] NULL , [應(yīng)收帳款凈值] [money] NULL , [流動資產(chǎn)總計] [money] NULL , [固定資產(chǎn)原值] [money] NULL , [累計折舊] [money] NULL ,[固定資產(chǎn)總計] [money] NULL , [其他資產(chǎn)] [money] NULL , [資產(chǎn)總計] [money] NULL ,[應(yīng)付帳款] [money] NULL ,[預(yù)收帳款] [money] NULL ,[應(yīng)付工資] [money] NULL , [其他負債] [money] NULL , [負債總計] [money] NULL , [實收資本] [money] NULL , [資本公積] [money] NULL , [贏余公積] [money] NULL , [未分配利潤] [money] NULL , [所有者權(quán)益總計] [money] NULL ,[負債及所有者權(quán)益總計] [money] NULL ) ON [PRIMARY]GOALTER TABLE [dbo].[憑證表] WITH NOCHECK ADD CONSTRAINT [PK_憑證表] PRIMARY KEY CLUSTERED ( [憑證編號] ) ON [PRIMARY] GOALTER TABLE [dbo].[分錄表] WITH NOCHECK ADD CONSTRAINT [PK_分錄表] PRIMARY KEY CLUSTERED ( [編號] ) ON [PRIMARY] GOALTER TABLE [dbo].[帳簿初始化表] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [科目代碼] ) ON [PRIMARY] GOALTER TABLE [dbo].[本期匯總帳簿] WITH NOCHECK ADD CONSTRAINT [PK_本期匯總帳簿] PRIMARY KEY CLUSTERED ( [科目代碼] ) ON [PRIMARY] GOALTER TABLE [dbo].[科目表] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [科目代碼] ) ON [PRIMARY] GOALTER TABLE [dbo].[資產(chǎn)負債表] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [會計期間] ) ON [PRIMARY] GOALTER TABLE [dbo].[分錄表] ADD CONSTRAINT [FK_分錄表_憑證表] FOREIGN KEY ( [憑證編號] ) REFERENCES [dbo].[憑證表] ( [憑證編號] ), CONSTRAINT [分錄表_科目代碼_fk] FOREIGN KEY ( [科目代碼] ) REFERENCES [dbo].[科目表] ( [科目代碼] )GOALTER TABLE [dbo].[分錄表歷史] ADD CONSTRAINT [分錄表歷史_科目代碼_fk] FOREIGN KEY ( [科目代碼] ) REFERENCES [dbo].[科目表] ( [科目代碼] )GOALTER TABLE [dbo].[帳簿初始化表] ADD CONSTRAINT [帳簿初始化表_科目代碼_fk] FOREIGN KEY ( [科目代碼] ) REFERENCES [dbo].[科目表] ( [科目代碼] )GOALTER TABLE [dbo].[本期明細帳簿] ADD CONSTRAINT [本期明細帳簿_科目代碼_fk] FOREIGN KEY ( [科目代碼] ) REFERENCES [dbo].[科目表] ( [科目代碼] )GOALTER TABLE [dbo].[本期匯總帳簿] ADD CONSTRAINT [本期匯總帳簿_科目代碼_fk] FOREIGN KEY ( [科目代碼] ) REFERENCES [dbo].[科目表] ( [科目代碼] )GOALTER TABLE [dbo].[科目余額表] ADD CONSTRAINT [科目余額表_科目代碼_fk] FOREIGN KEY ( [科目代碼] ) REFERENCES [dbo].[科目表] ( [科目代碼] )GOSET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GOcreate proc sf_憑證過帳as begin tran 設(shè)置本期匯總帳簿信息 update 本期匯總帳簿 set 本期借方合計 = 本期借方合計 + , 本期貸方合計 = 本期貸方合計 + , 本年借方累計 = 本年借方累計 + , 本年貸方累計 = 本年貸方累計 + , 余額 = 余額 + case when 余額方向=39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[系統(tǒng)參數(shù)表]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[科目表]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[科目余額表]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[本期匯總帳簿]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[本期明細帳簿]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[帳簿初始化表]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[分錄表歷史]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[分錄表]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[憑證表歷史]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[憑證表]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop procedure [dbo].[sf_計算資產(chǎn)負債表]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)