CST_REJECTED_TE_COSTS

This table will take backup of trade event costs before deleting them as duplicates or orphans.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CST_REJECTED_TE_COSTS_PK	TRADE_EVENT_INTF_COST_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TRADE_EVENT_INTF_COST_ID	NUMBER		18	Yes	Unique Identifier for the Trade event cost archive
EXTERNAL_SYSTEM_REFERENCE	VARCHAR2	60		Yes	EXTERNAL_SYSTEM_REFERENCE
EXTERNAL_SYSTEM_REF_ID	VARCHAR2	30		Yes	EXTERNAL_SYSTEM_REF_ID
TRANSFER_PRICE_COMPONENT	VARCHAR2	100		Yes	Transfer Price Component
UNIT_COST	NUMBER				Unit Cost
CURRENCY_CODE	VARCHAR2	15			Currency of the Unit Cost
UOM_CODE	VARCHAR2	3			UOM of the Unit Cost
EXTENDED_AMOUNT	NUMBER				This column is used to hold the transfer value (transfer price * quantity in transactional UOM of the item) interfaced by Supply Chain Financial Orchestration.
TRANSACTION_AMOUNT	NUMBER				Transaction amount for service line type purchase orders.
INTF_ROW_CREATION_DATE	TIMESTAMP			Yes	Row Creation Date in Interface table.
ARCHIVE_TYPE	VARCHAR2	20			Reason for Archiving. Possible Value Duplicate
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created 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.

Indexes

Index	Uniqueness	Tablespace	Columns
CST_REJECTED_TE_COSTS_PK	Unique	Default	TRADE_EVENT_INTF_COST_ID