SystemDivisions: Exact Online Systeemadministraties |
Catalogus: ExactOnlineREST
Schema: System
Primaire Sleutels: Code
Label: Systeemadministraties
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Tabelkolommen
De kolommen van de tabel SystemDivisions worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
AddressLine1 |
string(80) |
Adresregel 1 |
☐ |
First address line. |
AddressLine2 |
string(80) |
Adresregel 2 |
☐ |
Second address line. |
AddressLine3 |
string(80) |
Adresregel 3 |
☐ |
Third address line. |
ArchiveDate |
datetime |
Archiveringsdatum |
☐ |
|
BlockingStatus |
int32 |
Blokkerende 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 |
string(10) |
Bedrijfssoortcode |
☐ |
Business Type Code. |
BusinessTypeDescription |
string(150) |
Bedrijfssoortomschrijving |
☐ |
Business Type Description. |
ChamberOfCommerceEstablishment |
string |
KvK Opgericht |
☐ |
Establishment date at chamber of commerce. |
ChamberOfCommerceNumber |
string(60) |
KvK-nummer |
☐ |
Chamber of commerce number. |
City |
string(30) |
Plaats |
☐ |
City. |
Code |
int32 |
Code |
☑ |
Primary key. |
CompanySizeCode |
string(10) |
Bedrijfsgroottecode |
☐ |
Company Size Code. |
CompanySizeDescription |
string(60) |
Bedrijfsgroottebeschrijving |
☐ |
Company Size Description. |
Country |
string(30) |
Land |
☐ |
Country of the division. Is used for determination of legislation. |
Created |
datetime |
Gemaakt |
☑ |
Creation date. |
CreatedUtc |
datetime |
Aangemaakt (UTC) |
☐ |
Creation date in UTC. |
Creator |
guid |
Aanmaker |
☐ |
User ID of creator. |
CreatorFullName |
string(240) |
Aanmaker Volledige Naam |
☐ |
Name of creator. |
Currency |
string(30) |
Valuta |
☐ |
Default currency. |
Current |
boolean |
Huidige |
☑ |
True when this division is most recently used by the API. |
Customer |
guid |
Klant |
☐ |
Owner account of the division. |
CustomerCode |
string(18) |
Klantcode |
☐ |
Owner account code of the division. |
CustomerName |
string(50) |
Naam Klant |
☐ |
Owner account name of the division. |
DatevAccountantNumber |
string(30) |
DATEV Accountantnummer |
☐ |
Accountant number DATEV (Germany). |
DatevClientNumber |
string(30) |
DATEV-cliëntnummer |
☐ |
Accountant number DATEV (Germany). |
Description |
string(60) |
Omschrijving |
☐ |
Description. |
DivisionHRLinkUnlinkDate |
datetime |
Divisie HR Datum Koppeling/Ontkoppeling |
☐ |
|
DivisionMoveDate |
datetime |
Divisiedatabase Laatst Gewijzigd |
☐ |
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. |
string(128) |
☐ |
Email address. |
||
Fax |
string(25) |
Fax |
☐ |
Fax number. |
Hid |
int64 |
HID |
☑ |
Company number that is assigned by the customer. |
IsDossierDivision |
boolean |
Is Dossier Divisie |
☑ |
True if the division is a dossier division. |
IsHRDivision |
boolean |
Is HR-Organisatie |
☑ |
|
IsLicensed |
boolean |
Is Gelicentieerd |
☐ |
Gets whether the division is licensed to be used by Invantive software. |
IsMainDivision |
boolean |
Is Hoofddivisie |
☑ |
True if the division is the main division. |
IsPracticeDivision |
boolean |
Is Accountancypraktijk Divisie |
☑ |
|
Label |
string(128) |
Label |
☑ |
Label of the division. |
Legislation |
string |
Wetgeving |
☐ |
Legislation. |
Modified |
datetime |
Gewijzigd |
☑ |
Last modified date. |
ModifiedUtc |
datetime |
Gewijzigd (UTC) |
☐ |
Last modified date in UTC. |
Modifier |
guid |
Wijziger |
☐ |
User ID of modifier. |
ModifierFullName |
string(240) |
Gewijzigd Volledige Naam |
☐ |
Name of modifier. |
OBNumber |
string |
OB Nummer |
☐ |
The soletrader VAT number used for offical returns to tax authority. |
Phone |
string(25) |
Telefoon |
☐ |
Phone number. |
Postcode |
string(20) |
Postcode |
☐ |
Postcode. |
SbiCode |
string |
SBI Code |
☐ |
SBI Code. |
SbiDescription |
string |
SBI Omschrijving |
☐ |
SBI Description. |
SectorCode |
string |
Sectorcode |
☐ |
Sector Code. |
SectorDescription |
string |
Sectoromschrijving |
☐ |
Sector Description. |
ShareCapital |
double |
Aandelenkapitaal |
☐ |
Part of the capital of a company that comes from the issue of shares (France). |
SiretNumber |
string |
Siret-Nummer |
☐ |
Siret Number of the division (France). |
StartDate |
datetime |
Startdatum |
☐ |
Date on which the division becomes active. |
State |
string(30) |
Provincie |
☐ |
State/Province code. |
Status |
int32 |
Status |
☑ |
Follow the Division Status 0 for Inactive, 1 for Active and 2 for Archived Divisions. |
SubsectorCode |
string |
Subsectorcode |
☐ |
Subsector Code. |
SubsectorDescription |
string |
Subsectoromschrijving |
☐ |
Subsector Description. |
TaxOfficeNumber |
string(4) |
Belastingdienst Nummer |
☐ |
Number of your local tax authority (Germany). |
TaxReferenceNumber |
string(30) |
Belasting Referentienummer |
☐ |
Local tax reference number (Germany). |
TemplateCode |
string |
Sjabloon Code |
☐ |
Division template code. |
VATNumber |
string(35) |
BTW-nummer |
☐ |
The number under which the account is known at the Value Added Tax collection agency. |
Website |
string(128) |
Website |
☐ |
Website. |
24-06-2025 18:54 Versie 24.1.116-BETA+5455