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 Conversion Line Layout (UMC)

The Item Unit of Measure Conversion (ITEM_UM_CONV) table stores the unit of measure conversion rates for parts.

The application cannot process ITEM_U/M Conversion Line Types unless the Item exists. This Line Type is not processed if the Item Type is a S (Service) or G (Good), as goods and services do not have U/M rows populated.  You can process multiple lines per item. The Item ID, Item Revision ID, U/M From, and U/M To combination must be unique for each U/M conversion.

After you have established unit of measure information on the Manage Units of Measure screen, you can view or update the information stored on the U/M Conversions subtask of the Manage Parts screen.

Note: The application uses default values from Costpoint (for existing parts) only if the input file field value is not 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 UMC is used to indicate Item Unit of Measure Conversion information.
Item ID ITEM_ID Character 30 4 - 33 Yes If the Item ID, Item Revision ID, From U/M, and To U/M exist for the U/M From and U/M To codes, the Item U/M Conversion 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 will not be 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 the Item ID, Item Revision ID, From U/M, and To U/M exist for the U/M From and U/M To codes, the Item U/M Conversion 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 revisions are 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 Code From UM_CD_FR Character 3 37 - 39 Yes The value must exist in the U/M table.
Unit of Measure Code To UM_CD_ TO Character 3 40 - 42 Yes The value must exist in the U/M table.
Conversion Factor Rate *CONV_ FACT_RT Decimal 10.4 (maximum input file length - 12) 43 - 54 No The default is 1. The input file format is 999999.9999 (maximum 12 characters including the decimal point and optional minus sign (indicating a negative number)). The maximum value is 999999.9999. The minimum value is -999999.9999. Embedded commas are not allowed.
Direction Flag *S_DIR_IND_CD Character 1 55 No The value must be D (Divide) or M (Multiply. The default is M.
Rounding Type *S_ROUND_TYPE Character 1 56 No The value must be D (Down to last whole number), N (None, no rounding), or U (Up to next whole number). The default is U.
User ID last modified by *MODIFIED_BY Character 18 57 - 74 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 by this preprocessor.