# Addresses: Exact Online Addresses - Catalog: `ExactOnlineREST` - Schema: `CRM` - Primary Keys: `ID` - Label: Addresses The data in this table is partitioned per value of the `Division` column. Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Addresses` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Account` | `guid` | Account | ☐ | Account linked to the address. | | `AccountIsSupplier` | `char` | Account Is Supplier | ☐ | Indicates if the account is a supplier. | | `AccountName` | `varchar2`(50) | Account Name | ☐ | Name of the account. | | `AddressLine1` | `varchar2`(80) | Address Line 1 | ☐ | First address line. | | `AddressLine2` | `varchar2`(80) | Address Line 2 | ☐ | Second address line. | | `AddressLine3` | `varchar2`(80) | Address Line 3 | ☐ | Third address line. | | `City` | `varchar2`(30) | City | ☐ | City. | | `Contact` | `guid` | Contact | ☐ | Contact linked to Address. | | `ContactName` | `varchar2` | Contact Name | ☐ | Contact name. | | `Country` | `varchar2`(30) | Country | ☐ | Country code. | | `CountryName` | `varchar2` | Country Name | ☐ | Country name. | | `Created` | `datetime` | Created | ☐ | Creation date. | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | User ID of creator. | | `CreatorFullName` | `varchar2`(240) | Creator Full Name | ☐ | Name of creator. | | `CustomField` | `varchar2` | Custom Field | ☐ | | | `Division` | `int32` | Division | ☐ | Division code. | | `DivisionCompanyCoCNumber` | `varchar2`(60) | Division Chamber of Commerce Number | ☐ | Chamber of commerce number of the Exact Online division. | | `DivisionCompanyIBANNumber` | `varchar2`(50) | Division IBAN Number | ☐ | IBAN number of the Exact Online division. | | `DivisionCompanyName` | `varchar2`(50) | Division Company Name | ☑ | Company name of the Exact Online division. | | `DivisionCompanyRSINNumber` | `varchar2`(9) | Division RSIN Number | ☐ | RSIN number of the Exact Online division. | | `DivisionCompanyVATNumber` | `varchar2`(35) | Division VAT Number | ☐ | VAT number of the Exact Online division. | | `DivisionCompanyWageTaxNumber` | `varchar2`(60) | Division Wage Tax Number | ☐ | Wage tax number of the Exact Online division. | | `DivisionLabel` | `varchar2`(128) | Division Label | ☑ | Label of the Exact Online division. | | `DivisionName` | `varchar2`(50) | Administration Name | ☑ | Name of the Exact Online division. | | `DivisionOwnerCompanyName` | `varchar2`(50) | Subscription Holder Name | ☑ | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionOwnerCompanyNumber` | `varchar2`(18) | Subscription Holder Number | ☑ | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionShortName` | `int64` | Division Short Name | ☑ | Short name of the Exact Online division. | | `Fax` | `varchar2`(25) | Fax | ☐ | Fax number. | | `FreeBoolField_01` | `char` | Free Boolean Field #1 | ☐ | Free boolean field 1. | | `FreeBoolField_02` | `char` | Free Boolean Field #2 | ☐ | Free boolean field 2. | | `FreeBoolField_03` | `char` | Free Boolean Field #3 | ☐ | Free boolean field 3. | | `FreeBoolField_04` | `char` | Free Boolean Field #4 | ☐ | Free boolean field 4. | | `FreeBoolField_05` | `char` | Free Boolean Field #5 | ☐ | Free boolean field 5. | | `FreeDateField_01` | `datetime` | Free Date Field #1 | ☐ | Free date field 1. | | `FreeDateField_02` | `datetime` | Free Date Field #2 | ☐ | Free date field 2. | | `FreeDateField_03` | `datetime` | Free Date Field #3 | ☐ | Free date field 3. | | `FreeDateField_04` | `datetime` | Free Date Field #4 | ☐ | Free date field 4. | | `FreeDateField_05` | `datetime` | Free Date Field #5 | ☐ | Free date field 5. | | `FreeNumberField_01` | `double` | Free Number Field #1 | ☐ | Free number field 1. | | `FreeNumberField_02` | `double` | Free Number Field #2 | ☐ | Free number field 2. | | `FreeNumberField_03` | `double` | Free Number Field #3 | ☐ | Free number field 3. | | `FreeNumberField_04` | `double` | Free Number Field #4 | ☐ | Free number field 4. | | `FreeNumberField_05` | `double` | Free Number Field #5 | ☐ | Free number field 5. | | `FreeTextField_01` | `varchar2` | Free Text Field #1 | ☐ | Free text field 1. | | `FreeTextField_02` | `varchar2` | Free Text Field #2 | ☐ | Free text field 2. | | `FreeTextField_03` | `varchar2` | Free Text Field #3 | ☐ | Free text field 3. | | `FreeTextField_04` | `varchar2` | Free Text Field #4 | ☐ | Free text field 4. | | `FreeTextField_05` | `varchar2` | Free Text Field #5 | ☐ | Free text field 5. | | `ID` | `guid` | ID | ☑ | Primary key. | | `Mailbox` | `varchar2`(60) | Mailbox | ☐ | Mailbox. | | `Main` | `char` | Main | ☐ | Indicates if the address is the main address for this type. | | `Modified` | `datetime` | Modified | ☐ | Last modified date. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `ModifierFullName` | `varchar2`(240) | Modified Full Name | ☐ | Name of modifier. | | `NicNumber` | `varchar2` | NIC Number | ☐ | Last 5 digits of SIRET number which is an intern sequential number of 4 digits representing the identification of the localization of the office. | | `Notes` | `varchar2` | Notes | ☐ | Notes for an address. | | `Phone` | `varchar2`(25) | Phone | ☐ | Phone number. | | `PhoneExtension` | `varchar2`(15) | Phone Extension | ☐ | Phone number extension. | | `Postcode` | `varchar2`(20) | Postal Code | ☐ | Postcode. | | `Source` | `int16` | Source | ☐ | | | `State` | `varchar2`(30) | State | ☐ | State/Province code. | | `StateDescription` | `varchar2` | State Description | ☐ | Name of the State. | | `Type` | `int16` | Type | ☐ | The type of address. Visit=1, Postal=2, Invoice=3, Delivery=4. | | `Warehouse` | `guid` | Warehouse | ☐ | The warehouse linked to the address, if a warehouse is linked the account will be empty. Can only be filled for type=Delivery. | | `WarehouseCode` | `varchar2` | Warehouse Code | ☐ | Code of the warehoude. | | `WarehouseDescription` | `varchar2` | Warehouse Description | ☐ | Description of the warehouse. |