CST_DRAFT_STD_RSRC_RATE_DTLS

This table contains the cost component level breakup of resource rates draft published to cost accounting from a cost planning scenario.

Details

Name	Datatype	Length	Precision	Not-null	Comments
DRAFT_STD_RSRC_RATE_DTL_ID	NUMBER		18	Yes	Indicates the surrogate identifier for the standard resource rate detail.
DRAFT_STD_RSRC_RATE_ID	NUMBER		18	Yes	Indicates the reference of the standard resource rate under which the details are published.
COST_COMPONENT_ID	NUMBER		18		Identifies the cost component of the standard resource rate detail.
EXPENSE_POOL_ID	NUMBER		18		Identifies the expense pool of the standard resource rate detail.
UNIT_RATE	NUMBER				Indicates the unit rate for the cost component in resource rate currency.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Index	Uniqueness	Tablespace	Columns
CST_DRAFT_RSRC_RATE_DTLS_PK	Unique	FUSION_TS_TX_DATA	DRAFT_STD_RSRC_RATE_DTL_ID