--- title: Mandatory fields in the bulk import spreadsheets description: A list of the mandatory fields in the model, asset, and model and asset templates for bulk import in the Enterprise Asset Workspace. locale: en-US canonical_url: https://www.servicenow.com/docs/r/australia/it-asset-management/enterprise-asset-management/mandatory-bulk-fields.html release: australia product: Enterprise Asset Management classification: enterprise-asset-management topic_type: reference last_updated: "2025-07-31" reading_time_minutes: 7 breadcrumb: [Enterprise Asset Management reference, Enterprise Asset Management, Asset Management] --- # Mandatory fields in the bulk import spreadsheets 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
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 must 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. No
Parent model name Yes**Note:** Not applicable for single models. No
Parent model number Yes**Note:** Not applicable for single models. No
Component number Yes**Note:** Not applicable for single models. No
Component quantity Yes**Note:** Not applicable for single models. No
Required Yes**Note:** Not applicable for single models. No
Hot swappable Yes**Note:** Not applicable for single models. No
Repairable Yes**Note:** Not applicable for single models. No
## Mandatory fields for asset template
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 must fill this in manually. Yes Yes
Manufacturer Yes Yes
Model Yes Yes
Model Name Yes Yes
Model Number Yes Yes
Parent model manufacturer Yes**Note:** Not applicable for single assets. Yes**Note:** Not applicable for single assets.
Parent model name Yes**Note:** Not applicable for single assets. Yes**Note:** Not applicable for single assets.
Parent model number Yes**Note:** Not applicable for single assets. Yes**Note:** Not applicable for single assets.
Component number Yes**Note:** Not applicable for single assets. Yes
Asset Tag Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. Conditional**Note:** At least one unique identifier is required for non-consumables based on model category.
Serial Number Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. Conditional**Note:** At least one unique identifier is required for non-consumables based on model category.
MAC Address Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. Conditional**Note:** At least one unique identifier is required for non-consumables based on model category.
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 fields for model and asset template
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 must 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 Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. Conditional**Note:** At least one unique identifier is required for non-consumables based on model category.
Serial Number Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. Conditional**Note:** At least one unique identifier is required for non-consumables based on model category.
MAC Address Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. Conditional**Note:** At least one unique identifier is required for non-consumables based on model category.
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.
## Unit of measurement fields
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\).
## Reference fields validation The values entered in the following columns must exist in the database: - Manufacturer - Model failure impact - Model failure likelihood - Owner - Stockroom - Location - Managed by - Owned by - Reserved for - Supported by - Vendor - Asset failure impact - Asset failure likelihood **Parent Topic:**[Enterprise Asset Management reference](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-asset-management/enterprise-asset-management/reference-enterprise-asset-management.md) **Related topics** [Domain separation and Enterprise Asset Management]() [Components installed with Enterprise Asset Management]() [OT Asset Workspace roles]() [Asset fields for enterprise assets]() [Asset audit fields for enterprise assets]() [Audit results]() [Enterprise model categories and corresponding classes]() [Normalization status for enterprise models]() [Model fields for Enterprise Asset Management]() [Contract fields for Enterprise Asset Management]() [Maintenance plan fields for Enterprise Asset Management]() [Maintenance schedule fields for Enterprise Asset Management]() [Work plan fields for Enterprise Asset Management]() [Work plan schedule fields for Enterprise Asset Management]() [Expense line fields for Enterprise Asset Management]() [Fields inherited from a parent asset group to a sub group]() [Enterprise asset disposal order stages]() [Terminology for linear assets]() [Scheduled jobs and tables installed with normalization of firmware models]() [Asset put away task fields]()