Oracle_ERP_库存管理INV_8个表结构
ORACLE+ERP常用TABLE说明
ORACLE ERP常用TABLE说明mtl_onhand_locator_v(库存数据视图) (2)inv.mtl_system_items(物料主表) (2)ont.oe_order_headers_all(订单头) (6)po.po_lines_all(采购订单行) (8)apps.fnd_user(MRPII用户表) (9)hr.per_people_f(职工姓名表) (9)hr.hr_locations(交货位置表) (10)hwcust.hw_oe.products(产品编码表) (10)e.ra_customers(客户表) (10)wip.wip_accounting_classes(离散作业会计科目) (10)wip.wip_comment_codes(离散作业注释) (11)wip.wip_discrete_jobs(离散作业表) (11)wip.wip_entities(任务令信息表) (13)wip.wip_requirement_operations(任务令物料需求发放表) (14)wip.wip_operations(离散作业操作表) (14)wip.wip_operation_resources(离散作业操作资源) (15)wip.wip_transactions(离散作业交易表) (16)wip.wip_transaction_accounts(离散作业交易帐目) (17)wip.wip_scrap_values(离散作业报废价值表) (18)wip.wip_shop_floor_status_codes(场地状态表) (18)wip.wip_move_transactions(离散作业工序移动交易) (19)wip.wip_so_allocations(分配表) (19)wip.wip_valid_intraoperation_steps(有效的进入工序步骤) (20)bom.bom_bill_of_materials(BOM清单父项目) (20)bom.bom_inventory_components(BOM清单构成项目) (21)bom.bom_assembly_comments(装配件状态表) (21)bom.bom_standard_comments(标准注释表(状态说明表)) (22)bom.bom_calendars(日历种类表) (22)bom.bom_calendar_dates(工作日历表) (22)bom.bom_calendar_exceptions(日历例外信息) (22)bom.bom_calendar_shifts(倒班表) (23)bom.bom_shift_dates(轮班表) (23)bom.bom_cal_week_start_dates(星期开始日期) (23)bom.bom_period_start_dates(周期开始日期) (24)bom.bom_workday_patterns(工作日模式表) (24)bom.bom_exception_sets(BOM例外集表) (24)bom.cst_item_costs(项目成本表) (25)bom.cst_cost_types(成本类型表) (25)bom.cst_item_cost_details(项目成本明细表) (26)bom.cst_cost_elements(成本要素代码表) (26)bom.cst_elemental_costs(项目要素成本) (27)bom.cst_resource_costs(资源成本) (27)bom.cst_standard_costs(项目标准成本表) (27)bom.cst_std_cost_adj_values(标准成本调节表) (28)bom.bom_departments(部门代码对应表) (29)bom.bom_resources(资源代码对应表) (29)bom.bom_operational_routings(工艺路线) (30)bom.bom_operation_resources(工艺路线细节之资源表) (30)bom.bom_operation_sequences(工艺路线细节之工艺工序表) (30)bom.bom_standard_operations(标准操作表) (31)bom.bom_std_op_resources(标准操作资源表) (31)bom.bom_substitute_components(BOM替代件表) (32)mrp.mrp_assembly_operations(计划装配实施表) (32)mrp.mrp_forecast_items(预测项目表) (33)mrp.mrp_forecast_designators(预测名称表) (33)mrp.mrp_forecast_dates(预测表) (33)mrp.mrp_forecast_updates(预测更改) (34)mrp.mrp_gross_requirements(毛需求) (34)mrp.mrp_item_purchase_orders(MRP采购计划) (35)mrp.mrp_item_wip_entities(MRP项目离散作业) (37)mrp.mrp_plans(计划表) (37)mrp.mrp_recommendations (计划建议(含例外信息)) (38)mtl_onhand_locator_v(库存数据视图)常用视图表名：mtl_onhand_locator_v说明：库存数据视图列名类型含义inventory_item_id number 项目内码organization_id number 组织代码padded_concatenated_segments 物品编码revision varchar2(3) 物品版本total qoh number 现有量subinventory_code varchar2(10) 子库名locator_id number 货位内码inv.mtl_system_items(物料主表)inv模块常用表结构表名：inv.mtl_system_items说明：物料主表列名类型含义organization_id number 组织代码inventory_item_id number 项目内码segment1 varchar2(40) 项目编码（外码）unit_of_issue 单位description 项目说明allowed_units_lookup_code 可否单位换算inventory_item_status_code 项目状态item_type 项目类型primary_unit_of_measure 基本度量单位base_item_id 基础代码bom_enabled_flag bom使能标志(项目能否有清单)(y/n) bom_item_type bom项目类型engineering_ecn_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 采购员代码encumbrance_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_factor a 取舍因子taxable_flag 税收项目unit_of_issue 单位allow_express_delivery_flag a 可以快递项目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_flag a 是否必须收据receive_close_tolerance a 接收结束允许天数receiving_routing_id 接收行程安排编码auto_serial_alpha_prefix starting serial prefix cycle_count_enabled_flag 能否循环计算inventory_item_flag 是否为库存项目location_control_code 采购点控制代码lot_control_code 是否有批量控制mtl_transactions_enabled_flag 可否交易positive_measurement_error pos measurement error reservable_type 是否要预留restrict_locators_code 是否限制定位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 固定提前期fixed_lot_multiplier 固定批量大小fixed_order_quantity 固定定单数inventory_planning_code 库存计划方法maximum_order_quantity 最大定单数max_minmax_quantity min-max maximum quantity minimum_order_quantity 最小定单数min_minmax_quantity min-max minimum quantity mrp_safety_stock_code 安全库存mrp_safety_stock_percent 安全库存百分比order_cost 定单费用planner_code 计划员属性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 制造或购买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_supply_locator_id 离散作业库存地点wip_supply_type 离散作业供货类型atp_components_flag 是否有atp组成部件atp_flag 是否为atp项目atp_rule_id atp规则collateral_flag 是否为附属项目customer_order_flag 是否为定单项目default_shipping_org 运输组织代码internal_order_enabled_flag 是否可以是内部定单internal_order_flag 是否为内部定单picking_rule_id 库存规则pick_components_flag 是否为可选部件replenish_to_order_flag 是否为定单装配returnable_flag 是否可退回return_inspection_requirement rma inspection status shippable_item_flag 是否为运输项目ship_model_complete_flag 运送是否完成so_transactions_flag 是否可交易accounting_rule_id 会计规则invoiceable_item_flag 是否为需发票项目invoice_enabled_flag 是否具有发票invoicing_rule_id 发票规则payment_terms_id 付款期限sales_account 销售帐目tax_code 税收代码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 计划例外设置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_id number 订单头标识码org_id number ou idorder_type_id number 订单类型idorder_number number 订单编号ordered_date date 定购日期request_date date 客户要求发货日期demand_class_code varchar2(30) 需求分类codeprice_list_id number 价目表idtransactional_curr_code varchar2(15) 币种cust_po_number varchar2(50) 合同号invoicing_rule_id number(15) 开票规则id accounting_rule_id number(15) 会计规则id payment_term_id number(15) 付款条件id shipping_method_code varchar2(30) 发运方法code fob_point_code varchar2(30) fob codefreight_terms_code varchar2(30) 运费条款code ship_from_org_id number 发货库存组织idship_to_org_id number 客户account_idinvoice_to_org_id number 开票客户account_id sold_to_contact_id number 经办人idship_to_contact_id number 发货至联系人id invoice_to_contact_id number 开票至联系人id creation_date date 输入日期created_by number 输入人idlast_updated_by number 更新人last_update_date date 更新日期last_update_login number 更新人用户attribute1 date 合同收到日期attribute2 date 客户要求到货日期attribute3 varchar2(240) 到货视同验收attribute11 varchar2(240) 客户行业分类code attribute12 varchar2(240) 合同文本金额attribute13 varchar2(240) 是否需要客服到货确认attribute14 date 承诺核销日期cancelled_flag varchar2(1) 是否取消open_flag varchar2(1) 是否未结booked_flag varchar2(1) 登记与否salesrep_id number(15) 销售员idreturn_reason_code varchar2(30) 退货原因code sales_channel_code varchar2(30) 销售渠道code order_category_code varchar2(30) 订单类别shipping_instructions varchar2(2000) 老合同号packing_instructions varchar2(2000) 包装指令flow_status_code varchar2(30) 工作流状态代码booked_date date 下单日期po.po_lines_all(采购订单行)表名: po.po_lines_all说明: 采购订单行po_line_id number 行标识码po_header_id number 订单头标识码line_type_id number 行类型line_num number 行栏目item_id number 项目内码item_revision varchar2(3) 项目版本category_id number 归类标识码item_description varchar2(240) 项目描述unit_meas_lookup_code varchar2(25) 单位quantity_committed number 提交数量committed_amount number 提交金额allow_price_override_flag varchar2(1) 价格佣金允许not_to_exceed_price number 不允许超过价格list_price_per_unit numberunit_price number 单价quantity number 数量un_number_id number 货期标识码hazard_class_id number 风险类别标识码note_to_vendor varchar2(240) 对供应商的说明from_header_id number 来源订单头号from_line_id number 来源行号min_order_quantity number 最小订单数量max_order_quantity number 最大订单数量qty_rcv_tolerance number 可接收数量over_tolerance_error_flag varchar2(25) 超差示错标志market_price number 市价unordered_flag varchar2(1) 不定货标志closed_flag varchar2(1) 关闭标志user_hold_flag varchar2(1)cancel_flag varchar2(1) 取消标志cancelled_by number(9) 取消者cancel_date date 取消日期cancel_reason varchar2(240) 取消原因firm_status_lookup_code varchar2(30)firm_date datetaxable_flag varchar2(1) 应税标志tax_name varchar2(15) 税种capital_expense_flag varchar2(1) 大写金额标志negotiated_by_preparer_flag varchar2(1)closed_date date 关闭日期closed_reason varchar2(240) 关闭原因transaction_reason_code varchar2(25) 交易原因attribute10 varchar2(150) 厂家attribute11 varchar2(150) 型号apps.fnd_user(mrpii用户表)其它字典表表名：apps.fnd_user说明:mrpii用户表user_id number 用户iduser_name varchar2 用户名称employee_id number 使用人id(可与hr.per_people_f.person_id关联)hr.per_people_f(职工姓名表)表名:hr.per_people_f说明:职工姓名表person_id number 职工id号last_name varchar2 姓名full_name varchar2 姓名(带称呼mr./miss./mrs.)date_of_birth date 生日employee_number varchar2 工号sex varchar2 性别(m/f)title varchar2 称呼(mr./miss./mrs)hr.hr_locations(交货位置表)表名:hr.hr_locations说明:交货位置表location_id number id号location_code varchar2 名称address_line_1 varchar2 地址postal_code varchar2 邮编receiving_site_flag varchar2 可否接收tax_name varchar2 税种telephone_number_1 varchar2 电话1telephone_number_2 varchar2 电话2town_or_city varchar2 城市hwcust.hw_oe.products(产品编码表)表名: hwcust.hw_oe.products说明: 产品编码表product_code varchar2(20) 产品代码product_classes varchar2(30) 产品类别product_sub_classes varchar2(16) 产品子类product_name varchar2(30) 产品名称unit_of_measure varchar2(4) 单位start_date_active date 开始时间end_date_active date 结束时间status varchar2(1) 状态e.ra_customers(客户表)表名e.ra_customers说明:客户表customer_id number 客户idcustomer_number varchar2 客户代码customer_name varchar2 客户名称wip.wip_accounting_classes(离散作业会计科目) wip模块常用表结构表名: wip.wip_accounting_classes说明: 离散作业会计科目class_code varchar2(10) 帐目organization_id number 组织代码class_type number 帐目类型description varchar2(240) 描述disable_date date 失效日期material_account number 物料帐目material_variance_account number 物料差异帐目material_overhead_account number 物料经常费用帐目resource_account number 资源帐目resource_variance_account number 资源差异帐目outside_processing_account numberoutside_proc_variance_account numberoverhead_account number 经常费用帐目overhead_variance_account number 经常费用差异帐目std_cost_adjustment_account number 标准成本调节帐目completion_cost_source number 完成成本来源cost_type_id number 成本类型bridging_account number 过渡帐目wip.wip_comment_codes(离散作业注释)表名: wip.wip_comment_codes说明: 离散作业注释comment_code varchar2(10) 注释organization_id number 组织代码comment_description varchar2(240) 说明wip.wip_discrete_jobs(离散作业表)表名: wip.wip_discrete_jobs说明: 离散作业表wip_entity_id number 任务令内码organization_id number 组织代码source_line_id number 来源行号source_code varchar2(20) 来源description varchar2(240) 说明status_type number 状态primary_item_id number 加工件内码firm_planned_flag numberjob_type number 作业类型(1.标准,3.非标准)wip_supply_type number 供应类型class_code varchar2(10) 任务类别material_account number 物料帐目material_overhead_account number 物料经常费用帐目resource_account number 资源帐目outside_processing_account number 外(超)处理帐目material_variance_account number 物料差异帐目resource_variance_account number 资源差异帐目outside_proc_variance_account number 外(超)处理差异帐目std_cost_adjustment_account number 标准成本调整帐目overhead_account number 经常性费用帐目overhead_variance_account number 经常性费用差异帐目scheduled_start_date date 计划开工时间date_released date 任务令释放时间scheduled_completion_date date 计划完工时间date_completed date 完工时间date_closed date 关门时间start_quantity number 开始数量quantity_completed number 完工数量quantity_scrapped number 报废数量net_quantity number 净数量bom_reference_id number bom参考标识码routing_reference_id number 工艺路线参考标识码common_bom_sequence_id number 公共bom序号common_routing_sequence_id number 公共工艺路线序号bom_revision varchar2(3) bom版本routing_revision varchar2(3) 工艺路线版本bom_revision_date date bom版本日期routing_revision_date date 工艺路线版本日期lot_number varchar2(30) 批量alternate_bom_designator varchar2(10) 可替换bomalternate_routing_designator varchar2(10) 可替换工艺路线completion_subinventory varchar2(10) 完工应入子库completion_locator_id number 完工应入货位mps_scheduled_completion_date date mps计划完工时间mps_net_quantity number mps净数量demand_class varchar2(30) 需求类别schedule_group_id number 计划组标识码build_sequence numberline_id number 行号其中status_type 1 未发放的-收费不允许3 发入-收费允许4 完成-允许收费5 完成-不允许收费6 暂挂-不允许收费7 已取消-不允许收费8 等待物料单加载9 失败的物料单加载10 等待路线加载11 失败的路线加载12 关闭-不可收费13 等待-成批加载14 等待关闭15 关闭失败wip_supply_type 1 推式2 装配拉式3 操作拉式4 大量5 供应商6 虚拟7 以帐单为基础wip.wip_entities(任务令信息表)表名: wip.wip_entitieswip_entity_id number 任务令内码organization_id number 组织代码wip_entity_name varchar2(240) 任务令名称entity_type number 任务类型description varchar2(240) 说明primary_item_id number 装配件内码wip.wip_requirement_operations(任务令物料需求发放表) 表名: wip.wip_requirement_operations说明: 任务令物料需求发放表inventory_item_id number 物料项目内码organization_id number 组织代码wip_entity_id number 任务令内码operation_seq_num number 工序号repetitive_schedule_id number 重复计划标识码component_sequence_id number bom清单构成件序号department_id number 部门标识码wip_supply_type number 供应类型date_required date 要求日期required_quantity number 要求数量quantity_issued number 发放数量quantity_per_assembly number 单位需求量comments varchar2(40) 注释supply_subinventory varchar2(10) 供应子库supply_locator_id number 供应货位mrp_net_flag number 净mrp标志mps_required_quantity number mps要求数量mps_date_required number mps要求日期segment1 物料项目编码(外码)wip.wip_operations(离散作业操作表)表名: wip.wip_operationswip_entity_id number 任务令内码operation_seq_num number 工序号organization_id number 组织代码repetitive_schedule_id number 重复计划代码operation_sequence_id number 操作序号standard_operation_id number 标准操作序号department_id number 部门标识代码description varchar2(240) 描述scheduled_quantity number 计划数量quantity_in_queue number 排队数量quantity_running number 运行数量quantity_waiting_to_move number 待移动数量quantity_rejected number 故障品数量quantity_scrapped number 报废品数量quantity_completed number 完工数量first_unit_start_date date 最早一个单位上线时间first_unit_completion_date date 最早一个单位完成时间last_unit_start_date date 最后一个单位上线时间last_unit_completion_date date 最后一个单位完工时间previous_operation_seq_num number 前一工序序号next_operation_seq_num number 下一工序序号count_point_type number 计数点(1.是--自动收费,2.否) backflush_flag number 倒冲库存标识(1.是,2.否) minimum_transfer_quantity number 最小传送数量date_last_moved date 最后移动时间wip.wip_operation_resources(离散作业操作资源) 表名: wip.wip_operation_resources说明: 离散作业操作资源表wip_entity_id number 任务令内码operation_seq_num number 工序号resource_seq_num number 资源序号organization_id number 组织代码repetitive_schedule_id number 重复计划代码resource_id number 资源代码uom_code varchar2(3) 单位basis_type number 基本类型(1.项目,2.批量)usage_rate_or_amount number 利用率或金额activity_id number 活动(1.运行,4.移动,5.排队)scheduled_flag number 计划标志assigned_units nubmer 已分配单位autocharge_type number 自动记帐(1.wip移动,2.人工,3.po接收,4.po移动) standard_rate_flag number 标准费用率标志(1.否,2.是)applied_resource_units number 已应用单位applied_resource_value number 已应用值start_date date 开始日期completion_date date 完成日期wip.wip_transactions(离散作业交易表)表名: wip.wip_transactions说明: 离散作业交易表transaction_id nubmer 交易代码organization_id nubmer 组织代码wip_entity_id nubmer 任务令内码primary_item_id nubmer 加工件内码acct_period_id nubmerdepartment_id nubmer 部门内码transaction_type nubmer 交易类型*transaction_date date 交易日期group_id nubmer 组号source_code varchar2(30) 来源source_line_id nubmer 来源行号operation_seq_num nubmer 工序号resource_seq_num nubmer 资源序号employee_id nubmer 雇员标识号resource_id nubmer 资源标识号autocharge_type nubmer 自动记帐(1.wip移动,2.人工,3.po接收,4.po移动) standard_rate_flag nubmer 标准费用率标志(1.否,2.是)usage_rate_or_amount nubmer 利用率或金额basis_type nubmer 基本类型(1.项目,2.批量)transaction_quantity nubmer 交易数量transaction_uom varchar2(3) 交易单位primary_quantity nubmer 基本数量primary_uom varchar2(3) 基本单位actual_resource_rate nubmer 资源实际利用率standard_resource_rate nubmer 标准资源可用率currency_code varchar2(15) 货币代码currency_conversion_date date 货币兑换日期currency_conversion_type varchar2(10) 货币兑换类型currency_conversion_rate nubmer 汇率currency_actual_resource_rate nubmer 按该币种计算的资源实际利用率activity_id nubmer 活动(1.运行,4.移动,5.排队)reason_id nubmer 原因代码reference varchar2(240) 参考move_transaction_id nubmer 移动交易代码po_header_id nubmer 采购订单头po_line_id nubmer 采购订单行号rcv_transaction_id nubmer 接收交易代码(采购订单到货)注:transaction_type取值:1.资源交易,2.制造费交易,3.外部处理,4.成本更新,5.周期关闭差异,6.作业关闭差异wip.wip_transaction_accounts(离散作业交易帐目)表名: wip.wip_transaction_accounts说明: 离散作业交易帐目organization_id number 组织代码transaction_id number 交易代码reference_account number 参考科目transaction_date date 交易日期wip_entity_id number 任务令内码repetitive_schedule_id number 重复计划代码accounting_line_type number 会计栏类型transaction_value number 交易价值base_transaction_value number 基本交易价值contra_set_id number 反方集代码primary_quantity number 基本数量rate_or_amount number 率或金额basis_type number 基本类型(1.项目,2.批量) resource_id number 资源代码cost_element_id number 成本要素activity_id number 活动(1.运行,4.移动,5.排队) currency_code varchar2(15) 币种currency_conversion_date date 汇率日期currency_conversion_type varchar2(10) 汇率类型currency_conversion_rate number 汇率overhead_basis_factor number 基本经常费用因子basis_resource_id number 基本资源代码gl_batch_id number 财务批号wip.wip_scrap_values(离散作业报废价值表)表名: wip.wip_scrap_values说明: 离散作业报废价值表transaction_id number 交易代码level_type number 级别类型cost_element_id number 成本要素cost_element_value number 要素值wip.wip_shop_floor_status_codes(场地状态表) 表名: wip.wip_shop_floor_status_codes说明: 场地状态表shop_floor_status_code varchar2(10) 场地状态organization_id number 组织description varchar2(240) 描述disable_date date 失效日期status_move_flag number 状态移动标志wip.wip_move_transactions(离散作业工序移动交易) 表名: wip.wip_move_transactions说明: 离散作业工序移动交易transaction_id number 交易代码group_id number 组号source_code varchar2(30) 资源source_line_id number 资源行号organization_id number 组织代码wip_entity_id number 任务令内码line_id number 行号primary_item_id number 加工件内码transaction_date date 交易时间acct_period_id number 会计周期fm_operation_seq_num number 从工序号fm_operation_code varchar2(4) 从工序fm_department_id number 从部门fm_intraoperation_step_type numberto_operation_seq_num number 到工序号to_operation_code varchar2(4) 到工序to_department_id number 到部门to_intraoperation_step_type numbertransaction_quantity number 交易数量transaction_uom varchar2(3) 交易单位primary_quantity number 基本数量primary_uom varchar2(3) 基本单位scrap_account_id number 报废记帐标识号reason_id number 原因标识号reference varchar2(240) 参考wip.wip_so_allocations(分配表)表名：wip.wip_so_allocations说明: 分配表allocation_id number 分配标识码wip_entity_id number 任务令内码organization_id number 组织代码demand_source_header_id number 需求源头标识码demand_source_line varchar2(30) 需求源行号user_line_num varchar2(30) 用户栏目号demand_source_delivery varchar2(30) 需求源投递号user_delivery varchar2(30) 用户投递号quantity_allocated number 已分配数量quantity_completed number 已完成数量demand_class varchar2(30) 需求类别wip.wip_valid_intraoperation_steps(有效的进入工序步骤)表名: wip.wip_valid_intraoperation_steps说明: 有效的进入工序步骤organization_id number 组织代码record_creator varchar2(6) 记录创建者(system/user)step_lookup_type number 步骤类型last_update_date date 最后更改日期step_meaning varchar2(10) 步骤含义bom.bom_bill_of_materials(bom清单父项目)bom模块常用表结构表名: bom.bom_bill_of_materials说明: bom清单父项目bill_sequence_id number 清单序号（关键字）assembly_item_id number 装配件内码organization_id number 组织代码assembly_type number 装配类别specfiic_assembly_comment varchar2(240) 注释（装配件状态p、r等）common_organization_id number 公共组织common_bill_sequence_id number 公共序号common_assembly_item_id number 公共项目内码bom.bom_inventory_components(bom清单构成项目)表名：bom.bom_inventory_components说明：bom清单构成项目component_sequence_id number 构件序号bill_sequence_id number 清单序号operation_seq_num number 操作序列号component_item_id numberitem_num number 项目序列号component_quantity number 构件数量component_yield_factor number 产出因子effectivity_date date 生效日期disable_date date 失效日期change_notice varchar2(10) 更改注释(eco更改号)planning_factor number 计划百分比quantity_related number 相关数量so_basis numberoptional number 是否可选(1.是;2.否)mutually_exclusive_options number 互斥标识(1.是;2.否)wip_supply_type number 车间供应类型(1.推式2.装配拉式3.操作拉式4.大量5.供应商6.虚拟)supply_subinventory 供应子库存supply_locator_id 供应货位idbom_item_type number 清单项目类型(1.模型2.选项类3.计划中4.标准) include_on_ship_docs number 包含在发运文档中(1.是;2.否)required_for_revenue number 需要进款(1.是;2.否)required_to_ship number 需要发运(1.是;2.否)shipping allowed number 搬运允许(1.是;2.否)include_in_cost_rollup number 计入成本累加中(1.是;2.否)check_atp number atp检查(1.是;2.否)bom.bom_assembly_comments(装配件状态表)表名：bom.bom_assembly_comments说明：装配件状态表bill_sequence_id number 清单序号standard_remarks_designator varchar2(10) 状态标志(r,p,d_r等)bom.bom_standard_comments(标准注释表(状态说明表)) 表名: bom.bom_standard_comments说明: 标准注释表(状态说明表)comment_code varchar2(10) 注释代码(状态代码) organization_id number 组织代码comment_text varchar2(240) 注释说明(状态说明)bom.bom_calendars(日历种类表)表名: bom.bom_calendars说明: 日历种类表calendar_code varchar2(10) 日历代码quarterly_calendar_type number 季度日历类型calendar_start_date date 日历启用日期calendar_end_date date 日历截止日期description varchar2(240) 描述bom.bom_calendar_dates(工作日历表)表名: bom.bom_calendar_dates说明: 工作日历表calendar_code varcahr2(10) 日历代码prior_date date 前一天calendar_date date 当日(当与前,后日期均相同时为工作日) next_date date 后一天prior_seq_num number 前一天序列号seq_num number 当日序序列号(非工作日为空)next_seq_num number 后一天序列号exception_set_id number 例外集代码bom.bom_calendar_exceptions(日历例外信息)表名: bom.bom_calendar_exceptions说明: 日历例外信息calendar_code varchar2(10) 日历代码exception_set_id number 例外集代码exception_date date 例外日期exception_type nubmer 例外类别bom.bom_calendar_shifts(倒班表)表名: bom.bom_calendar_shifts说明: 倒班表calendar_code varcahr2(10) 日历代码shift_num number 班次description varchar2(240) 描述bom.bom_shift_dates(轮班表)表名: bom.bom_shift_dates说明: 轮班表calendar_code varchar2(10) 日历代码exception_set_id number 例外集代码shift_num number 倒班序号shift_date date 倒班日期seq_num number 倒班序号next_seq_num number 下一班序号prior_seq_num number 上一班序号next_date date 下一次倒班日期prior_date date 上一次倒班日期bom.bom_cal_week_start_dates(星期开始日期) 表名: bom.bom_cal_week_start_dates说明: 星期开始日期calendar_code varchar2(10) 日历代码exception_set_id number 例外集代码seq_num number 序号week_start_date date 周开始日期prior_date date 上周开始日期next_date date 下周开始日期bom.bom_period_start_dates(周期开始日期)表名: bom.bom_period_start_dates说明: 周期开始日期calendar_code varchar2(10) 日历代码exception_set_id number 例外集代码period_start_date date 周期开始日期period_sequence_num number 周期序号period_name varchar2(3) 周期名称(月的三位英文缩写) next_date date 下一周期开始日期prior_date date 上一周期开始日期bom.bom_workday_patterns(工作日模式表)表名: bom.bom_workday_patterns说明: 工作日模式表calendar_code varchar2(10) 日历代码shift_num number 班次seq_num number 模式序号days_on number 工作天数days_off number 非工作天数description varchar2(240) 描述(大周/小周)bom.bom_exception_sets(bom例外集表)表名: bom.bom_exception_sets说明: bom例外集表exception_set_id number 例外集代码exception_set_name varchar2(10) 例外集名称description varchar2(240) 描述表内容:1 主要主要例外集2 hw_wdces 华为日历异常集3 mbc_wdces 莫贝克日历异常集-1 虚拟 10sc 兼容的空数据bom.cst_item_costs(项目成本表)表名：bom.cst_item_costs说明：项目成本表organization_id number 组织代码inventory_item_id number 项目内码cost_type_id number 成本类型item_cost number 项目成本material_cost number 物料成本resource_cost number 资源成本unburdended_cost number 不分摊成本burden_cost number 分摊成本inventory_asset_flag number 资产项目lot_size number 批量大小based_on_rollup_flag numbershrinkage_rate number 收缩比例defaulted_flag numberbom.cst_cost_types(成本类型表)表名: bom.cst_cost_types说明: 成本类型表cost_type_id number 成本类型代码cost_type varchar2(10) 成本类型description varchar2(240) 说明costing_method_type number 成本合计方法代码(1.2.) disable_date date 失效日期本表内容如下:cost_type cost_type_id description冻结 1 冻结标准成本类型平均 2 平均成本类型等待 3 等待标准成本类型标准成本 1000 标准成本实际成本 1001 实际成本新标准成本 1002 新标准成本bom.cst_item_cost_details(项目成本明细表)表名: bom.cst_item_cost_details说明: 项目成本明细表organization_id number 组织代码inventory_item_id number 项目内码item_cost number 项目成本cost_type_id number 成本类型department_id number 部门代码cost_element_id number 成本要素类型代码last_update_date number 最后更新日期operation_sequence_id number 操作序列代码operation_seq_num number 操作序列号level_type number 级别类型resource_seq_num number 资源序列号resource_id number 资源代码resource_rate number 资源比率usage_rate_or_amount number 利用率或金额basis_type number 基础类型basis_resource_id number 基础资源代码basis_factor number 基础因子net_yield_or_shrinkage_factor number 净产出或收缩比rollup_source_type numberbom.cst_cost_elements(成本要素代码表)表名: bom.cst_cost_elements说明: 成本要素代码表cost_element_id number 成本要素代码cost_element varchar2(50) 成本要素说明内容:1 物料的2 物料制造费3 资源4 外部处理5 制造费bom.cst_elemental_costs(项目要素成本)表名: bom.cst_elemental_costs说明: 项目要素成本cost_update_id number 成本更新代码organization_id number 组织代码inventory_item_id number 项目内码cost_element_id number 要素代码last_update_date date 最后更新日期standard_cost number 标准成本bom.cst_resource_costs(资源成本)表名: bom.cst_resource_costs说明: 资源成本resource_id number 资源代码cost_type_id number 成本类型organization_id number 组织代码resource_rate number 资源费率bom.cst_standard_costs(项目标准成本表)表名: bom.cst_standard_costs说明: 项目标准成本表cost_update_id number 成本更新代码inventory_item_id number 项目内码organization_id number 组织代码standard_cost_revision_date date 标准成本版本日期standard_cost number 标准成本inventory_adjustment_quantity number 库存调节数量。
Oracle ERP INV 模块8个重要表结构_HR_ALL_ORGANIZATION_UNITS
ATTRIBUTE8 VARCHAR2(150),
ATTRIBUTE9 VARCHAR2(150),
ATTRIBUTE10 VARCHAR2(150),
-- Create table
create table HR.HR_ALL_ORGANIZATION_UNITS
(
ORGANIZATION_ID NUMBER(15) not null,
BUSINESS_GROUP_ID NUMBER(15) not null,
pctincrease 0
);
create index HR.HR_ORGANIZATION_UNITS_FK4 on HR.HR_ALL_ORGANIZATION_UNITS (SOFT_CODING_KEYFLEX_ID)
tablespace APPS_TS_TX_IDX
ATTRIBUTE3 VARCHAR2(150),
ATTRIBUTE4 VARCHAR2(150),
ATTRIBUTE5 VARCHAR2(150),
ATTRIBUTE6 VARCHAR2(150),
-- Create/Recreate indexes
create index HR.HR_ORGANIORGANIZATION_UNITS (BUSINESS_GROUP_ID)
tablespace APPS_TS_TX_IDX
pctfree 0
initrans 11
maxtrans 255
storage
(
initial 128K
next 128K
minextents 1
{选}Oracle_ERP_库存管理INV_8个表结构 ln
Oracle_ERP_库存管理INV_8个表结构下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_TRANSACTION_TYPES(TRANSACTION_TYPE_ID NUMBER not null,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null,CREATION_DATE DATE not null,CREATED_BY NUMBER not null,TRANSACTION_TYPE_NAME VARCHAR2(80) not null, DESCRIPTION VARCHAR2(240),TRANSACTION_ACTION_ID NUMBER not null, TRANSACTION_SOURCE_TYPE_ID NUMBER not null, SHORTAGE_MSG_BACKGROUND_FLAG VARCHAR2(1), SHORTAGE_MSG_ONLINE_FLAG VARCHAR2(1), DISABLE_DATE DATE,USER_DEFINED_FLAG VARCHAR2(1) not null, ATTRIBUTE1 VARCHAR2(150),ATTRIBUTE2 VARCHAR2(150),ATTRIBUTE3 VARCHAR2(150),ATTRIBUTE4 VARCHAR2(150),ATTRIBUTE5 VARCHAR2(150),ATTRIBUTE6 VARCHAR2(150),ATTRIBUTE7 VARCHAR2(150),ATTRIBUTE8 VARCHAR2(150),ATTRIBUTE9 VARCHAR2(150),ATTRIBUTE10 VARCHAR2(150),ATTRIBUTE11 VARCHAR2(150),ATTRIBUTE12 VARCHAR2(150),ATTRIBUTE13 VARCHAR2(150),ATTRIBUTE14 VARCHAR2(150),ATTRIBUTE15 VARCHAR2(150),ATTRIBUTE_CATEGORY VARCHAR2(30),TYPE_CLASS NUMBER,STATUS_CONTROL_FLAG NUMBER)tablespace APPS_TS_SEEDpctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate index INV.MTL_TRANSACTION_TYPES_N1 onINV.MTL_TRANSACTION_TYPES (TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID)tablespace APPS_TS_SEEDpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create unique index INV.MTL_TRANSACTION_TYPES_U1 onINV.MTL_TRANSACTION_TYPES (TRANSACTION_TYPE_ID) tablespace APPS_TS_SEEDpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onINV.MTL_TRANSACTION_TYPES to APPS with grant option;grant select on INV.MTL_TRANSACTION_TYPES to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_SYSTEM_ITEMS_B (INVENTORY_ITEM_ID NUMBER not null, ORGANIZATION_ID NUMBER not null, LAST_UPDATE_DATE DATE not null, LAST_UPDATED_BY NUMBER not null, CREATION_DATE DATE not null, CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER, SUMMARY_FLAG VARCHAR2(1) not null, ENABLED_FLAG VARCHAR2(1) not null,START_DATE_ACTIVE DATE,END_DATE_ACTIVE DATE,DESCRIPTION VARCHAR2(240),BUYER_ID NUMBER(9),ACCOUNTING_RULE_ID NUMBER, INVOICING_RULE_ID NUMBER, SEGMENT1 VARCHAR2(40),SEGMENT2 VARCHAR2(40),SEGMENT3 VARCHAR2(40),SEGMENT4 VARCHAR2(40),SEGMENT5 VARCHAR2(40),SEGMENT6 VARCHAR2(40),SEGMENT7 VARCHAR2(40),SEGMENT8 VARCHAR2(40),SEGMENT9 VARCHAR2(40),SEGMENT10 VARCHAR2(40),SEGMENT11 VARCHAR2(40),SEGMENT12 VARCHAR2(40),SEGMENT13 VARCHAR2(40),SEGMENT14 VARCHAR2(40),SEGMENT15 VARCHAR2(40),SEGMENT16 VARCHAR2(40),SEGMENT17 VARCHAR2(40),SEGMENT18 VARCHAR2(40),SEGMENT19 VARCHAR2(40),SEGMENT20 VARCHAR2(40),ATTRIBUTE_CATEGORY VARCHAR2(30),ATTRIBUTE1 VARCHAR2(240),ATTRIBUTE2 VARCHAR2(240),ATTRIBUTE3 VARCHAR2(240),ATTRIBUTE4 VARCHAR2(240),ATTRIBUTE5 VARCHAR2(240),ATTRIBUTE6 VARCHAR2(240),ATTRIBUTE7 VARCHAR2(240),ATTRIBUTE8 VARCHAR2(240),ATTRIBUTE9 VARCHAR2(240),ATTRIBUTE10 VARCHAR2(240),ATTRIBUTE11 VARCHAR2(240),ATTRIBUTE12 VARCHAR2(240),ATTRIBUTE13 VARCHAR2(240),ATTRIBUTE14 VARCHAR2(240),ATTRIBUTE15 VARCHAR2(240),PURCHASING_ITEM_FLAG VARCHAR2(1) not null, SHIPPABLE_ITEM_FLAG VARCHAR2(1) not null,CUSTOMER_ORDER_FLAG VARCHAR2(1) not null,INTERNAL_ORDER_FLAG VARCHAR2(1) not null,SERVICE_ITEM_FLAG VARCHAR2(1) not null,INVENTORY_ITEM_FLAG VARCHAR2(1) not null,ENG_ITEM_FLAG VARCHAR2(1) not null,INVENTORY_ASSET_FLAG VARCHAR2(1) not null, PURCHASING_ENABLED_FLAG VARCHAR2(1) not null, CUSTOMER_ORDER_ENABLED_FLAG VARCHAR2(1) not null, INTERNAL_ORDER_ENABLED_FLAG VARCHAR2(1) not null, SO_TRANSACTIONS_FLAG VARCHAR2(1) not null,MTL_TRANSACTIONS_ENABLED_FLAG VARCHAR2(1) not null, STOCK_ENABLED_FLAG VARCHAR2(1) not null,BOM_ENABLED_FLAG VARCHAR2(1) not null,BUILD_IN_WIP_FLAG VARCHAR2(1) not null,REVISION_QTY_CONTROL_CODE NUMBER,ITEM_CATALOG_GROUP_ID NUMBER,CATALOG_STATUS_FLAG VARCHAR2(1),RETURNABLE_FLAG VARCHAR2(1),DEFAULT_SHIPPING_ORG NUMBER,COLLATERAL_FLAG VARCHAR2(1),TAXABLE_FLAG VARCHAR2(1),QTY_RCV_EXCEPTION_CODE VARCHAR2(25),ALLOW_ITEM_DESC_UPDATE_FLAG VARCHAR2(1),INSPECTION_REQUIRED_FLAG VARCHAR2(1), RECEIPT_REQUIRED_FLAG VARCHAR2(1),MARKET_PRICE NUMBER,HAZARD_CLASS_ID NUMBER,RFQ_REQUIRED_FLAG VARCHAR2(1),QTY_RCV_TOLERANCE NUMBER,LIST_PRICE_PER_UNIT NUMBER,UN_NUMBER_ID NUMBER,PRICE_TOLERANCE_PERCENT NUMBER,ASSET_CATEGORY_ID NUMBER,ROUNDING_FACTOR NUMBER,UNIT_OF_ISSUE VARCHAR2(25),ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2(25), ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2(1), ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2(1), ALLOW_EXPRESS_DELIVERY_FLAG VARCHAR2(1), DAYS_EARLY_RECEIPT_ALLOWED NUMBER,DAYS_LATE_RECEIPT_ALLOWED NUMBER,RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2(25), RECEIVING_ROUTING_ID NUMBER,INVOICE_CLOSE_TOLERANCE NUMBER,RECEIVE_CLOSE_TOLERANCE NUMBER,AUTO_LOT_ALPHA_PREFIX VARCHAR2(30),START_AUTO_LOT_NUMBER VARCHAR2(30),LOT_CONTROL_CODE NUMBER,SHELF_LIFE_CODE NUMBER,SHELF_LIFE_DAYS NUMBER,SERIAL_NUMBER_CONTROL_CODE NUMBER,START_AUTO_SERIAL_NUMBER VARCHAR2(30), AUTO_SERIAL_ALPHA_PREFIX VARCHAR2(30), SOURCE_TYPE NUMBER,SOURCE_ORGANIZATION_ID NUMBER,SOURCE_SUBINVENTORY VARCHAR2(10),EXPENSE_ACCOUNT NUMBER,ENCUMBRANCE_ACCOUNT NUMBER,RESTRICT_SUBINVENTORIES_CODE NUMBER,UNIT_WEIGHT NUMBER,WEIGHT_UOM_CODE VARCHAR2(3),VOLUME_UOM_CODE VARCHAR2(3),UNIT_VOLUME NUMBER,RESTRICT_LOCATORS_CODE NUMBER,LOCATION_CONTROL_CODE NUMBER,SHRINKAGE_RATE NUMBER,ACCEPTABLE_EARLY_DAYS NUMBER,PLANNING_TIME_FENCE_CODE NUMBER,DEMAND_TIME_FENCE_CODE NUMBER,LEAD_TIME_LOT_SIZE NUMBER,STD_LOT_SIZE NUMBER,CUM_MANUFACTURING_LEAD_TIME NUMBER, OVERRUN_PERCENTAGE NUMBER,MRP_CALCULATE_ATP_FLAG VARCHAR2(1), ACCEPTABLE_RATE_INCREASE NUMBER, ACCEPTABLE_RATE_DECREASE NUMBER, CUMULATIVE_TOTAL_LEAD_TIME NUMBER, PLANNING_TIME_FENCE_DAYS NUMBER,DEMAND_TIME_FENCE_DAYS NUMBER,END_ASSEMBLY_PEGGING_FLAG VARCHAR2(1), REPETITIVE_PLANNING_FLAG VARCHAR2(1), PLANNING_EXCEPTION_SET VARCHAR2(10),BOM_ITEM_TYPE NUMBER not null,PICK_COMPONENTS_FLAG VARCHAR2(1) not null, REPLENISH_TO_ORDER_FLAG VARCHAR2(1) not null, BASE_ITEM_ID NUMBER,ATP_COMPONENTS_FLAG VARCHAR2(1) not null,ATP_FLAG VARCHAR2(1) not null,FIXED_LEAD_TIME NUMBER,VARIABLE_LEAD_TIME NUMBER,WIP_SUPPLY_LOCATOR_ID NUMBER,WIP_SUPPLY_TYPE NUMBER,WIP_SUPPLY_SUBINVENTORY VARCHAR2(10),PRIMARY_UOM_CODE VARCHAR2(3),PRIMARY_UNIT_OF_MEASURE VARCHAR2(25), ALLOWED_UNITS_LOOKUP_CODE NUMBER,COST_OF_SALES_ACCOUNT NUMBER,SALES_ACCOUNT NUMBER,DEFAULT_INCLUDE_IN_ROLLUP_FLAG VARCHAR2(1), INVENTORY_ITEM_STATUS_CODE VARCHAR2(10) not null, INVENTORY_PLANNING_CODE NUMBER,PLANNER_CODE VARCHAR2(10),PLANNING_MAKE_BUY_CODE NUMBER,FIXED_LOT_MULTIPLIER NUMBER,ROUNDING_CONTROL_TYPE NUMBER,CARRYING_COST NUMBER,POSTPROCESSING_LEAD_TIME NUMBER, PREPROCESSING_LEAD_TIME NUMBER,FULL_LEAD_TIME NUMBER,ORDER_COST NUMBER,MRP_SAFETY_STOCK_PERCENT NUMBER,MRP_SAFETY_STOCK_CODE NUMBER,MIN_MINMAX_QUANTITY NUMBER,MAX_MINMAX_QUANTITY NUMBER,MINIMUM_ORDER_QUANTITY NUMBER,FIXED_ORDER_QUANTITY NUMBER,FIXED_DAYS_SUPPLY NUMBER,MAXIMUM_ORDER_QUANTITY NUMBER,ATP_RULE_ID NUMBER,PICKING_RULE_ID NUMBER,RESERVABLE_TYPE NUMBER,POSITIVE_MEASUREMENT_ERROR NUMBER,NEGATIVE_MEASUREMENT_ERROR NUMBER, ENGINEERING_ECN_CODE VARCHAR2(50),ENGINEERING_ITEM_ID NUMBER,ENGINEERING_DATE DATE,SERVICE_STARTING_DELAY NUMBER,VENDOR_WARRANTY_FLAG VARCHAR2(1) not null, SERVICEABLE_COMPONENT_FLAG VARCHAR2(1), SERVICEABLE_PRODUCT_FLAG VARCHAR2(1) not null,BASE_WARRANTY_SERVICE_ID NUMBER,PAYMENT_TERMS_ID NUMBER,PREVENTIVE_MAINTENANCE_FLAG VARCHAR2(1), PRIMARY_SPECIALIST_ID NUMBER,SECONDARY_SPECIALIST_ID NUMBER,SERVICEABLE_ITEM_CLASS_ID NUMBER,TIME_BILLABLE_FLAG VARCHAR2(1),MATERIAL_BILLABLE_FLAG VARCHAR2(30),EXPENSE_BILLABLE_FLAG VARCHAR2(1),PRORATE_SERVICE_FLAG VARCHAR2(1),COVERAGE_SCHEDULE_ID NUMBER,SERVICE_DURATION_PERIOD_CODE VARCHAR2(10), SERVICE_DURATION NUMBER,WARRANTY_VENDOR_ID NUMBER,MAX_WARRANTY_AMOUNT NUMBER,RESPONSE_TIME_PERIOD_CODE VARCHAR2(30), RESPONSE_TIME_VALUE NUMBER,NEW_REVISION_CODE VARCHAR2(30),INVOICEABLE_ITEM_FLAG VARCHAR2(1) not null,TAX_CODE VARCHAR2(50),INVOICE_ENABLED_FLAG VARCHAR2(1) not null,MUST_USE_APPROVED_VENDOR_FLAG VARCHAR2(1) not null, REQUEST_ID NUMBER,PROGRAM_APPLICATION_ID NUMBER,PROGRAM_ID NUMBER,PROGRAM_UPDATE_DATE DATE,OUTSIDE_OPERATION_FLAG VARCHAR2(1) not null, OUTSIDE_OPERATION_UOM_TYPE VARCHAR2(25),SAFETY_STOCK_BUCKET_DAYS NUMBER,AUTO_REDUCE_MPS NUMBER(22),COSTING_ENABLED_FLAG VARCHAR2(1) not null,AUTO_CREATED_CONFIG_FLAG VARCHAR2(1) not null, CYCLE_COUNT_ENABLED_FLAG VARCHAR2(1) not null, ITEM_TYPE VARCHAR2(30),MODEL_CONFIG_CLAUSE_NAME VARCHAR2(10), SHIP_MODEL_COMPLETE_FLAG VARCHAR2(1),MRP_PLANNING_CODE NUMBER,RETURN_INSPECTION_REQUIREMENT NUMBER,ATO_FORECAST_CONTROL NUMBER,RELEASE_TIME_FENCE_CODE NUMBER,RELEASE_TIME_FENCE_DAYS NUMBER,CONTAINER_ITEM_FLAG VARCHAR2(1),VEHICLE_ITEM_FLAG VARCHAR2(1),MAXIMUM_LOAD_WEIGHT NUMBER,MINIMUM_FILL_PERCENT NUMBER,CONTAINER_TYPE_CODE VARCHAR2(30),INTERNAL_VOLUME NUMBER,WH_UPDATE_DATE DATE,PRODUCT_FAMILY_ITEM_ID NUMBER,GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(150), GLOBAL_ATTRIBUTE1 VARCHAR2(150),GLOBAL_ATTRIBUTE2 VARCHAR2(150),GLOBAL_ATTRIBUTE3 VARCHAR2(150),GLOBAL_ATTRIBUTE4 VARCHAR2(150),GLOBAL_ATTRIBUTE5 VARCHAR2(150),GLOBAL_ATTRIBUTE6 VARCHAR2(150),GLOBAL_ATTRIBUTE7 VARCHAR2(150),GLOBAL_ATTRIBUTE8 VARCHAR2(150),GLOBAL_ATTRIBUTE9 VARCHAR2(150),GLOBAL_ATTRIBUTE10 VARCHAR2(150), PURCHASING_TAX_CODE VARCHAR2(50), OVERCOMPLETION_TOLERANCE_TYPE NUMBER, OVERCOMPLETION_TOLERANCE_VALUE NUMBER, EFFECTIVITY_CONTROL NUMBER,CHECK_SHORTAGES_FLAG VARCHAR2(1),OVER_SHIPMENT_TOLERANCE NUMBER,UNDER_SHIPMENT_TOLERANCE NUMBER,OVER_RETURN_TOLERANCE NUMBER,UNDER_RETURN_TOLERANCE NUMBER, EQUIPMENT_TYPE NUMBER,RECOVERED_PART_DISP_CODE VARCHAR2(30), DEFECT_TRACKING_ON_FLAG VARCHAR2(1),USAGE_ITEM_FLAG VARCHAR2(1),EVENT_FLAG VARCHAR2(1),ELECTRONIC_FLAG VARCHAR2(1), DOWNLOADABLE_FLAG VARCHAR2(1),VOL_DISCOUNT_EXEMPT_FLAG VARCHAR2(1),COUPON_EXEMPT_FLAG VARCHAR2(1),COMMS_NL_TRACKABLE_FLAG VARCHAR2(1), ASSET_CREATION_CODE VARCHAR2(30), COMMS_ACTIVATION_REQD_FLAG VARCHAR2(1), ORDERABLE_ON_WEB_FLAG VARCHAR2(1), BACK_ORDERABLE_FLAG VARCHAR2(1),WEB_STATUS VARCHAR2(30),INDIVISIBLE_FLAG VARCHAR2(1),DIMENSION_UOM_CODE VARCHAR2(3),UNIT_LENGTH NUMBER,UNIT_WIDTH NUMBER,UNIT_HEIGHT NUMBER,BULK_PICKED_FLAG VARCHAR2(1),LOT_STATUS_ENABLED VARCHAR2(1),DEFAULT_LOT_STATUS_ID NUMBER,SERIAL_STATUS_ENABLED VARCHAR2(1), DEFAULT_SERIAL_STATUS_ID NUMBER,LOT_SPLIT_ENABLED VARCHAR2(1),LOT_MERGE_ENABLED VARCHAR2(1), INVENTORY_CARRY_PENALTY NUMBER, OPERATION_SLACK_PENALTY NUMBER, FINANCING_ALLOWED_FLAG VARCHAR2(1),EAM_ITEM_TYPE NUMBER,EAM_ACTIVITY_TYPE_CODE VARCHAR2(30),EAM_ACTIVITY_CAUSE_CODE VARCHAR2(30), EAM_ACT_NOTIFICATION_FLAG VARCHAR2(1), EAM_ACT_SHUTDOWN_STATUS VARCHAR2(30), DUAL_UOM_CONTROL NUMBER,SECONDARY_UOM_CODE VARCHAR2(3),DUAL_UOM_DEVIATION_HIGH NUMBER,DUAL_UOM_DEVIATION_LOW NUMBER, CONTRACT_ITEM_TYPE_CODE VARCHAR2(30), SUBSCRIPTION_DEPEND_FLAG VARCHAR2(1), SERV_REQ_ENABLED_CODE VARCHAR2(30), SERV_BILLING_ENABLED_FLAG VARCHAR2(1), SERV_IMPORTANCE_LEVEL NUMBER,PLANNED_INV_POINT_FLAG VARCHAR2(1),LOT_TRANSLATE_ENABLED VARCHAR2(1), DEFAULT_SO_SOURCE_TYPE VARCHAR2(30), CREATE_SUPPLY_FLAG VARCHAR2(1), SUBSTITUTION_WINDOW_CODE NUMBER, SUBSTITUTION_WINDOW_DAYS NUMBER,IB_ITEM_INSTANCE_CLASS VARCHAR2(30), CONFIG_MODEL_TYPE VARCHAR2(30),LOT_SUBSTITUTION_ENABLED VARCHAR2(1), MINIMUM_LICENSE_QUANTITY NUMBER,EAM_ACTIVITY_SOURCE_CODE VARCHAR2(30), LIFECYCLE_ID NUMBER,CURRENT_PHASE_ID NUMBER,OBJECT_VERSION_NUMBER NUMBER(9), TRACKING_QUANTITY_IND VARCHAR2(30), ONT_PRICING_QTY_SOURCE VARCHAR2(30), SECONDARY_DEFAULT_IND VARCHAR2(30), OPTION_SPECIFIC_SOURCED NUMBER, APPROVAL_STATUS VARCHAR2(30),VMI_MINIMUM_UNITS NUMBER,VMI_MINIMUM_DAYS NUMBER,VMI_MAXIMUM_UNITS NUMBER,VMI_MAXIMUM_DAYS NUMBER,VMI_FIXED_ORDER_QUANTITY NUMBER,SO_AUTHORIZATION_FLAG NUMBER, CONSIGNED_FLAG NUMBER,ASN_AUTOEXPIRE_FLAG NUMBER,VMI_FORECAST_TYPE NUMBER,FORECAST_HORIZON NUMBER,EXCLUDE_FROM_BUDGET_FLAG NUMBER, DAYS_TGT_INV_SUPPLY NUMBER,DAYS_TGT_INV_WINDOW NUMBER,DAYS_MAX_INV_SUPPLY NUMBER,DAYS_MAX_INV_WINDOW NUMBER,DRP_PLANNED_FLAG NUMBER,CRITICAL_COMPONENT_FLAG NUMBER, CONTINOUS_TRANSFER NUMBER, CONVERGENCE NUMBER,DIVERGENCE NUMBER,CONFIG_ORGS VARCHAR2(30),CONFIG_MATCH VARCHAR2(30))tablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate index INV.MTL_SYSTEM_ITEMS_B_N1 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, SEGMENT1) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N10 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, PLANNER_CODE) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N11 onINV.MTL_SYSTEM_ITEMS_B (WEB_STATUS, ORGANIZATION_ID) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N12 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID,CUSTOMER_ORDER_ENABLED_FLAG, SERVICE_ITEM_FLAG, VENDOR_WARRANTY_FLAG)tablespace APPS_TS_TX_IDXinitrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N13 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID,WIP_SUPPLY_LOCATOR_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N14 onINV.MTL_SYSTEM_ITEMS_B (BASE_ITEM_ID, ORGANIZATION_ID) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N2 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, DESCRIPTION) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N3 onINV.MTL_SYSTEM_ITEMS_B (INVENTORY_ITEM_STATUS_CODE) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N4 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID,AUTO_CREATED_CONFIG_FLAG)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N5 onINV.MTL_SYSTEM_ITEMS_B (WH_UPDATE_DATE)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N6 onINV.MTL_SYSTEM_ITEMS_B (ITEM_CATALOG_GROUP_ID, CATALOG_STATUS_FLAG)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N7 onINV.MTL_SYSTEM_ITEMS_B (PRODUCT_FAMILY_ITEM_ID, ORGANIZATION_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N8 onINV.MTL_SYSTEM_ITEMS_B (COMMS_NL_TRACKABLE_FLAG, ORGANIZATION_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kmaxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N9 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, BUYER_ID) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create unique index INV.MTL_SYSTEM_ITEMS_B_U1 onINV.MTL_SYSTEM_ITEMS_B (INVENTORY_ITEM_ID, ORGANIZATION_ID) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onINV.MTL_SYSTEM_ITEMS_B to APPS with grant option;grant select on INV.MTL_SYSTEM_ITEMS_B to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table BOM.CST_COST_TYPES(COST_TYPE_ID NUMBER not null,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null, CREATION_DATE DATE not null,CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER, ORGANIZATION_ID NUMBER,COST_TYPE VARCHAR2(10) not null, DESCRIPTION VARCHAR2(240),COSTING_METHOD_TYPE NUMBER not null, FROZEN_STANDARD_FLAG NUMBER,DEFAULT_COST_TYPE_ID NUMBER not null, BOM_SNAPSHOT_FLAG NUMBER not null, ALTERNATE_BOM_DESIGNATOR VARCHAR2(10), ALLOW_UPDATES_FLAG NUMBER,PL_ELEMENT_FLAG NUMBER not null,PL_RESOURCE_FLAG NUMBER not null,PL_OPERATION_FLAG NUMBER not null,PL_ACTIVITY_FLAG NUMBER not null,DISABLE_DATE DATE,AVAILABLE_TO_ENG_FLAG NUMBER, COMPONENT_YIELD_FLAG NUMBER not null, ATTRIBUTE_CATEGORY VARCHAR2(30), ATTRIBUTE1 VARCHAR2(150),ATTRIBUTE2 VARCHAR2(150),ATTRIBUTE3 VARCHAR2(150),ATTRIBUTE4 VARCHAR2(150),ATTRIBUTE5 VARCHAR2(150),ATTRIBUTE6 VARCHAR2(150),ATTRIBUTE7 VARCHAR2(150),ATTRIBUTE8 VARCHAR2(150),ATTRIBUTE9 VARCHAR2(150),ATTRIBUTE10 VARCHAR2(150),ATTRIBUTE11 VARCHAR2(150),ATTRIBUTE12 VARCHAR2(150),ATTRIBUTE13 VARCHAR2(150),ATTRIBUTE14 VARCHAR2(150),ATTRIBUTE15 VARCHAR2(150),REQUEST_ID NUMBER,PROGRAM_APPLICATION_ID NUMBER,PROGRAM_ID NUMBER,PROGRAM_UPDATE_DATE DATE)tablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate unique index BOM.CST_COST_TYPES_U1 on BOM.CST_COST_TYPES (COST_TYPE_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create unique index BOM.CST_COST_TYPES_U2 on BOM.CST_COST_TYPES (COST_TYPE, ORGANIZATION_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onBOM.CST_COST_TYPES to APPS with grant option;grant select on BOM.CST_COST_TYPES to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table HR.HR_ALL_ORGANIZATION_UNITS (ORGANIZATION_ID NUMBER(15) not null, BUSINESS_GROUP_ID NUMBER(15) not null, COST_ALLOCATION_KEYFLEX_ID NUMBER(9), LOCATION_ID NUMBER(15),SOFT_CODING_KEYFLEX_ID NUMBER(15), DATE_FROM DATE not null,NAME VARCHAR2(240) not null,DATE_TO DATE,INTERNAL_EXTERNAL_FLAG VARCHAR2(30), INTERNAL_ADDRESS_LINE VARCHAR2(80), TYPE VARCHAR2(30),REQUEST_ID NUMBER(15),PROGRAM_APPLICATION_ID NUMBER(15), PROGRAM_ID NUMBER(15),PROGRAM_UPDATE_DATE DATE, ATTRIBUTE_CATEGORY VARCHAR2(30), ATTRIBUTE1 VARCHAR2(150),ATTRIBUTE2 VARCHAR2(150),ATTRIBUTE3 VARCHAR2(150),ATTRIBUTE4 VARCHAR2(150),ATTRIBUTE5 VARCHAR2(150),ATTRIBUTE6 VARCHAR2(150),ATTRIBUTE7 VARCHAR2(150),ATTRIBUTE8 VARCHAR2(150),ATTRIBUTE9 VARCHAR2(150),ATTRIBUTE10 VARCHAR2(150),ATTRIBUTE11 VARCHAR2(150),ATTRIBUTE12 VARCHAR2(150),ATTRIBUTE13 VARCHAR2(150),ATTRIBUTE14 VARCHAR2(150),ATTRIBUTE15 VARCHAR2(150),ATTRIBUTE16 VARCHAR2(150),ATTRIBUTE17 VARCHAR2(150),ATTRIBUTE18 VARCHAR2(150),ATTRIBUTE19 VARCHAR2(150),ATTRIBUTE20 VARCHAR2(150),LAST_UPDATE_DATE DATE,LAST_UPDATED_BY NUMBER(15),LAST_UPDATE_LOGIN NUMBER(15),CREATED_BY NUMBER(15),CREATION_DATE DATE,OBJECT_VERSION_NUMBER NUMBER(9),PARTY_ID NUMBER(15),COMMENTS LONG)tablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate primary, unique and foreign key constraints alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_PK primary key (ORGANIZATION_ID)using indextablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kmaxextents unlimitedpctincrease 0);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_UK2 unique (NAME, BUSINESS_GROUP_ID)using indextablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK1 foreign key(BUSINESS_GROUP_ID)references HR.HR_ALL_ORGANIZATION_UNITS (ORGANIZATION_ID); alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK2 foreign key(COST_ALLOCATION_KEYFLEX_ID)references HR.PAY_COST_ALLOCATION_KEYFLEX(COST_ALLOCATION_KEYFLEX_ID);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK3 foreign key (LOCATION_ID) references HR.HR_LOCATIONS_ALL (LOCATION_ID);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK4 foreign key(SOFT_CODING_KEYFLEX_ID)references HR.HR_ALL_ORGANIZATION_UNITS (ORGANIZATION_ID);-- Create/Recreate check constraintsalter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_OU_INTERNAL_EXTERNAL_FL_CHKcheck (INTERNAL_EXTERNAL_FLAG IN ('INT', 'EXT'));-- Create/Recreate indexescreate index HR.HR_ORGANIZATION_UNITS_FK1 onHR.HR_ALL_ORGANIZATION_UNITS (BUSINESS_GROUP_ID)tablespace APPS_TS_TX_IDXpctfree 0initrans 11storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index HR.HR_ORGANIZATION_UNITS_FK2 onHR.HR_ALL_ORGANIZATION_UNITS (COST_ALLOCATION_KEYFLEX_ID) tablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index HR.HR_ORGANIZATION_UNITS_FK3 onHR.HR_ALL_ORGANIZATION_UNITS (LOCATION_ID)tablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index HR.HR_ORGANIZATION_UNITS_FK4 onHR.HR_ALL_ORGANIZATION_UNITS (SOFT_CODING_KEYFLEX_ID) tablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onHR.HR_ALL_ORGANIZATION_UNITS to APPS with grant option; grant select on HR.HR_ALL_ORGANIZATION_UNITS to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_ONHAND_QUANTITIES_DETAIL(INVENTORY_ITEM_ID NUMBER not null,ORGANIZATION_ID NUMBER not null,DATE_RECEIVED DATE,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null,CREATION_DATE DATE not null,CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER,PRIMARY_TRANSACTION_QUANTITY NUMBER not null, SUBINVENTORY_CODE VARCHAR2(10) not null,REVISION VARCHAR2(3),LOCATOR_ID NUMBER,CREATE_TRANSACTION_ID NUMBER,UPDATE_TRANSACTION_ID NUMBER,LOT_NUMBER VARCHAR2(30),ORIG_DATE_RECEIVED DATE,COST_GROUP_ID NUMBER,CONTAINERIZED_FLAG NUMBER,PROJECT_ID NUMBER,TASK_ID NUMBER,ONHAND_QUANTITIES_ID NUMBER not null, ORGANIZATION_TYPE NUMBER not null,OWNING_ORGANIZATION_ID NUMBER not null,OWNING_TP_TYPE NUMBER not null,PLANNING_ORGANIZATION_ID NUMBER not null,PLANNING_TP_TYPE NUMBER not null,TRANSACTION_UOM_CODE VARCHAR2(3) not null, TRANSACTION_QUANTITY NUMBER not null,SECONDARY_UOM_CODE VARCHAR2(3),SECONDARY_TRANSACTION_QUANTITY NUMBER,IS_CONSIGNED NUMBER not null,LPN_ID NUMBER)tablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate index INV.MTL_ONHAND_QUANTITIES_N4 onINV.MTL_ONHAND_QUANTITIES_DETAIL (INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE,PRIMARY_TRANSACTION_QUANTITY)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_ONHAND_QUANTITIES_N5 onINV.MTL_ONHAND_QUANTITIES_DETAIL (ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID, LPN_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_ONHAND_QUANTITIES_N6 onINV.MTL_ONHAND_QUANTITIES_DETAIL (ORGANIZATION_ID, INVENTORY_ITEM_ID, COST_GROUP_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onINV.MTL_ONHAND_QUANTITIES_DETAIL to APPS with grant option;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_SECONDARY_INVENTORIES(SECONDARY_INVENTORY_NAME VARCHAR2(10) not null, ORGANIZATION_ID NUMBER not null,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null,CREATION_DATE DATE not null,CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER,DESCRIPTION VARCHAR2(50),DISABLE_DATE DATE,INVENTORY_ATP_CODE NUMBER not null, AVAILABILITY_TYPE NUMBER not null,RESERVABLE_TYPE NUMBER not null,LOCATOR_TYPE NUMBER,PICKING_ORDER NUMBER,MATERIAL_ACCOUNT NUMBER,MATERIAL_OVERHEAD_ACCOUNT NUMBER, RESOURCE_ACCOUNT NUMBER,OVERHEAD_ACCOUNT NUMBER,OUTSIDE_PROCESSING_ACCOUNT NUMBER, QUANTITY_TRACKED NUMBER not null,。
OracleERP表结构
表名: inv.mtl_uom_class_ 表名: inv.mtl_uom_class_conversions 说明: 单位类别换算 说明:
INVENTORY_ITEM_ID FROM_UNIT_OF_MEASURE FROM_UOM_CODE FROM_UOM_CLASS TO_UNIT_OF_MEASURE TO_UOM_CODE TO_UOM_CLASS CONVERSION_RATE DISABLE_DATE NUMBER VARCHAR2(25) VARCHAR2(3) VARCHAR2(10) VARCHAR2(25) VARCHAR2(3) VARCHAR2(10) NUMBER DATE
表名: inv.mtl_descr_element_ 表名: inv.mtl_descr_element_values 说明: 说明: 项目描述构成元素值
INVENTORY_ITEM_ID ELEMENT_NAME ELEMENT_SEQUENCE ELEMENT_VALUE DEFAULT_ELEMENT_FLAG NUMBER VARCHAR2(30) NUMBER VARCHAR2(30) VARCHAR2(1)
INVENTORY_ITEM_STATUS_CODE DESCRIPTION VARCHAR2(10) VARCHAR2(240)
表名: inv.mtl_picking_ 表名: inv.mtl_picking_rules 说明: 说明: 捡料规则表
PICKING_RULE_ID PICKING_RULE_NAME DESCRIPTION NUMBER VARCHAR2(30) VARCHAR2(50)
OracleERP各模块之间表关系
FND_FVQ: FND_FLEX_VALIDATION_QUALIFIERS FND_FVRL: FND_FLEX_VALIDATION_RULE_LINES
FND_VAT:FND_VALUE_ATTRIBUTE_TYPES
FND_FIRL:FND_FLEX_INCLUDE_RULE_LINES
FND_CIFS:FND_COMPILED_ID_FLEX_STRUCTS FND_SAT:FND_SEGMENT_ATTRIBUTE_TYPES
成本(COST)
总帐(GL)
总帐(GL)
总帐(GL)
总帐(GL)
应收(AR)
应收(AR)
应收(AR)
应付(AP)
应付(AP)
应付(AP)
固定资产(FA)
固定资产(FA)
固定资产(FA)
弹性域
表名缩写对照表
FND_IFS: FND_ID_FLEX_SEGMENTS
FND_SAV:FND_SEGMENT_ATTRIBUTE_VALUES
FND_CQP: FND_CONCURRENT_QUEUE_PARAMS
FND_CQ: FND_ONCURRENT_QUEUES
FND_CPP:FND_CONC_PROCESSOR_PROGRAMS
FND_CPS: FND_CONCURRENT_PROCESSORS FND_CQS: FND_CONCURRENT_QUEUE_SIZE
FND_RG: FND_REQUEST_GROUPS
FND_RSP: FND_REQUEST_SET_PROGRAMS
FND_RSA: FND_REQUEST_SET_PROGRAM_ARGS FND_RR:FND_RUN_REQUESTS
OracleERP表结构
常用视图表名：MTL_ONHAND_LOCATOR_V说明：库存数据视图列名类型含义INVENTORY_ITEM_ID NUMBER 项目内码ORGANIZATION_ID NUMBER 组织代码PADDED_CONCATENATED_SEGMENTS 物品编码REVISION VARCHAR2(3) 物品版本TOTAL QOH NUMBER 现有量SUBINVENTORY_CODE VARCHAR2(10) 子库名LOCATOR_ID NUMBER 货位内码-------------------------------------------------------INV模块常用表结构表名：inv.mtl_system_items说明：物料主表列名类型含义ORGANIZATION_ID NUMBER 组织代码INVENTORY_ITEM_ID NUMBER 项目内码SEGMENT1 VARCHAR2(40) 项目编码（外码）UNIT_OF_ISSUE 单位DESCRIPTION 项目说明ALLOWED_UNITS_LOOKUP_CODE 可否单位换算INVENTORY_ITEM_STATUS_CODE 项目状态ITEM_TYPE 项目类型PRIMARY_UNIT_OF_MEASURE 基本度量单位BASE_ITEM_ID 基础代码BOM_ENABLED_FLAG BOM使能标志(项目能否有清单)(Y/N) BOM_ITEM_TYPE BOM项目类型ENGINEERING_ECN_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 采购员代码ENCUMBRANCE_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_FACTOR A 取舍因子TAXABLE_FLAG 税收项目UNIT_OF_ISSUE 单位ALLOW_EXPRESS_DELIVERY_FLAG A 可以快递项目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_FLAG A 是否必须收据RECEIVE_CLOSE_TOLERANCE A 接收结束允许天数RECEIVING_ROUTING_ID 接收行程安排编码AUTO_SERIAL_ALPHA_PREFIX Starting Serial Prefix CYCLE_COUNT_ENABLED_FLAG 能否循环计算INVENTORY_ITEM_FLAG 是否为库存项目LOCATION_CONTROL_CODE 采购点控制代码LOT_CONTROL_CODE 是否有批量控制MTL_TRANSACTIONS_ENABLED_FLAG 可否交易POSITIVE_MEASUREMENT_ERROR Pos Measurement Error RESERVABLE_TYPE 是否要预留RESTRICT_LOCATORS_CODE 是否限制定位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 固定提前期FIXED_LOT_MULTIPLIER 固定批量大小FIXED_ORDER_QUANTITY 固定定单数INVENTORY_PLANNING_CODE 库存计划方法MAXIMUM_ORDER_QUANTITY 最大定单数MAX_MINMAX_QUANTITY Min-Max Maximum Quantity MINIMUM_ORDER_QUANTITY 最小定单数MIN_MINMAX_QUANTITY Min-Max Minimum Quantity MRP_SAFETY_STOCK_CODE 安全库存MRP_SAFETY_STOCK_PERCENT 安全库存百分比ORDER_COST 定单费用PLANNER_CODE 计划员属性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 制造或购买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_SUPPLY_LOCATOR_ID 离散作业库存地点WIP_SUPPLY_TYPE 离散作业供货类型ATP_COMPONENTS_FLAG 是否有ATP组成部件ATP_FLAG 是否为ATP项目ATP_RULE_ID ATP规则COLLATERAL_FLAG 是否为附属项目CUSTOMER_ORDER_FLAG 是否为定单项目DEFAULT_SHIPPING_ORG 运输组织代码INTERNAL_ORDER_ENABLED_FLAG 是否可以是内部定单INTERNAL_ORDER_FLAG 是否为内部定单PICKING_RULE_ID 库存规则PICK_COMPONENTS_FLAG 是否为可选部件REPLENISH_TO_ORDER_FLAG 是否为定单装配RETURNABLE_FLAG 是否可退回RETURN_INSPECTION_REQUIREMENT RMA Inspection Status SHIPPABLE_ITEM_FLAG 是否为运输项目SHIP_MODEL_COMPLETE_FLAG 运送是否完成SO_TRANSACTIONS_FLAG 是否可交易ACCOUNTING_RULE_ID 会计规则INVOICEABLE_ITEM_FLAG 是否为需发票项目INVOICE_ENABLED_FLAG 是否具有发票INVOICING_RULE_ID 发票规则PAYMENT_TERMS_ID 付款期限SALES_ACCOUNT 销售帐目TAX_CODE 税收代码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 计划例外设置ROUNDING_CONTROL_TYPE 四舍五入控制FIXED_LEAD_TIME 固定提前期POSTPROCESSING_LEAD_TIME 后处理提前期WIP_SUPPLY_SUBINVENTORY 离散作业子库存CUSTOMER_ORDER_ENABLED_FLAG 是否是销售定单ACCEPTABLE_RATE_INCREASE 可接受的增加率---------------------------------------------------------OE模块常用表结构so_headers_all；so_lines_all；表名:ONT.OE_order_headers_all说明:订单头HEADER_ID NUMBER 订单头标识码ORG_ID NUMBER OU IDORDER_TYPE_ID NUMBER 订单类型IDORDER_NUMBER NUMBER 订单编号ORDERED_DATE DATE 定购日期REQUEST_DATE DATE 客户要求发货日期DEMAND_CLASS_CODE VARCHAR2(30) 需求分类Code PRICE_LIST_ID NUMBER 价目表IDTRANSACTIONAL_CURR_CODE VARCHAR2(15) 币种CUST_PO_NUMBER VARCHAR2(50) 合同号INVOICING_RULE_ID NUMBER(15) 开票规则ID ACCOUNTING_RULE_ID NUMBER(15) 会计规则ID PAYMENT_TERM_ID NUMBER(15) 付款条件IDSHIPPING_METHOD_CODE VARCHAR2(30) 发运方法Code FOB_POINT_CODE VARCHAR2(30) FOB CodeFREIGHT_TERMS_CODE VARCHAR2(30) 运费条款Code SHIP_FROM_ORG_ID NUMBER 发货库存组织IDSHIP_TO_ORG_ID NUMBER 客户Account_IDINVOICE_TO_ORG_ID NUMBER 开票客户Account_ID SOLD_TO_CONTACT_ID NUMBER 经办人IDSHIP_TO_CONTACT_ID NUMBER 发货至联系人ID INVOICE_TO_CONTACT_ID NUMBER 开票至联系人ID CREATION_DATE DATE 输入日期CREATED_BY NUMBER 输入人IDLAST_UPDATED_BY NUMBER 更新人LAST_UPDATE_DATE DATE 更新日期LAST_UPDATE_LOGIN NUMBER 更新人用户ATTRIBUTE1 DATE 合同收到日期ATTRIBUTE2 DATE 客户要求到货日期ATTRIBUTE3 VARCHAR2(240) 到货视同验收ATTRIBUTE11 VARCHAR2(240) 客户行业分类Code ATTRIBUTE12 VARCHAR2(240) 合同文本金额ATTRIBUTE13 VARCHAR2(240) 是否需要客服到货确认ATTRIBUTE14 DATE 承诺核销日期CANCELLED_FLAG VARCHAR2(1) 是否取消OPEN_FLAG VARCHAR2(1) 是否未结BOOKED_FLAG VARCHAR2(1) 登记与否SALESREP_ID NUMBER(15) 销售员IDRETURN_REASON_CODE VARCHAR2(30) 退货原因Code SALES_CHANNEL_CODE VARCHAR2(30) 销售渠道Code ORDER_CATEGORY_CODE VARCHAR2(30) 订单类别SHIPPING_INSTRUCTIONS VARCHAR2(2000) 老合同号PACKING_INSTRUCTIONS VARCHAR2(2000) 包装指令FLOW_STATUS_CODE VARCHAR2(30) 工作流状态代码BOOKED_DATE DATE 下单日期-----------------------------------------------------表名: po.po_lines_all说明: 采购订单行PO_LINE_ID NUMBER 行标识码PO_HEADER_ID NUMBER 订单头标识码LINE_TYPE_ID NUMBER 行类型LINE_NUM NUMBER 行栏目ITEM_ID NUMBER 项目内码ITEM_REVISION VARCHAR2(3) 项目版本CATEGORY_ID NUMBER 归类标识码ITEM_DESCRIPTION VARCHAR2(240) 项目描述UNIT_MEAS_LOOKUP_CODE VARCHAR2(25) 单位QUANTITY_COMMITTED NUMBER 提交数量COMMITTED_AMOUNT NUMBER 提交金额ALLOW_PRICE_OVERRIDE_FLAG VARCHAR2(1) 价格佣金允许NOT_TO_EXCEED_PRICE NUMBER 不允许超过价格LIST_PRICE_PER_UNIT NUMBERUNIT_PRICE NUMBER 单价QUANTITY NUMBER 数量UN_NUMBER_ID NUMBER 货期标识码HAZARD_CLASS_ID NUMBER 风险类别标识码NOTE_TO_VENDOR VARCHAR2(240) 对供应商的说明FROM_HEADER_ID NUMBER 来源订单头号FROM_LINE_ID NUMBER 来源行号MIN_ORDER_QUANTITY NUMBER 最小订单数量MAX_ORDER_QUANTITY NUMBER 最大订单数量QTY_RCV_TOLERANCE NUMBER 可接收数量OVER_TOLERANCE_ERROR_FLAG VARCHAR2(25) 超差示错标志MARKET_PRICE NUMBER 市价UNORDERED_FLAG VARCHAR2(1) 不定货标志CLOSED_FLAG VARCHAR2(1) 关闭标志USER_HOLD_FLAG VARCHAR2(1)CANCEL_FLAG VARCHAR2(1) 取消标志CANCELLED_BY NUMBER(9) 取消者CANCEL_DATE DATE 取消日期CANCEL_REASON VARCHAR2(240) 取消原因FIRM_STATUS_LOOKUP_CODE VARCHAR2(30)FIRM_DATE DATETAXABLE_FLAG VARCHAR2(1) 应税标志TAX_NAME VARCHAR2(15) 税种CAPITAL_EXPENSE_FLAG VARCHAR2(1) 大写金额标志NEGOTIATED_BY_PREPARER_FLAG VARCHAR2(1)CLOSED_DATE DATE 关闭日期CLOSED_REASON VARCHAR2(240) 关闭原因TRANSACTION_REASON_CODE VARCHAR2(25) 交易原因ATTRIBUTE10 VARCHAR2(150) 厂家ATTRIBUTE11 VARCHAR2(150) 型号---------------------------------------------------------其它字典表表名：apps.fnd_user说明:MRPII用户表USER_ID NUMBER 用户IDUSER_NAME VARCHAR2 用户名称EMPLOYEE_ID NUMBER 使用人ID(可与hr.per_people_f.person_id关联)表名:hr.per_people_f说明:职工姓名表PERSON_ID NUMBER 职工ID号LAST_NAME VARCHAR2 姓名FULL_NAME VARCHAR2 姓名(带称呼MR./MISS./MRS.)DATE_OF_BIRTH DATE 生日EMPLOYEE_NUMBER VARCHAR2 工号SEX VARCHAR2 性别(M/F)TITLE VARCHAR2 称呼(MR./MISS./MRS)表名:hr.hr_locations说明:交货位置表LOCATION_ID NUMBER ID号LOCATION_CODE VARCHAR2 名称ADDRESS_LINE_1 VARCHAR2 地址POSTAL_CODE VARCHAR2 邮编RECEIVING_SITE_FLAG VARCHAR2 可否接收TAX_NAME VARCHAR2 税种TELEPHONE_NUMBER_1 VARCHAR2 电话1TELEPHONE_NUMBER_2 VARCHAR2 电话2TOWN_OR_CITY VARCHAR2 城市表名: hwcust.hw_oe.products说明: 产品编码表PRODUCT_CODE VARCHAR2(20) 产品代码PRODUCT_CLASSES VARCHAR2(30) 产品类别PRODUCT_SUB_CLASSES VARCHAR2(16) 产品子类PRODUCT_NAME VARCHAR2(30) 产品名称UNIT_OF_MEASURE VARCHAR2(4) 单位START_DATE_ACTIVE DATE 开始时间END_DATE_ACTIVE DATE 结束时间STATUS VARCHAR2(1) 状态表名e.ra_customers说明:客户表CUSTOMER_ID NUMBER 客户IDCUSTOMER_NUMBER VARCHAR2 客户代码CUSTOMER_NAME VARCHAR2 客户名称----------------------------------------------WIP模块常用表结构表名: wip.wip_accounting_classes说明: 离散作业会计科目CLASS_CODE VARCHAR2(10) 帐目ORGANIZATION_ID NUMBER 组织代码CLASS_TYPE NUMBER 帐目类型DESCRIPTION VARCHAR2(240) 描述DISABLE_DATE DATE 失效日期MATERIAL_ACCOUNT NUMBER 物料帐目MATERIAL_VARIANCE_ACCOUNT NUMBER 物料差异帐目MATERIAL_OVERHEAD_ACCOUNT NUMBER 物料经常费用帐目RESOURCE_ACCOUNT NUMBER 资源帐目RESOURCE_VARIANCE_ACCOUNT NUMBER 资源差异帐目OUTSIDE_PROCESSING_ACCOUNT NUMBEROUTSIDE_PROC_VARIANCE_ACCOUNT NUMBEROVERHEAD_ACCOUNT NUMBER 经常费用帐目OVERHEAD_VARIANCE_ACCOUNT NUMBER 经常费用差异帐目STD_COST_ADJUSTMENT_ACCOUNT NUMBER 标准成本调节帐目COMPLETION_COST_SOURCE NUMBER 完成成本来源COST_TYPE_ID NUMBER 成本类型BRIDGING_ACCOUNT NUMBER 过渡帐目表名: wip.wip_comment_codes说明: 离散作业注释COMMENT_CODE VARCHAR2(10) 注释ORGANIZATION_ID NUMBER 组织代码COMMENT_DESCRIPTION VARCHAR2(240) 说明--------------------------------------------------------表名: wip.wip_discrete_jobs说明: 离散作业表WIP_ENTITY_ID NUMBER 任务令内码ORGANIZATION_ID NUMBER 组织代码SOURCE_LINE_ID NUMBER 来源行号SOURCE_CODE VARCHAR2(20) 来源DESCRIPTION VARCHAR2(240) 说明STATUS_TYPE NUMBER 状态PRIMARY_ITEM_ID NUMBER 加工件内码FIRM_PLANNED_FLAG NUMBERJOB_TYPE NUMBER 作业类型(1.标准,3.非标准)WIP_SUPPLY_TYPE NUMBER 供应类型CLASS_CODE VARCHAR2(10) 任务类别MATERIAL_ACCOUNT NUMBER 物料帐目MATERIAL_OVERHEAD_ACCOUNT NUMBER 物料经常费用帐目RESOURCE_ACCOUNT NUMBER 资源帐目OUTSIDE_PROCESSING_ACCOUNT NUMBER 外(超)处理帐目MATERIAL_VARIANCE_ACCOUNT NUMBER 物料差异帐目RESOURCE_VARIANCE_ACCOUNT NUMBER 资源差异帐目OUTSIDE_PROC_VARIANCE_ACCOUNT NUMBER 外(超)处理差异帐目STD_COST_ADJUSTMENT_ACCOUNT NUMBER 标准成本调整帐目OVERHEAD_ACCOUNT NUMBER 经常性费用帐目OVERHEAD_VARIANCE_ACCOUNT NUMBER 经常性费用差异帐目SCHEDULED_START_DATE DATE 计划开工时间DATE_RELEASED DATE 任务令释放时间SCHEDULED_COMPLETION_DATE DATE 计划完工时间DATE_COMPLETED DATE 完工时间DATE_CLOSED DATE 关门时间START_QUANTITY NUMBER 开始数量QUANTITY_COMPLETED NUMBER 完工数量QUANTITY_SCRAPPED NUMBER 报废数量NET_QUANTITY NUMBER 净数量BOM_REFERENCE_ID NUMBER BOM参考标识码ROUTING_REFERENCE_ID NUMBER 工艺路线参考标识码COMMON_BOM_SEQUENCE_ID NUMBER 公共BOM序号COMMON_ROUTING_SEQUENCE_ID NUMBER 公共工艺路线序号BOM_REVISION VARCHAR2(3) BOM版本ROUTING_REVISION VARCHAR2(3) 工艺路线版本BOM_REVISION_DATE DATE BOM版本日期ROUTING_REVISION_DATE DATE 工艺路线版本日期LOT_NUMBER VARCHAR2(30) 批量ALTERNATE_BOM_DESIGNATOR VARCHAR2(10) 可替换BOM ALTERNATE_ROUTING_DESIGNATOR VARCHAR2(10) 可替换工艺路线COMPLETION_SUBINVENTORY VARCHAR2(10) 完工应入子库COMPLETION_LOCATOR_ID NUMBER 完工应入货位MPS_SCHEDULED_COMPLETION_DATE DATE MPS计划完工时间MPS_NET_QUANTITY NUMBER MPS净数量DEMAND_CLASS VARCHAR2(30) 需求类别SCHEDULE_GROUP_ID NUMBER 计划组标识码BUILD_SEQUENCE NUMBERLINE_ID NUMBER 行号其中STATUS_TYPE 1 未发放的-收费不允许3 发入-收费允许4 完成-允许收费5 完成-不允许收费6 暂挂-不允许收费7 已取消-不允许收费8 等待物料单加载9 失败的物料单加载10 等待路线加载11 失败的路线加载12 关闭-不可收费13 等待-成批加载14 等待关闭15 关闭失败WIP_SUPPLY_TYPE 1 推式2 装配拉式3 操作拉式4 大量5 供应商6 虚拟7 以帐单为基础---------------------------------------------表名: wip.wip_entities说明: 任务令信息表WIP_ENTITY_ID NUMBER 任务令内码ORGANIZATION_ID NUMBER 组织代码WIP_ENTITY_NAME VARCHAR2(240) 任务令名称ENTITY_TYPE NUMBER 任务类型DESCRIPTION VARCHAR2(240) 说明PRIMARY_ITEM_ID NUMBER 装配件内码-----------------------------------------------表名: wip.wip_requirement_operations说明: 任务令物料需求发放表INVENTORY_ITEM_ID NUMBER 物料项目内码ORGANIZATION_ID NUMBER 组织代码WIP_ENTITY_ID NUMBER 任务令内码OPERATION_SEQ_NUM NUMBER 工序号REPETITIVE_SCHEDULE_ID NUMBER 重复计划标识码COMPONENT_SEQUENCE_ID NUMBER BOM清单构成件序号DEPARTMENT_ID NUMBER 部门标识码WIP_SUPPLY_TYPE NUMBER 供应类型DATE_REQUIRED DATE 要求日期REQUIRED_QUANTITY NUMBER 要求数量QUANTITY_ISSUED NUMBER 发放数量QUANTITY_PER_ASSEMBLY NUMBER 单位需求量COMMENTS VARCHAR2(40) 注释SUPPLY_SUBINVENTORY VARCHAR2(10) 供应子库SUPPLY_LOCATOR_ID NUMBER 供应货位MRP_NET_FLAG NUMBER 净MRP标志MPS_REQUIRED_QUANTITY NUMBER MPS要求数量MPS_DATE_REQUIRED NUMBER MPS要求日期SEGMENT1 物料项目编码(外码)表名: wip.wip_operations说明: 离散作业操作表WIP_ENTITY_ID NUMBER 任务令内码OPERATION_SEQ_NUM NUMBER 工序号ORGANIZATION_ID NUMBER 组织代码REPETITIVE_SCHEDULE_ID NUMBER 重复计划代码OPERATION_SEQUENCE_ID NUMBER 操作序号STANDARD_OPERATION_ID NUMBER 标准操作序号DEPARTMENT_ID NUMBER 部门标识代码DESCRIPTION VARCHAR2(240) 描述SCHEDULED_QUANTITY NUMBER 计划数量QUANTITY_IN_QUEUE NUMBER 排队数量QUANTITY_RUNNING NUMBER 运行数量QUANTITY_WAITING_TO_MOVE NUMBER 待移动数量QUANTITY_REJECTED NUMBER 故障品数量QUANTITY_SCRAPPED NUMBER 报废品数量QUANTITY_COMPLETED NUMBER 完工数量FIRST_UNIT_START_DATE DATE 最早一个单位上线时间FIRST_UNIT_COMPLETION_DATE DATE 最早一个单位完成时间LAST_UNIT_START_DATE DATE 最后一个单位上线时间LAST_UNIT_COMPLETION_DATE DATE 最后一个单位完工时间PREVIOUS_OPERATION_SEQ_NUM NUMBER 前一工序序号NEXT_OPERATION_SEQ_NUM NUMBER 下一工序序号COUNT_POINT_TYPE NUMBER 计数点(1.是--自动收费,2.否) BACKFLUSH_FLAG NUMBER 倒冲库存标识(1.是,2.否)MINIMUM_TRANSFER_QUANTITY NUMBER 最小传送数量DATE_LAST_MOVED DATE 最后移动时间------------------------------------------------表名: wip.wip_operation_resources说明: 离散作业操作资源表WIP_ENTITY_ID NUMBER 任务令内码OPERATION_SEQ_NUM NUMBER 工序号RESOURCE_SEQ_NUM NUMBER 资源序号ORGANIZATION_ID NUMBER 组织代码REPETITIVE_SCHEDULE_ID NUMBER 重复计划代码RESOURCE_ID NUMBER 资源代码UOM_CODE VARCHAR2(3) 单位BASIS_TYPE NUMBER 基本类型(1.项目,2.批量)USAGE_RATE_OR_AMOUNT NUMBER 利用率或金额ACTIVITY_ID NUMBER 活动(1.运行,4.移动,5.排队) SCHEDULED_FLAG NUMBER 计划标志ASSIGNED_UNITS NUBMER 已分配单位AUTOCHARGE_TYPE NUMBER 自动记帐(1.WIP移动,2.人工,3.PO接收,4.PO移动)STANDARD_RATE_FLAG NUMBER 标准费用率标志(1.否,2.是) APPLIED_RESOURCE_UNITS NUMBER 已应用单位APPLIED_RESOURCE_VALUE NUMBER 已应用值START_DATE DATE 开始日期COMPLETION_DATE DATE 完成日期------------------------------------------------表名: wip.wip_transactions说明: 离散作业交易表TRANSACTION_ID NUBMER 交易代码ORGANIZATION_ID NUBMER 组织代码WIP_ENTITY_ID NUBMER 任务令内码PRIMARY_ITEM_ID NUBMER 加工件内码ACCT_PERIOD_ID NUBMERDEPARTMENT_ID NUBMER 部门内码TRANSACTION_TYPE NUBMER 交易类型*TRANSACTION_DATE DATE 交易日期GROUP_ID NUBMER 组号SOURCE_CODE VARCHAR2(30) 来源SOURCE_LINE_ID NUBMER 来源行号OPERATION_SEQ_NUM NUBMER 工序号RESOURCE_SEQ_NUM NUBMER 资源序号EMPLOYEE_ID NUBMER 雇员标识号RESOURCE_ID NUBMER 资源标识号AUTOCHARGE_TYPE NUBMER 自动记帐(1.WIP移动,2.人工,3.PO接收,4.PO移动)STANDARD_RATE_FLAG NUBMER 标准费用率标志(1.否,2.是) USAGE_RATE_OR_AMOUNT NUBMER 利用率或金额BASIS_TYPE NUBMER 基本类型(1.项目,2.批量) TRANSACTION_QUANTITY NUBMER 交易数量TRANSACTION_UOM VARCHAR2(3) 交易单位PRIMARY_QUANTITY NUBMER 基本数量PRIMARY_UOM VARCHAR2(3) 基本单位ACTUAL_RESOURCE_RATE NUBMER 资源实际利用率STANDARD_RESOURCE_RATE NUBMER 标准资源可用率CURRENCY_CODE VARCHAR2(15) 货币代码CURRENCY_CONVERSION_DATE DATE 货币兑换日期CURRENCY_CONVERSION_TYPE VARCHAR2(10) 货币兑换类型CURRENCY_CONVERSION_RATE NUBMER 汇率CURRENCY_ACTUAL_RESOURCE_RATE NUBMER 按该币种计算的资源实际利用率ACTIVITY_ID NUBMER 活动(1.运行,4.移动,5.排队)REASON_ID NUBMER 原因代码REFERENCE VARCHAR2(240) 参考MOVE_TRANSACTION_ID NUBMER 移动交易代码PO_HEADER_ID NUBMER 采购订单头PO_LINE_ID NUBMER 采购订单行号RCV_TRANSACTION_ID NUBMER 接收交易代码(采购订单到货)注:TRANSACTION_TYPE取值:1.资源交易,2.制造费交易,3.外部处理,4.成本更新,5.周期关闭差异,6.作业关闭差异-----------------------------------------------表名: wip.wip_transaction_accounts说明: 离散作业交易帐目ORGANIZATION_ID NUMBER 组织代码TRANSACTION_ID NUMBER 交易代码REFERENCE_ACCOUNT NUMBER 参考科目TRANSACTION_DATE DATE 交易日期WIP_ENTITY_ID NUMBER 任务令内码REPETITIVE_SCHEDULE_ID NUMBER 重复计划代码ACCOUNTING_LINE_TYPE NUMBER 会计栏类型TRANSACTION_VALUE NUMBER 交易价值BASE_TRANSACTION_VALUE NUMBER 基本交易价值CONTRA_SET_ID NUMBER 反方集代码PRIMARY_QUANTITY NUMBER 基本数量RATE_OR_AMOUNT NUMBER 率或金额BASIS_TYPE NUMBER 基本类型(1.项目,2.批量)RESOURCE_ID NUMBER 资源代码COST_ELEMENT_ID NUMBER 成本要素ACTIVITY_ID NUMBER 活动(1.运行,4.移动,5.排队)CURRENCY_CODE VARCHAR2(15) 币种CURRENCY_CONVERSION_DATE DATE 汇率日期CURRENCY_CONVERSION_TYPE VARCHAR2(10) 汇率类型CURRENCY_CONVERSION_RATE NUMBER 汇率OVERHEAD_BASIS_FACTOR NUMBER 基本经常费用因子BASIS_RESOURCE_ID NUMBER 基本资源代码GL_BATCH_ID NUMBER 财务批号-------------------------------------------------表名: wip.wip_scrap_values说明: 离散作业报废价值表TRANSACTION_ID NUMBER 交易代码LEVEL_TYPE NUMBER 级别类型COST_ELEMENT_ID NUMBER 成本要素COST_ELEMENT_VALUE NUMBER 要素值---------------------------------------------------表名: wip.wip_shop_floor_status_codes说明: 场地状态表SHOP_FLOOR_STATUS_CODE VARCHAR2(10) 场地状态ORGANIZATION_ID NUMBER 组织DESCRIPTION VARCHAR2(240) 描述DISABLE_DATE DATE 失效日期STATUS_MOVE_FLAG NUMBER 状态移动标志--------------------------------------------------表名: wip.wip_move_transactions说明: 离散作业工序移动交易TRANSACTION_ID NUMBER 交易代码GROUP_ID NUMBER 组号SOURCE_CODE VARCHAR2(30) 资源SOURCE_LINE_ID NUMBER 资源行号ORGANIZATION_ID NUMBER 组织代码WIP_ENTITY_ID NUMBER 任务令内码LINE_ID NUMBER 行号PRIMARY_ITEM_ID NUMBER 加工件内码TRANSACTION_DATE DATE 交易时间ACCT_PERIOD_ID NUMBER 会计周期FM_OPERATION_SEQ_NUM NUMBER 从工序号FM_OPERATION_CODE VARCHAR2(4) 从工序FM_DEPARTMENT_ID NUMBER 从部门FM_INTRAOPERATION_STEP_TYPE NUMBERTO_OPERATION_SEQ_NUM NUMBER 到工序号TO_OPERATION_CODE VARCHAR2(4) 到工序TO_DEPARTMENT_ID NUMBER 到部门TO_INTRAOPERATION_STEP_TYPE NUMBER TRANSACTION_QUANTITY NUMBER 交易数量TRANSACTION_UOM VARCHAR2(3) 交易单位PRIMARY_QUANTITY NUMBER 基本数量PRIMARY_UOM VARCHAR2(3) 基本单位SCRAP_ACCOUNT_ID NUMBER 报废记帐标识号REASON_ID NUMBER 原因标识号REFERENCE VARCHAR2(240) 参考表名：wip.wip_so_allocations说明: 分配表ALLOCATION_ID NUMBER 分配标识码WIP_ENTITY_ID NUMBER 任务令内码ORGANIZATION_ID NUMBER 组织代码DEMAND_SOURCE_HEADER_ID NUMBER 需求源头标识码DEMAND_SOURCE_LINE VARCHAR2(30) 需求源行号USER_LINE_NUM VARCHAR2(30) 用户栏目号DEMAND_SOURCE_DELIVERY VARCHAR2(30) 需求源投递号USER_DELIVERY VARCHAR2(30) 用户投递号QUANTITY_ALLOCATED NUMBER 已分配数量QUANTITY_COMPLETED NUMBER 已完成数量DEMAND_CLASS VARCHAR2(30) 需求类别----------------------------------------------------表名: wip.wip_valid_intraoperation_steps说明: 有效的进入工序步骤ORGANIZATION_ID NUMBER 组织代码RECORD_CREATOR VARCHAR2(6) 记录创建者(SYSTEM/USER)STEP_LOOKUP_TYPE NUMBER 步骤类型LAST_UPDATE_DATE DATE 最后更改日期STEP_MEANING VARCHAR2(10) 步骤含义-----------------------------------------------BOM模块常用表结构表名: bom.bom_bill_of_materials说明: BOM清单父项目BILL_SEQUENCE_ID NUMBER 清单序号（关键字）ASSEMBLY_ITEM_ID NUMBER 装配件内码ORGANIZATION_ID NUMBER 组织代码ASSEMBLY_TYPE NUMBER 装配类别SPECFIIC_ASSEMBLY_COMMENT VARCHAR2(240) 注释（装配件状态P、R 等）COMMON_ORGANIZATION_ID NUMBER 公共组织COMMON_BILL_SEQUENCE_ID NUMBER 公共序号COMMON_ASSEMBLY_ITEM_ID NUMBER 公共项目内码--------------------------------------------------------表名：bom.bom_inventory_components说明：BOM清单构成项目COMPONENT_SEQUENCE_ID NUMBER 构件序号BILL_SEQUENCE_ID NUMBER 清单序号OPERATION_SEQ_NUM NUMBER 操作序列号COMPONENT_ITEM_ID NUMBERITEM_NUM NUMBER 项目序列号COMPONENT_QUANTITY NUMBER 构件数量COMPONENT_YIELD_FACTOR NUMBER 产出因子EFFECTIVITY_DATE DATE 生效日期DISABLE_DATE DATE 失效日期CHANGE_NOTICE VARCHAR2(10) 更改注释(ECO更改号)PLANNING_FACTOR NUMBER 计划百分比QUANTITY_RELATED NUMBER 相关数量SO_BASIS NUMBEROPTIONAL NUMBER 是否可选(1.是;2.否)MUTUALLY_EXCLUSIVE_OPTIONS NUMBER 互斥标识(1.是;2.否)WIP_SUPPLY_TYPE NUMBER 车间供应类型(1.推式2.装配拉式3.操作拉式4.大量5.供应商6.虚拟)supply_subinventory 供应子库存supply_locator_id 供应货位IDBOM_ITEM_TYPE NUMBER 清单项目类型(1.模型2.选项类3.计划中4.标准) INCLUDE_ON_SHIP_DOCS NUMBER 包含在发运文档中(1.是;2.否) REQUIRED_FOR_REVENUE NUMBER 需要进款(1.是;2.否)REQUIRED_TO_SHIP NUMBER 需要发运(1.是;2.否)SHIPPING ALLOWED NUMBER 搬运允许(1.是;2.否)INCLUDE_IN_COST_ROLLUP NUMBER 计入成本累加中(1.是;2.否) CHECK_ATP NUMBER ATP检查(1.是;2.否)----------------------------------------------------------表名：bom.bom_assembly_comments说明：装配件状态表BILL_SEQUENCE_ID NUMBER 清单序号STANDARD_REMARKS_DESIGNATOR VARCHAR2(10) 状态标志(R,P,D_R 等)----------------------------------------------------------表名: bom.bom_standard_comments说明: 标准注释表(状态说明表)COMMENT_CODE VARCHAR2(10) 注释代码(状态代码) ORGANIZATION_ID NUMBER 组织代码COMMENT_TEXT VARCHAR2(240) 注释说明(状态说明)----------------------------------------------------表名: bom.bom_calendars说明: 日历种类表CALENDAR_CODE VARCHAR2(10) 日历代码QUARTERLY_CALENDAR_TYPE NUMBER 季度日历类型CALENDAR_START_DATE DATE 日历启用日期CALENDAR_END_DATE DATE 日历截止日期DESCRIPTION VARCHAR2(240) 描述--------------------------------------------------表名: bom.bom_calendar_dates说明: 工作日历表CALENDAR_CODE VARCAHR2(10) 日历代码PRIOR_DATE DATE 前一天CALENDAR_DATE DATE 当日(当与前,后日期均相同时为工作日)NEXT_DATE DATE 后一天PRIOR_SEQ_NUM NUMBER 前一天序列号SEQ_NUM NUMBER 当日序序列号(非工作日为空)NEXT_SEQ_NUM NUMBER 后一天序列号EXCEPTION_SET_ID NUMBER 例外集代码-----------------------------------------------表名: bom.bom_calendar_exceptions说明: 日历例外信息CALENDAR_CODE VARCHAR2(10) 日历代码EXCEPTION_SET_ID NUMBER 例外集代码EXCEPTION_DATE DATE 例外日期EXCEPTION_TYPE NUBMER 例外类别------------------------------------------------表名: bom.bom_calendar_shifts说明: 倒班表CALENDAR_CODE VARCAHR2(10) 日历代码SHIFT_NUM NUMBER 班次DESCRIPTION VARCHAR2(240) 描述---------------------------------------------表名: bom.bom_shift_dates说明: 轮班表CALENDAR_CODE VARCHAR2(10) 日历代码EXCEPTION_SET_ID NUMBER 例外集代码SHIFT_NUM NUMBER 倒班序号SHIFT_DATE DATE 倒班日期SEQ_NUM NUMBER 倒班序号NEXT_SEQ_NUM NUMBER 下一班序号PRIOR_SEQ_NUM NUMBER 上一班序号NEXT_DATE DATE 下一次倒班日期PRIOR_DATE DATE 上一次倒班日期------------------------------------------表名: bom.bom_cal_week_start_dates说明: 星期开始日期CALENDAR_CODE VARCHAR2(10) 日历代码EXCEPTION_SET_ID NUMBER 例外集代码SEQ_NUM NUMBER 序号WEEK_START_DATE DATE 周开始日期PRIOR_DATE DATE 上周开始日期NEXT_DATE DATE 下周开始日期------------------------------------------表名: bom.bom_period_start_dates说明: 周期开始日期CALENDAR_CODE VARCHAR2(10) 日历代码EXCEPTION_SET_ID NUMBER 例外集代码PERIOD_START_DATE DATE 周期开始日期PERIOD_SEQUENCE_NUM NUMBER 周期序号PERIOD_NAME VARCHAR2(3) 周期名称(月的三位英文缩写) NEXT_DATE DATE 下一周期开始日期PRIOR_DATE DATE 上一周期开始日期-------------------------------------------表名: bom.bom_workday_patterns说明: 工作日模式表CALENDAR_CODE VARCHAR2(10) 日历代码SHIFT_NUM NUMBER 班次SEQ_NUM NUMBER 模式序号DAYS_ON NUMBER 工作天数DAYS_OFF NUMBER 非工作天数DESCRIPTION VARCHAR2(240) 描述(大周/小周)--------------------------------------------表名: bom.bom_exception_sets说明: BOM例外集表EXCEPTION_SET_ID NUMBER 例外集代码EXCEPTION_SET_NAME VARCHAR2(10) 例外集名称DESCRIPTION VARCHAR2(240) 描述表内容:1 主要主要例外集2 HW_WDCES 华为日历异常集3 MBC_WDCES 莫贝克日历异常集-1 虚拟10SC 兼容的空数据---------------------------------------------表名：bom.cst_item_costs说明：项目成本表ORGANIZATION_ID NUMBER 组织代码INVENTORY_ITEM_ID NUMBER 项目内码COST_TYPE_ID NUMBER 成本类型ITEM_COST NUMBER 项目成本MATERIAL_COST NUMBER 物料成本RESOURCE_COST NUMBER 资源成本UNBURDENDED_COST NUMBER 不分摊成本BURDEN_COST NUMBER 分摊成本INVENTORY_ASSET_FLAG NUMBER 资产项目LOT_SIZE NUMBER 批量大小BASED_ON_ROLLUP_FLAG NUMBERSHRINKAGE_RATE NUMBER 收缩比例DEFAULTED_FLAG NUMBER表名: bom.cst_cost_types说明: 成本类型表COST_TYPE_ID NUMBER 成本类型代码COST_TYPE VARCHAR2(10) 成本类型DESCRIPTION VARCHAR2(240) 说明COSTING_METHOD_TYPE NUMBER 成本合计方法代码(1.2.) DISABLE_DATE DATE 失效日期本表内容如下:COST_TYPE COST_TYPE_ID DESCRIPTION冻结 1 冻结标准成本类型平均 2 平均成本类型等待 3 等待标准成本类型标准成本1000 标准成本实际成本1001 实际成本新标准成本1002 新标准成本----------------------------------------------表名: bom.cst_item_cost_details说明: 项目成本明细表INVENTORY_ITEM_ID NUMBER 项目内码ITEM_COST NUMBER 项目成本COST_TYPE_ID NUMBER 成本类型DEPARTMENT_ID NUMBER 部门代码COST_ELEMENT_ID NUMBER 成本要素类型代码LAST_UPDATE_DATE NUMBER 最后更新日期OPERATION_SEQUENCE_ID NUMBER 操作序列代码OPERATION_SEQ_NUM NUMBER 操作序列号LEVEL_TYPE NUMBER 级别类型RESOURCE_SEQ_NUM NUMBER 资源序列号RESOURCE_ID NUMBER 资源代码RESOURCE_RATE NUMBER 资源比率USAGE_RATE_OR_AMOUNT NUMBER 利用率或金额BASIS_TYPE NUMBER 基础类型BASIS_RESOURCE_ID NUMBER 基础资源代码BASIS_FACTOR NUMBER 基础因子NET_YIELD_OR_SHRINKAGE_FACTOR NUMBER 净产出或收缩比ROLLUP_SOURCE_TYPE NUMBER-----------------------------------------------表名: bom.cst_cost_elements说明: 成本要素代码表COST_ELEMENT_ID NUMBER 成本要素代码COST_ELEMENT VARCHAR2(50) 成本要素说明内容:1 物料的2 物料制造费3 资源4 外部处理5 制造费--------------------------------------------------表名: bom.cst_elemental_costs说明: 项目要素成本COST_UPDATE_ID NUMBER 成本更新代码ORGANIZATION_ID NUMBER 组织代码INVENTORY_ITEM_ID NUMBER 项目内码COST_ELEMENT_ID NUMBER 要素代码LAST_UPDATE_DATE DATE 最后更新日期STANDARD_COST NUMBER 标准成本---------------------------------------------------表名: bom.cst_resource_costs说明: 资源成本RESOURCE_ID NUMBER 资源代码COST_TYPE_ID NUMBER 成本类型RESOURCE_RATE NUMBER 资源费率--------------------------------------------表名: bom.cst_standard_costs说明: 项目标准成本表COST_UPDATE_ID NUMBER 成本更新代码INVENTORY_ITEM_ID NUMBER 项目内码ORGANIZATION_ID NUMBER 组织代码STANDARD_COST_REVISION_DATE DATE 标准成本版本日期STANDARD_COST NUMBER 标准成本INVENTORY_ADJUSTMENT_QUANTITY NUMBER 库存调节数量INVENTORY_ADJUSTMENT_VALUE NUMBER 库存调节价值INTRANSIT_ADJUSTMENT_QUANTITY NUMBER 在途调节数量INTRANSIT_ADJUSTMENT_VALUE NUMBER 在途调节价值WIP_ADJUSTMENT_QUANTITY NUMBER 在制调节数量WIP_ADJUSTMENT_VALUE NUMBER 在制调节价值--------------------------------------------------表名: bom.cst_std_cost_adj_values说明: 标准成本调节表COST_UPDATE_ID NUMBER 成本更新代码ORGANIZATION_ID NUMBER 组织代码TRANSACTION_TYPE NUMBER 交易类型ADJUSTMENT_QUANTITY NUMBER 调节数量OLD_UNIT_COST NUMBER 老的单位成本NEW_UNIT_COST NUMBER 新的单位成本COST_ELEMENT_ID NUMBER 成本元素代码LEVEL_TYPE NUMBER 级别类型IN_OUT_FLAG NUMBER 出入标志RESOURCE_ID NUMBER 资源代码INVENTORY_ITEM_ID NUMBER 项目内码SUBINVENTORY VARCHAR2(10) 子库WIP_ENTITY_ID NUMBER 离散作业代码OPERATION_SEQ_NUM NUMBER 工艺路线操作序号DEPARTMENT_ID NUMBER 部门代码RESOURCE_SEQ_ID NUMBER 资源序号代码RESOURCE_SEQ_NUM NUMBER 资源序号STANDARD_RATE_FLAG NUMBER 标准率TRANSACTION_ID NUMBER 交易代码BASIS_TYPE NUMBER 基本类型FROM_ORGANIZATION_ID NUMBER 从组织代码TO_ORGANIZATION_ID NUMBER 到组织代码表名: bom.bom_departments说明: 部门代码对应表DEPARTMENT_ID NUMBER 部门内码DEPARTMENT_CODE VARCHAR2(10) 部门代码ORGANIZATION_ID NUMBER 组织代码DESCRIPTION VARCHAR2(240) 说明(汉字说明的部门名称) DISABLE_DATE DATE 失效日期LOCATION_ID NUMBER 地点代码--------------------------------------------表名: bom.bom_resources说明: 资源代码对应表RESOURCE_ID NUMBER 资源内码RESOURCE_CODE VARCHAR2(10) 资源代码ORGANIZATION_ID NUMBER 组织代码DESCRIPTION VARCHAR2(240) 说明DISABLE_DATE DATE 失效日期COST_ELEMENT_ID NUMBER 成本要素代码PURCHASE_ITEM_ID NUMBER 购买项目代码COST_CODE_TYPE NUMBERFUNCTIONAL_CURRENCY_FLAG NUMBER 货币单位(1.是,2.否) UNIT_OF_MEASURE VARCHAR2(3) 单位DEFAULT_ACTIVITY_ID NUMBER 活动缺省值(1.运行,4.移动,5.排队)RESOURCE_TYPE NUMBER 资源类型(1.机器,2.人员,3.空间,4.杂项,5.数额)AUTOCHARGE_TYPE NUMBER 自动记帐类型(1.WIP移动,2.人工,3.PO接收,4.PO移动)STANDARD_RATE_FLAG NUMBER 标准费用率标志(1.否,2.是) DEFAULT_BASIS_TYPE NUMBER 基本类型缺省值(1.项目,2.批量)ABSORPTION_ACCOUNT NUMBER 分摊帐目ALLOW_COSTS_FLAG NUMBER 计算成本标志(1.否,2.是) RATE_VARIANCE_ACCOUNT NUMBER 差异帐目EXPENDITURE_TYPE VARCHAR2(30) 费用类型-----------------------------------------------表名: bom.bom_operational_routings说明: 工艺路线ROUTING_SEQUENCE_ID NUMBER 路线序号ASSEMBLY_ITEM_ID NUMBER 项目内码ORGANIZATION_ID NUMBER 组织代码ALTERNATE_ROUTING_DESIGNATOR VARCHAR2(10) 替换工艺路线ROUTING_TYPE NUMBER 路线类别COMMON_ASSEMBLY_ITEM_ID NUMBER 公共装配件内码COMMON_ROUTING_SEQUENCE_ID NUMBER 公共路线序号ROUTING_COMMENT VARCHAR2(240) 路线注释COMPLETION_SUBINVENTORY VARCHAR2(10) 完工入库名称COMPLETION_LOCATOR_ID NUMBER 完工入库货位。
oracle erp库存模块表(INV)
表名：inv.mtl_system_items说明：物料主表列名类型含义ORGANIZATION_ID NUMBER 组织代码INVENTORY_ITEM_ID NUMBER 项目内码SEGMENT1 VARCHAR2(40) 项目编码（外码）UNIT_OF_ISSUE 单位DESCRIPTION 项目说明ALLOWED_UNITS_LOOKUP_CODE 可否单位换算INVENTORY_ITEM_STATUS_CODE 项目状态ITEM_TYPE 项目类型PRIMARY_UNIT_OF_MEASURE 基本度量单位BASE_ITEM_ID 基础代码BOM_ENABLED_FLAG BOM使能标志(项目能否有清单)(Y/N) BOM_ITEM_TYPE BOM项目类型ENGINEERING_ECN_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 采购员代码ENCUMBRANCE_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_FACTOR A 取舍因子TAXABLE_FLAG 税收项目UNIT_OF_ISSUE 单位ALLOW_EXPRESS_DELIVERY_FLAG A 可以快递项目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_FLAG A 是否必须收据RECEIVE_CLOSE_TOLERANCE A 接收结束允许天数RECEIVING_ROUTING_ID 接收行程安排编码AUTO_SERIAL_ALPHA_PREFIX Starting Serial Prefix CYCLE_COUNT_ENABLED_FLAG 能否循环计算INVENTORY_ITEM_FLAG 是否为库存项目LOCATION_CONTROL_CODE 采购点控制代码LOT_CONTROL_CODE 是否有批量控制MTL_TRANSACTIONS_ENABLED_FLAG 可否交易POSITIVE_MEASUREMENT_ERROR Pos Measurement Error RESERVABLE_TYPE 是否要预留RESTRICT_LOCATORS_CODE 是否限制定位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 固定提前期FIXED_LOT_MULTIPLIER 固定批量大小FIXED_ORDER_QUANTITY 固定定单数INVENTORY_PLANNING_CODE 库存计划方法MAXIMUM_ORDER_QUANTITY 最大定单数MAX_MINMAX_QUANTITY Min-Max Maximum Quantity MINIMUM_ORDER_QUANTITY 最小定单数MIN_MINMAX_QUANTITY Min-Max Minimum Quantity MRP_SAFETY_STOCK_CODE 安全库存MRP_SAFETY_STOCK_PERCENT 安全库存百分比ORDER_COST 定单费用PLANNER_CODE 计划员属性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 制造或购买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_SUPPLY_LOCATOR_ID 离散作业库存地点WIP_SUPPLY_TYPE 离散作业供货类型ATP_COMPONENTS_FLAG 是否有ATP组成部件ATP_FLAG 是否为ATP项目ATP_RULE_ID ATP规则COLLATERAL_FLAG 是否为附属项目CUSTOMER_ORDER_FLAG 是否为定单项目DEFAULT_SHIPPING_ORG 运输组织代码INTERNAL_ORDER_ENABLED_FLAG 是否可以是内部定单INTERNAL_ORDER_FLAG 是否为内部定单PICKING_RULE_ID 库存规则PICK_COMPONENTS_FLAG 是否为可选部件REPLENISH_TO_ORDER_FLAG 是否为定单装配RETURNABLE_FLAG 是否可退回RETURN_INSPECTION_REQUIREMENT RMA Inspection Status SHIPPABLE_ITEM_FLAG 是否为运输项目SHIP_MODEL_COMPLETE_FLAG 运送是否完成SO_TRANSACTIONS_FLAG 是否可交易ACCOUNTING_RULE_ID 会计规则INVOICEABLE_ITEM_FLAG 是否为需发票项目INVOICE_ENABLED_FLAG 是否具有发票INVOICING_RULE_ID 发票规则PAYMENT_TERMS_ID 付款期限SALES_ACCOUNT 销售帐目TAX_CODE 税收代码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 计划例外设置ROUNDING_CONTROL_TYPE 四舍五入控制FIXED_LEAD_TIME 固定提前期POSTPROCESSING_LEAD_TIME 后处理提前期WIP_SUPPLY_SUBINVENTORY 离散作业子库存CUSTOMER_ORDER_ENABLED_FLAG 是否是销售定单ACCEPTABLE_RATE_INCREASE 可接受的增加率表名：inv.mtl_planners说明：计划员代码表列名类型含义PLANNER_CODE VARCHAR2(10) 计划员代码ORGANIZATION_ID NUMBER 组织代码DESCRIPTION VARCHAR2(50) 计划员描述DISABLE_DATE DATE 失效日期表名: inv.mtl_units_of_measure说明：度量单位表UNIT_OF_MEASURE VARCHAR2(25) 度量单位UOM_CODE VARCHAR2(3) 单位代码UOM_CLASS VARCHAR2(10) 单位类别BASE_UOM_FLAG VARCHAR2(1) 是否基本单位DISABLE_DATE DATE 失效日期DESCRIPTION VARCHAR2(50) 描述表名：inv.mtl_uom_classes说明：度量单位类表UOM_CLASS VARCHAR2(10) 单位类别DISABLE_DATE DATE 失效日期DESCRIPTION VARCHAR2(50) 描述表名: inv.mtl_uom_class_conversions说明: 单位类别换算INVENTORY_ITEM_ID NUMBER 项目内码FROM_UNIT_OF_MEASURE VARCHAR2(25) 从单位FROM_UOM_CODE VARCHAR2(3) 从单位代码FROM_UOM_CLASS VARCHAR2(10) 从单位类TO_UNIT_OF_MEASURE VARCHAR2(25) 到单位TO_UOM_CODE VARCHAR2(3) 到单位代码TO_UOM_CLASS VARCHAR2(10) 到单位类CONVERSION_RATE NUMBER 换算比率DISABLE_DATE DATE 失效日期表名: inv.mtl_descr_element_values说明: 项目描述构成元素值INVENTORY_ITEM_ID NUMBER 项目内码ELEMENT_NAME VARCHAR2(30) 元素名称ELEMENT_SEQUENCE NUMBER 元素序号ELEMENT_VALUE VARCHAR2(30) 元素值DEFAULT_ELEMENT_FLAG VARCHAR2(1) 是否默认表名: inv.mtl_descriptive_elements说明: 项目描述构成元素表ITEM_CATALOG_GROUP_ID NUMBER 项目目录组代码ELEMENT_SEQUENCE NUMBER 元素序号ELEMENT_NAME VARCHAR2(30) 元素名称(频率.光洁度.硬度.亮度) DESCRIPTION VARCHAR2(50)表名: inv.mtl_item_catalog_groups说明: 项目目录表ITEM_CATALOG_GROUP_ID NUMBER 项目目录组代码SEGMENT1 VARCHAR2(40) 项目编码前两位SEGMENT2 VARCHAR2(40) 项目编码3、4位DESCRIPTION VARCHAR2(240) 描述表名：inv.mtl_item_attributes说明：项目属性字段说明ATTRIBUTE_NAME 属性字段(项目属性表中)DATA_TYPE 数据类型USER_ATTRIBUTE_NAME 用户属性名USER_ATTRIBUTE_NAME_GUI 用户属性名界面文字信息CONTROL_LEVEL 控制级别SEQUENCE 序号LEVEL_UPDATEABLE_FLAG 级别可否更改VALIDATION_CODE 校验代码MANDATORY_FLAG 是否强制表名: inv.mtl_manufacturers说明: 制造商代码表MANUFACTURER_ID NUMBER 制造商代码MANUFACTURER_NAME VARCHAR2(30) 制造商名称表名：inv.mtl_item_status说明：项目状态表INVENTORY_ITEM_STATUS_CODE VARCHAR2(10) 状态代码(Active/Inactive) DESCRIPTION VARCHAR2(240) 描述表名: inv.mtl_picking_rules说明: 捡料规则表PICKING_RULE_ID NUMBER 捡料规则代码PICKING_RULE_NAME VARCHAR2(30) 捡料规则名称(FIFO/BY_INV) DESCRIPTION VARCHAR2(50) 说明(先进先出/按库捡料)表名：inv.mfg_lookups说明：系统检查类型及值列表(从中可查许多TYPE字段的值)LOOKUP_TYPE VARCHAR2(30) 检查类型LOOKUP_CODE NUMBER 值代码MEANING VARCHAR2(80) 值含义表名: inv.mtl_item_revisions说明: 项目版本表ORGANIZATION_ID NUMBER 组织代码INENTORY_ITEM_ID NUMBER 项目内码REVISION VARCHAR2(3) 版本LAST_UPDATE_DATE DATE 最后更新日期EFFECTIVITY_DATE DATE 生效日期表名：inv.mtl_onhand_quantities说明：库存数据表列名类型含义INVENTORY_ITEM_ID NUMBER 项目内码ORGANIZATION_ID NUMBER 组织代码DATE_RECEIVED DATE 接收日期TRANSACTION_QUANTITY NUMBER 交易数量SUBINVENTORY_CODE VARCHAR2(10) 子库名REVISION VARCHAR2(3) 版本LOCATOR_ID NUMBER 货位内码CREATE_TRANSACTION_ID NUMBER 创建交易代码UPDATE_TRANSACTION_ID NUMBER 更改交易代码表名: inv.mtl_item_locations说明: 项目货位表ORGANIZATION_ID NUMBER 组织代码INVENTORY_LOCATION_ID NUMBER 货位内码SUBINVENTORY_CODE VARCHAR2(10) 子库名称SEGMENT1 VARCHAR2(40) 货位编码表名：inv.mtl_material_transactions说明：交易登记(出入库记录)表列名类型含义TRANSACTION_ID NUMBER 交易代码INVENTORY_ITEM_ID NUMBER 项目内码REVISION VARCHAR2(3) 版本ORGANIZATION_ID NUMBER 组织代码SUBINVENTORY_CODE VARCHAR2(10) 子库名称LOCATOR_ID NUMBER 货位代码TRANSACTION_TYPE_ID NUMBER 交易类型代码TRANSACTION_ACTION_ID NUMBER 交易执行代码TRANSACTION_SOURCE_TYPE_ID NUMBER 交易来源类型代码TRANSACTION_SOURCE_ID NUMBER 交易来源代码(视情况时对应任务令内码,订单内码等)TRANSACTION_SOURCE_NAME VARCHAR2(30) 交易来源名称TRANSACTION_QUANTITY NUMBER 交易数量TRANSACTION_UOM VARCHAR2(3) 单位TRANSACTION_DATE DATE 交易日期TRANSACTION_REFERENCE VARCHAR2(240) 交易参考(类型为Z31时对应订单号) REASON_ID NUMBER 交易原因代码TRANSACTION_COST NUMBER 交易成本PRIOR_COST NUMBER 原来成本NEW_COST NUMBER 新成本DEPARTMENT_ID NUMBER 部门代码OPERATION_SEQ_NUM NUMBER 操作序列栏目TRANSFER_TRANSACTION_ID NUMBER 移动交易代码TRANSACTION_SET_ID NUMBER 交易集代码RCV_TRANSACTION_ID NUMBER 接收交易代码MOVE_TRANSACTION_ID NUMBER 移动交易代码COMPLETION_TRANSACTION_ID NUMBER 最终交易代码SOURCE_CODE VARCHAR2(30) 来源代码(如RCV为接收)SOURCE_LINE_ID NUMBER 来源行号(无来源行时为-1)VENDOR_LOT_NUMBER VARCHAR2(30) 供应商批量TRANSFER_ORGANIZATION_ID NUMBER 对应组织代码TRANSFER_SUBINVENTORY VARCHAR2(10) 对应子库名TRANSFER_LOCATOR_ID NUMBER 对应货位表名：inv.mtl_transaction_types说明：交易类型代码表列名类型含义TRANSACTION_TYPE_ID NUMBER 交易类型代码TRANSACTION_TYPE_NAME VARCHAR2(30) 交易类型名称DESCRIPTION VARCHAR2(240) 描述TRANSACTION_ACTION_ID NUMBER 交易执行代码TRANSACTION_SOURCE_TYPE_ID NUMBER 交易来源类型代码DISABLE_DATE DATE 失效日期USER_DEFINED_FLAG VARCHAR2(1) 是否用户自定义表名：inv.mtl_transaction_reasons说明：交易原因代码表REASON_ID NUMBER 原因代码REASON_NAME VARCHAR2(30) 名称DESCRIPTION VARCHAR2(240) 描述表名: inv.mtl_txn_source_types说明: 交易来源类型代码表TRANSACTION_SOURCE_TYPE_ID NUMBER 交易来源类型代码TRANSACTION_SOURCE_TYPE_NAME VARCHAR2(30) 交易来源类型名称DESCRIPTION VARCHAR2(240) 描述表名: inv.mtl_supply说明: 项目供给信息表ITEM_ID NUMBER 项目代码SUPPLY_TYPE_CODE 供应类型(REQ,PO,RECEIVING,SHIPMENT) SUPPLY_SOURCE_ID 供应来源代码LAST_UPDATE_DATE DATE 最后更新时间REQ_HEADER_ID NUMBER PR头号(类型为REQ时有内容)REQ_LINE_ID NUMBER PR行号(类型为REQ时有内容)PO_HEADER_ID NUMBER PO头号(类型为PO时有内容)PO_LINE_ID NUMBER PO行号(类型为PO时有内容)PO_LINE_LOCATION_ID NUMBER PO定位号(类型为PO)PO_DISTRIBUTION_IDSHIPMENT_HEADER_ID 运输信息头号(类型RECEIVING)SHIPMENT_LINE_ID 运输信息行号(类型RECEIVING)RCV_TRANSACTION_ID 接收交易代码QUANTITY NUMBER 数量UNIT_OF_MEASURE 单位TO_ORG_PRIMARY_QUANTITY 转入基本组织数量TO_ORG_PRIMARY_UOM 转入基本组织单位RECEIPT_DATE DATE 接收时间NEED_BY_DATE DATE 需求时间DESTINATION_TYPE_CODE 目标类型(INVENTORY,EXPENSE,SHOP FLOOR) LOCATION_ID NUMBER 位置代码FROM_ORGANIZATION_ID NUMBER 来源组织代码FROM_SUBINVENTORY 来源子库TO_ORGANIZATION_ID NUMBER 目的组织代码TO_SUBINVENTORY 目的子库INTRANSIT_OWNING_ORG_ID NUMBER 在途所属组织代码MRP_PRIMARY_QUANTITY NUMBER MRP基本计划数量MRP_PRIMARY_UOM MRP基本计划单位MRP_EXPECTED_DELIVERY_DATE DATE MRP预计交付时间MRP_DESTINATION_TYPE_CODE MRP目标类型MRP_TO_ORGANIZATION_ID NUMBER MRP目的组织代码表名: inv.mtl_demand说明: 项目需求信息表DEMAND_ID 需求代码ORGANIZATION_ID 组织代码INVENTORY_ITEM_ID 项目内码DEMAND_SOURCE_TYPE 需求类型DEMAND_SOURCE_HEADER_ID 需求来源头号DEMAND_SOURCE_LINE 需求来源行号DEMAND_SOURCE_DELIVERY 需求来源投递号UOM_CODE 单位LINE_ITEM_QUANTITY 需求行项目数量PRIMARY_UOM_QUANTITY 基本计量单位数量LINE_ITEM_RESERVATION_QTYRESERVATION_QUANTITY COMPLETED_QUANTITY REQUIREMENT_DATE 需求时间RESERVATION_TYPE 专用类型LAST_UPDATE_DATE 最后更新日期PARENT_DEMAND_ID 上级需求代码USER_LINE_NUM 用户栏目UPDATE_FLAG 更新标志SUBINVENTORY 子库COMPONENT_SEQUENCE_ID 组成序号PARENT_COMPONENT_SEQ_ID 父组件序号RTA_MODEL_SOURCE_LINECONFIG_STATUSAVAILABLE_TO_MRPAVAILABLE_TO_ATPROW_STATUS_FLAGATP_LEAD_TIMEEXPLOSION_EFFECTIVITY_DATEBOM_LEVELMRP_DATEMRP_QUANTITYCUSTOMER_IDBILL_TO_SITE_IDSHIP_TO_SITE_IDMASTER_RESERVATION_QTY表名：inv.mtl_sales_orders说明：销售订单表SALES_ORDER_ID NUMBER 销售订单内码SEGMENT1 VARCHAR2(40) 订单号SEGMENT2 VARCHAR2(40) 订单类别ENABLED_FLAG VARCHAR2(1) 使能标志LAST_UPDATE_DATE DATE 最后更新日期CREATION_DATE DATE 创建日期表名：inv.mtl_safety_stocks说明：安全库存ORGANIZATION_ID NUMBER 组织代码INVENTORY_ITEM_ID NUMBER 项目内码EFFECTIVITY_DATE DATE 生效日期SAFETY_STOCK_CODE NUMBER 安全库存代码SAFETY_STOCK_QUANTITY NUMBER 安全库存数量表名：MTL_ONHAND_LOCATOR_V说明：库存数据视图列名类型含义INVENTORY_ITEM_ID NUMBER 项目内码ORGANIZATION_ID NUMBER 组织代码PADDED_CONCATENATED_SEGMENTS 物品编码REVISION VARCHAR2(3) 物品版本TOTAL QOH NUMBER 现有量SUBINVENTORY_CODE VARCHAR2(10) 子库名LOCATOR_ID NUMBER 货位内码。
oracle erp各模块表关系
安 全 象 只 弓 ，不拉 它就松 ，要想 保安全 ，常把 弓弦绷 。20.12.1206:45:4106:45Dec-2012-Dec-20
加 强 交 通 建 设管理 ，确保 工程建 设质量 。06:45:4106:45:4106:45Saturday, December 12, 2020
安 全 在 于 心 细，事 故出在 麻痹。 20.12.1220.12.1206:45:4106:45:41December 12, 2020
FND_CR: FND_CONCURRENT_REQUESTS
FND_CD:FND_CONFLICT_DOMAINS
FND_RES:FND_RESPONSIBILY
FND_CRC:FND_CONC_RELEASE_CLASSES FND_DGU:FND_DATA_GROUP_UNITS
FND_LOG:FND_LOGINS
并发管理器
FND_CCR:FND_CONCURRENT_COMPLEX_RULES FND_CCL:FND_CONCURRENT_COMPLEX_LINES
FND_CPG: FND_CONCURRENT_PROGRAMS
FND_CRC: FND_CONCURRENT_REQUEST_CLASS
FND_OID:FND_ORACLE_USERID
库存(INV)
库存(INV)
采购(PO)
采购(PO)
采购(PO)
采购(PO)
采购(PO)
采购(PO)
订单管理(OM)
OE_ORDER_HEADERS_ALL OE_ORDER_LINES_ALL
订单管理(OM)
WSH_DELIVERY_DETAILS WSH_DELIVERY_ASSIGNMENTS
OracleERP表结构
VARCHAR2(10) VARCHAR2(240)
表名: inv.mtl_picking_rules 说明: 捡料规则表
PICKING_RULE_ID PICKING_RULE_NAME DESCRIPTION
NUMBER VARCHAR2(30) VARCHAR2(50)
表名：inv.mfg_lookups
NUMBER VARCHAR2(50) DATE
VARCHAR2(25) VARCHAR2(3) VARCHAR2(10) VARCHAR2(1) DATE VARCHAR2(50)
VARCHAR2(10) DATE VARCHAR2(50)
NUMBER VARCHAR2(25) VARCHAR2(3) VARCHAR2(10) VARCHAR2(25) VARCHAR2(3) VARCHAR2(10) NUMBER DATE
表名: inv.mtl_manufacturers 说明: 制造商代码表 MANUFACTURER_ID MANUFACTURER_NAME
NUMBER VARCHAR2(30)
表名：inv.mtl_item_status 说明：项目状态表
INVENTORY_ITEM_STATUS_CODE DESCRIPTION
REVISION LOCATOR_ID CREATE_TRANSACTION_ID UPDATE_TRANSACTION_ID
SOURCE_TYPE
ACCEPTABLE_EARLY_DAYS
AUTO_REDUCE_MPS
DEMAND_TIME_FENCE_CODE
DEMAND_TIME_FENCE_DAYS
MRP_CALCULATE_ATP_FLAG
(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(客户表)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(离散作业交易帐目)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(装配件状态表)21bom.bom_standard_ments(标准注释表(状态说明表))22 bom.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(工作日模式表)24bom.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_departments(部门代码对应表)29bom.bom_resources(资源代码对应表)29bom.bom_operational_routings(工艺路线)30bom.bom_operation_resources(工艺路线细节之资源表)30 bom.bom_operation_sequences(工艺路线细节之工艺工序表)30 bom.bom_standard_operations(标准操作表)31bom.bom_std_op_resources(标准操作资源表)31bom.bom_substitute_ponents(BOM替代件表)32mrp.mrp_assembly_operations(计划装配实施表)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采购计划)35 mrp.mrp_item_wip_entities(MRP项目离散作业)37 mrp.mrp_plans(计划表)37mrp.mrp_remendations (计划建议(含例外信息))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_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_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采购员代码encumbrance_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_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接收结束允许天数receiving_routing_id接收行程安排编码auto_serial_alpha_prefixstartingserialprefixcycle_count_enabled_flag能否循环计算inventory_item_flag是否为库存项目location_control_code采购点控制代码lot_control_code是否有批量控制mtl_transactions_enabled_flag可否交易positive_measurement_errorposmeasurementerror reservable_type是否要预留restrict_locators_code是否限制定位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固定提前期fixed_lot_multiplier固定批量大小fixed_order_quantity固定定单数inventory_planning_code库存计划方法maximum_order_quantity最大定单数max_minmax_quantitymin-maxmaximumquantity minimum_order_quantity最小定单数min_minmax_quantitymin-maxminimumquantity mrp_safety_stock_code安全库存mrp_safety_stock_percent安全库存百分比order_cost定单费用planner_code计划员属性safety_stock_bucket_days安全库存天数source_organization_id来源组织代码source_subinventory来源子库存source_type补充来源类型acceptable_early_days接收提前天数auto_reduce_mps自动冲减mps demand_time_fence_code需求时间栏demand_time_fence_days需求时间栏天数mrp_calculate_atp_flag是否有atpmrp_planning_code计划方法overrun_percentage超差百分比planning_make_buy_code制造或购买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_supply_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_flag是否为定单装配returnable_flag是否可退回return_inspection_requirementrmainspectionstatus shippable_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_code税收代码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计划例外设置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_idnumberouidorder_type_idnumber订单类型idorder_numbernumber订单编号ordered_datedate定购日期request_datedate客户要求发货日期demand_class_codevarchar2(30)需求分类code price_list_idnumber价目表idtransactional_curr_codevarchar2(15)币种cust_po_numbervarchar2(50)合同号invoicing_rule_idnumber(15)开票规则id accounting_rule_idnumber(15)会计规则id payment_term_idnumber(15)付款条件id shipping_method_codevarchar2(30)发运方法code fob_point_codevarchar2(30)fobcodefreight_terms_codevarchar2(30)运费条款code ship_from_org_idnumber发货库存组织idship_to_org_idnumber客户account_idinvoice_to_org_idnumber开票客户account_id sold_to_contact_idnumber经办人idship_to_contact_idnumber发货至联系人id invoice_to_contact_idnumber开票至联系人idcreated_bynumber输入人idlast_updated_bynumber更新人last_update_datedate更新日期last_update_loginnumber更新人用户attribute1date合同收到日期attribute2date客户要求到货日期attribute3varchar2(240)到货视同验收attribute11varchar2(240)客户行业分类code attribute12varchar2(240)合同文本金额attribute13varchar2(240)是否需要客服到货确认attribute14date承诺核销日期cancelled_flagvarchar2(1)是否取消open_flagvarchar2(1)是否未结booked_flagvarchar2(1)登记与否salesrep_idnumber(15)销售员idreturn_reason_codevarchar2(30)退货原因code sales_channel_codevarchar2(30)销售渠道code order_category_codevarchar2(30)订单类别shipping_instructionsvarchar2(2000)老合同号packing_instructionsvarchar2(2000)包装指令flow_status_codevarchar2(30)工作流状态代码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_descriptionvarchar2(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_vendorvarchar2(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)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_reasonvarchar2(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说明:职工姓名表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_codevarchar2邮编receiving_site_flagvarchar2可否接收tax_namevarchar2税种telephone_number_1varchar2电话1 telephone_number_2varchar2电话2 town_or_cityvarchar2城市hwcust.hw_oe.products(产品编码表)表名:hwcust.hw_oe.products说明:产品编码表product_codevarchar2(20)产品代码product_classesvarchar2(30)产品类别product_sub_classesvarchar2(16)产品子类product_namevarchar2(30)产品名称unit_of_measurevarchar2(4)单位start_date_activedate开始时间end_date_activedate结束时间statusvarchar2(1)状态e.ra_customers(客户表)表名e.ra_customers说明:客户表customer_idnumber客户idcustomer_numbervarchar2客户代码customer_namevarchar2客户名称wip.wip_accounting_classes(离散作业会计科目) wip模块常用表结构表名:wip.wip_accounting_classes说明:离散作业会计科目class_codevarchar2(10)帐目organization_idnumber组织代码class_typenumber帐目类型descriptionvarchar2(240)描述disable_datedate失效日期material_accountnumber物料帐目material_variance_accountnumber物料差异帐目material_overhead_accountnumber物料经常费用帐目resource_accountnumber资源帐目resource_variance_accountnumber资源差异帐目outside_processing_accountnumberoutside_proc_variance_accountnumberoverhead_accountnumber经常费用帐目overhead_variance_accountnumber经常费用差异帐目std_cost_adjustment_accountnumber标准成本调节帐目pletion_cost_sourcenumber完成成本来源cost_type_idnumber成本类型bridging_accountnumber过渡帐目wip.wip_ment_codes(离散作业注释)表名:wip.wip_ment_codes说明:离散作业注释ment_codevarchar2(10)注释organization_idnumber组织代码ment_descriptionvarchar2(240)说明wip.wip_discrete_jobs(离散作业表)表名:wip.wip_discrete_jobs说明:离散作业表wip_entity_idnumber任务令内码organization_idnumber组织代码source_line_idnumber来源行号source_codevarchar2(20)来源descriptionvarchar2(240)说明status_typenumber状态primary_item_idnumber加工件内码firm_planned_flagnumberjob_typenumber作业类型(1.标准,3.非标准)wip_supply_typenumber供应类型class_codevarchar2(10)任务类别material_accountnumber物料帐目material_overhead_accountnumber物料经常费用帐目resource_accountnumber资源帐目outside_processing_accountnumber外(超)处理帐目material_variance_accountnumber物料差异帐目resource_variance_accountnumber资源差异帐目outside_proc_variance_accountnumber外(超)处理差异帐目std_cost_adjustment_accountnumber标准成本调整帐目overhead_accountnumber经常性费用帐目overhead_variance_accountnumber经常性费用差异帐目scheduled_start_datedate计划开工时间date_releaseddate任务令释放时间scheduled_pletion_datedate计划完工时间date_pleteddate完工时间date_closeddate关门时间start_quantitynumber开始数量quantity_pletednumber完工数量quantity_scrappednumber报废数量net_quantitynumber净数量bom_reference_idnumberbom参考标识码routing_reference_idnumber工艺路线参考标识码mon_bom_sequence_idnumber公共bom序号mon_routing_sequence_idnumber公共工艺路线序号bom_revisionvarchar2(3)bom版本routing_revisionvarchar2(3)工艺路线版本bom_revision_datedatebom版本日期routing_revision_datedate工艺路线版本日期lot_numbervarchar2(30)批量alternate_bom_designatorvarchar2(10)可替换bom alternate_routing_designatorvarchar2(10)可替换工艺路线pletion_subinventoryvarchar2(10)完工应入子库pletion_locator_idnumber完工应入货位mps_scheduled_pletion_datedatemps计划完工时间mps_net_quantitynumbermps净数量demand_classvarchar2(30)需求类别schedule_group_idnumber计划组标识码build_sequencenumberline_idnumber行号其中status_type1未发放的-收费不允许3发入-收费允许4完成-允许收费5完成-不允许收费6暂挂-不允许收费7已取消-不允许收费8等待物料单加载9失败的物料单加载10等待路线加载11失败的路线加载12关闭-不可收费13等待-成批加载14等待关闭15关闭失败wip_supply_type1推式2装配拉式3操作拉式4大量5供应商6虚拟7以帐单为基础wip.wip_entities(任务令信息表)表名:wip.wip_entities说明:任务令信息表wip_entity_idnumber任务令内码organization_idnumber组织代码wip_entity_namevarchar2(240)任务令名称entity_typenumber任务类型descriptionvarchar2(240)说明primary_item_idnumber装配件内码wip.wip_requirement_operations(任务令物料需求发放表) 表名:wip.wip_requirement_operations说明:任务令物料需求发放表inventory_item_idnumber物料项目内码organization_idnumber组织代码wip_entity_idnumber任务令内码operation_seq_numnumber工序号repetitive_schedule_idnumber重复计划标识码ponent_sequence_idnumberbom清单构成件序号department_idnumber部门标识码wip_supply_typenumber供应类型date_requireddate要求日期required_quantitynumber要求数量quantity_per_assemblynumber单位需求量mentsvarchar2(40)注释supply_subinventoryvarchar2(10)供应子库supply_locator_idnumber供应货位mrp_net_flagnumber净mrp标志mps_required_quantitynumbermps要求数量mps_date_requirednumbermps要求日期segment1物料项目编码(外码)wip.wip_operations(离散作业操作表)表名:wip.wip_operations说明:离散作业操作表wip_entity_idnumber任务令内码operation_seq_numnumber工序号organization_idnumber组织代码repetitive_schedule_idnumber重复计划代码operation_sequence_idnumber操作序号standard_operation_idnumber标准操作序号department_idnumber部门标识代码descriptionvarchar2(240)描述scheduled_quantitynumber计划数量quantity_in_queuenumber排队数量quantity_waiting_to_movenumber待移动数量quantity_rejectednumber故障品数量quantity_scrappednumber报废品数量quantity_pletednumber完工数量first_unit_start_datedate最早一个单位上线时间first_unit_pletion_datedate最早一个单位完成时间last_unit_start_datedate最后一个单位上线时间last_unit_pletion_datedate最后一个单位完工时间previous_operation_seq_numnumber前一工序序号next_operation_seq_numnumber下一工序序号count_point_typenumber计数点(1.是--自动收费,2.否) backflush_flagnumber倒冲库存标识(1.是,2.否) minimum_transfer_quantitynumber最小传送数量date_last_moveddate最后移动时间wip.wip_operation_resources(离散作业操作资源) 表名:wip.wip_operation_resources说明:离散作业操作资源表wip_entity_idnumber任务令内码operation_seq_numnumber工序号resource_seq_numnumber资源序号organization_idnumber组织代码repetitive_schedule_idnumber重复计划代码resource_idnumber资源代码uom_codevarchar2(3)单位basis_typenumber基本类型(1.项目,2.批量)usage_rate_or_amountnumber利用率或金额activity_idnumber活动(1.运行,4.移动,5.排队)scheduled_flagnumber计划标志assigned_unitsnubmer已分配单位autocharge_typenumber自动记帐(1.wip移动,2.人工,3.po接收,4.po移动) standard_rate_flagnumber标准费用率标志(1.否,2.是)applied_resource_unitsnumber已应用单位applied_resource_valuenumber已应用值start_datedate开始日期pletion_datedate完成日期wip.wip_transactions(离散作业交易表)表名:wip.wip_transactions说明:离散作业交易表transaction_idnubmer交易代码organization_idnubmer组织代码wip_entity_idnubmer任务令内码primary_item_idnubmer加工件内码acct_period_idnubmerdepartment_idnubmer部门内码transaction_typenubmer交易类型*transaction_datedate交易日期group_idnubmer组号source_codevarchar2(30)来源source_line_idnubmer来源行号operation_seq_numnubmer工序号resource_seq_numnubmer资源序号employee_idnubmer雇员标识号resource_idnubmer资源标识号autocharge_typenubmer自动记帐(1.wip移动,2.人工,3.po接收,4.po移动) standard_rate_flagnubmer标准费用率标志(1.否,2.是)usage_rate_or_amountnubmer利用率或金额basis_typenubmer基本类型(1.项目,2.批量)transaction_quantitynubmer交易数量transaction_uomvarchar2(3)交易单位primary_quantitynubmer基本数量primary_uomvarchar2(3)基本单位actual_resource_ratenubmer资源实际利用率standard_resource_ratenubmer标准资源可用率currency_codevarchar2(15)货币代码currency_conversion_datedate货币兑换日期currency_conversion_typevarchar2(10)货币兑换类型currency_conversion_ratenubmer汇率currency_actual_resource_ratenubmer按该币种计算的资源实际利用率activity_idnubmer活动(1.运行,4.移动,5.排队)reason_idnubmer原因代码referencevarchar2(240)参考move_transaction_idnubmer移动交易代码po_header_idnubmer采购订单头po_line_idnubmer采购订单行号rcv_transaction_idnubmer接收交易代码(采购订单到货)注:transaction_type取值:1.资源交易,2.制造费交易,3.外部处理,4.成本更新,5.周期关闭差异,6.作业关闭差异wip.wip_transaction_accounts(离散作业交易帐目)表名:wip.wip_transaction_accounts说明:离散作业交易帐目organization_idnumber组织代码transaction_idnumber交易代码reference_accountnumber参考科目transaction_datedate交易日期wip_entity_idnumber任务令内码repetitive_schedule_idnumber重复计划代码accounting_line_typenumber会计栏类型transaction_valuenumber交易价值base_transaction_valuenumber基本交易价值contra_set_idnumber反方集代码primary_quantitynumber基本数量rate_or_amountnumber率或金额basis_typenumber基本类型(1.项目,2.批量) resource_idnumber资源代码cost_element_idnumber成本要素activity_idnumber活动(1.运行,4.移动,5.排队) currency_codevarchar2(15)币种currency_conversion_datedate汇率日期currency_conversion_typevarchar2(10)汇率类型currency_conversion_ratenumber汇率overhead_basis_factornumber基本经常费用因子basis_resource_idnumber基本资源代码gl_batch_idnumber财务批号wip.wip_scrap_values(离散作业报废价值表)表名:wip.wip_scrap_values说明:离散作业报废价值表transaction_idnumber交易代码level_typenumber级别类型cost_element_idnumber成本要素cost_element_valuenumber要素值wip.wip_shop_floor_status_codes(场地状态表)表名:wip.wip_shop_floor_status_codes说明:场地状态表shop_floor_status_codevarchar2(10)场地状态organization_idnumber组织descriptionvarchar2(240)描述disable_datedate失效日期status_move_flagnumber状态移动标志wip.wip_move_transactions(离散作业工序移动交易) 表名:wip.wip_move_transactions说明:离散作业工序移动交易transaction_idnumber交易代码group_idnumber组号source_codevarchar2(30)资源source_line_idnumber资源行号organization_idnumber组织代码wip_entity_idnumber任务令内码line_idnumber行号primary_item_idnumber加工件内码transaction_datedate交易时间acct_period_idnumber会计周期fm_operation_seq_numnumber从工序号fm_operation_codevarchar2(4)从工序fm_department_idnumber从部门fm_intraoperation_step_typenumberto_operation_seq_numnumber到工序号to_operation_codevarchar2(4)到工序to_department_idnumber到部门to_intraoperation_step_typenumber transaction_quantitynumber交易数量transaction_uomvarchar2(3)交易单位primary_quantitynumber基本数量primary_uomvarchar2(3)基本单位scrap_account_idnumber报废记帐标识号reason_idnumber原因标识号referencevarchar2(240)参考wip.wip_so_allocations(分配表)表名：wip.wip_so_allocations说明:分配表allocation_idnumber分配标识码wip_entity_idnumber任务令内码organization_idnumber组织代码demand_source_header_idnumber需求源头标识码demand_source_linevarchar2(30)需求源行号user_line_numvarchar2(30)用户栏目号demand_source_deliveryvarchar2(30)需求源投递号user_deliveryvarchar2(30)用户投递号quantity_allocatednumber已分配数量quantity_pletednumber已完成数量demand_classvarchar2(30)需求类别wip.wip_valid_intraoperation_steps(有效的进入工序步骤) 表名:wip.wip_valid_intraoperation_steps说明:有效的进入工序步骤organization_idnumber组织代码record_creatorvarchar2(6)记录创建者(system/user)step_lookup_typenumber步骤类型last_update_datedate最后更改日期step_meaningvarchar2(10)步骤含义bom.bom_bill_of_materials(bom清单父项目)bom模块常用表结构表名:bom.bom_bill_of_materials说明:bom清单父项目bill_sequence_idnumber清单序号（关键字）assembly_item_idnumber装配件内码organization_idnumber组织代码assembly_typenumber装配类别specfiic_assembly_mentvarchar2(240)注释（装配件状态p、r等）mon_organization_idnumber公共组织mon_bill_sequence_idnumber公共序号mon_assembly_item_idnumber公共项目内码bom.bom_inventory_ponents(bom清单构成项目)表名：bom.bom_inventory_ponents说明：bom清单构成项目ponent_sequence_idnumber构件序号bill_sequence_idnumber清单序号operation_seq_numnumber操作序列号ponent_item_idnumberitem_numnumber项目序列号ponent_quantitynumber构件数量ponent_yield_factornumber产出因子effectivity_datedate生效日期disable_datedate失效日期change_noticevarchar2(10)更改注释(eco更改号)planning_factornumber计划百分比quantity_relatednumber相关数量so_basisnumberoptionalnumber是否可选(1.是;2.否)mutually_exclusive_optionsnumber互斥标识(1.是;2.否)wip_supply_typenumber车间供应类型(1.推式2.装配拉式3.操作拉式4.大量5.供应商6.虚拟)supply_subinventory供应子库存supply_locator_id供应货位idbom_item_typenumber清单项目类型(1.模型2.选项类3.计划中4.标准) include_on_ship_docsnumber包含在发运文档中(1.是;2.否) required_for_revenuenumber需要进款(1.是;2.否)required_to_shipnumber需要发运(1.是;2.否) shippingallowednumber搬运允许(1.是;2.否)include_in_cost_rollupnumber计入成本累加中(1.是;2.否)check_atpnumberatp检查(1.是;2.否)bom.bom_assembly_ments(装配件状态表)表名：bom.bom_assembly_ments说明：装配件状态表bill_sequence_idnumber清单序号standard_remarks_designatorvarchar2(10)状态标志(r,p,d_r等) bom.bom_standard_ments(标准注释表(状态说明表))表名:bom.bom_standard_ments说明:标准注释表(状态说明表)ment_codevarchar2(10)注释代码(状态代码) organization_idnumber组织代码ment_textvarchar2(240)注释说明(状态说明)bom.bom_calendars(日历种类表)表名:bom.bom_calendars说明:日历种类表calendar_codevarchar2(10)日历代码quarterly_calendar_typenumber季度日历类型calendar_start_datedate日历启用日期calendar_end_datedate日历截止日期descriptionvarchar2(240)描述bom.bom_calendar_dates(工作日历表)表名:bom.bom_calendar_dates说明:工作日历表calendar_codevarcahr2(10)日历代码prior_datedate前一天calendar_datedate当日(当与前,后日期均相同时为工作日) next_datedate后一天prior_seq_numnumber前一天序列号seq_numnumber当日序序列号(非工作日为空)next_seq_numnumber后一天序列号exception_set_idnumber例外集代码bom.bom_calendar_exceptions(日历例外信息) 表名:bom.bom_calendar_exceptions说明:日历例外信息calendar_codevarchar2(10)日历代码exception_set_idnumber例外集代码exception_datedate例外日期exception_typenubmer例外类别bom.bom_calendar_shifts(倒班表)表名:bom.bom_calendar_shifts说明:倒班表calendar_codevarcahr2(10)日历代码shift_numnumber班次descriptionvarchar2(240)描述bom.bom_shift_dates(轮班表)表名:bom.bom_shift_dates说明:轮班表calendar_codevarchar2(10)日历代码exception_set_idnumber例外集代码shift_numnumber倒班序号shift_datedate倒班日期seq_numnumber倒班序号next_seq_numnumber下一班序号prior_seq_numnumber上一班序号next_datedate下一次倒班日期prior_datedate上一次倒班日期bom.bom_cal_week_start_dates(星期开始日期) 表名:bom.bom_cal_week_start_dates说明:星期开始日期calendar_codevarchar2(10)日历代码exception_set_idnumber例外集代码seq_numnumber序号week_start_datedate周开始日期prior_datedate上周开始日期next_datedate下周开始日期bom.bom_period_start_dates(周期开始日期) 表名:bom.bom_period_start_dates说明:周期开始日期calendar_codevarchar2(10)日历代码exception_set_idnumber例外集代码period_start_datedate周期开始日期period_sequence_numnumber周期序号period_namevarchar2(3)周期名称(月的三位英文缩写) next_datedate下一周期开始日期prior_datedate上一周期开始日期bom.bom_workday_patterns(工作日模式表)表名:bom.bom_workday_patterns说明:工作日模式表calendar_codevarchar2(10)日历代码shift_numnumber班次seq_numnumber模式序号days_onnumber工作天数days_offnumber非工作天数descriptionvarchar2(240)描述(大周/小周)bom.bom_exception_sets(bom例外集表)表名:bom.bom_exception_sets说明:bom例外集表exception_set_idnumber例外集代码exception_set_namevarchar2(10)例外集名称descriptionvarchar2(240)描述表内容:1主要主要例外集2hw_wdces华为日历异常集3mbc_wdces莫贝克日历异常集-1虚拟10sc兼容的空数据bom.cst_item_costs(项目成本表)表名：bom.cst_item_costs说明：项目成本表organization_idnumber组织代码inventory_item_idnumber项目内码cost_type_idnumber成本类型item_costnumber项目成本material_costnumber物料成本resource_costnumber资源成本unburdended_costnumber不分摊成本burden_costnumber分摊成本inventory_asset_flagnumber资产项目lot_sizenumber批量大小based_on_rollup_flagnumber shrinkage_ratenumber收缩比例defaulted_flagnumberbom.cst_cost_types(成本类型表)表名:bom.cst_cost_types说明:成本类型表cost_type_idnumber成本类型代码cost_typevarchar2(10)成本类型descriptionvarchar2(240)说明costing_method_typenumber成本合计方法代码(1.2.) disable_datedate失效日期本表内容如下:cost_typecost_type_iddescription冻结1冻结标准成本类型平均2平均成本类型等待3等待标准成本类型标准成本1000标准成本实际成本1001实际成本新标准成本1002新标准成本bom.cst_item_cost_details(项目成本明细表)表名:bom.cst_item_cost_details说明:项目成本明细表organization_idnumber组织代码inventory_item_idnumber项目内码item_costnumber项目成本cost_type_idnumber成本类型department_idnumber部门代码cost_element_idnumber成本要素类型代码last_update_datenumber最后更新日期operation_sequence_idnumber操作序列代码operation_seq_numnumber操作序列号level_typenumber级别类型resource_seq_numnumber资源序列号resource_idnumber资源代码resource_ratenumber资源比率usage_rate_or_amountnumber利用率或金额basis_typenumber基础类型basis_resource_idnumber基础资源代码basis_factornumber基础因子net_yield_or_shrinkage_factornumber净产出或收缩比rollup_source_typenumberbom.cst_cost_elements(成本要素代码表)表名:bom.cst_cost_elements说明:成本要素代码表cost_element_idnumber成本要素代码cost_elementvarchar2(50)成本要素说明内容:1物料的2物料制造费3资源4外部处理5制造费bom.cst_elemental_costs(项目要素成本) 表名:bom.cst_elemental_costs说明:项目要素成本cost_update_idnumber成本更新代码organization_idnumber组织代码inventory_item_idnumber项目内码cost_element_idnumber要素代码last_update_datedate最后更新日期standard_costnumber标准成本bom.cst_resource_costs(资源成本)表名:bom.cst_resource_costs说明:资源成本resource_idnumber资源代码cost_type_idnumber成本类型organization_idnumber组织代码resource_ratenumber资源费率bom.cst_standard_costs(项目标准成本表) 表名:bom.cst_standard_costs说明:项目标准成本表cost_update_idnumber成本更新代码inventory_item_idnumber项目内码organization_idnumber组织代码standard_cost_revision_datedate标准成本版本日期standard_costnumber标准成本inventory_adjustment_quantitynumber库存调节数量inventory_adjustment_valuenumber库存调节价值intransit_adjustment_quantitynumber在途调节数量intransit_adjustment_valuenumber在途调节价值wip_adjustment_quantitynumber在制调节数量wip_adjustment_valuenumber在制调节价值bom.cst_std_cost_adj_values(标准成本调节表)表名:bom.cst_std_cost_adj_values说明:标准成本调节表cost_update_idnumber成本更新代码organization_idnumber组织代码transaction_typenumber交易类型adjustment_quantitynumber调节数量old_unit_costnumber老的单位成本new_unit_costnumber新的单位成本cost_element_idnumber成本元素代码level_typenumber级别类型in_out_flagnumber出入标志resource_idnumber资源代码inventory_item_idnumber项目内码subinventoryvarchar2(10)子库wip_entity_idnumber离散作业代码operation_seq_numnumber工艺路线操作序号department_idnumber部门代码resource_seq_idnumber资源序号代码resource_seq_numnumber资源序号standard_rate_flagnumber标准率transaction_idnumber交易代码basis_typenumber基本类型from_organization_idnumber从组织代码to_organization_idnumber到组织代码bom.bom_departments(部门代码对应表)表名:bom.bom_departments说明:部门代码对应表department_idnumber部门内码department_codevarchar2(10)部门代s码organization_idnumber组织代码descriptionvarchar2(240)说明(汉字说明的部门名称)disable_datedate失效日期location_idnumber地点代码bom.bom_resources(资源代码对应表)表名:bom.bom_resources说明:资源代码对应表resource_idnumber资源内码resource_codevarchar2(10)资源代码organization_idnumber组织代码descriptionvarchar2(240)说明disable_datedate失效日期cost_element_idnumber成本要素代码purchase_item_idnumber购买项目代码cost_code_typenumberfunctional_currency_flagnumber货币单位(1.是,2.否)unit_of_measurevarchar2(3)单位default_activity_idnumber活动缺省值(1.运行,4.移动,5.排队)resource_typenumber资源类型(1.机器,2.人员,3.空间,4.杂项,5.数额) autocharge_typenumber自动记帐类型(1.wip移动,2.人工,3.po接收,4.po移动) standard_rate_flagnumber标准费用率标志(1.否,2.是)default_basis_typenumber基本类型缺省值(1.项目,2.批量)absorption_accountnumber分摊帐目allow_costs_flagnumber计算成本标志(1.否,2.是)。
oracle_erp_库存管理inv_8个表结构.docx
下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_TRANSACTION_TYPES(TRANSACTION_TYPE_ID NUMBER not null,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null,CREATION_DATE DATE not null,CREATED_BY NUMBER not null,TRANSACTION_TYPE_NAME VARCHAR2(80) not null, DESCRIPTION VARCHAR2(240),TRANSACTION_ACTION_ID NUMBER not null, TRANSACTION_SOURCE_TYPE_ID NUMBER not null, SHORTAGE_MSG_BACKGROUND_FLAG VARCHAR2(1), SHORTAGE_MSG_ONLINE_FLAG VARCHAR2(1), DISABLE_DATE DATE,USER_DEFINED_FLAG VARCHAR2(1) not null, ATTRIBUTE1 VARCHAR2(150),ATTRIBUTE2 VARCHAR2(150),ATTRIBUTE3 VARCHAR2(150),ATTRIBUTE4 VARCHAR2(150),ATTRIBUTE5 VARCHAR2(150),ATTRIBUTE6 VARCHAR2(150),ATTRIBUTE7 VARCHAR2(150),ATTRIBUTE8 VARCHAR2(150),ATTRIBUTE9 VARCHAR2(150),ATTRIBUTE10 VARCHAR2(150),ATTRIBUTE11 VARCHAR2(150),ATTRIBUTE12 VARCHAR2(150),ATTRIBUTE13 VARCHAR2(150),ATTRIBUTE14 VARCHAR2(150),ATTRIBUTE15 VARCHAR2(150),ATTRIBUTE_CATEGORY VARCHAR2(30),TYPE_CLASS NUMBER,STATUS_CONTROL_FLAG NUMBER)tablespace APPS_TS_SEEDpctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate index INV.MTL_TRANSACTION_TYPES_N1 onINV.MTL_TRANSACTION_TYPES (TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID)tablespace APPS_TS_SEEDpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create unique index INV.MTL_TRANSACTION_TYPES_U1 onINV.MTL_TRANSACTION_TYPES (TRANSACTION_TYPE_ID) tablespace APPS_TS_SEEDpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onINV.MTL_TRANSACTION_TYPES to APPS with grant option;grant select on INV.MTL_TRANSACTION_TYPES to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_SYSTEM_ITEMS_B (INVENTORY_ITEM_ID NUMBER not null, ORGANIZATION_ID NUMBER not null, LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null, CREATION_DATE DATE not null, CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER, SUMMARY_FLAG VARCHAR2(1) not null, ENABLED_FLAG VARCHAR2(1) not null,START_DATE_ACTIVE DATE,END_DATE_ACTIVE DATE,DESCRIPTION VARCHAR2(240),BUYER_ID NUMBER(9),ACCOUNTING_RULE_ID NUMBER, INVOICING_RULE_ID NUMBER, SEGMENT1 VARCHAR2(40),SEGMENT2 VARCHAR2(40),SEGMENT3 VARCHAR2(40),SEGMENT4 VARCHAR2(40),SEGMENT5 VARCHAR2(40),SEGMENT6 VARCHAR2(40),SEGMENT7 VARCHAR2(40),SEGMENT8 VARCHAR2(40),SEGMENT9 VARCHAR2(40),SEGMENT10 VARCHAR2(40),SEGMENT11 VARCHAR2(40),SEGMENT12 VARCHAR2(40),SEGMENT13 VARCHAR2(40),SEGMENT14 VARCHAR2(40),SEGMENT15 VARCHAR2(40),SEGMENT16 VARCHAR2(40),SEGMENT17 VARCHAR2(40),SEGMENT18 VARCHAR2(40),SEGMENT19 VARCHAR2(40),SEGMENT20 VARCHAR2(40),ATTRIBUTE_CATEGORY VARCHAR2(30),ATTRIBUTE1 VARCHAR2(240),ATTRIBUTE2 VARCHAR2(240),ATTRIBUTE3 VARCHAR2(240),ATTRIBUTE4 VARCHAR2(240),ATTRIBUTE5 VARCHAR2(240),ATTRIBUTE6 VARCHAR2(240),ATTRIBUTE7 VARCHAR2(240),ATTRIBUTE8 VARCHAR2(240),ATTRIBUTE9 VARCHAR2(240),ATTRIBUTE10 VARCHAR2(240),ATTRIBUTE11 VARCHAR2(240),ATTRIBUTE12 VARCHAR2(240),ATTRIBUTE13 VARCHAR2(240),ATTRIBUTE14 VARCHAR2(240),ATTRIBUTE15 VARCHAR2(240),PURCHASING_ITEM_FLAG VARCHAR2(1) not null, SHIPPABLE_ITEM_FLAG VARCHAR2(1) not null,CUSTOMER_ORDER_FLAG VARCHAR2(1) not null,INTERNAL_ORDER_FLAG VARCHAR2(1) not null,SERVICE_ITEM_FLAG VARCHAR2(1) not null,INVENTORY_ITEM_FLAG VARCHAR2(1) not null,ENG_ITEM_FLAG VARCHAR2(1) not null,INVENTORY_ASSET_FLAG VARCHAR2(1) not null, PURCHASING_ENABLED_FLAG VARCHAR2(1) not null, CUSTOMER_ORDER_ENABLED_FLAG VARCHAR2(1) not null, INTERNAL_ORDER_ENABLED_FLAG VARCHAR2(1) not null, SO_TRANSACTIONS_FLAG VARCHAR2(1) not null,MTL_TRANSACTIONS_ENABLED_FLAG VARCHAR2(1) not null, STOCK_ENABLED_FLAG VARCHAR2(1) not null,BOM_ENABLED_FLAG VARCHAR2(1) not null,BUILD_IN_WIP_FLAG VARCHAR2(1) not null,REVISION_QTY_CONTROL_CODE NUMBER,ITEM_CATALOG_GROUP_ID NUMBER,CATALOG_STATUS_FLAG VARCHAR2(1),RETURNABLE_FLAG VARCHAR2(1),DEFAULT_SHIPPING_ORG NUMBER,COLLATERAL_FLAG VARCHAR2(1),TAXABLE_FLAG VARCHAR2(1),QTY_RCV_EXCEPTION_CODE VARCHAR2(25),ALLOW_ITEM_DESC_UPDATE_FLAG VARCHAR2(1),INSPECTION_REQUIRED_FLAG VARCHAR2(1), RECEIPT_REQUIRED_FLAG VARCHAR2(1),MARKET_PRICE NUMBER,HAZARD_CLASS_ID NUMBER,RFQ_REQUIRED_FLAG VARCHAR2(1),QTY_RCV_TOLERANCE NUMBER,LIST_PRICE_PER_UNIT NUMBER,UN_NUMBER_ID NUMBER,PRICE_TOLERANCE_PERCENT NUMBER,ASSET_CATEGORY_ID NUMBER,ROUNDING_FACTOR NUMBER,UNIT_OF_ISSUE VARCHAR2(25),ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2(25), ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2(1), ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2(1), ALLOW_EXPRESS_DELIVERY_FLAG VARCHAR2(1), DAYS_EARLY_RECEIPT_ALLOWED NUMBER,DAYS_LATE_RECEIPT_ALLOWED NUMBER, RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2(25), RECEIVING_ROUTING_ID NUMBER,INVOICE_CLOSE_TOLERANCE NUMBER,RECEIVE_CLOSE_TOLERANCE NUMBER,AUTO_LOT_ALPHA_PREFIX VARCHAR2(30),START_AUTO_LOT_NUMBER VARCHAR2(30),LOT_CONTROL_CODE NUMBER,SHELF_LIFE_CODE NUMBER,SHELF_LIFE_DAYS NUMBER,SERIAL_NUMBER_CONTROL_CODE NUMBER,START_AUTO_SERIAL_NUMBER VARCHAR2(30), AUTO_SERIAL_ALPHA_PREFIX VARCHAR2(30), SOURCE_TYPE NUMBER,SOURCE_ORGANIZATION_ID NUMBER,SOURCE_SUBINVENTORY VARCHAR2(10),EXPENSE_ACCOUNT NUMBER,ENCUMBRANCE_ACCOUNT NUMBER,RESTRICT_SUBINVENTORIES_CODE NUMBER,UNIT_WEIGHT NUMBER,WEIGHT_UOM_CODE VARCHAR2(3),VOLUME_UOM_CODE VARCHAR2(3),UNIT_VOLUME NUMBER,RESTRICT_LOCATORS_CODE NUMBER,LOCATION_CONTROL_CODE NUMBER,SHRINKAGE_RATE NUMBER,ACCEPTABLE_EARLY_DAYS NUMBER,PLANNING_TIME_FENCE_CODE NUMBER,DEMAND_TIME_FENCE_CODE NUMBER,LEAD_TIME_LOT_SIZE NUMBER,STD_LOT_SIZE NUMBER,CUM_MANUFACTURING_LEAD_TIME NUMBER, OVERRUN_PERCENTAGE NUMBER,MRP_CALCULATE_ATP_FLAG VARCHAR2(1), ACCEPTABLE_RATE_INCREASE NUMBER, ACCEPTABLE_RATE_DECREASE NUMBER, CUMULATIVE_TOTAL_LEAD_TIME NUMBER, PLANNING_TIME_FENCE_DAYS NUMBER,DEMAND_TIME_FENCE_DAYS NUMBER,END_ASSEMBLY_PEGGING_FLAG VARCHAR2(1), REPETITIVE_PLANNING_FLAG VARCHAR2(1), PLANNING_EXCEPTION_SET VARCHAR2(10),BOM_ITEM_TYPE NUMBER not null,PICK_COMPONENTS_FLAG VARCHAR2(1) not null, REPLENISH_TO_ORDER_FLAG VARCHAR2(1) not null, BASE_ITEM_ID NUMBER,ATP_COMPONENTS_FLAG VARCHAR2(1) not null,ATP_FLAG VARCHAR2(1) not null,FIXED_LEAD_TIME NUMBER,VARIABLE_LEAD_TIME NUMBER,WIP_SUPPLY_LOCATOR_ID NUMBER,WIP_SUPPLY_TYPE NUMBER,WIP_SUPPLY_SUBINVENTORY VARCHAR2(10), PRIMARY_UOM_CODE VARCHAR2(3),PRIMARY_UNIT_OF_MEASURE VARCHAR2(25), ALLOWED_UNITS_LOOKUP_CODE NUMBER,COST_OF_SALES_ACCOUNT NUMBER,SALES_ACCOUNT NUMBER,DEFAULT_INCLUDE_IN_ROLLUP_FLAG VARCHAR2(1), INVENTORY_ITEM_STATUS_CODE VARCHAR2(10) not null, INVENTORY_PLANNING_CODE NUMBER,PLANNER_CODE VARCHAR2(10),PLANNING_MAKE_BUY_CODE NUMBER,FIXED_LOT_MULTIPLIER NUMBER,ROUNDING_CONTROL_TYPE NUMBER,CARRYING_COST NUMBER,POSTPROCESSING_LEAD_TIME NUMBER, PREPROCESSING_LEAD_TIME NUMBER,FULL_LEAD_TIME NUMBER,ORDER_COST NUMBER,MRP_SAFETY_STOCK_PERCENT NUMBER,MRP_SAFETY_STOCK_CODE NUMBER,MIN_MINMAX_QUANTITY NUMBER,MAX_MINMAX_QUANTITY NUMBER,MINIMUM_ORDER_QUANTITY NUMBER,FIXED_ORDER_QUANTITY NUMBER,FIXED_DAYS_SUPPLY NUMBER,MAXIMUM_ORDER_QUANTITY NUMBER,ATP_RULE_ID NUMBER,PICKING_RULE_ID NUMBER,RESERVABLE_TYPE NUMBER,POSITIVE_MEASUREMENT_ERROR NUMBER,NEGATIVE_MEASUREMENT_ERROR NUMBER, ENGINEERING_ECN_CODE VARCHAR2(50),ENGINEERING_ITEM_ID NUMBER,ENGINEERING_DATE DATE,SERVICE_STARTING_DELAY NUMBER,VENDOR_WARRANTY_FLAG VARCHAR2(1) not null, SERVICEABLE_COMPONENT_FLAG VARCHAR2(1), SERVICEABLE_PRODUCT_FLAG VARCHAR2(1) not null,BASE_WARRANTY_SERVICE_ID NUMBER,PAYMENT_TERMS_ID NUMBER,PREVENTIVE_MAINTENANCE_FLAG VARCHAR2(1), PRIMARY_SPECIALIST_ID NUMBER,SECONDARY_SPECIALIST_ID NUMBER,SERVICEABLE_ITEM_CLASS_ID NUMBER,TIME_BILLABLE_FLAG VARCHAR2(1),MATERIAL_BILLABLE_FLAG VARCHAR2(30),EXPENSE_BILLABLE_FLAG VARCHAR2(1),PRORATE_SERVICE_FLAG VARCHAR2(1),COVERAGE_SCHEDULE_ID NUMBER,SERVICE_DURATION_PERIOD_CODE VARCHAR2(10), SERVICE_DURATION NUMBER,WARRANTY_VENDOR_ID NUMBER,MAX_WARRANTY_AMOUNT NUMBER,RESPONSE_TIME_PERIOD_CODE VARCHAR2(30), RESPONSE_TIME_VALUE NUMBER,NEW_REVISION_CODE VARCHAR2(30),INVOICEABLE_ITEM_FLAG VARCHAR2(1) not null,TAX_CODE VARCHAR2(50),INVOICE_ENABLED_FLAG VARCHAR2(1) not null,MUST_USE_APPROVED_VENDOR_FLAG VARCHAR2(1) not null, REQUEST_ID NUMBER,PROGRAM_APPLICATION_ID NUMBER,PROGRAM_ID NUMBER,PROGRAM_UPDATE_DATE DATE,OUTSIDE_OPERATION_FLAG VARCHAR2(1) not null, OUTSIDE_OPERATION_UOM_TYPE VARCHAR2(25),SAFETY_STOCK_BUCKET_DAYS NUMBER,AUTO_REDUCE_MPS NUMBER(22),COSTING_ENABLED_FLAG VARCHAR2(1) not null,AUTO_CREATED_CONFIG_FLAG VARCHAR2(1) not null, CYCLE_COUNT_ENABLED_FLAG VARCHAR2(1) not null, ITEM_TYPE VARCHAR2(30),MODEL_CONFIG_CLAUSE_NAME VARCHAR2(10), SHIP_MODEL_COMPLETE_FLAG VARCHAR2(1),MRP_PLANNING_CODE NUMBER,RETURN_INSPECTION_REQUIREMENT NUMBER,ATO_FORECAST_CONTROL NUMBER,RELEASE_TIME_FENCE_CODE NUMBER,RELEASE_TIME_FENCE_DAYS NUMBER, CONTAINER_ITEM_FLAG VARCHAR2(1),VEHICLE_ITEM_FLAG VARCHAR2(1),MAXIMUM_LOAD_WEIGHT NUMBER,MINIMUM_FILL_PERCENT NUMBER,CONTAINER_TYPE_CODE VARCHAR2(30),INTERNAL_VOLUME NUMBER,WH_UPDATE_DATE DATE,PRODUCT_FAMILY_ITEM_ID NUMBER,GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(150), GLOBAL_ATTRIBUTE1 VARCHAR2(150),GLOBAL_ATTRIBUTE2 VARCHAR2(150),GLOBAL_ATTRIBUTE3 VARCHAR2(150),GLOBAL_ATTRIBUTE4 VARCHAR2(150),GLOBAL_ATTRIBUTE5 VARCHAR2(150),GLOBAL_ATTRIBUTE6 VARCHAR2(150),GLOBAL_ATTRIBUTE7 VARCHAR2(150),GLOBAL_ATTRIBUTE8 VARCHAR2(150),GLOBAL_ATTRIBUTE9 VARCHAR2(150),GLOBAL_ATTRIBUTE10 VARCHAR2(150), PURCHASING_TAX_CODE VARCHAR2(50), OVERCOMPLETION_TOLERANCE_TYPE NUMBER, OVERCOMPLETION_TOLERANCE_VALUE NUMBER, EFFECTIVITY_CONTROL NUMBER,CHECK_SHORTAGES_FLAG VARCHAR2(1),OVER_SHIPMENT_TOLERANCE NUMBER,UNDER_SHIPMENT_TOLERANCE NUMBER,OVER_RETURN_TOLERANCE NUMBER,UNDER_RETURN_TOLERANCE NUMBER, EQUIPMENT_TYPE NUMBER,RECOVERED_PART_DISP_CODE VARCHAR2(30), DEFECT_TRACKING_ON_FLAG VARCHAR2(1),USAGE_ITEM_FLAG VARCHAR2(1),EVENT_FLAG VARCHAR2(1),ELECTRONIC_FLAG VARCHAR2(1), DOWNLOADABLE_FLAG VARCHAR2(1),VOL_DISCOUNT_EXEMPT_FLAG VARCHAR2(1),COUPON_EXEMPT_FLAG VARCHAR2(1),COMMS_NL_TRACKABLE_FLAG VARCHAR2(1), ASSET_CREATION_CODE VARCHAR2(30), COMMS_ACTIVATION_REQD_FLAG VARCHAR2(1), ORDERABLE_ON_WEB_FLAG VARCHAR2(1), BACK_ORDERABLE_FLAG VARCHAR2(1),WEB_STATUS VARCHAR2(30),INDIVISIBLE_FLAG VARCHAR2(1),DIMENSION_UOM_CODE VARCHAR2(3),UNIT_LENGTH NUMBER,UNIT_WIDTH NUMBER,UNIT_HEIGHT NUMBER,BULK_PICKED_FLAG VARCHAR2(1),LOT_STATUS_ENABLED VARCHAR2(1), DEFAULT_LOT_STATUS_ID NUMBER,SERIAL_STATUS_ENABLED VARCHAR2(1), DEFAULT_SERIAL_STATUS_ID NUMBER,LOT_SPLIT_ENABLED VARCHAR2(1),LOT_MERGE_ENABLED VARCHAR2(1), INVENTORY_CARRY_PENALTY NUMBER, OPERATION_SLACK_PENALTY NUMBER, FINANCING_ALLOWED_FLAG VARCHAR2(1), EAM_ITEM_TYPE NUMBER,EAM_ACTIVITY_TYPE_CODE VARCHAR2(30), EAM_ACTIVITY_CAUSE_CODE VARCHAR2(30), EAM_ACT_NOTIFICATION_FLAG VARCHAR2(1), EAM_ACT_SHUTDOWN_STATUS VARCHAR2(30), DUAL_UOM_CONTROL NUMBER,SECONDARY_UOM_CODE VARCHAR2(3),DUAL_UOM_DEVIATION_HIGH NUMBER,DUAL_UOM_DEVIATION_LOW NUMBER, CONTRACT_ITEM_TYPE_CODE VARCHAR2(30), SUBSCRIPTION_DEPEND_FLAG VARCHAR2(1), SERV_REQ_ENABLED_CODE VARCHAR2(30), SERV_BILLING_ENABLED_FLAG VARCHAR2(1), SERV_IMPORTANCE_LEVEL NUMBER,PLANNED_INV_POINT_FLAG VARCHAR2(1),LOT_TRANSLATE_ENABLED VARCHAR2(1), DEFAULT_SO_SOURCE_TYPE VARCHAR2(30), CREATE_SUPPLY_FLAG VARCHAR2(1), SUBSTITUTION_WINDOW_CODE NUMBER, SUBSTITUTION_WINDOW_DAYS NUMBER,IB_ITEM_INSTANCE_CLASS VARCHAR2(30), CONFIG_MODEL_TYPE VARCHAR2(30),LOT_SUBSTITUTION_ENABLED VARCHAR2(1), MINIMUM_LICENSE_QUANTITY NUMBER,EAM_ACTIVITY_SOURCE_CODE VARCHAR2(30),LIFECYCLE_ID NUMBER,CURRENT_PHASE_ID NUMBER,OBJECT_VERSION_NUMBER NUMBER(9),TRACKING_QUANTITY_IND VARCHAR2(30),ONT_PRICING_QTY_SOURCE VARCHAR2(30),SECONDARY_DEFAULT_IND VARCHAR2(30),OPTION_SPECIFIC_SOURCED NUMBER,APPROVAL_STATUS VARCHAR2(30),VMI_MINIMUM_UNITS NUMBER,VMI_MINIMUM_DAYS NUMBER,VMI_MAXIMUM_UNITS NUMBER,VMI_MAXIMUM_DAYS NUMBER,VMI_FIXED_ORDER_QUANTITY NUMBER,SO_AUTHORIZATION_FLAG NUMBER,CONSIGNED_FLAG NUMBER,ASN_AUTOEXPIRE_FLAG NUMBER,VMI_FORECAST_TYPE NUMBER,FORECAST_HORIZON NUMBER,EXCLUDE_FROM_BUDGET_FLAG NUMBER,DAYS_TGT_INV_SUPPLY NUMBER,DAYS_TGT_INV_WINDOW NUMBER,DAYS_MAX_INV_SUPPLY NUMBER,DAYS_MAX_INV_WINDOW NUMBER,DRP_PLANNED_FLAG NUMBER,CRITICAL_COMPONENT_FLAG NUMBER,CONTINOUS_TRANSFER NUMBER,CONVERGENCE NUMBER,DIVERGENCE NUMBER,CONFIG_ORGS VARCHAR2(30),CONFIG_MATCH VARCHAR2(30))tablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate index INV.MTL_SYSTEM_ITEMS_B_N1 on INV.MTL_SYSTEM_ITEMS_B(ORGANIZATION_ID, SEGMENT1)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N10 on INV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, PLANNER_CODE)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N11 on INV.MTL_SYSTEM_ITEMS_B (WEB_STATUS, ORGANIZATION_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N12 on INV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, CUSTOMER_ORDER_ENABLED_FLAG,SERVICE_ITEM_FLAG, VENDOR_WARRANTY_FLAG)tablespace APPS_TS_TX_IDXpctfree 10maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N13 on INV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, WIP_SUPPLY_LOCATOR_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N14 on INV.MTL_SYSTEM_ITEMS_B (BASE_ITEM_ID, ORGANIZATION_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N2 on INV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, DESCRIPTION)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(next 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N3 on INV.MTL_SYSTEM_ITEMS_B (INVENTORY_ITEM_STATUS_CODE)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N4 on INV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, AUTO_CREATED_CONFIG_FLAG)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N5 on INV.MTL_SYSTEM_ITEMS_B (WH_UPDATE_DATE)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimited);create index INV.MTL_SYSTEM_ITEMS_B_N6 on INV.MTL_SYSTEM_ITEMS_B (ITEM_CATALOG_GROUP_ID, CATALOG_STATUS_FLAG)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N7 on INV.MTL_SYSTEM_ITEMS_B (PRODUCT_FAMILY_ITEM_ID, ORGANIZATION_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N8 on INV.MTL_SYSTEM_ITEMS_B (COMMS_NL_TRACKABLE_FLAG, ORGANIZATION_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N9 on INV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, BUYER_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create unique index INV.MTL_SYSTEM_ITEMS_B_U1 onINV.MTL_SYSTEM_ITEMS_B (INVENTORY_ITEM_ID, ORGANIZATION_ID) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onINV.MTL_SYSTEM_ITEMS_B to APPS with grant option;grant select on INV.MTL_SYSTEM_ITEMS_B to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table BOM.CST_COST_TYPES(COST_TYPE_ID NUMBER not null,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null, CREATION_DATE DATE not null,CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER, ORGANIZATION_ID NUMBER,COST_TYPE VARCHAR2(10) not null, DESCRIPTION VARCHAR2(240),COSTING_METHOD_TYPE NUMBER not null, FROZEN_STANDARD_FLAG NUMBER, DEFAULT_COST_TYPE_ID NUMBER not null, BOM_SNAPSHOT_FLAG NUMBER not null, ALTERNATE_BOM_DESIGNATOR VARCHAR2(10), ALLOW_UPDATES_FLAG NUMBER,PL_ELEMENT_FLAG NUMBER not null,PL_RESOURCE_FLAG NUMBER not null,PL_OPERATION_FLAG NUMBER not null,PL_ACTIVITY_FLAG NUMBER not null,DISABLE_DATE DATE,AVAILABLE_TO_ENG_FLAG NUMBER, COMPONENT_YIELD_FLAG NUMBER not null, ATTRIBUTE_CATEGORY VARCHAR2(30), ATTRIBUTE1 VARCHAR2(150),ATTRIBUTE2 VARCHAR2(150),ATTRIBUTE3 VARCHAR2(150),ATTRIBUTE4 VARCHAR2(150),ATTRIBUTE5 VARCHAR2(150),ATTRIBUTE6 VARCHAR2(150),ATTRIBUTE7 VARCHAR2(150),ATTRIBUTE8 VARCHAR2(150),ATTRIBUTE9 VARCHAR2(150),ATTRIBUTE10 VARCHAR2(150),ATTRIBUTE11 VARCHAR2(150),ATTRIBUTE12 VARCHAR2(150),ATTRIBUTE13 VARCHAR2(150),ATTRIBUTE14 VARCHAR2(150),ATTRIBUTE15 VARCHAR2(150),REQUEST_ID NUMBER,PROGRAM_APPLICATION_ID NUMBER,PROGRAM_ID NUMBER,PROGRAM_UPDATE_DATE DATE)tablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate unique index BOM.CST_COST_TYPES_U1 on BOM.CST_COST_TYPES (COST_TYPE_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create unique index BOM.CST_COST_TYPES_U2 on BOM.CST_COST_TYPES (COST_TYPE, ORGANIZATION_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index on BOM.CST_COST_TYPES to APPS with grant option;grant select on BOM.CST_COST_TYPES to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table HR.HR_ALL_ORGANIZATION_UNITS (ORGANIZATION_ID NUMBER(15) not null, BUSINESS_GROUP_ID NUMBER(15) not null, COST_ALLOCATION_KEYFLEX_ID NUMBER(9), LOCATION_ID NUMBER(15),SOFT_CODING_KEYFLEX_ID NUMBER(15), DATE_FROM DATE not null,NAME VARCHAR2(240) not null,DATE_TO DATE,INTERNAL_EXTERNAL_FLAG VARCHAR2(30), INTERNAL_ADDRESS_LINE VARCHAR2(80), TYPE VARCHAR2(30),REQUEST_ID NUMBER(15),PROGRAM_APPLICATION_ID NUMBER(15), PROGRAM_ID NUMBER(15),PROGRAM_UPDATE_DATE DATE, ATTRIBUTE_CATEGORY VARCHAR2(30), ATTRIBUTE1 VARCHAR2(150),ATTRIBUTE2 VARCHAR2(150),ATTRIBUTE3 VARCHAR2(150),ATTRIBUTE4 VARCHAR2(150),ATTRIBUTE5 VARCHAR2(150),ATTRIBUTE6 VARCHAR2(150),ATTRIBUTE7 VARCHAR2(150),ATTRIBUTE8 VARCHAR2(150),ATTRIBUTE9 VARCHAR2(150),ATTRIBUTE10 VARCHAR2(150),ATTRIBUTE11 VARCHAR2(150),ATTRIBUTE12 VARCHAR2(150),ATTRIBUTE13 VARCHAR2(150),ATTRIBUTE14 VARCHAR2(150),ATTRIBUTE15 VARCHAR2(150),ATTRIBUTE16 VARCHAR2(150),ATTRIBUTE17 VARCHAR2(150),ATTRIBUTE18 VARCHAR2(150),ATTRIBUTE19 VARCHAR2(150),ATTRIBUTE20 VARCHAR2(150),LAST_UPDATE_DATE DATE,LAST_UPDATED_BY NUMBER(15),LAST_UPDATE_LOGIN NUMBER(15),CREATED_BY NUMBER(15),CREATION_DATE DATE,OBJECT_VERSION_NUMBER NUMBER(9),PARTY_ID NUMBER(15),COMMENTS LONG)tablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate primary, unique and foreign key constraintsalter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_PK primary key (ORGANIZATION_ID) using indextablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_UK2 unique (NAME,BUSINESS_GROUP_ID)using indextablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK1 foreign key(BUSINESS_GROUP_ID)references HR.HR_ALL_ORGANIZATION_UNITS (ORGANIZATION_ID); alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK2 foreign key(COST_ALLOCATION_KEYFLEX_ID)references HR.PAY_COST_ALLOCATION_KEYFLEX(COST_ALLOCATION_KEYFLEX_ID);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK3 foreign key (LOCATION_ID) references HR.HR_LOCATIONS_ALL (LOCATION_ID);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK4 foreign key(SOFT_CODING_KEYFLEX_ID)references HR.HR_ALL_ORGANIZATION_UNITS (ORGANIZATION_ID);-- Create/Recreate check constraintsalter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_OU_INTERNAL_EXTERNAL_FL_CHKcheck (INTERNAL_EXTERNAL_FLAG IN ('INT', 'EXT'));-- Create/Recreate indexescreate index HR.HR_ORGANIZATION_UNITS_FK1 onHR.HR_ALL_ORGANIZATION_UNITS (BUSINESS_GROUP_ID) tablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index HR.HR_ORGANIZATION_UNITS_FK2 onHR.HR_ALL_ORGANIZATION_UNITS (COST_ALLOCATION_KEYFLEX_ID) tablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index HR.HR_ORGANIZATION_UNITS_FK3 onHR.HR_ALL_ORGANIZATION_UNITS (LOCATION_ID)tablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index HR.HR_ORGANIZATION_UNITS_FK4 onHR.HR_ALL_ORGANIZATION_UNITS (SOFT_CODING_KEYFLEX_ID) tablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onHR.HR_ALL_ORGANIZATION_UNITS to APPS with grant option;grant select on HR.HR_ALL_ORGANIZATION_UNITS to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_ONHAND_QUANTITIES_DETAIL (INVENTORY_ITEM_ID NUMBER not null, ORGANIZATION_ID NUMBER not null,DATE_RECEIVED DATE,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null,CREATION_DATE DATE not null,CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER,PRIMARY_TRANSACTION_QUANTITY NUMBER not null, SUBINVENTORY_CODE VARCHAR2(10) not null, REVISION VARCHAR2(3),LOCATOR_ID NUMBER,CREATE_TRANSACTION_ID NUMBER,UPDATE_TRANSACTION_ID NUMBER,LOT_NUMBER VARCHAR2(30),ORIG_DATE_RECEIVED DATE,COST_GROUP_ID NUMBER,CONTAINERIZED_FLAG NUMBER,PROJECT_ID NUMBER,TASK_ID NUMBER,ONHAND_QUANTITIES_ID NUMBER not null, ORGANIZATION_TYPE NUMBER not null,OWNING_ORGANIZATION_ID NUMBER not null, OWNING_TP_TYPE NUMBER not null,PLANNING_ORGANIZATION_ID NUMBER not null, PLANNING_TP_TYPE NUMBER not null, TRANSACTION_UOM_CODE VARCHAR2(3) not null, TRANSACTION_QUANTITY NUMBER not null, SECONDARY_UOM_CODE VARCHAR2(3), SECONDARY_TRANSACTION_QUANTITY NUMBER,IS_CONSIGNED NUMBER not null,LPN_ID NUMBERtablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate index INV.MTL_ONHAND_QUANTITIES_N4 onINV.MTL_ONHAND_QUANTITIES_DETAIL (INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE,PRIMARY_TRANSACTION_QUANTITY)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_ONHAND_QUANTITIES_N5 onINV.MTL_ONHAND_QUANTITIES_DETAIL (ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID, LPN_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_ONHAND_QUANTITIES_N6 onINV.MTL_ONHAND_QUANTITIES_DETAIL (ORGANIZATION_ID, INVENTORY_ITEM_ID, COST_GROUP_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onINV.MTL_ONHAND_QUANTITIES_DETAIL to APPS with grant option;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_SECONDARY_INVENTORIES(SECONDARY_INVENTORY_NAME VARCHAR2(10) not null, ORGANIZATION_ID NUMBER not null,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null,CREATION_DATE DATE not null,CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER,DESCRIPTION VARCHAR2(50),DISABLE_DATE DATE,INVENTORY_ATP_CODE NUMBER not null, AVAILABILITY_TYPE NUMBER not null,RESERVABLE_TYPE NUMBER not null,LOCATOR_TYPE NUMBER,PICKING_ORDER NUMBER,MATERIAL_ACCOUNT NUMBER,MATERIAL_OVERHEAD_ACCOUNT NUMBER, RESOURCE_ACCOUNT NUMBER,OVERHEAD_ACCOUNT NUMBER,OUTSIDE_PROCESSING_ACCOUNT NUMBER, QUANTITY_TRACKED NUMBER not null,ASSET_INVENTORY NUMBER not null,SOURCE_TYPE NUMBER,SOURCE_SUBINVENTORY VARCHAR2(10),SOURCE_ORGANIZATION_ID NUMBER,REQUISITION_APPROVAL_TYPE NUMBER,EXPENSE_ACCOUNT NUMBER,ENCUMBRANCE_ACCOUNT NUMBER,ATTRIBUTE_CATEGORY VARCHAR2(30),ATTRIBUTE1 VARCHAR2(150),ATTRIBUTE2 VARCHAR2(150),ATTRIBUTE3 VARCHAR2(150),ATTRIBUTE4 VARCHAR2(150),。
OracleERP各模块之间表关系
•FND_CPS: FND_CONCURRENT_PROCESSORS FND_CQS: FND_CONCURRENT_QUEUE_SIZE
•FND_CTP: FND_CONCURRENT_TIME_PERIODS FND_APP:FND_APPLICATION
学习改变命运,知 识创造未来
OracleERP各模块之间表关系
•FND_CD:FND_CONFLICT_DOMAINS
FND_RES:FND_RESPONSIBILY
•FND_CRC:FND_CONC_RELEASE_CLASSES FND_DGU:FND_DATA_GROUP_UNITS
•FND_LOG:FND_LOGINS
FND_DG:FND_DATA_GROUPS
在制品(WIP)
学习改变命运,知 识创造未来
OracleERP各模块之间表关系
在制品(WIP)
学习改变命运,知 识创造未来
OracleERP各模块之间表关系
在制品(WIP)
学习改变命运,知 识创造未来
OracleERP各模块之间表关系
在制品(WIP)
学习改变命运,知 识创造未来
OracleERP各模块之间表关系
OracleERP各模块之间表关系
订单管理(OM)
•WSH_DELIVERY_DETAILS •WSH_DELIVERY_ASSIGNMENTS
•WSH_TRIPS •WSH_TRIP_STOPS •WSH_DELIVERY_LEGS •WSH_NEW_DELIVERIES
学习改变命运,知 识创造未来
学习改变命运,知 识创造未来
OracleERP各模块之间表关系
并发管理器
学习改变命运,知 识创造未来
oracleERP各模块数据库表关系
供应链模块：包括采购、库存、销售等子模块
生产模块：包括生产计划、车间管理、质量管理等子模块
人力资源模块：包括员工管理、薪资管理、考勤管理等子 模块
项目管理模块：包括项目计划、项目执行、项目监控等子 模块
客户关系管理模块：包括客户信息管理、销售机会管理、 合同管理等子模块
库存表：记录库存相关信息，包括库存 数量、库存位置、库存状态等。
生产进度表：记录生产进度相关信息， 包括生产完成情况、生产时间等。
采购表：记录采购相关信息，包括采购订 单、采购数量、采购时间等。
质量检验表：记录质量检验相关信息， 包括检验结果、检验时间等。
人力资源模块数据库表关系详细解析
员工信息表：记录员 工的基本信息，如姓 名、性别、出生日期
绩效评估表：记录员 工的绩效评估信息， 如评估指标、评估结
果等。
OracleERP各模块据库表关 系优化建议
财务模块数据库表关系优化建议
合并冗余数据表： 减少数据冗余， 提高数据一致性
优化表结构：根据 业务需求调整字段 和数据类型，提高 数据存储效率
建立索引：提高 查询速度，减少 查询时间
定期维护：定期 清理过期数据， 保持数据表健康 状态
培训信息表：存储员工的培训信息，如培训课程、培训时 间等。
OracleERP各模块数据库表关 系详细解析
财务模块数据库表关系详细解析
财务模块主要涉及的表：总账表、明细账表、现金流量表等 各表之间的关系：通过主键、外键等建立联系 财务模块与其他模块的交互：如与供应链、生产等模块的数据交互 财务模块的表结构与功能：详细介绍各表的字段、含义及作用
优化数据结构：根据 实际业务需求，调整 表结构和字段类型， 使数据结构更加合理。
OracleERP-库存管理
库存核心业务库存管理的核心是对货物本身的管理，是对货物的数量与相关属性的管理，目的是为销售与采购服务，确保合理的库存保有量，处理库存分类帐目与进出流水帐，以单据的形式基本涵盖仓库的各种进出库业务。
库存组织结构组织是一种业务单位，例如：公司、工厂、仓库、分部和部门等，组织可以根据实际业务不同分成多种层次，例如：法人实体，经营单位，库存组织等。
库存组织是建立在经营单位之下的，可以细分为不同的子库存。
特别的是项目主组织，是专门为了统一定义库存物品而设立的，可以是一个虚拟的并不存在的组织，对应实际仓库。
子库存是从物料库存中分离出来的独特的物理或逻辑库存，如原材料、成品或不良品的独自存货位置，客户虚拟仓等，货位是存储物料的子库存内的实际区域，例如：行、通道、存料箱或货架。
组织中的所有物料均保留在子库存中，因此必须至少定义一个子库存。
一个OU下可以有多个IO，一个IO下可以设置多个子库，每个子库下可以设置多个货位。
Oracle产品按照不同的组织层次分别进行安全性的控制。
总帐按照帐套进行数据屏蔽，而销售/应收/采购/应付是典型的按照经营单位进行管理，库存/物料清单/车间则是按照库存组织分别管理。
库存组织用来屏蔽各类制造数据，Item/BOM/Routing等定义在库存组织上，WIP/MRP等跑在库存组织上；而库存事务处理则以子库存为中心，要么从某个子库存出，要么从某个子库存入；每个子库存可以启用货位，也可以不启用；如果启用了，则事务处理时必须选择货位。
在不同的库存内，子库代码可以重复；在不同的子库内，货位代码也可以重复。
也就是说，Oracle仅仅是提供了这样的模型，至于如何和实际业务对用，就非常灵活了。
比如：库存是个组织的概念，其比较“虚”，可指一个工厂或者独立的办事处、分公司这样的实体；而子库则通常代表一个真正的物理仓库，也可指仓库或者车间的一块区域，还可以是虚拟的；货位可用来代表仓库的某一处空间或者货架，也可指车间的一个块区域。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
Oracle_ERP_库存管理INV_8个表结构下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_TRANSACTION_TYPES(TRANSACTION_TYPE_ID NUMBER not null,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null,CREATION_DATE DATE not null,CREATED_BY NUMBER not null,TRANSACTION_TYPE_NAME VARCHAR2(80) not null, DESCRIPTION VARCHAR2(240),TRANSACTION_ACTION_ID NUMBER not null, TRANSACTION_SOURCE_TYPE_ID NUMBER not null, SHORTAGE_MSG_BACKGROUND_FLAG VARCHAR2(1), SHORTAGE_MSG_ONLINE_FLAG VARCHAR2(1), DISABLE_DATE DATE,USER_DEFINED_FLAG VARCHAR2(1) not null, ATTRIBUTE1 VARCHAR2(150),ATTRIBUTE2 VARCHAR2(150),ATTRIBUTE3 VARCHAR2(150),ATTRIBUTE4 VARCHAR2(150),ATTRIBUTE5 VARCHAR2(150),ATTRIBUTE6 VARCHAR2(150),ATTRIBUTE7 VARCHAR2(150),ATTRIBUTE8 VARCHAR2(150),ATTRIBUTE9 VARCHAR2(150),ATTRIBUTE10 VARCHAR2(150),ATTRIBUTE11 VARCHAR2(150),ATTRIBUTE12 VARCHAR2(150),ATTRIBUTE13 VARCHAR2(150),ATTRIBUTE14 VARCHAR2(150),ATTRIBUTE15 VARCHAR2(150),ATTRIBUTE_CATEGORY VARCHAR2(30),TYPE_CLASS NUMBER,STATUS_CONTROL_FLAG NUMBER)tablespace APPS_TS_SEEDpctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate index INV.MTL_TRANSACTION_TYPES_N1 onINV.MTL_TRANSACTION_TYPES (TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID)tablespace APPS_TS_SEEDpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create unique index INV.MTL_TRANSACTION_TYPES_U1 onINV.MTL_TRANSACTION_TYPES (TRANSACTION_TYPE_ID) tablespace APPS_TS_SEEDpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onINV.MTL_TRANSACTION_TYPES to APPS with grant option;grant select on INV.MTL_TRANSACTION_TYPES to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_SYSTEM_ITEMS_B (INVENTORY_ITEM_ID NUMBER not null, ORGANIZATION_ID NUMBER not null, LAST_UPDATE_DATE DATE not null, LAST_UPDATED_BY NUMBER not null, CREATION_DATE DATE not null, CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER, SUMMARY_FLAG VARCHAR2(1) not null, ENABLED_FLAG VARCHAR2(1) not null,START_DATE_ACTIVE DATE,END_DATE_ACTIVE DATE,DESCRIPTION VARCHAR2(240),BUYER_ID NUMBER(9),ACCOUNTING_RULE_ID NUMBER, INVOICING_RULE_ID NUMBER, SEGMENT1 VARCHAR2(40),SEGMENT2 VARCHAR2(40),SEGMENT3 VARCHAR2(40),SEGMENT4 VARCHAR2(40),SEGMENT5 VARCHAR2(40),SEGMENT6 VARCHAR2(40),SEGMENT7 VARCHAR2(40),SEGMENT8 VARCHAR2(40),SEGMENT9 VARCHAR2(40),SEGMENT10 VARCHAR2(40),SEGMENT11 VARCHAR2(40),SEGMENT12 VARCHAR2(40),SEGMENT13 VARCHAR2(40),SEGMENT14 VARCHAR2(40),SEGMENT15 VARCHAR2(40),SEGMENT16 VARCHAR2(40),SEGMENT17 VARCHAR2(40),SEGMENT18 VARCHAR2(40),SEGMENT19 VARCHAR2(40),SEGMENT20 VARCHAR2(40),ATTRIBUTE_CATEGORY VARCHAR2(30),ATTRIBUTE1 VARCHAR2(240),ATTRIBUTE2 VARCHAR2(240),ATTRIBUTE3 VARCHAR2(240),ATTRIBUTE4 VARCHAR2(240),ATTRIBUTE5 VARCHAR2(240),ATTRIBUTE6 VARCHAR2(240),ATTRIBUTE7 VARCHAR2(240),ATTRIBUTE8 VARCHAR2(240),ATTRIBUTE9 VARCHAR2(240),ATTRIBUTE10 VARCHAR2(240),ATTRIBUTE11 VARCHAR2(240),ATTRIBUTE12 VARCHAR2(240),ATTRIBUTE13 VARCHAR2(240),ATTRIBUTE14 VARCHAR2(240),ATTRIBUTE15 VARCHAR2(240),PURCHASING_ITEM_FLAG VARCHAR2(1) not null, SHIPPABLE_ITEM_FLAG VARCHAR2(1) not null,CUSTOMER_ORDER_FLAG VARCHAR2(1) not null,INTERNAL_ORDER_FLAG VARCHAR2(1) not null,SERVICE_ITEM_FLAG VARCHAR2(1) not null,INVENTORY_ITEM_FLAG VARCHAR2(1) not null,ENG_ITEM_FLAG VARCHAR2(1) not null,INVENTORY_ASSET_FLAG VARCHAR2(1) not null, PURCHASING_ENABLED_FLAG VARCHAR2(1) not null, CUSTOMER_ORDER_ENABLED_FLAG VARCHAR2(1) not null, INTERNAL_ORDER_ENABLED_FLAG VARCHAR2(1) not null, SO_TRANSACTIONS_FLAG VARCHAR2(1) not null,MTL_TRANSACTIONS_ENABLED_FLAG VARCHAR2(1) not null, STOCK_ENABLED_FLAG VARCHAR2(1) not null,BOM_ENABLED_FLAG VARCHAR2(1) not null,BUILD_IN_WIP_FLAG VARCHAR2(1) not null,REVISION_QTY_CONTROL_CODE NUMBER,ITEM_CATALOG_GROUP_ID NUMBER,CATALOG_STATUS_FLAG VARCHAR2(1),RETURNABLE_FLAG VARCHAR2(1),DEFAULT_SHIPPING_ORG NUMBER,COLLATERAL_FLAG VARCHAR2(1),TAXABLE_FLAG VARCHAR2(1),QTY_RCV_EXCEPTION_CODE VARCHAR2(25),ALLOW_ITEM_DESC_UPDATE_FLAG VARCHAR2(1),INSPECTION_REQUIRED_FLAG VARCHAR2(1), RECEIPT_REQUIRED_FLAG VARCHAR2(1),MARKET_PRICE NUMBER,HAZARD_CLASS_ID NUMBER,RFQ_REQUIRED_FLAG VARCHAR2(1),QTY_RCV_TOLERANCE NUMBER,LIST_PRICE_PER_UNIT NUMBER,UN_NUMBER_ID NUMBER,PRICE_TOLERANCE_PERCENT NUMBER,ASSET_CATEGORY_ID NUMBER,ROUNDING_FACTOR NUMBER,UNIT_OF_ISSUE VARCHAR2(25),ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2(25), ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2(1), ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2(1), ALLOW_EXPRESS_DELIVERY_FLAG VARCHAR2(1), DAYS_EARLY_RECEIPT_ALLOWED NUMBER,DAYS_LATE_RECEIPT_ALLOWED NUMBER,RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2(25), RECEIVING_ROUTING_ID NUMBER,INVOICE_CLOSE_TOLERANCE NUMBER,RECEIVE_CLOSE_TOLERANCE NUMBER,AUTO_LOT_ALPHA_PREFIX VARCHAR2(30),START_AUTO_LOT_NUMBER VARCHAR2(30),LOT_CONTROL_CODE NUMBER,SHELF_LIFE_CODE NUMBER,SHELF_LIFE_DAYS NUMBER,SERIAL_NUMBER_CONTROL_CODE NUMBER,START_AUTO_SERIAL_NUMBER VARCHAR2(30), AUTO_SERIAL_ALPHA_PREFIX VARCHAR2(30), SOURCE_TYPE NUMBER,SOURCE_ORGANIZATION_ID NUMBER,SOURCE_SUBINVENTORY VARCHAR2(10),EXPENSE_ACCOUNT NUMBER,ENCUMBRANCE_ACCOUNT NUMBER,RESTRICT_SUBINVENTORIES_CODE NUMBER,UNIT_WEIGHT NUMBER,WEIGHT_UOM_CODE VARCHAR2(3),VOLUME_UOM_CODE VARCHAR2(3),UNIT_VOLUME NUMBER,RESTRICT_LOCATORS_CODE NUMBER,LOCATION_CONTROL_CODE NUMBER,SHRINKAGE_RATE NUMBER,ACCEPTABLE_EARLY_DAYS NUMBER,PLANNING_TIME_FENCE_CODE NUMBER,DEMAND_TIME_FENCE_CODE NUMBER,LEAD_TIME_LOT_SIZE NUMBER,STD_LOT_SIZE NUMBER,CUM_MANUFACTURING_LEAD_TIME NUMBER, OVERRUN_PERCENTAGE NUMBER,MRP_CALCULATE_ATP_FLAG VARCHAR2(1), ACCEPTABLE_RATE_INCREASE NUMBER, ACCEPTABLE_RATE_DECREASE NUMBER, CUMULATIVE_TOTAL_LEAD_TIME NUMBER, PLANNING_TIME_FENCE_DAYS NUMBER,DEMAND_TIME_FENCE_DAYS NUMBER,END_ASSEMBLY_PEGGING_FLAG VARCHAR2(1), REPETITIVE_PLANNING_FLAG VARCHAR2(1), PLANNING_EXCEPTION_SET VARCHAR2(10),BOM_ITEM_TYPE NUMBER not null,PICK_COMPONENTS_FLAG VARCHAR2(1) not null, REPLENISH_TO_ORDER_FLAG VARCHAR2(1) not null, BASE_ITEM_ID NUMBER,ATP_COMPONENTS_FLAG VARCHAR2(1) not null,ATP_FLAG VARCHAR2(1) not null,FIXED_LEAD_TIME NUMBER,VARIABLE_LEAD_TIME NUMBER,WIP_SUPPLY_LOCATOR_ID NUMBER,WIP_SUPPLY_TYPE NUMBER,WIP_SUPPLY_SUBINVENTORY VARCHAR2(10),PRIMARY_UOM_CODE VARCHAR2(3),PRIMARY_UNIT_OF_MEASURE VARCHAR2(25), ALLOWED_UNITS_LOOKUP_CODE NUMBER,COST_OF_SALES_ACCOUNT NUMBER,SALES_ACCOUNT NUMBER,DEFAULT_INCLUDE_IN_ROLLUP_FLAG VARCHAR2(1), INVENTORY_ITEM_STATUS_CODE VARCHAR2(10) not null, INVENTORY_PLANNING_CODE NUMBER,PLANNER_CODE VARCHAR2(10),PLANNING_MAKE_BUY_CODE NUMBER,FIXED_LOT_MULTIPLIER NUMBER,ROUNDING_CONTROL_TYPE NUMBER,CARRYING_COST NUMBER,POSTPROCESSING_LEAD_TIME NUMBER, PREPROCESSING_LEAD_TIME NUMBER,FULL_LEAD_TIME NUMBER,ORDER_COST NUMBER,MRP_SAFETY_STOCK_PERCENT NUMBER,MRP_SAFETY_STOCK_CODE NUMBER,MIN_MINMAX_QUANTITY NUMBER,MAX_MINMAX_QUANTITY NUMBER,MINIMUM_ORDER_QUANTITY NUMBER,FIXED_ORDER_QUANTITY NUMBER,FIXED_DAYS_SUPPLY NUMBER,MAXIMUM_ORDER_QUANTITY NUMBER,ATP_RULE_ID NUMBER,PICKING_RULE_ID NUMBER,RESERVABLE_TYPE NUMBER,POSITIVE_MEASUREMENT_ERROR NUMBER,NEGATIVE_MEASUREMENT_ERROR NUMBER, ENGINEERING_ECN_CODE VARCHAR2(50),ENGINEERING_ITEM_ID NUMBER,ENGINEERING_DATE DATE,SERVICE_STARTING_DELAY NUMBER,VENDOR_WARRANTY_FLAG VARCHAR2(1) not null, SERVICEABLE_COMPONENT_FLAG VARCHAR2(1), SERVICEABLE_PRODUCT_FLAG VARCHAR2(1) not null,BASE_WARRANTY_SERVICE_ID NUMBER,PAYMENT_TERMS_ID NUMBER,PREVENTIVE_MAINTENANCE_FLAG VARCHAR2(1), PRIMARY_SPECIALIST_ID NUMBER,SECONDARY_SPECIALIST_ID NUMBER,SERVICEABLE_ITEM_CLASS_ID NUMBER,TIME_BILLABLE_FLAG VARCHAR2(1),MATERIAL_BILLABLE_FLAG VARCHAR2(30),EXPENSE_BILLABLE_FLAG VARCHAR2(1),PRORATE_SERVICE_FLAG VARCHAR2(1),COVERAGE_SCHEDULE_ID NUMBER,SERVICE_DURATION_PERIOD_CODE VARCHAR2(10), SERVICE_DURATION NUMBER,WARRANTY_VENDOR_ID NUMBER,MAX_WARRANTY_AMOUNT NUMBER,RESPONSE_TIME_PERIOD_CODE VARCHAR2(30), RESPONSE_TIME_VALUE NUMBER,NEW_REVISION_CODE VARCHAR2(30),INVOICEABLE_ITEM_FLAG VARCHAR2(1) not null,TAX_CODE VARCHAR2(50),INVOICE_ENABLED_FLAG VARCHAR2(1) not null,MUST_USE_APPROVED_VENDOR_FLAG VARCHAR2(1) not null, REQUEST_ID NUMBER,PROGRAM_APPLICATION_ID NUMBER,PROGRAM_ID NUMBER,PROGRAM_UPDATE_DATE DATE,OUTSIDE_OPERATION_FLAG VARCHAR2(1) not null, OUTSIDE_OPERATION_UOM_TYPE VARCHAR2(25),SAFETY_STOCK_BUCKET_DAYS NUMBER,AUTO_REDUCE_MPS NUMBER(22),COSTING_ENABLED_FLAG VARCHAR2(1) not null,AUTO_CREATED_CONFIG_FLAG VARCHAR2(1) not null, CYCLE_COUNT_ENABLED_FLAG VARCHAR2(1) not null, ITEM_TYPE VARCHAR2(30),MODEL_CONFIG_CLAUSE_NAME VARCHAR2(10), SHIP_MODEL_COMPLETE_FLAG VARCHAR2(1),MRP_PLANNING_CODE NUMBER,RETURN_INSPECTION_REQUIREMENT NUMBER,ATO_FORECAST_CONTROL NUMBER,RELEASE_TIME_FENCE_CODE NUMBER,RELEASE_TIME_FENCE_DAYS NUMBER,CONTAINER_ITEM_FLAG VARCHAR2(1),VEHICLE_ITEM_FLAG VARCHAR2(1),MAXIMUM_LOAD_WEIGHT NUMBER,MINIMUM_FILL_PERCENT NUMBER,CONTAINER_TYPE_CODE VARCHAR2(30),INTERNAL_VOLUME NUMBER,WH_UPDATE_DATE DATE,PRODUCT_FAMILY_ITEM_ID NUMBER,GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(150), GLOBAL_ATTRIBUTE1 VARCHAR2(150),GLOBAL_ATTRIBUTE2 VARCHAR2(150),GLOBAL_ATTRIBUTE3 VARCHAR2(150),GLOBAL_ATTRIBUTE4 VARCHAR2(150),GLOBAL_ATTRIBUTE5 VARCHAR2(150),GLOBAL_ATTRIBUTE6 VARCHAR2(150),GLOBAL_ATTRIBUTE7 VARCHAR2(150),GLOBAL_ATTRIBUTE8 VARCHAR2(150),GLOBAL_ATTRIBUTE9 VARCHAR2(150),GLOBAL_ATTRIBUTE10 VARCHAR2(150), PURCHASING_TAX_CODE VARCHAR2(50), OVERCOMPLETION_TOLERANCE_TYPE NUMBER, OVERCOMPLETION_TOLERANCE_VALUE NUMBER, EFFECTIVITY_CONTROL NUMBER,CHECK_SHORTAGES_FLAG VARCHAR2(1),OVER_SHIPMENT_TOLERANCE NUMBER,UNDER_SHIPMENT_TOLERANCE NUMBER,OVER_RETURN_TOLERANCE NUMBER,UNDER_RETURN_TOLERANCE NUMBER, EQUIPMENT_TYPE NUMBER,RECOVERED_PART_DISP_CODE VARCHAR2(30), DEFECT_TRACKING_ON_FLAG VARCHAR2(1),USAGE_ITEM_FLAG VARCHAR2(1),EVENT_FLAG VARCHAR2(1),ELECTRONIC_FLAG VARCHAR2(1), DOWNLOADABLE_FLAG VARCHAR2(1),VOL_DISCOUNT_EXEMPT_FLAG VARCHAR2(1),COUPON_EXEMPT_FLAG VARCHAR2(1),COMMS_NL_TRACKABLE_FLAG VARCHAR2(1), ASSET_CREATION_CODE VARCHAR2(30), COMMS_ACTIVATION_REQD_FLAG VARCHAR2(1), ORDERABLE_ON_WEB_FLAG VARCHAR2(1), BACK_ORDERABLE_FLAG VARCHAR2(1),WEB_STATUS VARCHAR2(30),INDIVISIBLE_FLAG VARCHAR2(1),DIMENSION_UOM_CODE VARCHAR2(3),UNIT_LENGTH NUMBER,UNIT_WIDTH NUMBER,UNIT_HEIGHT NUMBER,BULK_PICKED_FLAG VARCHAR2(1),LOT_STATUS_ENABLED VARCHAR2(1),DEFAULT_LOT_STATUS_ID NUMBER,SERIAL_STATUS_ENABLED VARCHAR2(1), DEFAULT_SERIAL_STATUS_ID NUMBER,LOT_SPLIT_ENABLED VARCHAR2(1),LOT_MERGE_ENABLED VARCHAR2(1), INVENTORY_CARRY_PENALTY NUMBER, OPERATION_SLACK_PENALTY NUMBER, FINANCING_ALLOWED_FLAG VARCHAR2(1),EAM_ITEM_TYPE NUMBER,EAM_ACTIVITY_TYPE_CODE VARCHAR2(30),EAM_ACTIVITY_CAUSE_CODE VARCHAR2(30), EAM_ACT_NOTIFICATION_FLAG VARCHAR2(1), EAM_ACT_SHUTDOWN_STATUS VARCHAR2(30), DUAL_UOM_CONTROL NUMBER,SECONDARY_UOM_CODE VARCHAR2(3),DUAL_UOM_DEVIATION_HIGH NUMBER,DUAL_UOM_DEVIATION_LOW NUMBER, CONTRACT_ITEM_TYPE_CODE VARCHAR2(30), SUBSCRIPTION_DEPEND_FLAG VARCHAR2(1), SERV_REQ_ENABLED_CODE VARCHAR2(30), SERV_BILLING_ENABLED_FLAG VARCHAR2(1), SERV_IMPORTANCE_LEVEL NUMBER,PLANNED_INV_POINT_FLAG VARCHAR2(1),LOT_TRANSLATE_ENABLED VARCHAR2(1), DEFAULT_SO_SOURCE_TYPE VARCHAR2(30), CREATE_SUPPLY_FLAG VARCHAR2(1), SUBSTITUTION_WINDOW_CODE NUMBER, SUBSTITUTION_WINDOW_DAYS NUMBER,IB_ITEM_INSTANCE_CLASS VARCHAR2(30), CONFIG_MODEL_TYPE VARCHAR2(30),LOT_SUBSTITUTION_ENABLED VARCHAR2(1), MINIMUM_LICENSE_QUANTITY NUMBER,EAM_ACTIVITY_SOURCE_CODE VARCHAR2(30), LIFECYCLE_ID NUMBER,CURRENT_PHASE_ID NUMBER,OBJECT_VERSION_NUMBER NUMBER(9), TRACKING_QUANTITY_IND VARCHAR2(30), ONT_PRICING_QTY_SOURCE VARCHAR2(30), SECONDARY_DEFAULT_IND VARCHAR2(30), OPTION_SPECIFIC_SOURCED NUMBER, APPROVAL_STATUS VARCHAR2(30),VMI_MINIMUM_UNITS NUMBER,VMI_MINIMUM_DAYS NUMBER,VMI_MAXIMUM_UNITS NUMBER,VMI_MAXIMUM_DAYS NUMBER,VMI_FIXED_ORDER_QUANTITY NUMBER,SO_AUTHORIZATION_FLAG NUMBER, CONSIGNED_FLAG NUMBER,ASN_AUTOEXPIRE_FLAG NUMBER,VMI_FORECAST_TYPE NUMBER,FORECAST_HORIZON NUMBER,EXCLUDE_FROM_BUDGET_FLAG NUMBER, DAYS_TGT_INV_SUPPLY NUMBER,DAYS_TGT_INV_WINDOW NUMBER,DAYS_MAX_INV_SUPPLY NUMBER,DAYS_MAX_INV_WINDOW NUMBER,DRP_PLANNED_FLAG NUMBER,CRITICAL_COMPONENT_FLAG NUMBER, CONTINOUS_TRANSFER NUMBER, CONVERGENCE NUMBER,DIVERGENCE NUMBER,CONFIG_ORGS VARCHAR2(30),CONFIG_MATCH VARCHAR2(30))tablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate index INV.MTL_SYSTEM_ITEMS_B_N1 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, SEGMENT1) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N10 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, PLANNER_CODE) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N11 onINV.MTL_SYSTEM_ITEMS_B (WEB_STATUS, ORGANIZATION_ID) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N12 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID,CUSTOMER_ORDER_ENABLED_FLAG, SERVICE_ITEM_FLAG, VENDOR_WARRANTY_FLAG)tablespace APPS_TS_TX_IDXinitrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N13 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID,WIP_SUPPLY_LOCATOR_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N14 onINV.MTL_SYSTEM_ITEMS_B (BASE_ITEM_ID, ORGANIZATION_ID) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N2 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, DESCRIPTION) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N3 onINV.MTL_SYSTEM_ITEMS_B (INVENTORY_ITEM_STATUS_CODE) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N4 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID,AUTO_CREATED_CONFIG_FLAG)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N5 onINV.MTL_SYSTEM_ITEMS_B (WH_UPDATE_DATE)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N6 onINV.MTL_SYSTEM_ITEMS_B (ITEM_CATALOG_GROUP_ID, CATALOG_STATUS_FLAG)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N7 onINV.MTL_SYSTEM_ITEMS_B (PRODUCT_FAMILY_ITEM_ID, ORGANIZATION_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N8 onINV.MTL_SYSTEM_ITEMS_B (COMMS_NL_TRACKABLE_FLAG, ORGANIZATION_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kmaxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N9 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, BUYER_ID) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create unique index INV.MTL_SYSTEM_ITEMS_B_U1 onINV.MTL_SYSTEM_ITEMS_B (INVENTORY_ITEM_ID, ORGANIZATION_ID) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onINV.MTL_SYSTEM_ITEMS_B to APPS with grant option;grant select on INV.MTL_SYSTEM_ITEMS_B to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table BOM.CST_COST_TYPES(COST_TYPE_ID NUMBER not null,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null, CREATION_DATE DATE not null,CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER, ORGANIZATION_ID NUMBER,COST_TYPE VARCHAR2(10) not null, DESCRIPTION VARCHAR2(240),COSTING_METHOD_TYPE NUMBER not null, FROZEN_STANDARD_FLAG NUMBER,DEFAULT_COST_TYPE_ID NUMBER not null, BOM_SNAPSHOT_FLAG NUMBER not null, ALTERNATE_BOM_DESIGNATOR VARCHAR2(10), ALLOW_UPDATES_FLAG NUMBER,PL_ELEMENT_FLAG NUMBER not null,PL_RESOURCE_FLAG NUMBER not null,PL_OPERATION_FLAG NUMBER not null,PL_ACTIVITY_FLAG NUMBER not null,DISABLE_DATE DATE,AVAILABLE_TO_ENG_FLAG NUMBER, COMPONENT_YIELD_FLAG NUMBER not null, ATTRIBUTE_CATEGORY VARCHAR2(30), ATTRIBUTE1 VARCHAR2(150),ATTRIBUTE2 VARCHAR2(150),ATTRIBUTE3 VARCHAR2(150),ATTRIBUTE4 VARCHAR2(150),ATTRIBUTE5 VARCHAR2(150),ATTRIBUTE6 VARCHAR2(150),ATTRIBUTE7 VARCHAR2(150),ATTRIBUTE8 VARCHAR2(150),ATTRIBUTE9 VARCHAR2(150),ATTRIBUTE10 VARCHAR2(150),ATTRIBUTE11 VARCHAR2(150),ATTRIBUTE12 VARCHAR2(150),ATTRIBUTE13 VARCHAR2(150),ATTRIBUTE14 VARCHAR2(150),ATTRIBUTE15 VARCHAR2(150),REQUEST_ID NUMBER,PROGRAM_APPLICATION_ID NUMBER,PROGRAM_ID NUMBER,PROGRAM_UPDATE_DATE DATE)tablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate unique index BOM.CST_COST_TYPES_U1 on BOM.CST_COST_TYPES (COST_TYPE_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create unique index BOM.CST_COST_TYPES_U2 on BOM.CST_COST_TYPES (COST_TYPE, ORGANIZATION_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onBOM.CST_COST_TYPES to APPS with grant option;grant select on BOM.CST_COST_TYPES to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table HR.HR_ALL_ORGANIZATION_UNITS (ORGANIZATION_ID NUMBER(15) not null, BUSINESS_GROUP_ID NUMBER(15) not null, COST_ALLOCATION_KEYFLEX_ID NUMBER(9), LOCATION_ID NUMBER(15),SOFT_CODING_KEYFLEX_ID NUMBER(15), DATE_FROM DATE not null,NAME VARCHAR2(240) not null,DATE_TO DATE,INTERNAL_EXTERNAL_FLAG VARCHAR2(30), INTERNAL_ADDRESS_LINE VARCHAR2(80), TYPE VARCHAR2(30),REQUEST_ID NUMBER(15),PROGRAM_APPLICATION_ID NUMBER(15), PROGRAM_ID NUMBER(15),PROGRAM_UPDATE_DATE DATE, ATTRIBUTE_CATEGORY VARCHAR2(30), ATTRIBUTE1 VARCHAR2(150),ATTRIBUTE2 VARCHAR2(150),ATTRIBUTE3 VARCHAR2(150),ATTRIBUTE4 VARCHAR2(150),ATTRIBUTE5 VARCHAR2(150),ATTRIBUTE6 VARCHAR2(150),ATTRIBUTE7 VARCHAR2(150),ATTRIBUTE8 VARCHAR2(150),ATTRIBUTE9 VARCHAR2(150),ATTRIBUTE10 VARCHAR2(150),ATTRIBUTE11 VARCHAR2(150),ATTRIBUTE12 VARCHAR2(150),ATTRIBUTE13 VARCHAR2(150),ATTRIBUTE14 VARCHAR2(150),ATTRIBUTE15 VARCHAR2(150),ATTRIBUTE16 VARCHAR2(150),ATTRIBUTE17 VARCHAR2(150),ATTRIBUTE18 VARCHAR2(150),ATTRIBUTE19 VARCHAR2(150),ATTRIBUTE20 VARCHAR2(150),LAST_UPDATE_DATE DATE,LAST_UPDATED_BY NUMBER(15),LAST_UPDATE_LOGIN NUMBER(15),CREATED_BY NUMBER(15),CREATION_DATE DATE,OBJECT_VERSION_NUMBER NUMBER(9),PARTY_ID NUMBER(15),COMMENTS LONG)tablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate primary, unique and foreign key constraints alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_PK primary key (ORGANIZATION_ID)using indextablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kmaxextents unlimitedpctincrease 0);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_UK2 unique (NAME, BUSINESS_GROUP_ID)using indextablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK1 foreign key(BUSINESS_GROUP_ID)references HR.HR_ALL_ORGANIZATION_UNITS (ORGANIZATION_ID); alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK2 foreign key(COST_ALLOCATION_KEYFLEX_ID)references HR.PAY_COST_ALLOCATION_KEYFLEX(COST_ALLOCATION_KEYFLEX_ID);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK3 foreign key (LOCATION_ID) references HR.HR_LOCATIONS_ALL (LOCATION_ID);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK4 foreign key(SOFT_CODING_KEYFLEX_ID)references HR.HR_ALL_ORGANIZATION_UNITS (ORGANIZATION_ID);-- Create/Recreate check constraintsalter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_OU_INTERNAL_EXTERNAL_FL_CHKcheck (INTERNAL_EXTERNAL_FLAG IN ('INT', 'EXT'));-- Create/Recreate indexescreate index HR.HR_ORGANIZATION_UNITS_FK1 onHR.HR_ALL_ORGANIZATION_UNITS (BUSINESS_GROUP_ID)tablespace APPS_TS_TX_IDXpctfree 0initrans 11storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index HR.HR_ORGANIZATION_UNITS_FK2 onHR.HR_ALL_ORGANIZATION_UNITS (COST_ALLOCATION_KEYFLEX_ID) tablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index HR.HR_ORGANIZATION_UNITS_FK3 onHR.HR_ALL_ORGANIZATION_UNITS (LOCATION_ID)tablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index HR.HR_ORGANIZATION_UNITS_FK4 onHR.HR_ALL_ORGANIZATION_UNITS (SOFT_CODING_KEYFLEX_ID) tablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onHR.HR_ALL_ORGANIZATION_UNITS to APPS with grant option; grant select on HR.HR_ALL_ORGANIZATION_UNITS to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_ONHAND_QUANTITIES_DETAIL(INVENTORY_ITEM_ID NUMBER not null,ORGANIZATION_ID NUMBER not null,DATE_RECEIVED DATE,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null,CREATION_DATE DATE not null,CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER,PRIMARY_TRANSACTION_QUANTITY NUMBER not null, SUBINVENTORY_CODE VARCHAR2(10) not null,REVISION VARCHAR2(3),LOCATOR_ID NUMBER,CREATE_TRANSACTION_ID NUMBER,UPDATE_TRANSACTION_ID NUMBER,LOT_NUMBER VARCHAR2(30),ORIG_DATE_RECEIVED DATE,COST_GROUP_ID NUMBER,CONTAINERIZED_FLAG NUMBER,PROJECT_ID NUMBER,TASK_ID NUMBER,ONHAND_QUANTITIES_ID NUMBER not null, ORGANIZATION_TYPE NUMBER not null,OWNING_ORGANIZATION_ID NUMBER not null,OWNING_TP_TYPE NUMBER not null,PLANNING_ORGANIZATION_ID NUMBER not null,PLANNING_TP_TYPE NUMBER not null,TRANSACTION_UOM_CODE VARCHAR2(3) not null, TRANSACTION_QUANTITY NUMBER not null,SECONDARY_UOM_CODE VARCHAR2(3),SECONDARY_TRANSACTION_QUANTITY NUMBER,IS_CONSIGNED NUMBER not null,LPN_ID NUMBER)tablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate index INV.MTL_ONHAND_QUANTITIES_N4 onINV.MTL_ONHAND_QUANTITIES_DETAIL (INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE,PRIMARY_TRANSACTION_QUANTITY)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_ONHAND_QUANTITIES_N5 onINV.MTL_ONHAND_QUANTITIES_DETAIL (ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID, LPN_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_ONHAND_QUANTITIES_N6 onINV.MTL_ONHAND_QUANTITIES_DETAIL (ORGANIZATION_ID, INVENTORY_ITEM_ID, COST_GROUP_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onINV.MTL_ONHAND_QUANTITIES_DETAIL to APPS with grant option;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_SECONDARY_INVENTORIES(SECONDARY_INVENTORY_NAME VARCHAR2(10) not null, ORGANIZATION_ID NUMBER not null,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null,CREATION_DATE DATE not null,CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER,DESCRIPTION VARCHAR2(50),DISABLE_DATE DATE,INVENTORY_ATP_CODE NUMBER not null, AVAILABILITY_TYPE NUMBER not null,RESERVABLE_TYPE NUMBER not null,LOCATOR_TYPE NUMBER,PICKING_ORDER NUMBER,MATERIAL_ACCOUNT NUMBER,MATERIAL_OVERHEAD_ACCOUNT NUMBER, RESOURCE_ACCOUNT NUMBER,OVERHEAD_ACCOUNT NUMBER,OUTSIDE_PROCESSING_ACCOUNT NUMBER, QUANTITY_TRACKED NUMBER not null,。