ACA_PD_ITEM_COST

Details

Schema: FUSION
Object owner: ACA
Object type: TABLE
Tablespace: INTERFACE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
INTERFACE_TABLE_UNIQUE_ID	NUMBER		18		Interface table identifier for item cost interface rows.
HAS_ERRORS	NUMBER		1		This column stores if the record has any errors.
BATCH_ID	NUMBER		18		Unique identifier that groups items togather in a single transaction.
BATCH_NUMBER	VARCHAR2	40			Unique identifier of the batch that is used for item import.
PREPROCESS_THREAD_NUMBER	NUMBER		18		PreProcess Thread Number for interface processing.
THREAD_NUMBER	NUMBER		18		Attribute indicating the thread number with the import.
BUNDLE_ID	NUMBER		18		Unique identifier that groups items related entities together in a single transaction.
PROCESS_STATUS	NUMBER				Attribute indicating the process status of the record in the import.
TRANSACTION_ID	NUMBER		18		Attribute indicating the transaction identifier associated with the import.
TRANSACTION_TYPE	VARCHAR2	10			This refers to transaction type of the record.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
LOAD_REQUEST_ID	NUMBER		18		Identifier of the ESS request that was used to load this interface row.
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of 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.
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.
ITEM_NUMBER	VARCHAR2	300			Any part, material, product or service that is unique as compared with other items by nature of its attributes in the product data hub.
INVENTORY_ITEM_ID	NUMBER		18		Attribute indicating the unique identifier of the item.
ORGANIZATION_CODE	VARCHAR2	18			Unique Identifier of the Organization.
ORGANIZATION_ID	NUMBER		18		Unique identifier of Organization.
SOURCE_SYSTEM_ID	NUMBER		18		An external system from which items and its information is beign imported into product hub.
SOURCE_SYSTEM_REFERENCE	VARCHAR2	255			Unique identifier of the spoke item that an item is related to.
SOURCE_SYSTEM_CODE	VARCHAR2	30			Attribute indicating the source system code.
ITEM_COST_ID	NUMBER		18		Unique identifier of Item Cost row.
COST_SOURCE	VARCHAR2	1			This column indicates where the costing data for the Item came from.
CURRENCY_CODE	VARCHAR2	15			This is the currency of the cost information stored on the row.
MATERIAL_COST	NUMBER				The material cost to use for the Item.
LAST_CONTRACT_PRICE	NUMBER				Latest procurement price of the item.

Indexes

Index	Uniqueness	Tablespace	Columns
ACA_PD_ITEM_COST_INT_N1	Non Unique	Default	BATCH_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, PREPROCESS_THREAD_NUMBER
ACA_PD_ITEM_COST_INT_N2	Non Unique	Default	BATCH_ID, PREPROCESS_THREAD_NUMBER, PROCESS_STATUS, SOURCE_SYSTEM_ID, SOURCE_SYSTEM_REFERENCE
ACA_PD_ITEM_COST_INT_N3	Non Unique	Default	BATCH_ID, PREPROCESS_THREAD_NUMBER, TRANSACTION_ID
ACA_PD_ITEM_COST_INT_N4	Non Unique	Default	BATCH_NUMBER
ACA_PD_ITEM_COST_INT_N5	Non Unique	Default	BATCH_ID, PROCESS_STATUS, THREAD_NUMBER
ACA_PD_ITEM_COST_INT_N6	Non Unique	Default	LOAD_REQUEST_ID
ACA_PD_ITEM_COST_INT_U1	Unique	Default	INTERFACE_TABLE_UNIQUE_ID