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.
|
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.