ORACLE erp 内部数据结构课件

ORACLEerp内部数据结构课件张德全SeniorTechnicalAnalystOracleCorporation张德全SeniorTechnicalAnalystOracle应用产品重要表用途与关系介绍Oracle应用产品重要表用途与关系介绍概要了解表的用途及其关系的作用主要功能模块表的用途及其关系库存(INV),采购(PO),销售(OM)物料清单(BOM),在制(WIP),成本(COST)总帐(GL),应收(AR),应付(AP),固定资产(FA)概要了解表的用途及其关系的作用符号说明ABAB一对一相关多对一相关必须相关可能相关符号说明ABAB一对一相关多对一相关必须相关可能相关库存(INV)库存(INV)库存(INV)

库存(INV)库存(INV)

库存(INV)库存(INV)Email通知通知浏览器应用窗We浏览器工作流引擎通知系统Oracle7.3.2orhigher工作流监控器工作流生成工作流载入器库存(INV)Email通知通知浏览器应用窗We浏览器工作库存(INV)

库存(INV)库存(INV)

库存(INV)库存(INV)

库存(INV)库存(INV)库存(INV)库存(INV)库存(INV)采购(PO)采购(PO)采购(PO)采购(PO)采购(PO)采购(PO)采购(PO)

采购(PO)采购(PO)

采购(PO)采购(PO)采购(PO)订单管理(OM)

OE_ORDER_HEADERS_ALLOE_ORDER_LINES_ALL订单管理(OM)OE_ORDER_HEADERS_ALLO订单管理(OM)

WSH_TRIPSWSH_TRIP_STOPSWSH_DELIVERY_LEGSWSH_NEW_DELIVERIESWSH_DELIVERY_ASSIGNMENTSWSH_DELIVERY_DETAILS订单管理(OM)WSH_TRIPSWSH_TRIP_STO订单管理(OM)

OE_ORDER_LINES_ALLWSH_DELIVERY_DETAILSMTL_TXN_REQUEST_LINESMTL_MATERIAL_TRANSACTIONSMTL_MATERIAL_TRANSACTIONS_TEMP订单管理(OM)OE_ORDER_LINES_ALLWSH物料清单(BOM)物料清单(BOM)物料清单(BOM)

物料清单(BOM)物料清单(BOM)

物料清单(BOM)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)成本(COST)成本(COST)成本(COST)成本(COST)成本(COST)成本(COST)总帐(GL)总帐(GL)总帐(GL)总帐(GL)总帐(GL)总帐(GL)总帐(GL)总帐(GL)应收(AR)应收(AR)应收(AR)应收(AR)应收(AR)应收(AR)应付(AP)应付(AP)应付(AP)应付(AP)应付(AP)应付(AP)固定资产(FA)固定资产(FA)固定资产(FA)固定资产(FA)固定资产(FA)固定资产(FA)弹性域弹性域表名缩写对照表FND_IFS:FND_ID_FLEX_SEGMENTSFND_SAV:FND_SEGMENT_ATTRIBUTE_VALUESFND_SFA:FND_SHORTHAND_FLEX_ALIASESFND_IFSTR:FND_ID_FLEX_STRUCTUREFND_FVS:FND_FLEX_VALUE_SETSFND_FVRS:FND_FLEX_VALIDATION_RULE_STATSFND_FERL:FND_FLEX_EXCLUDE_RULE_LINESFND_FVR:FND_FLEX_VALIDATION_RULESFND_FVQ:FND_FLEX_VALIDATION_QUALIFIERSFND_FVRL:FND_FLEX_VALIDATION_RULE_LINESFND_VAT:FND_VALUE_ATTRIBUTE_TYPESFND_FIRL:FND_FLEX_INCLUDE_RULE_LINESFND_CIFS:FND_COMPILED_ID_FLEX_STRUCTSFND_SAT:FND_SEGMENT_ATTRIBUTE_TYPESFND_CIF:FND_COMPILED_ID_FLEXSFND_IF:FND_ID_FLEXSFND_APP:FND_APPLICATIONFND_TAB:FND_TABLESWF_RPV:WF_RUNNABLE_PROCESSES_VFND_FWP:FND_FLEX_WORKFLOW_PROCESSES表名缩写对照表FND_IFS:FND_ID_FLEX_SE弹性域弹性域弹性域弹性域表名缩写对照表FND_FVH:FND_FLEX_VALUE_HIERARCHIESFND_FVS:FND_FLEX_VALUE_SETSFND_IFS:FND_ID_FLEX_SEGMENTSFND_FVNH:FND_FLEX_VALUE_NORM_HIERARCHYFND_FH:FND_FLEX_HIERARCHIESFND_FV:FND_FLEX_VALUESFND_FVE:FND_FLEX_VALIDATION_EVENTSFND_FVRL:FND_FLEX_VALUE_RULE_LINESFND_FVR:FND_FLEX_VALUE_RULESFND_FVRU:FND_FLEX_VALUE_RULE_USAGESFND_RESP:FND_RESPONSIBILITYFND_TAB:FND_TABLESFND_FVT:FND_FLEX_VALIDATION_TABLES表名缩写对照表FND_FVH:FND_FLEX_VALUE并发管理器并发管理器FND_CCR:FND_CONCURRENT_COMPLEX_RULESFND_CCL:FND_CONCURRENT_COMPLEX_LINESFND_CPG:FND_CONCURRENT_PROGRAMSFND_CRC:FND_CONCURRENT_REQUEST_CLASSFND_OID:FND_ORACLE_USERIDFND_USER:FND_USERFND_CGC:FND_CONCURRENT_QUEUE_CONTENTFND_CR:FND_CONCURRENT_REQUESTSFND_NDS:FND_NODESFND_CPR:FND_CONCURRENT_PROCESSESFND_DG:FND_DATA_GROUPSFND_CQP:FND_CONCURRENT_QUEUE_PARAMSFND_CQ:FND_CONCURRENT_QUEUESFND_CPP:FND_CONC_PROCESSOR_PROGRAMSFND_CPS:FND_CONCURRENT_PROCESSORSFND_CQS:FND_CONCURRENT_QUEUE_SIZEFND_CTP:FND_CONCURRENT_TIME_PERIODSFND_APP:FND_APPLICATIONFND_CCR:FND_CONCURRENT_COMPLEX并发处理并发处理表名缩写对照表FND_CPA:FND_CONC_PP_ACTIONSFND_CRA:FND_CONC_REQUEST_ARGUMENTSFND_RRL:FND_RUN_REQ_LANGUAGESFND_CR:FND_CONCURRENT_REQUESTSFND_CD:FND_CONFLICT_DOMAINSFND_RES:FND_RESPONSIBILYFND_CRC:FND_CONC_RELEASE_CLASSESFND_DGU:FND_DATA_GROUP_UNITSFND_LOG:FND_LOGINSFND_DG:FND_DATA_GROUPSFND_OID:FND_ORACLE_USERIDFND_USR:FND_USERFND_CRC:FND_CONCURRENT_REQUEST_CLASSFND_CPS:FND_CONCURRENT_PROGRAM-SERIALFND_CPG:FND_CONCURRENT-PROGRAMSFND_EXE:FND_EXECUTABLES表名缩写对照表FND_CPA:FND_CONC_PP_ACT标准请求标准请求表名缩写对照表FND_RGU:FND_REQUEST_GROUP_UNITSFND_RS:FND_REQUEST_SETSFND_RSS:FND_REQUEST_SET_STAGESFND_RRA:FND_RUN_REQ_PP_ACTIONSFND_RG:FND_REQUEST_GROUPSFND_RSP:FND_REQUEST_SET_PROGRAMSFND_RSA:FND_REQUEST_SET_PROGRAM_ARGSFND_RR:FND_RUN_REQUESTSFND_DF:FND-DESCRIPTIVE_FLEXSFND_CPG:FND_CONCURRENT_PROGRAMSFND_RES:FND_RESPONSIBILITYFND_APP:FND_APPLICATION表名缩写对照表FND_RGU:FND_REQUEST_GRO功能安全功能安全登录安全登录安全表名缩写对照表FND_URG:FND_USER_RESP_GROUPSFND_RES:FND_RESPONSIBILITYFND_SG:FND_SECURITY_GROUPSFND_APP:FND_APPLICATIONFND_DGU:FND_DATA_GROUP_UNITSFND_AS:FND_APPLICATION_SERVERSFND_OID:FND_ORACLE_USERIDFND_DG:FND_DATA_GROUPSFND_SESS:FND_SESSIONSFND_LRF:FND_LOGIN_RESP_FORMSFND_LR:FND_LOGIN_RESPONSIBILITIESFND_LOG:FND_LOGINSFND_UL:FND_UNSUCCESSFUL_LOGINSFND_USER:FND_USER表名缩写对照表FND_URG:FND_USER_RESP_G预置文件预置文件数据字典数据字典货币与语言货币与语言Thankyou.Thankyou.ORACLEerp内部数据结构课件张德全SeniorTechnicalAnalystOracleCorporation张德全SeniorTechnicalAnalystOracle应用产品重要表用途与关系介绍Oracle应用产品重要表用途与关系介绍概要了解表的用途及其关系的作用主要功能模块表的用途及其关系库存(INV),采购(PO),销售(OM)物料清单(BOM),在制(WIP),成本(COST)总帐(GL),应收(AR),应付(AP),固定资产(FA)概要了解表的用途及其关系的作用符号说明ABAB一对一相关多对一相关必须相关可能相关符号说明ABAB一对一相关多对一相关必须相关可能相关库存(INV)库存(INV)库存(INV)

库存(INV)库存(INV)

库存(INV)库存(INV)Email通知通知浏览器应用窗We浏览器工作流引擎通知系统Oracle7.3.2orhigher工作流监控器工作流生成工作流载入器库存(INV)Email通知通知浏览器应用窗We浏览器工作库存(INV)

库存(INV)库存(INV)

库存(INV)库存(INV)

库存(INV)库存(INV)库存(INV)库存(INV)库存(INV)采购(PO)采购(PO)采购(PO)采购(PO)采购(PO)采购(PO)采购(PO)

采购(PO)采购(PO)

采购(PO)采购(PO)采购(PO)订单管理(OM)

OE_ORDER_HEADERS_ALLOE_ORDER_LINES_ALL订单管理(OM)OE_ORDER_HEADERS_ALLO订单管理(OM)

WSH_TRIPSWSH_TRIP_STOPSWSH_DELIVERY_LEGSWSH_NEW_DELIVERIESWSH_DELIVERY_ASSIGNMENTSWSH_DELIVERY_DETAILS订单管理(OM)WSH_TRIPSWSH_TRIP_STO订单管理(OM)

OE_ORDER_LINES_ALLWSH_DELIVERY_DETAILSMTL_TXN_REQUEST_LINESMTL_MATERIAL_TRANSACTIONSMTL_MATERIAL_TRANSACTIONS_TEMP订单管理(OM)OE_ORDER_LINES_ALLWSH物料清单(BOM)物料清单(BOM)物料清单(BOM)

物料清单(BOM)物料清单(BOM)

物料清单(BOM)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)在制品(WIP)成本(COST)成本(COST)成本(COST)成本(COST)成本(COST)成本(COST)总帐(GL)总帐(GL)总帐(GL)总帐(GL)总帐(GL)总帐(GL)总帐(GL)总帐(GL)应收(AR)应收(AR)应收(AR)应收(AR)应收(AR)应收(AR)应付(AP)应付(AP)应付(AP)应付(AP)应付(AP)应付(AP)固定资产(FA)固定资产(FA)固定资产(FA)固定资产(FA)固定资产(FA)固定资产(FA)弹性域弹性域表名缩写对照表FND_IFS:FND_ID_FLEX_SEGMENTSFND_SAV:FND_SEGMENT_ATTRIBUTE_VALUESFND_SFA:FND_SHORTHAND_FLEX_ALIASESFND_IFSTR:FND_ID_FLEX_STRUCTUREFND_FVS:FND_FLEX_VALUE_SETSFND_FVRS:FND_FLEX_VALIDATION_RULE_STATSFND_FERL:FND_FLEX_EXCLUDE_RULE_LINESFND_FVR:FND_FLEX_VALIDATION_RULESFND_FVQ:FND_FLEX_VALIDATION_QUALIFIERSFND_FVRL:FND_FLEX_VALIDATION_RULE_LINESFND_VAT:FND_VALUE_ATTRIBUTE_TYPESFND_FIRL:FND_FLEX_INCLUDE_RULE_LINESFND_CIFS:FND_COMPILED_ID_FLEX_STRUCTSFND_SAT:FND_SEGMENT_ATTRIBUTE_TYPESFND_CIF:FND_COMPILED_ID_FLEXSFND_IF:FND_ID_FLEXSFND_APP:FND_APPLICATIONFND_TAB:FND_TABLESWF_RPV:WF_RUNNABLE_PROCESSES_VFND_FWP:FND_FLEX_WORKFLOW_PROCESSES表名缩写对照表FND_IFS:FND_ID_FLEX_SE弹性域弹性域弹性域弹性域表名缩写对照表FND_FVH:FND_FLEX_VALUE_HIERARCHIESFND_FVS:FND_FLEX_VALUE_SETSFND_IFS:FND_ID_FLEX_SEGMENTSFND_FVNH:FND_FLEX_VALUE_NORM_HIERARCHYFND_FH:FND_FLEX_HIERARCHIESFND_FV:FND_FLEX_VALUESFND_FVE:FND_FLEX_VALIDATION_EVENTSFND_FVRL:FND_FLEX_VALUE_RULE_LINESFND_FVR:FND_FLEX_VALUE_RULESFND_FVRU:FND_FLEX_VALUE_RULE_USAGESFND_RESP:FND_RESPONSIBILITYFND_TAB:FND_TABLESFND_FVT:FND_FLEX_VALIDATION_TABLES表名缩写对照表FND_FVH:FND_FLEX_VALUE并发管理器并发管理器FND_CCR:FND_CONCURRENT_COMPLEX_RULESFND_CCL:FND_CONCURRENT_COMPLEX_LINESFND_CPG:FND_CONCURRENT_PROGRAMSFND_CRC:FND_CONCURRENT_REQUEST_CLASSFND_OID:FND_ORACLE_USERIDFND_USER:FND_USERFND_CGC:FND_CONCURRENT_QUEUE_CONTENTFND_CR:FND_CONCURRENT_REQUESTSFND_NDS:FND_NODESFND_CPR:FND_CONCURRENT_PROCESSESFND_DG:FND_DATA_GROUPSFND_CQP:FND_CONCURRENT_QUEUE_PARAMSFND_CQ:FND_CONCURRENT_QUEUESFND_CPP:FND_CONC_PROCESSOR_PROGRAMSFND_CPS:FND_CONCURRENT_PROCESSORSFND_CQS:FND_CONCURRENT_QUEUE_SIZEFND_CTP:FND_CONCURRENT_TIME_PERIODSFND_APP:FND_APPLICATIONFND_CCR:FND_CONCURRENT_COMPLEX并发处理并发处理表名缩写对照表FND_CPA:FND_CONC_PP_ACTIONSFND_CRA:FND_CONC_REQUEST_ARGUMENTSFND_RRL:FND_RUN_REQ_LANGUAGESFND_CR:FND_CONCURRENT_REQUESTSFND_CD:FND_CONFLICT_DOMAINSFND_RES:FND_RESPONSIBILYFND_CRC:FND_CONC_RELEASE_CLASSESFND_DGU:FND_DATA_GROUP_UNITSFND_LOG:FND_LOGINSFND_DG:FND_DATA_GROUPSFND_OID:FND_ORACLE_USERIDFND_USR:FND_USERFND_CRC:FND_CONCURRENT_REQUEST_CLASSFND_CPS:FND_CONCURRENT_PROGRAM-SERIALFND_CPG:FND_CONCURRENT-PROGRAMSFND_EXE:FND_EXECUTABLES表名缩写对照表FND_CPA:FND_CONC_PP_ACT标准请求标准请求表名缩写对照表FND_RGU:FND_REQUEST_GROUP_UNITS