CST_INTERFACE_STD_COST

Details

Schema: FUSION
Object owner: CST
Object type: TABLE
Tablespace: FUSION_TS_INTERFACE

Primary Key

Name	Columns
CST_INTERFACE_STD_COST_HE_PK	EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
EXTERNAL_SYSTEM_REFERENCE	VARCHAR2	240		Yes	Reference information from an external system.
EXTERNAL_SYSTEM_REF_ID	VARCHAR2	30		Yes	Reference identifier information from an external system.
COST_ORG_CODE	VARCHAR2	240			Identifies the cost organization for which the standard cost is entered.
COST_BOOK_CODE	VARCHAR2	30			Identifies the cost book for which the standard cost is entered.
BUY_COST_FLAG	VARCHAR2	1			Indicates the buy cost type. This can be either Y or N.
ITEM_NUMBER	VARCHAR2	1200		Yes	Identifies the item for which the standard cost is entered.
INVENTORY_ORG_CODE	VARCHAR2	240			Identifies the inventory organization of the item for which the standard cost is entered.
SUBINVENTORY_CODE	VARCHAR2	240			Identifies the sub inventory organization of the item for which the standard cost is entered.
LOCATOR	VARCHAR2	81			Identifies the stock locator of the item for which the standard cost is entered.
LOCATOR_ID	NUMBER		18		Identifies the locator identifier of the item for which the standard cost is entered.
LOT_NUMBER	VARCHAR2	240			Identifies the lot identifier of the item for which the standard cost is entered.
SERIAL_NUMBER	VARCHAR2	240			Identifies the serial number of the item for which the standard cost is entered.
GRADE_CODE	VARCHAR2	240			Identifies the grade code of the item for which the standard cost is entered.
VAL_UNIT_CODE	VARCHAR2	1000			Identifies the valuation unit for which the standard cost is entered.
ASSET_EXPENSE_FLAG	VARCHAR2	30			Indicates the cost profile is an asset or an expense.
EFFECTIVE_START_DATE	DATE				Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
CURRENCY_CODE	VARCHAR2	15			Indicates the currency code in which the standard cost is entered.
UOM_CODE	VARCHAR2	30			Indicates the standard unit of measure in which the standard cost is entered.
PROCESSING_STATUS	VARCHAR2	1			Indicates the processing status. Below are the possible values. n=new, x=do not process, s= successful, e=error
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
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.
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.
LOAD_REQUEST_ID	NUMBER		18		Used by Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row.
SCENARIO_NUMBER	VARCHAR2	30			Identifies the scenario for which the standard cost is entered.

Indexes

Index	Uniqueness	Tablespace	Columns
CST_INTFC_STD_COST_HDRS_U1	Unique	FUSION_TS_INTERFACE	EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID