EBS常用表

select * from ap_bank_accounts_all?????????银行帐号
select * from ap_invoice_payments_all??????核销
?
========================华丽的分割线=========================
?
INV库存
select * from ap_payment_schedules_all?????付款计划
select * from ap_check_stocks_all??????????单据
select * from ap_checks_all????????????????付款
select * from ap_bank_branches?????????????银行
select * from ra_addresses_all?????????????地址
select * 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_details
select * from wsh_delivery_assignments
--gl
select * from gl_sets_of_books????总帐
select * from mtl_item_locations??????????货位
select * from mtl_lot_numbers?????????????批次
select * from mtl_onhand_quantities???????现有量表
select * from mtl_serial_numbers??????????序列
select * from po_agents????????????????????
select * from po_vendors???????????????????订单
select * from po_vendor_sites_all
--oe
select * from ra_customers?????????????????客户
SOLD_TO_ORG_ID就是客户层
SHIP_FROM_ORG_ID
SHIP_TO_ORG_ID就是客户收货层
INVOICE_TO_ORG_ID就是客户收单层
DELIVER_TO_ORG_ID
和客户结构有关
客户RA_customers?
客户Address Ra_Addresses
Address货品抵达site RA_SITE_USES_ALL
call fnd_global.APPS_INITIALIZE(1318,50583,401)
select fnd_profile.VALUE('ORG_ID') FROM DUAL
select * from hr_operating_units hou where anization_id=204
select * from ar_adjustments_all????????????会计分录
select * from ar_distributions_all??????????付款计划
--ap
select * from ap_invoices_all??????????????发票头
select * from ap_invoice_distributions_all发票行
select * from po_headers_all??????????????订单头
select * from po_lines_all????????????????订单行
select * from po_line_locations_all???????
select * from po_distributions_all?????????分配
select * from fnd_concurrent_programs???程序表
select * from fnd_concurrent_requests???请求表
select * from fnd_concurrent_processes??进程表
--inv
select * from org_organization_definitions??库存组织
PO_LINES_ALL
采购接收－退货/组织间转移/正常状态都需要使用这个模块
RCV_TRANSACTIONS
1.接收100单位货物,放入“待质检”货位
2.接受/拒绝
3.库存/退回
有三个不同的状态！例如：接收100个，80个接受入库，20个退回，那么有80个接受事务/20个退回事物
select TRANSACTION_TYPE，DESTINATION_TYPE_CODE from RCV_TRANSACTIONS
可以看出以下阶段：
A1.RECEIVE–RECEIVING
A2.ACCEPT–RECEIVING
A3.DELIERY–INVETORY(影响库存现有量)
如果按照正常模式，最后会触发产生MTL_MATERIAL_TRANSACTIONS
销售订单
OE_ORDER_headers_all
SOLD_FROM_ORG_ID
select * from gl_account_hierarchies科目汇总模板层次
--ar
select * from ar_batches_all????????????????事务处理批
select * from ra_customer_trx_all???????????发票头
select * from ra_customer_trx_lines_all?????发票行
MTL_ONHAND_QUANTITIES现有量表，组织/子库存/货位/物品summary可能按照挑库先进先出统计，如果设置了"不允许负库存"，这样就不可能出现负数
PO
请购单头表
Po_Requisition_Headers_all
行表
Po_Requisition_lines_all
采购订单
PO_HEADER_ALL
select * from gl_code_combinations gcc where gcc.summary_flag='Y'??科目组合
select * from gl_balances?????????科目余额
select * from gl_je_batches???????凭证批
select * from gl_je_headers???????凭证头
Mtl_Material_Transactions - (库存)物料事物表
成本mtl_transaction_accounts
transaction_cost是事物成本；
ACTUAL_COST是通过成本算法计算出来的实际成本，主计量单位
现有量
汇总历史记录（正负合计）
Mtl_Material_Transactions
Address发票抵达site?
OE_ORDER_LINEs_all
GL凭证
gl_je_batches
凭证日期:??????????????? DEFAULT_EFFECTIVE_DATE
会计期间:??????????????? DEFAULT_PERIOD_NAME
原币种凭证批借贷方汇总: RUNNING_TOTAL_DR/CR比如美元
select * from gl_je_lines?????????凭证行
select * from gl_je_categories????凭证分类
select * from gl_je_sources???????凭证来源
select * from gl_summary_templates科目汇总模板
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 * from fnd_flex_value_sets???
select * from fnd_flex_values???????
select * from fnd_flex_values_vl
----弹性域
select * from fnd_id_flexs?????????
select * from mtl_material_transactions???物料事务记录
select *from mtl_transaction_accounts????会计分录
select * from mtl_transaction_types???????事务类型
select * from mtl_txn_source_types????????事务来源类型
--fnd
select * from fnd_application???
select * from fnd_application_tl where application_id=101