PO模块各Open InterfacePDOI/Req Import/Receiving ROI的接口表→基表层级映射及关键字段对应关系下面按Purchasing三大接口分类整理。一、PO采购订单导入PDOI — Purchase Document Open Interface并发程序Import Standard Purchase Orders​ /Import Price Catalogs接口表写入基表层级说明PO_HEADERS_INTERFACEPO_HEADERS_ALLPO头标准PO/BPA/CPA/报价/RFQPO_LINES_INTERFACEPO_LINES_ALLPO行物料/服务/说明行PO_LINES_INTERFACESHIPMENT_TYPESHIPMENT或PO_LINE_LOCATIONS_INTERFACEPO_LINE_LOCATIONS_ALL发运行(Shipment) / BPA价格中断(Price Break)PO_DISTRIBUTIONS_INTERFACEPO_DISTRIBUTIONS_ALL会计分配CCID、项目/任务拆分—PO_INTERFACE_ERRORS错误记录表interface_typePO_DOCS_OPEN_INTERFACEPO_HEADERS_INTERFACE → PO_HEADERS_ALL 关键字段映射接口表字段基表字段备注INTERFACE_HEADER_ID—派生PO_HEADER_ID关联键不直接写入DOCUMENT_TYPE_CODETYPE_LOOKUP_CODESTANDARD/BLANKET/CONTRACT/PLANNED/QUOTATION/RFQSEGMENT1SEGMENT1PO编号留NULL则由系统按序生成VENDOR_IDVENDOR_ID供应商VENDOR_SITE_IDVENDOR_SITE_ID供应商地点ORG_IDORG_IDOperating UnitCURRENCY_CODECURRENCY_CODE币种RATE / RATE_DATE / RATE_TYPERATE / RATE_DATE / RATE_TYPE汇率AGENT_ID / AGENT_NAMEAGENT_ID采购员HR_EMPLOYEESSHIP_TO_LOCATION_IDSHIP_TO_LOCATION_ID收货地址BILL_TO_LOCATION_IDBILL_TO_LOCATION_ID开票地址TERMS_ID / PAYMENT_TERMSTERMS_ID付款条件START_DATE / END_DATESTART_DATE / END_DATE协议有效期BPA用NOTE_TO_VENDORNOTE_TO_VENDOR供应商备注ATTRIBUTE1~15ATTRIBUTE1~15DFFPO_LINES_INTERFACE → PO_LINES_ALL 关键字段映射接口表字段基表字段备注INTERFACE_HEADER_ID—关联PO_HEADER_IDINTERFACE_LINE_ID—派生PO_LINE_IDLINE_NUMLINE_NUM行号ITEM_IDITEM_ID物料NULL说明行ITEM_DESCRIPTIONITEM_DESCRIPTION说明行描述CATEGORY_IDCATEGORY_ID采购分类UNIT_MEAS_LOOKUP_CODE / UOM_CODEUNIT_MEAS_LOOKUP_CODE单位QUANTITY—转入PO_LINE_LOCATIONS_ALL.QUANTITYUNIT_PRICE—转入PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDENEED_BY_DATE—转入 ShipmentPROMISED_DATE—转入 ShipmentLINE_TYPE_ID / LINE_TYPELINE_TYPE_IDGoods/Services/Amount⚠️ PDOI中PO_LINES_INTERFACE.QUANTITY/UNIT_PRICE实际写入的是PO_LINE_LOCATIONS_ALLShipment层PO_LINES_ALL本身不存数量单价。PO_LINE_LOCATIONS_INTERFACE或 LINES_INTERFACE Shipment行→ PO_LINE_LOCATIONS_ALL接口表字段基表字段备注SHIPMENT_NUMSHIPMENT_NUM发运序号SHIP_TO_ORGANIZATION_IDSHIP_TO_ORGANIZATION_ID库存组织QUANTITYQUANTITY订购数量PRICE_OVERRIDEPRICE_OVERRIDE单价可覆盖行单价NEED_BY_DATENEED_BY_DATEPROMISED_DATEPROMISED_DATEMATCH_OPTIONMATCH_OPTIONRECEIPT(三单) / PO(两单)SHIPMENT_TYPE—SHIPMENT 或 PRICE BREAK(BPA)PO_DISTRIBUTIONS_INTERFACE → PO_DISTRIBUTIONS_ALL接口表字段基表字段备注QUANTITY_ORDEREDQUANTITY_ORDERED分配数量CODE_COMBINATION_IDCODE_COMBINATION_IDGL费用科目CCIDSET_OF_BOOKS_IDSET_OF_BOOKS_ID账簿PROJECT_ID / TASK_ID / EXPENDITURE_TYPE同名字段项目核算DELIVER_TO_LOCATION_IDDELIVER_TO_LOCATION_ID送达地点DELIVER_TO_PERSON_IDDELIVER_TO_PERSON_ID请求人REQ_DISTRIBUTION_IDREQ_DISTRIBUTION_ID关联PR分配AutoCreate时系统填二、请购单导入Requisition Open Interface并发程序Requisition Import接口表写入基表PO_REQUISITIONS_INTERFACE_ALLPO_REQUISITION_HEADERS_ALLPO_REQUISITION_LINES_ALLPO_REQ_DIST_INTERFACE_ALLPO_REQ_DISTRIBUTIONS_ALLPO_REQUISITIONS_INTERFACE_ALL → 基表关键映射接口字段基表字段说明REQUISITION_HEADER_IDPO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_IDSEGMENT1 / REQ_NUMBER_SEGMENT1PO_REQUISITION_HEADERS_ALL.SEGMENT1PR编号NULL则自动生成TYPEPURCHASEPO_REQUISITION_HEADERS_ALL.TYPEAUTHORIZATION_STATUSPO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUSINCOMPLETE/APPROVEDPREPARER_IDPO_REQUISITION_HEADERS_ALL.PREPARER_ID申请人(EMPLOYEE_ID)DESTINATION_TYPE_CODEPO_REQUISITION_LINES_ALL.DESTINATION_TYPE_CODEINVENTORY/EXPENSEDESTINATION_ORGANIZATION_IDPO_REQUISITION_LINES_ALL.DESTINATION_ORGANIZATION_IDITEM_ID / ITEM_SEGMENT1PO_REQUISITION_LINES_ALL.ITEM_IDQUANTITYPO_REQUISITION_LINES_ALL.QUANTITYUNIT_PRICEPO_REQUISITION_LINES_ALL.UNIT_PRICECHARGE_ACCOUNT_ID / CHARGE_ACCT_FLEXPO_REQ_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID费用科目PROJECT_ID / TASK_IDPO_REQ_DISTRIBUTIONS_ALL.PROJECT_ID / TASK_ID项目核算三、采购接收导入Receiving Open Interface — ROI并发程序Receiving Transaction Processor接口表写入基表RCV_HEADERS_INTERFACERCV_SHIPMENT_HEADERSRCV_TRANSACTIONS_INTERFACERCV_SHIPMENT_LINESRCV_TRANSACTIONS可选MTL_TRANSACTION_LOTS_INTERFACEMTL_LOT_NUMBERS/MTL_SERIAL_NUMBERSRCV_TRANSACTIONS_INTERFACE → 基表关键映射接口字段基表字段说明PO_HEADER_IDRCV_SHIPMENT_HEADERS.PO_HEADER_IDPO_LINE_IDRCV_SHIPMENT_LINES.PO_LINE_IDPO_LINE_LOCATION_IDRCV_TRANSACTIONS.PO_LINE_LOCATION_ID关联ShipmentPO_DISTRIBUTION_IDRCV_TRANSACTIONS.PO_DISTRIBUTION_ID关联分配TRANSACTION_TYPERCV_TRANSACTIONS.TRANSACTION_TYPERECEIVE/DELIVER/RETURN/ACCEPT/REJECTQUANTITYRCV_TRANSACTIONS.QUANTITY接收数量SHIP_TO_ORGANIZATION_IDRCV_TRANSACTIONS.SHIP_TO_ORGANIZATION_ID库存组织SUBINVENTORYRCV_TRANSACTIONS.SUBINVENTORY子库RECEIPT_SOURCE_CODERCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODEVENDORVENDOR_ID / VENDOR_SITE_IDRCV_SHIPMENT_HEADERS.VENDOR_ID四、整体映射速览┌─────────────────────────────┐ ┌──────────────────────────────────────┐ │ PO_HEADERS_INTERFACE │──────▶│ PO_HEADERS_ALL │ │ PO_LINES_INTERFACE │──────▶│ PO_LINES_ALL │ │ PO_LINE_LOCATIONS_INTERFACE│──────▶│ PO_LINE_LOCATIONS_ALL (Shipment/PB) │ │ PO_DISTRIBUTIONS_INTERFACE │──────▶│ PO_DISTRIBUTIONS_ALL (GL CCID) │ │ PO_INTERFACE_ERRORS │◀──────│ 错误记录 │ ├─────────────────────────────┤ │ PO_REQUISITIONS_INTERFACE_ │──────▶│ PO_REQUISITION_HEADERS_ALL │ │ ALL │ │ PO_REQUISITION_LINES_ALL │ │ PO_REQ_DIST_INTERFACE_ALL │──────▶│ PO_REQ_DISTRIBUTIONS_ALL │ ├─────────────────────────────┤ │ RCV_HEADERS_INTERFACE │──────▶│ RCV_SHIPMENT_HEADERS │ │ RCV_TRANSACTIONS_INTERFACE │──────▶│ RCV_SHIPMENT_LINES RCV_TRANSACTIONS │ └─────────────────────────────┘ └──────────────────────────────────────┘