invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

ItemGroups: Exact Online Item Groups

popular insert update delete per partition REST

  • Catalogus: ExactOnlineREST
  • Schema: Logistics
  • Primaire sleutels: ID
  • Label: Item Groups

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/{division}/logistics/ItemGroups
  • Metagegevens: /api/v1/{division}/logistics/$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 ItemGroups 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
Code varchar2 Code filters on the platform, writable Code of the item group.
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.
CreatorFullName varchar2(240) Aanmaker Volledige Naam filters on the platform, writable Name of creator.
Description varchar2 Description filters on the platform, writable Description of the item group.
Division int32 Division 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.
GLCosts guid Grootboek Kosten filters on the platform, writable GL account on which the costs of items of this group will be booked.
GLCostsCode varchar2 Grootboekrekening Kosten filters on the platform, writable Code of GLCosts.
GLCostsDescription varchar2 Grootboekrekening Omschrijving Kosten filters on the platform, writable Description of GLCosts.
GLCostsWorkInProgress guid itgen_eol_glcostsworkinprogress filters op het platform
GLCostsWorkInProgressCode varchar2 itgen_eol_glcostsworkinprogresscode filters op het platform
GLCostsWorkInProgressDescription varchar2 itgen_eol_glcostsworkinprogressdescription filters op het platform
GLPurchaseAccount guid itgen_eol_glpurchaseaccount filters on the platform, writable GL Purchase account for purchase invoicing according to (non-) perpetual inventory method.
GLPurchaseAccountCode varchar2 itgen_eol_glpurchaseaccountcode filters on the platform, writable Code of GLPurchase.
GLPurchaseAccountDescription varchar2 itgen_eol_glpurchaseaccountdescription filters on the platform, writable Description of GLPurchaseAccount.
GLPurchasePriceDifference guid itgen_eol_glpurchasepricedifference filters on the platform, writable GL account that will be used for the 'Standard cost price' valuation method to balance the difference between purchase price and cost price.
GLPurchasePriceDifferenceCode varchar2 itgen_eol_glpurchasepricedifferencecode filters on the platform, writable Code of GLPurchasePriceDifference.
GLPurchasePriceDifferenceDescr varchar2 itgen_eol_glpurchasepricedifferencedescr filters on the platform, writable Description of GLPurchasePriceDifference.
GLRevenue guid Grootboek Omzet filters on the platform, writable GL account on which the revenue for items of this group will be booked.
GLRevenueCode varchar2 Grootboekrekening Code Opbrengst. filters on the platform, writable Code of GLRevenue.
GLRevenueDescription varchar2 Grootboekrekening Omschrijving Opbrengst filters on the platform, writable Description of GLRevenue.
GLRevenueWorkInProgress guid itgen_eol_glrevenueworkinprogress filters op het platform
GLRevenueWorkInProgressCode varchar2 itgen_eol_glrevenueworkinprogresscode filters op het platform
GLRevenueWorkInProgressDescription varchar2 itgen_eol_glrevenueworkinprogressdescription filters op het platform
GLStock guid Grootboekrekening Voorraad filters on the platform, writable GL account on which stock entries will be booked for items of this group.
GLStockCode varchar2 Grootboekrekeningcode Voorraad filters on the platform, writable Code of GLStock.
GLStockDescription varchar2 Grootboekrekeningomschrijving Voorraad filters on the platform, writable Description of GLStock.
GLStockVariance guid itgen_eol_glstockvariance filters on the platform, writable GL stock variance account for perpetual inventory.
GLStockVarianceCode varchar2 itgen_eol_glstockvariancecode filters on the platform, writable Code of GLStockVariance.
GLStockVarianceDescription varchar2 itgen_eol_glstockvariancedescription filters on the platform, writable Description of GLStockVariance.
ID guid ID filters on the platform, writable Primary key.
IsDefault int16 Is Standaard filters on the platform, writable Indicates if this is the default item group that will be assigned when a new item is created.
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.
ModifierFullName varchar2(240) Gewijzigd Volledige Naam filters on the platform, writable Name of modifier.
Notes varchar2 Notes filters on the platform, writable Notes.

Toetsen

Key Column Verwijst naar Kind Description
ItemGroups_Creator_Users_fk Creator Users.UserID Key
ItemGroups_GLCosts_GLAccounts_fk GLCosts GLAccounts.ID Key
ItemGroups_GLPurchaseAccount_GLAccounts_fk GLPurchaseAccount GLAccounts.ID Key
ItemGroups_GLPurchasePriceDifference_GLAccounts_fk GLPurchasePriceDifference GLAccounts.ID Key
ItemGroups_GLRevenue_GLAccounts_fk GLRevenue GLAccounts.ID Key
ItemGroups_GLStockVariance_GLAccounts_fk GLStockVariance GLAccounts.ID Key
ItemGroups_GLStock_GLAccounts_fk GLStock GLAccounts.ID Key
ItemGroups_Modifier_Users_fk Modifier Users.UserID Key

Geciteerd door

Release Notes

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