# GetCurrentDivision: Exact Online Get Current Division - Catalog: `ExactOnlineREST` - Schema: `System` - Primary Keys: `Code` - Label: Get Current Division Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `GetCurrentDivision` 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 | ☑ | | | `CompanySizeCode` | `varchar2`(10) | Company Size Code | ☐ | Company Size Code. | | `CompanySizeDescription` | `varchar2`(60) | Company Size Description | ☐ | Company Size Description. | | `Country` | `varchar2`(30) | Country | ☐ | Country code. | | `Creator` | `guid` | Creator | ☐ | User ID of creator. | | `CreatorFullName` | `varchar2`(240) | Creator Full Name | ☐ | Name of creator. | | `Currency` | `varchar2`(30) | Currency | ☐ | Code of Currency. | | `Current` | `char` | Current | ☑ | | | `Customer` | `guid` | Customer | ☐ | Reference to customer (account). | | `CustomerCode` | `varchar2`(18) | Customer Code | ☐ | Owner account code of the division. | | `CustomerName` | `varchar2`(50) | Customer Name | ☐ | | | `DatevAccountantNumber` | `varchar2`(30) | DATEV Accountant Number | ☐ | Accountant number DATEV (Germany). | | `DatevClientNumber` | `varchar2`(30) | DATEV Client Number | ☐ | Accountant number DATEV (Germany). | | `Description` | `varchar2` | Description | ☐ | | | `DivisionHRLinkUnlinkDate` | `datetime` | Division HR Link/Unlink Date | ☐ | | | `DivisionMoveDate` | `datetime` | Division Database Last Changed | ☐ | | | `Email` | `varchar2`(128) | Email | ☐ | Email address. | | `Fax` | `varchar2`(25) | Fax | ☐ | Fax number. | | `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 | ☐ | Legislation. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `ModifierFullName` | `varchar2`(240) | Modified Full Name | ☐ | Name of modifier. | | `OBNumber` | `varchar2` | OB Number | ☐ | | | `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 | ☑ | | | `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 | ☐ | | | `VATNumber` | `varchar2`(35) | VAT Number | ☐ | VAT number. | | `Website` | `varchar2`(128) | Website | ☐ | Website. |