Showing posts with label Inventory and PO Interface Tables. Show all posts
Showing posts with label Inventory and PO Interface Tables. Show all posts

Wednesday, 20 April 2011

Inventory and PO Interface Tables


Inventory and PO Interface Tables


Inventory Interfaces
Open Item Interface

Interface Table:MTL_SYSTEM_ITEM_INTERFACE
MTL_ITEM_REVISIONS_INTERFACE
MTL_ITEM_CATEGORY_INTERFACE
MTL_INTERFACE_ERRORS

Base Table:
MTL_SYSTEM_ITEMS_B
MTL_ITEM_REVISIONS
MTL_ITEM_CATEGORIES

Open Transaction Interface
MTL_TRANSACTIONS_INTERFACE
MTL_TRANSACTION_LOTS_INTERFACE
MTL_SERIAL_NUMBERS_INTERFACE
MTL_INTERFACE_ERRORS

Base Tables
MTL_MATERIAL_TRANSACTIONS
MTL_TRANSACTION_LOT_NUMBERS
MTL_SERIAL_NUMBERS

PO Interfaces
Requistion
PO_REQUISITIONS_INTERFACE_ALL
table are identical to the corresponding columns in the
PO_REQUISITIONS_HEADERS_ALL,
PO_REQUISITION_LINES_ALL and PO_REQ_DISTRIBUTIONS_ALL
tables.

Receiving
RCV_HEADERS_INTERFACE
RCV_LOTS_INTERFACE
RCV_TRANSACTIONS_INTERFACE
Tables:
RCV_SHIPMENT_HEADERS
RCT_SHIPMENT_LINES
RCV_TRANSACTIONS