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