金算盘-oracle常用数据表和视图
金算盘-oracle常用数据表和视图
----------------------------------------------------
*****************************************************************
******************************************************************
---------------------------
会计科目:
ACCOUNT
---------------------------
ACCOUNTDAILY
---------------------------
ACCOUNTEX
---------------------------
ACCOUNTPERIOD
---------------------------
科目类型
ACCOUNTTYPE
---------------------------
年度
ACCOUNTYEAR
---------------------------
单据类型
ACTIVITYTYPE
---------------------------
账期
AGEPERIOD
---------------------------
固定资产来源类型
ASSETALTERTYPE
ASSETALTERTYPEEX
---------------------------
固定资产类型
ASSETGROUP
ASSETKIND
---------------------------
固定资产使用状态
ASSETSTATE
---------------------------
无形资产类型
ASSETTYPEBASE
---------------------------
BANKBILLTOTEMPLATE
---------------------------
结算方式
BANKBILLTYPE
---------------------------
BANKBILLUSE
---------------------------
地区行政级别
BUDGETGRADE
---------------------------
BUSINESS
---------------------------
现金流量项目
CASHITEM
---------------------------
CLASS2GROUP
---------------------------
CLASSCOST
---------------------------
辅助核算项目类别
CODEHANDLEITEM
---------------------------
CODERULEITEM
---------------------------
CODEUSEINFO
---------------------------
CONSUMPTIONMETHOD
---------------------------
CONSUMPTIONTYPE
---------------------------
币别种类
CURRENCYS
---------------------------
客户档案?
CUSTOMER
CUSTOMEREX
---------------------------
往来单位类型
CUSTOMERSET
---------------------------
客户类型
CUSTOMERTYPE
---------------------------
DEFEREDMETHOD
---------------------------
DEFEREDTYPE
---------------------------
部门档案
DEPARTMENT
---------------------------
学历
EDUCATION
---------------------------
职员类型
EMPLOYEETYPE
---------------------------
ENUMTABLE
---------------------------
ENUMTABTYPE
---------------------------
ERPEXPORTTYPE
---------------------------
报表
ETSETTING
---------------------------
FBCOMMONPROJECT
---------------------------
FBDATARULE
---------------------------
字段类型
FBDATATYPE
---------------------------
FBDUTYCENTER
---------------------------
FBFORMULA
---------------------------
FBSYSTEM
---------------------------
FBTYPE
---------------------------
FIXEDACCOUNT
---------------------------
FIXEDALTER
---------------------------
FIXEDBALANCE
---------------------------
FIXEDBATCHALTER
---------------------------
FIXEDBATCHALTERDETAIL
---------------------------
FIXEDCARD
---------------------------
FIXEDCOST
---------------------------
FIXEDDAILY
---------------------------
FIXEDDAILYDEPT
---------------------------
FIXEDDEPARTMENT
---------------------------
FIXEDDEPR1
FIXEDDEPR2
---------------------------
FIXEDMETHOD
---------------------------
FIXEDMETHODEX
---------------------------
FIXEDTYPE
---------------------------
FIXEDTYPEEX
---------------------------
FIXEDVOUCHERDETAIL
---------------------------
FLEXIBLETITLE
---------------------------
FLEXIBLEUSEFIELD
---------------------------
FLOWSPECIALTYPE
---------------------------
FONT
---------------------------
GROUPTORIGHT
---------------------------
GROUPTORIGHTDETAIL
---------------------------
HANDSCREEN
---------------------------
HANDSCREENCHILDMENU
---------------------------
HANDSCREENCHILDMENUSET
---------------------------
HANDSCREENEMPLOYEE
---------------------------
HANDSCREENLEFTGRID
---------------------------
HANDSCREENLEFTMENU
---------------------------
HANDSCREENPROPERTYSET
---------------------------
IMMATERIALMETHOD
---------------------------
IMMATERIALTYPE
---------------------------
INITORGCONFIG
---------------------------
INOUTFIELD
---------------------------
INOUTTYPE
---------------------------
ITEMCUSTOMSETTING
---------------------------
JOBSTATUS
---------------------------
LIST
---------------------------
LISTCOND
---------------------------
LISTFIELD
---------------------------
LISTMULTIIDCOND
---------------------------
LOCATION
---------------------------
LOG
---------------------------
MENUFREQUENCIES
---------------------------
MENUGLOBAL
---------------------------
MENUSCHEME
---------------------------
MENUSCHEMEDETAIL
---------------------------
MODULE
---------------------------
MODULEGROUP
---------------------------
MODULEGROUPDETAIL
---------------------------
MSG
---------------------------
各家银行名称
NORMALBANK
---------------------------
OPERATEFLOW
OPERATEFLOWRECEIPTTYPE
---------------------------
用户名称
OPERATOR
---------------------------
OPERATORACCOUNT
---------------------------
OPERATORACCOUNTUSE
---------------------------
OPERATORALLRIGHT
---------------------------
OPERATORCUSTOMERUSE
---------------------------
OPERATORFLOW
---------------------------
用户所属组
OPERATORGROUP
---------------------------
OPERATORREPORT
OPERATORRIGHT
---------------------------
所属机关类型
ORGNATURE
---------------------------
ORGOPERATORALLOT
---------------------------
投资来源(资金来源)
OUTLAYCHANNEL
---------------------------
付款方式
PAYMENTMETHOD
---------------------------
PERSONTAX
---------------------------
人员来源
PERSONTAXTYPE
---------------------------
POSITIONGROUP
---------------------------
POSITIONSTATUS
---------------------------
PRINTSETUP
---------------------------
PRODUCECUSTOMFIELD
---------------------------
PROTEMPLATE
---------------------------
RECEIPT
---------------------------
RECEIPTMAXNO
---------------------------
RECEIPTNORULE
---------------------------
RECEIPTTYPE
---------------------------
REMARK
---------------------------
REPORT
---------------------------
REPORTANALYSISDATA
---------------------------
REPORTCOND
---------------------------
REPORTFIELD
---------------------------
REPORTFILTER
---------------------------
REPORTGROUP
---------------------------
REPORTHEADTAIL
---------------------------
REPORTMULTIIDCOND
---------------------------
REPORTONLYDATA
---------------------------
REPORTPAPER
---------------------------
REPORTSPECIALCOLUMN
---------------------------
REPORTUPDATE
---------------------------
REPORTUPDATEHEAD
---------------------------
RIGHT
---------------------------
权限组
RIGHTGROUP
---------------------------
RIGHTGROUPDETAIL
---------------------------
报表项目名称
RMITEM
---------------------------
报表名称
RMITEMTYPE
---------------------------
RMTARGET
---------------------------
RMTYPE
---------------------------
RTDATAFIELD
---------------------------
RTDATATABLE
---------------------------
RTDUTYCENTER
---------------------------
RTFORMULACHECK
---------------------------
RTITEM
---------------------------
RTSCHEME
---------------------------
RTSYSTEM
---------------------------
RTTARGET
---------------------------
RTTEMPLATE
---------------------------
RTTEMPLATEFIELD
---------------------------
RTTEMPLATEREGION
---------------------------
RTTEMPLATEREGIONBINDING
---------------------------
RTTYPE
---------------------------
SELGROUPRIGHT
---------------------------
SETTING
---------------------------
STDVOUCHER
---------------------------
STDVOUCHERDETAIL
---------------------------
SYSACCOUNTPERIOD
---------------------------
SYSACCOUNTYEAR
---------------------------
SYSAGEPERIOD
---------------------------
SYSCLASS2GROUP
---------------------------
SYSCLASSCOST
---------------------------
SYSETSETTING
---------------------------
SYSFLEXIBLERECEIPTUSEFIELD
---------------------------
SYSGROUPTORIGHT
---------------------------
SYSMODULE
---------------------------
SYSOPERATORFLOW
---------------------------
SYSOPERATORREPORT
---------------------------
SYSOPERATORRIGHT
---------------------------
SYSREPORT
---------------------------
SYSREPORTANALYSISDATA
---------------------------
SYSREPORTCOND
---------------------------
SYSREPORTFIELD
---------------------------
SYSREPORTFILTER
---------------------------
SYSREPORTMULTIIDCOND
---------------------------
SYSREPORTSPECIALCOLUMN
---------------------------
SYSRIGHTGROUP
---------------------------
SYSRIGHTGROUPDETAIL
---------------------------
SYSSETTING
---------------------------
SYSTEMPLATE
---------------------------
SYSTEMPLATEFORMAT
---------------------------
SYSTEMPLATESCHEME
-----------------------------
SYSXMBBCOLSETTING
-----------------------------
SYSXMBBFORMULAR
-----------------------------
SYSXMBBREPORT
-----------------------------
SYSXMBBROWSETTING
-----------------------------
TAX
-----------------------------
TEMPLATE
-----------------------------
TEMPLATEFORMAT
-----------------------------
TERM
-----------------------------
职务
TITLE
-----------------------------
行业
TRADE
-----------------------------
USERMENU
-----------------------------
VIEW1
-----------------------------
VIEWFIELD
-----------------------------
VIEWHEAD
-----------------------------
凭证
VOUCHER
-----------------------------
VOUCHERCASHFLOW
-----------------------------
VOUCHERDETAIL
-----------------------------
凭证字
VOUCHERTYPE
VOUCHERTYPEEX
-----------------------------
WORKFLOWCONDTREE
-----------------------------
XMBBROWSETTING
-----------------------------
ZCXASSETCARDTYPE
-----------------------------
ZCXDICTIONARY
-----------------------------
ZCXIOTURNRULE
-----------------------------
ZCXIOVALIDRULE
-----------------------------
ZCXREPORTTURNRULE
-----------------------------
ZCXTURNITEM
-----------------------------
ZCXTURNSETTING
-----------------------------
*****************************************************************
******************************************************************
视图
---------------------------------------------------
---------------------------------------------------
单据类型
ALLRECEIPTTYPE
---------------------------------------------------
年度期间
ALTERID
ALTERINITID
---------------------------------------------------
凭证
APPQUERY
APPQUERY2
APQUERY
APQUERY2
---------------------------------------------------
ARAPPAYMONEY
ARAPQUERYJC
---------------------------------------------------
ARQUERY2
ARQUERY222
---------------------------------------------------
ARRQUERY2
---------------------------------------------------
ASSETTYPE
ASSETTYPELIST
ASSETTYPEORG1
ASSETTYPEORG101
---------------------------------------------------
期初
BANKMONEY
BANKMONEY2
---------------------------------------------------
BUDGETQUERY
---------------------------------------------------
CASHFLOWTOBECUT
---------------------------------------------------
COLLATE
---------------------------------------------------
COLLATE0
---------------------------------------------------
CUSTOMERBALANCEDETAIL
CUSTOMERBALANCEDETAIL1
---------------------------------------------------
CUSTOMEREXVIEW
---------------------------------------------------
CUSTOMERVIEW
---------------------------------------------------
FIXBALID
FIXEDALTERBALANCEID
FIXEDALTERBALANCEIDEX
FIXEDDEPREINCREASEACCOUNT
FIXEDPERIODCALC
FIXEDPERIODCALC1
---------------------------------------------------
FORMATDESIGNQUERY
---------------------------------------------------
ITEMSTOCKQUANTITY
---------------------------------------------------
MZWWORK
---------------------------------------------------
NEWACCOUNT
---------------------------------------------------
OPERATORRIGHTQUERY
OPERATORRIGHTQUERY1
---------------------------------------------------
PRINTFIXEDCARDHEAD
---------------------------------------------------
QMZWFIXEDBALANCE
---------------------------------------------------
QMZWMAXFIXED
---------------------------------------------------
SALARYFIELDQUERY
SALARYITEM
---------------------------------------------------
凭证
SEARCHFILTER
SEARCHFROMSQL2
SEARCHSELFROM
---------------------------------------------------
V_PLANEXECUTE
V_PURCHASEFINISH
---------------------------------------------------
VOUCHER2
---------------------------------------------------
VOUCHERCASHFLOW2
VOUCHERQUERY
---------------------------------------------------
VOUCHERROW
---------------------------------------------------
WRACNTBALANCE
---------------------------------------------------
WRACNTBALANCE1
---------------------------------------------------
WRACNTCURRENCY
---------------------------------------------------
WRACNTDAILY
---------------------------------------------------
WRACNTFUNC2
---------------------------------------------------
WRFIX
---------------------------------------------------
WRFIX2
---------------------------------------------------
WRFIXVOUCHER
---------------------------------------------------
