CST_CLC_ONHAND_VALUE_GT
Global temporary table used by the cost process to calculate the layer onhand value.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| COST_ID | NUMBER | 18 | Layer Cost Identifier | |
| SOURCE_TABLE | VARCHAR2 | 20 | Indicates the source table of the record. | |
| ONHAND_VALUE_STATUS_FLAG | VARCHAR2 | 1 | Indicates the onhand value status. | |
| OH_STATUS_FLAG | VARCHAR2 | 1 | Indicates the onhand status. | |
| OH_VALUE | NUMBER | Indicates the onhand value. | ||
| PREV_ONHAND_QUANTITY | NUMBER | Indicates the previous onhand quantity. | ||
| ONHAND_QUANTITY | NUMBER | Indicates the onhand quantity. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_CLC_ONHAND_VALUE_GT_N1 | Non Unique | COST_ID |
| CST_CLC_ONHAND_VALUE_GT_N2 | Non Unique | SOURCE_TABLE |