浪潮軟件財(cái)務(wù)數(shù)據(jù)結(jié)構(gòu)

1、第一部分第一部分基本表基本表外幣字典外幣字典(LSWBZD)別名列名數(shù)據(jù)類型空值缺省規(guī)則注釋外幣編號(hào)LSWBZD_WBBHvar(10)No幣名LSWBZD_BMvar(30)No代表符LSWBZD_DBF(4)標(biāo)價(jià)方法LSWBZD_BJFF(1)No‘1’‘1’’2’‘1’:直接標(biāo)價(jià)法‘2’:間接標(biāo)價(jià)法匯率方式LSWBZD_HLFS(1)No‘1’‘1’’2’‘1’:固定匯率‘2’:現(xiàn)行匯率精度LSWBZD_JDIntNo2折算誤差L

2、SWBZD_ZSWCU001No0是否本位幣LSWBZD_BWB(1)No‘0’‘0’’1’‘1’:是‘0’:否Index:uniqueclusteredlswbzdon(LSWBZD_BH)固定匯率表固定匯率表(LSGDHL)現(xiàn)行匯率表現(xiàn)行匯率表(LSXXHL)會(huì)計(jì)期間會(huì)計(jì)期間(LSKJQJ)部門字典部門字典(LSBMZD)別名列名數(shù)據(jù)類型空值缺省規(guī)則注釋部門編號(hào)LSBMZD_BMBHvar(20)No部門名稱LSBMZD_BMMCV

3、ar(40)No級(jí)數(shù)LSBMZD_JS(1)No‘1’明細(xì)否LSBMZD_MX(1)No‘1’備注LSBMZD_NOTEVar(60)Index:uniqueclusteredlsbmzdon(LSBMZD_BMBH)環(huán)境配置環(huán)境配置(LSCONF)別名列名數(shù)據(jù)類型空值缺省規(guī)則注釋系統(tǒng)變量F_VKEYvar(20)No變量值F_VALVar(255)No備注F_NOTEVar(60)Index:uniqueclusteredlsconf

4、on(F_VKEY)類型ZWKMZD_XX03Var(30)均可重新定義現(xiàn)金限額ZWKMZD_XJXEU0001No0原始憑證ZWKMZD_YSPZ(2)臺(tái)帳類別ZWKMZD_TZLB(2)期末結(jié)平ZWKMZD_QMJP(1)No‘0’‘0’’1’定義總帳科目期末是否結(jié)平Index:1.uniqueclusteredzwkmzdon(ZWKMZD_KMBH)2.uniquezwkmzd_jsbhon(ZWKMZD_JSZWKMZD_KM

5、BH)科目金額余額帳科目金額余額帳(ZWKMJE)別名列名數(shù)據(jù)類型空值缺省規(guī)則注釋科目編號(hào)ZWKMJE_KMBHvar(30)No會(huì)計(jì)年度ZWKMJE_KJND(4)No會(huì)計(jì)期間ZWKMJE_KJQJ(2)No年初余額ZWKMJE_NCYEU001No0借方累計(jì)ZWKMJE_JFLJU001NO0貸方累計(jì)ZWKMJE_DFLJU001No0借方發(fā)生ZWKMJE_JFFSU001No0貸方發(fā)生ZWKMJE_DFFSU001No0當(dāng)前余額Z

6、WKMJE_DQYEU001No0Index:1.uniqueclusteredzwkmjeon(ZWKMJE_KMBHZWKMJE_KJQJZWKMJE_KJND)2.uniquezwkmje_qjbhon(ZWKMJE_KJNDZWKMJE_KJQJZWKMJE_KMBH)科目數(shù)量余額帳科目數(shù)量余額帳(ZWKMSL)記錄科目各月的數(shù)量發(fā)生額及余額信息；外幣余額帳外幣余額帳(ZWKMWB)記錄科目各月的外幣發(fā)生額及余額信息；部門字典部

7、門字典(ZWBMZD)別名列名數(shù)據(jù)類型空值缺省規(guī)則注釋部門編號(hào)ZWBMZD_BMBHvar(20)No部門名稱ZWBMZD_BMMCVar(40)No級(jí)數(shù)ZWBMZD_JS(1)No‘1’明細(xì)否ZWBMZD_MXintNo1備注ZWBMZD_NOTEVar(60)Index:uniqueclusteredzwbmzdon(ZWBMZD_BMBH)職工字典職工字典(ZWZGZD)別名列名數(shù)據(jù)類型空值缺省規(guī)則注釋職工編號(hào)ZWZGZD_ZGB