INV_CST_CONS_ADVICE_GT
This global temp table holds the transaction id and consumption line identifier for consumption advice interface.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
INV_CST_CONS_ADVICE_GT_PK |
CONSUMPTION_LINE_ID, TRANSACTION_ID |
Columns
| Name | Datatype | Precision | Not-null | Comments |
|---|---|---|---|---|
| CONSUMPTION_LINE_ID | NUMBER | 18 | Yes | Consumption advice line identifier |
| TRANSACTION_ID | NUMBER | 18 | Yes | Transaction Identifier |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| INV_CST_CONS_ADVICE_GT_U1 | Unique | CONSUMPTION_LINE_ID, TRANSACTION_ID |