eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: RCV_SERIAL_TRANSACTIONS

Product:	PO - Purchasing
Description:	Receiving serial transactions
Implementation/DBA Data:	PO.RCV_SERIAL_TRANSACTIONS

Primary Key: RCV_SERIAL_TRX_UK01

SERIAL_TRANSACTION_TYPE
SHIPMENT_LINE_ID
SERIAL_NUM

Primary Key: RCV_SERIAL_TRX_UK02

SERIAL_TRANSACTION_TYPE
TRANSACTION_ID
SERIAL_NUM

Foreign Keys

Table	Foreign Table	Foreign Key Column
RCV_SERIAL_TRANSACTIONS	RCV_TRANSACTIONS	RCV_SERIAL_TRANSACTIONS.SOURCE_TRANSACTION_ID
RCV_SERIAL_TRANSACTIONS	RCV_TRANSACTIONS	RCV_SERIAL_TRANSACTIONS.CORRECTION_TRANSACTION_ID
RCV_SERIAL_TRANSACTIONS	RCV_SHIPMENT_LINES	RCV_SERIAL_TRANSACTIONS.SHIPMENT_LINE_ID
RCV_SERIAL_TRANSACTIONS	RCV_TRANSACTIONS	RCV_SERIAL_TRANSACTIONS.TRANSACTION_ID