invantive documentation
Invantive Support ForumsLog In / Sign Up

EmployeeTimeCardSummaries: Visma.net Financials Employee Time Card Summaries

read only REST

  • Catalog: VismaNet
  • Schema: TimeCard
  • Label: Employee Time Card Summaries

Get all employee time cards, a filter needs to be specified - ScreenId=EP305000

Can only retrieve data.

API Source

  • Endpoint: /v1/timeCard
  • Operation: get /v1/timeCard

Performance Characteristics

Characteristic Value
Average access latency (ms) 155
Full scan rows per minute 29,100
Point query rows per minute 387

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
employeeCd ``
greaterThanValue `` Greater-than value. The item which is the object for this, varies from API to API.
lastModifiedDateTime `` This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present. Accepted format: * yyyy-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
lastModifiedDateTimeCondition `` This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
status `` The status of the document. (Values: Hold, Open, Approved, Rejected, Released)
type `` Identifies the type of the time card (Normal, Corrected, NormalCorrected) (Values: Normal, Correction, NormalCorrected)
week `` Identifies the week number of the time card

Table Columns

The columns of the table EmployeeTimeCardSummaries are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
COMPANY_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name writable Name of the partition.
approvalStatus varchar2 Approval Status writable, approvalStatus Approval status > The approval status, which indicates whether the summary row requires approval and, if it does, what the current state of approval is.
approvalStatusText varchar2 Approval Status Text writable, approvalStatusText last approval comment > The approval status text suitable for display
approvalStatusText_2 varchar2 Approval Status Text 2 filters on the platform, writable, ::ancestor.approvalStatusText
approvalStatus_2 varchar2 Approval Status 2 filters on the platform, writable, ::ancestor.approvalStatus The top part > Approval status > The approval status of the time card
approver varchar2 Approver writable, approver The identifier of the person authorized to approve the activity, if approval is required. This is either the approver of the project task or, if no approver is assigned to the project task, the project manager.
description varchar2 Description writable, description Description > The description of the reported work hours.
earningType_code varchar2 Earning Type Code writable, earningType.code Mandatory field: Code* > The unique ID of the type of hour.
earningType_description varchar2 Earning Type Description writable, earningType.description Mandatory field: Description > The brief description of the type of hour.
earningType_isActive char Earning Type Is Active writable, earningType.isActive Active > A check box that indicates (if selected) that the type of hour is active and can be used.
earningType_isBillable char Earning Type Is Billable writable, earningType.isBillable Invoicable > A check box that indicates (if selected) that the type is treated as invoiceable by default.
earningType_isOvertime char Earning Type Is Overtime writable, earningType.isOvertime Overtime > A check box that indicates (if selected) that the type of hour is treated as overtime.
earningType_lastModifiedDateTime datetime Earning Type Lastmodified Datetime writable, earningType.lastModifiedDateTime System generated information.
earningType_overtimeMultiplier double Earning Type Overtime Multiplier writable, earningType.overtimeMultiplier Multiplier > The value by which the employee cost for this type of hour is multiplied when the time activity is released.
employee_internalId varchar2 Employee Internal ID filters on the platform, writable, ::ancestor.employee.internalId
employee_name varchar2 Employee Name filters on the platform, writable, ::ancestor.employee.name The name of the particular destination of the selected type.
employee_number varchar2 Employee Number filters on the platform, writable, ::ancestor.employee.number The identifier of the particular destination of the selected type.
errorInfo varchar2 Error Message filters on the platform, writable, ::ancestor.errorInfo
fri int32 Fri writable, fri Fri > The work time reported for Friday, including overtime.
invoiceable char Invoiceable writable, invoiceable Invoicable > A check box that you select to indicate that these work hours are invoiceable.
invoiceableOvertime int32 Invoiceable Overtime filters on the platform, writable, ::ancestor.invoiceableOvertime The top part > Overtime column: Invoicable > The invoiceable overtime spent by the employee during the week
invoiceableTotalTime int32 Invoiceable Total Time filters on the platform, writable, ::ancestor.invoiceableTotalTime The top part > Total column: Invoicable > The total invoiceable working time (regular and overtime) for the week
invoiceable_2 int32 Invoiceable 2 filters on the platform, writable, ::ancestor.invoiceable The top part > Regular column: Invoicable > The invoiceable work hours spent by the employee during the week
lastModifiedDateTime datetime Last Modified writable, lastModifiedDateTime The last time the time card line was modified
lastModifiedDateTime_2 datetime Last Modified Date/Time 2 filters on the platform, writable, ::ancestor.lastModifiedDateTime System generated information: The last time the time card line was modified
lineId guid Line Identifier writable, lineId The time card line id
lineNumber int32 Line Number writable, lineNumber The time card line number
metadata_maxPageSize int64 Metadata Max Pagesize filters on the platform, writable, ::ancestor.metadata.maxPageSize
metadata_totalCount int64 Total Count filters on the platform, writable, ::ancestor.metadata.totalCount
mon int32 Mon writable, mon Mon > The work time reported for Monday, including overtime.
origRefNbr varchar2 Orig Reference Nbr filters on the platform, writable, ::ancestor.origRefNbr The top part > Orig. ref. no. > The reference number of the time card being corrected. This box is filled in only when Correction is specified in the Type box
overtimeSpent int32 Overtime Spent filters on the platform, writable, ::ancestor.overtimeSpent The top part > Overtime column: Time spent > The work hours spent by the employee during the week on activities with the Overtime earning type.
projectTask_description varchar2 Project Task Description writable, projectTask.description Click on the magnifier. > The description.
projectTask_id varchar2 Project Task ID writable, projectTask.id Click on the magnifier. > The identifier.
projectTask_internalId int32 itgen_vnet_projecttask_internalid writable, projectTask.internalId The internal identifier.
project_description varchar2 Project Description writable, project.description Click on the magnifier. > The description.
project_id varchar2 Project ID writable, project.id Click on the magnifier. > The identifier.
project_internalId int32 itgen_vnet_project_internalid writable, project.internalId The internal identifier.
refNbr varchar2 Reference Number filters on the platform, writable, ::ancestor.refNbr The top part > Ref. no. > The unique reference number of the time card, which Acumatica ERP automatically assigns according to the numbering sequence specified as the Time Card Numbering Sequence on the Time and Expenses Preferences (EP.10.10.00) form.
sat int32 Sat writable, sat Sat > The work time reported for Saturday, including overtime.
status varchar2 Status filters on the platform, writable, ::ancestor.status The top part > Status > The status of the time card
sun int32 Sunday writable, sun Sun > The work time reported for Sunday, including overtime.
thu int32 Thu writable, thu Thu > The work time reported for Thursday, including overtime.
timeSpent int32 Time Spent writable, timeSpent Time spent > The work time (regular and overtime) that the employee spent on the project and task during the week.
timeSpent_2 int32 Timespent 2 filters on the platform, writable, ::ancestor.timeSpent The top part > Regular column: Time spent > The work hours spent by the employee during the week on activities with the Regular Hours earning type.
timeStamp blob Timestamp filters on the platform, writable, ::ancestor.timeStamp Identifier that represents a specific version of the resource. It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers)
totalTimeSpent int32 Total Time Spent filters on the platform, writable, ::ancestor.totalTimeSpent The top part > Total column: Time spent > The total working time (regular and overtime) for the week
tue int32 Tuesday writable, tue Tue > The work time reported for Tuesday, including overtime.
type varchar2 Type filters on the platform, writable, ::ancestor.type The top part > Type > The type of the time card. The following options are available:• Normal: Regular time card• Correction: Corrective time card, which is a time card that updates a released time card
wed int32 Wednesday writable, wed Wed > The work time reported for Wednesday, including overtime.
week_description varchar2 Week Description filters on the platform, writable, ::ancestor.week.description Name of item/description
week_number varchar2 Week Number filters on the platform, writable, ::ancestor.week.number Number of item

Release Notes

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