EAM Columns

Column Names (partial list of columns) Instruction

-------------------------------------------------------------

PROCESS_FLAG--> Enter 1 for pending data to be imported.

After running the import process, the PROCESS_FLAG of the corresponding rows will be set to different values, 

indicating the results of the import (1 = Pending, 2 = Assign complete, 3 = Assign/validation failed,

 4 = Validation succeeded; import failed, 5 = Import in process, 6 = Import succeeded)

TRANSACTION_TYPE--> Enter CREATE to create a new item, or UPDATE to update existing items.

SET_PROCESS_ID--->Enter an arbitrary number. Rows designated with the same value for SET_PROCESS_ID will process together.

ORGANIZATION_CODE -->Enter the organization that the new item will import into.

SEGMENT1~20 --> Corresponds to the item name (for example, the name of the Asset Group, Asset Activity, or Rebuildable Item)

DESCRIPTION --> Enter the description of the item.

EAM_ITEM_TYPE --> Enter 1 for Asset Group, 2 for Asset Activity, or 3 for Rebuildable Item.

INVENTORY_ITEM_FLAG -->Enter Y for eAM items.

MTL_TRANSACTIONS_ENABLED_FLAG --> Enter N for eAM items.

EFFECTIVITY_CONTROL -->Enter 2 for Unit Effectivity Control for eAM Asset Groups.

SERIAL_NUMBER_CONTROL_CODE --> Enter 2 (Predefined) for Asset Groups; this should be NULL for Asset Activities.

AUTO_SERIAL_ALPHA_PREFIX --> Serial Number Prefix

START_AUTO_SERIAL_NUMBER ---> Start Serial Number