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. | |
Account |
varchar2 |
Account Code | writable | ||
Account |
varchar2 |
Accountnaam | writable | Name of account. | |
Amount |
double |
Amount | writable | ||
Amount |
double |
Werkelijk Bedrag | writable | ||
Amount |
double |
Bedrag Vreemde Valuta | writable | ||
Amount |
double |
Werkelijk Bedrag Vreemde Valuta | writable | ||
Approved |
datetime |
Approved | writable | ||
Approver |
guid |
Approver | writable | ||
Approver |
varchar2 |
Goedkeurder Volledige naam | writable | ||
Buildup |
char |
Build-up | writable | ||
Campaign |
guid |
Campaign | writable | ||
Contact |
guid |
Contact | writable | ||
Contact |
varchar2 |
Contactpersoon Volledige Naam | writable | ||
Context |
guid |
Context ID | filters on the platform, writable | ||
Context |
int32 |
Contextsoort | filters on the platform, writable | ||
Created |
datetime |
Created | writable | Creation date. | |
Created |
datetime |
Aangemaakt (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | User ID of creator. | |
Creator |
varchar2 |
Aanmaker Volledige Naam | 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 |
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 | ||
End |
datetime |
Einddatum | writable | ||
End |
datetime |
Daadwerkelijke Einddatum | writable | ||
Error |
int32 |
Foutlogboek-ID | writable | ||
Financial |
guid |
Financiële Boeking | writable | ||
Free |
char |
Vrij Booleaans Veld #1 | writable | ||
Free |
char |
Vrij Booleaans Veld #2 | writable | ||
Free |
char |
Vrij Booleaans Veld #3 | writable | ||
Free |
char |
Vrij Booleaans Veld #4 | writable | ||
Free |
char |
Vrij Booleaans Veld #5 | writable | ||
Free |
datetime |
Vrij Datumveld #1 | writable | ||
Free |
datetime |
Vrij Datumveld #2 | writable | ||
Free |
datetime |
Vrij Datumveld #3 | writable | ||
Free |
datetime |
Vrij Datumveld #4 | writable | ||
Free |
datetime |
Vrij Datumveld #5 | writable | ||
Free |
guid |
Vrij GUID-veld 1 | writable | ||
Free |
guid |
Vrij GUID-veld 2 | writable | ||
Free |
guid |
Vrij GUID-veld 3 | writable | ||
Free |
guid |
Vrij GUID-veld 4 | writable | ||
Free |
guid |
Vrij GUID-veld 5 | writable | ||
Free |
guid |
Vrij GUID-veld 6 | writable | ||
Free |
guid |
Vrij GUID-veld 7 | writable | ||
Free |
guid |
Vrij GUID-veld 8 | writable | ||
Free |
guid |
Vrij GUID-veld 9 | writable | ||
Free |
guid |
Vrij GUID-veld 10 | writable | ||
Free |
int32 |
Vrij Integer-veld 1 | writable | ||
Free |
int32 |
Vrij Integer-veld 2 | writable | ||
Free |
int32 |
Vrij Integer-veld 3 | writable | ||
Free |
int32 |
Vrij Integer-veld 4 | writable | ||
Free |
int32 |
Vrij Integer-veld 5 | writable | ||
Free |
double |
Vrij Numeriek Veld #1 | writable | ||
Free |
double |
Vrij Numeriek Veld #2 | writable | ||
Free |
double |
Vrij Numeriek Veld #3 | writable | ||
Free |
double |
Vrij Numeriek Veld #4 | writable | ||
Free |
double |
Vrij Numeriek Veld #5 | writable | ||
Free |
varchar2 |
Vrij Tekstveld #1 | writable | ||
Free |
varchar2 |
Vrij Tekstveld #2 | writable | ||
Free |
varchar2 |
Vrij Tekstveld #3 | writable | ||
Free |
varchar2 |
Vrij Tekstveld #4 | writable | ||
Free |
varchar2 |
Vrij Tekstveld #5 | writable | ||
Free |
varchar2 |
Vrij Tekstveld #6 | writable | ||
Free |
varchar2 |
Vrij Tekstveld #7 | writable | ||
Free |
varchar2 |
Vrij Tekstveld #8 | writable | ||
Free |
varchar2 |
Vrij Tekstveld #9 | writable | ||
Free |
varchar2 |
Vrij Tekstveld #10 | writable | ||
Free |
varchar2 |
Vrij Tekstveld 11 | writable | ||
Free |
varchar2 |
Vrij Tekstveld 12 | writable | ||
Free |
varchar2 |
itgen_eol_freetextfield_13 | writable | ||
Free |
varchar2 |
Vrij Tekstveld 14 | writable | ||
Free |
varchar2 |
Vrij Tekstveld 15 | writable | ||
HID |
int32 |
HID | writable | ||
Help |
guid |
Helpbestand | writable | ||
Help |
guid |
Helpartikel | writable | ||
Hours |
double |
Hours | writable | ||
Hours |
double |
Werkelijke Uren | writable | ||
ID |
guid |
ID | filters on the platform, writable | ||
In |
char |
In Werkstroom | writable | ||
IsRead |
char |
Is Gelezen | writable | ||
Item |
varchar2 |
Artikelcode 1 | writable | ||
Item |
varchar2 |
Artikelomschrijving 1 | writable | Description of Item. | |
Item |
guid |
Artikelnummer-ID 1 | writable | ||
Item |
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. | |
Modified |
datetime |
Gewijzigd (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Multiple |
varchar2 |
Meerdere Invoerkolommen | writable | ||
Multiple |
guid |
Meerdere Invoer-ID | writable | ||
Opportunity |
guid |
Opportunity | writable | ||
Opportunity |
varchar2 |
itgen_eol_opportunitydescription | writable | ||
Payroll |
guid |
Salaris Component | writable | ||
Payroll |
int32 |
Salarisboeking | writable | ||
Payroll |
int32 |
Loonjaar | writable | ||
Priority |
int32 |
Priority | writable | ||
Processed |
datetime |
Processed | writable | ||
Processor |
guid |
Processor | writable | ||
Project |
guid |
Project | writable | ||
Project |
varchar2 |
Projectomschrijving | writable | ||
Quantity |
double |
Werkelijke Hoeveelheid 1 | writable | ||
Quantity |
double |
Werkelijke Hoeveelheid 2 | writable | ||
Quantity_ |
double |
Hoeveelheid 1 | writable | ||
Quantity_ |
double |
Hoeveelheid 2 | writable | ||
Realized |
datetime |
Realized | writable | ||
Realizer |
guid |
Realizer | writable | ||
Reminder |
int16 |
Reminder | writable | ||
Request |
varchar2 |
Verzoek om Opmerkingen | filters on the platform, writable | ||
Resubmit |
int16 |
Status Opnieuw Indienen | writable | ||
Security |
int32 |
Beveiligingsniveau | writable | ||
Start |
datetime |
Startdatum | filters on the platform, writable | ||
Start |
datetime |
Daadwerkelijke Startdatum | writable | ||
Status |
int16 |
Status | filters on the platform, writable | ||
Status |
datetime |
Status Gewijzigd | writable | ||
Sub |
int32 |
Substatus | writable | ||
Subscription |
varchar2 |
Abonnementshouder Naam | writable | Name of the subscription owner.Name is derived from the description and may be inaccurate. | |
Task |
int32 |
Taaksubtype | writable | ||
Type |
guid |
Type | filters on the platform, writable | ||
Type |
varchar2 |
Soort Omschrijving | writable | ||
Type |
int32 |
Soort Mens-ID | filters on the platform, writable | ||
User |
varchar2 |
Gebruiker Volledige Naam | writable | ||
User |
int32 |
Gebruiker Menselijke ID | writable | ||
UserID |
guid |
Gebruikers-ID | writable | ||
Workflow |
varchar2 |
Workflow-opmerkingen | writable | ||
XBRL |
guid |
XBRL-document | writable | ||
Your |
varchar2 |
Uw Referentie | filters on the platform, writable | Your reference. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
Customer |
Account |
Accounts.ID |
Key | |
Customer |
Creator |
Users. |
Key | |
Customer |
Currency |
Currencies.Code |
Key | |
Customer |
Modifier |
Users. |
Key |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: