INV_TXN_CONTEXT_GT
This is a global temp table that is used to store the context of the demand during execution of the rules engine.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Not-null | Comments |
---|---|---|---|---|
LINE_ID | NUMBER | Yes | Unique ID of context line | |
TXN_SOURCE_ID | NUMBER | Unique ID representing source demand record. | ||
TXN_SOURCE_LINE_ID | NUMBER | Unique ID representing source demand line record. | ||
TXN_SOURCE_NAME | VARCHAR2 | 30 | Name associated with source deman. | |
TXN_SOURCE_LINE_DETAIL | NUMBER | Unique ID representing source line detail. | ||
FREIGHT_CARRIER_CODE | VARCHAR2 | 30 | Code representing freight carrier. | |
CUSTOMER_ID | NUMBER | Unique ID of customer. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
INV_TXN_CONTEXT_GT_U1 | Unique | LINE_ID |