invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

CustomerCooperations: Exact Online Customer Cooperations

insert update delete REST

  • Catalogus: ExactOnlineREST
  • Schema: Workflow
  • Primaire sleutels: ID
  • Label: Customer Cooperations

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

API-bron

  • Eindpunt: /api/v1/beta/{division}/workflow/CustomerCooperations
  • Metagegevens: /api/v1/beta/{division}/workflow/$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 CustomerCooperations 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 Exact Online customer ID of the accountant.
AccountCode varchar2(18) Account Code writable
AccountName varchar2(50) Accountnaam writable Name of account.
Amount double Amount writable
AmountActual double Werkelijk Bedrag writable
AmountFC double Bedrag Vreemde Valuta writable
AmountFCActual double Werkelijk Bedrag Vreemde Valuta writable
Approved datetime Approved writable
Approver guid Approver writable
ApproverFullName varchar2(240) Goedkeurder Volledige naam writable
Buildup char Build-up writable
Campaign guid Campaign writable
Contact guid Contact writable
ContactFullName varchar2(240) Contactpersoon Volledige Naam writable
ContextID guid Context ID filters on the platform, writable
ContextType int32 Contextsoort filters on the platform, writable
Created datetime Created writable Creation date.
CreatedUtc datetime Aangemaakt (UTC) writable Creation date in UTC.
Creator guid Creator writable User ID of creator.
CreatorFullName varchar2(240) Aanmaker Volledige Naam writable Name of creator.
Currency varchar2(30) Currency writable Code of Currency.
CurrencyActual varchar2(30) itgen_eol_currencyactual writable Code of actual currency.
Days double itgen_eol_days writable
DaysActual double itgen_eol_daysactual writable
Description varchar2 Description filters on the platform, writable
Division int32 Division writable
DivisionHID int64 itgen_eol_divisionhid filters on the platform, writable
DivisionName varchar2 Administratie Naam writable Name of the division.Name is derived from the description and may be inaccurate.
Document guid Document writable
Employee guid Employee writable
EndDate datetime Einddatum writable
EndDateActual datetime Daadwerkelijke Einddatum writable
ErrorLogID int32 Foutlogboek-ID writable
FinancialEntry guid Financiële Boeking writable
FreeBoolField_01 char Vrij Booleaans Veld #1 writable
FreeBoolField_02 char Vrij Booleaans Veld #2 writable
FreeBoolField_03 char Vrij Booleaans Veld #3 writable
FreeBoolField_04 char Vrij Booleaans Veld #4 writable
FreeBoolField_05 char Vrij Booleaans Veld #5 writable
FreeDateField_01 datetime Vrij Datumveld #1 writable
FreeDateField_02 datetime Vrij Datumveld #2 writable
FreeDateField_03 datetime Vrij Datumveld #3 writable
FreeDateField_04 datetime Vrij Datumveld #4 writable
FreeDateField_05 datetime Vrij Datumveld #5 writable
FreeGuidField_01 guid Vrij GUID-veld 1 writable
FreeGuidField_02 guid Vrij GUID-veld 2 writable
FreeGuidField_03 guid Vrij GUID-veld 3 writable
FreeGuidField_04 guid Vrij GUID-veld 4 writable
FreeGuidField_05 guid Vrij GUID-veld 5 writable
FreeGuidField_06 guid Vrij GUID-veld 6 writable
FreeGuidField_07 guid Vrij GUID-veld 7 writable
FreeGuidField_08 guid Vrij GUID-veld 8 writable
FreeGuidField_09 guid Vrij GUID-veld 9 writable
FreeGuidField_10 guid Vrij GUID-veld 10 writable
FreeIntField_01 int32 Vrij Integer-veld 1 writable
FreeIntField_02 int32 Vrij Integer-veld 2 writable
FreeIntField_03 int32 Vrij Integer-veld 3 writable
FreeIntField_04 int32 Vrij Integer-veld 4 writable
FreeIntField_05 int32 Vrij Integer-veld 5 writable
FreeNumberField_01 double Vrij Numeriek Veld #1 writable
FreeNumberField_02 double Vrij Numeriek Veld #2 writable
FreeNumberField_03 double Vrij Numeriek Veld #3 writable
FreeNumberField_04 double Vrij Numeriek Veld #4 writable
FreeNumberField_05 double Vrij Numeriek Veld #5 writable
FreeTextField_01 varchar2 Vrij Tekstveld #1 writable
FreeTextField_02 varchar2 Vrij Tekstveld #2 writable
FreeTextField_03 varchar2 Vrij Tekstveld #3 writable
FreeTextField_04 varchar2 Vrij Tekstveld #4 writable
FreeTextField_05 varchar2 Vrij Tekstveld #5 writable
FreeTextField_06 varchar2 Vrij Tekstveld #6 writable
FreeTextField_07 varchar2 Vrij Tekstveld #7 writable
FreeTextField_08 varchar2 Vrij Tekstveld #8 writable
FreeTextField_09 varchar2 Vrij Tekstveld #9 writable
FreeTextField_10 varchar2 Vrij Tekstveld #10 writable
FreeTextField_11 varchar2 Vrij Tekstveld 11 writable
FreeTextField_12 varchar2 Vrij Tekstveld 12 writable
FreeTextField_13 varchar2 itgen_eol_freetextfield_13 writable
FreeTextField_14 varchar2 Vrij Tekstveld 14 writable
FreeTextField_15 varchar2 Vrij Tekstveld 15 writable
HID int32 HID writable
HelpFile guid Helpbestand writable
HelpItem guid Helpartikel writable
Hours double Hours writable
HoursActual double Werkelijke Uren writable
ID guid ID filters on the platform, writable
InWorkflow char In Werkstroom writable
IsRead char Is Gelezen writable
ItemCode_1 varchar2(30) Artikelcode 1 writable
ItemDescription_1 varchar2(255) Artikelomschrijving 1 writable Description of Item.
ItemNumberID_1 guid Artikelnummer-ID 1 writable
ItemNumberID_2 guid Artikelnummer-ID 2 writable
Item_1 guid Artikel 1 writable
Item_2 guid Artikel 2 writable
Lead guid Lead writable
Location varchar2 Location writable
Modified datetime Modified writable Last modified date.
ModifiedUtc datetime Gewijzigd (UTC) writable Last modified date in UTC.
Modifier guid Modifier writable User ID of modifier.
MultipleEntryCols varchar2 Meerdere Invoerkolommen writable
MultipleEntryID guid Meerdere Invoer-ID writable
Opportunity guid Opportunity writable
OpportunityDescription varchar2 itgen_eol_opportunitydescription writable
PayrollComponent guid Salaris Component writable
PayrollPeriod int32 Salarisboeking writable
PayrollYear int32 Loonjaar writable
Priority int32 Priority writable
Processed datetime Processed writable
Processor guid Processor writable
Project guid Project writable
ProjectDescription varchar2(60) Projectomschrijving writable
QuantityActual_1 double Werkelijke Hoeveelheid 1 writable
QuantityActual_2 double Werkelijke Hoeveelheid 2 writable
Quantity_1 double Hoeveelheid 1 writable
Quantity_2 double Hoeveelheid 2 writable
Realized datetime Realized writable
Realizer guid Realizer writable
Reminder int16 Reminder writable
RequestComments varchar2 Verzoek om Opmerkingen filters on the platform, writable
ResubmitStatus int16 Status Opnieuw Indienen writable
SecurityLevel int32 Beveiligingsniveau writable
StartDate datetime Startdatum filters on the platform, writable
StartDateActual datetime Daadwerkelijke Startdatum writable
Status int16 Status filters on the platform, writable
StatusChanged datetime Status Gewijzigd writable
SubStatus int32 Substatus writable
SubscriptionOwnerName varchar2 Abonnementshouder Naam writable Name of the subscription owner.Name is derived from the description and may be inaccurate.
TaskSubType int32 Taaksubtype writable
Type guid Type filters on the platform, writable
TypeDescription varchar2(240) Soort Omschrijving writable
TypeHID int32 Soort Mens-ID filters on the platform, writable
UserFullName varchar2(240) Gebruiker Volledige Naam writable
UserHID int32 Gebruiker Menselijke ID writable
UserID guid Gebruikers-ID writable
WorkflowComments varchar2 Workflow-opmerkingen writable
XBRLDocument guid XBRL-document writable
YourRef varchar2(60) Uw Referentie filters on the platform, writable Your reference.

Toetsen

Key Column Verwijst naar Kind Description
CustomerCooperations_Account_Accounts_fk Account Accounts.ID Key
CustomerCooperations_Creator_Users_fk Creator Users.UserID Key
CustomerCooperations_Currency_Currencies_fk Currency Currencies.Code Key
CustomerCooperations_Modifier_Users_fk Modifier Users.UserID Key

Release Notes

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