ITEM UNIT OF MEASURE LINE (IUM)

Item Unit of Measure Line Layout

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 will not be 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, the system will create the values using the Default U/M from the Item table (i.e., one for "S" (Selling) and one for "O" (Order)) Inventory U/M Types will not be 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 in the Maintain Parts and Basic Part Data screens (Units of Measure Types subtask) in Costpoint Product Definition.

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 Item ID/Item Revision ID/Unit of Measure Type exists, ITEM_UM 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	Yes (if revisions are used)	If Item ID/Item Revision ID/Unit of Measure Type exists, ITEM_UM 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.
Unit of Measure Type	S_UM_TYPE	Character 1	37	Yes.	Must be "S" (Selling) or "O" (Order). "I" (Inventory) will be rejected. Inventory value will always be the same as the Default U/M in the ITEM table.
Unit of Measure Code	*UM_CD	Character 3	38 - 40	No	If UM_CD is provided, U/M must exist in Units of Measure table (in the Product Definition Controls menu). Will be Default U/M (from ITEM table).
User ID last modified by	*MODIFIED_BY	Character 18	41 - 58	No	If value is not provided, the program will modify 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.