Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Item Unit of Measure Line Layout (IUM)

The Item Unit of Measure (ITEM_UM) table stores the unit of measure in which the part can be expressed. 

The Unit of Measure associated with the part can vary in terms of inventory, ordering, and selling.

The application cannot process Item U/M Line Types unless the Item table (ITEM) exists. This Line Type is not processed if the Item Type (in the ITEM table) is an S (Service) or G (Good), as goods and services do not have U/M rows populated. You can have two Item U/M Line Type lines per ITEM_ID. If neither is provided, Costpoint creates the values using the Default U/M from the Item table (that is, one for S (Selling) and one for O (Order)). Inventory U/M Types are not accepted. A part must have three U/M type lines per PART_KEY (inventory, sales, and order). 

You can view or update the information stored in this table on the Units of Measure subtask of the Manage Parts screen.

Note: The application uses default values for INSERTS ONLY if the input file field value is not provided. The exception is MODIFIED_BY, which is updated using the default value if no value is provided.
Input File Field Costpoint Column Column Type and Max Length Starting/Ending Position Required Values, Defaults, and Notes
Line Type Character 3 1 -3 Yes IUM is used to indicate Item Unit of Measure information.
Item ID ITEM_ID Character 30 4 - 33 No If the Item ID/Item Revision ID/Unit of Measure Type exists, the ITEM_UM table is updated. If you did not select the Allow Multiple Revisions for Each Item check box on the Configure Product Definition Settings screen, the revision is not checked.

The fixed length file format accepts 30 characters while delimited file format accepts up to 50 characters.

Item Revision ID ITEM_RVSN_ID Character 3 34 - 36 Yes (if revisions are used) If an Item ID/Item Revision ID/Unit of Measure Type exists, the ITEM_UM table is updated. If you did not select the Allow Multiple Revisions for Each Item check box on the Configure Product Definition Settings screen, the revision is not checked. The default is a space.

The fixed length file format accepts 3 characters while delimited file format accepts up to 10 characters.

Unit of Measure Type S_UM_TYPE Character 1 37 Yes. Must be S (Selling) or O (Order). I (Inventory) is rejected. The Inventory value is always the same as the Default U/M in the ITEM table.
Unit of Measure Code *UM_CD Character 3 38 - 40 No If a UM_CD is provided, the U/M must exist in the Units of Measure table. This is the Default U/M (from ITEM table).
User ID last modified by *MODIFIED_BY Character 18 41 - 58 No The default is UPLOAD. If a value is not provided, the program modifies the MODIFIED_BY column using the current user ID as the default.

* Indicates columns that may be updated when changing an existing record with this preprocessor.