1. Tables and Views for SCM
  2. CST_VALUATION_UNITS_GT

CST_VALUATION_UNITS_GT

The table is used to populate the valuation unit for Cost Org - Book - Inventory Item - Valuation Structure

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Columns

Name Datatype Length Precision Not-null Comments Status
COST_ORG_ID NUMBER 18 Yes Single column FK: Identifies the Cost Organization associated with the inventory organization. Active
COST_BOOK_ID NUMBER 18 Yes Single column FK: Identifies the Cost Book assigned to the Cost Organization. Active
INVENTORY_ITEM_ID NUMBER 18 Yes Inventory item identifier Active
EXPENSE_TRANSACTION_FLAG VARCHAR2 1 Yes Populated form the transaction, here it indicates what kind of valuation structure to be used; expense or asset. Active
INVENTORY_ORG_ID NUMBER 18 Indicates The Inventory Org To Which The Item Belongs Active
INVENTORY_ORG_ID_FLAG NUMBER 18 Flag to indicate if inventory organization is a segment of the valuation structure. Active
INVENTORY_ORG_ID_REQUIRED NUMBER 18 Flag to indicate if inventory organization is a mandatory segment of the valuation structure. Active
SUBINVENTORY_CODE VARCHAR2 240 The subinventory code where the item is stored Active
SUBINVENTORY_CODE_FLAG NUMBER 18 Flag to indicate if subinventory code is a segment of the valuation structure. Active
SUBINVENTORY_CODE_REQUIRED NUMBER 18 Flag to indicate if subinventory code is a mandatory segment of the valuation structure. Active
LOCATOR_ID NUMBER 18 Inventory locator identifier Active
LOCATOR_ID_FLAG NUMBER 18 Flag to indicate if location is a segment of the valuation structure. Active
LOCATOR_ID_REQUIRED NUMBER 18 Flag to indicate if location is a mandatory segment of the valuation structure. Active
PROJECT_ID NUMBER 18 Identifier of the project used to stripe Inventory transactions
PROJECT_ID_FLAG NUMBER 18 Flag to indicate if Project id is a segment of the valuation structure.
PROJECT_ID_REQUIRED NUMBER 18 Flag to indicate if Project id is a mandatory segment of the valuation structure.
TASK_ID NUMBER 18 Identifier of the task used to stripe Inventory transactions
TASK_ID_FLAG NUMBER 18 Flag to indicate if Task id is a segment of the valuation structure.
TASK_ID_REQUIRED NUMBER 18 Flag to indicate if Task id is a mandatory segment of the valuation structure.
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Code for the country of manufacture used to stripe Inventory transactions
COUNTRY_OF_ORIGIN_FLAG NUMBER 18 Flag to indicate if Country of origin is a segment of the valuation structure.
COUNTRY_OF_ORIGIN_REQUIRED NUMBER 18 Flag to indicate if Country of origin is a mandatory segment of the valuation structure.
LOT_NUMBER VARCHAR2 240 The lot number of the item Active
LOT_NUMBER_FLAG NUMBER 18 Flag to indicate if lot number is a segment of the valuation structure. Active
LOT_NUMBER_REQUIRED NUMBER 18 Flag to indicate if lot number is a mandatory segment of the valuation structure. Active
SERIAL_NUMBER VARCHAR2 240 Serial number of the item Active
SERIAL_NUMBER_FLAG NUMBER 18 Flag to indicate if serial number is a segment of the valuation structure. Active
SERIAL_NUMBER_REQUIRED NUMBER 18 Flag to indicate if serial number is a mandatory segment of the valuation structure. Active
GRADE_CODE VARCHAR2 240 Grade of the Lot for a grade controlled Item Active
GRADE_CODE_FLAG NUMBER 18 Flag to indicate if grade code is a segment of the valuation structure. Active
GRADE_CODE_REQUIRED NUMBER 18 Flag to indicate if grade code is a mandatory segment of the valuation structure. Active
COST_PROFILE_ID NUMBER 18 Yes The Cost profile for cost org - book - item - asset_identifier combination Active
VAL_STRUCTURE_ID NUMBER 18 Single column FK: Identifies the Valuation Structure. Active
STRUCTURE_INSTANCE_NUMBER NUMBER 18 Structure Instance number Active
VAL_STRUCTURE_MODE_CODE VARCHAR2 30 The mode of creation of valuation units. It can be AUTO, MANUAL or BOTH. Active
VAL_UNIT_ID NUMBER 18 Valuation unit identifier Active
VAL_UNIT_COMBINATION_ID NUMBER 18 Valuation Units Code Combination Identifier Active
STATUS VARCHAR2 30 The status whether the valuation unit could be found or created or not. Active
ERROR_CODE VARCHAR2 30 Error code in case neither the valuation was found nor was it created. Active
VAL_UNIT_DETAIL_ID NUMBER 18 Single column FK: Identifies the valuation unit detail line. Active
TOKEN1_NAME VARCHAR2 30 Message token name
TOKEN1_TYPE VARCHAR2 30 Since this message token is used for SEGMENT_NAME, the type column is used to get the column name as defined by the user in KFF tables.
TOKEN1_VALUE VARCHAR2 240 The value of the message token
CONSIGNED_FLAG VARCHAR2 1 Yes Indicates whether the transaction is consigned or owned.
OWNER_TYPE NUMBER 18 This is the party that transfers the ownership to the org where the ownership change happens. Values: 1 is SUPPLIER, 2 is INVENTORY_ORG and Null is when the transaction is not consigned
OWNING_ENTITY_ID NUMBER 18 This is the party that transfers the ownership to the org where the ownership change happens. Owner Type = SUPPLIER, represents the supplier site ID; Owner type = INVENTORY_ORG, represents the inventory org id
OWNER_NAME VARCHAR2 30 This is used for valuation unit generation for consigned scenarios
ORIGINAL_RECEIPT_TXN_ID NUMBER 18 Reference of the original receipt txn ID (Deliver txn ID) on the inter org receipt transactions. This is required to find the purchase order delivery to which the inter org receipt is linked to.
ORIGINAL_RECEIPT_NUMBER VARCHAR2 50 This column is used for valuation unit generation and is the combination of receipt number and the inventory org code.
OWNER_TYPE_FLAG NUMBER 18 Flag to indicate if owner type is a segment of the valuation structure. Active
OWNER_TYPE_REQUIRED NUMBER 18 Flag to indicate if owner type is a mandatory segment of the valuation structure. Active
OWNER_NAME_FLAG NUMBER 18 Flag to indicate if owner name is a segment of the valuation structure. Active
OWNER_NAME_REQUIRED NUMBER 18 Flag to indicate if owner name is a mandatory segment of the valuation structure. Active
ORIGINAL_RECEIPT_NUMBER_FLAG NUMBER 18 Flag to indicate if original receipt number is a segment of the valuation structure. Active
ORIGINAL_RECEIPT_NUMBER_REQ NUMBER 18 Flag to indicate if original receuot number is a mandatory segment of the valuation structure. Active
VU_STRUCTURE_COMPARE_FLAG VARCHAR2 1 Contains C if the VU structure is at Cost Org only or I if VU structure is at Cost Org & Inventory Org (and no other attributes)

Indexes

Index Uniqueness Columns Status
CST_VALUATION_UNITS_GT_U1 Unique COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, EXPENSE_TRANSACTION_FLAG, INVENTORY_ORG_ID, SUBINVENTORY_CODE, LOCATOR_ID, LOT_NUMBER, SERIAL_NUMBER, GRADE_CODE, COST_PROFILE_ID, OWNER_TYPE, OWNER_NAME, ORIGINAL_RECEIPT_NUMBER Obsolete
CST_VALUATION_UNITS_GT_U2 Unique COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, EXPENSE_TRANSACTION_FLAG, INVENTORY_ORG_ID, SUBINVENTORY_CODE, LOCATOR_ID, LOT_NUMBER, SERIAL_NUMBER, GRADE_CODE, COST_PROFILE_ID, OWNER_TYPE, OWNER_NAME, ORIGINAL_RECEIPT_NUMBER, PROJECT_ID, TASK_ID, COUNTRY_OF_ORIGIN_CODE