# SystemDivisions: Exact Online System Divisions - Catalog: `ExactOnlineREST` - Schema: `System` - Primary Keys: `Code` - Label: System Divisions Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `SystemDivisions` 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 | |---|:---:|---|:---:|---| | `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. | | `ArchiveDate` | `datetime` | Archive Date | ☐ | | | `BlockingStatus` | `int32` | Blocking Status | ☑ | Values: 0 = Not blocked 1 = Backup 2 = Conversion busy 3 = Conversion shadow 4 = Conversion waiting 5 = Copy data waiting 6 = Copy data buzy 100 = Wait for deletion 101 = Deleted 102 = Deletion failed. | | `BusinessTypeCode` | `varchar2`(10) | Business Type Code | ☐ | Business Type Code. | | `BusinessTypeDescription` | `varchar2`(150) | Business Type Description | ☐ | Business Type Description. | | `ChamberOfCommerceEstablishment` | `varchar2` | CoC Establishment | ☐ | Establishment date at chamber of commerce. | | `ChamberOfCommerceNumber` | `varchar2`(60) | Chamber of Commerce Number | ☐ | Chamber of commerce number. | | `City` | `varchar2`(30) | City | ☐ | City. | | `Code` | `int32` | Code | ☑ | Primary key. | | `CompanySizeCode` | `varchar2`(10) | Company Size Code | ☐ | Company Size Code. | | `CompanySizeDescription` | `varchar2`(60) | Company Size Description | ☐ | Company Size Description. | | `Country` | `varchar2`(30) | Country | ☐ | Country of the division. Is used for determination of legislation. | | `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. | | `Currency` | `varchar2`(30) | Currency | ☐ | Default currency. | | `Current` | `char` | Current | ☑ | True when this division is most recently used by the API. | | `Customer` | `guid` | Customer | ☐ | Owner account of the division. | | `CustomerCode` | `varchar2`(18) | Customer Code | ☐ | Owner account code of the division. | | `CustomerName` | `varchar2`(50) | Customer Name | ☐ | Owner account name of the division. | | `DatevAccountantNumber` | `varchar2`(30) | DATEV Accountant Number | ☐ | Accountant number DATEV (Germany). | | `DatevClientNumber` | `varchar2`(30) | DATEV Client Number | ☐ | Accountant number DATEV (Germany). | | `Description` | `varchar2`(60) | Description | ☐ | 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`(128) | Email | ☐ | Email address. | | `Fax` | `varchar2`(25) | Fax | ☐ | Fax number. | | `Hid` | `int64` | HID | ☑ | Company number that is assigned by the customer. | | `IsDossierDivision` | `char` | Is File Division | ☑ | True if the division is a dossier division. | | `IsHRDivision` | `char` | Is HR Division | ☑ | | | `IsLicensed` | `char` | Is Licensed | ☐ | Gets whether the division is licensed to be used by Invantive software. | | `IsMainDivision` | `char` | Is Main Division | ☑ | True if the division is the main division. | | `IsPracticeDivision` | `char` | Is Practice Division | ☑ | | | `Label` | `varchar2`(128) | Label | ☑ | Label of the division. | | `Legislation` | `varchar2` | Legislation | ☐ | Legislation. | | `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. | | `OBNumber` | `varchar2` | OB Number | ☐ | The soletrader VAT number used for offical returns to tax authority. | | `Phone` | `varchar2`(25) | Phone | ☐ | Phone number. | | `Postcode` | `varchar2`(20) | Postal Code | ☐ | Postcode. | | `SbiCode` | `varchar2` | SBI Code | ☐ | SBI Code. | | `SbiDescription` | `varchar2` | SBI Description | ☐ | SBI Description. | | `SectorCode` | `varchar2` | Sector Code | ☐ | Sector Code. | | `SectorDescription` | `varchar2` | Sector Description | ☐ | Sector Description. | | `ShareCapital` | `double` | Share Capital | ☐ | Part of the capital of a company that comes from the issue of shares (France). | | `SiretNumber` | `varchar2` | Siret Number | ☐ | Siret Number of the division (France). | | `StartDate` | `datetime` | Start Date | ☐ | Date on which the division becomes active. | | `State` | `varchar2`(30) | State | ☐ | State/Province code. | | `Status` | `int32` | Status | ☑ | Follow the Division Status 0 for Inactive, 1 for Active and 2 for Archived Divisions. | | `SubsectorCode` | `varchar2` | Subsector Code | ☐ | Subsector Code. | | `SubsectorDescription` | `varchar2` | Subsector Description | ☐ | Subsector Description. | | `TaxOfficeNumber` | `varchar2`(4) | Tax Office Number | ☐ | Number of your local tax authority (Germany). | | `TaxReferenceNumber` | `varchar2`(30) | Tax Reference Number | ☐ | Local tax reference number (Germany). | | `TemplateCode` | `varchar2` | Template Code | ☐ | Division template code. | | `VATNumber` | `varchar2`(35) | VAT Number | ☐ | The number under which the account is known at the Value Added Tax collection agency. | | `Website` | `varchar2`(128) | Website | ☐ | Website. |