CST_NEGINV_WO_GT
GLOBAL TEMP TABLE TO CALCULATE NEG INVENTORY WRITEOFF COSTS
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the cost transaction. | |
| REC_TRXN_ID | NUMBER | 18 | Yes | Receipt Transaction Identifyer | |
| DEP_TRXN_ID | NUMBER | 18 | Yes | Deplete Transaction Identifyer | |
| EFF_DATE | DATE | Effective Date of transaction. | |||
| COST_ELEMENT_ID | NUMBER | 18 | Yes | Cost element corresponding to the cost of the transaction. | |
| ISSUE_COST | NUMBER | ISSUE_COST | |||
| RECEIPT_COST | NUMBER | RECEIPT_COST | |||
| UNIT_COST_WO | NUMBER | UNIT_COST_WO | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Identifies the currency of the transaction / cost. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_NEGINV_WO_GT_N1 | Non Unique | TRANSACTION_ID, REC_TRXN_ID, DEP_TRXN_ID, COST_ELEMENT_ID |