CSV data migration for accounts
Column list
| Name | Description | Type | Required |
|---|---|---|---|
| EXTERNAL_ID | Unique identifier of the company | string of max 255 characters | ✅ |
| COMPANYNAME | Company name | string of max 255 characters | ✅ |
| PARENT_EXTERNAL_ID | Unique identifier of the parent company | string of max 255 characters | |
| POTENTIAL | Account potential (1 = P1, 2 = P2, etc.) | integer | |
| RATING | Customer relationship (1 = one star, etc.) | integer | |
| MANAGER_EXTERNAL_ID | Unique identifier of the account manager | string of max 255 characters | |
| CATEGORY | Account category (enter the label of the matching category in the reference table) | string of max 255 characters | |
| TYPE | Account type (0 = other, 1 = customer, 2 = prospect, 3 = Partner, 4 = Supplier) | integer, 0 by default (other) | |
| SECTOR | Account sector (enter the label of the matching sector in the reference table) | string of max 255 characters | |
| SIZE | Account size (enter the label of the matching size in the reference table) | string of max 255 characters | |
| SIRET | Account SIRET | string of max 255 characters | |
| SIREN | Account SIREN | string of max 255 characters | |
| ORIGIN | Account origin (enter the label of the matching origin in the reference table) | string of max 255 characters | |
| VATID | Account VAT number | string of max 255 characters | |
| APECODE | Account NAF/APE code | string of max 255 characters | |
| LINKEDINUSERNAME | Account LinkedIn username | string of max 255 characters | |
| ISINDIVIDUAL | Indicates whether the account is an individual (=True) or a company (=False) | boolean, False by default | |
| POTENTIAL_AMOUNT | Potential sales amount | decimal | |
| START_DATE | Customer since this date | datetime in YYYY-MM-DD format | |
| REVENUE | Revenue achieved | integer | |
| TOPPRIORITY | Indicates whether the account is a priority (=True) or not (=False | boolean, False by default | |
| ADDR1TYPE | Address 1 type (0 = office, 1 = headquarters, 2 = billing, 3 = delivery, 4 = other, 5 = pickup) | integer | ✅ if address 1 is filled in |
| ADDR1STREETLINE1 | Address 1 street line 1 | string of max 255 characters | |
| ADDR1STREETLINE2 | Address 1 street line 2 | string of max 255 characters | |
| ADDR1ZIPCODE | Address 1 postal code | string of max 255 characters | |
| ADDR1CITY | Address 1 city | string of max 255 characters | |
| ADDR1STATE | Address 1 region | string of max 255 characters | |
| ADDR1COUNTRY | Address 1 country | string of max 255 characters | |
| ADDR2TYPE | Address 2 type (0 = office, 1 = headquarters, 2 = billing, 3 = delivery, 4 = other, 5 = pickup) | integer | ✅ if address 2 is filled in |
| ADDR2STREETLINE1 | Address 2 street line 1 | string of max 255 characters | |
| ADDR2STREETLINE2 | Address 2 street line 2 | string of max 255 characters | |
| ADDR2ZIPCODE | Address 2 postal code | string of max 255 characters | |
| ADDR2CITY | Address 2 city | string of max 255 characters | |
| ADDR2STATE | Address 2 region | string of max 255 characters | |
| ADDR2COUNTRY | Address 2 country | string of max 255 characters | |
| PHONE1TYPE | Phone 1 type (0 = office, 1 = home, 2 = mobile, 3 = other, 4 = fax) | integer | ✅ if PHONE1VALUE is filled in |
| PHONE1VALUE | Phone number 1 | string of max 255 characters | |
| PHONE2TYPE | Phone 2 type | integer | ✅ if PHONE2VALUE is filled in |
| PHONE2VALUE | Phone number 2 | string of max 255 characters | |
| EMAIL1 | Account email 1 | string of max 255 characters | |
| EMAIL2 | Account email 2 | string of max 255 characters | |
| WEBSITE1 | Account website 1 | string of max 255 characters | |
| WEBSITE2 | Account website 2 | string of max 255 characters | |
| NOTE | Notes on the account | string of max 4000 characters | |
| EMAIL3 | Account email 3 | string of max 255 characters | |
| EMAIL4 | Account email 4 | string of max 255 characters | |
| EMAIL5 | Account email 5 | string of max 255 characters | |
| EMAIL6 | Account email 6 | string of max 255 characters | |
| EMAIL7 | Account email 7 | string of max 255 characters | |
| REFERENCE_CODE | Account internal code | string of max 255 characters | |
| MOBICRM_ID | MobiCRM internal identifier | string of max 255 characters |
