# AllDivisions: Exact Online All Divisions - Catalog: `ExactOnlineREST` - Schema: `System` - Primary Keys: `Code` - Label: All Divisions This is a read-only table function. The Exact Online API may not support changing the data or the Invantive UniversalSQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API. ## Columns of Table Function The columns of the table function `AllDivisions` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AddressLine1` | `varchar2`(80) | Address Line 1 | ☐ | | | `AddressLine2` | `varchar2`(80) | Address Line 2 | ☐ | | | `AddressLine3` | `varchar2`(80) | Address Line 3 | ☐ | | | `ArchiveDate` | `datetime` | Archive Date | ☐ | | | `BlockingStatus` | `int32` | Blocking Status | ☑ | | | `BusinessTypeCode` | `varchar2` | Business Type Code | ☐ | | | `BusinessTypeDescription` | `varchar2` | Business Type Description | ☐ | | | `ChamberOfCommerceEstablishment` | `varchar2` | CoC Establishment | ☐ | | | `ChamberOfCommerceNumber` | `varchar2`(60) | Chamber of Commerce Number | ☐ | | | `City` | `varchar2` | City | ☐ | | | `Code` | `int32` | Code | ☑ | | | `CompanySizeCode` | `varchar2` | Company Size Code | ☐ | | | `CompanySizeDescription` | `varchar2` | Company Size Description | ☐ | | | `Country` | `varchar2` | Country | ☐ | | | `Created` | `datetime` | Created | ☑ | | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | | | `CreatorFullName` | `varchar2` | Creator Full Name | ☐ | | | `Currency` | `varchar2` | Currency | ☐ | | | `Current` | `char` | Current | ☑ | | | `Customer` | `guid` | Customer | ☐ | | | `CustomerCode` | `varchar2` | Customer Code | ☐ | | | `CustomerName` | `varchar2` | Customer Name | ☐ | | | `DatevAccountantNumber` | `varchar2` | DATEV Accountant Number | ☐ | | | `DatevClientNumber` | `varchar2` | DATEV Client Number | ☐ | | | `Description` | `varchar2` | Description | ☐ | | | `DivisionHRLinkUnlinkDate` | `datetime` | Division HR Link/Unlink Date | ☐ | | | `DivisionMoveDate` | `datetime` | Division Database Last Changed | ☐ | Date at which the division was moved last from one Exact Online database into another. Please resync all data when this value changes because value of Timestamp is regenerated. | | `Email` | `varchar2` | Email | ☐ | | | `Fax` | `varchar2` | Fax | ☐ | | | `Hid` | `int64` | HID | ☑ | | | `IsDossierDivision` | `char` | Is File Division | ☑ | | | `IsHRDivision` | `char` | Is HR Division | ☑ | | | `IsMainDivision` | `char` | Is Main Division | ☑ | | | `IsPracticeDivision` | `char` | Is Practice Division | ☑ | | | `Legislation` | `varchar2` | Legislation | ☐ | | | `Modified` | `datetime` | Modified | ☑ | | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | | | `ModifierFullName` | `varchar2` | Modified Full Name | ☐ | | | `OBNumber` | `varchar2` | OB Number | ☐ | | | `Phone` | `varchar2` | Phone | ☐ | | | `Postcode` | `varchar2` | Postal Code | ☐ | | | `SbiCode` | `varchar2` | SBI Code | ☐ | | | `SbiDescription` | `varchar2` | SBI Description | ☐ | | | `SectorCode` | `varchar2` | Sector Code | ☐ | | | `SectorDescription` | `varchar2` | Sector Description | ☐ | | | `ShareCapital` | `double` | Share Capital | ☐ | | | `SiretNumber` | `varchar2` | Siret Number | ☐ | | | `StartDate` | `datetime` | Start Date | ☐ | | | `State` | `varchar2` | State | ☐ | | | `Status` | `int32` | Status | ☑ | | | `SubsectorCode` | `varchar2` | Subsector Code | ☐ | | | `SubsectorDescription` | `varchar2` | Subsector Description | ☐ | | | `TaxOfficeNumber` | `varchar2` | Tax Office Number | ☐ | | | `TaxReferenceNumber` | `varchar2` | Tax Reference Number | ☐ | | | `TemplateCode` | `varchar2` | Template Code | ☐ | | | `VATNumber` | `varchar2` | VAT Number | ☐ | | | `Website` | `varchar2` | Website | ☐ | |