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 RECEIPT 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
PAC_XFR_CO_FLAG	VARCHAR2	1			Indicates if a transfer shipment will use the prior period PAC cost or the current shipment cost as the transfer cost. This value is only applicable for transfer shipments using PAC cost method. Valid values are Y - Use prior period PAC cost, NULL - Use shipment cost.

Indexes

Index	Uniqueness	Columns
CST_INV_TXNS_SUMMARIZE_GT_U1	Unique	CST_INV_TRANSACTION_ID, COST_ORG_ID, COST_BOOK_ID