CST_INV_TXNS_SUMMARIZE_GT

This temporary table is used by cost processing during pre-processing stage when creating costing transactions to determine if the lot/serial details should be summarized or not.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CST_INV_TXNS_SUMMARIZE_GT_PK	CST_INV_TRANSACTION_ID, COST_ORG_ID, COST_BOOK_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
CST_INV_TRANSACTION_ID	NUMBER		18	Yes	Costing inventory transaction identifier for the transaction.	Active
COST_ORG_ID	NUMBER		18	Yes	Cost Org Identifier for the transaction.	Active
COST_BOOK_ID	NUMBER		18	Yes	Cost Book Identifier for the transaction.	Active
ITEM_COST_PROFILE_ID	NUMBER		18		Item Cost Profile Identifier for the transaction.	Active
COST_PROFILE_ID	NUMBER		18		Cost Profile Identifier for the transaction.	Active
STATUS	VARCHAR2	30			The status of whether cost profile was identified for the transaction.	Active
ERROR_CODE	VARCHAR2	30			Error code if the cost profile could not be identified for the transaction.	Active
LOGICAL_FLAG	VARCHAR2	1			Logical flag for the transaction.	Active
UOM_CODE	VARCHAR2	3			Unit of measure code for the transaction.	Active
CHECK_QTY_SIGN_FLAG	VARCHAR2	1			Whether or not to check the sign of the quantity to determine whether it is a ISSUE or a RECEIPT transaction.	Active
COST_TRANSACTION_TYPE	VARCHAR2	10			Costing transaction type which is either RECIPT or ISSUE.	Active
ADDITIONAL_PROCESSING_CODE	VARCHAR2	240			Specifies the transactions that are further classified with the cost transaction type. It can either be null or TRANSFER.	Active
TRANSACTION_FLOW_TYPE	NUMBER		18		Transaction Flow Identifier, 1 - Internal Drop Shipment, 2 - Global Procurement, 3 - Customer Drop Shipment, 4 - Intransit Interorg Transfer, 5 - Direct Interorg Transfer, 6 - Intraorg Transfer, 7 - Transfer Order Intransit Interorg Transfer, 8 - Transfer Order Direct Interorg Transfer, 9 - Transfer Order Intraorg Transfer, 10 - TIR/TIRR at ownership change in procuring org for consigned PO, 11 - TIRR of TO Return with Scrap or null for others.
USE_ITEM_COST_FLAG	VARCHAR2	1			Specifies whether to use the current item cost or the incoming cost.	Active
SUMMARIZE_TXN_FLAG	VARCHAR2	1			Whether to summarize the lot/serial details of the transaction. The value comes from cst_cost_profiles_b table.	Active

Indexes

Index	Uniqueness	Columns
CST_INV_TXNS_SUMMARIZE_GT_U1	Unique	CST_INV_TRANSACTION_ID, COST_ORG_ID, COST_BOOK_ID