INV_SERIAL_ITEM_CONTROLS
This table stores the auto serial prefix and start serial number from the EGP_ITEM_ORG_ASSOCIATIONS table for serial items for which user setup is at the item level, i.e., the item level settings will be used to generate auto serial numbers. It also stores the next serial number to be used by the auto serial generation process..
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_SERIAL_ITEM_CONTROLS_PK |
INVENTORY_ITEM_ID, ORGANIZATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This identifies the inventory item. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | This identifies the inventory organization. | |
| AUTO_SERIAL_ALPHA_PREFIX | VARCHAR2 | 80 | This field will be synched with the items table. | ||
| START_AUTO_SERIAL_NUMBER | VARCHAR2 | 80 | This is a starting serial number; synchronized with the items table. | ||
| NEXT_AUTO_SERIAL_NUMBER | VARCHAR2 | 80 | This holds the real starting auto serial number | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_SERIAL_ITEM_CONTROLS_U1 | Unique | FUSION_TS_TX_IDX | INVENTORY_ITEM_ID, ORGANIZATION_ID |