CST_DEPCOST_DATE_GT
Assigned Deplete Cost Date to depletes that points to a receipt data
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CST_DEPCOST_DATE_GT_PK |
TRANSACTION_ID, REC_TRXN_ID, DEP_TRXN_ID |
Columns
Name | Datatype | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | |
TRANSACTION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the costing transaction. | Active |
REC_TRXN_ID | NUMBER | 18 | Yes | Receipt Transaction Identifyer | Active |
DEP_TRXN_ID | NUMBER | 18 | Yes | Deplete Transaction Identifyer | Active |
COST_ORG_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Organization associated with the inventory organization. | Active |
COST_BOOK_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | Active |
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory Item Identifier | Active |
VAL_UNIT_ID | NUMBER | 18 | Yes | Valuation unit identifier | Active |
REC_COST_DATE | TIMESTAMP | Receipt Date to Cost Depletion Trasaction | Active | ||
REC_COST_ID | NUMBER | 18 | Yes | Receipt Transaction to Cost Depletion Trasaction | Active |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CST_DEPCOST_DATE_GT_U1 | Unique | TRANSACTION_ID, REC_TRXN_ID, DEP_TRXN_ID |