檢視會計系統的原始碼

'''會計系統'''，預定以ASP.NET MVC4與SQL Server方式改寫。改寫後的版本預定採用LGPL方式授權，如有任何改進建議，歡迎回報。

==開發環境==
* IDE：Visual Studio 2012
* 資料庫：SQL Server 2012
* 報表：Crystal Reports
* 用戶端：jQuery、jQuery UI、jqGrid

==參考資料==
#參考資料1，ACCESS會計管理系統
#*書名：活用ACCESS會計管理系統 開發與運用
#*作者：平南
#*出版社：金禾資訊
#*ISBN 9861491066
#*經原作者同意以註明出處後改寫成Web版
#參考資料2，會計相關用語（中英翻譯）
#*[http://www.ardf.org.tw/html/tifrs1001115.pdf 「重要會計用語中英對照」- 財團法人會計研究發展基金會]
#*[https://translate.google.com.tw/?hl=zh-TW&tab=TT Google翻譯]
#參考資料3，交換票據相關用語
#*[http://wiki.mbalib.com/zh-tw/%E5%BA%94%E6%94%B6%E7%A5%A8%E6%8D%AE 應收票據]、[http://wiki.mbalib.com/zh-tw/%E5%BA%94%E4%BB%98%E7%A5%A8%E6%8D%AE 應付票據]

==資料表==
===最初版本===
*以下Table為以SQL Server匯入參考資料1的書附光碟（檔案：會計管理系統2003.mde）再輸出成SQL指令碼，以取得未設關聯的最初版本的資料表
{{HideH|資料表}}
<source lang="tsql">
/****** Object:  Table [dbo].[應付票據明細表]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[應付票據明細表](
	[甲存序號] [nvarchar](2) NOT NULL,
	[支票號碼] [nvarchar](15) NOT NULL,
	[受款人] [nvarchar](20) NOT NULL,
	[到期日] [datetime] NOT NULL,
	[支票金額] [money] NOT NULL,
	[開立日期] [datetime] NOT NULL,
	[發票號碼] [nvarchar](15) NULL,
	[傳票號碼] [nvarchar](8) NULL,
	[付票內容] [nvarchar](10) NULL,
	[沖帳傳票] [nvarchar](8) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[銷貨折讓臨時檔案]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[銷貨折讓臨時檔案](
	[客戶名稱] [nvarchar](20) NOT NULL,
	[原幣銷貨折讓] [money] NULL,
	[台幣銷貨折讓] [money] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[銷貨成本臨時檔案]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[銷貨成本臨時檔案](
	[客戶名稱] [nvarchar](20) NOT NULL,
	[台幣銷貨成本淨額] [money] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[銷貨毛額臨時檔案]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[銷貨毛額臨時檔案](
	[客戶名稱] [nvarchar](20) NOT NULL,
	[原幣銷貨收入毛額] [money] NULL,
	[台幣銷貨收入毛額] [money] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[銷貨毛利分析表]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[銷貨毛利分析表](
	[客戶名稱] [nvarchar](20) NOT NULL,
	[幣別] [nvarchar](3) NOT NULL,
	[開始日期] [datetime] NOT NULL,
	[截止日期] [datetime] NOT NULL,
	[原幣銷貨收入毛額] [money] NULL,
	[台幣銷貨收入毛額] [money] NULL,
	[原幣銷貨折讓] [money] NULL,
	[台幣銷貨折讓] [money] NULL,
	[原幣銷貨收入淨額] [money] NULL,
	[台幣銷貨收入淨額] [money] NULL,
	[台幣銷貨成本淨額] [money] NULL,
	[台幣銷貨毛利] [money] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[試算表臨時檔案]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[試算表臨時檔案](
	[會計科目] [nvarchar](8) NOT NULL,
	[借方金額] [money] NULL,
	[借方筆數] [int] NOT NULL,
	[貸方金額] [money] NULL,
	[貸方筆數] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[試算表]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[試算表](
	[會計科目] [nvarchar](8) NOT NULL,
	[科目名稱] [nvarchar](20) NOT NULL,
	[開始日期] [datetime] NOT NULL,
	[截止日期] [datetime] NOT NULL,
	[期初餘額] [money] NULL,
	[借方金額] [money] NULL,
	[借方筆數] [int] NULL,
	[貸方金額] [money] NULL,
	[貸方筆數] [int] NULL,
	[期末餘額] [money] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[會計類別]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[會計類別](
	[類別編號] [nvarchar](2) NOT NULL,
	[類別名稱] [nvarchar](5) NOT NULL,
	[大類名稱] [nvarchar](2) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[會計科目]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[會計科目](
	[科目編號] [nvarchar](8) NOT NULL,
	[科目名稱] [nvarchar](20) NOT NULL,
	[類別編號] [nvarchar](2) NOT NULL,
	[使用幣別] [nvarchar](1) NOT NULL,
	[沖帳] [bit] NOT NULL,
	[傳票科目] [bit] NOT NULL,
	[部門區分] [bit] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[匯率主表]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[匯率主表](
	[幣別代號] [nvarchar](1) NOT NULL,
	[幣別名稱] [nvarchar](3) NOT NULL,
	[已過帳] [bit] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[匯率子表]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[匯率子表](
	[幣別代號] [nvarchar](1) NOT NULL,
	[啟用日期] [datetime] NOT NULL,
	[匯率] [money] NOT NULL,
	[已過帳] [bit] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[匯差調整表]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[匯差調整表](
	[會計科目] [nvarchar](8) NOT NULL,
	[沖帳碼] [nvarchar](20) NULL,
	[幣別代號] [nvarchar](1) NOT NULL,
	[新匯率] [real] NOT NULL,
	[原幣餘額] [money] NOT NULL,
	[應有台幣餘額] [money] NOT NULL,
	[現有台幣餘額] [money] NOT NULL,
	[匯兌損益] [money] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[傳票明細]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[傳票明細](
	[借貸] [nvarchar](1) NOT NULL,
	[傳票號碼] [nvarchar](8) NOT NULL,
	[會計科目] [nvarchar](8) NOT NULL,
	[幣別代號] [nvarchar](1) NOT NULL,
	[成本中心] [nvarchar](3) NOT NULL,
	[沖帳碼] [nvarchar](20) NULL,
	[摘要] [nvarchar](30) NOT NULL,
	[原幣借方金額] [money] NULL,
	[原幣貸方金額] [money] NULL,
	[台幣借方金額] [money] NULL,
	[台幣貸方金額] [money] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[傳票]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[傳票](
	[傳票號碼] [nvarchar](8) NOT NULL,
	[傳票日期] [datetime] NOT NULL,
	[製票] [nvarchar](4) NOT NULL,
	[製票日期] [datetime] NOT NULL,
	[已過帳] [bit] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[結算帳戶]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[結算帳戶](
	[科目編號] [nvarchar](8) NOT NULL,
	[年月] [nvarchar](7) NOT NULL,
	[上期原幣餘額] [money] NULL,
	[上期台幣餘額] [money] NULL,
	[原幣借方總計] [money] NULL,
	[台幣借方總計] [money] NULL,
	[原幣貸方總計] [money] NULL,
	[台幣貸方總計] [money] NULL,
	[本期原幣餘額] [money] NULL,
	[本期台幣餘額] [money] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[常用摘要]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[常用摘要](
	[摘要說明] [nvarchar](30) NOT NULL,
	[總帳科目] [nvarchar](4) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[財產類別]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[財產類別](
	[類別編號] [nvarchar](1) NOT NULL,
	[類別名稱] [nvarchar](12) NOT NULL,
	[固定資產科目] [nvarchar](8) NOT NULL,
	[累計折舊科目] [nvarchar](8) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[固定資產]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[固定資產](
	[財產類別] [nvarchar](1) NOT NULL,
	[財產編號] [nvarchar](9) NOT NULL,
	[財產名稱] [nvarchar](20) NOT NULL,
	[廠牌規格] [nvarchar](20) NULL,
	[數量] [int] NOT NULL,
	[單位] [nvarchar](2) NOT NULL,
	[取得日期] [datetime] NOT NULL,
	[耐用年數] [smallint] NOT NULL,
	[幣別代號] [nvarchar](1) NULL,
	[原幣成本] [money] NULL,
	[原始成本] [money] NOT NULL,
	[使用單位] [nvarchar](3) NOT NULL,
	[傳票號碼] [nvarchar](8) NULL,
	[備註] [nvarchar](10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[受款人]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[受款人](
	[受款人] [nvarchar](20) NOT NULL,
	[會計科目] [nvarchar](8) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[系統建檔]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[系統建檔](
	[公司名稱] [nvarchar](10) NULL,
	[建檔年月] [nvarchar](7) NULL,
	[科目編號] [nvarchar](8) NOT NULL,
	[幣別代號] [nvarchar](1) NOT NULL,
	[沖帳碼] [nvarchar](20) NULL,
	[原幣借方金額] [money] NULL,
	[原幣貸方金額] [money] NULL,
	[台幣借方金額] [money] NULL,
	[台幣貸方金額] [money] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[沖帳碼明細表]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[沖帳碼明細表](
	[會計科目] [nvarchar](8) NOT NULL,
	[沖帳碼] [nvarchar](20) NOT NULL,
	[傳票日期] [datetime] NOT NULL,
	[傳票號碼] [nvarchar](8) NOT NULL,
	[幣別代號] [nvarchar](1) NOT NULL,
	[摘要] [nvarchar](30) NULL,
	[原幣借方金額] [money] NULL,
	[原幣貸方金額] [money] NULL,
	[台幣借方金額] [money] NULL,
	[台幣貸方金額] [money] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[成本中心]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[成本中心](
	[成本中心] [nvarchar](3) NOT NULL,
	[部門別] [nvarchar](10) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[年度初始值]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[年度初始值](
	[科目編號] [nvarchar](8) NOT NULL,
	[年度別] [nvarchar](4) NOT NULL,
	[幣別代號] [nvarchar](1) NOT NULL,
	[原幣借方金額] [money] NULL,
	[原幣貸方金額] [money] NULL,
	[台幣借方金額] [money] NULL,
	[台幣貸方金額] [money] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[甲存帳戶]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[甲存帳戶](
	[帳戶序號] [nvarchar](2) NOT NULL,
	[幣別代號] [nvarchar](1) NOT NULL,
	[銀行名稱] [nvarchar](10) NOT NULL,
	[銀行帳號] [nvarchar](10) NOT NULL,
	[銀行存款科目] [nvarchar](8) NOT NULL,
	[應付票據科目] [nvarchar](8) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[用戶群組]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[用戶群組](
	[用戶編號] [nvarchar](4) NOT NULL,
	[用戶名稱] [nvarchar](4) NULL,
	[密碼] [nvarchar](8) NOT NULL,
	[用戶群組] [nvarchar](5) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[付票內容]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[付票內容](
	[付票內容] [nvarchar](10) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[月結過帳原幣臨時檔案]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[月結過帳原幣臨時檔案](
	[科目編號] [nvarchar](8) NOT NULL,
	[原幣借方金額] [money] NULL,
	[原幣貸方金額] [money] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[月結過帳台幣臨時檔案]    Script Date: 04/30/2013 17:48:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[月結過帳台幣臨時檔案](
	[科目編號] [nvarchar](8) NOT NULL,
	[台幣借方金額] [money] NULL,
	[台幣貸方金額] [money] NULL
) ON [PRIMARY]
GO
</source>
{{HideF}}

===資料表名稱與欄位名稱英文化後的版本===
*未完
====資料表====
{{HideH|資料表}}
<source lang="tsql">
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

--會計科目
CREATE TABLE [dbo].[AccountingAccounts](
	[AccountNo] [nvarchar](10) NOT NULL,
	[AccountName] [nvarchar](20) NOT NULL,
	[CategoryNo] [nvarchar](6) NOT NULL,
	[CurrencyID] [nvarchar](3) NOT NULL,
	[IsStrikeBalance] [bit] NOT NULL,
	[IsSummonsAccount] [bit] NOT NULL,
	[IsDistinguish] [bit] NOT NULL,
 CONSTRAINT [PK_AccountingAccounts] PRIMARY KEY CLUSTERED 
(
	[AccountNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY];

--甲存帳戶(銀行)
CREATE TABLE [dbo].[AccountingBankAccount](
	[BankAccountID] [int] IDENTITY(1,1) NOT NULL,
	[CurrencyID] [nvarchar](3) NOT NULL,
	[BankID] [nvarchar](3) NOT NULL,
	[BankName] [nvarchar](10) NOT NULL,
	[BankAccount] [nvarchar](16) NOT NULL,
	[BankAccountName] [nvarchar](16) NOT NULL,
	[AccountNoForBank] [nvarchar](10) NOT NULL,
	[AccountNoForPayable] [nvarchar](10) NOT NULL,
 CONSTRAINT [PK_AccountingBankAccount] PRIMARY KEY CLUSTERED 
(
	[BankAccountID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY];

--會計類別(基礎會計科目)
CREATE TABLE [dbo].[AccountingCategory](
	[CategoryNo] [nvarchar](6) NOT NULL,
	[CategoryNoLen] [int] NOT NULL,
	[CategoryName] [nvarchar](50) NOT NULL,
	[CategoryDescription] [nvarchar](250) NOT NULL,
 CONSTRAINT [PK_AccountingCategory] PRIMARY KEY CLUSTERED 
(
	[CategoryNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY];

--結算帳戶(過帳時使用)
CREATE TABLE [dbo].[AccountingClearing](
	[AccountNo] [nvarchar](10) NOT NULL,
	[ClearingYear] [int] NOT NULL,
	[ClearingMonth] [int] NOT NULL,
	[BeforeBalancesOriginal] [money] NULL,
	[BeforeBalances] [money] NULL,
	[DebitTotalAmountOriginal] [money] NULL,
	[DebitTotalAmount] [money] NULL,
	[CreditTotalAmountOriginal] [money] NULL,
	[CreditTotalAmount] [money] NULL,
	[CurrentBalancesOriginal] [money] NULL,
	[CurrentBalances] [money] NULL
) ON [PRIMARY];

--成本中心
CREATE TABLE [dbo].[AccountingCostCenter](
	[CostCenter] [nvarchar](4) NOT NULL,
	[DepartmentName] [nvarchar](10) NOT NULL,
	[DepartmentDescription] [nvarchar](250) NOT NULL,
 CONSTRAINT [PK_AccountingCostCenter] PRIMARY KEY CLUSTERED 
(
	[CostCenter] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY];

--貨幣
CREATE TABLE [dbo].[AccountingCurrency](
	[CurrencyID] [nvarchar](3) NOT NULL,
	[CurrencyName] [nvarchar](10) NOT NULL,
	[EntityName] [nvarchar](10) NOT NULL,
	[PreSymbol] [nvarchar](10) NOT NULL,
	[CurrencyUnit] [nvarchar](10) NOT NULL,
	[CurrencyMinUnit] [int] NOT NULL,
 CONSTRAINT [PK_AccountingCurrency] PRIMARY KEY CLUSTERED 
(
	[CurrencyID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY];

--傳票

CREATE TABLE [dbo].[AccountingSummons](
	[SummonsNo] [nvarchar](10) NOT NULL,
	[SummonsDate] [datetime] NOT NULL,
	[MakeSummons] [nvarchar](10) NOT NULL,
	[MakeDate] [datetime] NOT NULL,
	[IsPosted] [bit] NOT NULL,
 CONSTRAINT [PK_AccountingSummons] PRIMARY KEY CLUSTERED 
(
	[SummonsNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY];

--傳票明細
CREATE TABLE [dbo].[AccountingSummonsDetails](
	[DetailsID] [int] IDENTITY(1,1) NOT NULL,
	[SummonsNo] [nvarchar](10) NOT NULL,
	[DetailsMode] [nvarchar](1) NOT NULL,
	[AccountNo] [nvarchar](10) NOT NULL,
	[CurrencyID] [nvarchar](3) NOT NULL,
	[CostCenter] [nvarchar](4) NULL,
	[ChongzhangCode] [nvarchar](20) NULL,
	[Summary] [nvarchar](30) NOT NULL,
	[DebitAmountOriginal] [money] NULL,
	[CreditAmountOriginal] [money] NULL,
	[DebitAmount] [money] NULL,
	[CreditAmount] [money] NULL,
 CONSTRAINT [PK_AccountingSummonsDetails] PRIMARY KEY CLUSTERED 
(
	[DetailsID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY];

</source>
{{HideF}}
====檢視====
{{HideH|檢視}}
<source lang="tsql">
--分類帳或日記帳用
CREATE VIEW [dbo].[AccountingLedger]
AS
SELECT          a.DetailsID, a.SummonsNo, a.DetailsMode, a.CurrencyID, a.AccountNo, a.CostCenter, a.ChongzhangCode, 
                            a.Summary, a.DebitAmountOriginal, a.CreditAmountOriginal, a.DebitAmount, a.CreditAmount, b.SummonsDate, 
                            b.MakeSummons, b.MakeDate, b.IsPosted, c.AccountName, c.CategoryNo, d.CurrencyName, YEAR(b.SummonsDate) 
                            AS SummonsYear, MONTH(b.SummonsDate) AS SummonsMonth, DAY(b.SummonsDate) AS SummonsDay
FROM              dbo.AccountingSummonsDetails AS a 
LEFT OUTER JOIN                            dbo.AccountingSummons AS b ON a.SummonsNo = b.SummonsNo 
LEFT OUTER JOIN                            dbo.AccountingAccounts AS c ON a.AccountNo = c.AccountNo 
LEFT OUTER JOIN                            dbo.AccountingCurrency AS d ON a.CurrencyID = d.CurrencyID;

</source>
{{HideF}}

====預存程序====

==Model==
*檔案：\Models\AccountingModels.cs （未完）
{{HideH|AccountingModels.cs}}
{{會計系統\AccountingModels.cs}}
{{HideF}}

==Controller==
*未完
===AccountingController.cs===
*檔案：\Controllers\AccountingController.cs （功能選單用）
{{HideH|AccountingController.cs}}
{{會計系統\AccountingController.cs}}
{{HideF}}
===AccountingAccountsController.cs===
*檔案：\Controllers\AccountingAccountsController.cs （會計科目）
{{HideH|AccountingAccountsController.cs}}
{{會計系統\AccountingAccountsController.cs}}
{{HideF}}
===AccountingBankAccountController.cs===
*檔案：\Controllers\AccountingBankAccountController.cs （銀行帳戶）
{{HideH|AccountingBankAccountController.cs}}
{{會計系統\AccountingBankAccountController.cs}}
{{HideF}}
===AccountingCategoryController.cs===
*檔案：\Controllers\AccountingCategoryController.cs （會計類別）
{{HideH|AccountingCategoryController.cs}}
{{會計系統\AccountingCategoryController.cs}}
{{HideF}}
===AccountingCostCenterController.cs===
*檔案：\Controllers\AccountingCostCenterController.cs （成本中心）
{{HideH|AccountingCostCenterController.cs}}
{{會計系統\AccountingCostCenterController.cs}}
{{HideF}}
===AccountingCurrencyController.cs===
*檔案：\Controllers\AccountingCurrencyController.cs （貨幣）
{{HideH|AccountingCurrencyController.cs}}
{{會計系統\AccountingCurrencyController.cs}}
{{HideF}}
===AccountingLedgerController.cs===
*檔案：\Controllers\AccountingLedgerController.cs （分類帳）
{{HideH|AccountingLedgerController.cs}}
{{會計系統\AccountingLedgerController.cs}}
{{HideF}}
===AccountingSummonsController.cs===
*檔案：\Controllers\AccountingSummonsController.cs （傳票）
{{HideH|AccountingSummonsController.cs}}
{{會計系統\AccountingSummonsController.cs}}
{{HideF}}
===AccountingSummonsDetailsController.cs===
*檔案：\Controllers\AccountingSummonsDetailsController.cs （傳票明細）
{{HideH|AccountingSummonsDetailsController.cs}}
{{會計系統\AccountingSummonsDetailsController.cs}}
{{HideF}}

==View==
===Index.cshtml===
*檔案：\Views\Accounting\Index.cshtml （用途：功能選單）
{{HideH|Index.cshtm}}
{{會計系統\Index.cshtm}}
{{HideF}}
===Accounts.cshtml===
*檔案：\Views\Accounting\Accounts.cshtml （用途：會計科目）
{{HideH|Accounts.cshtml}}
{{會計系統\Accounts.cshtml}}
{{HideF}}
===BankAccount.cshtml===
*檔案：\Views\Accounting\BankAccount.cshtml （用途：銀行帳號）
{{HideH|BankAccount.cshtml}}
{{會計系統\BankAccount.cshtml}}
{{HideF}}
===Category.cshtml===
*檔案：\Views\Accounting\Category.cshtml （用途：會計類別）
{{HideH|Category.cshtml}}
{{會計系統\Category.cshtml}}
{{HideF}}
===CostCenter.cshtml===
*檔案：\Views\Accounting\CostCenter.cshtml （用途：成本中心）
{{HideH|CostCenter.cshtml}}
{{會計系統\CostCenter.cshtml}}
{{HideF}}
===Currency.cshtml===
*檔案：\Views\Accounting\Currency.cshtml （用途：貨幣）
{{HideH|Currency.cshtml}}
{{會計系統\Currency.cshtml}}
{{HideF}}
===Currency.cshtml===
*檔案：\Views\Accounting\Currency.cshtml （用途：貨幣）
{{HideH|Currency.cshtml}}
{{會計系統\Currency.cshtml}}
{{HideF}}
===Journal.cshtml===
*檔案：\Views\Accounting\Journal.cshtml （用途：日記帳）
{{HideH|Journal.cshtml}}
{{會計系統\Journal.cshtml}}
{{HideF}}
===Ledger.cshtml===
*檔案：\Views\Accounting\Ledger.cshtml （用途：分類帳）
{{HideH|Ledger.cshtml}}
{{會計系統\Ledger.cshtml}}
{{HideF}}
===Summons.cshtml===
*檔案：\Views\Accounting\Summons.cshtml （用途：傳票）
{{HideH|Summons.cshtml}}
{{會計系統\Summons.cshtml}}
{{HideF}}
===_SummonsDetails.cshtml===
*檔案：\Views\Accounting\_SummonsDetails.cshtml （用途：傳票明細）
{{HideH|_SummonsDetails.cshtml}}
{{會計系統\_SummonsDetails.cshtml}}
{{HideF}}

[[Category:ASP.NET MVC]]
[[分類:會計]]