EAM Asset number and Attributes

 The two item interface tables to populate are MTL_EAM_ASSET_NUM_INTERFACE (MEANI), and the MTL_EAM_ATTR_VAL_INTERFACE (MEAVI). The MTL_EAM_ASSET_NUM_INTERFACE table stores relevant Asset Number information. If the asset's attributes are also imported, that information is stored in the MTL_EAM_ATTR_VAL_INTERFACE.

Column Name (partial list of columns)	Instruction
BATCH_ID	Enter an arbitrary number. Rows designated with the same BATCH_ID will process together.
PROCESS_FLAG	Enter a P for pending. This value will change to S if the import is successful, or E if the row contains an error.
IMPORT_MODE	Enter 0 to create new rows (asset numbers), or 1 to update existing rows.
IMPORT_SCOPE	Enter 0 to import both Asset Numbers and Attributes, 1 to import Asset Numbers only, or 2 to import Attributes only.
INVENTORY_ITEM_ID	Enter the Asset Group to associate with the imported Asset Number(s).
SERIAL_NUMBER	Enter the name of the Asset Number.
ORGANIZATION_CODE	Enter the current organization.
OWNING_DEPARTMENT_CODE	Enter the Owning Department of the asset number(s).
ERROR_CODE	This column will update by the Import process if an error occurs.
ERROR_MESSAGE	This column will update by the Import process if an error occurs.
INTERFACE_HEADER_ID	This is used with the identically named column in the MEAVI table, to relate the Attributes associated with an Asset Number.

Column Name (partial list of columns)	Instruction
PROCESS_STATUS	Enter P (Pending). This value will change to S if the import is successful, or E if the row contains an error.
INTERFACE_HEADER_ID	Foreign key of the identically named column in the MEANI table to relate to the Asset Number an Attribute is associated with.
INTERFACE_LINE_ID	A unique key
END_USER_COLUMN_NAME	Corresponds with the Attribute Name
ATTRIBUTE_CATEGORY	Corresponds with the Attribute Group
LINE_TYPE	Enter 1 if the Attribute is of type VARCHAR2, 2 if it is of type NUMBER, or 3 if it is of type DATE.
ATTRIBUTE_VARCHAR2_VALUE	Value of the Attribute; used with LINE_TYPE = 1
ATTRIBUTE_NUMBER_VALUE	Value of the Attribute; used with LINE_TYPE = 2
ATTRIBUTE_DATE_VALUE	Value of the Attribute; used with LINE_TYPE = 3
ERROR_NUMBER	This column will update by the Import process if an error occurs.
ERROR_MESSAGE	This column will update by the Import process if an error occurs.