CustomerCooperations: Exact Online Customer Cooperations
insert update delete REST
- Catalog:
ExactOnlineREST - Schema:
Workflow - Primary Keys:
ID - Label: Customer Cooperations
Can retrieve data and change data using insert, update and delete.
API Source
- Endpoint:
/api/v1/beta/{division}/workflow/CustomerCooperations - Metadata:
/api/v1/beta/{division}/workflow/$metadata
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 5 |
| Full scan rows per minute | 7,200 |
| Point query rows per minute | 300 |
| Write rows per minute | 300 |
The result can be cached on the client.
Table Columns
The columns of the table CustomerCooperations are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | 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 |
Account Name | writable | Name of account. | |
Amount |
double |
Amount | writable | ||
Amount |
double |
Amount Actual | writable | ||
Amount |
double |
Amount Foreign Currency | writable | ||
Amount |
double |
Amount Foreign Currency Actual | writable | ||
Approved |
datetime |
Approved | writable | ||
Approver |
guid |
Approver | writable | ||
Approver |
varchar2 |
Approver Full Name | writable | ||
Buildup |
char |
Build-up | writable | ||
Campaign |
guid |
Campaign | writable | ||
Contact |
guid |
Contact | writable | ||
Contact |
varchar2 |
Contact Full Name | writable | ||
Context |
guid |
Context ID | filters on the platform, writable | ||
Context |
int32 |
Context Type | filters on the platform, writable | ||
Created |
datetime |
Created | writable | Creation date. | |
Created |
datetime |
Created (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | User ID of creator. | |
Creator |
varchar2 |
Creator Full 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 |
Administration 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 |
End Date | writable | ||
End |
datetime |
End Date Actual | writable | ||
Error |
int32 |
Error Log ID | writable | ||
Financial |
guid |
Financial Entry | writable | ||
Free |
char |
Free Boolean Field #1 | writable | ||
Free |
char |
Free Boolean Field #2 | writable | ||
Free |
char |
Free Boolean Field #3 | writable | ||
Free |
char |
Free Boolean Field #4 | writable | ||
Free |
char |
Free Boolean Field #5 | writable | ||
Free |
datetime |
Free Date Field #1 | writable | ||
Free |
datetime |
Free Date Field #2 | writable | ||
Free |
datetime |
Free Date Field #3 | writable | ||
Free |
datetime |
Free Date Field #4 | writable | ||
Free |
datetime |
Free Date Field #5 | writable | ||
Free |
guid |
Free GUID Field 1 | writable | ||
Free |
guid |
Free GUID Field 2 | writable | ||
Free |
guid |
Free GUID Field 3 | writable | ||
Free |
guid |
Free GUID Field 4 | writable | ||
Free |
guid |
Free GUID Field 5 | writable | ||
Free |
guid |
Free GUID Field 6 | writable | ||
Free |
guid |
Free GUID Field 7 | writable | ||
Free |
guid |
Free GUID Field 8 | writable | ||
Free |
guid |
Free GUID Field 9 | writable | ||
Free |
guid |
Free GUID Field 10 | writable | ||
Free |
int32 |
Free Integer Field 1 | writable | ||
Free |
int32 |
Free Integer Field 2 | writable | ||
Free |
int32 |
Free Integer Field 3 | writable | ||
Free |
int32 |
Free Integer Field 4 | writable | ||
Free |
int32 |
Free Integer Field 5 | writable | ||
Free |
double |
Free Number Field #1 | writable | ||
Free |
double |
Free Number Field #2 | writable | ||
Free |
double |
Free Number Field #3 | writable | ||
Free |
double |
Free Number Field #4 | writable | ||
Free |
double |
Free Number Field #5 | writable | ||
Free |
varchar2 |
Free Text Field #1 | writable | ||
Free |
varchar2 |
Free Text Field #2 | writable | ||
Free |
varchar2 |
Free Text Field #3 | writable | ||
Free |
varchar2 |
Free Text Field #4 | writable | ||
Free |
varchar2 |
Free Text Field #5 | writable | ||
Free |
varchar2 |
Free Text Field #6 | writable | ||
Free |
varchar2 |
Free Text Field #7 | writable | ||
Free |
varchar2 |
Free Text Field #8 | writable | ||
Free |
varchar2 |
Free Text Field #9 | writable | ||
Free |
varchar2 |
Free Text Field #10 | writable | ||
Free |
varchar2 |
Free Text Field 11 | writable | ||
Free |
varchar2 |
Free Text Field 12 | writable | ||
Free |
varchar2 |
itgen_eol_freetextfield_13 | writable | ||
Free |
varchar2 |
Free Text Field 14 | writable | ||
Free |
varchar2 |
Free Text Field 15 | writable | ||
HID |
int32 |
HID | writable | ||
Help |
guid |
Help File | writable | ||
Help |
guid |
Help Item | writable | ||
Hours |
double |
Hours | writable | ||
Hours |
double |
Hours Actual | writable | ||
ID |
guid |
ID | filters on the platform, writable | ||
In |
char |
In Workflow | writable | ||
IsRead |
char |
Is Read | writable | ||
Item |
varchar2 |
Item Code 1 | writable | ||
Item |
varchar2 |
Item Description 1 | writable | Description of Item. | |
Item |
guid |
Item Number ID 1 | writable | ||
Item |
guid |
Item Number ID 2 | writable | ||
Item_1 |
guid |
Item 1 | writable | ||
Item_2 |
guid |
Item 2 | writable | ||
Lead |
guid |
Lead | writable | ||
Location |
varchar2 |
Location | writable | ||
Modified |
datetime |
Modified | writable | Last modified date. | |
Modified |
datetime |
Modified (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Multiple |
varchar2 |
Multiple Entry Columns | writable | ||
Multiple |
guid |
Multiple Entry ID | writable | ||
Opportunity |
guid |
Opportunity | writable | ||
Opportunity |
varchar2 |
itgen_eol_opportunitydescription | writable | ||
Payroll |
guid |
Payroll Component | writable | ||
Payroll |
int32 |
Payroll Period | writable | ||
Payroll |
int32 |
Payroll Year | writable | ||
Priority |
int32 |
Priority | writable | ||
Processed |
datetime |
Processed | writable | ||
Processor |
guid |
Processor | writable | ||
Project |
guid |
Project | writable | ||
Project |
varchar2 |
Project Description | writable | ||
Quantity |
double |
Quantity Actual 1 | writable | ||
Quantity |
double |
Quantity Actual 2 | writable | ||
Quantity_ |
double |
Quantity 1 | writable | ||
Quantity_ |
double |
Quantity 2 | writable | ||
Realized |
datetime |
Realized | writable | ||
Realizer |
guid |
Realizer | writable | ||
Reminder |
int16 |
Reminder | writable | ||
Request |
varchar2 |
Request Comments | filters on the platform, writable | ||
Resubmit |
int16 |
Resubmit Status | writable | ||
Security |
int32 |
Security Level | writable | ||
Start |
datetime |
Start Date | filters on the platform, writable | ||
Start |
datetime |
Start Date Actual | writable | ||
Status |
int16 |
Status | filters on the platform, writable | ||
Status |
datetime |
Status Changed | writable | ||
Sub |
int32 |
Sub Status | writable | ||
Subscription |
varchar2 |
Subscription Owner Name | writable | Name of the subscription owner. Name is derived from the description and may be inaccurate. | |
Task |
int32 |
Task Subtype | writable | ||
Type |
guid |
Type | filters on the platform, writable | ||
Type |
varchar2 |
Type Description | writable | ||
Type |
int32 |
Type Human ID | filters on the platform, writable | ||
User |
varchar2 |
User Full Name | writable | ||
User |
int32 |
User Human ID | writable | ||
UserID |
guid |
User ID | writable | ||
Workflow |
varchar2 |
Workflow Comments | writable | ||
XBRL |
guid |
XBRL Document | writable | ||
Your |
varchar2 |
Your Reference | filters on the platform, writable | Your reference. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Customer |
Account |
Accounts.ID |
Key | |
Customer |
Creator |
Users. |
Key | |
Customer |
Currency |
Currencies.Code |
Key | |
Customer |
Modifier |
Users. |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: