培训oracle库存数据表结构

库存基础数据表结构文档版本1.0课程内容完成本课后，您应该能够执行以下操作：解释定义库存物料确定定义物料中使用的主要表单解释库存事务处理活动确定库存事务处理中使用的主要表单在SQL

*Plus中针对相应的数据库表运行查询，以查找 特定的库存物料，以及它的状态和周期盘点。库存事务处理开放性接口课程目标理解库存相关表之间的关联关系，各个表的主键以及常 用字段的含义。Oracle库存InventoryOrder

entryInternalshipmentReceiveDeliverInspectTransferShopfloorInventorySupplierShipmentExpense库存数据概览结构图MTL_PARAMETERSLOCATORSUBINVENTORYMTL_MATERIAL_TRANSACTIONSMTL_SYSTEM_ITEMS_BHR_ALL_ORGANIZATION_UNITSMTL_ONHAND_QUANTITIESMTL_TRANSACTION_ACCOUNTSMTL_SYSTEM_ITEMS_TL库存组织组织结构图GL_CODE_COMBINATIONSGL_SETS_OF_BOOKSMTL_INTERORG_PARAMETERSHR_ALL_ORGANIZATION_UNITSHR_ORGANIZATION_INFORMATIONMTL_PARAMETERS库存组织：HR.HR_ALL_ORGANIZATION_UNITS位置：设置->组织->组织库存组织：HR.HR_ALL_ORGANIZATION_UNITS常用视图（库存组织）：ORG_ORGANIZATION_DEFINITIONSORGANIZATION_IDORGANIZATION_CODEORGANIZATION_NAMESET_OF_BOOKS_IDCHART_OF_ACCOUNTS_IDOPERATING_UNIT库存组织ID库存组织编码库存组织名称分类账ID会计科目结构ID业务实体ID库存组织：HR.HR_ALL_ORGANIZATION_UNITS常用视图（业务实体）：HR_ORGANIZATION_UNITSORGANIZATION_IDNAME业务实体ID业务名称库存组织参数：MTL_PARAMETERS位置：设置->组织->参数库存：子库和货位MTL_SECONDARY_LOCATORSMTL_ITEM_LOCATIONSMTL_ITEM_SUB_INVENTORIESMTL_SECONDARY_INVENTORIESGL_CODE_COMBINATIONSMTL_SYSTEM_ITEMS_BMTL_PARAMETERSMTL_SYSTEM_ITEMS_TL子库存表：MTL_SECONDARY_INVENTORIES位置：设置->组织->子库存子库存表：MTL_SECONDARY_INVENTORIESSECONDARY_INVENTORY_NAMEORGANIZATION_ID子库存名称库存组织ID相关连的表（子库存物料信息表）：MTL_ITEM_SUB_INVENTORIESINVENTORY_ITEM_IDSECONDARY_INVENTORY_NAMEORGANIZATION_ID物料ID子库存名称库存组织ID货位表：MTL_ITEM_LOCATIONS位置：设置->组织->库存货位货位表：MTL_ITEM_LOCATIONSINVENTORY_LOCATION_IDORGANIZATION_IDSUBINVENTORY_CODE货位ID库存组织ID子库编码相关连的表（子库存物料信息表）：MTL_SECONDARY_LOCATORSINVENTORY_ITEM_IDSECONDARY_INVENTORY_NAMEORGANIZATION_ID物料ID子库存名称库存组织ID子库存表：MTL_SECONDARY_INVENTORIESSECONDARY_INVENTORY_NAMEORGANIZATION_ID子库存名称库存组织ID相关连的表（子库存物料信息表）：MTL_ITEM_SUB_INVENTORIESINVENTORY_ITEM_IDSECONDARY_INVENTORY_NAMEORGANIZATION_ID物料ID子库存名称库存组织ID库存：主物料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项目类型物料模版：MTL_ITEM_TEMPLATES物料现有量：MTL_ONHAND_QUANTITIES库存：物料控制MTL_LOT_NUMBERSMTL_SERIAL_NUMBERSMTL_ITEM_REVISIONSMTL_SYSTEM_ITEMS_B序列号库存：物料状态MTL_ITEM_ATTRIBUTESMTL_STATUS_ATTRIBUTE_VALUESMTL_ITEM_STATUSMTL_SYSTEM_ITEMS_BMTL_PENDING_ITEM_STATUS库存：物料状态库存：物料状态库存：物料类别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库存：物料类别库存：物料类别库存：物料类别库存：目录MTL_DESCRIPTIVE_ELEMENTSMTL_DESCR_ELEMENT_VALUESMTL_ITEM_CATALOG_GROUPSMTL_SYSTEM_ITEMS_B库存：目录库存：目录Oracle库存事务处理流程RCV_TRANSACTIONS_INTERFACEMTL_TRANSACTIONS_INTERFACEMTL_MATERIAL_TRANSACTIONS_TEMPMTL_MATERIAL_TRANSACTIONSMTL_TRANSACTION_ACCOUNTSOrder

entryInventory,WIPReceivingOracle库存事务处理流程RCV_TRANSACTIONS_INTERFACEMTL_TRANSACTIONS_INTERFACEMTL_MATERIAL_TRANSACTIONS_TEMPMTL_MATERIAL_TRANSACTIONSMTL_TRANSACTION_ACCOUNTSOrder

entryInventory,WIPReceiving库存：物料事务处理和物料控制MTL_UNIT_TRANSACTIONSMTL_MATERIAL_TRANSACTIONSMTL_SYSTEM_ITEMS_BMTL_TRANSACTION_LOT_NUMBERSMTL_ITEM_REVISIONSMTL_SERIAL_NUMBERSMTL_LOT_NUMBERS物料事务处理库存：实际盘存MTL_MATERIAL_TRANSACTIONSMTL_PHYSICAL_ADJUSTMENTSMTL_SECONDARY_INVENTORIESMTL_PHYSICAL_SUBINVENTORIESMTL_PHYSICAL_INVENTORIESMTL_SYSTEM_ITEMS_BMTL_PHYSICAL_INVENTORY_TAGS库存：ABC分析MTL_ABC_ASSIGNMENTSMTL_ABC_COMPILE_HEADERSMTL_SYSTEM_ITEMS_BMTL_SECONDARY

INVENTORIESMTL_ABC_COMPILESMTL_ABC_CLASSESMTL_ABC_ASSGN_GROUP_CLASSESMTL_ABC_ASSIGNMENT_GROUPSOracle库存：周期盘点MTL_CC_SCHED_COUNTXREFSMTL_CYCLE_COUNT_ENTRIESMTL_MATERIAL_TRANSACTIONSMTL_CC_SCHEDULE_REQUESTSMTL_SYSTEM_ITEMS_BMTL_CYCLE_COUNT_ITEMSMTL_CYCLE_COUNT_CLASSESMTL_CYCLE_COUNT_HEADERS库存：需求和预订信息MTL_DEMANDMTL_MATERIAL_TRANSACTIONSGL_CODE_COMBINATIONSMTL_GENERIC_DISPOSITIONSMTL_SYSTEM_ITEMS_BOE_ORDER_HEADERS_ALLOE_ORDER_LINES_ALLMTL_SALES_ORDERSMTL_DEMAND_INTERFACE库存事务处理开放式接口表InterfaceNameTransactionsDataFlowDirectionInboundTable,View,

orProcessTableTable,

View,

or

Module

nameMTL_TRANSACTIONS_INTERFACEMTL_SERIAL_NUMBERS_INTERFACEMTL_TRANSACION_LOTS_INTERFACEDemandInterfaceInboundTableMTL_DEMAND_INTERFACEReplenishmentInboundTableMTL_REPLENISH_HEADERS_INTMTL_REPLENISH_LINES_INT物料事务处理接口供应与需求接口库存设置开放式接口表InterfaceNameData

FlowDirectionTable,

View,or

ProcessTable,

View,

or

Module

Nam