CST_LYR_ONHAND_GT
Global temporary table used by the quantity flow processor to update the transaction layers with the onhand balance.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Single column FK: Identifies the cost transaction. | |
| REC_TRXN_ID | NUMBER | 18 | Receipt Transaction Identifier | |
| DEP_TRXN_ID | NUMBER | 18 | Deplete Transaction Identifier | |
| SOURCE_TABLE | VARCHAR2 | 20 | Indicates the source table of the record. | |
| ADDITIONAL_PROCESSING_CODE | VARCHAR2 | 240 | Code specifying what kind of processing needs to be done. | |
| QTY_ONHAND | NUMBER | Contains the running onhand balance of the item. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_LYR_ONHAND_GT_N1 | Non Unique | TRANSACTION_ID, REC_TRXN_ID, DEP_TRXN_ID |
| CST_LYR_ONHAND_GT_N2 | Non Unique | SOURCE_TABLE |