The following is an explanation of each of the fields you can provide when importing Locations.
| Field Name | Required? | Maximum length | Description | Accepted Values | Additional Information |
| Location Name* | Yes | 100 characters | The name of this Location. | Key field. Requires an exact match with the desired Location's name (for updating). |
|
| Active? | No | N/A | Denotes if this Location is active or inactive. | Active Inactive |
Requires an exact match with one of the accepted values. All records are automatically set to Active when created; they cannot be created and set to inactive in the same import. |
| Description | No | 4000 characters | The description of this Location. | ||
| Location ID* | Yes | 20 characters | The ID of this Location. | Key field. Requires an exact match with the desired Location's name (for updating). |
|
| Parent Location Name | No | 100 characters | The name of this Location's parent. | Requires an exact match with the desired Location's name. | |
| Parent Location ID | No | 40 characters | The ID of this Location's parent. | Requires an exact match with the desired Location's name. The desired Location must be active in Bill.com, or created during the same import. |
Please note: If you are specifying the Parent Location, both Parent Location Name and Parent Location ID MUST be provided.