--- sourceDocument: Xanadu IT Asset Management sourceDocumentLink: https://www.servicenow.com/docs/r/xanadu/it-asset-management Release : - xanadu ft:locale : - en-US ft:publication_title : - Xanadu IT Asset Management ft:clusterId : - itam bundleId : - itam workflow : - Technology --- # Mandatory fields in the bulk import spreadsheets # Mandatory fields in the bulk import spreadsheets {#ariaid-title1} * Release version: Xanadu * * Updated August 1, 2024 * * ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 4 minutes to read A list of the mandatory fields in the model, asset, and model and asset templates for bulk import in the Enterprise Asset Workspace. ## Mandatory fields for model template {#mandatory-bulk-fields__section_khb_cx2_3xb} {#mandatory-bulk-fields__table_eh1_gx2_3xb__entry__3} | Field/column | Mandatory for creating models | Mandatory for updating models | |-|-|-| | Index Note: Representing the row number can be used to identify a specific row. However, you need to fill this in manually. | Yes | Yes | | Manufacturer | Yes | Yes | | Model Name | Yes | Yes | | Model Number | Yes | Yes | | Model category | Yes | No | | Model type | Yes | No | | Parent model manufacturer | Yes, only for complex models. Note: Not applicable for single models. | No | | Parent model name | Yes, only for complex models. Note: Not applicable for single models. | No | | Parent model number | Yes, only for complex models. Note: Not applicable for single models. | No | | Component number | Yes, only for complex models. Note: Not applicable for single models. | No | | Component quantity | Yes, only for complex models. Note: Not applicable for single models. | No | | Required | Yes, only for complex models. Note: Not applicable for single models. | No | | Hot swappable | Yes, only for complex models. Note: Not applicable for single models. | No | | Repairable | Yes, only for complex models. Note: Not applicable for single models. | No | [ ] {#mandatory-bulk-fields__table_eh1_gx2_3xb} ## Mandatory fields for asset template {#mandatory-bulk-fields__section_qrm_4sg_3xb} {#mandatory-bulk-fields__table_bqz_psg_3xb__entry__3} | Field/column | Mandatory for creating assets | Mandatory for updating assets | |-|-|-| | Index Note: Representing the row number can be used to identify a specific row. However, you need to fill this in manually. | Yes | Yes | | Manufacturer | Yes | Yes | | Model | Yes | Yes | | Model Name | Yes | Yes | | Model Number | Yes | Yes | | Parent model manufacturer | Yes, only for complex assets. Note: Not applicable for single assets. | Yes | | Parent model name | Yes, only for complex assets. Note: Not applicable for single assets. | Yes | | Parent model number | Yes, only for complex assets. Note: Not applicable for single assets. | Yes | | Component number | Yes, only for complex assets. Note: Not applicable for single assets. | Yes | | Asset Tag | Yes | Yes | | Serial Number | Yes | No | | MAC Address | Yes | No | | Parent asset | Conditional Note: Required for child assets when parent model information is provided. | Conditional Note: Required for child assets when parent model information is provided. | | Quantity | Conditional Note: Required for consumable assets (positive number). | No Note: Consumable assets cannot be updated. | | State | Yes | No | | Sub state | Yes | No | | Stockroom | Conditional Note: Required for In stock and Build states. | Conditional Note: Required for In stock and Build states. | | Location | Conditional Note: Required for In stock, In use, and Build states. | Conditional Note: Required for In stock, In use, and Build states. | | Install status | Yes | Yes | | Substatus | Conditional Note: Required for In stock state only. | Conditional Note: Required for In stock state only. | | Component ID | Conditional Note: Required for child assets when applicable. | No | | OT entity | Conditional Note: Required as true for hardware models when the OT Asset Management application is activated. | Conditional Note: Required as true for hardware models when the OT Asset Management application is activated. | [ ] {#mandatory-bulk-fields__table_bqz_psg_3xb} ## Mandatory fields for model and asset template {#mandatory-bulk-fields__section_bms_yyj_3xb} {#mandatory-bulk-fields__table_ukz_yyj_3xb__entry__3} | Field/column | Mandatory for creating models and assets | Mandatory for updating models and assets | |-|-|-| | Index Note: Representing the row number can be used to identify a specific row. However, you need to fill this in manually. | Yes | Yes | | Manufacturer | Yes | Yes | | Model Name | Yes | Yes | | Model Number | Yes | Yes | | Model category | Yes | Yes | | Model type | Yes | Yes | | Parent model manufacturer | Yes Note: Not applicable for single models and single assets. | Yes | | Parent model name | Yes Note: Not applicable for single models and single assets. | Yes | | Parent model number | Yes Note: Not applicable for single models and single assets. | Yes | | Component number | Yes Note: Not applicable for single models and single assets. | No | | Component quantity | Yes Note: Not applicable for single models and single assets. | No | | Required | Yes Note: Not applicable for single models and single assets. | No | | Hot swappable | Yes Note: Not applicable for single models and single assets. | No | | Repairable | Yes Note: Not applicable for single models and single assets. | No | | Asset Tag | Yes | Yes | | Serial Number | Yes | No | | MAC Address | Yes | No | | Parent asset | Yes Note: Not applicable for single models and single assets. | No | | Quantity | Yes | No | | State | Yes | No | | Sub state | Yes | No | | Stockroom | Conditional Note: Required for In stock and Build states. | Conditional Note: Required for In stock and Build states. | | Location | Conditional Note: Required for In stock, In use, and Build states. | Conditional Note: Required for In stock, In use, and Build states. | [ ] {#mandatory-bulk-fields__table_ukz_yyj_3xb} ## Unit of measurement fields {#mandatory-bulk-fields__section_tlt_2sm_ngc} {#mandatory-bulk-fields__table_ult_2sm_ngc__entry__3} | Field/column | Mandatory for creating models | Mandatory for updating models | |-|-|-| | Dimensions Unit | Conditional Note: Required if length, width, height, or depth is provided. | Conditional Note: Required if length, width, height, or depth is provided. | | Weight Unit | Conditional Note: Required if the weight_decimal value is provided. | Conditional Note: Required if the weight_decimal value is provided. | | Volume Unit | Conditional Note: Required if the volume is provided. | Conditional Note: Required if the volume is provided. | | Current Unit | Conditional Note: Required if the value is provided for Current. | Conditional Note: Required if the value is provided for Current. | | Power Unit | Conditional Note: Required if the rated_power value is provided. | Conditional Note: Required if rated_power is provided. | | Voltage Unit | Conditional Note: Required if the voltage value is provided. | Conditional Note: Required if voltage is provided. | | Cooling Unit | Conditional Note: Required if the cooling value is provided (Enterprise models only). | Conditional Note: Required if the cooling value is provided (Enterprise models only). | | Pressure Unit | Conditional Note: Required if the pressure value is provided (Enterprise models only). | Conditional Note: Required if the pressure value is provided (Enterprise models only). | | Temperature Unit | Conditional Note: Required if the temperature value is provided (Enterprise models only). | Conditional Note: Required if the temperature value is provided (Enterprise models only). | [ ] {#mandatory-bulk-fields__table_ult_2sm_ngc} ## Reference fields validation {#mandatory-bulk-fields__section_jc5_ltm_ngc} The values entered in the following columns should exist in the database: * PO Number * Assigned To * Department * Company * Cost Center * Asset Depreciation * Aisle Space Location {#mandatory-bulk-fields__ul_ipv_5qv_ngc} **Related concepts** * [Domain separation and Enterprise Asset Management](https://www.servicenow.com/docs/vj2Zp5rCpFGmp9KI7Z5J2A "Domain separation is supported in Enterprise Asset Management. Domain separation enables you to separate data, processes, and administrative tasks into logical groupings called domains. You can control several aspects of this separation, including which users can see and access data.") **Related reference** * [Enterprise Asset Management roles](https://www.servicenow.com/docs/2ZO1p2jB_3CdlhBi09o~OA "The following roles help you to configure and use the Enterprise Asset Management application to manage the life cycle of your assets, parts, and their hierarchical relationships.") * [Enterprise model categories and corresponding classes](https://www.servicenow.com/docs/g5YZFGl8n68Ycb85CzS8_A "Enterprise model categories and their corresponding Configuration Management Database (CMDB) configuration item (CI), asset, and model classes.") * [Normalization status for enterprise models](https://www.servicenow.com/docs/BKipr4KJYmN_3iJUbBOzNg "Description of the normalization statuses for enterprise models.") * [Model fields for Enterprise Asset Management](https://www.servicenow.com/docs/VmE_XaYgGV~H2H9a5SEFUQ "A detailed description of all model fields in the Enterprise Asset Management application.") * [Contract fields for Enterprise Asset Management](https://www.servicenow.com/docs/g5thkxjs3zWGTPoLuLOmbw "A detailed description of all contract fields in the Enterprise Asset Management application.") * [Maintenance plan fields for Enterprise Asset Management](https://www.servicenow.com/docs/zmOLMBuJBIMaykVpiL2~4w "A detailed description of all maintenance plan fields in the Enterprise Asset Management application.") * [Maintenance schedule fields for Enterprise Asset Management](https://www.servicenow.com/docs/D1pRTUxzRlNaz1hmTjiZdg "A detailed description of all maintenance schedule fields in the Enterprise Asset Management application.") * [Work plan fields for Enterprise Asset Management](https://www.servicenow.com/docs/4cBel9qWmkOS0AVE9uE2iA "A detailed description of all work plan fields in the Enterprise Asset Management application.") * [Work plan schedule fields for Enterprise Asset Management](https://www.servicenow.com/docs/a9GUTtspIomLAjJO~rraow "A detailed description of all the work plan schedule fields in the Enterprise Asset Management application.") * [Expense line fields for Enterprise Asset Management](https://www.servicenow.com/docs/eP7u5zJCz1U~ltUTLibOGQ "A detailed description of all expense line fields in the Enterprise Asset Management application.") * [Fields inherited from a parent asset group to a sub group](https://www.servicenow.com/docs/H6THFTCeQ2dzlya6IK2fBQ "A list of all the fields that are inherited from the parent asset group to a subgroup.") * [Enterprise asset disposal order stages](https://www.servicenow.com/docs/2dbVGCvJy7YI8fR1gFR0GA "An enterprise asset disposal order goes through various stages in the disposal process before it’s completed. With each stage, the task that's associated with that stage changes too.") * [Terminology for linear assets](https://www.servicenow.com/docs/Co91GMw8oxi1KRf695bLfw "Terms commonly used for linear assets in the Enterprise Asset Management application.") * [Installed with Enterprise Asset Management for Healthcare](https://www.servicenow.com/docs/X3aQOFVK9NX0h6rs4xY0OQ "The user role components, plugins, and applications are installed with activation of the com.sn_eamhc plugin.") * [Installed with OT Asset Management](https://www.servicenow.com/docs/YjLjuZQtPo7rU11UDwuA4g "The user role components, plugins, and applications are installed with activation of the com.sn_otam plugin.") * [Asset put away task fields](https://www.servicenow.com/docs/ldFbaDXU~1brDqq7u~i9Jg "Fields on the Asset put away task form help you create a put away task for the in stock assets.")