【目录】
【目录】........................................................................................................................................................1
【目的】本文主要整理了 Oracle EBS（11.5.0.10） 中常用的表结构以供开发维护查询....................4
一. OE 模块...................................................................................................................................................4
(1) 表名:ONT.OE_order_headers_all 说明:订单头.......................................................................................................4
(2) 表名:ONT.OE_order_lines_all 说明:订单行............................................................................................................5
(3) 表名:oe_transaction_types_tl 说明:订单类别多语言表..........................................................................................6
(4) 表名:oe_transaction_types_all 说明:订单类别表....................................................................................................7
(5) Fold:XXEUL_OM_RELATED_INFO 说明:完整的订单数据...............................................................................7
(6) Fold:XXEUL_OE_DILIVERY_RECORDS 说明:完整的订单发运记录..............................................................9
(7) Fold:XXEUL_PRICING_LIST 说明:完整的订单发运记录................................................................................10
(8) Fold:Ra Customers V 说明:完整的客户头记录....................................................................................................10
(9) Fold:Ra Addresses 说明:完整的客户地址信息.....................................................................................................10
(10) Fold:Ra Site Use 说明:完整的客户地址对应的目的..........................................................................................11
(11) Fold:MTL_TXN_REQUEST_LINES_V 说明:完整的搬运单行信息................................................................11
(12) Fold:MTL_TXN_REQUEST_HEADERS_V 说明:完整的搬运单头信息........................................................12
(13) Fold:Fnd_Lookup_Values_Vl 说明:OM 的 Quick Code ：SALES_CHANNEL...............................................12
(14) Fold:XXEUL_OM_ORDER_TYPE 说明:OM 的订单类型...............................................................................13
(15) Fold:Wsh Regions Tl 说明:销售区域...................................................................................................................13
二. PO 模块..................................................................................................................................................13
(1) 表名: po.po_requisition_headers_all; 说明: 采购请求..........................................................................................13
(2) 表名: po.po_requisition_lines_all; 说明: 采购请求明细 ......................................................................................13
(3) 表名: po.po_lookup_codes 说明: 检查代码...........................................................................................................15
(4) 表名: po.po_lookup_types; 说明: 检查类型..........................................................................................................15
(5) 表名: po.po_headers_all; 说明: 采购订单头..........................................................................................................15
(6) 表名: po.po_lines_all; 说明: 采购订单行..............................................................................................................17
(7) 表名: po.po_line_locations_all; 说明: 采购定位表 ..............................................................................................18
(8) 表名: po.po_un_numbers; 说明: 货期表................................................................................................................19
(9) 表名: po.rcv_transactions; 说明：到货接收..........................................................................................................19
(10) 表名: po.po_vendors 说明:供应商表...................................................................................................................21
三. INV 模块................................................................................................................................................23
(2) 表名: inv.mtl_planners; 说明：计划员代码表......................................................................................................26
(3) 表名: inv.mtl_units_of_measure; 说明：度量单位表...........................................................................................26
(4) 表名: inv.mtl_uom_classes; 说明：度量单位类表................................................................................................26
(5) 表名: inv.mtl_uom_class_conversions; 说明: 单位类别换算................................................................................27
(6) 表名: inv.mtl_descr_element_values; 说明: 项目描述构成元素值......................................................................27
(7) 表名: inv.mtl_descriptive_elements; 说明: 项目描述构成元素表........................................................................27
(8) 表名: inv.mtl_item_catalog_groups; 说明: 项目目录表 .......................................................................................27
(9) 表名: inv.mtl_item_attributes; 说明：项目属性字段说明 .................................................................................27
(10) 表名: inv.mtl_manufacturers; 说明: 制造商代码表 ..........................................................................................28
(12) 表名: inv.mtl_picking_rules 说明: 捡料规则表 ..................................................................................................28
(13) 表名: inv.mfg_lookups;;说明：系统检查类型及值列表(可查许多 TYPE 字段的值).....................................28
(14) 表名: inv.mtl_item_revisions;; 说明: 项目版本表...............................................................................................28
(15) 表名: inv.mtl_onhand_quantities;; 说明：库存数据表 .....................................................................................28
(16) 表名: inv.mtl_item_locations;; 说明: 项目货位表...............................................................................................29
(17) 表名: inv.mtl_material_transactions;; 说明：交易登记(出入库记录)表............................................................29
剩余49页未读，继续阅读
评论17