Exact Time & Billing (Independent Publisher) (Preview)

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	support@indocs.nl

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

Operation ID:

PostProjectRestrictionRebillings

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

Body

ProjectRestrictionRebillingsResponse

Create time corrections

Operation ID:

PostTimeCorrections

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

Body

TimeCorrectionsResponse

Create time transactions

Operation ID:

PostTimeTransactions

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

Body

TimeTransactionsResponse

Delete project restriction rebillings

Operation ID:

DeleteProjectRestrictionRebillings

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

Body

ProjectRestrictionRebillingsResponse

Delete time corrections

Operation ID:

DeleteTimeCorrections

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

Body

TimeCorrectionsResponse

Delete time transactions

Operation ID:

DeleteTimeTransactions

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

Body

TimeTransactionsResponse

Get divisions

Operation ID:

GetDivisions

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

Operation ID:

GetEmploymentInternalRates

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

Body

EmploymentInternalRatesResponse

Get hour cost types

Operation ID:

GetHourCostTypes

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

Body

HourCostTypesResponse

Get hour entry activities by project

Operation ID:

GetHourEntryActivitiesByProject

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

Body

HourEntryActivitiesByProjectResponse

Get hour entry recent accounts

Operation ID:

GetHourEntryRecentAccounts

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

Body

HourEntryRecentAccountsResponse

Get hour entry recent accounts by project

Operation ID:

GetHourEntryRecentAccountsByProject

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

Body

HourEntryRecentAccountsByProjectResponse

Get hour entry recent hour types

Operation ID:

GetHourEntryRecentHourTypes

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

Body

HourEntryRecentHourTypesResponse

Get hour entry recent hour types by project

Operation ID:

GetHourEntryRecentHourTypesByProject

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

Body

HourEntryRecentHourTypesByProjectResponse

Get hour entry recent projects

Operation ID:

GetHourEntryRecentProjects

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

Body

HourEntryRecentProjectsResponse

Get hour types

Operation ID:

GetHourTypes

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

Operation ID:

GetHourTypesByDate

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

Body

HourTypesByDateResponse

Get hour types by project and date

Operation ID:

GetHourTypesByProjectAndDate

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

Body

HourTypesByProjectAndDateResponse

Get hours by date

Operation ID:

GetHoursByDate

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

Operation ID:

GetHoursById

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

Operation ID:

GetMe

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

Operation ID:

GetProjectRestrictionRebillings

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

Body

ProjectRestrictionRebillingsResponse

Get project time cost transactions

Operation ID:

GetProjectTimeCostTransactions

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

Body

ProjectTimeCostTransactionsResponse

Get recent costs by number of weeks

Operation ID:

GetRecentCostsByNumberOfWeeks

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

Body

RecentCostsByNumberOfWeeksResponse

Get recent hours

Operation ID:

GetRecentHours

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

Operation ID:

GetRecentHoursByNumberOfWeeks

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

Body

RecentHoursByNumberOfWeeksResponse

Get time and billing account details

Operation ID:

GetTimeAndBillingAccountDetails

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

Body

TimeAndBillingAccountDetailsResponse

Get time and billing account details byid

Operation ID:

GetTimeAndBillingAccountDetailsByID

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

Body

TimeAndBillingAccountDetailsByIDResponse

Get time and billing activities and expenses

Operation ID:

GetTimeAndBillingActivitiesAndExpenses

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

Body

TimeAndBillingActivitiesAndExpensesResponse

Get time and billing entry accounts

Operation ID:

GetTimeAndBillingEntryAccounts

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

Body

TimeAndBillingEntryAccountsResponse

Get time and billing entry accounts by date

Operation ID:

GetTimeAndBillingEntryAccountsByDate

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

Body

TimeAndBillingEntryAccountsByDateResponse

Get time and billing entry accounts by project and date

Operation ID:

GetTimeAndBillingEntryAccountsByProjectAndDate

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

Body

TimeAndBillingEntryAccountsByProjectAndDateResponse

Get time and billing entry projects

Operation ID:

GetTimeAndBillingEntryProjects

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

Body

TimeAndBillingEntryProjectsResponse

Get time and billing entry projects by account and date

Operation ID:

GetTimeAndBillingEntryProjectsByAccountAndDate

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

Body

TimeAndBillingEntryProjectsByAccountAndDateResponse

Get time and billing entry projects by date

Operation ID:

GetTimeAndBillingEntryProjectsByDate

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

Body

TimeAndBillingEntryProjectsByDateResponse

Get time and billing entry recent accounts

Operation ID:

GetTimeAndBillingEntryRecentAccounts

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

Body

TimeAndBillingEntryRecentAccountsResponse

Get time and billing entry recent activities and expenses

Operation ID:

GetTimeAndBillingEntryRecentActivitiesAndExpenses

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

Body

TimeAndBillingEntryRecentActivitiesAndExpensesResponse

Get time and billing entry recent hour cost types

Operation ID:

GetTimeAndBillingEntryRecentHourCostTypes

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

Body

TimeAndBillingEntryRecentHourCostTypesResponse

Get time and billing entry recent projects

Operation ID:

GetTimeAndBillingEntryRecentProjects

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

Body

TimeAndBillingEntryRecentProjectsResponse

Get time and billing item details

Operation ID:

GetTimeAndBillingItemDetails

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

Body

TimeAndBillingItemDetailsResponse

Get time and billing item details byid

Operation ID:

GetTimeAndBillingItemDetailsByID

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

Body

TimeAndBillingItemDetailsByIDResponse

Get time and billing project details

Operation ID:

GetTimeAndBillingProjectDetails

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

Body

TimeAndBillingProjectDetailsResponse

Get time and billing project details byid

Operation ID:

GetTimeAndBillingProjectDetailsByID

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

Body

TimeAndBillingProjectDetailsByIDResponse

Get time and billing recent projects

Operation ID:

GetTimeAndBillingRecentProjects

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

Body

TimeAndBillingRecentProjectsResponse

Get time corrections

Operation ID:

GetTimeCorrections

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

Body

TimeCorrectionsResponse

Get time transactions

Operation ID:

GetTimeTransactions

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

Body

TimeTransactionsResponse

Update project restriction rebillings

Operation ID:

PutProjectRestrictionRebillings

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

Body

ProjectRestrictionRebillingsResponse

Update time corrections

Operation ID:

PutTimeCorrections

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

Body

TimeCorrectionsResponse

Update time transactions

Operation ID:

PutTimeTransactions

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

Body

TimeTransactionsResponse

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	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