oracle ERP 各模块数据库表关系.ppt

张德全 SeniorTechnicalAnalystOracleCorporation Oracle应用产品重要表用途与关系介绍 概要 了解表的用途及其关系的作用主要功能模块表的用途及其关系库存 INV 采购 PO 销售 OM 物料清单 BOM 在制 WIP 成本 COST 总帐 GL 应收 AR 应付 AP 固定资产 FA 符号说明 A B A B 一对一相关 多对一相关 必须相关 可能相关 库存 INV 库存 INV 库存 INV 库存 INV Email通知 通知浏览器 应用窗 We浏览器 工作流引擎 通知系统 Oracle7 3 2orhigher 工作流监控器 工作流生成 工作流载入器 库存 INV 库存 INV 库存 INV 库存 INV 库存 INV 采购 PO 采购 PO 采购 PO 采购 PO 采购 PO 采购 PO 订单管理 OM OE ORDER HEADERS ALL OE ORDER LINES ALL 订单管理 OM WSH TRIPS WSH TRIP STOPS WSH DELIVERY LEGS WSH NEW DELIVERIES WSH DELIVERY ASSIGNMENTS WSH DELIVERY DETAILS 订单管理 OM OE ORDER LINES ALL WSH DELIVERY DETAILS MTL TXN REQUEST LINES MTL MATERIAL TRANSACTIONS MTL MATERIAL TRANSACTIONS TEMP 物料清单 BOM 物料清单 BOM 物料清单 BOM 在制品 WIP 在制品 WIP 在制品 WIP 在制品 WIP 在制品 WIP 在制品 WIP 在制品 WIP 在制品 WIP 成本 COST 成本 COST 成本 COST 总帐 GL 总帐 GL 总帐 GL 总帐 GL 应收 AR 应收 AR 应收 AR 应付 AP 应付 AP 应付 AP 固定资产 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 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 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 APPLICATION 并发处理 表名缩写对照表 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 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 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