DOO_LOT_SERIAL_NUMBERS
This table would contain lot serial information
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
DOO_LOT_SERIAL_NUMBERS_PK |
LOT_SERIAL_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
LOT_SERIAL_ID | NUMBER | 18 | Yes | Unique identifier for lot and serial combinations. | |
QUANTITY | NUMBER | Holds the quantity information of Lots and Serials | |||
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. | |
LINE_ID | NUMBER | 18 | Reference to the unique identifier for the orchestration order line | ||
FULFILL_LINE_ID | NUMBER | 18 | Yes | Reference to the unique identifier of a fulfillment line | |
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_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. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
LOT_NUMBER | VARCHAR2 | 320 | A number assigned to quantity of items for identification purposes. | ||
LOCATOR_ID | NUMBER | 18 | Identifies locator where the item is shipped from or received into | ||
ITEM_SERIAL_NUMBER_FROM | VARCHAR2 | 120 | Starting serial number of a range of serial numbers. | ||
ITEM_SERIAL_NUMBER_TO | VARCHAR2 | 120 | Ending serial number of a range of serial numbers. | ||
ITEM_REVISION_NUMBER | VARCHAR2 | 120 | Indicates additional information about an item revision. | ||
ORIG_SYS_LOTSERIAL_REF | VARCHAR2 | 50 | Original document reference for the orchestration order in external system | ||
REFERENCE_LOT_SERIAL_ID | NUMBER | 18 | Used by change mgmt to associate the change order's lot serial no with the original order's lot serial no. | ||
DELTA_TYPE | NUMBER | 18 | Internal column used by change processing framework for tracking type of change like update, cancel..etc | ||
MODIFIED_FLAG | VARCHAR2 | 1 | Indicates that the row has been modified in the version currently submitted | ||
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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
DOO_LOT_SERIAL_NUMBERS | doo_fulfill_lines_all | FULFILL_LINE_ID |
doo_lot_serial_numbers_eff_b | doo_lot_serial_numbers | LOT_SERIAL_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
DOO_LOT_SERIAL_NUMBERS_FK1 | Non Unique | Default | FULFILL_LINE_ID |
DOO_LOT_SERIAL_NUMBERS_N1 | Non Unique | Default | REFERENCE_LOT_SERIAL_ID |
DOO_LOT_SERIAL_NUMBERS_PK | Unique | Default | LOT_SERIAL_ID |