EmployeeTimeCardMaterials: Visma.net Financials Employee Time Card Materials
read only REST
- Catalog:
VismaNet - Schema:
Employee - Label: Employee Time Card Materials
Get a specific employee time cards
Can only retrieve data.
API Source
- Endpoint:
/v1/employee/{EmployeeCd}/timecards - Operation:
get /v1/employee/{EmployeeCd}/timecards
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 |
|---|---|---|---|---|
employee |
`` | Identifies the employee | ||
greater |
`` | Greater-than value. The item which is the object for this, varies from API to API. | ||
last |
`` | 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- * yyyy- * yyyy- * yyyy- * yyyy- Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive. |
||
last |
`` | 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 EmployeeTimeCardMaterials 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_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
approval |
varchar2 |
Approval Status | filters on the platform, writable, ::ancestor. |
The top part > Approval status > The approval status of the time card | |
approval |
varchar2 |
Approval Status Text | filters on the platform, writable, ::ancestor. |
||
description |
varchar2 |
Description | writable, description |
Description > The description of the reported quantity. | |
employee_ |
varchar2 |
Employee Internal ID | filters on the platform, writable, ::ancestor. |
||
employee_ |
varchar2 |
Employee Name | filters on the platform, writable, ::ancestor. |
The name of the particular destination of the selected type. | |
employee_ |
varchar2 |
Employee Number | filters on the platform, writable, ::ancestor. |
The identifier of the particular destination of the selected type. | |
error |
varchar2 |
Error Message | filters on the platform, writable, ::ancestor. |
||
fri |
double |
Fri | writable, fri |
Fri > The quantity reported for Friday. | |
invoiceable |
int32 |
Invoiceable | filters on the platform, writable, ::ancestor. |
The top part > Regular column: Invoicable > The invoiceable work hours spent by the employee during the week | |
invoiceable |
int32 |
Invoiceable Overtime | filters on the platform, writable, ::ancestor. |
The top part > Overtime column: Invoicable > The invoiceable overtime spent by the employee during the week | |
invoiceable |
int32 |
Invoiceable Total Time | filters on the platform, writable, ::ancestor. |
The top part > Total column: Invoicable > The total invoiceable working time (regular and overtime) for the week | |
itemId |
varchar2 |
Item ID | writable, itemId |
Item Id | |
last |
datetime |
Last Modified | writable, last |
||
last |
datetime |
Last Modified Date/Time 2 | filters on the platform, writable, ::ancestor. |
System generated information: The last time the time card line was modified | |
line |
int32 |
Line Number | writable, line |
The time card line number | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, ::ancestor. |
||
mon |
double |
Mon | writable, mon |
Mon > The quantity reported for Monday. | |
orig |
varchar2 |
Orig Reference Nbr | filters on the platform, writable, ::ancestor. |
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 | |
overtime |
int32 |
Overtime Spent | filters on the platform, writable, ::ancestor. |
The top part > Overtime column: Time spent > The work hours spent by the employee during the week on activities with the Overtime earning type. | |
project |
varchar2 |
Project Task Description | writable, project |
Click on the magnifier. > The description. | |
project |
varchar2 |
Project Task ID | writable, project |
Click on the magnifier. > The identifier. | |
project |
int32 |
itgen_vnet_projecttask_internalid | writable, project |
The internal identifier. | |
project_ |
varchar2 |
Project Description | writable, project. |
Click on the magnifier. > The description. | |
project_ |
varchar2 |
Project ID | writable, project. |
Click on the magnifier. > The identifier. | |
project_ |
int32 |
itgen_vnet_project_internalid | writable, project. |
The internal identifier. | |
refNbr |
varchar2 |
Reference Number | filters on the platform, writable, ::ancestor. |
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 |
double |
Sat | writable, sat |
Sat > The quantity reported for Saturday. | |
status |
varchar2 |
Status | filters on the platform, writable, ::ancestor. |
The top part > Status > The status of the time card | |
sun |
double |
Sunday | writable, sun |
Sun > The quantity reported for Sunday. | |
thu |
double |
Thu | writable, thu |
Thu > The quantity reported for Thursday. | |
time |
int32 |
Time Spent | filters on the platform, writable, ::ancestor. |
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. | |
time |
blob |
Timestamp | filters on the platform, writable, ::ancestor. |
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) | |
total |
double |
Total Quantity | writable, total |
Total Qty | |
total |
int32 |
Total Time Spent | filters on the platform, writable, ::ancestor. |
The top part > Total column: Time spent > The total working time (regular and overtime) for the week | |
tue |
double |
Tuesday | writable, tue |
Tue > The quantity reported for Tuesday. | |
type |
varchar2 |
Type | filters on the platform, writable, ::ancestor. |
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 | |
uoM |
varchar2 |
Unit of Measure | writable, uoM |
The unit of measure of item | |
wed |
double |
Wednesday | writable, wed |
Wed > The quantity reported for Wednesday. | |
week_ |
varchar2 |
Week Description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
week_ |
varchar2 |
Week Number | filters on the platform, writable, ::ancestor. |
Number of item |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: