invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

AllocationRule: Exact Online Allocation Rule

insert update delete per partition REST

  • Catalogus: ExactOnlineREST
  • Schema: Cashflow
  • Primaire sleutels: ID
  • Label: Allocation Rule

De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.

Je kunt gegevens ophalen en wijzigen met insert, update en delete.

API-bron

  • Eindpunt: /api/v1/beta/{division}/cashflow/AllocationRule
  • Metagegevens: /api/v1/beta/{division}/cashflow/$metadata

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 5
Aantal rijen per minuut bij volledige scan 7,200
Aantal rijen per minuut in een Query 300
Aantal rijen per minuut schrijven 300

Het resultaat kan op de client in de Cache worden opgeslagen.

Tabelkolommen

De kolommen van de tabel AllocationRule 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.

Name Datatype Label Required Marks Documentation
Account guid Account filters on the platform, writable The account ID to which the imported bank transaction must be allocated.
AccountBankAccount varchar2(50) Rekening Bankrekening filters on the platform, writable The bank account number that should be in the imported bank transaction in order to perform the automatic allocation on bank account.Either bank account or word must be filled.
Costcenter varchar2(8) Kostenplaats filters on the platform, writable The cost centre that will be allocated to the imported bank transaction.
Costunit varchar2(8) Kostendrager filters on the platform, writable The cost unit that will be allocated to the imported bank transaction.
Created datetime Created filters on the platform, writable Creation date.
CreatedUtc datetime Aangemaakt (UTC) writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
Division int32 Division writable Division Code.
DivisionCompanyCoCNumber varchar2(60) Divisie Kamer van Koophandel Nummer writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Divisie IBAN Nummer writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Divisie Bedrijfsnaam writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Divisie RSIN Nummer writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Divisie BTW Nummer writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Divisie Loonbelastingnummer writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Divisie Label writable Label of the Exact Online division.
DivisionName varchar2(50) Administratie Naam writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Naam Abonnementhouder writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Abonnementhoudernummer writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Divisie Korte Naam writable Short name of the Exact Online division.
GLAccount guid Grootboekrekening filters on the platform, writable The G/L account to which the imported bank transaction must be allocated.
ID guid ID filters on the platform, writable Primary key.
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Gewijzigd (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
VATCode varchar2(3) BTW-code filters on the platform, writable The VAT code that will be allocated to the imported bank transaction.
Words varchar2 Words filters on the platform, writable Words for the automatic allocation.Either bank account or word must be filled.

Toetsen

Key Column Verwijst naar Kind Description
AllocationRule_Account_Accounts_fk Account Accounts.ID Key
AllocationRule_Costcenter_Costcenters_fk Costcenter Costcenters.Code Key
AllocationRule_Costunit_Costunits_fk Costunit Costunits.Code Key
AllocationRule_Creator_Users_fk Creator Users.UserID Key
AllocationRule_GLAccount_GLAccounts_fk GLAccount GLAccounts.ID Key
AllocationRule_Modifier_Users_fk Modifier Users.UserID Key
AllocationRule_VATCode_VATCodes_fk VATCode VATCodes.Code Key

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: