invantive documentation
Invantive SupportforenAnmelden / Eintragen

CustomerCooperations: Exact Online Customer Cooperations

insert update delete REST

  • Katalog: ExactOnlineREST
  • Schema: Workflow
  • Primärschlüssel: ID
  • Label: Customer Cooperations

Mit insert, update und delete können Daten abgerufen und geändert werden.

API-Quelle

  • Endpunkt: /api/v1/beta/{division}/workflow/CustomerCooperations
  • Metadaten: /api/v1/beta/{division}/workflow/$metadata

Leistungsmerkmale

Characteristic Value
Durchschnittliche Zugriffsverzögerung (ms) 5
Anzahl der Vollscan-Zeilen pro Minute 7,200
Anzahl der Query-Zeilen pro Minute 300
Zeilen pro Minute schreiben 300

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

Tabellenspalten

Die Spalten der Tabelle CustomerCooperations sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
Account guid Account filters on the platform, writable Exact Online customer ID of the accountant.
AccountCode varchar2(18) Konto Code writable
AccountName varchar2(50) Konto Name writable Name of account.
Amount double Amount writable
AmountActual double Betrag Ist writable
AmountFC double Summe Fremdwährung writable
AmountFCActual double Betrag Währung Ist writable
Approved datetime Approved writable
Approver guid Approver writable
ApproverFullName varchar2(240) Vollständigen Namen bestätigen writable
Buildup char Build-up writable
Campaign guid Campaign writable
Contact guid Contact writable
ContactFullName varchar2(240) Ansprechpartner – Vollständiger Name writable
ContextID guid Kontext-ID filters on the platform, writable
ContextType int32 Kontextart filters on the platform, writable
Created datetime Created writable Creation date.
CreatedUtc datetime Angelegt writable Creation date in UTC.
Creator guid Creator writable User ID of creator.
CreatorFullName varchar2(240) Ersteller vollständiger Name 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 Verwaltung Name 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 Enddatum writable
EndDateActual datetime Tatsächliches Enddatum writable
ErrorLogID int32 Fehlerprotokoll-ID writable
FinancialEntry guid Finanzeintrag writable
FreeBoolField_01 char Freies Boolesches Feld Nr. 1 writable
FreeBoolField_02 char Freies Boolesches Feld Nr. 2 writable
FreeBoolField_03 char Freies Boolesches Feld Nr. 3 writable
FreeBoolField_04 char Freies Boolesches Feld Nr. 4 writable
FreeBoolField_05 char Freies Boolesches Feld Nr. 5 writable
FreeDateField_01 datetime Freies Datumsfeld Nr. 1 writable
FreeDateField_02 datetime Freies Datumsfeld Nr. 2 writable
FreeDateField_03 datetime Freies Datumsfeld Nr. 3 writable
FreeDateField_04 datetime Freies Datumsfeld Nr. 4 writable
FreeDateField_05 datetime Freies Datumsfeld Nr. 5 writable
FreeGuidField_01 guid Freies GUID-Feld 1 writable
FreeGuidField_02 guid Freies GUID-Feld 2 writable
FreeGuidField_03 guid Freies GUID-Feld 3 writable
FreeGuidField_04 guid Freies GUID-Feld 4 writable
FreeGuidField_05 guid Freies GUID-Feld 5 writable
FreeGuidField_06 guid Freies GUID-Feld 6 writable
FreeGuidField_07 guid Freies GUID-Feld 7 writable
FreeGuidField_08 guid Freies GUID-Feld 8 writable
FreeGuidField_09 guid Freies GUID-Feld 9 writable
FreeGuidField_10 guid Freies GUID-Feld 10 writable
FreeIntField_01 int32 Freies Ganzzahlfeld 1 writable
FreeIntField_02 int32 Freies Ganzzahlfeld 2 writable
FreeIntField_03 int32 Freies Ganzzahlfeld 3 writable
FreeIntField_04 int32 Freies Ganzzahlfeld 4 writable
FreeIntField_05 int32 Freies Ganzzahlfeld 5 writable
FreeNumberField_01 double Freies Zahlenfeld Nr. 1 writable
FreeNumberField_02 double Freies Zahlenfeld Nr. 2 writable
FreeNumberField_03 double Freies Zahlenfeld Nr. 3 writable
FreeNumberField_04 double Freies Zahlenfeld Nr. 4 writable
FreeNumberField_05 double Freies Zahlenfeld Nr. 5 writable
FreeTextField_01 varchar2 Freitextfeld Nr. 1 writable
FreeTextField_02 varchar2 Freitextfeld Nr. 2 writable
FreeTextField_03 varchar2 Freitextfeld Nr. 3 writable
FreeTextField_04 varchar2 Freitextfeld Nr. 4 writable
FreeTextField_05 varchar2 Freitextfeld Nr. 5 writable
FreeTextField_06 varchar2 Freitextfeld Nr. 6 writable
FreeTextField_07 varchar2 Freitextfeld Nr. 7 writable
FreeTextField_08 varchar2 Freitextfeld Nr. 8 writable
FreeTextField_09 varchar2 Freitextfeld Nr. 9 writable
FreeTextField_10 varchar2 Freitextfeld Nr. 10 writable
FreeTextField_11 varchar2 Freitextfeld 11 writable
FreeTextField_12 varchar2 Freitextfeld 12 writable
FreeTextField_13 varchar2 itgen_eol_freetextfield_13 writable
FreeTextField_14 varchar2 Freitextfeld 14 writable
FreeTextField_15 varchar2 Freitextfeld 15 writable
HID int32 HID writable
HelpFile guid Hilfedatei writable
HelpItem guid Hilfe-Eintrag writable
Hours double Hours writable
HoursActual double Tatsächliche Arbeitsstunden writable
ID guid ID filters on the platform, writable
InWorkflow char Im Workflow writable
IsRead char Ist gelesen writable
ItemCode_1 varchar2(30) Artikelcode 1 writable
ItemDescription_1 varchar2(255) Artikelbeschreibung 1 writable Description of Item.
ItemNumberID_1 guid Artikelnummer ID 1 writable
ItemNumberID_2 guid Artikelnummer ID 2 writable
Item_1 guid Punkt 1 writable
Item_2 guid Punkt 2 writable
Lead guid Lead writable
Location varchar2 Location writable
Modified datetime Modified writable Last modified date.
ModifiedUtc datetime Geändert (UTC) writable Last modified date in UTC.
Modifier guid Modifier writable User ID of modifier.
MultipleEntryCols varchar2 Spalten mit mehreren Einträgen writable
MultipleEntryID guid ID für mehrere Einträge writable
Opportunity guid Opportunity writable
OpportunityDescription varchar2 itgen_eol_opportunitydescription writable
PayrollComponent guid Personalabrechnung writable
PayrollPeriod int32 Gehaltsabrechnung Periode writable
PayrollYear int32 Gehaltsliste Jahr writable
Priority int32 Priority writable
Processed datetime Processed writable
Processor guid Processor writable
Project guid Project writable
ProjectDescription varchar2(60) Projektbeschreibung writable
QuantityActual_1 double Tatsächliche Menge 1 writable
QuantityActual_2 double Tatsächliche Menge 2 writable
Quantity_1 double Anzahl 1 writable
Quantity_2 double Anzahl 2 writable
Realized datetime Realized writable
Realizer guid Realizer writable
Reminder int16 Reminder writable
RequestComments varchar2 Anfragekommentare filters on the platform, writable
ResubmitStatus int16 Status der erneuten Einreichung writable
SecurityLevel int32 Sicherheitsstufe writable
StartDate datetime Anfangsdatum filters on the platform, writable
StartDateActual datetime Startdatum (tatsächlich) writable
Status int16 Status filters on the platform, writable
StatusChanged datetime Status geändert writable
SubStatus int32 Untertitel-Status writable
SubscriptionOwnerName varchar2 Abonnementinhabername writable Name of the subscription owner.Name is derived from the description and may be inaccurate.
TaskSubType int32 Aufgabenuntertyp writable
Type guid Type filters on the platform, writable
TypeDescription varchar2(240) Typ Beschreibung writable
TypeHID int32 Typ: Mensch-ID filters on the platform, writable
UserFullName varchar2(240) Vollständiger Benutzername writable
UserHID int32 Benutzer-ID writable
UserID guid Benutzer-Kennung writable
WorkflowComments varchar2 Workflow-Kommentare writable
XBRLDocument guid XBRL-Dokument writable
YourRef varchar2(60) Ihre Referenz filters on the platform, writable Your reference.

Tasten

Key Column Bezieht sich auf 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

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: