RTOORACLEERP常用TABLE说明mtl_onhand_locator_v(库存数据视图)............................................................................................2inv.mtl_system_items(物料主表).......................................................................................................2ont.oe_order_headers_all(订单头)...................................................................................................6po.po_lines_all(采购订单行)............................................................................................................8apps.fnd_user(MRPII用户表)...........................................................................................................9hr.per_people_f(职工姓名表)...........................................................................................................9hr.hr_locations(交货位置表)..........................................................................................................10hwcust.hw_oe.products(产品编码表).............................................................................................10e.ra_customers(客户表)..................................................................................................................10wip.wip_accounting_classes(离散作业会计科目).........................................................................10wip.wip_comment_codes(离散作业注释).......................................................................................11wip.wip_discrete_jobs(离散作业表)...............................................................................................11wip.wip_entities(任务令信息表).....................................................................................................13wip.wip_requirement_operations(任务令物料需求发放表)..........................................................14wip.wip_operations(离散作业操作表)...........................................................................................14wip.wip_operation_resources(离散作业操作资源).......................................................................15wip.wip_transactions(离散作业交易表).........................................................................................16wip.wip_transaction_accounts(离散作业交易帐目)......................................................................17wip.wip_scrap_values(离散作业报废价值表)...............................................................................18wip.wip_shop_floor_status_codes(场地状态表).............................................................................18wip.wip_move_transactions(离散作业工序移动交易)..................................................................19wip.wip_so_allocations(分配表).....................................................................................................19wip.wip_valid_intraoperation_steps(有效的进入工序步骤).........................................................20bom.bom_bill_of_materials(BOM清单父项目).............................................................................20bom.bom_inventory_components(BOM清单构成项目)................................................................21bom.bom_assembly_comments(装配件状态表).............................................................................21bom.bom_standard_comments(标准注释表(状态说明...
