Exact Time & Billing (Independent Publisher) (Preview)
![](https://connectoricons-prod.azureedge.net/u/shgogna/version-mismatches-special-train/1.0.1670.3520/exactonlinetimebilip/icon.png)
This API contains all methods for the Exact Online package "Time & Billing".
This connector is available in the following products and regions:
Service | Class | Regions |
---|---|---|
Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - US Department of Defense (DoD) |
Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
Power Apps | Premium | All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
Contact | |
---|---|
Name | Indocs |
URL | https://indocs.nl |
[email protected] |
Connector Metadata | |
---|---|
Publisher | Indocs |
Website | https://indocs.nl |
Privacy policy | https://indocs.nl/privacyverklaring |
Categories | Sales and CRM;Human Resources |
Creating a connection
The connector supports the following authentication types:
Default | Parameters for creating connection. | All regions | Not shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
Name | Type | Description | Required |
---|---|---|---|
Client Id | string | Please enter the client Id. | True |
Client Secret | securestring | Please enter the client secret. | True |
Throttling Limits
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 100 | 60 seconds |
Actions
Create project restriction rebillings |
This endpoint enables users to restrict which cost types the project allows rebilling to customer. |
Create time corrections |
Use this endpoint to create, read, update and delete time correction to correct final time entries that already invoiced. |
Create time transactions |
Use this endpoint to create, read, update and delete time transaction of the user.Note: For creating a time transactions, it is mandatory to supply item, project and the quantity of hour. |
Delete project restriction rebillings |
This endpoint enables users to restrict which cost types the project allows rebilling to customer. |
Delete time corrections |
Use this endpoint to create, read, update and delete time correction to correct final time entries that already invoiced. |
Delete time transactions |
Use this endpoint to create, read, update and delete time transaction of the user.Note: For creating a time transactions, it is mandatory to supply item, project and the quantity of hour. |
Get divisions |
Returns only divisions that are accessible to the signed-in user, as configured in the user card under 'Companies: Access rights'. Accountants will only see divisions that belong to a single license (either their own or a client's), being the license that owns the division specified in the URI.Please note that divisions returned are only those which the user has granted permission to.Recommended alternative that is not limited to accessible divisions: /api/v1/{division}/system/AllDivisionsRecommended alternative that is not limited to a single license: /api/v1/{division}/system/Divisions |
Get employment internal rates |
Use this endpoint to retrieve internal rates of employees. |
Get hour cost types |
This endpoint enables users to retrieve up to date active Hour and Cost types. |
Get hour entry activities by project |
This endpoint enables users to retrieve a list of WBS Activities and its parent Deliverable based on the project ID provided. |
Get hour entry recent accounts |
Use this endpoint to read a list of accounts that is used by an employee to create hour entries. The list is ordered by the most recently used first. |
Get hour entry recent accounts by project |
This endpoint enables users to retrieve a list of Accounts used by an employee for hour entries based on the Project Id provided. The list is ordered by the most recently used first. |
Get hour entry recent hour types |
Use this endpoint to read a list of items that is used by an employee to create hour entries. The list is ordered by the most recently used first. |
Get hour entry recent hour types by project |
This endpoint enables users to retrieve a list of Items used by an employee for hour entries based on the Project Id provided. The list is ordered by the most recently used first. |
Get hour entry recent projects |
Use this endpoint to read and retrieve projects that employees have used for entering hour entries order by most recently. |
Get hour types |
This endpoint enables users to retrieve up to date active Hour types. |
Get hour types by date |
This endpoint enables users to retrieve active Hour types based on date provided. |
Get hour types by project and date |
Use this endpoint to read active hour types by providing project id and a reference check date.Note: Employee Id parameter is optional. Hour types listed will be based on a hierachy with project employee hour type restriction, project hour type restriction and employee restriction by providing this additional parameter. For this function to work correctly, you must supply all parameters. |
Get hours by date |
Use this endpoint to read , filter and display all hour entries by employee based on the Date provided. |
Get hours by id |
This endpoint enables users to retrieve an hour entry's information for an employee. |
Get me |
This end point retrieves information about the current user. |
Get project restriction rebillings |
This endpoint enables users to restrict which cost types the project allows rebilling to customer. |
Get project time cost transactions |
The TimeCostTransactions sync api returns both time and cost transactions. To filter out time or cost transactions you need to filter only on property Type. The API does not allow to filter on these fields. Filtering need to be done after receiving the records. The sync api's have the goal to keep the data between Exact Online and a 3rd party application the same. The sync api's are all based on row versioning and because of that it is guaranteed to be unique. Every time an existing record is changed or a new record is inserted, the row versioning value is higher than the highest available value at that time. When retrieving records via these api's also a timestamp value is returned. The highest timestamp value of the records returned should be stored on client side. Next time records are retrieved, the timestamp value stored on client side should be provided as parameter. The api will then return only the new and changed records. Using this method is more reliable than using modified date, since it can happen that multiple records have the same modified date and therefore same record can be returned more than once. This will not happen when using timestamp. The sync api's are also developed to give best performance when retrieving records. Because of performance and the intended purpose of the api's, only the timestamp field is allowed as parameter. The single and bulk api’s are designed for a different purpose. They provide ability to retrieve specific record or a set of records which meet certain conditions. In case the division is moved to another database in Exact Online the timestamp values will be reset. Therefore, after a division is moved all data needs to be synchronized again in order to get the new timestamp values. To see if a division was moved, the /api/v1/{division}/system/Divisions can be used. The property DivisionMoveDate indicated at which date a division was moved and this date can be used to determine if it is needed to synchronize all data again. The API has two important key fields, the Timestamp and the ID. The ID should be used to uniquely identify the record and will never change. The Timestamp is used to get new or changed records in an efficient way and will change for every change made to the record. The timestamp value returned has no relation with actual date or time. As such it cannot be converted to a date\time value. The timestamp is a rowversion value. When you use the sync or delete api for the first time for a particular division, filter on timestamp greater than 1. |
Get recent costs by number of weeks |
Use this endpoint to read cost entries in the last specified number of ISO weeks.For time and billing project users to gather insight on the cost based on status by the user per week ordered by the most recent date, in turn aid in generate powerful reports. |
Get recent hours |
This endpoint enables users to retrieve hour entries in the last 4 ISO weeks, including the current week. The list is ordered by most recent date first. |
Get recent hours by number of weeks |
Use this endpoint to read hour entries in the last specified number of ISO weeks.For time and billing project users to gather insight on the amount of hours based on status by the user per week ordered by the most recent date, in turn aid in generate powerful reports. |
Get time and billing account details |
This endpoint enables users to retrieve the account details. |
Get time and billing account details byid |
This endpoint enables users to retrieve the account details. |
Get time and billing activities and expenses |
Use this endpoint to retrieve a list of Activities, Expenses and its parent Deliverable. |
Get time and billing entry accounts |
This endpoint enables users to retrieve currently active account details. |
Get time and billing entry accounts by date |
This endpoint enables users to retrieve all accounts still active as of the date provided as the parameter. |
Get time and billing entry accounts by project and date |
This endpoint enables users to retrieve the account related to the project ID as of the date provided as the parameters.For this function to work correctly, you must supply all parameters. |
Get time and billing entry projects |
This endpoint enables users to retrieve project code and project description based on the project ID provided. |
Get time and billing entry projects by account and date |
This endpoint enables users to retrieve a list of projects allowed for an employee based on the Account and Date provided.For this function to work correctly, you must supply all parameters. |
Get time and billing entry projects by date |
Use this endpoint to read a list of projects allowed for an employee based on the Date provided.Note: For getting the list, it is mandatory to supply check date. |
Get time and billing entry recent accounts |
This endpoint enables users to retrieve a list of Accounts used by an employee for hour and cost entries. The list is ordered by the most recently used first. |
Get time and billing entry recent activities and expenses |
This endpoint enables users to retrieve a list of Activites and Expenses together with its corresponding parent Deliverable used by an employee for hour and cost entries. The list is ordered by the most recently used first. |
Get time and billing entry recent hour cost types |
This endpoint enables users to retrieve a list of Items used by an employee for hour and cost entries. The list is ordered by the most recently used first. |
Get time and billing entry recent projects |
This endpoint enables users to retrieve a list of Projects used by an employee for hour and cost entries. The list is ordered by the most recently used first. |
Get time and billing item details |
This endpoint enables users to retrieve a list of Items with details. |
Get time and billing item details byid |
Use this endpoint to read an Item used in hour and cost entries with details based on the Item Id provided. |
Get time and billing project details |
This endpoint enables users to retrieve a list of Projects with details. |
Get time and billing project details byid |
Use this endpoint to read and retrieve time and billing project details based on the project ID provided. |
Get time and billing recent projects |
This endpoint enables users to retrieve a list of Projects used by an employee for hour and cost entries. The list is ordered by the most recently used first. |
Get time corrections |
Use this endpoint to create, read, update and delete time correction to correct final time entries that already invoiced. |
Get time transactions |
Use this endpoint to create, read, update and delete time transaction of the user.Note: For creating a time transactions, it is mandatory to supply item, project and the quantity of hour. |
Update project restriction rebillings |
This endpoint enables users to restrict which cost types the project allows rebilling to customer. |
Update time corrections |
Use this endpoint to create, read, update and delete time correction to correct final time entries that already invoiced. |
Update time transactions |
Use this endpoint to create, read, update and delete time transaction of the user.Note: For creating a time transactions, it is mandatory to supply item, project and the quantity of hour. |
Create project restriction rebillings
This endpoint enables users to restrict which cost types the project allows rebilling to customer.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
division
|
division | True | string |
The division |
ID
|
ID | string |
Primary key |
|
CostTypeRebill
|
CostTypeRebill | True | string |
Cost type reference |
CostTypeRebillCode
|
CostTypeRebillCode | string |
Cost type code |
|
CostTypeRebillDescription
|
CostTypeRebillDescription | string |
Cost type description |
|
Created
|
Created | date-time |
Date and time when the project restriction was created |
|
Creator
|
Creator | string |
ID of user that created the project restriction |
|
CreatorFullName
|
CreatorFullName | string |
Full name of user that created the project restriction |
|
Division
|
Division | integer |
Division of project and project restriction |
|
Modified
|
Modified | date-time |
Last date when the project restriction was modified |
|
Modifier
|
Modifier | string |
ID of user that modified the project restriction |
|
ModifierFullName
|
ModifierFullName | string |
Full name of user that modified the project restriction |
|
Project
|
Project | True | string |
Project ID that the restriction is referenced to |
ProjectCode
|
ProjectCode | string |
Project code that the restriction is referenced to |
|
ProjectDescription
|
ProjectDescription | string |
Project description that the restriction is referenced to |
Returns
Create time corrections
Use this endpoint to create, read, update and delete time correction to correct final time entries that already invoiced.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
division
|
division | True | string |
The division |
ID
|
ID | string |
Primary key |
|
Created
|
Created | date-time |
Date and time when the time correction was created |
|
Creator
|
Creator | string |
ID of user that created the time correction |
|
CreatorFullName
|
CreatorFullName | string |
Full name of user that created the time correction |
|
Division
|
Division | integer |
Division code |
|
Modified
|
Modified | date-time |
Last modified date of time correction |
|
Modifier
|
Modifier | string |
ID of user that modified the time correction |
|
ModifierFullName
|
ModifierFullName | string |
Full name of user that modified the time correction |
|
Notes
|
Notes | string |
Notes of time correction for providing additional information |
|
OriginalEntryId
|
OriginalEntryId | string |
Reference to the time entry that this corrects for |
|
Quantity
|
Quantity | double |
Quantity has to be negative value. E.g.: If original quantity is 10 and the correct quantity is 4, this quantity is -6 |
Returns
Create time transactions
Use this endpoint to create, read, update and delete time transaction of the user.Note: For creating a time transactions, it is mandatory to supply item, project and the quantity of hour.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
division
|
division | True | string |
The division |
ID
|
ID | string |
Primary key |
|
Account
|
Account | string |
Guid ID of account that is linked to the project |
|
AccountName
|
AccountName | string |
Name of account that is linked to the project |
|
Activity
|
Activity | string |
Guid ID of activity that is linked to project WBS (work breakdown structure) |
|
ActivityDescription
|
ActivityDescription | string |
Name of activity that is linked to project WBS (work breakdown structure) |
|
Amount
|
Amount | double |
This property is obsolete. Use property 'AmountFC' instead. |
|
AmountFC
|
AmountFC | double |
Calculated amount of the transaction based on (Quantity * PriceFC) |
|
Attachment
|
Attachment | string |
Attachment linked to the transaction (not mandatory) |
|
Created
|
Created | date-time |
Date and time the transaction was created |
|
Creator
|
Creator | string |
The Guid ID of user that created the transaction |
|
CreatorFullName
|
CreatorFullName | string |
The full name of the user that created the record |
|
Currency
|
Currency | string |
Currency of amount FC |
|
Date
|
Date | date-time |
Date and time the time transaction was done |
|
Division
|
Division | integer |
Division code |
|
DivisionDescription
|
DivisionDescription | string |
Description of Division |
|
Employee
|
Employee | string |
Guid ID of the employee that is linked to the time transaction |
|
EndTime
|
EndTime | date-time |
End time of the time transaction |
|
EntryNumber
|
EntryNumber | integer |
Number that represents the grouping of time transactions |
|
ErrorText
|
ErrorText | string |
(Only used by backgroundjobs) To determine which transaction has an error |
|
HourStatus
|
HourStatus | float |
Status of the transaction: 1 = Draft, 2 = Rejected, 10 = Submitted, 11 = Failed on approval, 14 = Processing, 16 = Processing, 19 = Failed while undoing approval, 20 = Final |
|
Item
|
Item | True | string |
Item that is linked to the transaction, which provides the time information |
ItemDescription
|
ItemDescription | string |
Description of the item that is linked to the transaction |
|
ItemDivisable
|
ItemDivisable | boolean |
Indicates if fractional quantities of the item can be used, for example quantity = 0.4 |
|
Modified
|
Modified | date-time |
The date and time transaction record was modified |
|
Modifier
|
Modifier | string |
The Guid ID of the user that modified the records |
|
ModifierFullName
|
ModifierFullName | string |
The full name of the user that modified the record |
|
Notes
|
Notes | string |
Notes linked to the transaction for providing additional information (not mandatory) |
|
Price
|
Price | double |
This property is obsolete. Use property 'PriceFC' instead. |
|
PriceFC
|
PriceFC | double |
For use in AmountFC (Quantiy * Price FC) |
|
Project
|
Project | True | string |
Guid ID of project that is linked to the transaction |
ProjectAccount
|
ProjectAccount | string |
Project account ID that is linked to the transaction (not mandatory) |
|
ProjectAccountCode
|
ProjectAccountCode | string |
Project account code that is linked to the transaction |
|
ProjectAccountName
|
ProjectAccountName | string |
Project account name that is linked to the transaction |
|
ProjectCode
|
ProjectCode | string |
Project code that is linked to the transaction |
|
ProjectDescription
|
ProjectDescription | string |
Project description that is linked to the transaction |
|
Quantity
|
Quantity | True | double |
Quantity of the item that is linked to the transaction |
SkipValidation
|
SkipValidation | boolean |
Skip validation |
|
StartTime
|
StartTime | date-time |
Start time of the time transaction |
|
Subscription
|
Subscription | string |
Guid ID of subscription that is linked to the transaction |
|
SubscriptionAccount
|
SubscriptionAccount | string |
Subscription account ID that is linked to the transaction, this is to identify the referenced subscription |
|
SubscriptionAccountCode
|
SubscriptionAccountCode | string |
Subscription account code that is linked to the transaction |
|
SubscriptionAccountName
|
SubscriptionAccountName | string |
Subscription account name that is linked to the transaction |
|
SubscriptionDescription
|
SubscriptionDescription | string |
Subscription description that is linked to the transaction |
|
SubscriptionNumber
|
SubscriptionNumber | integer |
Subscription number that is linked to the transaction |
|
Type
|
Type | float |
The type of transaction. E.g: 1 = Time, 2 = Cost |
Returns
Delete project restriction rebillings
This endpoint enables users to restrict which cost types the project allows rebilling to customer.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
division
|
division | True | string |
The division |
ID
|
ID | True | string |
Primary key |
Returns
Delete time corrections
Use this endpoint to create, read, update and delete time correction to correct final time entries that already invoiced.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
division
|
division | True | string |
The division |
ID
|
ID | True | string |
Primary key |
Returns
Delete time transactions
Use this endpoint to create, read, update and delete time transaction of the user.Note: For creating a time transactions, it is mandatory to supply item, project and the quantity of hour.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
division
|
division | True | string |
The division |
ID
|
ID | True | string |
Primary key |
Returns
Get divisions
Returns only divisions that are accessible to the signed-in user, as configured in the user card under 'Companies: Access rights'. Accountants will only see divisions that belong to a single license (either their own or a client's), being the license that owns the division specified in the URI.Please note that divisions returned are only those which the user has granted permission to.Recommended alternative that is not limited to accessible divisions: /api/v1/{division}/system/AllDivisionsRecommended alternative that is not limited to a single license: /api/v1/{division}/system/Divisions
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
- Body
- DivisionsResponse
Get employment internal rates
Use this endpoint to retrieve internal rates of employees.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get hour cost types
This endpoint enables users to retrieve up to date active Hour and Cost types.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get hour entry activities by project
This endpoint enables users to retrieve a list of WBS Activities and its parent Deliverable based on the project ID provided.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
projectId
|
projectId | True | string |
The projectId. |
Returns
Get hour entry recent accounts
Use this endpoint to read a list of accounts that is used by an employee to create hour entries. The list is ordered by the most recently used first.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get hour entry recent accounts by project
This endpoint enables users to retrieve a list of Accounts used by an employee for hour entries based on the Project Id provided. The list is ordered by the most recently used first.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
projectId
|
projectId | True | string |
The projectId. |
Returns
Get hour entry recent hour types
Use this endpoint to read a list of items that is used by an employee to create hour entries. The list is ordered by the most recently used first.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get hour entry recent hour types by project
This endpoint enables users to retrieve a list of Items used by an employee for hour entries based on the Project Id provided. The list is ordered by the most recently used first.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
projectId
|
projectId | True | string |
The projectId. |
Returns
Get hour entry recent projects
Use this endpoint to read and retrieve projects that employees have used for entering hour entries order by most recently.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get hour types
This endpoint enables users to retrieve up to date active Hour types.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
- Body
- HourTypesResponse
Get hour types by date
This endpoint enables users to retrieve active Hour types based on date provided.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
checkDate
|
checkDate | True | date-time |
The checkDate. |
division
|
division | True | string |
The division |
Returns
Get hour types by project and date
Use this endpoint to read active hour types by providing project id and a reference check date.Note: Employee Id parameter is optional. Hour types listed will be based on a hierachy with project employee hour type restriction, project hour type restriction and employee restriction by providing this additional parameter. For this function to work correctly, you must supply all parameters.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
projectId
|
projectId | True | string |
The projectId. |
Returns
Get hours by date
Use this endpoint to read , filter and display all hour entries by employee based on the Date provided.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
checkDate
|
checkDate | True | date-time |
The checkDate. |
division
|
division | True | string |
The division |
Returns
- Body
- HoursByDateResponse
Get hours by id
This endpoint enables users to retrieve an hour entry's information for an employee.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
entryId
|
entryId | True | string |
The entryId. |
Returns
- Body
- HoursByIdResponse
Get me
This end point retrieves information about the current user.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
Returns
- Body
- MeResponse
Get project restriction rebillings
This endpoint enables users to restrict which cost types the project allows rebilling to customer.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get project time cost transactions
The TimeCostTransactions sync api returns both time and cost transactions. To filter out time or cost transactions you need to filter only on property Type. The API does not allow to filter on these fields. Filtering need to be done after receiving the records. The sync api's have the goal to keep the data between Exact Online and a 3rd party application the same. The sync api's are all based on row versioning and because of that it is guaranteed to be unique. Every time an existing record is changed or a new record is inserted, the row versioning value is higher than the highest available value at that time. When retrieving records via these api's also a timestamp value is returned. The highest timestamp value of the records returned should be stored on client side. Next time records are retrieved, the timestamp value stored on client side should be provided as parameter. The api will then return only the new and changed records. Using this method is more reliable than using modified date, since it can happen that multiple records have the same modified date and therefore same record can be returned more than once. This will not happen when using timestamp. The sync api's are also developed to give best performance when retrieving records. Because of performance and the intended purpose of the api's, only the timestamp field is allowed as parameter. The single and bulk api’s are designed for a different purpose. They provide ability to retrieve specific record or a set of records which meet certain conditions. In case the division is moved to another database in Exact Online the timestamp values will be reset. Therefore, after a division is moved all data needs to be synchronized again in order to get the new timestamp values. To see if a division was moved, the /api/v1/{division}/system/Divisions can be used. The property DivisionMoveDate indicated at which date a division was moved and this date can be used to determine if it is needed to synchronize all data again. The API has two important key fields, the Timestamp and the ID. The ID should be used to uniquely identify the record and will never change. The Timestamp is used to get new or changed records in an efficient way and will change for every change made to the record. The timestamp value returned has no relation with actual date or time. As such it cannot be converted to a date\time value. The timestamp is a rowversion value. When you use the sync or delete api for the first time for a particular division, filter on timestamp greater than 1.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get recent costs by number of weeks
Use this endpoint to read cost entries in the last specified number of ISO weeks.For time and billing project users to gather insight on the cost based on status by the user per week ordered by the most recent date, in turn aid in generate powerful reports.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
numberOfWeeks
|
numberOfWeeks | True | integer |
The numberOfWeeks. |
Returns
Get recent hours
This endpoint enables users to retrieve hour entries in the last 4 ISO weeks, including the current week. The list is ordered by most recent date first.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
- Body
- RecentHoursResponse
Get recent hours by number of weeks
Use this endpoint to read hour entries in the last specified number of ISO weeks.For time and billing project users to gather insight on the amount of hours based on status by the user per week ordered by the most recent date, in turn aid in generate powerful reports.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
numberOfWeeks
|
numberOfWeeks | True | integer |
The numberOfWeeks. |
Returns
Get time and billing account details
This endpoint enables users to retrieve the account details.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get time and billing account details byid
This endpoint enables users to retrieve the account details.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
accountId
|
accountId | True | string |
The accountId. |
division
|
division | True | string |
The division |
Returns
Get time and billing activities and expenses
Use this endpoint to retrieve a list of Activities, Expenses and its parent Deliverable.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get time and billing entry accounts
This endpoint enables users to retrieve currently active account details.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get time and billing entry accounts by date
This endpoint enables users to retrieve all accounts still active as of the date provided as the parameter.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
checkDate
|
checkDate | True | date-time |
The checkDate. |
division
|
division | True | string |
The division |
Returns
Get time and billing entry accounts by project and date
This endpoint enables users to retrieve the account related to the project ID as of the date provided as the parameters.For this function to work correctly, you must supply all parameters.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
projectId
|
projectId | True | string |
The projectId. |
Returns
Get time and billing entry projects
This endpoint enables users to retrieve project code and project description based on the project ID provided.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get time and billing entry projects by account and date
This endpoint enables users to retrieve a list of projects allowed for an employee based on the Account and Date provided.For this function to work correctly, you must supply all parameters.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
accountId
|
accountId | True | string |
The accountId. |
division
|
division | True | string |
The division |
Returns
Get time and billing entry projects by date
Use this endpoint to read a list of projects allowed for an employee based on the Date provided.Note: For getting the list, it is mandatory to supply check date.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
checkDate
|
checkDate | True | date-time |
The checkDate. |
division
|
division | True | string |
The division |
Returns
Get time and billing entry recent accounts
This endpoint enables users to retrieve a list of Accounts used by an employee for hour and cost entries. The list is ordered by the most recently used first.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get time and billing entry recent activities and expenses
This endpoint enables users to retrieve a list of Activites and Expenses together with its corresponding parent Deliverable used by an employee for hour and cost entries. The list is ordered by the most recently used first.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get time and billing entry recent hour cost types
This endpoint enables users to retrieve a list of Items used by an employee for hour and cost entries. The list is ordered by the most recently used first.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get time and billing entry recent projects
This endpoint enables users to retrieve a list of Projects used by an employee for hour and cost entries. The list is ordered by the most recently used first.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get time and billing item details
This endpoint enables users to retrieve a list of Items with details.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get time and billing item details byid
Use this endpoint to read an Item used in hour and cost entries with details based on the Item Id provided.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
itemId
|
itemId | True | string |
The itemId. |
Returns
Get time and billing project details
This endpoint enables users to retrieve a list of Projects with details.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get time and billing project details byid
Use this endpoint to read and retrieve time and billing project details based on the project ID provided.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
projectId
|
projectId | True | string |
The projectId. |
Returns
Get time and billing recent projects
This endpoint enables users to retrieve a list of Projects used by an employee for hour and cost entries. The list is ordered by the most recently used first.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get time corrections
Use this endpoint to create, read, update and delete time correction to correct final time entries that already invoiced.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Get time transactions
Use this endpoint to create, read, update and delete time transaction of the user.Note: For creating a time transactions, it is mandatory to supply item, project and the quantity of hour.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
filter
|
$filter | string |
An OData like filter string. |
|
select
|
$select | string |
A comma separated string of the properties you would like returned. |
|
skiptoken
|
$skiptoken | string |
A token allowing you to skip the first n items. |
|
top
|
$top | integer |
Only retrieve the first n items. |
|
division
|
division | True | string |
The division |
Returns
Update project restriction rebillings
This endpoint enables users to restrict which cost types the project allows rebilling to customer.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
division
|
division | True | string |
The division |
ID
|
ID | True | string |
Primary key |
ID
|
ID | string |
Primary key |
|
CostTypeRebill
|
CostTypeRebill | True | string |
Cost type reference |
CostTypeRebillCode
|
CostTypeRebillCode | string |
Cost type code |
|
CostTypeRebillDescription
|
CostTypeRebillDescription | string |
Cost type description |
|
Created
|
Created | date-time |
Date and time when the project restriction was created |
|
Creator
|
Creator | string |
ID of user that created the project restriction |
|
CreatorFullName
|
CreatorFullName | string |
Full name of user that created the project restriction |
|
Division
|
Division | integer |
Division of project and project restriction |
|
Modified
|
Modified | date-time |
Last date when the project restriction was modified |
|
Modifier
|
Modifier | string |
ID of user that modified the project restriction |
|
ModifierFullName
|
ModifierFullName | string |
Full name of user that modified the project restriction |
|
Project
|
Project | True | string |
Project ID that the restriction is referenced to |
ProjectCode
|
ProjectCode | string |
Project code that the restriction is referenced to |
|
ProjectDescription
|
ProjectDescription | string |
Project description that the restriction is referenced to |
Returns
Update time corrections
Use this endpoint to create, read, update and delete time correction to correct final time entries that already invoiced.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
division
|
division | True | string |
The division |
ID
|
ID | True | string |
Primary key |
ID
|
ID | string |
Primary key |
|
Created
|
Created | date-time |
Date and time when the time correction was created |
|
Creator
|
Creator | string |
ID of user that created the time correction |
|
CreatorFullName
|
CreatorFullName | string |
Full name of user that created the time correction |
|
Division
|
Division | integer |
Division code |
|
Modified
|
Modified | date-time |
Last modified date of time correction |
|
Modifier
|
Modifier | string |
ID of user that modified the time correction |
|
ModifierFullName
|
ModifierFullName | string |
Full name of user that modified the time correction |
|
Notes
|
Notes | string |
Notes of time correction for providing additional information |
|
OriginalEntryId
|
OriginalEntryId | string |
Reference to the time entry that this corrects for |
|
Quantity
|
Quantity | double |
Quantity has to be negative value. E.g.: If original quantity is 10 and the correct quantity is 4, this quantity is -6 |
Returns
Update time transactions
Use this endpoint to create, read, update and delete time transaction of the user.Note: For creating a time transactions, it is mandatory to supply item, project and the quantity of hour.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
division
|
division | True | string |
The division |
ID
|
ID | True | string |
Primary key |
ID
|
ID | string |
Primary key |
|
Account
|
Account | string |
Guid ID of account that is linked to the project |
|
AccountName
|
AccountName | string |
Name of account that is linked to the project |
|
Activity
|
Activity | string |
Guid ID of activity that is linked to project WBS (work breakdown structure) |
|
ActivityDescription
|
ActivityDescription | string |
Name of activity that is linked to project WBS (work breakdown structure) |
|
Amount
|
Amount | double |
This property is obsolete. Use property 'AmountFC' instead. |
|
AmountFC
|
AmountFC | double |
Calculated amount of the transaction based on (Quantity * PriceFC) |
|
Attachment
|
Attachment | string |
Attachment linked to the transaction (not mandatory) |
|
Created
|
Created | date-time |
Date and time the transaction was created |
|
Creator
|
Creator | string |
The Guid ID of user that created the transaction |
|
CreatorFullName
|
CreatorFullName | string |
The full name of the user that created the record |
|
Currency
|
Currency | string |
Currency of amount FC |
|
Date
|
Date | date-time |
Date and time the time transaction was done |
|
Division
|
Division | integer |
Division code |
|
DivisionDescription
|
DivisionDescription | string |
Description of Division |
|
Employee
|
Employee | string |
Guid ID of the employee that is linked to the time transaction |
|
EndTime
|
EndTime | date-time |
End time of the time transaction |
|
EntryNumber
|
EntryNumber | integer |
Number that represents the grouping of time transactions |
|
ErrorText
|
ErrorText | string |
(Only used by backgroundjobs) To determine which transaction has an error |
|
HourStatus
|
HourStatus | float |
Status of the transaction: 1 = Draft, 2 = Rejected, 10 = Submitted, 11 = Failed on approval, 14 = Processing, 16 = Processing, 19 = Failed while undoing approval, 20 = Final |
|
Item
|
Item | True | string |
Item that is linked to the transaction, which provides the time information |
ItemDescription
|
ItemDescription | string |
Description of the item that is linked to the transaction |
|
ItemDivisable
|
ItemDivisable | boolean |
Indicates if fractional quantities of the item can be used, for example quantity = 0.4 |
|
Modified
|
Modified | date-time |
The date and time transaction record was modified |
|
Modifier
|
Modifier | string |
The Guid ID of the user that modified the records |
|
ModifierFullName
|
ModifierFullName | string |
The full name of the user that modified the record |
|
Notes
|
Notes | string |
Notes linked to the transaction for providing additional information (not mandatory) |
|
Price
|
Price | double |
This property is obsolete. Use property 'PriceFC' instead. |
|
PriceFC
|
PriceFC | double |
For use in AmountFC (Quantiy * Price FC) |
|
Project
|
Project | True | string |
Guid ID of project that is linked to the transaction |
ProjectAccount
|
ProjectAccount | string |
Project account ID that is linked to the transaction (not mandatory) |
|
ProjectAccountCode
|
ProjectAccountCode | string |
Project account code that is linked to the transaction |
|
ProjectAccountName
|
ProjectAccountName | string |
Project account name that is linked to the transaction |
|
ProjectCode
|
ProjectCode | string |
Project code that is linked to the transaction |
|
ProjectDescription
|
ProjectDescription | string |
Project description that is linked to the transaction |
|
Quantity
|
Quantity | True | double |
Quantity of the item that is linked to the transaction |
SkipValidation
|
SkipValidation | boolean |
Skip validation |
|
StartTime
|
StartTime | date-time |
Start time of the time transaction |
|
Subscription
|
Subscription | string |
Guid ID of subscription that is linked to the transaction |
|
SubscriptionAccount
|
SubscriptionAccount | string |
Subscription account ID that is linked to the transaction, this is to identify the referenced subscription |
|
SubscriptionAccountCode
|
SubscriptionAccountCode | string |
Subscription account code that is linked to the transaction |
|
SubscriptionAccountName
|
SubscriptionAccountName | string |
Subscription account name that is linked to the transaction |
|
SubscriptionDescription
|
SubscriptionDescription | string |
Subscription description that is linked to the transaction |
|
SubscriptionNumber
|
SubscriptionNumber | integer |
Subscription number that is linked to the transaction |
|
Type
|
Type | float |
The type of transaction. E.g: 1 = Time, 2 = Cost |
Returns
Definitions
DivisionsResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | DivisionsArray |
DivisionsArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of Divisions |
Divisions
Name | Path | Type | Description |
---|---|---|---|
Code
|
Code | integer |
Primary key |
ArchiveDate
|
ArchiveDate | date-time |
Date on which the division is archived |
BlockingStatus
|
BlockingStatus | integer |
Values: 0 = Not blocked, 1 = Backup/restore, 2 = Conversion busy, 3 = Conversion shadow, 4 = Conversion waiting, 5 = Copy data waiting, 6 = Copy data busy |
Country
|
Country | string |
Country of the division. Is used for determination of legislation |
CountryDescription
|
CountryDescription | string |
Description of Country |
Created
|
Created | date-time |
Creation date |
Creator
|
Creator | string |
User ID of creator |
CreatorFullName
|
CreatorFullName | string |
Name of the creator |
Currency
|
Currency | string |
Default currency of the division |
CurrencyDescription
|
CurrencyDescription | string |
Description of Currency |
Customer
|
Customer | string |
Owner account of the division |
CustomerCode
|
CustomerCode | string |
Owner account code of the division |
CustomerName
|
CustomerName | string |
Owner account name of the division |
Description
|
Description | string |
Description |
HID
|
HID | string |
Number that customers give to the division |
Main
|
Main | boolean |
True for the main (hosting) division |
Modified
|
Modified | date-time |
Last modified date |
Modifier
|
Modifier | string |
User ID of modifier |
ModifierFullName
|
ModifierFullName | string |
Name of the last modifier |
OBNumber
|
OBNumber | string |
The soletrader VAT number used for offical returns to tax authority |
SiretNumber
|
SiretNumber | string |
Siret Number of the division (France) |
StartDate
|
StartDate | date-time |
Date on which the division becomes active |
Status
|
Status | float |
Regular administrations will have status 0. Currently, the only other possibility is 'archived' (1), which means the administration is not actively used, but still needs to be accessible for the customer/accountant to meet legal obligations |
TaxOfficeNumber
|
TaxOfficeNumber | string |
Number of your local tax authority (Germany) |
TaxReferenceNumber
|
TaxReferenceNumber | string |
Local tax reference number (Germany) |
TemplateCode
|
TemplateCode | string |
Division template code |
VATNumber
|
VATNumber | string |
VAT number |
Website
|
Website | string |
Customer value, hyperlink to external website |
EmploymentInternalRatesResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | EmploymentInternalRatesArray |
EmploymentInternalRatesArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of EmploymentInternalRates |
EmploymentInternalRates
Name | Path | Type | Description |
---|---|---|---|
ID
|
ID | string |
ID of internal rate |
Created
|
Created | date-time |
Date and time when the internal rates was created |
Creator
|
Creator | string |
ID of user that created the internal rate |
CreatorFullName
|
CreatorFullName | string |
Full name of user that created the record |
Division
|
Division | integer |
Division code |
Employee
|
Employee | string |
ID of employee that linked to the internal rate |
EmployeeFullName
|
EmployeeFullName | string |
Name of employee that linked to the internal rate |
EmployeeHID
|
EmployeeHID | integer |
Employee number that linked to the internal rate |
Employment
|
Employment | string |
ID of employment that linked to the internal rate |
EmploymentHID
|
EmploymentHID | integer |
Employement number that linked to the internal rate |
EndDate
|
EndDate | date-time |
End date of internal rate |
IntercompanyRate
|
IntercompanyRate | double |
Amount of intercompany rate |
InternalRate
|
InternalRate | double |
Amount of internal rate |
Modified
|
Modified | date-time |
Last modified date of internal rate |
Modifier
|
Modifier | string |
ID of user that modified the internal rate |
ModifierFullName
|
ModifierFullName | string |
Full name of user that modified the internal rate |
StartDate
|
StartDate | date-time |
Start date of internal rate |
HourCostTypesResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | HourCostTypesArray |
HourCostTypesArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of HourCostTypes |
HourCostTypes
Name | Path | Type | Description |
---|---|---|---|
ItemId
|
ItemId | string |
GUID id of the item that is linked to the project |
ItemDescription
|
ItemDescription | string |
Description of the item that is linked to the project |
HourEntryActivitiesByProjectResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | HourEntryActivitiesByProjectArray |
HourEntryActivitiesByProjectArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of HourEntryActivitiesByProject |
HourEntryActivitiesByProject
Name | Path | Type | Description |
---|---|---|---|
ID
|
ID | string |
ID of activity or expense |
Description
|
Description | string |
Description of activity or expense |
ParentDescription
|
ParentDescription | string |
Description of its parent |
HourEntryRecentAccountsResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | HourEntryRecentAccountsArray |
HourEntryRecentAccountsArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of HourEntryRecentAccounts |
HourEntryRecentAccounts
Name | Path | Type | Description |
---|---|---|---|
AccountId
|
AccountId | string |
Guid ID of the account used for hour entries |
AccountName
|
AccountName | string |
Name of account |
DateLastUsed
|
DateLastUsed | date-time |
The last date that the account has been used for hour entry |
HourEntryRecentAccountsByProjectResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | HourEntryRecentAccountsByProjectArray |
HourEntryRecentAccountsByProjectArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of HourEntryRecentAccountsByProject |
HourEntryRecentAccountsByProject
Name | Path | Type | Description |
---|---|---|---|
AccountId
|
AccountId | string |
Guid ID of the account used for hour entries |
AccountName
|
AccountName | string |
Name of account |
DateLastUsed
|
DateLastUsed | date-time |
The last date that the account has been used for hour entry |
HourEntryRecentHourTypesResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | HourEntryRecentHourTypesArray |
HourEntryRecentHourTypesArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of HourEntryRecentHourTypes |
HourEntryRecentHourTypes
Name | Path | Type | Description |
---|---|---|---|
ItemId
|
ItemId | string |
Guid ID of the item used for hour entries |
DateLastUsed
|
DateLastUsed | date-time |
The last date that the item has been used for hour entry |
ItemDescription
|
ItemDescription | string |
Description of item |
HourEntryRecentHourTypesByProjectResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | HourEntryRecentHourTypesByProjectArray |
HourEntryRecentHourTypesByProjectArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of HourEntryRecentHourTypesByProject |
HourEntryRecentHourTypesByProject
Name | Path | Type | Description |
---|---|---|---|
ItemId
|
ItemId | string |
Guid ID of the item used for hour entries |
DateLastUsed
|
DateLastUsed | date-time |
The last date that the item has been used for hour entry |
ItemDescription
|
ItemDescription | string |
Description of item |
HourEntryRecentProjectsResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | HourEntryRecentProjectsArray |
HourEntryRecentProjectsArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of HourEntryRecentProjects |
HourEntryRecentProjects
Name | Path | Type | Description |
---|---|---|---|
ProjectId
|
ProjectId | string |
The Id of the project that hours entries are entered |
DateLastUsed
|
DateLastUsed | date-time |
The datetime the hour entries have been entered on the project |
ProjectCode
|
ProjectCode | string |
The code of the project that the hour entries have been entered on |
ProjectDescription
|
ProjectDescription | string |
The description of the project that the hour entries have been entered on |
HoursByDateResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | HoursByDateArray |
HoursByDateArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of HoursByDate |
HoursByDate
Name | Path | Type | Description |
---|---|---|---|
Id
|
Id | integer |
Primary key |
AccountCode
|
AccountCode | string |
Code of account linked to the project that hours are being entered to |
AccountId
|
AccountId | string |
ID of account linked to the project that hours are being entered to |
AccountName
|
AccountName | string |
Name of account linked to the project that hours are being entered to |
Activity
|
Activity | string |
The activity of the project that the hours are entered to |
ActivityDescription
|
ActivityDescription | string |
Name of activity of the project that the hours are entered to |
Date
|
Date | date-time |
Date of hour entry record by week |
EntryId
|
EntryId | string |
Entry ID of record |
HoursApproved
|
HoursApproved | double |
Hours approved |
HoursApprovedBillable
|
HoursApprovedBillable | double |
Billable hours that is approved |
HoursDraft
|
HoursDraft | double |
Hours saved as draft |
HoursDraftBillable
|
HoursDraftBillable | double |
Billable hours saved as draft |
HoursRejected
|
HoursRejected | double |
Hours that are rejected |
HoursRejectedBillable
|
HoursRejectedBillable | double |
Billable hours that are rejected |
HoursSubmitted
|
HoursSubmitted | double |
Hours that are submitted |
HoursSubmittedBillable
|
HoursSubmittedBillable | double |
Billable hours that are submitted |
ItemCode
|
ItemCode | string |
Code of the item that is used for hours |
ItemDescription
|
ItemDescription | string |
Description of the item that is used for hours |
ItemId
|
ItemId | string |
ID of the item that is used for hours |
Notes
|
Notes | string |
Notes entered regarding the information of the hours entered |
ProjectCode
|
ProjectCode | string |
Code of project that the hours are entered on |
ProjectDescription
|
ProjectDescription | string |
Description of project that the hours are entered on |
ProjectId
|
ProjectId | string |
ID of project that the hours are entered on |
WeekNumber
|
WeekNumber | integer |
The week number that the hours are entered on |
HoursByIdResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | HoursByIdArray |
HoursByIdArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of HoursById |
HoursById
Name | Path | Type | Description |
---|---|---|---|
Id
|
Id | integer |
Primary key |
AccountCode
|
AccountCode | string |
Code of account linked to the project that hours are being entered to |
AccountId
|
AccountId | string |
ID of account linked to the project that hours are being entered to |
AccountName
|
AccountName | string |
Name of account linked to the project that hours are being entered to |
Activity
|
Activity | string |
The activity of the project that the hours are entered to |
ActivityDescription
|
ActivityDescription | string |
Name of activity of the project that the hours are entered to |
Date
|
Date | date-time |
Date of hour entry record by week |
EntryId
|
EntryId | string |
Entry ID of record |
HoursApproved
|
HoursApproved | double |
Hours approved |
HoursApprovedBillable
|
HoursApprovedBillable | double |
Billable hours that is approved |
HoursDraft
|
HoursDraft | double |
Hours saved as draft |
HoursDraftBillable
|
HoursDraftBillable | double |
Billable hours saved as draft |
HoursRejected
|
HoursRejected | double |
Hours that are rejected |
HoursRejectedBillable
|
HoursRejectedBillable | double |
Billable hours that are rejected |
HoursSubmitted
|
HoursSubmitted | double |
Hours that are submitted |
HoursSubmittedBillable
|
HoursSubmittedBillable | double |
Billable hours that are submitted |
ItemCode
|
ItemCode | string |
Code of the item that is used for hours |
ItemDescription
|
ItemDescription | string |
Description of the item that is used for hours |
ItemId
|
ItemId | string |
ID of the item that is used for hours |
Notes
|
Notes | string |
Notes entered regarding the information of the hours entered |
ProjectCode
|
ProjectCode | string |
Code of project that the hours are entered on |
ProjectDescription
|
ProjectDescription | string |
Description of project that the hours are entered on |
ProjectId
|
ProjectId | string |
ID of project that the hours are entered on |
WeekNumber
|
WeekNumber | integer |
The week number that the hours are entered on |
HourTypesResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | HourTypesArray |
HourTypesArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of HourTypes |
HourTypes
Name | Path | Type | Description |
---|---|---|---|
ItemId
|
ItemId | string |
GUID id of the item that is linked to the project |
ItemDescription
|
ItemDescription | string |
Description of the item that is linked to the project |
HourTypesByDateResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | HourTypesByDateArray |
HourTypesByDateArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of HourTypesByDate |
HourTypesByDate
Name | Path | Type | Description |
---|---|---|---|
ItemId
|
ItemId | string |
GUID id of the item that is linked to the project |
ItemDescription
|
ItemDescription | string |
Description of the item that is linked to the project |
HourTypesByProjectAndDateResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | HourTypesByProjectAndDateArray |
HourTypesByProjectAndDateArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of HourTypesByProjectAndDate |
HourTypesByProjectAndDate
Name | Path | Type | Description |
---|---|---|---|
ItemId
|
ItemId | string |
GUID id of the item that is linked to the project |
ItemDescription
|
ItemDescription | string |
Description of the item that is linked to the project |
ProjectRestrictionRebillingsResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | ProjectRestrictionRebillingsArray |
ProjectRestrictionRebillingsArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of ProjectRestrictionRebillings |
ProjectRestrictionRebillings
Name | Path | Type | Description |
---|---|---|---|
ID
|
ID | string |
Primary key |
CostTypeRebill
|
CostTypeRebill | string |
Cost type reference |
CostTypeRebillCode
|
CostTypeRebillCode | string |
Cost type code |
CostTypeRebillDescription
|
CostTypeRebillDescription | string |
Cost type description |
Created
|
Created | date-time |
Date and time when the project restriction was created |
Creator
|
Creator | string |
ID of user that created the project restriction |
CreatorFullName
|
CreatorFullName | string |
Full name of user that created the project restriction |
Division
|
Division | integer |
Division of project and project restriction |
Modified
|
Modified | date-time |
Last date when the project restriction was modified |
Modifier
|
Modifier | string |
ID of user that modified the project restriction |
ModifierFullName
|
ModifierFullName | string |
Full name of user that modified the project restriction |
Project
|
Project | string |
Project ID that the restriction is referenced to |
ProjectCode
|
ProjectCode | string |
Project code that the restriction is referenced to |
ProjectDescription
|
ProjectDescription | string |
Project description that the restriction is referenced to |
RecentCostsByNumberOfWeeksResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | RecentCostsByNumberOfWeeksArray |
RecentCostsByNumberOfWeeksArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of RecentCostsByNumberOfWeeks |
RecentCostsByNumberOfWeeks
Name | Path | Type | Description |
---|---|---|---|
Id
|
Id | integer |
Primary key |
AccountCode
|
AccountCode | string |
Code of account linked to the project that hours are being entered to |
AccountId
|
AccountId | string |
ID of account linked to the project that hours are being entered to |
AccountName
|
AccountName | string |
Name of account linked to the project that hours are being entered to |
AmountApproved
|
AmountApproved | double |
The total amount of (Quantity * Sales price of cost item) that has been approved |
AmountDraft
|
AmountDraft | double |
The total amount of (Quantity * Sales price of cost item) that has been saved as draft |
AmountRejected
|
AmountRejected | double |
The total amount of (Quantity * Sales price of cost item) that has been rejected |
AmountSubmitted
|
AmountSubmitted | double |
The total amount of (Quantity * Sales price of cost item) that has been submitted |
CurrencyCode
|
CurrencyCode | string |
Code of sales currency which is used in the cost item |
Date
|
Date | date-time |
Date of entry |
EntryId
|
EntryId | string |
Entry ID of record |
Expense
|
Expense | string |
The ID of the Expense that is linked to the project |
ExpenseDescription
|
ExpenseDescription | string |
The description of the Expense that is linked to the project |
ItemCode
|
ItemCode | string |
Code of the item used for cost entry |
ItemDescription
|
ItemDescription | string |
Description of the item used for cost entry |
ItemId
|
ItemId | string |
ID of the item used for cost entry |
Notes
|
Notes | string |
Notes entered regarding the information of the cost entered |
ProjectCode
|
ProjectCode | string |
Code of project that the costs are entered on |
ProjectDescription
|
ProjectDescription | string |
Description of project that the costs are entered on |
ProjectId
|
ProjectId | string |
ID of project that the costs are entered on |
QuantityApproved
|
QuantityApproved | double |
Quantity of items that is used in cost entry that are approved |
QuantityDraft
|
QuantityDraft | double |
Quantity of items that is used in cost entry that are saved as draft |
QuantityRejected
|
QuantityRejected | double |
Quantity of items that is used in cost entry that are rejected |
QuantitySubmitted
|
QuantitySubmitted | double |
Quantity of items that is used in cost entry that are submitted |
WeekNumber
|
WeekNumber | integer |
The week number that the cost entries have been entered on |
RecentHoursResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | RecentHoursArray |
RecentHoursArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of RecentHours |
RecentHours
Name | Path | Type | Description |
---|---|---|---|
Id
|
Id | integer |
Primary key |
AccountCode
|
AccountCode | string |
Code of account linked to the project that hours are being entered to |
AccountId
|
AccountId | string |
ID of account linked to the project that hours are being entered to |
AccountName
|
AccountName | string |
Name of account linked to the project that hours are being entered to |
Activity
|
Activity | string |
The activity of the project that the hours are entered to |
ActivityDescription
|
ActivityDescription | string |
Name of activity of the project that the hours are entered to |
Date
|
Date | date-time |
Date of hour entry record by week |
EntryId
|
EntryId | string |
Entry ID of record |
HoursApproved
|
HoursApproved | double |
Hours approved |
HoursApprovedBillable
|
HoursApprovedBillable | double |
Billable hours that is approved |
HoursDraft
|
HoursDraft | double |
Hours saved as draft |
HoursDraftBillable
|
HoursDraftBillable | double |
Billable hours saved as draft |
HoursRejected
|
HoursRejected | double |
Hours that are rejected |
HoursRejectedBillable
|
HoursRejectedBillable | double |
Billable hours that are rejected |
HoursSubmitted
|
HoursSubmitted | double |
Hours that are submitted |
HoursSubmittedBillable
|
HoursSubmittedBillable | double |
Billable hours that are submitted |
ItemCode
|
ItemCode | string |
Code of the item that is used for hours |
ItemDescription
|
ItemDescription | string |
Description of the item that is used for hours |
ItemId
|
ItemId | string |
ID of the item that is used for hours |
Notes
|
Notes | string |
Notes entered regarding the information of the hours entered |
ProjectCode
|
ProjectCode | string |
Code of project that the hours are entered on |
ProjectDescription
|
ProjectDescription | string |
Description of project that the hours are entered on |
ProjectId
|
ProjectId | string |
ID of project that the hours are entered on |
WeekNumber
|
WeekNumber | integer |
The week number that the hours are entered on |
RecentHoursByNumberOfWeeksResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | RecentHoursByNumberOfWeeksArray |
RecentHoursByNumberOfWeeksArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of RecentHoursByNumberOfWeeks |
RecentHoursByNumberOfWeeks
Name | Path | Type | Description |
---|---|---|---|
Id
|
Id | integer |
Primary key |
AccountCode
|
AccountCode | string |
Code of account linked to the project that hours are being entered to |
AccountId
|
AccountId | string |
ID of account linked to the project that hours are being entered to |
AccountName
|
AccountName | string |
Name of account linked to the project that hours are being entered to |
Activity
|
Activity | string |
The activity of the project that the hours are entered to |
ActivityDescription
|
ActivityDescription | string |
Name of activity of the project that the hours are entered to |
Date
|
Date | date-time |
Date of hour entry record by week |
EntryId
|
EntryId | string |
Entry ID of record |
HoursApproved
|
HoursApproved | double |
Hours approved |
HoursApprovedBillable
|
HoursApprovedBillable | double |
Billable hours that is approved |
HoursDraft
|
HoursDraft | double |
Hours saved as draft |
HoursDraftBillable
|
HoursDraftBillable | double |
Billable hours saved as draft |
HoursRejected
|
HoursRejected | double |
Hours that are rejected |
HoursRejectedBillable
|
HoursRejectedBillable | double |
Billable hours that are rejected |
HoursSubmitted
|
HoursSubmitted | double |
Hours that are submitted |
HoursSubmittedBillable
|
HoursSubmittedBillable | double |
Billable hours that are submitted |
ItemCode
|
ItemCode | string |
Code of the item that is used for hours |
ItemDescription
|
ItemDescription | string |
Description of the item that is used for hours |
ItemId
|
ItemId | string |
ID of the item that is used for hours |
Notes
|
Notes | string |
Notes entered regarding the information of the hours entered |
ProjectCode
|
ProjectCode | string |
Code of project that the hours are entered on |
ProjectDescription
|
ProjectDescription | string |
Description of project that the hours are entered on |
ProjectId
|
ProjectId | string |
ID of project that the hours are entered on |
WeekNumber
|
WeekNumber | integer |
The week number that the hours are entered on |
TimeAndBillingAccountDetailsResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingAccountDetailsArray |
TimeAndBillingAccountDetailsArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingAccountDetails |
TimeAndBillingAccountDetails
Name | Path | Type | Description |
---|---|---|---|
ID
|
ID | string |
Primary key |
Name
|
Name | string |
Name |
TimeAndBillingAccountDetailsByIDResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingAccountDetailsByIDArray |
TimeAndBillingAccountDetailsByIDArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingAccountDetailsByID |
TimeAndBillingAccountDetailsByID
Name | Path | Type | Description |
---|---|---|---|
ID
|
ID | string |
Primary key |
Name
|
Name | string |
Name |
TimeAndBillingActivitiesAndExpensesResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingActivitiesAndExpensesArray |
TimeAndBillingActivitiesAndExpensesArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingActivitiesAndExpenses |
TimeAndBillingActivitiesAndExpenses
Name | Path | Type | Description |
---|---|---|---|
ID
|
ID | string |
ID of activity or expense |
Description
|
Description | string |
Description of activity or expense |
ParentDescription
|
ParentDescription | string |
Description of its parent |
TimeAndBillingEntryAccountsResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingEntryAccountsArray |
TimeAndBillingEntryAccountsArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingEntryAccounts |
TimeAndBillingEntryAccounts
Name | Path | Type | Description |
---|---|---|---|
AccountId
|
AccountId | string |
ID of account used for entries |
AccountName
|
AccountName | string |
Name of account |
TimeAndBillingEntryAccountsByDateResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingEntryAccountsByDateArray |
TimeAndBillingEntryAccountsByDateArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingEntryAccountsByDate |
TimeAndBillingEntryAccountsByDate
Name | Path | Type | Description |
---|---|---|---|
AccountId
|
AccountId | string |
ID of account used for entries |
AccountName
|
AccountName | string |
Name of account |
TimeAndBillingEntryAccountsByProjectAndDateResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingEntryAccountsByProjectAndDateArray |
TimeAndBillingEntryAccountsByProjectAndDateArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingEntryAccountsByProjectAndDate |
TimeAndBillingEntryAccountsByProjectAndDate
Name | Path | Type | Description |
---|---|---|---|
AccountId
|
AccountId | string |
ID of account used for entries |
AccountName
|
AccountName | string |
Name of account |
TimeAndBillingEntryProjectsResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingEntryProjectsArray |
TimeAndBillingEntryProjectsArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingEntryProjects |
TimeAndBillingEntryProjects
Name | Path | Type | Description |
---|---|---|---|
ProjectId
|
ProjectId | string |
GUID id of the project |
ProjectCode
|
ProjectCode | string |
Code of the project |
ProjectDescription
|
ProjectDescription | string |
Description of the project |
TimeAndBillingEntryProjectsByAccountAndDateResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingEntryProjectsByAccountAndDateArray |
TimeAndBillingEntryProjectsByAccountAndDateArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingEntryProjectsByAccountAndDate |
TimeAndBillingEntryProjectsByAccountAndDate
Name | Path | Type | Description |
---|---|---|---|
ProjectId
|
ProjectId | string |
GUID id of the project |
ProjectCode
|
ProjectCode | string |
Code of the project |
ProjectDescription
|
ProjectDescription | string |
Description of the project |
TimeAndBillingEntryProjectsByDateResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingEntryProjectsByDateArray |
TimeAndBillingEntryProjectsByDateArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingEntryProjectsByDate |
TimeAndBillingEntryProjectsByDate
Name | Path | Type | Description |
---|---|---|---|
ProjectId
|
ProjectId | string |
GUID id of the project |
ProjectCode
|
ProjectCode | string |
Code of the project |
ProjectDescription
|
ProjectDescription | string |
Description of the project |
TimeAndBillingEntryRecentAccountsResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingEntryRecentAccountsArray |
TimeAndBillingEntryRecentAccountsArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingEntryRecentAccounts |
TimeAndBillingEntryRecentAccounts
Name | Path | Type | Description |
---|---|---|---|
AccountId
|
AccountId | string |
Guid ID of the account used for hour entries |
AccountName
|
AccountName | string |
Name of account |
DateLastUsed
|
DateLastUsed | date-time |
The last date that the account has been used for hour entry |
TimeAndBillingEntryRecentActivitiesAndExpensesResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingEntryRecentActivitiesAndExpensesArray |
TimeAndBillingEntryRecentActivitiesAndExpensesArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingEntryRecentActivitiesAndExpenses |
TimeAndBillingEntryRecentActivitiesAndExpenses
Name | Path | Type | Description |
---|---|---|---|
ID
|
ID | string |
Primary key |
DateLastUsed
|
DateLastUsed | date-time |
Date last used |
Description
|
Description | string |
Description |
ParentDescription
|
ParentDescription | string |
Description of Parent |
TimeAndBillingEntryRecentHourCostTypesResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingEntryRecentHourCostTypesArray |
TimeAndBillingEntryRecentHourCostTypesArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingEntryRecentHourCostTypes |
TimeAndBillingEntryRecentHourCostTypes
Name | Path | Type | Description |
---|---|---|---|
ItemId
|
ItemId | string |
Guid ID of the item used for hour entries |
DateLastUsed
|
DateLastUsed | date-time |
The last date that the item has been used for hour entry |
ItemDescription
|
ItemDescription | string |
Description of item |
TimeAndBillingEntryRecentProjectsResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingEntryRecentProjectsArray |
TimeAndBillingEntryRecentProjectsArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingEntryRecentProjects |
TimeAndBillingEntryRecentProjects
Name | Path | Type | Description |
---|---|---|---|
ProjectId
|
ProjectId | string |
The Id of the project that hours entries are entered |
DateLastUsed
|
DateLastUsed | date-time |
The datetime the hour entries have been entered on the project |
ProjectCode
|
ProjectCode | string |
The code of the project that the hour entries have been entered on |
ProjectDescription
|
ProjectDescription | string |
The description of the project that the hour entries have been entered on |
TimeAndBillingItemDetailsResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingItemDetailsArray |
TimeAndBillingItemDetailsArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingItemDetails |
TimeAndBillingItemDetails
Name | Path | Type | Description |
---|---|---|---|
ID
|
ID | string |
Primary key |
Code
|
Code | string |
The code of the item used in time and billing projects |
Description
|
Description | string |
The description of the item used in time and billing projects |
IsFractionAllowedItem
|
IsFractionAllowedItem | boolean |
A boolean field to indicated if this item's quantity is allowed to be used in fraction's, which changes the calculation of the total amount invoiced |
IsSalesItem
|
IsSalesItem | boolean |
A boolean field to indicated if this item is enabled to be used in a invoice proposal |
SalesCurrency
|
SalesCurrency | string |
The code of the sales currency used in this item |
SalesPrice
|
SalesPrice | double |
Sales price of the item which is used when processing sales invoice |
TimeAndBillingItemDetailsByIDResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingItemDetailsByIDArray |
TimeAndBillingItemDetailsByIDArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingItemDetailsByID |
TimeAndBillingItemDetailsByID
Name | Path | Type | Description |
---|---|---|---|
ID
|
ID | string |
Primary key |
Code
|
Code | string |
The code of the item used in time and billing projects |
Description
|
Description | string |
The description of the item used in time and billing projects |
IsFractionAllowedItem
|
IsFractionAllowedItem | boolean |
A boolean field to indicated if this item's quantity is allowed to be used in fraction's, which changes the calculation of the total amount invoiced |
IsSalesItem
|
IsSalesItem | boolean |
A boolean field to indicated if this item is enabled to be used in a invoice proposal |
SalesCurrency
|
SalesCurrency | string |
The code of the sales currency used in this item |
SalesPrice
|
SalesPrice | double |
Sales price of the item which is used when processing sales invoice |
TimeAndBillingProjectDetailsResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingProjectDetailsArray |
TimeAndBillingProjectDetailsArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingProjectDetails |
TimeAndBillingProjectDetails
Name | Path | Type | Description |
---|---|---|---|
ID
|
ID | string |
Primary key |
Account
|
Account | string |
The ID of the account that the project is linked to |
AccountName
|
AccountName | string |
The name of the account that the project is linked to |
Code
|
Code | string |
The code of the account that the project is linked to |
Description
|
Description | string |
The description of the account that project is linked to |
Type
|
Type | integer |
The project type. E.g: 1 = Campaign, 2 = Fixed Price, 3 = Time and Material, 4 = Non Billable, 5 = Prepaid |
TimeAndBillingProjectDetailsByIDResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingProjectDetailsByIDArray |
TimeAndBillingProjectDetailsByIDArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingProjectDetailsByID |
TimeAndBillingProjectDetailsByID
Name | Path | Type | Description |
---|---|---|---|
ID
|
ID | string |
Primary key |
Account
|
Account | string |
The ID of the account that the project is linked to |
AccountName
|
AccountName | string |
The name of the account that the project is linked to |
Code
|
Code | string |
The code of the account that the project is linked to |
Description
|
Description | string |
The description of the account that project is linked to |
Type
|
Type | integer |
The project type. E.g: 1 = Campaign, 2 = Fixed Price, 3 = Time and Material, 4 = Non Billable, 5 = Prepaid |
TimeAndBillingRecentProjectsResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeAndBillingRecentProjectsArray |
TimeAndBillingRecentProjectsArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeAndBillingRecentProjects |
TimeAndBillingRecentProjects
Name | Path | Type | Description |
---|---|---|---|
ProjectId
|
ProjectId | string |
The Id of the project that hours entries are entered |
DateLastUsed
|
DateLastUsed | date-time |
The datetime the hour entries have been entered on the project |
ProjectCode
|
ProjectCode | string |
The code of the project that the hour entries have been entered on |
ProjectDescription
|
ProjectDescription | string |
The description of the project that the hour entries have been entered on |
TimeCorrectionsResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeCorrectionsArray |
TimeCorrectionsArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeCorrections |
TimeCorrections
Name | Path | Type | Description |
---|---|---|---|
ID
|
ID | string |
Primary key |
Created
|
Created | date-time |
Date and time when the time correction was created |
Creator
|
Creator | string |
ID of user that created the time correction |
CreatorFullName
|
CreatorFullName | string |
Full name of user that created the time correction |
Division
|
Division | integer |
Division code |
Modified
|
Modified | date-time |
Last modified date of time correction |
Modifier
|
Modifier | string |
ID of user that modified the time correction |
ModifierFullName
|
ModifierFullName | string |
Full name of user that modified the time correction |
Notes
|
Notes | string |
Notes of time correction for providing additional information |
OriginalEntryId
|
OriginalEntryId | string |
Reference to the time entry that this corrects for |
Quantity
|
Quantity | double |
Quantity has to be negative value. E.g.: If original quantity is 10 and the correct quantity is 4, this quantity is -6 |
TimeTransactionsResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | TimeTransactionsArray |
TimeTransactionsArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of TimeTransactions |
TimeTransactions
Name | Path | Type | Description |
---|---|---|---|
ID
|
ID | string |
Primary key |
Account
|
Account | string |
Guid ID of account that is linked to the project |
AccountName
|
AccountName | string |
Name of account that is linked to the project |
Activity
|
Activity | string |
Guid ID of activity that is linked to project WBS (work breakdown structure) |
ActivityDescription
|
ActivityDescription | string |
Name of activity that is linked to project WBS (work breakdown structure) |
Amount
|
Amount | double |
This property is obsolete. Use property 'AmountFC' instead. |
AmountFC
|
AmountFC | double |
Calculated amount of the transaction based on (Quantity * PriceFC) |
Attachment
|
Attachment | string |
Attachment linked to the transaction (not mandatory) |
Created
|
Created | date-time |
Date and time the transaction was created |
Creator
|
Creator | string |
The Guid ID of user that created the transaction |
CreatorFullName
|
CreatorFullName | string |
The full name of the user that created the record |
Currency
|
Currency | string |
Currency of amount FC |
Date
|
Date | date-time |
Date and time the time transaction was done |
Division
|
Division | integer |
Division code |
DivisionDescription
|
DivisionDescription | string |
Description of Division |
Employee
|
Employee | string |
Guid ID of the employee that is linked to the time transaction |
EndTime
|
EndTime | date-time |
End time of the time transaction |
EntryNumber
|
EntryNumber | integer |
Number that represents the grouping of time transactions |
ErrorText
|
ErrorText | string |
(Only used by backgroundjobs) To determine which transaction has an error |
HourStatus
|
HourStatus | float |
Status of the transaction: 1 = Draft, 2 = Rejected, 10 = Submitted, 11 = Failed on approval, 14 = Processing, 16 = Processing, 19 = Failed while undoing approval, 20 = Final |
Item
|
Item | string |
Item that is linked to the transaction, which provides the time information |
ItemDescription
|
ItemDescription | string |
Description of the item that is linked to the transaction |
ItemDivisable
|
ItemDivisable | boolean |
Indicates if fractional quantities of the item can be used, for example quantity = 0.4 |
Modified
|
Modified | date-time |
The date and time transaction record was modified |
Modifier
|
Modifier | string |
The Guid ID of the user that modified the records |
ModifierFullName
|
ModifierFullName | string |
The full name of the user that modified the record |
Notes
|
Notes | string |
Notes linked to the transaction for providing additional information (not mandatory) |
Price
|
Price | double |
This property is obsolete. Use property 'PriceFC' instead. |
PriceFC
|
PriceFC | double |
For use in AmountFC (Quantiy * Price FC) |
Project
|
Project | string |
Guid ID of project that is linked to the transaction |
ProjectAccount
|
ProjectAccount | string |
Project account ID that is linked to the transaction (not mandatory) |
ProjectAccountCode
|
ProjectAccountCode | string |
Project account code that is linked to the transaction |
ProjectAccountName
|
ProjectAccountName | string |
Project account name that is linked to the transaction |
ProjectCode
|
ProjectCode | string |
Project code that is linked to the transaction |
ProjectDescription
|
ProjectDescription | string |
Project description that is linked to the transaction |
Quantity
|
Quantity | double |
Quantity of the item that is linked to the transaction |
SkipValidation
|
SkipValidation | boolean |
Skip validation |
StartTime
|
StartTime | date-time |
Start time of the time transaction |
Subscription
|
Subscription | string |
Guid ID of subscription that is linked to the transaction |
SubscriptionAccount
|
SubscriptionAccount | string |
Subscription account ID that is linked to the transaction, this is to identify the referenced subscription |
SubscriptionAccountCode
|
SubscriptionAccountCode | string |
Subscription account code that is linked to the transaction |
SubscriptionAccountName
|
SubscriptionAccountName | string |
Subscription account name that is linked to the transaction |
SubscriptionDescription
|
SubscriptionDescription | string |
Subscription description that is linked to the transaction |
SubscriptionNumber
|
SubscriptionNumber | integer |
Subscription number that is linked to the transaction |
Type
|
Type | float |
The type of transaction. E.g: 1 = Time, 2 = Cost |
ProjectTimeCostTransactionsResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | ProjectTimeCostTransactionsArray |
ProjectTimeCostTransactionsArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of ProjectTimeCostTransactions |
ProjectTimeCostTransactions
Name | Path | Type | Description |
---|---|---|---|
Timestamp
|
Timestamp | integer |
Timestamp |
Account
|
Account | string |
Guid ID of account that is linked to the project |
AccountName
|
AccountName | string |
Name of account that is linked to the project |
AmountFC
|
AmountFC | double |
Calculated amount of the transaction based on (Quantity * PriceFC) |
Attachment
|
Attachment | string |
Attachment linked to the transaction (not mandatory) |
Created
|
Created | date-time |
Date and time the transaction was created |
Creator
|
Creator | string |
The Guid ID of user that created the transaction |
CreatorFullName
|
CreatorFullName | string |
The full name of the user that created the record |
Currency
|
Currency | string |
Currency of amount FC |
Date
|
Date | date-time |
Date and time the transaction was done |
Division
|
Division | integer |
Division code |
DivisionDescription
|
DivisionDescription | string |
Description of Division |
Employee
|
Employee | string |
Guid ID of the employee that is linked to the transaction |
EndTime
|
EndTime | date-time |
End time of the time transaction |
EntryNumber
|
EntryNumber | integer |
Number that represents the grouping of transactions |
ErrorText
|
ErrorText | string |
(Only used by backgroundjobs) To determine which transaction has an error |
HourStatus
|
HourStatus | float |
Status of the transaction: 1 = Draft, 2 = Rejected, 10 = Submitted, 11 = Failed on approval, 14 = Processing, 16 = Processing, 19 = Failed while undoing approval, 20 = Final |
ID
|
ID | string |
Primary key |
Item
|
Item | string |
Item that is linked to the transaction, which provides the time or cost information |
ItemDescription
|
ItemDescription | string |
Description of the item that is linked to the transaction |
ItemDivisable
|
ItemDivisable | boolean |
Indicates if fractional quantities of the item can be used, for example quantity = 0.4 |
Modified
|
Modified | date-time |
The date and time transaction record was modified |
Modifier
|
Modifier | string |
The Guid ID of the user that modified the records |
ModifierFullName
|
ModifierFullName | string |
The full name of the user that modified the record |
Notes
|
Notes | string |
Notes linked to the transaction for providing additional information (not mandatory) |
PriceFC
|
PriceFC | double |
For use in AmountFC (Quantiy * Price FC) |
Project
|
Project | string |
Guid ID of project that is linked to the transaction |
ProjectAccount
|
ProjectAccount | string |
Project account ID that is linked to the transaction (not mandatory) |
ProjectAccountCode
|
ProjectAccountCode | string |
Project account code that is linked to the transaction |
ProjectAccountName
|
ProjectAccountName | string |
Project account name that is linked to the transaction |
ProjectCode
|
ProjectCode | string |
Project code that is linked to the transaction |
ProjectDescription
|
ProjectDescription | string |
Project description that is linked to the transaction |
Quantity
|
Quantity | double |
Quantity of the item that is linked to the transaction |
StartTime
|
StartTime | date-time |
Start time of the time transaction |
Subscription
|
Subscription | string |
Guid ID of subscription that is linked to the transaction |
SubscriptionAccount
|
SubscriptionAccount | string |
Subscription account ID that is linked to the transaction, this is to identify the referenced subscription |
SubscriptionAccountCode
|
SubscriptionAccountCode | string |
Subscription account code that is linked to the transaction |
SubscriptionAccountName
|
SubscriptionAccountName | string |
Subscription account name that is linked to the transaction |
SubscriptionDescription
|
SubscriptionDescription | string |
Subscription description that is linked to the transaction |
SubscriptionNumber
|
SubscriptionNumber | integer |
Subscription number that is linked to the transaction |
Type
|
Type | float |
The type of transaction. E.g: 1 = Time, 2 = Cost |
WBS
|
WBS | string |
Guid ID of activity for time transaction or expense for cost transaction that is linked to project WBS (work breakdown structure) |
WBSDescription
|
WBSDescription | string |
Name of activity for time transaction or expense for cost transaction that is linked to project WBS (work breakdown structure) |
MeResponse
Name | Path | Type | Description |
---|---|---|---|
d
|
d | MeArray |
MeArray
Name | Path | Type | Description |
---|---|---|---|
results
|
results | array of Me |
Me
Name | Path | Type | Description |
---|---|---|---|
UserID
|
UserID | string |
Primary key |
AccountingDivision
|
AccountingDivision | integer |
Accounting division number |
CurrentDivision
|
CurrentDivision | integer |
Division number that is currently used in the API. You should use a division number in the url |
CustomerCode
|
CustomerCode | string |
Account code of the logged in user. |
DivisionCustomer
|
DivisionCustomer | string |
Owner account of the division |
DivisionCustomerCode
|
DivisionCustomerCode | string |
Owner account code of the division |
DivisionCustomerName
|
DivisionCustomerName | string |
Owner account name of the division |
DivisionCustomerSiretNumber
|
DivisionCustomerSiretNumber | string |
Owner account SIRET Number of the division for French legislation |
DivisionCustomerVatNumber
|
DivisionCustomerVatNumber | string |
Owner account VAT Number of the division |
DossierDivision
|
DossierDivision | integer |
Dossier division number (optional) |
Email
|
string |
Email address of the user |
|
EmployeeID
|
EmployeeID | string |
Employee ID |
FirstName
|
FirstName | string |
First name |
FullName
|
FullName | string |
Full name of the user |
Gender
|
Gender | string |
Gender: M=Male, V=Female, O=Unknown |
Initials
|
Initials | string |
Initials |
IsClientUser
|
IsClientUser | boolean |
Client user of an accountant: either a portal user or a non-accountant user with his own license (internal use) |
IsMyFirmPortalUser
|
IsMyFirmPortalUser | boolean |
MyFirm user of accountant with limited access and specific start page (internal use) |
Language
|
Language | string |
Language spoken by this user |
LanguageCode
|
LanguageCode | string |
Language (culture) that is used in Exact Online |
LastName
|
LastName | string |
Last name |
Legislation
|
Legislation | string |
Legislation |
MiddleName
|
MiddleName | string |
Middle name |
Mobile
|
Mobile | string |
Mobile phone |
Nationality
|
Nationality | string |
Nationality |
Phone
|
Phone | string |
Phone number |
PhoneExtension
|
PhoneExtension | string |
Phone number extension |
PictureUrl
|
PictureUrl | string |
Url that can be used to retrieve the picture of the user |
ServerTime
|
ServerTime | string |
The current date and time in Exact Online |
ServerUtcOffset
|
ServerUtcOffset | double |
The time difference with UTC in seconds |
ThumbnailPicture
|
ThumbnailPicture | binary |
Binary thumbnail picture of this user (This property will never return value and will be removed in the near future.) |
ThumbnailPictureFormat
|
ThumbnailPictureFormat | string |
File type of the picture (This property will never return value and will be removed in the near future.) |
Title
|
Title | string |
Title |
UserName
|
UserName | string |
Login name of the user |