EBS R12 各模块核心物理表基表清单按模块分组列出表名。带 _ALL 的表支持多组织Multi-Org需配合 ORG_ID 使用。一、总账 GLGL_LEDGERSGL_SETS_OF_BOOKSGL_PERIOD_SETSGL_PERIODSGL_PERIOD_STATUSESGL_CODE_COMBINATIONSGL_JE_BATCHESGL_JE_HEADERS_ALLGL_JE_LINES_ALLGL_BALANCESGL_INTERFACEGL_IMPORT_REFERENCES二、应付 APAP_BATCHES_ALLAP_INVOICES_ALLAP_INVOICE_LINES_ALLAP_INVOICE_DISTRIBUTIONS_ALLAP_PAYMENT_SCHEDULES_ALLAP_CHECKS_ALLAP_INVOICE_PAYMENTS_ALLAP_PAYMENT_HISTORY_ALLAP_PAYMENT_HIST_DISTSAP_PREPAY_HISTORY_ALLAP_PREPAY_APP_DISTSAP_HOLDS_ALLAP_SUPPLIERSAP_SUPPLIER_SITES_ALLAP_AWT_TEMP_DISTRIBUTIONS_ALLAP_SELF_ASSESSED_TAX_DIST_ALL三、应收 ARAR_BATCHES_ALLRA_CUSTOMER_TRX_ALLRA_CUSTOMER_TRX_LINES_ALLRA_CUST_TRX_LINE_GL_DIST_ALLAR_CASH_RECEIPTS_ALLAR_RECEIVABLE_APPLICATIONS_ALLAR_ADJUSTMENTS_ALLAR_DISTRIBUTIONS_ALLAR_MISC_CASH_DISTRIBUTIONS_ALLAR_PAYMENT_SCHEDULES_ALLHZ_PARTIESHZ_CUST_ACCOUNTSHZ_CUST_ACCT_SITES_ALLHZ_CUST_SITE_USES_ALL四、资产 FAFA_ADDITIONS_BFA_BOOKSFA_BOOK_CONTROLSFA_TRANSACTION_HEADERSFA_DISTRIBUTION_HISTORYFA_DEPRN_SUMMARYFA_DEPRN_DETAILFA_DEPRN_PERIODSFA_RETIREMENTSFA_ASSET_INVOICESFA_MASS_ADDITIONSFA_CATEGORIES_BFA_CATEGORIES_TLFA_CATEGORY_BOOKSFA_CATEGORY_BOOK_DEFAULTS五、采购 POPO_REQUISITION_HEADERS_ALLPO_REQUISITION_LINES_ALLPO_HEADERS_ALLPO_LINES_ALLPO_LINE_LOCATIONS_ALLPO_DISTRIBUTIONS_ALLPO_VENDOR_SITES_ALL收货相关见库存模块。六、库存 INVMTL_PARAMETERSMTL_SYSTEM_ITEMS_BMTL_CATEGORY_SETS_BMTL_CATEGORIES_BMTL_ITEM_CATEGORIESMTL_SECONDARY_INVENTORIESMTL_ITEM_LOCATIONSMTL_ONHAND_QUANTITIES_DETAILMTL_MATERIAL_TRANSACTIONSMTL_TRANSACTION_TYPESMTL_TRANSACTION_ACCOUNTSMTL_LOT_NUMBERSMTL_SERIAL_NUMBERSMTL_RESERVATIONSMTL_DEMANDMTL_TXN_REQUEST_HEADERSMTL_TXN_REQUEST_LINESMTL_TRANSACTIONS_INTERFACEMTL_MATERIAL_TRANSACTIONS_TEMPMTL_INTERFACE_ERRORSMTL_TRANSACTION_LOTS_INTERFACEMTL_SERIAL_NUMBERS_INTERFACE收货子模块RCV_SHIPMENT_HEADERSRCV_SHIPMENT_LINESRCV_TRANSACTIONSRCV_RECEIVING_SUB_LEDGER七、成本 CostingCST_COST_TYPESCST_COST_ELEMENTSCST_ITEM_COSTSMTL_TRANSACTION_ACCOUNTSWIP_TRANSACTION_ACCOUNTSCST_COGS_EVENTSWIP_DISCRETE_JOBSWIP_TRANSACTIONSWIP_RESOURCE_TRANSACTIONS八、销售 OM / WSHOE_ORDER_HEADERS_ALLOE_ORDER_LINES_ALLWSH_DELIVERY_ASSIGNMENTSWSH_DELIVERY_DETAILSWSH_NEW_DELIVERIESWSH_TRIPSWSH_TRIP_STOPSMTL_MATERIAL_TRANSACTIONS 发料/发货事务销售开票后对接 ARRA_CUSTOMER_TRX_ALL 等见应收模块。九、关联交易 IntercompanyEBS 没有独立的关联交易物理表其数据分散在以下表中通过法人/经营单位ORG_ID / LEGAL_ENTITY_ID区分PO_HEADERS_ALL 内部采购订单OE_ORDER_HEADERS_ALL 内部销售订单MTL_MATERIAL_TRANSACTIONS 组织间调拨TRANSACTION_TYPE_ID 标识AP_INVOICES_ALL 买方应付RA_CUSTOMER_TRX_ALL 卖方应收XLE_ENTITY_PROFILES 法人主体GL_LEDGERS 分类账XLA_AE_LINES SLA 分录承载内部应收/应付/未实现毛利十、交易计税 ZXTax EngineZX_LINESZX_LINES_SUMMARYZX_LINES_DET_FACTORSZX_REC_NREC_DISTZX_TAXES_BZX_RATES_BZX_PARTY_TAX_PROFILEAP_AWT_TEMP_DISTRIBUTIONS_ALL AP 预扣税AP_SELF_ASSESSED_TAX_DIST_ALL AP 自评估税ZX 引擎统一服务于 AP、AR、PO、OM 所有模块的税务计算。十一、SLA 子分类账贯穿所有模块XLA_TRANSACTION_ENTITIESXLA_EVENTSXLA_AE_HEADERSXLA_AE_LINESXLA_DISTRIBUTION_LINKSGL_IMPORT_REFERENCESXLA_DISTRIBUTION_LINKS 与子模块分配表的对应关系SOURCE_DISTRIBUTION_TYPE关联物理表AP_INV_DISTAP_INVOICE_DISTRIBUTIONS_ALLAP_PMT_DISTAP_PAYMENT_HIST_DISTSAR_DISTRIBUTIONS_ALLAR_DISTRIBUTIONS_ALLRA_CUST_TRX_LINE_GL_DIST_ALLRA_CUST_TRX_LINE_GL_DIST_ALLMTL_TRANSACTION_ACCOUNTSMTL_TRANSACTION_ACCOUNTSWIP_TRANSACTION_ACCOUNTSWIP_TRANSACTION_ACCOUNTSRCV_RECEIVING_SUB_LEDGERRCV_RECEIVING_SUB_LEDGER⚠️ 说明上述为 EBS R12 常用基表清单非完整穷尽。实际报表/接口开发推荐优先使用 Oracle 提供的 _ALL 表 Multi-Org 安全策略或只读视图如 GL_BALANCES_V、AP_INVOICES_V。部分资料将 GL_JE_HEADERS_ALL 简写为 GL_JE_HEADERS、GL_JE_LINES_ALL 简写为 GL_JE_LINES——两者指向同一逻辑实体是否带 _ALL 取决于是否启用 MOAC。直接操作基表存在数据一致性风险Oracle 官方不建议直接 DML生产环境应通过 API如 AP_INVOICES_PKG、AR_INVOICE_API_PUB、WSH_DELIVERY_PUB操作。