【文章內(nèi)容簡介】 (FK)ItemClassCode項目分類編碼References 項目分類表C,6,(FK)ItemCode項目編碼References 項目目錄表C,15,(FK)Year會計年度Int,NNPeriod會計期間Int,NNYcye年初余額(始終按借方數(shù))顯示時如0 則為借方 如0則為貸方 如=0 則平MoneyQcye期初余額(始終按借方數(shù))顯示時如0 則為借方 如0則為貸方 如=0 則平MoneyMjje本期金額借方合計MoneyMdje本期金額貸方合計MoneyByjfljje本年借方累計金額MoneyBydfljje本年貸方累計金額MoneyQmye本期期末余額(始終按借方數(shù))顯示時如0 則為借方 如0則為貸方 如=0 則平MoneyYcsl年初數(shù)量(始終按借方數(shù))顯示時如0 則為借方 如0則為貸方 如=0 則平Deci,6Qcsl期初數(shù)量(始終按借方數(shù))顯示時如0 則借方 0則貸方 =0 則平Deci,6Mjsl本期數(shù)量借方合計Deci,6Mdsl本期數(shù)量貸方合計Deci,6Byjfljsl本年借方累計數(shù)量Deci,6Bydfljsl本年貸方累計數(shù)量Deci,6Qmsl本期期末數(shù)量(始終按借方數(shù))顯示時如0 則為借方 如0則為貸方 如=0 則平Deci,6Ycwb年初外幣(始終按借方數(shù))顯示時如0 則為借方 如0則為貸方 如=0 則平MoneyQcwb期初外幣(始終按借方數(shù))顯示時如0 則借方 0則貸方 =0 則平MoneyMjwb本期外幣借方合計MoneyMdwb本期外幣貸方合計MoneyByjfljwb本年借方累計外幣MoneyBydfljwb本年貸方累計外幣MoneyQmwb本期期末外幣(始終按借方數(shù))顯示時如0 則為借方 如0則為貸方 如=0 則平MoneyYcItemSl年初項目數(shù)量Deci,6QcItemSl期初項目數(shù)量Deci,6ItemMjsl項目本期借方數(shù)量Deci,6ItemMdsl項目本期貸方數(shù)量Deci,6ItemByljjfsl項目本年累計借方數(shù)量Deci,6ItemByljdfsl項目本年累計貸方數(shù)量Deci,6QmItemSl期末項目數(shù)量Deci,6 多欄帳主表:(cwzz_AccMultiMain) 字段編碼 字段說明 字段屬性AccMultiCode多欄帳編碼C,10,(PK),NNAccMultiName多欄帳名稱NC,30,NNCcode核算科目號(用于自動展開編制)C,15,(FK)Memo備注NC,30 多欄帳欄目定義:(cwzz_AccMultiItem) 字段編碼 字段說明 字段屬性AccMultiItemID用來記錄欄目真實順序Int,(PK) ,NNAccMultiCode多欄帳編碼 References:多欄帳主表 C,10,NNItemName欄目名稱Nc,20,NNCcode核算科目號C,15AnalyseOri分析方向(借,貸)C,2,NN 自動轉(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 自動轉(zhuǎn)帳過程項目表:(Cwzz_AutoTranItem) 字段編碼 字段說明 字段屬性AutoTranID自增的主鍵Int,(PK),NNTranCode轉(zhuǎn)帳過程編碼C,4,NNCcode科目號 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項目類別編碼C,6,(FK)ItemCode項目編碼C,15,(FK)GetCcode對應(yīng)科目損益結(jié)轉(zhuǎn)C,15,(FK)DistriProp分配比例Deci,6Constant轉(zhuǎn)帳金額DeciFormulaString計算公式NVC,255TranClass轉(zhuǎn)帳類別C,2,NNDigest摘要NVC,60FormalaCode公式編碼C,2,(FK) 銀行對帳單表(Cwzz_BankBill) 字段編碼 字段說明字段屬性及長度BankBillID用于編輯時唯一標(biāo)識Int,(PK),NNCcode科目號 References 科目表C,15,(FK)BillDate發(fā)生日期(票據(jù))DatetimeDigest摘要NC,60SSCode結(jié)算方式編碼 References 結(jié)算方式表C,3,(FK)BillNo銀行票號C,8Jfje借方金額MoneyDfje貸方金額MoneyRecType記錄類型（0調(diào)整前余額 1對帳單期初未達 2錄入對帳單）IntBCheckFlag銀行核對標(biāo)志(0未達帳項 1已達帳項)Bit,NNHandWorkFlag手工對帳標(biāo)志（0自動對帳 1手工對帳）Bit,NNBDelete銀行帳核銷標(biāo)志(0未核銷 1已核銷)Bit,NNBalanceMoney 系統(tǒng)編碼方案表：Gy_CodeScheme見公用表 我的報表：Cwzz_MyReport 字段編碼 字段說明 字段屬性I_ID唯一標(biāo)識主鍵INT,(PK),NNCzybm操作員編碼C,3,(FK) ,NNQueryCode查詢功能編碼C,20,(FK),NNQueryName報表名稱NC，20Value查詢條件值C,30 現(xiàn)金流量表報表項目：Cwzz_CashFlowItem 字段編碼 字段說明 字段屬性CashFlowID現(xiàn)金流量項目ID(自動編碼，唯一標(biāo)識)Int,(PK) ,NNLogicId現(xiàn)金流量項目邏輯編碼Int,NNCashFlowCode現(xiàn)金流量項目查找索引編碼VC,6CashFlowName現(xiàn)金流量項目名稱NVc,40,NNRowNO行次VC,3DataSource數(shù)據(jù)來源NVc,50DistributeFlag是否由憑證數(shù)據(jù)分配得到Bit,NN 現(xiàn)金流量表數(shù)據(jù)：Cwzz_CashFlowData(會計分錄分配) 字段編碼 字段說明 字段屬性CashFlowDataID編輯時唯一定位標(biāo)識Int,(PK),NNVouchId憑證唯一關(guān)聯(lián)標(biāo)識Int（FK）Year年度Int（PK）,NNPeriod會計期間Int（PK）,NNCashFlowID現(xiàn)金流量項目唯一標(biāo)識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 科目輔助帳中代碼對應(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 項目主從表視圖：/*==============================================================*//* View: Cwzz_V_Item *//*==============================================================*/create view as SELECT , , , , , , , , , FROM Cwzz_Item LEFT OUTER JOIN Cwzz_ItemClass ON = go 憑證臨時主從表視圖：/*==============================================================*//* 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,