CST_INCOMING_TXN_COST_SOURCES

This table stores references to the PO and AP data that is the cause of the transaction cost. This table will be populated only for incoming costs for PO related transactions.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CST_INCOMING_TXN_COST_SOU_PK	CST_INV_TRANSACTION_ID, CMR_PO_DISTRIBUTION_ID, CMR_AP_INVOICE_DIST_ID, TRADE_OPERATION_ID, CHARGE_LINE_NUMBER, FISCAL_DOC_HEADER_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CST_INV_TRANSACTION_ID	NUMBER		18	Yes	Single column FK: Identifies the Inventory transaction.
CMR_PO_DISTRIBUTION_ID	NUMBER		18	Yes	Identifies the PO distribution that contributed to this acquisition cost.
PO_EVENT_DATE	TIMESTAMP				Identifies the event date of the PO distribution that contributed to this acquisition cost.
CMR_AP_INVOICE_DIST_ID	NUMBER		18	Yes	Identifies the AP invoice distribution that contributed to this acquisition cost.
TRADE_OPERATION_ID	NUMBER		18	Yes	Identifies the trade operation that contributed to this acquisition cost.
FISCAL_DOC_HEADER_ID	NUMBER		18	Yes	Single Column FK: Indiciates the fiscal document header.
CHARGE_LINE_NUMBER	NUMBER		9	Yes	Identifies the trade operation charge line that contributed to this acquisition cost
CONS_PRICE_UPD_EFFECTIVE_DATE	TIMESTAMP				Effective date of the consigned purchase order price update.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CST_INCOMING_TXN_COST_SOURCES	cst_inv_transactions	CST_INV_TRANSACTION_ID
CST_INCOMING_TXN_COST_SOURCES	cmr_ap_invoice_dtls	CMR_AP_INVOICE_DIST_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
CST_INCOMING_TXN_COST_SOURC_N1	Non Unique	FUSION_TS_TX_DATA	CST_INV_TRANSACTION_ID	Obsolete
CST_INCOMING_TXN_COST_SOURC_N2	Non Unique	FUSION_TS_TX_DATA	REQUEST_ID
CST_INCOMING_TXN_COST_SOU_UK1	Unique	FUSION_TS_TX_DATA	CST_INV_TRANSACTION_ID, CMR_PO_DISTRIBUTION_ID, CMR_AP_INVOICE_DIST_ID, TRADE_OPERATION_ID, CHARGE_LINE_NUMBER, FISCAL_DOC_HEADER_ID