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 will not be processed if the item type is a Service (S) or Good (G), 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.
Once you have established unit of measure information in the Units of Measure table in the Product Definition Controls menu, you can view or update the information stored in the Item U/M Conversion table in the Units of Measure Conversion subtask of the Basic Part Data screen in Costpoint Product Definition.
|
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 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 will be updated. If you did not select the Allow Multiple Revisions for Each Item checkbox in Product Definition settings, the revision will not be checked. |
|
Item Revision ID |
ITEM_ RVSN_ID |
Character 3 |
34 - 36 |
No |
If Item ID, Item Revision ID, U/M From, and U/M To for the U/M From and U/M To codes, the Item U/M Conversion table will be updated. If you did not select the Allow Multiple Revisions for Each Item checkbox in Product Definition settings, the revisions will not be checked. The default value is space. |
|
Unit of Measure Code From |
UM_CD_FR |
Character 3 |
37 - 39 |
Yes |
Value must exist in the U/M table (in the Product Definition Controls menu). |
|
Unit of Measure Code To |
UM_CD_ TO |
Character 3 |
40 - 42 |
Yes |
Value must exist in the U/M table (in the Product Definition Controls menu). |
|
Conversion Factor Rate |
*CONV_ FACT_RT |
Decimal 10.4 (maximum input file length - 12) |
43 - 54 |
No |
Default is "1." Input file format is "999999.9999" (maximum 12 characters including the decimal point and optional minus sign (indicating a negative number)). Maximum value is "999999.9999." Minimum value is "-999999.9999." Embedded commas are not allowed. |
|
Direction Flag |
*S_DIR_ IND_CD |
Character 1 |
55 |
No |
Value must be "D" (Divide) or "M" (Multiply). Default is "M." |
|
Rounding Type |
*S_ROUND_TYPE |
Character 1 |
56 |
No |
Value must be "D" (Down to last whole number), "N" (None, no rounding), or "U" (Up to next whole number). Default is "U." |
|
User ID last modified by |
*MODIFIED_BY |
Character 18 |
57 - 74 |
No |
If value is not provided, the program will modify the MODIFIED_BY column using the current user ID as the default. |