培訓(xùn)oracle庫(kù)存數(shù)據(jù)表結(jié)構(gòu)

庫(kù)存基礎(chǔ)數(shù)據(jù)表結(jié)構(gòu)文檔版本1.0課程內(nèi)容完成本課后，您應(yīng)該能夠執(zhí)行以下操作：解釋定義庫(kù)存物料確定定義物料中使用的主要表單解釋庫(kù)存事務(wù)處理活動(dòng)確定庫(kù)存事務(wù)處理中使用的主要表單在SQL

*Plus中針對(duì)相應(yīng)的數(shù)據(jù)庫(kù)表運(yùn)行查詢，以查找 特定的庫(kù)存物料，以及它的狀態(tài)和周期盤點(diǎn)。庫(kù)存事務(wù)處理開放性接口課程目標(biāo)理解庫(kù)存相關(guān)表之間的關(guān)聯(lián)關(guān)系，各個(gè)表的主鍵以及常 用字段的含義。Oracle庫(kù)存InventoryOrder

entryInternalshipmentReceiveDeliverInspectTransferShopfloorInventorySupplierShipmentExpense庫(kù)存數(shù)據(jù)概覽結(jié)構(gòu)圖MTL_PARAMETERSLOCATORSUBINVENTORYMTL_MATERIAL_TRANSACTIONSMTL_SYSTEM_ITEMS_BHR_ALL_ORGANIZATION_UNITSMTL_ONHAND_QUANTITIESMTL_TRANSACTION_ACCOUNTSMTL_SYSTEM_ITEMS_TL庫(kù)存組織組織結(jié)構(gòu)圖GL_CODE_COMBINATIONSGL_SETS_OF_BOOKSMTL_INTERORG_PARAMETERSHR_ALL_ORGANIZATION_UNITSHR_ORGANIZATION_INFORMATIONMTL_PARAMETERS庫(kù)存組織：HR.HR_ALL_ORGANIZATION_UNITS位置：設(shè)置->組織->組織庫(kù)存組織：HR.HR_ALL_ORGANIZATION_UNITS常用視圖（庫(kù)存組織）：ORG_ORGANIZATION_DEFINITIONSORGANIZATION_IDORGANIZATION_CODEORGANIZATION_NAMESET_OF_BOOKS_IDCHART_OF_ACCOUNTS_IDOPERATING_UNIT庫(kù)存組織ID庫(kù)存組織編碼庫(kù)存組織名稱分類賬ID會(huì)計(jì)科目結(jié)構(gòu)ID業(yè)務(wù)實(shí)體ID庫(kù)存組織：HR.HR_ALL_ORGANIZATION_UNITS常用視圖（業(yè)務(wù)實(shí)體）：HR_ORGANIZATION_UNITSORGANIZATION_IDNAME業(yè)務(wù)實(shí)體ID業(yè)務(wù)名稱庫(kù)存組織參數(shù)：MTL_PARAMETERS位置：設(shè)置->組織->參數(shù)庫(kù)存：子庫(kù)和貨位MTL_SECONDARY_LOCATORSMTL_ITEM_LOCATIONSMTL_ITEM_SUB_INVENTORIESMTL_SECONDARY_INVENTORIESGL_CODE_COMBINATIONSMTL_SYSTEM_ITEMS_BMTL_PARAMETERSMTL_SYSTEM_ITEMS_TL子庫(kù)存表：MTL_SECONDARY_INVENTORIES位置：設(shè)置->組織->子庫(kù)存子庫(kù)存表：MTL_SECONDARY_INVENTORIESSECONDARY_INVENTORY_NAMEORGANIZATION_ID子庫(kù)存名稱庫(kù)存組織ID相關(guān)連的表（子庫(kù)存物料信息表）：MTL_ITEM_SUB_INVENTORIESINVENTORY_ITEM_IDSECONDARY_INVENTORY_NAMEORGANIZATION_ID物料ID子庫(kù)存名稱庫(kù)存組織ID貨位表：MTL_ITEM_LOCATIONS位置：設(shè)置->組織->庫(kù)存貨位貨位表：MTL_ITEM_LOCATIONSINVENTORY_LOCATION_IDORGANIZATION_IDSUBINVENTORY_CODE貨位ID庫(kù)存組織ID子庫(kù)編碼相關(guān)連的表（子庫(kù)存物料信息表）：MTL_SECONDARY_LOCATORSINVENTORY_ITEM_IDSECONDARY_INVENTORY_NAMEORGANIZATION_ID物料ID子庫(kù)存名稱庫(kù)存組織ID子庫(kù)存表：MTL_SECONDARY_INVENTORIESSECONDARY_INVENTORY_NAMEORGANIZATION_ID子庫(kù)存名稱庫(kù)存組織ID相關(guān)連的表（子庫(kù)存物料信息表）：MTL_ITEM_SUB_INVENTORIESINVENTORY_ITEM_IDSECONDARY_INVENTORY_NAMEORGANIZATION_ID物料ID子庫(kù)存名稱庫(kù)存組織ID庫(kù)存：主物料MTL_ITEM_ATTRIBUTESMTL_SYSTEM_ITEMS_BMTL_ITEM_STATUSMTL_ITEM_TEMPL_ATTRIBUTESMTL_ITEM_TEMPLATESMTL_STATUS_ATTRIBUTE_VALUESMTL_PARAMETERS物料表：INV.MTL_SYSTEM_ITEMS_B位置：物料->主組織物料物料表：INV.MTL_SYSTEM_ITEMS_BORGANIZATION_ID

NUMBER組織代碼INVENTORY_ITEM_ID

NUMBER物料IDSEGMENT1

VARCHAR2(40)物料編碼PRIMARY_UNIT_OF_MEASURE基本度量單位

ITEM_TYPE項(xiàng)目類型物料模版：MTL_ITEM_TEMPLATES物料現(xiàn)有量：MTL_ONHAND_QUANTITIES庫(kù)存：物料控制MTL_LOT_NUMBERSMTL_SERIAL_NUMBERSMTL_ITEM_REVISIONSMTL_SYSTEM_ITEMS_B序列號(hào)庫(kù)存：物料狀態(tài)MTL_ITEM_ATTRIBUTESMTL_STATUS_ATTRIBUTE_VALUESMTL_ITEM_STATUSMTL_SYSTEM_ITEMS_BMTL_PENDING_ITEM_STATUS庫(kù)存：物料狀態(tài)庫(kù)存：物料狀態(tài)庫(kù)存：物料類別MTL_ITEM_CATEGORIESMTL_SYSTEM_ITEMS_BMTL_CATEGORIES_BMTL_CATEGORY_SET_VALID_CATSFND_ID_FLEX_STRUCTURESMTL_CATEGORY_SETS_BMTL_DEFAULT_CATEGORY_SETSMTL_CATEGORIES_TLMTL_CATEGORY_SETS_TL庫(kù)存：物料類別庫(kù)存：物料類別庫(kù)存：物料類別庫(kù)存：目錄MTL_DESCRIPTIVE_ELEMENTSMTL_DESCR_ELEMENT_VALUESMTL_ITEM_CATALOG_GROUPSMTL_SYSTEM_ITEMS_B庫(kù)存：目錄庫(kù)存：目錄Oracle庫(kù)存事務(wù)處理流程RCV_TRANSACTIONS_INTERFACEMTL_TRANSACTIONS_INTERFACEMTL_MATERIAL_TRANSACTIONS_TEMPMTL_MATERIAL_TRANSACTIONSMTL_TRANSACTION_ACCOUNTSOrder

entryInventory,WIPReceivingOracle庫(kù)存事務(wù)處理流程RCV_TRANSACTIONS_INTERFACEMTL_TRANSACTIONS_INTERFACEMTL_MATERIAL_TRANSACTIONS_TEMPMTL_MATERIAL_TRANSACTIONSMTL_TRANSACTION_ACCOUNTSOrder

entryInventory,WIPReceiving庫(kù)存：物料事務(wù)處理和物料控制MTL_UNIT_TRANSACTIONSMTL_MATERIAL_TRANSACTIONSMTL_SYSTEM_ITEMS_BMTL_TRANSACTION_LOT_NUMBERSMTL_ITEM_REVISIONSMTL_SERIAL_NUMBERSMTL_LOT_NUMBERS物料事務(wù)處理庫(kù)存：實(shí)際盤存MTL_MATERIAL_TRANSACTIONSMTL_PHYSICAL_ADJUSTMENTSMTL_SECONDARY_INVENTORIESMTL_PHYSICAL_SUBINVENTORIESMTL_PHYSICAL_INVENTORIESMTL_SYSTEM_ITEMS_BMTL_PHYSICAL_INVENTORY_TAGS庫(kù)存：ABC分析MTL_ABC_ASSIGNMENTSMTL_ABC_COMPILE_HEADERSMTL_SYSTEM_ITEMS_BMTL_SECONDARY

INVENTORIESMTL_ABC_COMPILESMTL_ABC_CLASSESMTL_ABC_ASSGN_GROUP_CLASSESMTL_ABC_ASSIGNMENT_GROUPSOracle庫(kù)存：周期盤點(diǎn)MTL_CC_SCHED_COUNTXREFSMTL_CYCLE_COUNT_ENTRIESMTL_MATERIAL_TRANSACTIONSMTL_CC_SCHEDULE_REQUESTSMTL_SYSTEM_ITEMS_BMTL_CYCLE_COUNT_ITEMSMTL_CYCLE_COUNT_CLASSESMTL_CYCLE_COUNT_HEADERS庫(kù)存：需求和預(yù)訂信息MTL_DEMANDMTL_MATERIAL_TRANSACTIONSGL_CODE_COMBINATIONSMTL_GENERIC_DISPOSITIONSMTL_SYSTEM_ITEMS_BOE_ORDER_HEADERS_ALLOE_ORDER_LINES_ALLMTL_SALES_ORDERSMTL_DEMAND_INTERFACE庫(kù)存事務(wù)處理開放式接口表InterfaceNameTransactionsDataFlowDirectionInboundTable,View,

orProcessTableTable,

View,

or

Module

nameMTL_TRANSACTIONS_INTERFACEMTL_SERIAL_NUMBERS_INTERFACEMTL_TRANSACION_LOTS_INTERFACEDemandInterfaceInboundTableMTL_DEMAND_INTERFACEReplenishmentInboundTableMTL_REPLENISH_HEADERS_INTMTL_REPLENISH_LINES_INT物料事務(wù)處理接口供應(yīng)與需求接口庫(kù)存設(shè)置開放式接口表InterfaceNameData

FlowDirectionTable,

View,or

ProcessTable,

View,

or

Module

Nam