CST_TRADE_SALES_TXNS_GT

This global temp table contains the Trade Sales Issue and Trade Sales Return transactions.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CST_TRADE_SALES_TXNS_GT_PK	EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
EXTERNAL_SYSTEM_REFERENCE	VARCHAR2	60		Yes	Reference information from an external system (external to Cost Management).
EXTERNAL_SYSTEM_REF_ID	VARCHAR2	30		Yes	Stores a value that uniquely identifies a certain instance of an object within the external system.
TRANSACTION_TYPE	VARCHAR2	30		Yes	Trade event transaction type. Example: Trade Sales Issue, Trade Sales Return
DOO_FULLFILL_LINE_ID	NUMBER		18		Reference to the unique identifier of the source fulfillment line in distributed order orchestration (DOO).
DOO_SPLIT_FULFILL_LINE_ID	NUMBER		18		Reference to the distributed order orchestration (DOO) fulfillment line identifier.
WSH_DELIVERY_DETAIL_ID	NUMBER		18		Shipping delivery detail identifier.
OWNERSHIP_CHANGE_EVENT_TYPE	VARCHAR2	100			The type of event associated to the ownership change transaction.
OWNERSHIP_CHANGE_TXN_ID	VARCHAR2	100			The transaction that triggered the ownership change. Example: ASN, AP invoice
TRANSACTION_EVENT_ID	NUMBER		18		This is a unique key which identifies AP Invoice Match events from SFO.
RCV_TRANSACTION_ID	NUMBER		18		Receiving transaction identifier.
FULFILLMENT_UPDATE_FLAG	VARCHAR2	1			A flag that indicates if the backordered fulfillment line is updated in Fusion Order Management. Possible values are: Y: Indicates that the fulfillment is updated. NULL: Indicates that the fulfillment is not updated.

Indexes

Index	Uniqueness	Columns
CST_TRADE_SALES_TXNS_GT_U1	Unique	EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID