CST_TRANSACTIONS_GT

This table is used for storing all the transactions that are resulted for the given search parameters for Review Cost Accounting Distributions BIP Report.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CST_TRANSACTIONS_GT_PK	TRANSACTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TRANSACTION_ID	NUMBER		18	Yes	Transaction identifier which uniquely identifies a transaction in costing.
COST_ORG_NAME	VARCHAR2	240		Yes	Denotes the translated name for the Cost Organization Unit.
COST_BOOK_CODE	VARCHAR2	30		Yes	A unique code given for a particular cost book. Usually named to indicate the purpose of that cost book.
ITEM_NUMBER	VARCHAR2	300		Yes	Value that identifies the inventory item associated with the transaction.
INVENTORY_ORG_NAME	VARCHAR2	240			Denotes the translated name for the Inventory Organization Unit.
TRANSACTION_NUMBER	VARCHAR2	240			Transaction source doc type and txn_source_doc_number  separated with '-'.
TRANSACTION_DATE	TIMESTAMP				The date when this transaction happened.
COST_DATE	TIMESTAMP				The date to be used for transaction sequencing.
TXN_SOURCE_REF_DOC_TYPE	VARCHAR2	50			Transactions Source Documents Reference Document Type.
TXN_SOURCE_REF_DOC_NUMBER	VARCHAR2	240			Transactions Source Documents Reference Document Number.
COSTING_STATUS	VARCHAR2	1			Status of the transaction which denotes, whether a transaction has been pre-processed, processed by cost processors, distributions have been created or processed by sub-ledger accounting.
RESOURCE_NAME	VARCHAR2	120			Indicates the name of the resource.
LE_TIMEZONE_CODE	VARCHAR2	50			Indicates Legal Entity Timezone for transaction.
TRANSACTION_TYPE	VARCHAR2	80			Transaction type name translated to the language.

Indexes

Index	Uniqueness	Columns
CST_TRANSACTIONS_GT_U1	Unique	TRANSACTION_ID