下面给出EBS R12.2ONT SchemaOE_ORDER_HEADERS_ALL与OE_ORDER_LINES_ALL的完整 ETRM 级字段定义按“字段名 / 数据类型长度 / 是否必填 / ETRM 原始描述英文 中文解释 / 头行映射角色”五段呈现。以 Oracle 官方 ETRM 12.2.2Ontology Owner ONT物理表定义为准未标注长度的 NUMBER/DATE 表示精度由应用控制。第一部分OE_ORDER_HEADERS_ALL头表Owner ONTTablespace APPS_TS_TX_DATAPrimary Key HEADER_ID1.1 主键与业务键字段类型空ETRM 描述原文→ 解释角色HEADER_IDNUMBERN“Order Header Identifier” → 订单头唯一标识头 PKORDER_NUMBERNUMBERN“User visible number of the order” → 用户可见的单号业务键非 PKORG_IDNUMBERN*“Operating Unit which performed this transaction” → 所属业务实体 OUMOAC 隔离键VERSION_NUMBERNUMBERN“Not Used” → 内部版本号未启用保留列*ETRM 列清单标 NMOAC 下实际由默认化框架写入。1.2 订单来源与溯源字段类型空ETRM 描述 → 解释角色ORDER_SOURCE_IDNUMBERY“Source of the order” → 订单来源手工/OI/CRM/EDI→ OE_ORDER_SOURCESSOURCE_DOCUMENT_TYPE_IDNUMBERY“Indicates the source of the order” → 来源单据类型复制单溯源SOURCE_DOCUMENT_IDNUMBERY“Source Order Header Identifier” → 来源订单头 ID复制单溯源ORIG_SYS_DOCUMENT_REFVARCHAR2(50)Y“Original document reference for the order in external system” → 外部系统单据引用Order ImportORDER_TYPE_IDNUMBERN“Order Transaction Type Identifier” → 订单事务类型→ OE_TRANSACTION_TYPES_ALL1.3 日期、币种与汇率字段类型空ETRM 描述 → 解释角色ORDERED_DATEDATEY“Ordered Date” → 下单日期定价日期默认REQUEST_DATEDATEY“Request date for the order” → 客户要求日期头默认→行PRICING_DATEDATEY“Determines effective list and price modifiers” → 定价生效日空则取 ORDERED_DATEEXPIRATION_DATEDATEY“Not Used” → 报价有效期预留保留列TRANSACTIONAL_CURR_CODEVARCHAR2(15)Y“Currency for the order” → 交易币种行经转换继承CONVERSION_RATENUMBERY“Rate of the currency conversion” → 汇率CONVERSION_TYPE_CODEVARCHAR2(30)Y“Currency Conversion type” → 汇率类型CONVERSION_RATE_DATEDATEY“Date of the currency conversion” → 汇率日期1.4 定价、财务与条款字段类型空ETRM 描述 → 解释角色PRICE_LIST_IDNUMBERY“Price list Identification for the order” → 价目表→ QP_LIST_HEADERS_BDEMAND_CLASS_CODEVARCHAR2(30)Y“Demand Class” → 需求分类计划用行继承SHIPMENT_PRIORITY_CODEVARCHAR2(30)Y“Shipment Priority Code” → 发运优先级行继承TAX_EXEMPT_FLAGVARCHAR2(1)Y“S/E/R tax handling” → 免税处理标志TAX_EXEMPT_NUMBERVARCHAR2(80)Y“The Tax exemption Number” → 免税编号TAX_EXEMPT_REASON_CODEVARCHAR2(30)Y“The reason code for Tax exemption” → 免税原因INVOICING_RULE_IDNUMBER(15)Y“Invoicing rule used by AR for generating Invoice” → AR 开票规则→ RA_RULESACCOUNTING_RULE_IDNUMBER(15)Y“Accounting rule used by AR for generating Invoice” → AR 收入确认规则→ RA_RULESPAYMENT_TERM_IDNUMBER(15)Y“Payment Terms” → 付款条款→ RA_TERMS_BAGREEMENT_IDNUMBERY“Internal use only” → 客户框架协议→ OE_AGREEMENTS_B1.5 贸易与承运条款字段类型空ETRM 描述 → 解释角色SHIPPING_METHOD_CODEVARCHAR2(30)Y“Shipping method to be used to ship the order” → 发运方式行可覆盖FREIGHT_CARRIER_CODEVARCHAR2(30)Y“Freight Carrier Code” → 承运商FOB_POINT_CODEVARCHAR2(30)Y“FOB Point Code” → FOB 贸易条款FREIGHT_TERMS_CODEVARCHAR2(30)Y“Freight Terms Code” → 运费条款TAX_POINT_CODEVARCHAR2(30)Y“For future use” → 税务时点预留保留列PARTIAL_SHIPMENTS_ALLOWEDVARCHAR2(1)Y“Not Used” → 是否允许分批预留保留列SHIP_TOLERANCE_ABOVENUMBERY“Over Shipment/Return Tolerance” → 超收容差%行继承SHIP_TOLERANCE_BELOWNUMBERY“Under Shipment/Return Tolerance” → 欠收容差%行继承1.6 客户地点与联系人HZ 外键字段类型空ETRM 描述 → 解释角色SOLD_FROM_ORG_IDNUMBERY“Selling Organization” → 销售组织SOLD_TO_ORG_IDNUMBERY“Sold to customer” → 下单客户→ HZ_CUST_ACCOUNTSSHIP_FROM_ORG_IDNUMBERY“Ship From Organization Id - Warehouse” → 头级默认发货组织建行时推 OOLSHIP_TO_ORG_IDNUMBERY“Ship to Organization Id” → 收货地点→ HZ_CUST_SITE_USES_ALLINVOICE_TO_ORG_IDNUMBERY“Invoice To Organization ID” → 开票地点→ HZ_CUST_SITE_USES_ALLDELIVER_TO_ORG_IDNUMBERY“Deliver to Organization Id” → 最终交付地点→ HZ_CUST_SITE_USES_ALLSOLD_TO_CONTACT_IDNUMBERY“Customer contact” → 下单联系人SHIP_TO_CONTACT_IDNUMBERY“Ship to Contact Id” → 收货联系人INVOICE_TO_CONTACT_IDNUMBERY“Invoice To Contact ID” → 开票联系人DELIVER_TO_CONTACT_IDNUMBERY“Deliver to Contact Id” → 交付联系人1.7 状态与登记字段类型空ETRM 描述 → 解释角色BOOKED_FLAGVARCHAR2(1)Y列清单含未单独注解→ 是否已登记Y/NBOOKED_DATEDATEY未注解→ 登记日期OPEN_FLAGVARCHAR2(1)Y→ 订单是否未结独立维护CANCELLED_FLAGVARCHAR2(1)Y→ 订单是否取消独立维护FLOW_STATUS_CODEVARCHAR2(30)Y→ 头 Workflow 状态子行聚合摘要ENTERED/BOOKED/CLOSEDORDER_CATEGORY_CODEVARCHAR2(30)Y→ 头定性ORDER/RETURN/MIXEDRETURN_REASON_CODEVARCHAR2(30)Y→ 退货原因头级SALESREP_IDNUMBERY→ 销售员→ JTF_RS_SALESREPS1.8 并发控制与指示字段类型空ETRM 描述 → 解释角色CUST_PO_NUMBERVARCHAR2(50)Y“Customer Purchase Order Number” → 客户 PO 号头唯一CHANGE_SEQUENCEVARCHAR2(50)Y→ Process Order 并发版本控制LOCK_CONTROLNUMBERY→ 行锁控制SHIPPING_INSTRUCTIONSVARCHAR2(2000)Y→ 发运指示行可覆盖PACKING_INSTRUCTIONSVARCHAR2(2000)Y→ 包装指示行可覆盖1.9 弹性域DFF字段类型空ETRM 描述 → 解释角色CONTEXTVARCHAR2(30)Y→ 说明性弹性域上下文ATTRIBUTE_CATEGORY头 DFFATTRIBUTE1~ATTRIBUTE30VARCHAR2(240)Y“Descriptive Flexfield” → 说明性弹性域GLOBAL_ATTRIBUTE_CATEGORYVARCHAR2(30)Y→ 全局 DFF 上下文GLOBAL_ATTRIBUTE1~20VARCHAR2(240)Y→ 全局弹性域TP_CONTEXTVARCHAR2(30)Y→ 贸易伙伴上下文TP_ATTRIBUTE1~15VARCHAR2(240)Y→ 贸易伙伴弹性域1.10 WHO 与并发 WHO 列字段类型空ETRM 描述 → 解释CREATION_DATEDATENStandard Who columnCREATED_BYNUMBERNStandard Who columnLAST_UPDATED_BYNUMBERNStandard Who columnLAST_UPDATE_DATEDATENStandard Who columnLAST_UPDATE_LOGINNUMBERYStandard Who columnPROGRAM_APPLICATION_IDNUMBERYApplication of concurrent program that last updated rowPROGRAM_IDNUMBERYConcurrent program that last updated rowPROGRAM_UPDATE_DATEDATEY(同上)REQUEST_IDNUMBERYConcurrent request id第二部分OE_ORDER_LINES_ALL行表Owner ONTPrimary Key LINE_IDForeign Key HEADER_ID → OE_ORDER_HEADERS_ALL.HEADER_ID2.1 主键、头外键与行编号字段类型空ETRM 描述 → 解释角色LINE_IDNUMBERN“Order Line Identifier” → 订单行唯一标识行 PKHEADER_IDNUMBERN“Sales Order Header Identifier” → 所属订单头→ OOH.HEADER_IDORG_IDNUMBERN*“Operating Unit” → 业务实体MOAC 以行准LINE_NUMBERNUMBERY“Sales Order Line Number” → 行号展示用SHIPMENT_NUMBERNUMBERY→ 发运序号1.1 / 1.2LINE_TYPE_IDNUMBERN“Identifier of the Transaction Line Type” → 行事务类型→ OE_LINE_TYPES_B2.2 物料与类型字段类型空ETRM 描述 → 解释角色ORDERED_ITEMVARCHAR2(2000)Y→ 录入的物品编码字符INVENTORY_ITEM_IDNUMBERY**​“Identifying ID of the Inventory Item” → 物料 ID→ MTL_SYSTEM_ITEMS_BITEM_REVISIONVARCHAR2(3)Y“Item revision” → 物料版本ITEM_TYPE_CODEVARCHAR2(30)Y“ITEM/OPTION/CLASS/MODEL” → 物料类型**ETRM JTM 视图标 MandatoryY物理 OOL 服务行可 NULL以基表为准。2.3 数量字段累计值Workflow 回写字段类型空ETRM 描述 → 解释角色ORDER_QUANTITY_UOMVARCHAR2(3)Y“Order quantity UOM” → 订购单位ORDERED_QUANTITYNUMBERY“Number of Ordered Items for the Line” → 订购数原始需求CANCELLED_QUANTITYNUMBERY“Cancelled Quantity” → 取消数SHIPPED_QUANTITYNUMBERY“Quantity shipped” → 已发运数Ship Confirm 回写INVOICED_QUANTITYNUMBERY“Invoiced quantity” → 已开票数AutoInvoice 回写FULFILLED_QUANTITYNUMBERY“Fulfilled quantity” → 已履约数SHIPPING_QUANTITYNUMBERY“Shipping transaction quantity” → 发运事务数SHIPPING_QUANTITY_UOMVARCHAR2(3)Y“Shipping UOM” → 发运单位PRICING_QUANTITYNUMBERY“Pricing quantity” → 定价数量PRICING_QUANTITY_UOMVARCHAR2(3)Y“Pricing UOM” → 定价单位2.4 价格与税额字段类型空ETRM 描述 → 解释角色UNIT_LIST_PRICENUMBERY“List price” → 目录价UNIT_SELLING_PRICENUMBERY“Actual price charged” → 实际成交单价QP 落行TAX_CODEVARCHAR2Y“Tax code” → 税码TAX_RATENUMBERY“Tax rate” → 税率TAX_VALUENUMBERY“Tax value” → 税额TAX_DATEDATEY“Tax date” → 税务日期TAX_EXEMPT_FLAGVARCHAR2(1)Y“S/E/R” → 行级免税标志TAX_EXEMPT_NUMBERVARCHAR2(80)Y→ 行级免税号TAX_EXEMPT_REASON_CODEVARCHAR2(30)Y→ 行级免税原因2.5 客户地点与联系人行可覆盖头字段类型空ETRM 描述 → 解释角色SOLD_TO_ORG_IDNUMBERY“Sold-to account” → 下单账户行继承头SOLD_FROM_ORG_IDNUMBERY“Selling org” → 销售组织SHIP_FROM_ORG_IDNUMBERY“Ship-from inventory org” → 发货库存组织覆盖头→WSHSHIP_TO_ORG_IDNUMBERY“Ship-to site use” → 收货地点覆盖头INVOICE_TO_ORG_IDNUMBERY“Invoice-to site use” → 开票地点覆盖头DELIVER_TO_ORG_IDNUMBERY“Deliver-to site use” → 交付地点覆盖头INTMED_SHIP_TO_ORG_IDNUMBERY“Intermediate ship-to” → 中转收货地INTMED_SHIP_TO_CONTACT_IDNUMBERY→ 中转收货联系人SHIP_TO_CONTACT_IDNUMBERY→ 收货联系人INVOICE_TO_CONTACT_IDNUMBERY→ 开票联系人DELIVER_TO_CONTACT_IDNUMBERY→ 交付联系人2.6 定价上下文、条款与公差字段类型空ETRM 描述 → 解释角色PRICE_LIST_IDNUMBERY“Price list for line” → 行价目表QP 按行算价PRICING_DATEDATEY“Pricing date” → 行定价日PAYMENT_TERM_IDNUMBER(15)Y“Payment terms” → 行付款条款INVOICING_RULE_IDNUMBER(15)Y“Invoicing rule” → 行开票规则ACCOUNTING_RULE_IDNUMBER(15)Y“Accounting rule” → 行收入规则SHIPMENT_PRIORITY_CODEVARCHAR2(30)Y“Shipment priority” → 发运优先级覆盖头DEMAND_CLASS_CODEVARCHAR2(30)Y“Demand class” → 需求分类覆盖头SHIP_TOLERANCE_ABOVENUMBERY“Over ship tolerance” → 超容SHIP_TOLERANCE_BELOWNUMBERY“Under ship tolerance” → 欠容2.7 日期与调度字段类型空ETRM 描述 → 解释角色REQUEST_DATEDATEY“Request Shipping/Arrival date” → 客户要求日覆盖头PROMISE_DATEDATEY“Promised date” → 承诺日期SCHEDULE_SHIP_DATEDATEY“Scheduled ship date” → 计划发运日ATP/调度回写SCHEDULE_ARRIVAL_DATEDATEY“Scheduled arrival date” → 计划到达日DELIVERY_LEAD_TIMENUMBERY→ 在途天数2.8 状态、接口与履约标志字段类型空ETRM 描述 → 解释角色BOOKED_FLAGVARCHAR2(1)Y→ 行登记标志随头置 YOPEN_FLAGVARCHAR2(1)Y→ 行未结标志独立CANCELLED_FLAGVARCHAR2(1)Y→ 行取消标志独立FLOW_STATUS_CODEVARCHAR2(30)Y→ 行 Workflow 状态真身AWAITING_SHIPPING/SHIPPED/CLOSEDSCHEDULE_STATUS_CODEVARCHAR2(30)Y“Schedule status” → 调度状态INVOICE_INTERFACE_STATUS_CODEVARCHAR2(30)Y“AR interface status” → 开票接口状态→ RA_INTERFACE_LINES_ALLLINE_CATEGORY_CODEVARCHAR2(30)Y“ORDER/RETURN” → 行定性RETURN_REASON_CODEVARCHAR2(30)Y→ 行退货原因DROP_SHIP_FLAGVARCHAR2(1)Y“Drop ship flag” → 是否直运ATP_FLAGVARCHAR2(1)Y“ATP flag” → ATP 检查标记SOURCE_TYPE_CODEVARCHAR2(30)Y“INTERNAL/EXTERNAL” → 履约来源VISIBLE_DEMAND_FLAGVARCHAR2(1)Y→ 是否挂 MRP 可见需求2.9 配置层级与拆分自引用 → LINE_ID字段类型空ETRM 描述 → 解释角色TOP_MODEL_LINE_IDNUMBERY“Top PTO model line” → 顶层 PTO 模型行自引用LINK_TO_LINE_IDNUMBERY“Direct parent line” → 直接父行自引用ATO_LINE_IDNUMBERY“ATO config line” → ATO 配置顶层行自引用SPLIT_FROM_LINE_IDNUMBERY“Split source line” → 拆分来源行分批溯源SHIP_SET_IDNUMBERY“Ship set” → 发货集多行捆绑LINE_SET_IDNUMBERY“Line set” → 行集2.10 来源与退货溯源字段类型空ETRM 描述 → 解释角色ORDER_SOURCE_IDNUMBERY“Order source” → 行来源SOURCE_DOCUMENT_TYPE_IDNUMBERY“Source document type” → 复制来源类型SOURCE_DOCUMENT_IDNUMBERY“Source header id” → 复制来源头SOURCE_DOCUMENT_LINE_IDNUMBERY“Source line id” → 复制来源行ORIG_SYS_DOCUMENT_REFVARCHAR2(50)Y“Orig sys doc ref” → 外部头引用ORIG_SYS_LINE_REFVARCHAR2(50)Y“Orig sys line ref” → 外部行引用Order ImportREFERENCE_HEADER_IDNUMBERY“Reference header (RMA→SO)” → 原销售单头RMA 溯源REFERENCE_LINE_IDNUMBERY“Reference line (RMA→SO line)” → 原销售单行RMA 溯源REFERENCE_TYPEVARCHAR2(30)Y“Reference type” → 引用类型REFERENCE_CUSTOMER_TRX_LINE_IDNUMBERY“AR invoice line referenced” → 原 AR 发票行→ RA_CUSTOMER_TRX_LINES_ALL2.11 弹性域含定价 DFF字段类型空ETRM 描述 → 解释CONTEXTVARCHAR2(30)Y行 DFF 上下文ATTRIBUTE1~30VARCHAR2(240)Y说明性弹性域GLOBAL_ATTRIBUTE_CATEGORYVARCHAR2(30)Y全局 DFF 上下文GLOBAL_ATTRIBUTE1~20VARCHAR2(240)Y全局弹性域PRICING_CONTEXTVARCHAR2(30)Y定价 DFF 上下文PRICING_ATTRIBUTE1~nVARCHAR2(240)Y定价弹性域2.12 WHO 与并发列同头表结构CREATION_DATE / LAST_UPDATE_DATE (DATE, N)CREATED_BY / LAST_UPDATED_BY (NUMBER, N)LAST_UPDATE_LOGIN (NUMBER, Y)PROGRAM_APPLICATION_ID / PROGRAM_ID (NUMBER, Y)PROGRAM_UPDATE_DATE (DATE, Y)REQUEST_ID (NUMBER, Y)LOCK_CONTROL (NUMBER, Y)第三部分ETRM 级映射要点一句话版主从骨架OOH.HEADER_ID (PK) ↔ OOL.HEADER_ID (FK)报表永远用 HEADER_ID JOIN禁止用 ORDER_NUMBER 当主键。LINE_ID 是跨 WSH/AR/INV 的关联核心键非 LINE_NUMBER。同名同类型继承字段建行复制、行可 overrideORG_ID、PRICE_LIST_ID、TRANSACTIONAL_CURR_CODE(→行经转换)、CONVERSION、SOLD_TO_ORG_ID、SHIP_TO_ORG_ID、INVOICE_TO_ORG_ID、DELIVER_TO_ORG_ID、PAYMENT_TERM_ID、INVOICING_RULE_ID、ACCOUNTING_RULE_ID、ORDERED_DATE、REQUEST_DATE、BOOKED_FLAG、OPEN_FLAG、CANCELLED_FLAG、FLOW_STATUS_CODE、DEMAND_CLASS_CODE、SHIPMENT_PRIORITY_CODE、TOLERANCE_*。改名不改性ORDER_TYPE_ID (头) ↔ LINE_TYPE_ID (行)CURRENCY 概念头 TRANSACTIONAL_CURR_CODE → 行由头币种CONVERSION 上下文决定物理 OOL 无 CURRENCY_CODE 列仅 APPS 视图层投影。头有行无ORDER_NUMBER、ORDER_SOURCE_ID、ORIG_SYS_DOCUMENT_REF、CUST_PO_NUMBER、BOOKED_DATE、ORDER_CATEGORY_CODE、SHIPPING_INSTRUCTIONS、PACKING_INSTRUCTIONS、CHANGE_SEQUENCE、AGREEMENT_ID、WHO 列全部。行有头无LINE_ID、LINE_TYPE_ID、LINE_NUMBER、SHIPMENT_NUMBER、INVENTORY_ITEM_ID、ORDERED_ITEM、全部_QUANTITY、UNIT_SELLING_PRICE、SCHEDULE_SHIP_DATE、PROMISE_DATE、TOP_MODEL_LINE_ID、LINK_TO_LINE_ID、ATO_LINE_ID、SPLIT_FROM_LINE_ID、SHIP_SET_ID、REFERENCE_LINE_ID、REFERENCE_CUSTOMER_TRX_LINE_ID、INVOICE_INTERFACE_STATUS_CODE、ATP_FLAG、SOURCE_TYPE_CODE、VISIBLE_DEMAND_FLAG、PRICING_ATTRIBUTE。两个不在物理表的派生项EXTENDED_SELLING_PRICE UNIT_SELLING_PRICE × ORDERED_QUANTITY不是物理列CURRENCY_CODE 在 OOL 物理表不存在。状态机语义OOH.FLOW_STATUS_CODE 子行状态聚合摘要不驱动 WorkflowOOL.FLOW_STATUS_CODE Workflow真身禁止 UPDATE。数量字段语义ORDERED/SHIPPED/INVOICED/CANCELLED/FULFILLED_QUANTITY 全是Workflow 回写的累计值非派生视图。待发 ORDERED − SHIPPED − CANCELLED。弹性域规则ATTRIBUTE_CATEGORYCONTEXT控制 ATTRIBUTE1~30 上下文头 DFF 与行 DFF上下文独立TP_ATTRIBUTE* 用于贸易伙伴/EDI。取数必须按 CATEGORY decode。外键指向速查OOH → OE_TRANSACTION_TYPES_ALL(ORDER_TYPE_ID)、OE_ORDER_SOURCES(ORDER_SOURCE_ID)、QP_LIST_HEADERS_B(PRICE_LIST_ID)、HZ_CUST_ACCOUNTS(SOLD_TO_ORG_ID)、HZ_CUST_SITE_USES_ALL(SHIP/INVOICE/DELIVER_TO_ORG_ID)、RA_TERMS_B(PAYMENT_TERM_ID)、RA_RULES(INVOICING/ACCOUNTING_RULE_ID)OOL → OOH.HEADER_ID、OE_LINE_TYPES_B(LINE_TYPE_ID)、MTL_SYSTEM_ITEMS_B(INVENTORY_ITEM_ID)、MTL_PARAMETERS(SHIP_FROM_ORG_ID)、自引用(TOP_MODEL/LINK_TO/ATO/SPLIT_FROM_LINE_ID)、RA_CUSTOMER_TRX_LINES_ALL(REFERENCE_CUSTOMER_TRX_LINE_ID)下行业务外键无物理 FKWSH_DELIVERY_DETAILS(SOURCE_HEADER_ID/SRC_LINE_ID)、OE_PRICE_ADJUSTMENTS_ALL(HEADER_ID/LINE_ID)、OE_ORDER_HOLDS_ALL(HEADER_ID/LINE_ID)最小可用查询骨架SELECT ooh.header_id, ooh.order_number, ooh.org_id, ooh.order_type_id, ooh.flow_status_code hdr_stat, ool.line_id, ool.line_number, ool.inventory_item_id, ool.ordered_quantity, ool.shipped_quantity, ool.invoiced_quantity, ool.unit_selling_price, ool.flow_status_code line_stat, ool.ship_from_org_id FROM oe_order_headers_all ooh JOIN oe_order_lines_all ool ON ool.header_id ooh.header_id WHERE ooh.org_id :ou_id AND ooh.flow_status_code CANCELLED;所有 ID 类为 NUMBERJOIN 不加引号ATTRIBUTE1~30 为 VARCHAR2(240)日期/数字弹性域需显式转换生产环境严禁 UPDATE FLOW_STATUS_CODE / *_QUANTITY 字段。