DOO_FS_LOT_SERIALS_INT
Lot number and serial number related details in the fulfillment system response.
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
DOO_FS_LOT_SERIALS_INT_PK |
LOT_SERIAL_IF_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
LOT_SERIAL_IF_ID | NUMBER | 18 | Yes | Unique internal identifier for a lot serial interface record, generated by sequence. | |
FULFILLMENT_SYSTEM_RESPONSE_ID | VARCHAR2 | 50 | Unique identifier that fulfillment system may send and can be used to correlate the response relayed back to the fulfillment system. | ||
FULFILL_LINE_INTERFACE_KEY | VARCHAR2 | 120 | An identifier that distinguishes a fulfillment line record from another one for a given fulfillment system response identifier. | ||
LOT_SERIAL_INTERFACE_KEY | VARCHAR2 | 50 | Reference to the lot and serial information in the system where this information originated. | ||
LOAD_REQUEST_ID | NUMBER | 18 | Unique identifier of a data set pertaining to fulfillment system responses to one or more fulfillment system requests. | ||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of 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. | |
LOT_NUMBER | VARCHAR2 | 320 | Number assigned to quantity of items for identification purposes. | ||
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. | ||
ITEM_REVISION_NUMBER | VARCHAR2 | 120 | Number of times an item was revised. | ||
LOCATOR_ID | NUMBER | 18 | Unique identifier of the locator where the item is shipped from or received into. | ||
INTERFACE_SOURCE_CODE | VARCHAR2 | 30 | Identifies the source used to insert data in this interface table. For example, ORA_FS_RESPONSE_FBDI and ORA_FS_RESPONSE_API for data imported using file and API respectively. | ||
QUANTITY | NUMBER | Holds the quantity information of Lots and Serials. | |||
SECONDARY_QUANTITY | NUMBER | Quantity of the lot for the item or service in the secondary unit of measure. This attribute applies when you use more than one unit of measure to measure and track the item. | |||
FULFILL_LINE_ID | NUMBER | 18 | Unique Identifier for a fulfillment line |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
DOO_FS_LOT_SERIALS_INT_N1 | Non Unique | Default | INTERFACE_SOURCE_CODE, LOAD_REQUEST_ID, FULFILL_LINE_INTERFACE_KEY, LOT_SERIAL_INTERFACE_KEY | Obsolete |
DOO_FS_LOT_SERIALS_INT_N2 | Non Unique | Default | FULFILL_LINE_ID, FULFILL_LINE_INTERFACE_KEY | |
DOO_FS_LOT_SERIALS_INT_PK | Unique | Default | LOT_SERIAL_IF_ID |