Important Apps Tables Mfg

Type Of Interface

Interface Table

Base Table

Inventory Item Interface

Open Transaction Interace

Receiving Transaction Interface (for ASN's)

mtl_system_item_interface mtl_item_revisions_interface mtl_item_categories_interface mtl_transaction_interface mtl_transaction_lots_interface mtl_serial_numbers_interface rcv_headers_interface rcv_transactions_interface

mtl_system_items mtl_item_revisions mtl_item_categories mtl_material_transactions mtl_transaction_lots_numbers mtl_serial_numbers rcv_shipment_headers rcv_shipment_lines

Purchasing Requisition Interface (for Requisitions) For rescheuling info. From planning system Purchase Order Interface

po_requisitions_interface_all

po_requisition_headers_all po_requisition_lines_all po_req_distributions_all

po_reschedule_interface po_headers_interface po_lines_interface po_distributions_interface

po_headers_all po_lines_all po_distributions_all rcv_transactions

Order Management order Import

ship confirm open interface

oe_headers_iface_all oe_lines_iface_all oe_lotserials_iface_all oe_credits_iface_all oe_actions_iface_all oe_price_adjs_iface_all oe_reservtns_iface_all

WSH_DELIVERIES_INTERFACE wsh_packed_container_interface wsh_picking_details_interface wsh_freight_charge_interface

oe_order_headers_all oe_lines_all oe_lot_serial_numbers oe_sales_credits oe_price_adjustments Pricing : QP_List_Headers QP_List_lines Shipping : WSH_NEW_DELIVERIES WSH_DELIVERY_DETAILS WSH_DELIVERY_ASSIGNMENT S. wsh_deliveries wsh_packed_containers so_picking_line_details so_freight_charges

BOM Open Bills of Material Interface

BOM_BILL_OF_MTLS_INTERFACE

bom_bill_of_materials

Open Routing Interface

BOM_INVENTORY_COMPS_INTERFACE BOM_REF_DESGS_INTERFACE BOM_SUB_COMPS_INTERFACE MTL_ITEM_REVISIONS_INTERFACE BOM_OP_ROUTINGS_INTERFACE BOM_OP_SEQUENCES_INTERFACE BOM_OP_RESOURCES_INTERFACE MTL_RTG_ITEM_REVS_INTERFACE

bom_inventory_components bom_reference_designators bom_substitute_components mtl_item_revisions bom_operational_routings bom_operation_sequences bom_operation_resources

WIP move transaction interface resource transaction interface work order_interface

wip_move_txn_interface wip_cost_txn_interface wip_job_shedule_interface wip_job_dtls_interface

wip_move_transactions wip_discrete_jobs wip_repetitive_schedules

MPS/MRP Forecast Intf

mrp_forecast_interface

Master Schedule Intf.

mrp_schedule_interface

mrp_forecast_dates,mrp_forecast _items mrp_schedule_dates, mrp_schedule_items