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. | |
Account |
varchar2 |
Konto Code | writable | ||
Account |
varchar2 |
Konto Name | writable | Name of account. | |
Amount |
double |
Amount | writable | ||
Amount |
double |
Betrag Ist | writable | ||
Amount |
double |
Summe Fremdwährung | writable | ||
Amount |
double |
Betrag Währung Ist | writable | ||
Approved |
datetime |
Approved | writable | ||
Approver |
guid |
Approver | writable | ||
Approver |
varchar2 |
Vollständigen Namen bestätigen | writable | ||
Buildup |
char |
Build-up | writable | ||
Campaign |
guid |
Campaign | writable | ||
Contact |
guid |
Contact | writable | ||
Contact |
varchar2 |
Ansprechpartner – Vollständiger Name | writable | ||
Context |
guid |
Kontext-ID | filters on the platform, writable | ||
Context |
int32 |
Kontextart | filters on the platform, writable | ||
Created |
datetime |
Created | writable | Creation date. | |
Created |
datetime |
Angelegt | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | User ID of creator. | |
Creator |
varchar2 |
Ersteller vollständiger Name | writable | Name of creator. | |
Currency |
varchar2 |
Currency | writable | Code of Currency. | |
Currency |
varchar2 |
itgen_eol_currencyactual | writable | Code of actual currency. | |
Days |
double |
itgen_eol_days | writable | ||
Days |
double |
itgen_eol_daysactual | writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | ||
Division |
int32 |
Division | writable | ||
Division |
int64 |
itgen_eol_divisionhid | filters on the platform, writable | ||
Division |
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 | ||
End |
datetime |
Enddatum | writable | ||
End |
datetime |
Tatsächliches Enddatum | writable | ||
Error |
int32 |
Fehlerprotokoll-ID | writable | ||
Financial |
guid |
Finanzeintrag | writable | ||
Free |
char |
Freies Boolesches Feld Nr. 1 | writable | ||
Free |
char |
Freies Boolesches Feld Nr. 2 | writable | ||
Free |
char |
Freies Boolesches Feld Nr. 3 | writable | ||
Free |
char |
Freies Boolesches Feld Nr. 4 | writable | ||
Free |
char |
Freies Boolesches Feld Nr. 5 | writable | ||
Free |
datetime |
Freies Datumsfeld Nr. 1 | writable | ||
Free |
datetime |
Freies Datumsfeld Nr. 2 | writable | ||
Free |
datetime |
Freies Datumsfeld Nr. 3 | writable | ||
Free |
datetime |
Freies Datumsfeld Nr. 4 | writable | ||
Free |
datetime |
Freies Datumsfeld Nr. 5 | writable | ||
Free |
guid |
Freies GUID-Feld 1 | writable | ||
Free |
guid |
Freies GUID-Feld 2 | writable | ||
Free |
guid |
Freies GUID-Feld 3 | writable | ||
Free |
guid |
Freies GUID-Feld 4 | writable | ||
Free |
guid |
Freies GUID-Feld 5 | writable | ||
Free |
guid |
Freies GUID-Feld 6 | writable | ||
Free |
guid |
Freies GUID-Feld 7 | writable | ||
Free |
guid |
Freies GUID-Feld 8 | writable | ||
Free |
guid |
Freies GUID-Feld 9 | writable | ||
Free |
guid |
Freies GUID-Feld 10 | writable | ||
Free |
int32 |
Freies Ganzzahlfeld 1 | writable | ||
Free |
int32 |
Freies Ganzzahlfeld 2 | writable | ||
Free |
int32 |
Freies Ganzzahlfeld 3 | writable | ||
Free |
int32 |
Freies Ganzzahlfeld 4 | writable | ||
Free |
int32 |
Freies Ganzzahlfeld 5 | writable | ||
Free |
double |
Freies Zahlenfeld Nr. 1 | writable | ||
Free |
double |
Freies Zahlenfeld Nr. 2 | writable | ||
Free |
double |
Freies Zahlenfeld Nr. 3 | writable | ||
Free |
double |
Freies Zahlenfeld Nr. 4 | writable | ||
Free |
double |
Freies Zahlenfeld Nr. 5 | writable | ||
Free |
varchar2 |
Freitextfeld Nr. 1 | writable | ||
Free |
varchar2 |
Freitextfeld Nr. 2 | writable | ||
Free |
varchar2 |
Freitextfeld Nr. 3 | writable | ||
Free |
varchar2 |
Freitextfeld Nr. 4 | writable | ||
Free |
varchar2 |
Freitextfeld Nr. 5 | writable | ||
Free |
varchar2 |
Freitextfeld Nr. 6 | writable | ||
Free |
varchar2 |
Freitextfeld Nr. 7 | writable | ||
Free |
varchar2 |
Freitextfeld Nr. 8 | writable | ||
Free |
varchar2 |
Freitextfeld Nr. 9 | writable | ||
Free |
varchar2 |
Freitextfeld Nr. 10 | writable | ||
Free |
varchar2 |
Freitextfeld 11 | writable | ||
Free |
varchar2 |
Freitextfeld 12 | writable | ||
Free |
varchar2 |
itgen_eol_freetextfield_13 | writable | ||
Free |
varchar2 |
Freitextfeld 14 | writable | ||
Free |
varchar2 |
Freitextfeld 15 | writable | ||
HID |
int32 |
HID | writable | ||
Help |
guid |
Hilfedatei | writable | ||
Help |
guid |
Hilfe-Eintrag | writable | ||
Hours |
double |
Hours | writable | ||
Hours |
double |
Tatsächliche Arbeitsstunden | writable | ||
ID |
guid |
ID | filters on the platform, writable | ||
In |
char |
Im Workflow | writable | ||
IsRead |
char |
Ist gelesen | writable | ||
Item |
varchar2 |
Artikelcode 1 | writable | ||
Item |
varchar2 |
Artikelbeschreibung 1 | writable | Description of Item. | |
Item |
guid |
Artikelnummer ID 1 | writable | ||
Item |
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. | |
Modified |
datetime |
Geändert (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Multiple |
varchar2 |
Spalten mit mehreren Einträgen | writable | ||
Multiple |
guid |
ID für mehrere Einträge | writable | ||
Opportunity |
guid |
Opportunity | writable | ||
Opportunity |
varchar2 |
itgen_eol_opportunitydescription | writable | ||
Payroll |
guid |
Personalabrechnung | writable | ||
Payroll |
int32 |
Gehaltsabrechnung Periode | writable | ||
Payroll |
int32 |
Gehaltsliste Jahr | writable | ||
Priority |
int32 |
Priority | writable | ||
Processed |
datetime |
Processed | writable | ||
Processor |
guid |
Processor | writable | ||
Project |
guid |
Project | writable | ||
Project |
varchar2 |
Projektbeschreibung | writable | ||
Quantity |
double |
Tatsächliche Menge 1 | writable | ||
Quantity |
double |
Tatsächliche Menge 2 | writable | ||
Quantity_ |
double |
Anzahl 1 | writable | ||
Quantity_ |
double |
Anzahl 2 | writable | ||
Realized |
datetime |
Realized | writable | ||
Realizer |
guid |
Realizer | writable | ||
Reminder |
int16 |
Reminder | writable | ||
Request |
varchar2 |
Anfragekommentare | filters on the platform, writable | ||
Resubmit |
int16 |
Status der erneuten Einreichung | writable | ||
Security |
int32 |
Sicherheitsstufe | writable | ||
Start |
datetime |
Anfangsdatum | filters on the platform, writable | ||
Start |
datetime |
Startdatum (tatsächlich) | writable | ||
Status |
int16 |
Status | filters on the platform, writable | ||
Status |
datetime |
Status geändert | writable | ||
Sub |
int32 |
Untertitel-Status | writable | ||
Subscription |
varchar2 |
Abonnementinhabername | writable | Name of the subscription owner.Name is derived from the description and may be inaccurate. | |
Task |
int32 |
Aufgabenuntertyp | writable | ||
Type |
guid |
Type | filters on the platform, writable | ||
Type |
varchar2 |
Typ Beschreibung | writable | ||
Type |
int32 |
Typ: Mensch-ID | filters on the platform, writable | ||
User |
varchar2 |
Vollständiger Benutzername | writable | ||
User |
int32 |
Benutzer-ID | writable | ||
UserID |
guid |
Benutzer-Kennung | writable | ||
Workflow |
varchar2 |
Workflow-Kommentare | writable | ||
XBRL |
guid |
XBRL-Dokument | writable | ||
Your |
varchar2 |
Ihre Referenz | filters on the platform, writable | Your reference. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
Customer |
Account |
Accounts.ID |
Key | |
Customer |
Creator |
Users. |
Key | |
Customer |
Currency |
Currencies.Code |
Key | |
Customer |
Modifier |
Users. |
Key |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: