基于vb的財(cái)務(wù)管理系統(tǒng)設(shè)計(jì)(編輯修改稿)
2024-07-24 18:50 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 憑證字號(hào)借方合計(jì)附單據(jù)借單貸方合計(jì)會(huì)計(jì)期間憑證狀態(tài)憑證圖37 憑證ER圖4. 分錄和分錄歷史憑證編號(hào)科目代碼借方貸方單價(jià)會(huì)計(jì)期間編號(hào)分錄圖38 分錄ER圖憑證編號(hào)科目代碼借方貸方單價(jià)會(huì)計(jì)期間編號(hào)分錄歷史圖39分錄歷史ER圖5. 科目余額表本期貸方余額本期借方余額期初貸方余額科目代碼本期借方發(fā)生本期貸方發(fā)生最后結(jié)算分錄期初貸方余額內(nèi)部編號(hào)科目圖310科目ER圖憑證字號(hào)分錄編號(hào)借方科目代碼貸方會(huì)計(jì)期間單價(jià)憑證編號(hào)本期明細(xì)賬圖311 明細(xì)賬簿ER圖本年借方余額期初借方余額期初貸方余額科目代碼本期借方合計(jì)本期貸方合計(jì)會(huì)計(jì)期間本年貸方余額分錄歷史圖312 匯總賬簿ER圖負(fù)債及所有者會(huì)計(jì)期間流動(dòng)資產(chǎn)總計(jì)固定資產(chǎn)總計(jì)其他資產(chǎn)資產(chǎn)總計(jì)應(yīng)付賬款其他負(fù)債負(fù)債總計(jì)實(shí)收資本總計(jì)資產(chǎn)簿圖313 資產(chǎn)負(fù)債ER圖“科目表”是系統(tǒng)的關(guān)鍵表，其他各表均與“科目表”通過(guò)“科目代碼”字段進(jìn)行多對(duì)一的關(guān)聯(lián)。系統(tǒng)共需要9張表，用途如下表數(shù)據(jù)表名稱數(shù)據(jù)表用途科目表保存企業(yè)財(cái)務(wù)的科目設(shè)置信息賬簿初始化表正式使用系統(tǒng)前初始化科目的期初余額憑證表輸入會(huì)計(jì)憑證，記錄表的主表分錄表輸入會(huì)計(jì)分錄，記錄表的從表科目余額表保存各個(gè)會(huì)計(jì)期間的科目借、貸、余額情況本期明細(xì)賬簿保存當(dāng)前會(huì)計(jì)期間的明細(xì)賬簿數(shù)據(jù)本期匯總賬簿保存當(dāng)前會(huì)計(jì)期間的明細(xì)賬簿數(shù)據(jù)，期末結(jié)賬后期末變成新會(huì)計(jì)期間的期初資產(chǎn)負(fù)債表統(tǒng)計(jì)用表，用于計(jì)算資產(chǎn)負(fù)債表系統(tǒng)參數(shù)表系統(tǒng)運(yùn)行所需的參數(shù)信息打開(kāi)SQL Server企業(yè)管理器，新建一個(gè)數(shù)據(jù)庫(kù)，名稱為caiwubook。然后創(chuàng)建數(shù)據(jù)庫(kù)對(duì)象，完成數(shù)據(jù)庫(kù)的設(shè)計(jì)。圖314 數(shù)據(jù)庫(kù)截圖創(chuàng)建“科目表”數(shù)據(jù)表CREATE TABLE 科目表S ( char (20) NOT NULL PRIMARY KER, char (20) NULL, char (20) NULL, direction char (4) NULL S. amount char (10) NULL) 創(chuàng)建“帳簿初始化表”數(shù)據(jù)表CREATE TABLE 帳簿初始化表 F ( char (20) NOT NULL PRIMARY KER , char (20) NULL , Accumulative total debits money NULL , Accumulative total credit money) NULL , remaining sum money NULL , ) 創(chuàng)建“憑證表”CREATE TABLE 憑證表P ( char (10) NOT NULL PRIMARY KER, char (2) NULL, document attached int NULL, make bill char (20) NULL, sum money NULL, sum money NULL, P. condition char (10) NULL) 創(chuàng)建“分錄表”CREATE TABLE 分錄表SS( int IDENTITY (1,1) NOT NULL PRIMARY KER , char (10) NOT NULL, char (20) NULL, Debtor money NULL, creditor money NULL, price money NULL ) CREATE TABLE 分錄表歷史SSH ( int IDENTITY (1,1) NOT NULL PRIMARY KER , char (10) NOT NULL, char (20) NULL, Debtor char(80) NULL, creditor char(80) NULL, price money NULL ) 創(chuàng)建“科目余額表”數(shù)據(jù)表CREATE TABLE 科目余額表SR ( char (20) NULL PRIMARY KER, Initial debit balance money NULL , Initial credit balance money NULL , This period debit amounts incurred money NULL , This credit amount money NULL ,ben This period debit balance money NULL , This credit balance money NULL , Final settlement entries int NULL , ) 創(chuàng)建“本期明細(xì)帳簿”數(shù)據(jù)表CREATE TABLE 本期明細(xì)帳簿DB ( int IDENTITY (1, 1) NOT NULL PRIMARY KER , int NULL , char (4) NULL , char (10) NULL , char (20) NULL , Debtor char (80) NULL, creditor char (80) NULL, price money NULL) 創(chuàng)建“本期匯總帳簿”數(shù)據(jù)表CREATE TABLE 本期匯總帳簿CB ( char (20) NOT NULL PRIMARY KER , Fiscal year int NULL , initial balance money NULL , This total debits money NULL , This credit aggregate money NULL , Foura debit accumulative total money NULL , Foura lenders accumulative total money NULL , remaining sum money NULL , ) 創(chuàng)建“資產(chǎn)負(fù)債表”數(shù)據(jù)表CREATE TABLE 資產(chǎn)負(fù)債表BS (Total Current Assets money NULL PRIMARY KER ,Fixed assets amounted money NULL ,other assets money NULL ,total assets money NULL , account payable money NULL , other liabilities money NULL , Paidin capital total money NULL , Total Liabilities and Equity money NULL) 創(chuàng)建“系統(tǒng)參數(shù)表”數(shù)據(jù)表CREATE TABLE 系統(tǒng)參數(shù)表SSP ( int IDENTITY (1, 1) NOT NULL PRIMARY KER , char (20) NULL , Value int NULL ) 本模塊主要就是一個(gè)簡(jiǎn)單的界面視圖，如圖315：圖315財(cái)務(wù)管理系統(tǒng)主界面圖316 管理員登陸界面員工管理的權(quán)限屬于經(jīng)理。以“admin”賬號(hào)登陸系統(tǒng)。選擇“員工管理”，可以進(jìn)行“創(chuàng)建員工賬號(hào)”、“修改員工密碼”、“修改員工資料”等操作。也可以點(diǎn)取“員工賬號(hào)管理”啟動(dòng)如圖316所示界面進(jìn)行員工賬號(hào)的集中統(tǒng)一管理。圖317財(cái)務(wù)管理系統(tǒng)子界
高考資料相關(guān)推薦
鄂ICP備17016276號(hào)-1