RCV_RECEIPT_CONF_LS_INT

The table RCV_RECEIPT_CONF_LS_INT will be used to store the lot and serial information for a receipt confirmation interface sent by an external system such as contract manufacturer. The data from this intermediate table is transformed to INV_TRANSACTION_LOTS_INTERFACE and INV_SERIAL_NUMBERS_INTERFACE.

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: TABLE

• Tablespace: INTERFACE

Primary Key

Name	Columns
RCV_RECEIPT_CONF_LS_INT_PK	RCPT_CONF_LS_INTF_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RCPT_CONF_LS_INTF_ID	NUMBER		18	Yes	Receipt confirmation lot-serial interface record unique identifier.
RCPT_CONF_INTF_TXN_ID	NUMBER		18	Yes	This is the foreign-key column which refers to the RCPT_CONF_INTF_TXN_ID column in the table RCV_RCPT_CONF_INTERFACE.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LOT_NUMBER	VARCHAR2	80			This number identifies an inventory lot.
FM_SERIAL_NUMBER	VARCHAR2	80			Single serial number or beginning serial number in range.
TO_SERIAL_NUMBER	VARCHAR2	80			Ending serial number in a range.
LOT_QUANTITY	NUMBER				This column stores the lot quantity in terms of transaction unit of measure.
SECONDARY_LOT_QUANTITY	NUMBER				This column stores the lot quantity in the item's secondary unit of measure.
SUBINVENTORY	VARCHAR2	10			This column stores the destination subinventory where the item is to be put away.
LOCATION	VARCHAR2	81			This column stores the concatenated segments of the inventory locator where the item is to be put away.
LOT_EXPIRATION_DATE	DATE				This column stores the expiration date for the lot.

Foreign Keys

Table	Foreign Table	Foreign Key Column
RCV_RECEIPT_CONF_LS_INT	rcv_receipt_conf_int	RCPT_CONF_INTF_TXN_ID

Indexes

Index	Uniqueness	Tablespace	Columns
RCV_RECEIPT_CONF_LS_INT_N1	Non Unique	Default	RCPT_CONF_INTF_TXN_ID, LOT_NUMBER
RCV_RECEIPT_CONF_LS_INT_U1	Unique	Default	RCPT_CONF_LS_INTF_ID