ORACLE EBS常用表 | 您所在的位置:网站首页 › mtl价格 › ORACLE EBS常用表 |
call fnd_global.APPS_INITIALIZE(1318,50583,401) select fnd_profile.VALUE('ORG_ID') FROM DUAL select * from hr_operating_units hou where hou.organization_id=204 --fnd select * from fnd_application select * from fnd_application_tl where application_id=101 select * from fnd_application_vl where application_id = 101 ----值集 select * from fnd_flex_value_sets select * from fnd_flex_values select * from fnd_flex_values_vl ----弹性域 select * from fnd_id_flexs select * 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=50671 select * from fnd_profile_options_vl select * from fnd_concurrent_programs 程序表 select * from fnd_concurrent_requests 请求表 select * from fnd_concurrent_processes 进程表 --inv select * 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 * 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 事务来源类型 select * from mfg_lookups ml where ml.LOOKUP_TYPE = 'MTL_TRANSACTION_ACTION' --po select * 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_all select * from po_distributions_all 分配 select * from po_releases_all 发送 select * from rcv_shipment_headers 采购接收头 select * from rcv_shipment_lines 采购接收行 select * from rcv_transactions 接收事务处理 select * from po_agents select * from po_vendors 订单 select * from po_vendor_sites_all --oe select * from ra_customers 客户 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 gl_code_combinations gcc where gcc.summary_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 科目汇总模板层次 --ar select * 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_adjustments_all 会计分录 select * from ar_distributions_all 付款计划 --ap select * 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 核销
========================华丽的分割线=========================
INV库存organization 两个含义:1. 经营单位,A/B/C分公司,A下面有A1,A2等工厂,主题目标是为了独立核算此组织ORG,ORG_ID;2. 库存组织,例如制造商的仓库,例如A1,A2等工厂Organization_id; HR_ORGANIZATION_UNITS -Org_organization_definitions Mtl_subinventory_ 库存组织单位MTL_PARAMETERS -库存组织参数(没有用ID,直接用name)MTL_SYSTEM_ITEMS_b -物料信息(同上,应用了库存组织name)MTL_SECONDARY_INVENTORIES -子库存组织 - MTL_ITEM_LOCATTIONS -货位 - SUBINVENTROY_CODE Mtl_Material_Transactions - (库存)物料事物表成本 mtl_transaction_accountstransaction_cost是事物成本;ACTUAL_COST是通过成本算法计算出来的实际成本,主计量单位 现有量汇总历史记录(正负合计)Mtl_Material_TransactionsMTL_ONHAND_QUANTITIES现有量表,组织/子库存/货位/物品 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 TRANSACTION_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_TO_ORG_ID和客户结构有关客户 RA_customers 客户Address Ra_AddressesAddress 货品抵达 site RA_SITE_USES_ALLAddress 发票抵达 site OE_ORDER_LINEs_all GL凭证gl_je_batches凭证日期: DEFAULT_EFFECTIVE_DATE会计期间: DEFAULT_PERIOD_NAME原币种凭证批借贷方汇总: RUNNING_TOTAL_DR/CR 比如美元本位币凭证批借贷方汇总: RUNNING_TOTAL_ACCOUNTED_DR/CR gl_je_headers日记账头信息批号: JE_BATCH_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_SOURCE gl_je_lines日记账体信息CODE_COMBINATION_ID 科目组合编号 GL_BALANCES 总帐余额PERIOD_NET_DR/CR 净值BEGIN_BALANCE_DR/CR 期初额 AR应收发票RA_CUSTOMER_TRX_ALL CUSTOMER_TRX_ID 发票编号 BILL_TO_SITE_USE_ID 客户收单方编号 PRIMARY_SALES_ID销售员REFERENCE是Oracle提供的外部编号输入框,但是由于版本问题和长度( |
CopyRight 2018-2019 实验室设备网 版权所有 |