CST_CP_MAIN_GT

Temporary table used for chunking high volume data in the Cost Processor.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Precision Comments
COST_ORG_ID NUMBER 18 Identifies the Cost Organization associated with the inventory organization.
COST_BOOK_ID NUMBER 18 Identifies the Cost Book assigned to the Cost Organization.
INVENTORY_ITEM_ID NUMBER 18 Inventory Item Identifier

Indexes

Index Uniqueness Columns
CST_CP_MAIN_GT_N1 Non Unique COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID
CST_CP_MAIN_GT_N2 Non Unique INVENTORY_ITEM_ID