| SUPEROFFICE FIELD | DESCRIPTION | TYPE OF DATA REQUIRED | DUPLICATE CHECK | REMARK |
|---|
| Company ID | Unique internal company ID | Integer (SEE REMARK, normally you use code or number) | yes | WARNING: This is the unique company ID in the database, not visible in the SuperOffice user interface |
| Name* | Company name | Text string - Mandatory | yes |
|
| Department | The department name | Text string | yes |
|
| Code | The code field | Text string | yes |
|
| Number | The number field | Text string | yes |
|
| VAT No | VAT Number | Text string | yes |
|
| Stop | Stop sign on/off | True/False, 0/1 various values can be used (see section interests) | no | https://infobridgekb.atlassian.net/wiki/spaces/ND/pages/24248401/Specifications+of+the+Import+fields+in+DataBridge |
| Email | The main organization email address | Text string | no |
|
| Phone | Phone Number | Text string | no | With international numbers add the +sign or don't add the international part. (e.g. +31). Then SO will automaticly add the +31 based on country. |
| Fax | Fax Number | Text string | no | With international numbers add the +sign or don't add the international part. (e.g. +31). Then SO will automaticly add the +31 based on country. |
| Website | The URL of the organization website | Text string | no |
|
| Category | Name of the category | Text string (missing items can be added automatically) | no | https://infobridgekb.atlassian.net/wiki/spaces/ND/pages/24510872/Importing+list+items |
| Business | Name of business type | Text string (missing items can be added automatically) | no | https://infobridgekb.atlassian.net/wiki/spaces/ND/pages/24510872/Importing+list+items |
| Info | The paperclip note for an organization | Text string | no |
|
| No Mailings | No mailing on/off | True/False, 0/1 multiple values can be used (see section interests) | no | https://infobridgekb.atlassian.net/wiki/spaces/ND/pages/24248401/Specifications+of+the+Import+fields+in+DataBridge |
| Our contact | Contacts responsible person | SuperOffice initials or full name | no | https://kb.infobridge.com/hc/en-us/articles/115000892905-Link-a-record-to-an-associate-in-SuperOffice |
| Street addres line 1 | Organisazation address line 1 | Text string | yes |
|
| Street addres line 2 | Organisazation address line 2 | Text string | yes |
|
| Street addres line 3 | Organisazation address line 3 | Text string | yes |
|
| Street addres city | Organisazation city | Text string | yes |
|
| Street addres county | Organisazation county | Text string | yes |
|
| Street addres state | Organisazation state | Text string | yes |
|
| Street addres zip code | Organisazation zip code | Text string | yes |
|
| Postal addres line 1 | Organisazation address line 1 | Text string | yes |
|
| Postal addres line 2 | Organisazation address line 2 | Text string | yes |
|
| Postal addres line 3 | Organisazation address line 3 | Text string | yes |
|
| Postal addres city | Organisazation city | Text string | yes |
|
| Postal addres county | Organisazation county | Text string | yes |
|
| Postal addres state | Organisazation state | Text string | yes |
|
| Postal addres zip code | Organisazation zip code | Text string | yes |
|
| Country | Country of the organization | Full country name (Tip: Use transformations like NO=Norway) | no | https://kb.infobridge.com/hc/en-us/articles/115002651053-Transformations-for-DataBridge-Import |