GL,INV,AP,FA,INV,PO,BOM,WIP, INTERFACE TABLES

                    

GL INTERFACE TABLES

TNAME TABTYPE
------------------------------ ------- ----------------------
GL_BUDGET_INTERFACE TABLE
GL_DAILY_RATES_INTERFACE TABLE
GL_IEA_INTERFACE TABLE
GL_INTERFACE TABLE
GL_INTERFACE_CONTROL TABLE
GL_INTERFACE_HISTORY TABLE

AP INTERFACE TABLES

TNAME TABTYPE
------------------------------ ------- ------------------------
AP_INTERFACE_CONTROLS TABLE
AP_INTERFACE_REJECTIONS TABLE
AP_INVOICES_INTERFACE TABLE
AP_INVOICE_LINES_INTERFACE TABLE


AR INTERFACE TABLES

TNAME TABTYPE
------------------------------ --------------------------------------
AR_PAYMENTS_INTERFACE_ALL TABLE
AR_TAX_INTERFACE TABLE
HZ_DQM_SYNC_INTERFACE TABLE
HZ_PARTY_INTERFACE TABLE
HZ_PARTY_INTERFACE_ERRORS TABLE
RA_CUSTOMERS_INTERFACE_ALL TABLE
RA_INTERFACE_DISTRIBUTIONS_ALL TABLE
RA_INTERFACE_ERRORS_ALL TABLE
RA_INTERFACE_LINES_ALL TABLE
RA_INTERFACE_SALESCREDITS_ALL TABLE


FA INTERFACE TABLES

TNAME TABTYPE
------------------------------ ------- ----------------------
FA_BUDGET_INTERFACE TABLE
FA_INV_INTERFACE TABLE
FA_PRODUCTION_INTERFACE TABLE
FA_TAX_INTERFACE TABLE

INVENTORY INTERFACE TABLES

TNAME TABTYPE
------------------------------ ------- ------------------------------------
MTL_CC_ENTRIES_INTERFACE TABLE
MTL_CC_INTERFACE_ERRORS TABLE
MTL_CI_INTERFACE TABLE
MTL_CI_XREFS_INTERFACE TABLE
MTL_COPY_ORG_INTERFACE TABLE
MTL_CROSS_REFERENCES_INTERFACE TABLE
MTL_DEMAND_INTERFACE TABLE
MTL_DESC_ELEM_VAL_INTERFACE TABLE
MTL_EAM_ASSET_NUM_INTERFACE TABLE
MTL_EAM_ATTR_VAL_INTERFACE TABLE
MTL_INTERFACE_ERRORS TABLE

TNAME TABTYPE
------------------------------ ------- --------------------------------------
MTL_INTERFACE_PROC_CONTROLS TABLE
MTL_ITEM_CATEGORIES_INTERFACE TABLE
MTL_ITEM_CHILD_INFO_INTERFACE TABLE
MTL_ITEM_REVISIONS_INTERFACE TABLE
MTL_ITEM_SUB_INVS_INTERFACE TABLE
MTL_OBJECT_GENEALOGY_INTERFACE TABLE
MTL_RELATED_ITEMS_INTERFACE TABLE
MTL_RESERVATIONS_INTERFACE TABLE
MTL_RTG_ITEM_REVS_INTERFACE TABLE
MTL_SECONDARY_LOCS_INTERFACE TABLE
MTL_SERIAL_NUMBERS_INTERFACE TABLE

TNAME TABTYPE
------------------------------ ------- ------------------------------------
MTL_SO_RMA_INTERFACE TABLE
MTL_SYSTEM_ITEMS_INTERFACE TABLE
MTL_TRANSACTIONS_INTERFACE TABLE
MTL_TRANSACTION_LOTS_INTERFACE TABLE
MTL_TXN_COST_DET_INTERFACE TABLE

PO INTERFACE TAB

TNAME TABTYPE
------------------------------ ------- -------------------------
PO_DISTRIBUTIONS_INTERFACE TABLE
PO_HEADERS_INTERFACE TABLE
PO_INTERFACE_ERRORS TABLE
PO_LINES_INTERFACE TABLE
PO_REQUISITIONS_INTERFACE_ALL TABLE
PO_REQ_DIST_INTERFACE_ALL TABLE
PO_RESCHEDULE_INTERFACE TABLE
RCV_HEADERS_INTERFACE TABLE
RCV_LOTS_INTERFACE TABLE
RCV_SERIALS_INTERFACE TABLE
RCV_TRANSACTIONS_INTERFACE TABLE

BOM INTERFACE TABLES

TNAME TABTYPE
------------------------------ ------- ----------------------------------
BOM_BILL_OF_MTLS_INTERFACE TABLE
BOM_INTERFACE_DELETE_GROUPS TABLE
BOM_INVENTORY_COMPS_INTERFACE TABLE
BOM_OP_RESOURCES_INTERFACE TABLE
BOM_OP_ROUTINGS_INTERFACE TABLE
BOM_OP_SEQUENCES_INTERFACE TABLE
BOM_REF_DESGS_INTERFACE TABLE
BOM_SUB_COMPS_INTERFACE TABLE
CST_COMP_SNAP_INTERFACE TABLE
CST_INTERFACE_ERRORS TABLE
CST_ITEM_COSTS_INTERFACE TABLE
CST_ITEM_CST_DTLS_INTERFACE TABLE
CST_PC_COST_DET_INTERFACE TABLE
CST_PC_ITEM_COST_INTERFACE TABLE

WIP INTERFACE TABLES

TNAME TABTYPE
------------------------------ ------- --------------------------
WIP_COST_TXN_INTERFACE TABLE
WIP_INTERFACE_ERRORS TABLE
WIP_JOB_DTLS_INTERFACE TABLE
WIP_JOB_SCHEDULE_INTERFACE TABLE
WIP_MOVE_TXN_INTERFACE TABLE
WIP_SCHEDULING_INTERFACE TABLE
WIP_TXN_INTERFACE_ERRORS TABLE

ORDER MANAGEMENT INTERFACE TABLES

TNAME TABTYPE
------------------------------ ------- -----------------------------------
SO_CONFIGURATIONS_INTERFACE TABLE
SO_HEADERS_INTERFACE_ALL TABLE
SO_HEADER_ATTRIBUTES_INTERFACE TABLE
SO_LINES_INTERFACE_ALL TABLE
SO_LINE_ATTRIBUTES_INTERFACE TABLE
SO_LINE_DETAILS_INTERFACE TABLE
SO_PRICE_ADJUSTMENTS_INTERFACE TABLE
SO_SALES_CREDITS_INTERFACE TABLE
SO_SERVICE_DETAILS_INTERFACE TABLE
WSH_DELIVERIES_INTERFACE TABLE
WSH_FREIGHT_CHARGES_INTERFACE TABLE
WSH_PACKED_CONTAINER_INTERFACE TABLE

Type Of Interface	Interface Table	Base Table
Inventory
Item Interface	mtl_system_item_interface	mtl_system_items
	mtl_item_revisions_interface	mtl_item_revisions
	mtl_item_categories_interface	mtl_item_categories
Open Transaction Interace	mtl_transaction_interface	mtl_material_transactions
	mtl_transaction_lots_interface	mtl_transaction_lots_numbers
	mtl_serial_numbers_interface	mtl_serial_numbers
Receiving Transaction Interface	rcv_headers_interface	rcv_shipment_headers
(for ASN's)	rcv_transactions_interface	rcv_shipment_lines
Purchasing
Requisition Interface	po_requisitions_interface_all	po_requisition_headers_all
(for Requisitions)		po_requisition_lines_all
		po_req_distributions_all
For rescheuling info. From planning system	po_reschedule_interface
Purchase Order Interface	po_headers_interface	po_headers_all
	po_lines_interface	po_lines_all
	po_distributions_interface	po_distributions_all
		rcv_transactions
Order Management
order Import	oe_headers_iface_all	oe_order_headers_all
	oe_lines_iface_all	oe_lines_all
	oe_lotserials_iface_all	oe_lot_serial_numbers
	oe_credits_iface_all	oe_sales_credits
	oe_actions_iface_all
	oe_price_adjs_iface_all	oe_price_adjustments
	oe_reservtns_iface_all
		Pricing :
		QP_List_Headers
		QP_List_lines
		Shipping :
ship confirm open interface	WSH_DELIVERIES_INTERFACE	WSH_NEW_DELIVERIES
	wsh_packed_container_interface	WSH_DELIVERY_DETAILS
	wsh_picking_details_interface	WSH_DELIVERY_ASSIGNMENTS.
	wsh_freight_charge_interface	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
	BOM_INVENTORY_COMPS_INTERFACE	bom_inventory_components
	BOM_REF_DESGS_INTERFACE	bom_reference_designators
	BOM_SUB_COMPS_INTERFACE	bom_substitute_components
	MTL_ITEM_REVISIONS_INTERFACE	mtl_item_revisions
Open Routing Interface	BOM_OP_ROUTINGS_INTERFACE	bom_operational_routings
	BOM_OP_SEQUENCES_INTERFACE	bom_operation_sequences
	BOM_OP_RESOURCES_INTERFACE	bom_operation_resources
	MTL_RTG_ITEM_REVS_INTERFACE
WIP
move transaction interface	wip_move_txn_interface	wip_move_transactions
resource transaction interface	wip_cost_txn_interface
work order_interface	wip_job_shedule_interface	wip_discrete_jobs
	wip_job_dtls_interface	wip_repetitive_schedules
MPS/MRP
Forecast Intf	mrp_forecast_interface	mrp_forecast_dates,mrp_forecast_items
Master Schedule Intf.	mrp_schedule_interface	mrp_schedule_dates, mrp_schedule_items