DOO_ORDER_LOT_SERIALS_INT

This interface table contains details of Lot Serial Numbers for an imported Source Sales Order.

Details

• Schema: FUSION

• Object owner: DOO

• Object type: TABLE

• Tablespace: INTERFACE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SOURCE_TRANSACTION_LOT_ID	VARCHAR2	50			Unique identifier of the lot assigned by the system that captured the transaction.
SOURCE_TRANSACTION_SYSTEM	VARCHAR2	30			System or application that submitted the order request.
SOURCE_TRANSACTION_ID	VARCHAR2	50			Unique identifier of the transaction in the system that captured the transaction.
SOURCE_TRANSACTION_SCHEDULE_ID	VARCHAR2	50			Unique identifier of a schedule, shipment, or subline, as assigned by the system that captured the transaction.
SOURCE_TRANSACTION_LINE_ID	VARCHAR2	50			Unique identifier of the transaction line from the system that captured the transaction.
LOT_NUMBER	VARCHAR2	320			Number assigned to quantity of items for identification purposes.
LOAD_REQUEST_ID	NUMBER		18		Unique identifier of the import request.
LOCATOR_ID	NUMBER		18		Unique identifier of the locator where the item is shipped from or received into.
ITEM_REVISION_NUMBER	VARCHAR2	320			Number of times an item was revised.
SERIAL_NUMBER_FROM	VARCHAR2	120			Starting serial number of a range of serial numbers.
SERIAL_NUMBER_TO	VARCHAR2	120			Ending serial number of a range of serial numbers.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to 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.
LOCATOR_NAME	VARCHAR2	2000			Identifies the source location that order management uses to ship the item to the destination location. If it's a return order, then this attribute identifies the destination location where order management receives the item back into inventory. This attribute contains the concatenated segments of the locator flexfields.
QUANTITY	NUMBER				Holds the quantity information of Lots and Serials.

Indexes

Index	Uniqueness	Tablespace	Columns
DOO_ORDER_LOT_SERIALS_INT_N1	Non Unique	Default	SOURCE_TRANSACTION_ID, SOURCE_TRANSACTION_SYSTEM, LOAD_REQUEST_ID, SOURCE_TRANSACTION_LINE_ID