1、張德全張德全Senior Technical AnalystOracle CorporationOracle 應(yīng)用產(chǎn)品重要表應(yīng)用產(chǎn)品重要表用途與關(guān)系介紹用途與關(guān)系介紹概要概要l了解表的用途及其關(guān)系的作用了解表的用途及其關(guān)系的作用l主要功能模塊表的用途及其關(guān)系主要功能模塊表的用途及其關(guān)系l庫(kù)存庫(kù)存(INV),采購(gòu)采購(gòu)(PO),銷(xiāo)售銷(xiāo)售(OM)l物料清單物料清單(BOM),在制在制(WIP),成本成本(COST)l總帳總帳(GL),應(yīng)收應(yīng)收(AR),應(yīng)付應(yīng)付(AP),固定資產(chǎn)固定資產(chǎn)(FA)符號(hào)說(shuō)明符號(hào)說(shuō)明ABAB一對(duì)一相關(guān)多對(duì)一相關(guān)必須相關(guān)可能相關(guān)庫(kù)存庫(kù)存(INV)庫(kù)存庫(kù)存(INV) 庫(kù)存庫(kù)存(

2、INV) 庫(kù)存庫(kù)存(INV)Email通知通知通知瀏覽器通知瀏覽器應(yīng)用窗應(yīng)用窗We 瀏覽器瀏覽器工作流引擎工作流引擎通知系統(tǒng)通知系統(tǒng)Oracle 7.3.2 or higher工作流監(jiān)控器工作流監(jiān)控器工作流生成工作流生成工作流載入器工作流載入器庫(kù)存庫(kù)存(INV) 庫(kù)存庫(kù)存(INV) 庫(kù)存庫(kù)存(INV) 庫(kù)存庫(kù)存(INV)庫(kù)存庫(kù)存(INV)采購(gòu)采購(gòu)(PO)采購(gòu)采購(gòu)(PO)采購(gòu)采購(gòu)(PO)采購(gòu)采購(gòu)(PO) 采購(gòu)采購(gòu)(PO) 采購(gòu)采購(gòu)(PO)訂單管理訂單管理(OM) OE_ORDER_HEADERS_ALLOE_ORDER_LINES_ALL訂單管理訂單管理(OM) WSH_TRIPSWSH_TRI

3、P_STOPSWSH_DELIVERY_LEGSWSH_NEW_DELIVERIESWSH_DELIVERY_ASSIGNMENTSWSH_DELIVERY_DETAILS訂單管理訂單管理(OM) OE_ORDER_LINES_ALLWSH_DELIVERY_DETAILSMTL_TXN_REQUEST_LINESMTL_MATERIAL_TRANSACTIONSMTL_MATERIAL_TRANSACTIONS_TEMP物料清單物料清單(BOM)物料清單物料清單(BOM) 物料清單物料清單(BOM) 在制品在制品(WIP)在制品在制品(WIP)在制品在制品(WIP)在制品在制品(WIP)在制

4、品在制品(WIP)在制品在制品(WIP)在制品在制品(WIP)在制品在制品(WIP)成本成本(COST)成本成本(COST)成本成本(COST)總帳總帳(GL)總帳總帳(GL)總帳總帳(GL)總帳總帳(GL)應(yīng)收應(yīng)收(AR)應(yīng)收應(yīng)收(AR)應(yīng)收應(yīng)收(AR)應(yīng)付應(yīng)付(AP)應(yīng)付應(yīng)付(AP)應(yīng)付應(yīng)付(AP)固定資產(chǎn)固定資產(chǎn)(FA)固定資產(chǎn)固定資產(chǎn)(FA)固定資產(chǎn)固定資產(chǎn)(FA)彈性域彈性域表名縮寫(xiě)對(duì)照表表名縮寫(xiě)對(duì)照表FND_IFS: FND_ID_FLEX_SEGMENTS FND_SAV:FND_SEGMENT_ATTRIBUTE_VALUESFND_SFA:FND_SHORTHAND_FLEX

5、_ALIASES FND_IFSTR:FND_ID_FLEX_STRUCTUREFND_FVS:FND_FLEX_VALUE_SETS FND_FVRS:FND_FLEX_VALIDATION_RULE_STATSFND_FERL:FND_FLEX_EXCLUDE_RULE_LINES FND_FVR:FND_FLEX_VALIDATION_RULESFND_FVQ: FND_FLEX_VALIDATION_QUALIFIERS FND_FVRL: FND_FLEX_VALIDATION_RULE_LINES FND_VAT:FND_VALUE_ATTRIBUTE_TYPES FND_FIRL

6、:FND_FLEX_INCLUDE_RULE_LINES FND_CIFS:FND_COMPILED_ID_FLEX_STRUCTS FND_SAT:FND_SEGMENT_ATTRIBUTE_TYPES FND_CIF:FND_COMPILED_ID_FLEXS FND_IF:FND_ID_FLEXSFND_APP:FND_APPLICATION FND_TAB:FND_TABLESWF_RPV:WF_RUNNABLE_PROCESSES_V FND_FWP: FND_FLEX_WORKFLOW_PROCESSES彈性域彈性域彈性域彈性域表名縮寫(xiě)對(duì)照表表名縮寫(xiě)對(duì)照表FND_FVH: FND_

7、FLEX_VALUE_HIERARCHIES FND_FVS: FND_FLEX_VALUE_SETSFND_IFS: FND_ID_FLEX_SEGMENTS FND_FVNH: FND_FLEX_VALUE_NORM_HIERARCHYFND_FH:FND_FLEX_HIERARCHIES FND_FV: FND_FLEX_VALUESFND_FVE: FND_FLEX_VALIDATION_EVENTS FND_FVRL: FND_FLEX_VALUE_RULE_LINESFND_FVR: FND_FLEX_VALUE_RULES FND_FVRU: FND_FLEX_VALUE_RUL

8、E_USAGESFND_RESP:FND_RESPONSIBILITY FND_TAB:FND_TABLESFND_FVT:FND_FLEX_VALIDATION_TABLES并發(fā)管理器并發(fā)管理器FND_CCR:FND_CONCURRENT_COMPLEX_RULES FND_CCL:FND_CONCURRENT_COMPLEX_LINESFND_CPG: FND_CONCURRENT_PROGRAMS FND_CRC: FND_CONCURRENT_REQUEST_CLASSFND_OID:FND_ORACLE_USERID FND_USER:FND_USERFND_CGC: FND_CON

9、CURRENT_QUEUE_CONTENT FND_CR: FND_CONCURRENT_REQUESTSFND_NDS:FND_NODES FND_CPR: FND_CONCURRENT_PROCESSESFND_DG:FND_DATA_GROUPS FND_CQP: FND_CONCURRENT_QUEUE_PARAMSFND_CQ: FND_CONCURRENT_QUEUES FND_CPP:FND_CONC_PROCESSOR_PROGRAMSFND_CPS: FND_CONCURRENT_PROCESSORS FND_CQS: FND_CONCURRENT_QUEUE_SIZEFND

10、_CTP: FND_CONCURRENT_TIME_PERIODS FND_APP:FND_APPLICATION 并發(fā)處理并發(fā)處理表名縮寫(xiě)對(duì)照表表名縮寫(xiě)對(duì)照表FND_CPA:FND_CONC_PP_ACTIONS FND_CRA:FND_CONC_REQUEST_ARGUMENTSFND_RRL:FND_RUN_REQ_LANGUAGES FND_CR: FND_CONCURRENT_REQUESTSFND_CD:FND_CONFLICT_DOMAINS FND_RES:FND_RESPONSIBILYFND_CRC:FND_CONC_RELEASE_CLASSES FND_DGU:FND_

11、DATA_GROUP_UNITSFND_LOG:FND_LOGINS FND_DG:FND_DATA_GROUPSFND_OID:FND_ORACLE_USERID FND_USR:FND_USERFND_CRC: FND_CONCURRENT_REQUEST_CLASS FND_CPS: FND_CONCURRENT_PROGRAM-SERIALFND_CPG: FND_CONCURRENT-PROGRAMS FND_EXE:FND_EXECUTABLES標(biāo)準(zhǔn)請(qǐng)求標(biāo)準(zhǔn)請(qǐng)求表名縮寫(xiě)對(duì)照表表名縮寫(xiě)對(duì)照表FND_RGU:FND_REQUEST_GROUP_UNITS FND_RS:FND_REQU

12、EST_SETSFND_RSS:FND_REQUEST_SET_STAGES FND_RRA:FND_RUN_REQ_PP_ACTIONSFND_RG: FND_REQUEST_GROUPS FND_RSP: FND_REQUEST_SET_PROGRAMSFND_RSA: FND_REQUEST_SET_PROGRAM_ARGS FND_RR:FND_RUN_REQUESTSFND_DF:FND-DESCRIPTIVE_FLEXS FND_CPG:FND_CONCURRENT_PROGRAMSFND_RES:FND_RESPONSIBILITY FND_APP:FND_APPLICATION功能安全功能安全登錄安全登錄安全表名縮寫(xiě)對(duì)照表表名縮寫(xiě)對(duì)照表FND_URG:FND_USER_RESP_GROUPS FND_RES:FND_RESPONSIBILITYFND_SG:FND_SECURITY_GROUPS FND_APP:FND_APPLICATIONFND_DGU:FND_DATA_GROUP_UNITS FND_AS:FND_APPLICATION_SERVERSFND_OID:FND_ORACLE_USERID FND_DG:FND_DATA_G