EBS R12 AP → Fusion Payables​ 的三层对象映射表按你前几轮聚焦的Invoice Header / Invoice Line / Distribution由 Line 派生/ Prepayment​ 四个边界细化到字段级 数据类型。类型以 Oracle 官方字典为准EBS 取自 ETRMAP_INVOICES_ALL等Fusion 取自 Help CenterFUSION.AP_*FBDI 接口表类型与 CSV 约定单列说明。三层口径重申BO业务单据Payables Invoice BOLEFusion 头/行/分配/installment 分离EBS LE≈PEPEEBSAP_*_ALL直写Fusion 走AP_INVOICES_INTERFACE/AP_INVOICE_LINES_INTERFACE→ 基表FUSION.AP.*封闭FBDI 类型CSV 文本但接口表列有逻辑类型日期YYYY/MM/DD金额小数点.段值串VARCHAR2。1. Invoice HeaderBO 字段FBDI 列 (AP_INVOICES_INTERFACE)FBDI 逻辑类型Fusion PE 列 (AP_INVOICES_ALL)Fusion PE 类型EBS 源表.列 (AP_INVOICES_ALL)EBS 源类型转换规则发票内部键INVOICE_IDNUMBER(18) 接口联键INVOICE_IDNUMBER(18)INVOICE_IDNUMBER(15)EBS PK 弃用Fusion 自生成接口内自编临时键业务单位BUSINESS_UNITVARCHAR2(50) 名称ORG_ID→BU 解析NUMBER(18)ORG_IDNUMBER(15)OU→BU 映射表分类账LEDGER (via BU)VARCHAR2(30)SET_OF_BOOKS_IDNUMBER(18)SET_OF_BOOKS_IDNUMBER(15)直迁来源SOURCEVARCHAR2(25)SOURCEVARCHAR2(25)SOURCEVARCHAR2(25)历史迁建议External发票号INVOICE_NUMVARCHAR2(50)INVOICE_NUMVARCHAR2(50)INVOICE_NUMVARCHAR2(50)BULedger 内唯一OU 内去重发票类型INVOICE_TYPEVARCHAR2(25)INVOICE_TYPE_LOOKUP_CODEVARCHAR2(25)INVOICE_TYPE_LOOKUP_CODEVARCHAR2(25)STANDARD/CREDIT/PREPAYMENT 直迁金额INVOICE_AMOUNTNUMBER(28,8) CSVINVOICE_AMOUNTNUMBERINVOICE_AMOUNTNUMBER币种精度校验行和头发票日期INVOICE_DATEDATE (YYYY/MM/DD)INVOICE_DATEDATEINVOICE_DATEDATE直迁记账日期ACCOUNTING_DATEDATEGL_DATE→派生DATEGL_DATEDATE必须在打开期间供应商SUPPLIER / SUPPLIER_NUMBERVARCHAR2(30)VENDOR_ID←POZNUMBER(18)VENDOR_IDNUMBER(15)传 Segment1 而非 VENDOR_ID​供应商地点SUPPLIER_SITEVARCHAR2(15)VENDOR_SITE_IDNUMBER(18)VENDOR_SITE_IDNUMBER(15)传 Site Code发票币种INVOICE_CURRENCYVARCHAR2(15)INVOICE_CURRENCY_CODEVARCHAR2(15)INVOICE_CURRENCY_CODEVARCHAR2(15)ISO 代码付款币种PAYMENT_CURRENCYVARCHAR2(15)PAYMENT_CURRENCY_CODEVARCHAR2(15)PAYMENT_CURRENCY_CODEVARCHAR2(15)同币或固定汇率描述DESCRIPTIONVARCHAR2(240)DESCRIPTIONVARCHAR2(240)DESCRIPTIONVARCHAR2(240)直迁付款条款PAYMENT_TERMSVARCHAR2(50) 名称TERMS_IDNUMBER(18)TERMS_IDNUMBER(15)EBS terms_id→Fusion 名称反查条款日期TERMS_DATEDATETERMS_DATEDATETERMS_DATEDATE直迁付款方法PAYMENT_METHODVARCHAR2(25)PAYMENT_METHOD_LOOKUP_CODEVARCHAR2(25)PAYMENT_METHOD_LOOKUP_CODEVARCHAR2(25)枚举对齐付款组PAY_GROUPVARCHAR2(25)PAY_GROUP_LOOKUP_CODEVARCHAR2(25)PAY_GROUP_LOOKUP_CODEVARCHAR2(25)直迁负债科目LIABILITY_COMBINATIONVARCHAR2 段值串ACCTS_PAY_CODE_COMBINATION_IDNUMBER(18)ACCTS_PAY_CODE_COMBINATION_IDNUMBER(15)传段值 A.B.C.D 或新 CCID​汇率类型EXCHANGE_RATE_TYPEVARCHAR2(30)EXCHANGE_RATE_TYPEVARCHAR2(30)EXCHANGE_RATE_TYPEVARCHAR2(30)直迁汇率EXCHANGE_RATENUMBER(28,8)EXCHANGE_RATENUMBEREXCHANGE_RATENUMBER直迁最早结算日(临时预付)EARLIEST_SETTLEMENT_DATEDATEEARLIEST_SETTLEMENT_DATEDATEEARLIEST_SETTLEMENT_DATEDATE仅 PREPAYMENT 用DFFATTRIBUTE1..15VARCHAR2(150)ATTRIBUTE1..15VARCHAR2(150)ATTRIBUTE1..15VARCHAR2(150)上下文不同需重映射2. Invoice LineFBDI: AP_INVOICE_LINES_INTERFACEBO 字段FBDI 列FBDI 类型Fusion PE 列 (AP_INVOICE_LINES_ALL)Fusion PE 类型EBS 源表.列EBS 类型转换规则头联键INVOICE_IDNUMBER(18)INVOICE_IDNUMBER(18)INVOICE_IDNUMBER(15)与头一致行键INVOICE_LINE_IDNUMBER(18) 可选INVOICE_LINE_IDNUMBER(18)INVOICE_LINE_IDNUMBER(15)不填则序列填充行号LINE_NUMBERNUMBER(18)LINE_NUMBERNUMBER(18)LINE_NUMBERNUMBER(15)同发票内唯一行类型LINE_TYPE_LOOKUP_CODEVARCHAR2(25)LINE_TYPE_LOOKUP_CODEVARCHAR2(25)LINE_TYPE_LOOKUP_CODEVARCHAR2(25)ITEM/TAX/FREIGHT/MISC金额AMOUNTNUMBER(28,8)AMOUNTNUMBERAMOUNTNUMBER标准发票为正描述DESCRIPTIONVARCHAR2(240)DESCRIPTIONVARCHAR2(240)DESCRIPTIONVARCHAR2(240)PO 匹配留空继承 PO记账日ACCOUNTING_DATEDATEACCOUNTING_DATEDATEACCOUNTING_DATE/GL_DATEDATE行→头→参数→选项数量QUANTITY_INVOICEDNUMBER(28,8)QUANTITY_INVOICEDNUMBERQUANTITY_INVOICEDNUMBERPO 匹配 AMOUNTQTY*PRICE单价UNIT_PRICENUMBER(28,8)UNIT_PRICENUMBERUNIT_PRICENUMBER分配科目DISTRIBUTION_COMBINATIONVARCHAR2 段值串派生 DIST_CODE_COMBINATION_IDNUMBER(18)CODE_COMBINATION_IDNUMBER(15)传段值优于旧 CCID分摊组LINE_GROUP_NUMBERNUMBER(18)LINE_GROUP_NUMBERNUMBER(18)无—EBS 手建分配无此概念Fusion 补分摊标志PRORATE_ACROSS_FLAGVARCHAR2(1) Y/N导入行为—无—非 ITEM 行设 Y 摊到同组PO 号PURCHASE_ORDERVARCHAR2(20)PO_HEADER_ID 反查NUMBER(18)PO_HEADER_ID→SEGMENT1NUMBER(15)传 PO 号PO 行号PO_LINE_NUMBERNUMBER(18)PO_LINE_ID 反查NUMBER(18)PO_LINE_IDNUMBER(15)PO 须在 Fusion 存在收货号RECEIPT_NUMBERVARCHAR2(30)RCV_SHIPMENT_LINE_ID 反查NUMBER(18)RCV_SHIPMENT_LINE_IDNUMBER(15)税码TAX_CODE_IDNUMBER(18)TAX_CODE_IDNUMBER(18)TAX_CODE_IDNUMBER(15)Fusion 建议留空走 Tax Engine最终匹配FINAL_MATCH_FLAGVARCHAR2(1) Y/NFINAL_MATCH_FLAGVARCHAR2(1)FINAL_MATCH_FLAGVARCHAR2(1)收据匹配时忽略一行 Line 在导入时可派生多行 Distribution如 Tax 摊到多个 Item。3. Distribution无独立 FBDI sheet由 Line 派生 → AP_INVOICE_DISTRIBUTIONS_ALLBO 概念来源Fusion PE 列Fusion PE 类型EBS 源表.列EBS 类型规则发票联键Line 归属INVOICE_IDNUMBER(18)INVOICE_IDNUMBER(15)继承行联键Line 归属INVOICE_LINE_IDNUMBER(18)INVOICE_LINE_IDNUMBER(15)继承分配类型继承 LineLINE_TYPE_LOOKUP_CODEVARCHAR2(25)LINE_TYPE_LOOKUP_CODEVARCHAR2(25)ITEM/TAX/FREIGHT/MISC金额Line 金额或分摊AMOUNTNUMBERAMOUNTNUMBER行金额分配和科目 CCIDLine 段值解析DIST_CODE_COMBINATION_IDNUMBER(18)CODE_COMBINATION_IDNUMBER(15)EBS CCID 经 COA 映射或拆段值​段值1..n解析自 CCIDGL_CODE_COMBINATIONSVARCHAR2SEGMENT1..nVARCHAR2FBDI 推荐直接传段值串记账日Line 记账日ACCOUNTING_DATEDATEACCOUNTING_DATEDATEPO 分发PO 匹配PO_DISTRIBUTION_IDNUMBER(18)PO_DISTRIBUTION_IDNUMBER(15)三单匹配保留数量PO 匹配QUANTITYNUMBERQUANTITYNUMBER已过账系统POSTED_FLAGVARCHAR2(1)POSTED_FLAGVARCHAR2(1)N→YEBS 老数据若无 AP_INVOICE_LINES_ALL 只有头分配FBDI 必须造虚拟 ITEM 行再把分配挂上去否则拒绝导入。4. PrepaymentFBDI 阶段 头 TYPEPREPAYMENT 普通 Line/Dist应用另走动作阶段BO 动作FBDI / 接口类型要点Fusion PEEBS PE说明迁入预付款发票建 PREPAYMENT 发票Header.INVOICE_TYPEPREPAYMENT Line ITEM Dist 预付科目同普通发票AP_INVOICES_ALL(INVOICE_TYPE_LOOKUP_CODEPREPAYMENT) 分配AP_INVOICES_ALL AP_PREPAYMENTS_ALLEBS 的 AP_PREPAYMENTS_ALL 在 Fusion 合入发票头不再单列预制表最早结算日头级属性EARLIEST_SETTLEMENT_DATEDATEEARLIEST_SETTLEMENT_DATEEARLIEST_SETTLEMENT_DATE临时预付必填应用预付款Apply Prepayment BO 动作Prepayment Application 接口非发票 FBDI填 PrepaymentNumber(VARCHAR2)AppliedAmount(NUMBER)写 AP_INVOICE_PAYMENTS_ALLAP_INVOICE_PAYMENTS_ALL同 EBS 核销机制转回系统自动——同左EARLIEST_SETTLEMENT_DATE 触发5. 类型迁移三条硬规则字段级收口数值精度EBS 金额NUMBER实际(18,2)左右→ FBDI CSV 按NUMBER(28,8)接 → Fusion 基表NUMBER落库按币种精度可能舍入。ID 类 EBSNUMBER(15)→ FusionNUMBER(18)但EBS ID 绝不写入 Fusion PK只作接口联键。字符与日期VARCHAR2长度 EBS/Fusion 基本一致50/240/25/15Fusion Who 列LAST_UPDATED_BY扩到VARCHAR2(64)日期 FBDI 统一YYYY/MM/DDOracle 类型DATELAST_UPDATE_DATE在 Fusion 变TIMESTAMP。CCID 与 SupplierCCID 是NUMBER(18)但迁移走段值串 VARCHAR2Supplier 不传VENDOR_ID(NUMBER)改传SUPPLIER_NUMBER(VARCHAR2)SUPPLIER_SITE(VARCHAR2)由 Fusion 反查POZ_SUPPLIERS/POZ_SUPPLIER_SITES_ALL。