GetMostRecentlyUsedDivisions: Exact Online Meest Recent Gebruikte Divisies |
Catalogus: ExactOnlineREST
Schema: System
Primaire Sleutels: Code
Label: Meest Recent Gebruikte Divisies
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Tabelkolommen
De kolommen van de tabel GetMostRecentlyUsedDivisions 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 |
☐ |
Address line 2. |
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 |
Omschrijving |
☐ |
Description. |
DivisionHRLinkUnlinkDate |
datetime |
Divisie HR Datum Koppeling/Ontkoppeling |
☐ |
|
DivisionMoveDate |
datetime |
Divisiedatabase Laatst Gewijzigd |
☐ |
Date when the division was moved. 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 |
☑ |
|
IsMainDivision |
boolean |
Is Hoofddivisie |
☑ |
True if the division is the main division. |
IsPracticeDivision |
boolean |
Is Accountancypraktijk Divisie |
☑ |
|
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