FND Design Data [Home] [Help]

Table: RCV_SERIAL_TRANSACTIONS

Product: PO - Purchasing
Description: Receiving serial transactions
Implementation/DBA Data: TablePO.RCV_SERIAL_TRANSACTIONS
Primary Key: RCV_SERIAL_TRX_UK01
  1. ColumnSERIAL_TRANSACTION_TYPE
  2. ColumnSHIPMENT_LINE_ID
  3. ColumnSERIAL_NUM
Primary Key: RCV_SERIAL_TRX_UK02
  1. ColumnSERIAL_TRANSACTION_TYPE
  2. ColumnTRANSACTION_ID
  3. ColumnSERIAL_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
RCV_SERIAL_TRANSACTIONS FK Joins to TableRCV_TRANSACTIONS RCV_SERIAL_TRANSACTIONS.SOURCE_TRANSACTION_ID
RCV_SERIAL_TRANSACTIONS FK Joins to TableRCV_TRANSACTIONS RCV_SERIAL_TRANSACTIONS.CORRECTION_TRANSACTION_ID
RCV_SERIAL_TRANSACTIONS FK Joins to TableRCV_SHIPMENT_LINES RCV_SERIAL_TRANSACTIONS.SHIPMENT_LINE_ID
RCV_SERIAL_TRANSACTIONS FK Joins to TableRCV_TRANSACTIONS RCV_SERIAL_TRANSACTIONS.TRANSACTION_ID