invantive documentation
Invantive Support ForumsLog In / Sign Up

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.
AccountCode varchar2(18) Account Code writable
AccountName varchar2(50) Account Name writable Name of account.
Amount double Amount writable
AmountActual double Amount Actual writable
AmountFC double Amount Foreign Currency writable
AmountFCActual double Amount Foreign Currency Actual writable
Approved datetime Approved writable
Approver guid Approver writable
ApproverFullName varchar2(240) Approver Full Name writable
Buildup char Build-up writable
Campaign guid Campaign writable
Contact guid Contact writable
ContactFullName varchar2(240) Contact Full Name writable
ContextID guid Context ID filters on the platform, writable
ContextType int32 Context Type filters on the platform, writable
Created datetime Created writable Creation date.
CreatedUtc datetime Created (UTC) writable Creation date in UTC.
Creator guid Creator writable User ID of creator.
CreatorFullName varchar2(240) Creator Full 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 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
EndDate datetime End Date writable
EndDateActual datetime End Date Actual writable
ErrorLogID int32 Error Log ID writable
FinancialEntry guid Financial Entry writable
FreeBoolField_01 char Free Boolean Field #1 writable
FreeBoolField_02 char Free Boolean Field #2 writable
FreeBoolField_03 char Free Boolean Field #3 writable
FreeBoolField_04 char Free Boolean Field #4 writable
FreeBoolField_05 char Free Boolean Field #5 writable
FreeDateField_01 datetime Free Date Field #1 writable
FreeDateField_02 datetime Free Date Field #2 writable
FreeDateField_03 datetime Free Date Field #3 writable
FreeDateField_04 datetime Free Date Field #4 writable
FreeDateField_05 datetime Free Date Field #5 writable
FreeGuidField_01 guid Free GUID Field 1 writable
FreeGuidField_02 guid Free GUID Field 2 writable
FreeGuidField_03 guid Free GUID Field 3 writable
FreeGuidField_04 guid Free GUID Field 4 writable
FreeGuidField_05 guid Free GUID Field 5 writable
FreeGuidField_06 guid Free GUID Field 6 writable
FreeGuidField_07 guid Free GUID Field 7 writable
FreeGuidField_08 guid Free GUID Field 8 writable
FreeGuidField_09 guid Free GUID Field 9 writable
FreeGuidField_10 guid Free GUID Field 10 writable
FreeIntField_01 int32 Free Integer Field 1 writable
FreeIntField_02 int32 Free Integer Field 2 writable
FreeIntField_03 int32 Free Integer Field 3 writable
FreeIntField_04 int32 Free Integer Field 4 writable
FreeIntField_05 int32 Free Integer Field 5 writable
FreeNumberField_01 double Free Number Field #1 writable
FreeNumberField_02 double Free Number Field #2 writable
FreeNumberField_03 double Free Number Field #3 writable
FreeNumberField_04 double Free Number Field #4 writable
FreeNumberField_05 double Free Number Field #5 writable
FreeTextField_01 varchar2 Free Text Field #1 writable
FreeTextField_02 varchar2 Free Text Field #2 writable
FreeTextField_03 varchar2 Free Text Field #3 writable
FreeTextField_04 varchar2 Free Text Field #4 writable
FreeTextField_05 varchar2 Free Text Field #5 writable
FreeTextField_06 varchar2 Free Text Field #6 writable
FreeTextField_07 varchar2 Free Text Field #7 writable
FreeTextField_08 varchar2 Free Text Field #8 writable
FreeTextField_09 varchar2 Free Text Field #9 writable
FreeTextField_10 varchar2 Free Text Field #10 writable
FreeTextField_11 varchar2 Free Text Field 11 writable
FreeTextField_12 varchar2 Free Text Field 12 writable
FreeTextField_13 varchar2 itgen_eol_freetextfield_13 writable
FreeTextField_14 varchar2 Free Text Field 14 writable
FreeTextField_15 varchar2 Free Text Field 15 writable
HID int32 HID writable
HelpFile guid Help File writable
HelpItem guid Help Item writable
Hours double Hours writable
HoursActual double Hours Actual writable
ID guid ID filters on the platform, writable
InWorkflow char In Workflow writable
IsRead char Is Read writable
ItemCode_1 varchar2(30) Item Code 1 writable
ItemDescription_1 varchar2(255) Item Description 1 writable Description of Item.
ItemNumberID_1 guid Item Number ID 1 writable
ItemNumberID_2 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.
ModifiedUtc datetime Modified (UTC) writable Last modified date in UTC.
Modifier guid Modifier writable User ID of modifier.
MultipleEntryCols varchar2 Multiple Entry Columns writable
MultipleEntryID guid Multiple Entry ID writable
Opportunity guid Opportunity writable
OpportunityDescription varchar2 itgen_eol_opportunitydescription writable
PayrollComponent guid Payroll Component writable
PayrollPeriod int32 Payroll Period writable
PayrollYear int32 Payroll Year writable
Priority int32 Priority writable
Processed datetime Processed writable
Processor guid Processor writable
Project guid Project writable
ProjectDescription varchar2(60) Project Description writable
QuantityActual_1 double Quantity Actual 1 writable
QuantityActual_2 double Quantity Actual 2 writable
Quantity_1 double Quantity 1 writable
Quantity_2 double Quantity 2 writable
Realized datetime Realized writable
Realizer guid Realizer writable
Reminder int16 Reminder writable
RequestComments varchar2 Request Comments filters on the platform, writable
ResubmitStatus int16 Resubmit Status writable
SecurityLevel int32 Security Level writable
StartDate datetime Start Date filters on the platform, writable
StartDateActual datetime Start Date Actual writable
Status int16 Status filters on the platform, writable
StatusChanged datetime Status Changed writable
SubStatus int32 Sub Status writable
SubscriptionOwnerName varchar2 Subscription Owner Name writable Name of the subscription owner. Name is derived from the description and may be inaccurate.
TaskSubType int32 Task Subtype writable
Type guid Type filters on the platform, writable
TypeDescription varchar2(240) Type Description writable
TypeHID int32 Type Human ID filters on the platform, writable
UserFullName varchar2(240) User Full Name writable
UserHID int32 User Human ID writable
UserID guid User ID writable
WorkflowComments varchar2 Workflow Comments writable
XBRLDocument guid XBRL Document writable
YourRef varchar2(60) Your Reference filters on the platform, writable Your reference.

Keys

Key Column Refers to 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

What changed per release in the tables, columns, attributes and capabilities of the driver: