EBS R12 AP → Fusion Payables​ 的 AP 三层对象映射表细化到字段级。覆盖你前面关心的四个 FBDI worksheetInvoice Header / Invoice Line / Distribution行内分配/ Prepayment每个字段给出「Fusion FBDI 列 ↔ Fusion 物理表列 ↔ EBS 物理表列 ↔ 转换规则」。约定Fusion 物理表与 EBS 同名表AP_INVOICES_ALL等语义相近但FBDI 接口表是AP_INVOICES_INTERFACE/AP_INVOICE_LINES_INTERFACE不是基表直写。FusionDistribution 不单独占一个 worksheet而是由 Line worksheet 的Distribution Combination/ 段值 Prorate 标志在导入时派生到AP_INVOICE_DISTRIBUTIONS_ALL。Prepayment 在 FBDI 里不是独立 worksheet而是 Header 的InvoiceTypePREPAYMENT 普通 Line/DIST导入后再用「Apply Prepayment」动作或 Prepayment Application 接口做应用。供应商主数据先迁HZ_PARTIESPOZ_SUPPLIERSPOZ_SUPPLIER_SITES_ALLFBDI 里用Supplier Number Site Code​ 而非 EBS 的VENDOR_ID。1. Invoice HeaderFBDI: AP_INVOICES_INTERFACEFBDI 列Fusion 基表列EBS 源表.列转换规则InvoiceIdINVOICE_ID临时接口键自建序列 /AP_INVOICES_ALL.INVOICE_ID弃用仅接口内联头行不进基表 PKBusinessUnitBU 解析→ORG_ID等效AP_INVOICES_ALL.ORG_ID→BU 映射EBS OU 需先建 BU 映射表LedgerSET_OF_BOOKS_IDAP_INVOICES_ALL.SET_OF_BOOKS_ID直接迁LEDGER 须与 BU 绑定SourceSOURCEAP_INVOICES_ALL.SOURCE历史迁建议写External或Legacy EBSInvoiceNumberINVOICE_NUMAP_INVOICES_ALL.INVOICE_NUMBULedger 内唯一EBS OU 内唯一需去重InvoiceTypeINVOICE_TYPE_LOOKUP_CODE同列STANDARD/CREDIT/PREPAYMENT/EXPENSE REPORT 枚举直迁InvoiceAmountINVOICE_AMOUNT同列本币/外币按INVOICE_CURRENCY_CODE解释InvoiceDateINVOICE_DATE同列YYYY/MM/DDAccountingDateGL_DATEAP_INVOICES_ALL.GL_DATE必须落在 Fusion 打开期间TermsTERMS_ID→名称解析AP_TERMS_TL.NAME(TERMS_ID)EBS terms_id 需先做 Fusion terms 映射TermsDateTERMS_DATEAP_INVOICES_ALL.TERMS_DATE直迁SupplierVENDOR_ID←POZ_SUPPLIERS.VENDOR_NUMAP_SUPPLIERS.SEGMENT1(NUM)不传 VENDOR_ID传 Supplier NumberFusion 反查SupplierSiteVENDOR_SITE_ID←Site CodeAP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE传 Site Code须在该 BU 启用InvoiceCurrencyINVOICE_CURRENCY_CODE同列PaymentCurrencyPAYMENT_CURRENCY_CODE同列与发票币同种或固定汇率DescriptionDESCRIPTION同列PaymentMethodPAYMENT_METHOD_LOOKUP_CODE同列枚举对齐 Fusion 付款方法PayGroupPAY_GROUP_LOOKUP_CODE同列LiabilityCombinationACCTS_PAY_CODE_COMBINATION_ID同列 CCID优先传段值组合而非旧 CCID或做 CCID 跨环境映射ExchangeRateTypeEXCHANGE_RATE_TYPE同列直迁ExchangeDateEXCHANGE_DATE同列ExchangeRateEXCHANGE_RATE同列PrepaymentNumber仅 PREPAYMENT 应用填AP_PREPAYMENTS_ALL.INVOICE_NUM历史预付款应用才填PrepaymentApplicationAmount应用金额AP_INVOICE_PAYMENTS_ALL.AMOUNT应用步骤用不在头导入阶段AttributeCategory / Attribute1..15ATTRIBUTE_CATEGORY/ATTRIBUTE1..15同列EBS DFF 直迁注意 Fusion 上下文不同LegalEntity解析至 Ledger/BUAP_INVOICES_ALL.LEGAL_ENTITY_ID(R12 有)通过 BU→LE 配置解析不直写2. Invoice LineFBDI: AP_INVOICE_LINES_INTERFACE一行 Line 在导入时可能派生多行 Distribution如 Tax 分摊。FBDI 列Fusion 基表列EBS 源表.列转换规则InvoiceId接口键同 Header 自联与 Header 一致InvoiceLineIdINVOICE_LINE_IDAP_INVOICE_LINES_ALL.INVOICE_LINE_ID(弃用PK)接口临时键LineNumberLINE_NUMBERAP_INVOICE_LINES_ALL.LINE_NUMBER同发票内唯一LineTypeLINE_TYPE_LOOKUP_CODE同列ITEM / TAX / FREIGHT / MISCELLANEOUSAmountAMOUNTAP_INVOICE_LINES_ALL.AMOUNT正负号随发票类型校验DescriptionDESCRIPTION同列PO 匹配时留空可继承 PO 行描述AccountingDateACCOUNTING_DATEAP_INVOICE_LINES_ALL.ACCOUNTING_DATE/GL_DATE取行级→头级→选项级DistributionCombination派生AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_IDAP_INVOICE_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID传段值A.B.C.D或新 CCIDProrateAcrossFlagPRORATE_ACROSS_FLAG无直接列EBS 靠手动建分配Y按 LineGroup 摊到各 Item 行LineGroupNumberLINE_GROUP_NUMBER无直接列同组 ItemTAX/FREIGHT 一起分摊PurchaseOrderNum匹配PO_HEADERS_ALL.SEGMENT1AP_INVOICE_LINES_ALL.PO_HEADER_ID→SEGMENT1传 PO 号Fusion 反查POLineNumberPO_LINE_ID解析AP_INVOICE_LINES_ALL.PO_LINE_ID需 PO 已在 Fusion 存在ReceiptNum匹配RCV_SHIPMENT_HEADERS.RECEIPT_NUMAP_INVOICE_LINES_ALL.RCV_SHIPMENT_LINE_ID收单匹配用QuantityInvoicedQUANTITY_INVOICED同列PO 匹配时 AMOUNTQTY*PRICEUnitPriceUNIT_PRICE同列TaxCodeId / TaxCodeTAX_CODE_IDAP_INVOICE_LINES_ALL.TAX_CODE_IDFusion 走 Tax Engine建议留空让自动定税FinalMatchFlagFINAL_MATCH_FLAG同列PO 最终匹配 Y/N3. DistributionFBDI 无独立 sheet由 Line 派生 → AP_INVOICE_DISTRIBUTIONS_ALL概念字段Fusion 基表列EBS 源表.列转换规则所属发票INVOICE_IDAP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID由 Line 归属所属发票行INVOICE_LINE_ID同列由 Line 归属分配类型LINE_TYPE_LOOKUP_CODE同列ITEM/TAX/FREIGHT/MISC 继承自行金额AMOUNT同列行金额或分摊后金额数量QUANTITY同列PO 匹配行有值科目组合DIST_CODE_COMBINATION_IDCODE_COMBINATION_IDEBS CCID 必须经 COA 迁移映射成 Fusion CCID 或段值​段值1..n解析自 CCIDGL_CODE_COMBINATIONS.SEGMENT1..nFBDI 推荐直接传段值串避 CCID 错乱PO 行引用PO_LINE_ID同列三单匹配保留分配创建原因CREATED_BY/ORG_ID同概念系统填关键坑EBS 老数据若没有AP_INVOICE_LINES_ALL只有头分配FBDI 必须先造虚拟 ITEM 行再把分配挂上去否则导入拒绝。4. PrepaymentFBDI 阶段 普通发票头行类型 PREPAYMENT阶段FBDI 处理Fusion 对象EBS 对应迁入预付款发票Header.InvoiceTypePREPAYMENTLineITEMDistribution资产/预付科目AP_INVOICES_ALL(TYPEPREPAYMENT) 分配AP_INVOICES_ALLAP_PREPAYMENTS_ALL应用预付款另跑「Apply Prepayment」/ Prepayment Application 接口填 PrepaymentNumber PrepaymentApplicationAmount 被冲发票 InvoiceIdAP_INVOICE_PAYMENTS_ALL应用写核销AP_INVOICE_PAYMENTS_ALL同机制转回临时预付款到EARLIEST_SETTLEMENT_DATE未用自动转回同左AP_INVOICES_ALL.EARLIEST_SETTLEMENT_DATEEBS 字段落位AP_PREPAYMENTS_ALL.INVOICE_ID→ Fusion 仍是一张 PREPAYMENT 类型发票AP_INVOICE_PAYMENTS_ALL.AMOUNT→ PrepaymentApplicationAmountEARLIEST_SETTLEMENT_DATE→ 头级字段直迁5. 三层对象收口对照字段级之上的边界层EBSFusion字段映射结论BO发票头分配Payables Invoice BO头行分配计划EBS 缺「行」层FBDI 必须补 LineLE基本物理表头/行/分配/installment 分离Distribution 由 Line 派生不独立传PEAP_INVOICES_ALL等_ALL直写FUSION.AP.*封闭走 INTERFACE→基表FBDI 接口列≠基表列Supplier 用 Number 不用 ID