K/3 Cloud 常用表结构(K / 3 cloud common table structure)

以下数据表为金蝶云星空常用数据表。

数据表命名基本规则:

表名前缀:t_ 或者 T_

视图前缀:v_ 或者 V_

多语言表后缀:_L

关联关系表后缀:_LK

一、元数据

元数据: t_meta_objectType

元数据扩展信息表: t_meta_objectType_E

元数据缓存表: T_META_OBJECTTYPECACHE

元数据视图表: T_META_OBJECTTYPEVIEW

元数据视图:V_META_OBJECTTYPE_L

元数据扩展多语言名称:T_META_OBJECTTYPENAMEEX_L

元数据序号: T_META_OBJECTTYPE_E

基础资料元数据信息表: T_META_LOOKUPCLASS

基础资料元数据类型表: T_META_BASEDATATYPE

单据类型表: T_BAS_BILLTYPE,T_BAS_BILLTYPEFLDCTL

枚举元数据表: T_META_FORMENUM

枚举项元数据表: T_META_FORMENUMITEM

转换规则元数据表: T_META_CONVERTRULE

反写规则元数据表: t_bf_writebackrule

反写规则扩展表:t_BF_WriteBackRuleCust

表单和表关系表:T_META_TRACKERBILLTABLE

领域模型:T_MDL_DOMAINMODETYPE

领域子模型:T_MDL_DOMAINMODELSUB_L

元素:T_MDL_ELEMENTTYPE

元素分组:T_MDL_ELEMENTGROUP_L

属性:T_MDL_ELEMENTPROPERTY

领域元素:T_MDL_DOMAINMODELELEMENTMAP

领域元素属性:T_MDL_DOMAINMODELELPROPMAP

表单服务:T_MDL_FORMBUSINESS

操作函数:T_MDL_FORMFUNCTION

操作:T_MDL_FORMOPERATIONTYPE

效验:T_MDL_FORMVALIDATIONTYPE

二、弹性域相关表

辅助属性维度定义:T_BD_FLEXAUXPROPERTY

辅助属性数据表:T_BD_FLEXSITEMDETAILV

仓位值集表维度定义:t_bas_flexValues

仓位值集表维度仓位定义:T_BAS_FLEXVALUESENTRY

仓位值集数据表:t_bas_flexValuesDetail

核算维度维度定义:T_BD_FLEXITEMPROPERTY

核算维度数据表:T_BD_FLEXITEMDETAILV

三、菜单

子系统分组: T_META_TOPCLASS

子系统: T_META_SUBSYSTEM_L

模块: T_META_CONSOLESUBFUNC_L

菜单: T_META_CONSOLEDETAIL

四、权限

对象权限: T_SEC_OBJECTTYPEPERMISSION

权限表: T_SEC_FIELDPERMISSION

权限项表: t_sec_permissionItem

功能权限表: T_SEC_FUNCPERMISSION

功能权限项表: T_SEC_FUNCPERMISSIONENTRY

字段权限表: T_SEC_FIELDPERMISSION

字段权限项表: T_SEC_FIELDPERMISSIONENTRY

用户组织表: T_SEC_USERORG

角色表: T_SEC_ROLE

五、基础资料

基础资料和表:T_META_LOOKUPCLASS

组织表: T_ORG_ORGANIZATIONS

物料: T_BD_MATERIAL

采购价目表: t_PUR_PriceList

采购价目分发表: t_PUR_PriceList_Issue

用户表: T_SEC_USER

部门表: T_BD_DEPARTMENT

员工信息表: T_BD_STAFF

员工任职信息表: T_BD_STAFFPOSTINFO

业务员表: T_BD_OPERATOR

业务员分录表: T_BD_OPERATORENTRY

销售员表: V_BD_SALESMAN

销售员单据体表: V_BD_SALESMANENTRY

岗位信息表: T_ORG_POST\HR_ORG_HRPOST

岗位对应角色表: T_ORG_POSTROLE

辅助资料表:T_BAS_ASSISTANTDATAENTRY

辅助资料类别表:T_BAS_ASSISTANTDATA

基础资料分配表: T_ORG_BASEDATAALLOCATEENTRY

仓库:T_BD_Stock

供应商:t_BD_Supplier

六、 网控

网控对象表: T_BAS_NETWORKCTRLOBJECT

互斥对象表: T_BAS_NETWORKCTRLMUTEX

网络控制表: T_BAS_MUTEX

网控记录表: T_BAS_NETWORKCTRLRECORDS

七、参数

用户参数表: T_BAS_UserParameter

系统参数表: T_BAS_SysParameter

发布参数表: T_BAS_ReleaseParameter

单据参数表: t_BAS_BillGlobalParameter

用户界面参数:T_BAS_FormParameter

八、服务

表单服务表: T_MDL_FORMBUSINESS

操作服务表: T_MDL_FORMOPERATIONTYPE

校验器表:T_MDL_FORMVALIDATIONTYPE

九、日志记录

引出记录表: T_BAS_EXPORTRECORD

上机操作日志表: t_bas_operateLog

上机操作日志备份表: t_bas_operateLogBK

系统日志表: T_BAS_LOG

执行计划日志表:T_BAS_SCHEDULELOG

WebApi日志:T_BAS_WEBAPILOG

十、管理中心

数据中心表: T_BAS_DATACENTER

补丁日志表表: t_bos_installedpackagehis

十一、业务流程图

业务流程版本表: T_BF_DEFVERSION

业务流程发布表: t_BF_Publish

业务流程发布分录表: t_BF_PublishEntry(流程跟单据类型的关系)

业务流程定义单据检索表: T_BF_DEFVERSIONLOOKUP(流程跟表的关系)

业务流程定义表: T_BF_PROCDEF

数据中心表: T_BAS_DATACENTER

十二、反写

反写规则元数据表: t_bf_writebackrule

反写规则元数据扩展表:t_BF_WriteBackRuleCust

反写记录表:t_bf_instanceSnap

反写记录历史表:t_bf_instanceSnapHis

反写记录归档表:t_bf_SnapBackUp

反写日志表: T_BF_WBLOG

十三、业务流程实例

业务流程实例表: t_BF_Instance

业务流程节点表: t_BF_InstanceEntry

业务流程控制字段反写记录表: t_bf_instanceAmount

业务流程实例历史表: t_bf_instanceHis

业务流程节点历史表: t_bf_instanceEntryHis

业务流程控制字段反写记录历史表: t_bf_instanceAmountHis

业务流程实例归档表: t_bf_instBackUp

业务流程节点归档表: t_bf_instEntryBackUp

业务流程控制字段反写记录归档表: t_bf_instAmountBackUp

业务流程压缩文件日志表: t_bf_InstArchiveLog

业务流程压缩文件表: t_BF_ArchiveFiles

十四、过滤方案

过滤方案表: T_BAS_FILTERSCHEME

万能报表默认过滤:T_BOS_DEVREPORTDATASOURCE

十五、单据

销售订单表: T_SAL_ORDER

销售订单明细表: T_SAL_ORDERENTRY

销售出库单表: T_SAL_OUTSTOCK

销售出库单明细表: T_SAL_OUTSTOCKENTRY

应收单表: t_AR_receivable

应收单明细表: t_AR_receivableEntry

应付单表: T_AP_PAYABLE

应付单明细表: T_AP_PAYABLEENTRY

采购订单表: t_PUR_POOrder

采购订单明细表: t_PUR_POOrderEntry

生产订单表: PRD_MO、T_PRD_MO

工序计划表: T_SFC_OPERPLANNING

工序计划系列表: T_SFC_OPERPLANNINGSEQ

工序汇报表: T_SFC_OPTRPTENTRY

工序转移表: T_SFC_OPERATIONTRANSFER

生成入库单:PRD_INSTOCK 、T_PRD_INSTOCK

付款申请单:T_CN_PAYAPPLY

十六、附件和附件信息

附件信息:T_BAS_FileServerFileInfo

附件跟单据关系表:T_BAS_ATTACHMENT

十七、报表

关键字:T_MDL_RPTKEYWORDS

十八、工作流和审批流

流程定义:t_WF_ProcDef

版本:t_wf_DefVersion

流程类型:t_WF_ProcessType

流程模板:t_WF_Template

流程发起配置:t_wf_prclaunchconfig、T_WF_PRCLAUNCHCONFIG_L

流程实例和单据关系:t_WF_PiBiMap

流程实例:T_WF_PROCINST

流程节点实例:T_WF_ACTINST

流程任务:T_WF_ASSIGN

流程任务接收人:T_WF_RECEIVER

流程任务详情:T_WF_APPROVALASSIGN

流程任务处理记录:T_WF_APPROVALITEM

流程反馈信息表:T_WF_DISCUSS

十九、其他

临时表: T_BAS_TEMPORARYTABLENAME

单据类型:T_BAS_BILLTYPE

安装包:t_bos_installedpackage

————————

The following table of Kingdee cloud is the common data.

Basic rules for data table naming:

Table name prefix: t_ Or T_

View prefix: v_ Or V_

Multilingual table suffix:_ L

Association table suffix:_ LK

1、 Metadata

元数据: t_meta_objectType

Metadata extension information table: t_ meta_ objectType_ E

Metadata cache table: t_ META_ OBJECTTYPECACHE

Metadata view chart: t_ META_ OBJECTTYPEVIEW

Metadata view: v_ META_ OBJECTTYPE_ L

Metadata extension multilingual Name: t_ META_ OBJECTTYPENAMEEX_ L

Metadata serial number: t_ META_ OBJECTTYPE_ E

Master data metadata information table: t_ META_ LOOKUPCLASS

Master data metadata type table: t_ META_ BASEDATATYPE

单据类型表: T_BAS_BILLTYPE,T_BAS_BILLTYPEFLDCTL

Enumerating metadata tables: t_ META_ FORMENUM

Enumeration item metadata table: t_ META_ FORMENUMITEM

Conversion rule metadata table: t_ META_ CONVERTRULE

Reverse write rule metadata table: t_ bf_ writebackrule

Table extension: t_ BF_ WriteBackRuleCust

Forms and table relationships: t_ META_ TRACKERBILLTABLE

领域模型:T_MDL_DOMAINMODETYPE

Domain sub model: t_ MDL_ DOMAINMODELSUB_ L

元素:T_MDL_ELEMENTTYPE

Element grouping: t_ MDL_ ELEMENTGROUP_ L

属性:T_MDL_ELEMENTPROPERTY

领域元素:T_MDL_DOMAINMODELELEMENTMAP

领域元素属性:T_MDL_DOMAINMODELELPROPMAP

Form service: t_ MDL_ FORMBUSINESS

Operation function: t_ MDL_ FORMFUNCTION

操作:T_MDL_FORMOPERATIONTYPE

效验:T_MDL_FORMVALIDATIONTYPE

2、 Elastic domain correlation table

Auxiliary attribute dimension definition: t_ BD_ FLEXAUXPROPERTY

Auxiliary attribute data table: t_ BD_ FLEXSITEMDETAILV

Dimension definition of bin value set table: t_ bas_ flexValues

Bin value set table dimension bin definition: t_ BAS_ FLEXVALUESENTRY

Bin value set data table: t_ bas_ flexValuesDetail

Accounting dimension definition: t_ BD_ FLEXITEMPROPERTY

Accounting dimension data table: t_ BD_ FLEXITEMDETAILV

3、 Menu

Subsystem grouping: t_ META_ TOPCLASS

子系统: T_META_SUBSYSTEM_L

模块: T_META_CONSOLESUBFUNC_L

菜单: T_META_CONSOLEDETAIL

4、 Authority

对象权限: T_SEC_OBJECTTYPEPERMISSION

权限表: T_SEC_FIELDPERMISSION

权限项表: t_sec_permissionItem

Function permission table: t_ SEC_ FUNCPERMISSION

功能权限项表: T_SEC_FUNCPERMISSIONENTRY

字段权限表: T_SEC_FIELDPERMISSION

字段权限项表: T_SEC_FIELDPERMISSIONENTRY

User organization table: t_ SEC_ USERORG

Role table: t_ SEC_ ROLE

5、 Basic data

Basic data and table: t_ META_ LOOKUPCLASS

组织表: T_ORG_ORGANIZATIONS

物料: T_BD_MATERIAL

Purchase price list: t_ PUR_ PriceList

Purchase price list Publishing: t_ PUR_ PriceList_ Issue

User table: t_ SEC_ USER

部门表: T_BD_DEPARTMENT

Employee information form: t_ BD_ STAFF

Employee employment information table: t_ BD_ STAFFPOSTINFO

Salesman table: t_ BD_ OPERATOR

Clerk entry table: t_ BD_ OPERATORENTRY

Salesperson table: v_ BD_ SALESMAN

Salesperson document body: v_ BD_ SALESMANENTRY

Job information table: t_ ORG_ POST\HR_ ORG_ HRPOST

Position corresponding role table: t_ ORG_ POSTROLE

辅助资料表:T_BAS_ASSISTANTDATAENTRY

Auxiliary data category table: t_ BAS_ ASSISTANTDATA

基础资料分配表: T_ORG_BASEDATAALLOCATEENTRY

Warehouse: t_ BD_ Stock

Supplier: t_ BD_ Supplier

6、 Network control

网控对象表: T_BAS_NETWORKCTRLOBJECT

互斥对象表: T_BAS_NETWORKCTRLMUTEX

Network control table: t_ BAS_ MUTEX

网控记录表: T_BAS_NETWORKCTRLRECORDS

7、 Parameters

User parameter table: t_ BAS_ UserParameter

System parameter table: t_ BAS_ SysParameter

发布参数表: T_BAS_ReleaseParameter

单据参数表: t_BAS_BillGlobalParameter

User interface parameters: t_ BAS_ FormParameter

8、 Service

Form service table: t_ MDL_ FORMBUSINESS

操作服务表: T_MDL_FORMOPERATIONTYPE

校验器表:T_MDL_FORMVALIDATIONTYPE

9、 Logging

Export record table: t_ BAS_ EXPORTRECORD

Log table of computer operation: t_ bas_ operateLog

Backup table of computer operation log: t_ bas_ operateLogBK

System log table: t_ BAS_ LOG

Execution plan log table: t_ BAS_ SCHEDULELOG

WebApi日志:T_BAS_WEBAPILOG

10、 Management Center

Data center table: t_ BAS_ DATACENTER

补丁日志表表: t_bos_installedpackagehis

11、 Business flow chart

Business process version table: t_ BF_ DEFVERSION

Business process release table: t_ BF_ Publish

Business process publishing entry table: t_ BF_ Publishentry (relationship between process and document type)

Business process definition document retrieval table: t_ BF_ Defversionlookup (relationship between process and table)

Business process definition table: t_ BF_ PROCDEF

Data center table: t_ BAS_ DATACENTER

12、 Reverse writing

Reverse write rule metadata table: t_ bf_ writebackrule

Reverse write rule metadata extension table: t_ BF_ WriteBackRuleCust

Reverse write record table: t_ bf_ instanceSnap

Reverse write record history table: t_ bf_ instanceSnapHis

Reverse write record archive table: t_ bf_ SnapBackUp

Reverse write log table: t_ BF_ WBLOG

13、 Business process instance

Business process instance table: t_ BF_ Instance

Business process node table: t_ BF_ InstanceEntry

Business process control field reverse writing record table: t_ bf_ instanceAmount

Business process instance history table: t_ bf_ instanceHis

Business process node history table: t_ bf_ instanceEntryHis

Business process control field reverse write record history table: t_ bf_ instanceAmountHis

Business process instance archiving table: t_ bf_ instBackUp

Business process node archiving table: t_ bf_ instEntryBackUp

Business process control field reverse write record archiving table: t_ bf_ instAmountBackUp

Business process compressed file log table: t_ bf_ InstArchiveLog

Business process compressed file table: t_ BF_ ArchiveFiles

14、 Filtering scheme

Filter scheme table: t_ BAS_ FILTERSCHEME

Universal report default filter: t_ BOS_ DEVREPORTDATASOURCE

15、 Documents

Sales order form: t_ SAL_ ORDER

Sales order details: t_ SAL_ ORDERENTRY

Sales delivery order table: t_ SAL_ OUTSTOCK

Sales delivery order details: t_ SAL_ OUTSTOCKENTRY

A / R doc table: t_ AR_ receivable

A / R document details: t_ AR_ receivableEntry

A / P sheet: t_ AP_ PAYABLE

A / P document details: t_ AP_ PAYABLEENTRY

Purchase order form: t_ PUR_ POOrder

Purchase order details: t_ PUR_ POOrderEntry

Production order form: PRD_ MO、T_ PRD_ MO

Operation schedule: t_ SFC_ OPERPLANNING

Operation plan series table: t_ SFC_ OPERPLANNINGSEQ

Operation report: t_ SFC_ OPTRPTENTRY

工序转移表: T_SFC_OPERATIONTRANSFER

Generate receipt doc: PRD_ INSTOCK 、T_ PRD_ INSTOCK

Payment application form: t_ CN_ PAYAPPLY

16、 Attachments and attachment information

附件信息:T_BAS_FileServerFileInfo

Attachment document relationship table: t_ BAS_ ATTACHMENT

17、 Statement

关键字:T_MDL_RPTKEYWORDS

18、 Workflow and approval process

Process definition: t_ WF_ ProcDef

版本:t_wf_DefVersion

Process type: t_ WF_ ProcessType

Process template: t_ WF_ Template

流程发起配置:t_wf_prclaunchconfig、T_WF_PRCLAUNCHCONFIG_L

Relationship between process instance and document: t_ WF_ PiBiMap

Process example: t_ WF_ PROCINST

Process node instance: t_ WF_ ACTINST

Process task: t_ WF_ ASSIGN

Process task recipient: t_ WF_ RECEIVER

Process task details: t_ WF_ APPROVALASSIGN

Process task processing record: t_ WF_ APPROVALITEM

Process feedback information form: t_ WF_ DISCUSS

19、 Other

临时表: T_BAS_TEMPORARYTABLENAME

Document type: t_ BAS_ BILLTYPE

安装包:t_bos_installedpackage