【文章內(nèi)容簡介】 (FK)ItemClassCode項(xiàng)目分類編碼References 項(xiàng)目分類表C,6,(FK)ItemCode項(xiàng)目編碼References 項(xiàng)目目錄表C,15,(FK)Year會(huì)計(jì)年度Int,NNPeriod會(huì)計(jì)期間Int,NNYcye年初余額(始終按借方數(shù))顯示時(shí)如0 則為借方 如0則為貸方 如=0 則平MoneyQcye期初余額(始終按借方數(shù))顯示時(shí)如0 則為借方 如0則為貸方 如=0 則平MoneyMjje本期金額借方合計(jì)MoneyMdje本期金額貸方合計(jì)MoneyByjfljje本年借方累計(jì)金額MoneyBydfljje本年貸方累計(jì)金額MoneyQmye本期期末余額(始終按借方數(shù))顯示時(shí)如0 則為借方 如0則為貸方 如=0 則平MoneyYcsl年初數(shù)量(始終按借方數(shù))顯示時(shí)如0 則為借方 如0則為貸方 如=0 則平Deci,6Qcsl期初數(shù)量(始終按借方數(shù))顯示時(shí)如0 則借方 0則貸方 =0 則平Deci,6Mjsl本期數(shù)量借方合計(jì)Deci,6Mdsl本期數(shù)量貸方合計(jì)Deci,6Byjfljsl本年借方累計(jì)數(shù)量Deci,6Bydfljsl本年貸方累計(jì)數(shù)量Deci,6Qmsl本期期末數(shù)量(始終按借方數(shù))顯示時(shí)如0 則為借方 如0則為貸方 如=0 則平Deci,6Ycwb年初外幣(始終按借方數(shù))顯示時(shí)如0 則為借方 如0則為貸方 如=0 則平MoneyQcwb期初外幣(始終按借方數(shù))顯示時(shí)如0 則借方 0則貸方 =0 則平MoneyMjwb本期外幣借方合計(jì)MoneyMdwb本期外幣貸方合計(jì)MoneyByjfljwb本年借方累計(jì)外幣MoneyBydfljwb本年貸方累計(jì)外幣MoneyQmwb本期期末外幣(始終按借方數(shù))顯示時(shí)如0 則為借方 如0則為貸方 如=0 則平MoneyYcItemSl年初項(xiàng)目數(shù)量Deci,6QcItemSl期初項(xiàng)目數(shù)量Deci,6ItemMjsl項(xiàng)目本期借方數(shù)量Deci,6ItemMdsl項(xiàng)目本期貸方數(shù)量Deci,6ItemByljjfsl項(xiàng)目本年累計(jì)借方數(shù)量Deci,6ItemByljdfsl項(xiàng)目本年累計(jì)貸方數(shù)量Deci,6QmItemSl期末項(xiàng)目數(shù)量Deci,6 多欄帳主表:(cwzz_AccMultiMain) 字段編碼 字段說明 字段屬性AccMultiCode多欄帳編碼C,10,(PK),NNAccMultiName多欄帳名稱NC,30,NNCcode核算科目號(hào)(用于自動(dòng)展開編制)C,15,(FK)Memo備注NC,30 多欄帳欄目定義:(cwzz_AccMultiItem) 字段編碼 字段說明 字段屬性AccMultiItemID用來記錄欄目真實(shí)順序Int,(PK) ,NNAccMultiCode多欄帳編碼 References:多欄帳主表 C,10,NNItemName欄目名稱Nc,20,NNCcode核算科目號(hào)C,15AnalyseOri分析方向(借,貸)C,2,NN 自動(dòng)轉(zhuǎn)帳過程主表：Cwzz_AutoTranMain 字段編碼 字段說明 字段屬性TranClass轉(zhuǎn)帳類別C,2(PK),NNTranCode轉(zhuǎn)帳過程編碼C,4,(PK),NNTranName轉(zhuǎn)帳過程名稱NC,20,NNVouchClassCode憑證類別編碼 References:憑證類別表NC,2,(FK),NNEndTranDate最后一次結(jié)轉(zhuǎn)日期DatetimeBill制單人NC,10 自動(dòng)轉(zhuǎn)帳過程項(xiàng)目表:(Cwzz_AutoTranItem) 字段編碼 字段說明 字段屬性AutoTranID自增的主鍵Int,(PK),NNTranCode轉(zhuǎn)帳過程編碼C,4,NNCcode科目號(hào) C,15,(FK)TranOri轉(zhuǎn)帳方向(借,貸)C,2TranProp轉(zhuǎn)帳性質(zhì)(轉(zhuǎn)入,轉(zhuǎn)出)C,4PersonCode職員編碼 References 公司職員表C,8,(FK)CusCode往來客戶編碼References 往來客戶表C,12,(FK）Supplier_Code往來供應(yīng)商編碼References 往來供應(yīng)商表C,12,(FK)DeptCode部門編碼 References 部門表C,12,(FK)ItemClassCode項(xiàng)目類別編碼C,6,(FK)ItemCode項(xiàng)目編碼C,15,(FK)GetCcode對(duì)應(yīng)科目損益結(jié)轉(zhuǎn)C,15,(FK)DistriProp分配比例Deci,6Constant轉(zhuǎn)帳金額DeciFormulaString計(jì)算公式NVC,255TranClass轉(zhuǎn)帳類別C,2,NNDigest摘要NVC,60FormalaCode公式編碼C,2,(FK) 銀行對(duì)帳單表(Cwzz_BankBill) 字段編碼 字段說明字段屬性及長度BankBillID用于編輯時(shí)唯一標(biāo)識(shí)Int,(PK),NNCcode科目號(hào) References 科目表C,15,(FK)BillDate發(fā)生日期(票據(jù))DatetimeDigest摘要NC,60SSCode結(jié)算方式編碼 References 結(jié)算方式表C,3,(FK)BillNo銀行票號(hào)C,8Jfje借方金額MoneyDfje貸方金額MoneyRecType記錄類型（0調(diào)整前余額 1對(duì)帳單期初未達(dá) 2錄入對(duì)帳單）IntBCheckFlag銀行核對(duì)標(biāo)志(0未達(dá)帳項(xiàng) 1已達(dá)帳項(xiàng))Bit,NNHandWorkFlag手工對(duì)帳標(biāo)志（0自動(dòng)對(duì)帳 1手工對(duì)帳）Bit,NNBDelete銀行帳核銷標(biāo)志(0未核銷 1已核銷)Bit,NNBalanceMoney 系統(tǒng)編碼方案表：Gy_CodeScheme見公用表 我的報(bào)表：Cwzz_MyReport 字段編碼 字段說明 字段屬性I_ID唯一標(biāo)識(shí)主鍵INT,(PK),NNCzybm操作員編碼C,3,(FK) ,NNQueryCode查詢功能編碼C,20,(FK),NNQueryName報(bào)表名稱NC，20Value查詢條件值C,30 現(xiàn)金流量表報(bào)表項(xiàng)目：Cwzz_CashFlowItem 字段編碼 字段說明 字段屬性CashFlowID現(xiàn)金流量項(xiàng)目ID(自動(dòng)編碼，唯一標(biāo)識(shí))Int,(PK) ,NNLogicId現(xiàn)金流量項(xiàng)目邏輯編碼Int,NNCashFlowCode現(xiàn)金流量項(xiàng)目查找索引編碼VC,6CashFlowName現(xiàn)金流量項(xiàng)目名稱NVc,40,NNRowNO行次VC,3DataSource數(shù)據(jù)來源NVc,50DistributeFlag是否由憑證數(shù)據(jù)分配得到Bit,NN 現(xiàn)金流量表數(shù)據(jù)：Cwzz_CashFlowData(會(huì)計(jì)分錄分配) 字段編碼 字段說明 字段屬性CashFlowDataID編輯時(shí)唯一定位標(biāo)識(shí)Int,(PK),NNVouchId憑證唯一關(guān)聯(lián)標(biāo)識(shí)Int（FK）Year年度Int（PK）,NNPeriod會(huì)計(jì)期間Int（PK）,NNCashFlowID現(xiàn)金流量項(xiàng)目唯一標(biāo)識(shí)Int,NNFpje分配金額Money 用戶自定義函數(shù)：cwzz_UserDefineFn 字段編碼 字段說明 字段屬性FnAlias函數(shù)別名NVC（24）(PK),NNFnName函數(shù)名VC（12）NNFnComment函數(shù)說明Ntext NNFnFlag標(biāo)志Smallint,NN 視圖： 憑證主從表視圖：/*==============================================================*//* View: Cwzz_V_AccVouch *//*==============================================================*/create view Cwzz_V_AccVouch as SELECT .*, AS year, AS period, AS Ddate, AS VouchClassCode, AS VouchNo, AS Doc, AS Bill, AS Checker, AS Book, AS ErrorFlag, AS CheckFlag, AS BookFlag, AS VouchSourceFROM INNER JOIN ON = go 科目輔助帳中代碼對(duì)應(yīng)中文名稱視圖：/*==============================================================*//* View: Cwzz_V_AccVouchAss *//*==============================================================*/create view Cwzz_V_AccVouchAss as select , , , , , m.*from Cwzz_AccSumAssi mLEFT OUTER JOINCwzz_Item n ON = AND = LEFT OUTER JOINCwzz_ItemClass r ON = LEFT OUTER JOIN Gy_Person o ON = LEFT OUTER JOIN Gy_Customer p ON = LEFT OUTER JOIN Gy_Department q ON = go 項(xiàng)目主從表視圖：/*==============================================================*//* View: Cwzz_V_Item *//*==============================================================*/create view as SELECT , , , , , , , , , FROM Cwzz_Item LEFT OUTER JOIN Cwzz_ItemClass ON = go 憑證臨時(shí)主從表視圖：/*==============================================================*//* View: Cwzz_V_AccVouchTemp *//*==============================================================*/create view Cwzz_V_AccVouchTemp as SELECT .*, AS VouchSource, AS OperationNo, AS VouchClassCode, AS Year, AS Period, AS Ddate, AS VouchNo, AS Doc, AS Bill, AS OperationClass, AS BillType, AS BillNum,