Journals: Exact Online Dagboeken |
Catalogus: ExactOnlineREST
Schema: Financial
Primaire Sleutels: ID
Label: Dagboeken
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Tabelkolommen
De kolommen van de tabel Journals 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 |
---|---|---|---|---|
AllowVariableCurrency |
boolean |
Variabele Valuta Toestaan |
☐ |
Indicates if the journal allows variable currency. |
AllowVariableExchangeRate |
boolean |
Sta Variabele Wisselkoers toe |
☐ |
Indicates if the journal allows the exchange rate of the currency of the amounts in the journal entry to be changed. |
AllowVAT |
boolean |
Sta BTW toe |
☐ |
Indicates if the journal allows the use of VAT in the financial entry. Especially true for general journals. |
AutoSave |
boolean |
Automatisch Opslaan |
☐ |
Indicates if the journal automatically saves the entries when the amount is in balance with the entry lines. |
Bank |
guid |
Bank |
☐ |
Reference to bank account. |
BankAccountBICCode |
string(11) |
Bankrekening BIC code |
☐ |
BIC code of the bank where the bank account is held. |
BankAccountCountry |
string(30) |
Bankrekening Land |
☐ |
Country of bank account. |
BankAccountDescription |
string(60) |
Bankrekening Omschrijving |
☐ |
Description of bank account. |
BankAccountIBAN |
string(50) |
Bankrekening IBAN |
☐ |
IBAN of the bank account. |
BankAccountID |
guid |
Bankrekening ID |
☐ |
Reference to the Bank Account linked to the Journal. |
BankAccountIncludingMask |
string(50) |
Bankrekening inclusief Masker |
☐ |
Bank account number. Is mandatory for Journals that have Type = Bank. |
BankAccountUseSEPA |
boolean |
Bankrekening Gebruik SEPA |
☐ |
Obsolete. Whether or not use SEPA for the bank account. |
BankAccountUseSepaDirectDebit |
boolean |
Bankrekening Gebruik SEPA Direct Debit |
☐ |
Obsolete. Whether or not use SEPA direct debit for the bank account. |
BankName |
string |
Naam van de Bank |
☐ |
Name of bank account. |
Code |
string(20) |
Code |
☑ |
Primary key. |
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 of the Journal. If AllowVariableCurrency is false this is the only currency that can be used. |
CurrencyDescription |
string(60) |
Valuta Omschrijving |
☐ |
Description of Currency. |
CustomField |
string |
{res:itgen_eol_customfield} |
☐ |
|
Description |
string(60) |
Omschrijving |
☐ |
Name of the Journal. |
Division |
int32 |
Divisie |
☐ |
Division code. |
DivisionCompanyCoCNumber |
string(60) |
Divisie Kamer van Koophandel Nummer |
☐ |
Chamber of commerce number of the Exact Online division. |
DivisionCompanyIBANNumber |
string(50) |
Divisie IBAN Nummer |
☐ |
IBAN number of the Exact Online division. |
DivisionCompanyName |
string(50) |
Divisie Bedrijfsnaam |
☑ |
Company name of the Exact Online division. |
DivisionCompanyRSINNumber |
string(9) |
Divisie RSIN Nummer |
☐ |
RSIN number of the Exact Online division. |
DivisionCompanyVATNumber |
string(35) |
Divisie BTW Nummer |
☐ |
VAT number of the Exact Online division. |
DivisionCompanyWageTaxNumber |
string(60) |
Divisie Loonbelastingnummer |
☐ |
Wage tax number of the Exact Online division. |
DivisionLabel |
string(128) |
Divisie Label |
☑ |
Label of the Exact Online division. |
DivisionName |
string(50) |
Administratie Naam |
☑ |
Name of the Exact Online division. |
DivisionOwnerCompanyName |
string(50) |
Naam Abonnementhouder |
☑ |
Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionOwnerCompanyNumber |
string(18) |
Abonnementhoudernummer |
☑ |
Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionShortName |
int64 |
Divisie Korte Naam |
☑ |
Short name of the Exact Online division. |
GLAccount |
guid |
Grootboekrekening |
☐ |
Suspense general ledger account. |
GLAccountCode |
string(30) |
Grootboekrekening Code |
☐ |
Code of the G/L account. |
GLAccountDescription |
string(60) |
Grootboekrekening Omschrijving |
☐ |
Description of the G/L account. |
GLAccountType |
int32 |
Grootboekrekeningsoort |
☐ |
Type of G/L account. |
ID |
guid |
ID |
☑ |
Primary Key. |
IsBlocked |
boolean |
Is Geblokkeerd |
☐ |
Indicates whether the journal is blocked or not. |
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. |
PaymentInTransitAccount |
guid |
Betaling in Transit Rekening |
☐ |
General ledger account for payment in transit. |
PaymentServiceAccountIdentifier |
string |
Betalingsdienst Relatiekenmerk |
☐ |
Identifier detail of the Payment service account. Ex. EmailID for Paypal type of Payment service account. |
PaymentServiceProvider |
int32 |
Betalingsdienstaanbieder |
☐ |
Type of Payment service provider. The following values are supported: 1 (Adyen), 2 (Paypal), 3 (Stripe). Is mandatory for Journals of Type 16 (Payment service). |
PaymentServiceProviderName |
string |
Naam Betalingsdienstaanbieder |
☐ |
Name of the Payment service provider. |
Type |
int32 |
Soort |
☐ |
Type of Journal. The following values are supported: 10 (Cash) 12 (Bank) 16 (Payment service) 20 (Sales) 21 (Return invoice) 22 (Purchase) 23 (Received return invoice) 90 (General journal). |
24-06-2025 18:54 Versie 24.1.116-BETA+5455