invantive documentation
Invantive Support ForumsLog In / Sign Up

TimeCardEmployeesByReferenceNumber: Visma.net Financials itgen_vnet_timecardemployeesbyreferencenumber_plural

read only REST

  • Catalog: VismaNet
  • Schema: TimeCard
  • Label: itgen_vnet_timecardemployeesbyreferencenumber_plural

Get a specific employee time card Data for a single employee time card The response headers include an ETag after a successful GET operation.

Can only retrieve data.

Summary

Data for a single employee time card

The response headers include an ETag after a successful GET operation.

API Source

  • Endpoint: /v1/timeCard/{referenceNumber}
  • Operation: get /v1/timeCard/{referenceNumber}

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
referenceNumber `` Identifies the time card

Table Columns

The columns of the table TimeCardEmployeesByReferenceNumber 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 filters on the platform, writable, approvalStatus The top part > Approval status > The approval status of the time card
approvalStatusText varchar2 Approval Status Text filters on the platform, writable, approvalStatusText
employee_internalId varchar2 Employee Internal ID filters on the platform, writable, employee.internalId
employee_name varchar2 Employee Name filters on the platform, writable, employee.name The name of the particular destination of the selected type.
employee_number varchar2 Employee Number filters on the platform, writable, employee.number The identifier of the particular destination of the selected type.
errorInfo varchar2 Error Message filters on the platform, writable, errorInfo
invoiceable int32 Invoiceable filters on the platform, writable, invoiceable The top part > Regular column: Invoicable > The invoiceable work hours spent by the employee during the week
invoiceableOvertime int32 Invoiceable Overtime filters on the platform, writable, 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, invoiceableTotalTime The top part > Total column: Invoicable > The total invoiceable working time (regular and overtime) for the week
lastModifiedDateTime datetime Last Modified filters on the platform, writable, lastModifiedDateTime System generated information: The last time the time card line was modified
metadata_maxPageSize int64 Metadata Max Pagesize filters on the platform, writable, metadata.maxPageSize
metadata_totalCount int64 Total Count filters on the platform, writable, metadata.totalCount
origRefNbr varchar2 Orig Reference Nbr filters on the platform, writable, 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, 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.
refNbr varchar2 Reference Number filters on the platform, writable, 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.
status varchar2 Status filters on the platform, writable, status The top part > Status > The status of the time card
timeSpent int32 Time Spent filters on the platform, writable, 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, 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, totalTimeSpent The top part > Total column: Time spent > The total working time (regular and overtime) for the week
type varchar2 Type filters on the platform, writable, 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
week_description varchar2 Week Description filters on the platform, writable, week.description Name of item/description
week_number varchar2 Week Number filters on the platform, writable, week.number Number of item

Release Notes

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