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 |