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 |