INV_MSN_GT
This is a global temp table that is used to store serial numbers allocated by the rules engine.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| SERIAL_IDENTIFIER | NUMBER | Yes | Unique ID of serial record. | |
| INVENTORY_ITEM_ID | NUMBER | Yes | Unique ID of item. | |
| ORGANIZATION_ID | NUMBER | Yes | Unique ID of organization. | |
| SERIAL_NUMBER | VARCHAR2 | 80 | Yes | Serial number allocated. |
| USE_FLAG | NUMBER | Flag indicated whether serial has been used. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| INV_MSN_GT_U1 | Unique | SERIAL_IDENTIFIER |
| INV_MSN_GT_U2 | Unique | INVENTORY_ITEM_ID, ORGANIZATION_ID, SERIAL_NUMBER, USE_FLAG |