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 |