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 |