ERPMRP管理ORACLEERP常用TABLE说明最全版.docx

1、ERPMRP管理ORACLEERP常用TABLE说明最全版（ERPMRP管理)ORACLEERP常用TABLE说明ORACLEERP常用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(

2、客户表)10wip.wip_accounting_classes(离散作业会计科目)10wip.wip_ment_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(

3、离散作业交易帐目)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_ponents(BOM清单构成项目)21bom.bom_assembly_ments(装配件

4、状态表)21bom.bom_standard_ments(标准注释表(状态说明表)22bom.bom_calendars(日历种类表)22bom.bom_calendar_dates(工作日历表)22bom.bom_calendar_exceptions(日历例外信息)22bom.bom_calendar_shifts(倒班表)23bom.bom_shift_dates(轮班表)23bom.bom_cal_week_start_dates(星期开始日期)23bom.bom_period_start_dates(周期开始日期)24bom.bom_workday_patterns(工作日模式表)2

5、4bom.bom_exception_sets(BOM例外集表)24bom.cst_item_costs(项目成本表)25bom.cst_cost_types(成本类型表)25bom.cst_item_cost_details(项目成本明细表)26bom.cst_cost_elements(成本要素代码表)26bom.cst_elemental_costs(项目要素成本)27bom.cst_resource_costs(资源成本)27bom.cst_standard_costs(项目标准成本表)27bom.cst_std_cost_adj_values(标准成本调节表)28bom.bom_de

6、partments(部门代码对应表)29bom.bom_resources(资源代码对应表)29bom.bom_operational_routings(工艺路线)30bom.bom_operation_resources(工艺路线细节之资源表)30bom.bom_operation_sequences(工艺路线细节之工艺工序表)30bom.bom_standard_operations(标准操作表)31bom.bom_std_op_resources(标准操作资源表)31bom.bom_substitute_ponents(BOM替代件表)32mrp.mrp_assembly_operati

7、ons(计划装配实施表)32mrp.mrp_forecast_items(预测项目表)33mrp.mrp_forecast_designators(预测名称表)33mrp.mrp_forecast_dates(预测表)33mrp.mrp_forecast_updates(预测更改)34mrp.mrp_gross_requirements(毛需求)34mrp.mrp_item_purchase_orders(MRP采购计划)35mrp.mrp_item_wip_entities(MRP项目离散作业)37mrp.mrp_plans(计划表)37mrp.mrp_remendations (计划建议(

8、含例外信息)38mtl_onhand_locator_v(库存数据视图)常用视图表名：mtl_onhand_locator_v说明：库存数据视图列名类型含义inventory_item_idnumber项目内码organization_idnumber组织代码padded_concatenated_segments物品编码revisionvarchar2(3)物品版本totalqohnumber现有量subinventory_codevarchar2(10)子库名locator_idnumber货位内码inv.mtl_system_items(物料主表)inv模块常用表结构表名：inv.mtl

9、_system_items说明：物料主表列名类型含义organization_idnumber组织代码inventory_item_idnumber项目内码segment1varchar2(40)项目编码（外码）unit_of_issue单位description项目说明allowed_units_lookup_code可否单位换算inventory_item_status_code项目状态item_type项目类型primary_unit_of_measure基本度量单位base_item_id基础代码bom_enabled_flagbom使能标志(项目能否有清单)(y/n)bom_item

10、_typebom项目类型engineering_e_code工程更改号engineering_item_id工程项目代码eng_item_flag是否是工程项目costing_enabled_flag成本始能标志(有无成本)cost_of_sales_account货物销售帐目default_include_in_rollup_flag是否可为缺省inventory_asset_flag是否是库存资产std_lot_size标准批量规格allow_item_desc_update_flag是否可更新项目说明asset_category_id资产类别buyer_id采购员代码encumbranc

11、e_account无效帐目expense_account费用帐户hazard_class_id风险类代码list_price_per_unit单位定价market_price市价outside_operation_flag外部操作项目outside_operation_uom_type外部操作单位类型price_tolerance_percent允许价格偏差百分比purchasing_enabled_flag是否可采购purchasing_item_flag采购项目rounding_factora取舍因子taxable_flag税收项目unit_of_issue单位allow_express_

12、delivery_flaga可以快递项目allow_substitute_receipts_flag收据是否可以替换days_early_receipt_allowed可以提前天数days_late_receipt_allowed可以推迟天数enforce_ship_to_location_code目的地invoice_close_tolerance发票结束偏差qty_rcv_exception_code例外接收数量代码qty_rcv_tolerance例外接收允许量receipt_required_flaga是否必须收据receive_close_tolerancea接收结束允许天数rece

13、iving_routing_id接收行程安排编码auto_serial_alpha_prefixstartingserialprefixcycle_count_enabled_flag能否循环计算inventory_item_flag是否为库存项目location_control_code采购点控制代码lot_control_code是否有批量控制mtl_transactions_enabled_flag可否交易positive_measurement_errorposmeasurementerrorreservable_type是否要预留restrict_locators_code是否限制定

14、位revision_qty_control_code是否受修订版本控制serial_number_control_code是否受系列号控制shelf_life_code有无存储期控制shelf_life_days存储期天数start_auto_lot_number开始批量start_auto_serial_number开始系列号stock_enabled_flag能否库存unit_volume体积unit_weight重量volume_uom_code体积度量单位weight_uom_code重量度量单位carrying_cost运输费用百分比fixed_days_supply固定提前期fix

15、ed_lot_multiplier固定批量大小fixed_order_quantity固定定单数inventory_planning_code库存计划方法maximum_order_quantity最大定单数max_minmax_quantitymin-maxmaximumquantityminimum_order_quantity最小定单数min_minmax_quantitymin-maxminimumquantitymrp_safety_stock_code安全库存mrp_safety_stock_percent安全库存百分比order_cost定单费用planner_code计划员属性

16、safety_stock_bucket_days安全库存天数source_organization_id来源组织代码source_subinventory来源子库存source_type补充来源类型acceptable_early_days接收提前天数auto_reduce_mps自动冲减mpsdemand_time_fence_code需求时间栏demand_time_fence_days需求时间栏天数mrp_calculate_atp_flag是否有atpmrp_planning_code计划方法overrun_percentage超差百分比planning_make_buy_code制造

17、或购买planning_time_fence_code计划时间栏planning_time_fence_days计划时间栏天数repetitive_planning_flag是否是重复计划shrinkage_rate收缩比率cumulative_total_lead_time累积总体提前期cum_manufacturing_lead_time制造提前期full_lead_time处理提前期lead_time_lot_size批量提前期preprocessing_lead_time预处理提前期variable_lead_time不定的提前期build_in_wip_flag是否在制wip_sup

18、ply_locator_id离散作业库存地点wip_supply_type离散作业供货类型atp_ponents_flag是否有atp组成部件atp_flag是否为atp项目atp_rule_idatp规则collateral_flag是否为附属项目customer_order_flag是否为定单项目default_shipping_org运输组织代码internal_order_enabled_flag是否可以是内部定单internal_order_flag是否为内部定单picking_rule_id库存规则pick_ponents_flag是否为可选部件replenish_to_order

19、_flag是否为定单装配returnable_flag是否可退回return_inspection_requirementrmainspectionstatusshippable_item_flag是否为运输项目ship_model_plete_flag运送是否完成so_transactions_flag是否可交易accounting_rule_id会计规则invoiceable_item_flag是否为需发票项目invoice_enabled_flag是否具有发票invoicing_rule_id发票规则payment_terms_id付款期限sales_account销售帐目tax_cod

20、e税收代码ato_forecast_control预测控制must_use_approved_vendor_flag是否必须授权供应商un_number_id货期allow_unordered_receipts_flag是否为非定单收据inspection_required_flag是否需检查receipt_days_exception_code接收天数例外代码restrict_subinventories_code子库存限制acceptable_rate_decrease可接受减少率end_assembly_pegging_flag是否是最终装配planning_exception_set计

21、划例外设置rounding_control_type四舍五入控制fixed_lead_time固定提前期postprocessing_lead_time后处理提前期wip_supply_subinventory离散作业子库存customer_order_enabled_flag是否是销售定单acceptable_rate_increase可接受的增加率ont.oe_order_headers_all(订单头)oe模块常用表结构so_headers_all；so_lines_all；表名:ont.oe_order_headers_all说明:订单头header_idnumber订单头标识码org

22、_idnumberouidorder_type_idnumber订单类型idorder_numbernumber订单编号ordered_datedate定购日期request_datedate客户要求发货日期demand_class_codevarchar2(30)需求分类codeprice_list_idnumber价目表idtransactional_curr_codevarchar2(15)币种cust_po_numbervarchar2(50)合同号invoicing_rule_idnumber(15)开票规则idaccounting_rule_idnumber(15)会计规则idpa

23、yment_term_idnumber(15)付款条件idshipping_method_codevarchar2(30)发运方法codefob_point_codevarchar2(30)fobcodefreight_terms_codevarchar2(30)运费条款codeship_from_org_idnumber发货库存组织idship_to_org_idnumber客户account_idinvoice_to_org_idnumber开票客户account_idsold_to_contact_idnumber经办人idship_to_contact_idnumber发货至联系人id

24、invoice_to_contact_idnumber开票至联系人idcreation_datedate输入日期created_bynumber输入人idlast_updated_bynumber更新人last_update_datedate更新日期last_update_loginnumber更新人用户attribute1date合同收到日期attribute2date客户要求到货日期attribute3varchar2(240)到货视同验收attribute11varchar2(240)客户行业分类codeattribute12varchar2(240)合同文本金额attribute13v

25、archar2(240)是否需要客服到货确认attribute14date承诺核销日期cancelled_flagvarchar2(1)是否取消open_flagvarchar2(1)是否未结booked_flagvarchar2(1)登记与否salesrep_idnumber(15)销售员idreturn_reason_codevarchar2(30)退货原因codesales_channel_codevarchar2(30)销售渠道codeorder_category_codevarchar2(30)订单类别shipping_instructionsvarchar2(2000)老合同号pa

26、cking_instructionsvarchar2(2000)包装指令flow_status_codevarchar2(30)工作流状态代码booked_datedate下单日期po.po_lines_all(采购订单行)表名:po.po_lines_all说明:采购订单行po_line_idnumber行标识码po_header_idnumber订单头标识码line_type_idnumber行类型line_numnumber行栏目item_idnumber项目内码item_revisionvarchar2(3)项目版本category_idnumber归类标识码item_descript

27、ionvarchar2(240)项目描述unit_meas_lookup_codevarchar2(25)单位quantity_mittednumber提交数量mitted_amountnumber提交金额allow_price_override_flagvarchar2(1)价格佣金允许not_to_exceed_pricenumber不允许超过价格list_price_per_unitnumberunit_pricenumber单价quantitynumber数量un_number_idnumber货期标识码hazard_class_idnumber风险类别标识码note_to_vendo

28、rvarchar2(240)对供应商的说明from_header_idnumber来源订单头号from_line_idnumber来源行号min_order_quantitynumber最小订单数量max_order_quantitynumber最大订单数量qty_rcv_tolerancenumber可接收数量over_tolerance_error_flagvarchar2(25)超差示错标志market_pricenumber市价unordered_flagvarchar2(1)不定货标志closed_flagvarchar2(1)关闭标志user_hold_flagvarchar2(1

29、)cancel_flagvarchar2(1)取消标志cancelled_bynumber(9)取消者cancel_datedate取消日期cancel_reasonvarchar2(240)取消原因firm_status_lookup_codevarchar2(30)firm_datedatetaxable_flagvarchar2(1)应税标志tax_namevarchar2(15)税种capital_expense_flagvarchar2(1)大写金额标志negotiated_by_preparer_flagvarchar2(1)closed_datedate关闭日期closed_re

30、asonvarchar2(240)关闭原因transaction_reason_codevarchar2(25)交易原因attribute10varchar2(150)厂家attribute11varchar2(150)型号apps.fnd_user(mrpii用户表)其它字典表表名：apps.fnd_user说明:mrpii用户表user_idnumber用户iduser_namevarchar2用户名称employee_idnumber使用人id(可与hr.per_people_f.person_id关联)hr.per_people_f(职工姓名表)表名:hr.per_people_f说明

31、:职工姓名表person_idnumber职工id号last_namevarchar2姓名full_namevarchar2姓名(带称呼mr./miss./mrs.)date_of_birthdate生日employee_numbervarchar2工号sexvarchar2性别(m/f)titlevarchar2称呼(mr./miss./mrs)hr.hr_locations(交货位置表)表名:hr.hr_locations说明:交货位置表location_idnumberid号location_codevarchar2名称address_line_1varchar2地址postal_codeva