Oracle ebs 常用数据表.doc

《Oracle ebs 常用数据表.doc》由会员分享，可在线阅读，更多相关《Oracle ebs 常用数据表.doc（10页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、如有侵权，请联系网站删除，仅供学习与交流Oracle ebs 常用数据表【精品文档】第 10 页OracleEBS常用数据表EBS常用数据表:（未整理）INV库存organization 两个含义:1. 经营单位，A/B/C分公司，A下面有A1，A2等工厂，主题目标是为了独立核算此组织ORG，ORG_ID;2. 库存组织，例如制造商的仓库，例如A1，A2等工厂Organization_id;HR_ORGANIZATION_UNITS Org_organization_definitionsMtl_subinventory_ 库存组织单位MTL_PARAMETERS -库存组织参数（没有用ID，

2、直接用name）MTL_SYSTEM_ITEMS_b -物料信息（同上，应用了库存组织name）MTL_SECONDARY_INVENTORIES -子库存组织 -MTL_ITEM_LOCATTIONS -货位 - SUBINVENTROY_CODEMtl_Material_Transactions - (库存)物料事物表成本 mtl_transaction_accountstransaction_cost是事物成本；ACTUAL_COST是通过成本算法计算出来的实际成本，主计量单位现有量汇总历史记录（正负合计）Mtl_Material_TransactionsMTL_ONHAND_QUANT

3、ITIES现有量表，组织/子库存/货位/物品 summary可能按照挑库先进先出统计，如果设置了不允许负库存，这样就不可能出现负数PO请购单头表Po_Requisition_Headers_all行表Po_Requisition_lines_all采购订单PO_HEADER_ALLPO_LINES_ALL采购接收退货/组织间转移/正常状态 都需要使用这个模块RCV_TRANSACTIONS1. 接收100单位货物,放入“待质检”货位2. 接受/拒绝3. 库存/退回有三个不同的状态！例如：接收100个，80个接受入库，20个退回，那么有80个接受事务/20个退回事物select TRANSACT

4、ION_TYPE，DESTINATION_TYPE_CODE from RCV_TRANSACTIONS可以看出以下阶段：A1.RECEIVE RECEIVINGA2.ACCEPT RECEIVINGA3.DELIERY INVETORY(影响库存现有量)如果按照正常模式，最后会触发产生MTL_MATERIAL_TRANSACTIONS销售订单OE_ORDER_headers_allSOLD_FROM_ORG_IDSOLD_TO_ORG_ID 就是客户层SHIP_FROM_ORG_IDSHIP_TO_ORG_ID 就是客户收货层INVOICE_TO_ORG_ID 就是客户收单层DELIVER_

5、TO_ORG_ID和客户结构有关客户 RA_customers客户Address Ra_AddressesAddress 货品抵达 site RA_SITE_USES_ALLAddress 发票抵达 siteOE_ORDER_LINEs_allGL凭证gl_je_batches凭证日期: DEFAULT_EFFECTIVE_DATE会计期间: DEFAULT_PERIOD_NAME原币种凭证批借贷方汇总: RUNNING_TOTAL_DR/CR 比如美元本位币凭证批借贷方汇总: RUNNING_TOTAL_ACCOUNTED_DR/CRgl_je_headers日记账头信息批号: JE_BAT

6、CH_ID会计期间: PERIOD_NAME币种: CURRENCY_CODE汇率类型: CURRENCY_CONVERSION_TYPE汇率日期: CURRENCY_CONVERSION_DATE帐套: SET_OF_BOOKS_ID 参考 GL_SETS_OF_BOOKS凭证类型: JE_CATEGORY 参考 GL_JE_SOURCES凭证来源: JE_SOURCEgl_je_lines日记账体信息CODE_COMBINATION_ID 科目组合编号GL_BALANCES 总帐余额PERIOD_NET_DR/CR 净值BEGIN_BALANCE_DR/CR 期初额AR应收发票RA_CUS

7、TOMER_TRX_ALL CUSTOMER_TRX_ID 发票编号 BILL_TO_SITE_USE_ID 客户收单方编号 PRIMARY_SALES_ID销售员REFERENCE是Oracle提供的外部编号输入框，但是由于版本问题和长度(=30)，不建议用户使用，如果要使用外部编号，请使用说明性弹性域RA_CUSTOMER_TRX_LINES_ALL LINE_ID 行号 INVENTORY_ITEM_ID 可以为空，比如非物料的服务，只在DESCRIPTION中出现 /税行 DESCRIPTION QUANTITY_INVOICE 开票数量 LINE_TYPE 行类型 (一般/税) EX

8、TEND_PRICE 本行金额注意：税行是隐藏行，所以至少会有两行收款情况AR_CASH_RECEIPTS_ALL（还包含了非收款信息） CASH_RECEIPT_ID 内部code RECEIPT_NUMBER 收款号 RECEIPT_DATE 收款日期 AMOUNT 总额 RECEIPT_TYPE 现金/杂项 Cash/Misc FUNCTIONAL_AMOUNT 本位币计量金额 UI上为RECEIPTS 核销关系不是一一对应，也不是一次核销100%,UI上右下方的Application 按钮 AR_RECEIVABLE_APPLICATIONS_ALL APPLIED_CUSTOMER_

9、TRX_ID 发票编号 APPLIED_CUSTOMER_TRX_LINE_ID 发票行编号 STATUS APP表示核销 /UNAPP表示未核销 AMOUNT_APPLIED 匹配金额 注意:红冲收款报表时间跨月的问题；必须联查 AR_CASH_RECEIPTS_ALL和 AR_CASH_RECEIPT_HISTORY_ALLAP应付帐款(是我方人员按照供应商提供的纸张发票信息录入)UI 上的invoiceAP_INVOICES_ALL实际付款PAYMENTAP_CHECKS_ALL核销关系 同AR，右下方的Payment 按钮AP_INVOICE_PAYMENTS_ALL客户余额表，情况比

10、较复杂:比如两个用户合并，应收应付差额，预付款资产信息FA_ADDITIONS名称编号分类数量资产类别FA_CATEGORIES资产帐簿FA_BOOK_CONTROLS 和会计帐簿有什么关系？FA_BOOKSUI中的InquiryMothed是折旧方法(直线法/产量法)FA_DISTRIBUTION_HISTORY分配assignment，给什么部门使用多少LOCATION_ID 部门 联查FA_LOCATIONS折旧信息(分摊方法)FA_DEPRN_DETAILperiod_counter 折旧期间编号折旧事务(新增、重建、转移、报废)FA_TRANSACTION_HEADERSselect

11、 fnd_profile.VALUE(ORG_ID) FROM DUALselect * from hr_operating_units hou where hou.organization_id=204-fndselect * from fnd_applicationselect * from fnd_application_tl where application_id=101select * from fnd_application_vl where application_id = 101-值集select * from fnd_flex_value_setsselect * from

12、 fnd_flex_valuesselect * from fnd_flex_values_vl-弹性域select * from fnd_id_flexsselect * from fnd_id_flex_structures where id_flex_code=GL#select * from fnd_id_flex_segments where id_flex_code=GL# and id_flex_num=50671select * from fnd_profile_options_vlselect * from fnd_concurrent_programs 程序表select

13、* from fnd_concurrent_requests 请求表select * from fnd_concurrent_processes 进程表-invselect * from org_organization_definitions 库存组织select * from mtl_parameters 组织参数select * from mtl_system_items_b where inventory_item_id = 171 and organization_id=204 物料表select * from mtl_secondary_inventories 子库存select

14、* from mtl_item_locations 货位select * from mtl_lot_numbers 批次select * from mtl_onhand_quantities 现有量表select * from mtl_serial_numbers 序列select * from mtl_material_transactions 物料事务记录select * from mtl_transaction_accounts 会计分录select * from mtl_transaction_types 事务类型select * from mtl_txn_source_types 事

15、务来源类型select * from mfg_lookups ml where ml.LOOKUP_TYPE = MTL_TRANSACTION_ACTION-poselect * from po_requisition_headers_all 请求头select * from po_requisition_lines_all 请求行select * from po_headers_all 订单头select * from po_lines_all 订单行select * from po_line_locations_allselect * from po_distributions_all

16、分配select * from po_releases_all 发送select * from rcv_shipment_headers 采购接收头select * from rcv_shipment_lines 采购接收行select * from rcv_transactions 接收事务处理select * from po_agentsselect * from po_vendors 订单select * from po_vendor_sites_all-oeselect * from ra_customers 客户select * from ra_addresses_all 地址sel

17、ect * from ra_site_uses_all 用户select * from oe_order_headers_all 销售头select * from oe_order_lines_all 销售行select * from wsh_new_deliveries 发送select * from wsh_delivery_detailsselect * from wsh_delivery_assignments-glselect * from gl_sets_of_books 总帐select * from gl_code_combinations gcc where gcc.summ

18、ary_flag=Y 科目组合select * from gl_balances 科目余额select * from gl_je_batches 凭证批select * from gl_je_headers 凭证头select * from gl_je_lines 凭证行select * from gl_je_categories 凭证分类select * from gl_je_sources 凭证来源select * from gl_summary_templates 科目汇总模板select * from gl_account_hierarchies 科目汇总模板层次-arselect *

19、 from ar_batches_all 事务处理批select * from ra_customer_trx_all 发票头select * from ra_customer_trx_lines_all 发票行select * from ra_cust_trx_line_gl_dist_all 发票分配select * from ar_cash_receipts_all 收款select * from ar_receivable_applications_all 核销select * from ar_payment_schedules_all 发票调整select * from ar_adj

20、ustments_all 会计分录select * from ar_distributions_all 付款计划-apselect * from ap_invoices_all 发票头select * from ap_invoice_distributions_all 发票行select * from ap_payment_schedules_all 付款计划select * from ap_check_stocks_all 单据select * from ap_checks_all 付款select * from ap_bank_branches 银行select * from ap_bank_accounts_all 银行帐号select * from ap_invoice_payments_all 核销