Wednesday, June 25, 2008

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

1 comment:

Unknown said...
This comment has been removed by the author.