Oracleebs常用数据表格.pdf

该【Oracleebs常用数据表格 】是由【青山代下】上传分享，文档一共【26】页，该文档可以免费在线阅读，需要了解更多关于【Oracleebs常用数据表格 】的内容，可以使用淘豆网的站内搜索功能，选择自己适合的文档，以下文字是截取该文章内的部分文字，如需要获得完整电子版，请下载此文档到您的设备，方便您编辑和打印。:..:(未整理)INV库存organization两个含义:经营单位,A/B/C分企业,A下边有A1,A2等工厂,主题目标是为了独立核算此组织_ID;库存组织,比方制造商的库房,比方A1,A2等工厂Organization_id;ANIZATION_UNITS-anization_definitionsMtl_subinventory_库存组织单位MTL_PARAMETERS库-存组织参数(没实用ID,直接用name)1:..精选文档MTL_SYSTEM_ITEMS_b物-料信息(同上,应用了库存组织name)MTL_SECONDARY_INVENTORIES子库-存组织-MTL_ITEM_LOCATTIONS货-位-SUBINVENTROY_CODEMtl_Material_Transactions-(库存)物料事物表ounts12:..;ACTUAL_COST是经过成本算法计算出来的实质成本,主计量单位现有量汇总历史记录(正负共计)Mtl_Material_TransactionsMTL_ONHAND_QUANTITIES现有量表,组织/子库存/货位/物件summary可能依据挑库先进先出统计,假如设置了不一样意负库存,这样就不行能出现负数PO请购单头表Po_Requisition_Headers_all行表Po_Requisition_lines_all采买订单3:..精选文档PO_HEADER_ALLPO_LINES_ALL采买接收-退货/组织间转移/,放入“待质检”货位24:..!比方:接收100个,80个接受入库,20个退回,那么有80个接受事务/20个退回事物selectTRANSACTION_TYPE,DESTINATION_TYPE_CODEfromRCV_TRANSACTIONS能够看出以下阶段:–RECEIVING–RECEIVING–INVETORY(影响库存现有量)假如依据正常模式,最后会触发产生MTL_MATERIAL_TRANSACTIONS销售订单OE_ORDER_headers_all_ID5:..精选文档_ID就是客户层_ID_ID就是客户收货层_ID就是客户收单层_ID36:..:DEFAULT_EFFECTIVE_DATE会计时期:DEFAULT_PERIOD_NAME原币种凭据批借贷方汇总:RUNNING_TOTAL_DR/CR比方美元本位币凭据批借贷方汇总:OUNTED_DR/CR7:..精选文档gl_je_headers日志账头信息批号:JE_BATCH_ID会计时期:PERIOD_NAME币种:CURRENCY_CODE48:..:CURRENCY_CONVERSION_TYPE汇率日期:CURRENCY_CONVERSION_DATE帐套:SET_OF_BOOKS_ID参照GL_SETS_OF_BOOKS凭据种类:JE_CATEGORY参照GL_JE_SOURCES凭据根源:JE_SOURCEgl_je_lines日志账体信息BINATION_ID科目组合编号GL_BALANCES总帐余额_DR/CR净值BEGIN_BALANCE_DR/CR期初额AR应收发票RA_CUSTOMER_TRX_ALLCUSTOMER_TRX_ID发票编号9:..BILL_TO_SITE_USE_ID客户收单方编号PRIMARY_SALES_ID销售员REFERENCE是Oracle供应的外面编号输入框,可是因为版本问题和长度(<=30),不建议用户使用,假如要使用外面编号,请使用说明性弹性域RA_CUSTOMER_TRX_LINES_ALL510:..,比方非物料的服务,只在DESCRIPTION中出现/税行DESCRIPTIONQUANTITY_INVOICE开票数目LINE_TYPE行种类(一般/税)EXTEND_PRICE本行金额注意:税行是隐蔽行,因此最少会有两行收款状况AR_CASH_RECEIPTS_ALL(还包括了非收款信息)CASH_RECEIPT_ID内部codeRECEIPT_NUMBER收款号RECEIPT_DATE收款日期11:..AMOUNT总数RECEIPT_TYPE现金/杂项Cash/MiscFUNCTIONAL_AMOUNT本位币计量金额UI上为RECEIPTS核销关系不是一一对应,也不是一次核销100%,UI上右下方的Application按钮612:..:红冲收款报表时间跨月的问题;一定联查AR_CASH_RECEIPTS_ALL和AR_CASH_RECEIPT_HISTORY_ALLAP对付帐款(是我方人员依据供应商供应的纸张发票信息录入)UI上的invoiceAP_INVOICES_ALL实质付款PAYMENTAP_CHECKS_ALL13:..核销关系同AR,右下方的Payment按钮AP_INVOICE_PAYMENTS_ALL客户余额表,状况比较复杂:比方两个用户归并,应收对付差额,预支款财富信息FA_ADDITIONS名称714:..?FA_BOOKSUI中的InquiryMothed是折旧方法(直线法/产量法)FA_DISTRIBUTION_HISTORY分派assignment,给什么部门使用多少LOCATION_ID部门联查FA_LOCATIONS折旧信息(分摊方法)15:..精选文档FA_DEPRN_DETAILperiod_counter折旧时期编号折旧事务(新增、重修、转移、报废)FA_TRANSACTION_HEADERS816:..精选文档select('ORG_ID')FROMDUALselect*fromfnd_profile_options_vlselect*fromhr_operating_unitshouwhere=204select*fromfnd_concurre--fndnt_programs程序表select*fromfnd_applicationselect*fromfnd_concurrent_requests恳求表select*fromfnd_application_tlwhereapplication_id=101select*fromfnd_application_vlwhereapplication_id=101值集select*fromfnd_flex_value_setsselect*fromfnd_flex_valuesselect*fromfnd_flex_values_vl弹性域select*fromfnd_id_flexsselect*fromfnd_id_flex_structureswhereid_flex_code='GL#'select*fromfnd_id_flex_segmentswhereid_flex_code='GL#'17:..=50671918:..*fromfnd_concurrent_processes进度表--invselect*anization_definitions库存组织组select*frommtl_parameters织参数select*frommtl_system_items_bwhereinventory_item_id=171andorganization_id=204物料表select*frommtl_secondary_inventories子库存select*frommtl_item_locations货位select*frommtl_lot_numbers批次select*frommtl_onhand_quantities现有量表select*frommtl_serial_numbers序列select*frommtl_material_transactions物料事务记录select*ounts会计分录select*frommtl_transaction_types事务种类select*frommtl_txn_source_types事务根源种类select*frommfg_lookupsmlwhere='MTL_TRANSACTION_ACTION'19:..精选文档--poselect*frompo_requisition_headers_all10恳求头20:..*frompo_requisition_lines_all恳求行select*frompo_headers_all订单头select*frompo_lines_all订单行select*frompo_line_locations_allselect*frompo_distributions_all分派select*frompo_releases_all发送select*fromrcv_shipment_headers采买接收头select*fromrcv_shipment_lines采买接收行select*fromrcv_transactions接收事务办理select*frompo_agentsselect*frompo_vendors订单select*frompo_vendor_sites_all--oe21:..精选文档select*fromra_customers客户select*fromra_addresses_all地点select*fromra_site_uses_all用户select*fromoe_order_headers_all销售头1122:..*fromoe_order_lines_all销售行select*fromwsh_new_deliveries发送select*fromwsh_delivery_detailsselect*fromwsh_delivery_assignments--glselect*fromgl_sets_of_books总帐select*where='Y'科目组合科目select*fromgl_balances余额select*fromgl_je_batches凭据批select*fromgl_je_headers凭据头凭据select*fromgl_je_lines行select*fromgl_je_categories凭据分类凭据根select*fromgl_je_sources源select*fromgl_summary_templates科目汇总模板select*ount_hiera科目汇总模rchies板层次--ar23:..精选文档事务select*fromar_batches_all办理批1224:..*fromra_customer_trx_all票头select*fromra_customer_trx_lines_all发票行select*fromra_cust_trx_line_gl_dist_all发票分派select*fromar_cash_receipts_all收款select*fromar_receivable_applications_all核销select*fromar_payment_schedules_all发票调整会select*fromar_adjustments_all计分录付款select*fromar_distributions_all计划--ap发select*fromap_invoices_all票头select*fromap_invoice_distributions_all发票行select*fromap_payment_schedules_all付款计划select*fromap_check_stocks_all票据付select*fromap_checks_all款银select*fromap_bank_branches行银行帐select*ounts_all号25:..select*fromap_invoice_payments_all核销1326