【正文】 (10) NULL , [余額標(biāo)記] [char] (4) NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[本期匯總帳簿] ( [科目代碼] [char] (20) NOT NULL ,[會(huì)計(jì)期間] [int] NULL , [期初余額] [money] NULL , [本期借方合計(jì)] [money] NULL , [本期貸方合計(jì)] [money] NULL , [本年借方累計(jì)] [money] NULL , [本年貸方累計(jì)] [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 , [本年借方累計(jì)發(fā)生額] [money] NULL , [本年貸方累計(jì)發(fā)生額] [money] NULL , [本期借方余額] [money] NULL ,[本期貸方余額] [money] NULL ,[最后結(jié)算分錄] [int] NULL ,[會(huì)計(jì)期間] [int] NULL , [余額方向] [char] (4) NULL , [內(nèi)部編號(hào)] [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ù)表] ([編號(hào)] [int] IDENTITY (1, 1) NOT NULL ,[參數(shù)名稱] [char] (20) NULL ,[取值] [int] NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[資產(chǎn)負(fù)債表] ( [會(huì)計(jì)期間] [int] NOT NULL ,[現(xiàn)金及現(xiàn)金等價(jià)物] [money] NULL , [應(yīng)收帳款] [money] NULL , [壞帳準(zhǔn)備] [money] NULL , [應(yīng)收帳款凈值] [money] NULL , [流動(dòng)資產(chǎn)總計(jì)] [money] NULL , [固定資產(chǎn)原值] [money] NULL , [累計(jì)折舊] [money] NULL ,[固定資產(chǎn)總計(jì)] [money] NULL , [其他資產(chǎn)] [money] NULL , [資產(chǎn)總計(jì)] [money] NULL ,[應(yīng)付帳款] [money] NULL ,[預(yù)收帳款] [money] NULL ,[應(yīng)付工資] [money] NULL , [其他負(fù)債] [money] NULL , [負(fù)債總計(jì)] [money] NULL , [實(shí)收資本] [money] NULL , [資本公積] [money] NULL , [贏余公積] [money] NULL , [未分配利潤] [money] NULL , [所有者權(quán)益總計(jì)] [money] NULL ,[負(fù)債及所有者權(quán)益總計(jì)] [money] NULL ) ON [PRIMARY]GOALTER TABLE [dbo].[憑證表] WITH NOCHECK ADD CONSTRAINT [PK_憑證表] PRIMARY KEY CLUSTERED ( [憑證編號(hào)] ) ON [PRIMARY] GOALTER TABLE [dbo].[分錄表] WITH NOCHECK ADD CONSTRAINT [PK_分錄表] PRIMARY KEY CLUSTERED ( [編號(hào)] ) 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)負(fù)債表] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [會(huì)計(jì)期間] ) ON [PRIMARY] GOALTER TABLE [dbo].[分錄表] ADD CONSTRAINT [FK_分錄表_憑證表] FOREIGN KEY ( [憑證編號(hào)] ) REFERENCES [dbo].[憑證表] ( [憑證編號(hào)] ), 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].[本期明細(xì)帳簿] ADD CONSTRAINT [本期明細(xì)帳簿_科目代碼_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 本期借方合計(jì) = 本期借方合計(jì) + , 本期貸方合計(jì) = 本期貸方合計(jì) + , 本年借方累計(jì) = 本年借方累計(jì) + , 本年貸方累計(jì) = 本年貸方累計(jì) + , 余額 = 余額 + case when 余額方向=39。 then ye + jf df else ye + df jf end, 余額標(biāo)記=39。mitGOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GOSET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GOcreate proc sf_啟用帳戶as begin tran 清除原來數(shù)據(jù),從新建立帳戶 delete from 科目余額表 delete from 本期匯總帳簿 delete from 本期明細(xì)帳簿 delete from 分錄表 delete from 分錄表歷史 delete from 憑證表 delete from 憑證表歷史 設(shè)置本期匯總帳簿及科目余額表 insert into 本期匯總帳簿 select 科目代碼,0,期初余額, 0,0,0,0,期初余額,余額方向 from 帳簿初始化表 update 本期匯總帳簿 set 會(huì)計(jì)期間= from 系統(tǒng)參數(shù)表 as b where 參數(shù)名稱=39。mitGOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GOSET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GOcreate proc sf_期末結(jié)帳as begin tran 先將沒有過帳的憑證過帳 exec sf_憑證過帳 declare kjqj int 當(dāng)前會(huì)計(jì)期間 select kjqj = 會(huì)計(jì)期間 from 本期匯總帳簿 計(jì)算科目余額表,可以統(tǒng)計(jì)資產(chǎn)負(fù)債表/損溢表等 update 科目余額表 set 本期借方發(fā)生額 = , 本期貸方發(fā)生額 = , 會(huì)計(jì)期間 = , 余額方向 = from 科目余額表 as a, 本期匯總帳簿 as b where = and = update 科目余額表 set 本年借方累計(jì)發(fā)生額 = 本年借方累計(jì)發(fā)生額 + 本期借方發(fā)生額, 本年貸方累計(jì)發(fā)生額 = 本年貸方累計(jì)發(fā)生額 + 本期貸方發(fā)生額, 本期借方余額 = 期初借方余額 + 本期借方發(fā)生額, 本期貸方余額 = 期初貸方余額 + 本期貸方發(fā)生額 where 會(huì)計(jì)期間 = kjqj 更新會(huì)計(jì)期間 update 系統(tǒng)參數(shù)表 set 取值 = 取值 + 1 where 參數(shù)名稱=39。在大堂工作要特別注重禮儀，禮儀是人們?cè)诮煌顒?dòng)中形成的行為規(guī)范與準(zhǔn)則,成天與客戶打交道的大堂經(jīng)理，代表著企業(yè)的形象和名譽(yù)，所以一切都要小心謹(jǐn)慎。作為一名一直生活在單純的大學(xué)校園的我，這次的畢業(yè)實(shí)習(xí)無疑成為了我踏入社會(huì)前的一個(gè)平臺(tái)，為我今后踏入社會(huì)奠定了基礎(chǔ)。走上社會(huì)之后，環(huán)境，生活習(xí)慣都會(huì)發(fā)生很大變化，如果不能盡快適應(yīng)，仍把自己能學(xué)生看待，必定會(huì)被殘酷的社會(huì)淘汰。這使我認(rèn)識(shí)到在真正的工作當(dāng)中要求的是我們嚴(yán)謹(jǐn)和細(xì)致的工作態(tài)度并虛心向他人請(qǐng)教。 實(shí)習(xí)指導(dǎo)老師的平易近人，為人誠懇，學(xué)識(shí)淵博，為我提供了一種良好的精神氣氛。必須全面強(qiáng)調(diào)我們的基礎(chǔ)知識(shí)、基本能力和基本素質(zhì)，而且專業(yè)面要寬，以適應(yīng)技術(shù)進(jìn)步與市場(chǎng)的不斷變化。而當(dāng)對(duì)方有所疑