OracleERP表结构
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
LOOKUP_TYPE LOOKUP_CODE MEANING VARCHAR2(30) NUMBER VARCHAR2(80)
表名: inv.mtl_item_revisions 说明: 项目版本表
ORGANIZATION_ID INENTORY_ITEM_ID REVISION LAST_UPDATE_DATE EFFECTIVITY_DATE NUMBER NUMBER VARCHAR2(3) DATE DATE
说明: 项目目录表
ITEM_CATALOG_GROUP_ID SEGMENT1 SEGMENT2 DESCRIPTION NUMBER VARCHAR2(40) VARCHAR2(40) VARCHAR2(240)
表名：inv.mtl_item_attributes 说明：项目属性字段说明
ATTRIBUTE_NAME DATA_TYPE USER_ATTRIBUTE_NAME USER_ATTRIBUTE_NAME_GUI CONTROL_LEVEL SEQUENCE LEVEL_UPDATEABLE_FLAG VALIDATION_CODE MANDATORY_FLAG
UOM_CLASS DISABLE_DATE DESCRIPTION VARCHAR2(10) DATE VARCHAR2(50)
表名: inv.mtl_uom_class_conversions 说明: 单位类别换算
INVENTORY_ITEM_ID FROM_UNIT_OF_MEASURE FROM_UOM_CODE FROM_UOM_CLASS TO_UNIT_OF_MEASURE TO_UOM_CODE TO_UOM_CLASS CONVERSION_RATE DISABLE_DATE NUMBER VARCHAR2(25) VARCHAR2(3) VARCHAR2(10) VARCHAR2(25) VARCHAR2(3) VARCHAR2(10) NUMBER DATE
表名Baidu Nhomakorabea inv.mtl_descriptive_elements 说明: 项目描述构成元素表
ITEM_CATALOG_GROUP_ID ELEMENT_SEQUENCE ELEMENT_NAME DESCRIPTION NUMBER NUMBER VARCHAR2(30) VARCHAR2(50)
表名: inv.mtl_item_catalog_groups
表名: inv.mtl_picking_rules 说明: 捡料规则表
PICKING_RULE_ID PICKING_RULE_NAME DESCRIPTION NUMBER VARCHAR2(30) VARCHAR2(50)
表名：inv.mfg_lookups 说明：系统检查类型及值列表(从中可查许多TYPE字段的值)
表名: inv.mtl_descr_element_values 说明: 项目描述构成元素值
INVENTORY_ITEM_ID ELEMENT_NAME ELEMENT_SEQUENCE ELEMENT_VALUE DEFAULT_ELEMENT_FLAG NUMBER VARCHAR2(30) NUMBER VARCHAR2(30) VARCHAR2(1)
UNIT_OF_MEASURE UOM_CODE UOM_CLASS BASE_UOM_FLAG DISABLE_DATE DESCRIPTION VARCHAR2(25) VARCHAR2(3) VARCHAR2(10) VARCHAR2(1) DATE VARCHAR2(50)
表名：inv.mtl_uom_classes 说明：度量单位类表
INV模块常用表结构
表名：inv.mtl_system_items 说明： 物料主表
列名 ORGANIZATION_ID INVENTORY_ITEM_ID SEGMENT1 UNIT_OF_ISSUE DESCRIPTION ALLOWED_UNITS_LOOKUP_CODE INVENTORY_ITEM_STATUS_CODE ITEM_TYPE PRIMARY_UNIT_OF_MEASURE BASE_ITEM_ID BOM_ENABLED_FLAG BOM_ITEM_TYPE ENGINEERING_ECN_CODE ENGINEERING_ITEM_ID ENG_ITEM_FLAG COSTING_ENABLED_FLAG COST_OF_SALES_ACCOUNT DEFAULT_INCLUDE_IN_ROLLUP_FLAG INVENTORY_ASSET_FLAG STD_LOT_SIZE ALLOW_ITEM_DESC_UPDATE_FLAG ASSET_CATEGORY_ID BUYER_ID ENCUMBRANCE_ACCOUNT EXPENSE_ACCOUNT HAZARD_CLASS_ID LIST_PRICE_PER_UNIT MARKET_PRICE OUTSIDE_OPERATION_FLAG OUTSIDE_OPERATION_UOM_TYPE PRICE_TOLERANCE_PERCENT PURCHASING_ENABLED_FLAG PURCHASING_ITEM_FLAG ROUNDING_FACTOR TAXABLE_FLAG UNIT_OF_ISSUE ALLOW_EXPRESS_DELIVERY_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG DAYS_EARLY_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED ENFORCE_SHIP_TO_LOCATION_CODE INVOICE_CLOSE_TOLERANCE QTY_RCV_EXCEPTION_CODE QTY_RCV_TOLERANCE RECEIPT_REQUIRED_FLAG 类型 NUMBER NUMBER VARCHAR2(40)
A
SHRINKAGE_RATE CUMULATIVE_TOTAL_LEAD_TIME CUM_MANUFACTURING_LEAD_TIME FULL_LEAD_TIME LEAD_TIME_LOT_SIZE PREPROCESSING_LEAD_TIME VARIABLE_LEAD_TIME BUILD_IN_WIP_FLAG WIP_SUPPLY_LOCATOR_ID WIP_SUPPLY_TYPE ATP_COMPONENTS_FLAG ATP_FLAG ATP_RULE_ID COLLATERAL_FLAG CUSTOMER_ORDER_FLAG DEFAULT_SHIPPING_ORG INTERNAL_ORDER_ENABLED_FLAG INTERNAL_ORDER_FLAG PICKING_RULE_ID PICK_COMPONENTS_FLAG REPLENISH_TO_ORDER_FLAG RETURNABLE_FLAG RETURN_INSPECTION_REQUIREMENT SHIPPABLE_ITEM_FLAG SHIP_MODEL_COMPLETE_FLAG SO_TRANSACTIONS_FLAG ACCOUNTING_RULE_ID INVOICEABLE_ITEM_FLAG INVOICE_ENABLED_FLAG INVOICING_RULE_ID PAYMENT_TERMS_ID SALES_ACCOUNT TAX_CODE ATO_FORECAST_CONTROL MUST_USE_APPROVED_VENDOR_FLAG UN_NUMBER_ID ALLOW_UNORDERED_RECEIPTS_FLAG INSPECTION_REQUIRED_FLAG RECEIPT_DAYS_EXCEPTION_CODE RESTRICT_SUBINVENTORIES_CODE ACCEPTABLE_RATE_DECREASE END_ASSEMBLY_PEGGING_FLAG PLANNING_EXCEPTION_SET ROUNDING_CONTROL_TYPE FIXED_LEAD_TIME POSTPROCESSING_LEAD_TIME WIP_SUPPLY_SUBINVENTORY CUSTOMER_ORDER_ENABLED_FLAG ACCEPTABLE_RATE_INCREASE
表名：inv.mtl_planners 说明：计划员代码表
列名 PLANNER_CODE ORGANIZATION_ID DESCRIPTION DISABLE_DATE 类型 VARCHAR2(10) NUMBER VARCHAR2(50) DATE
表名: inv.mtl_units_of_measure 说明：度量单位表
表名：inv.mtl_onhand_quantities 说明：库存数据表
列名 类型
INVENTORY_ITEM_ID ORGANIZATION_ID DATE_RECEIVED TRANSACTION_QUANTITY SUBINVENTORY_CODE REVISION LOCATOR_ID CREATE_TRANSACTION_ID UPDATE_TRANSACTION_ID
A
A
A
RECEIVE_CLOSE_TOLERANCE RECEIVING_ROUTING_ID AUTO_SERIAL_ALPHA_PREFIX CYCLE_COUNT_ENABLED_FLAG INVENTORY_ITEM_FLAG LOCATION_CONTROL_CODE LOT_CONTROL_CODE MTL_TRANSACTIONS_ENABLED_FLAG POSITIVE_MEASUREMENT_ERROR RESERVABLE_TYPE RESTRICT_LOCATORS_CODE REVISION_QTY_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE SHELF_LIFE_CODE SHELF_LIFE_DAYS START_AUTO_LOT_NUMBER START_AUTO_SERIAL_NUMBER STOCK_ENABLED_FLAG UNIT_VOLUME UNIT_WEIGHT VOLUME_UOM_CODE WEIGHT_UOM_CODE CARRYING_COST FIXED_DAYS_SUPPLY FIXED_LOT_MULTIPLIER FIXED_ORDER_QUANTITY INVENTORY_PLANNING_CODE MAXIMUM_ORDER_QUANTITY MAX_MINMAX_QUANTITY MINIMUM_ORDER_QUANTITY MIN_MINMAX_QUANTITY MRP_SAFETY_STOCK_CODE MRP_SAFETY_STOCK_PERCENT ORDER_COST PLANNER_CODE SAFETY_STOCK_BUCKET_DAYS SOURCE_ORGANIZATION_ID SOURCE_SUBINVENTORY SOURCE_TYPE ACCEPTABLE_EARLY_DAYS AUTO_REDUCE_MPS DEMAND_TIME_FENCE_CODE DEMAND_TIME_FENCE_DAYS MRP_CALCULATE_ATP_FLAG MRP_PLANNING_CODE OVERRUN_PERCENTAGE PLANNING_MAKE_BUY_CODE PLANNING_TIME_FENCE_CODE PLANNING_TIME_FENCE_DAYS REPETITIVE_PLANNING_FLAG
表名: inv.mtl_manufacturers 说明: 制造商代码表
MANUFACTURER_ID MANUFACTURER_NAME NUMBER VARCHAR2(30)
表名：inv.mtl_item_status 说明：项目状态表
INVENTORY_ITEM_STATUS_CODE DESCRIPTION VARCHAR2(10) VARCHAR2(240)
表名: inv.mtl_item_revisions 说明: 项目版本表
ORGANIZATION_ID INENTORY_ITEM_ID REVISION LAST_UPDATE_DATE EFFECTIVITY_DATE NUMBER NUMBER VARCHAR2(3) DATE DATE
说明: 项目目录表
ITEM_CATALOG_GROUP_ID SEGMENT1 SEGMENT2 DESCRIPTION NUMBER VARCHAR2(40) VARCHAR2(40) VARCHAR2(240)
表名：inv.mtl_item_attributes 说明：项目属性字段说明
ATTRIBUTE_NAME DATA_TYPE USER_ATTRIBUTE_NAME USER_ATTRIBUTE_NAME_GUI CONTROL_LEVEL SEQUENCE LEVEL_UPDATEABLE_FLAG VALIDATION_CODE MANDATORY_FLAG
UOM_CLASS DISABLE_DATE DESCRIPTION VARCHAR2(10) DATE VARCHAR2(50)
表名: inv.mtl_uom_class_conversions 说明: 单位类别换算
INVENTORY_ITEM_ID FROM_UNIT_OF_MEASURE FROM_UOM_CODE FROM_UOM_CLASS TO_UNIT_OF_MEASURE TO_UOM_CODE TO_UOM_CLASS CONVERSION_RATE DISABLE_DATE NUMBER VARCHAR2(25) VARCHAR2(3) VARCHAR2(10) VARCHAR2(25) VARCHAR2(3) VARCHAR2(10) NUMBER DATE
表名Baidu Nhomakorabea inv.mtl_descriptive_elements 说明: 项目描述构成元素表
ITEM_CATALOG_GROUP_ID ELEMENT_SEQUENCE ELEMENT_NAME DESCRIPTION NUMBER NUMBER VARCHAR2(30) VARCHAR2(50)
表名: inv.mtl_item_catalog_groups
表名: inv.mtl_picking_rules 说明: 捡料规则表
PICKING_RULE_ID PICKING_RULE_NAME DESCRIPTION NUMBER VARCHAR2(30) VARCHAR2(50)
表名：inv.mfg_lookups 说明：系统检查类型及值列表(从中可查许多TYPE字段的值)
表名: inv.mtl_descr_element_values 说明: 项目描述构成元素值
INVENTORY_ITEM_ID ELEMENT_NAME ELEMENT_SEQUENCE ELEMENT_VALUE DEFAULT_ELEMENT_FLAG NUMBER VARCHAR2(30) NUMBER VARCHAR2(30) VARCHAR2(1)
UNIT_OF_MEASURE UOM_CODE UOM_CLASS BASE_UOM_FLAG DISABLE_DATE DESCRIPTION VARCHAR2(25) VARCHAR2(3) VARCHAR2(10) VARCHAR2(1) DATE VARCHAR2(50)
表名：inv.mtl_uom_classes 说明：度量单位类表
INV模块常用表结构
表名：inv.mtl_system_items 说明： 物料主表
列名 ORGANIZATION_ID INVENTORY_ITEM_ID SEGMENT1 UNIT_OF_ISSUE DESCRIPTION ALLOWED_UNITS_LOOKUP_CODE INVENTORY_ITEM_STATUS_CODE ITEM_TYPE PRIMARY_UNIT_OF_MEASURE BASE_ITEM_ID BOM_ENABLED_FLAG BOM_ITEM_TYPE ENGINEERING_ECN_CODE ENGINEERING_ITEM_ID ENG_ITEM_FLAG COSTING_ENABLED_FLAG COST_OF_SALES_ACCOUNT DEFAULT_INCLUDE_IN_ROLLUP_FLAG INVENTORY_ASSET_FLAG STD_LOT_SIZE ALLOW_ITEM_DESC_UPDATE_FLAG ASSET_CATEGORY_ID BUYER_ID ENCUMBRANCE_ACCOUNT EXPENSE_ACCOUNT HAZARD_CLASS_ID LIST_PRICE_PER_UNIT MARKET_PRICE OUTSIDE_OPERATION_FLAG OUTSIDE_OPERATION_UOM_TYPE PRICE_TOLERANCE_PERCENT PURCHASING_ENABLED_FLAG PURCHASING_ITEM_FLAG ROUNDING_FACTOR TAXABLE_FLAG UNIT_OF_ISSUE ALLOW_EXPRESS_DELIVERY_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG DAYS_EARLY_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED ENFORCE_SHIP_TO_LOCATION_CODE INVOICE_CLOSE_TOLERANCE QTY_RCV_EXCEPTION_CODE QTY_RCV_TOLERANCE RECEIPT_REQUIRED_FLAG 类型 NUMBER NUMBER VARCHAR2(40)
A
SHRINKAGE_RATE CUMULATIVE_TOTAL_LEAD_TIME CUM_MANUFACTURING_LEAD_TIME FULL_LEAD_TIME LEAD_TIME_LOT_SIZE PREPROCESSING_LEAD_TIME VARIABLE_LEAD_TIME BUILD_IN_WIP_FLAG WIP_SUPPLY_LOCATOR_ID WIP_SUPPLY_TYPE ATP_COMPONENTS_FLAG ATP_FLAG ATP_RULE_ID COLLATERAL_FLAG CUSTOMER_ORDER_FLAG DEFAULT_SHIPPING_ORG INTERNAL_ORDER_ENABLED_FLAG INTERNAL_ORDER_FLAG PICKING_RULE_ID PICK_COMPONENTS_FLAG REPLENISH_TO_ORDER_FLAG RETURNABLE_FLAG RETURN_INSPECTION_REQUIREMENT SHIPPABLE_ITEM_FLAG SHIP_MODEL_COMPLETE_FLAG SO_TRANSACTIONS_FLAG ACCOUNTING_RULE_ID INVOICEABLE_ITEM_FLAG INVOICE_ENABLED_FLAG INVOICING_RULE_ID PAYMENT_TERMS_ID SALES_ACCOUNT TAX_CODE ATO_FORECAST_CONTROL MUST_USE_APPROVED_VENDOR_FLAG UN_NUMBER_ID ALLOW_UNORDERED_RECEIPTS_FLAG INSPECTION_REQUIRED_FLAG RECEIPT_DAYS_EXCEPTION_CODE RESTRICT_SUBINVENTORIES_CODE ACCEPTABLE_RATE_DECREASE END_ASSEMBLY_PEGGING_FLAG PLANNING_EXCEPTION_SET ROUNDING_CONTROL_TYPE FIXED_LEAD_TIME POSTPROCESSING_LEAD_TIME WIP_SUPPLY_SUBINVENTORY CUSTOMER_ORDER_ENABLED_FLAG ACCEPTABLE_RATE_INCREASE
表名：inv.mtl_planners 说明：计划员代码表
列名 PLANNER_CODE ORGANIZATION_ID DESCRIPTION DISABLE_DATE 类型 VARCHAR2(10) NUMBER VARCHAR2(50) DATE
表名: inv.mtl_units_of_measure 说明：度量单位表
表名：inv.mtl_onhand_quantities 说明：库存数据表
列名 类型
INVENTORY_ITEM_ID ORGANIZATION_ID DATE_RECEIVED TRANSACTION_QUANTITY SUBINVENTORY_CODE REVISION LOCATOR_ID CREATE_TRANSACTION_ID UPDATE_TRANSACTION_ID
A
A
A
RECEIVE_CLOSE_TOLERANCE RECEIVING_ROUTING_ID AUTO_SERIAL_ALPHA_PREFIX CYCLE_COUNT_ENABLED_FLAG INVENTORY_ITEM_FLAG LOCATION_CONTROL_CODE LOT_CONTROL_CODE MTL_TRANSACTIONS_ENABLED_FLAG POSITIVE_MEASUREMENT_ERROR RESERVABLE_TYPE RESTRICT_LOCATORS_CODE REVISION_QTY_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE SHELF_LIFE_CODE SHELF_LIFE_DAYS START_AUTO_LOT_NUMBER START_AUTO_SERIAL_NUMBER STOCK_ENABLED_FLAG UNIT_VOLUME UNIT_WEIGHT VOLUME_UOM_CODE WEIGHT_UOM_CODE CARRYING_COST FIXED_DAYS_SUPPLY FIXED_LOT_MULTIPLIER FIXED_ORDER_QUANTITY INVENTORY_PLANNING_CODE MAXIMUM_ORDER_QUANTITY MAX_MINMAX_QUANTITY MINIMUM_ORDER_QUANTITY MIN_MINMAX_QUANTITY MRP_SAFETY_STOCK_CODE MRP_SAFETY_STOCK_PERCENT ORDER_COST PLANNER_CODE SAFETY_STOCK_BUCKET_DAYS SOURCE_ORGANIZATION_ID SOURCE_SUBINVENTORY SOURCE_TYPE ACCEPTABLE_EARLY_DAYS AUTO_REDUCE_MPS DEMAND_TIME_FENCE_CODE DEMAND_TIME_FENCE_DAYS MRP_CALCULATE_ATP_FLAG MRP_PLANNING_CODE OVERRUN_PERCENTAGE PLANNING_MAKE_BUY_CODE PLANNING_TIME_FENCE_CODE PLANNING_TIME_FENCE_DAYS REPETITIVE_PLANNING_FLAG
表名: inv.mtl_manufacturers 说明: 制造商代码表
MANUFACTURER_ID MANUFACTURER_NAME NUMBER VARCHAR2(30)
表名：inv.mtl_item_status 说明：项目状态表
INVENTORY_ITEM_STATUS_CODE DESCRIPTION VARCHAR2(10) VARCHAR2(240)