Get job ledger entry
If you need to get the posted job data
back to your ERP system you can use this
function.
It will return all the posted job ledger
entries not already transfered. When you
have read and stored a record you must
call MarkJobLedgerEntryTransfered to make
sure you don't get that same record again
next time.
You just need to pass APIKey
It will return a dataset with these
fields
| Field | SQL Type | Comment |
| ID | INT | Unique ID for
this record |
| EmployeeCode | NVARCHAR(20) | |
| Date | DATETIME | |
| Name | NVARCHAR(50) | |
| JobCode | NVARCHAR(20) | |
| OperationCode | NVARCHAR(20) | |
| JobOperationLineNumber | DECIMAL | |
| OperationDescription | NVARCHAR(50) | |
| ActivityCode | NVARCHAR(20) | |
| ActivityDescription | NVARCHAR(50) | |
| Completed | BIT | If the
operation has been completed with
the specific operation |
| WorkTypeCode | NVARCHAR(20) | Type of this
time - could be NORMAL time,
OVERTIME1, OVERTIME2 or any other
extra. It's important to
understand that if an employee has
worked 9,5 hours which may have
given 2 hours overtime there will
be 2 records. One with 9,5 hours
with NORMAL and another record
with 2 hours OVERTIME1 |
| StartTime | DATETIME | The excact
time when this job/operation has
been started |
| EndTime | DATETIME | The excact
time when this job/operation has
been stopped |
| TotalTime | DECIMAL | In hours. Be
aware that total time is reduced
with breaks that has been between
start time and end time. Total
time could also be rounded |
| ERPReference | NVARCHAR(20) | Reference back
to ERP system. The same ERP that
has been passed using create
operation function |
| TaskID | INT | If tasks has
been used |
| WorkFunctionCode | NVARCHAR(20) | The work
function for the employee working
on this job |
| DistrictCode | NVARCHAR(20) | District code
of the job |
| DepartmentCode | NVARCHAR(20) | Department
code of the job |
| EmployeeGroupCode | NVARCHAR(20) | Employee group
code of the employee |
| Setup | BIT | If this record
is setup time. |
| JournalCode | NVARCHAR(20) | From which
journal in SmartTID this has been
posted |
| DimensionCode1 | NVARCHAR(20) | Value of
dimension code 1 |
| DimensionCode2 | NVARCHAR(20) | |
| DimensionCode3 | NVARCHAR(20) | |
| DimensionCode4 | NVARCHAR(20) | |
| DimensionCode5 | NVARCHAR(20) | |
| DimensionCode6 | NVARCHAR(20) | |
| DimensionCode7 | NVARCHAR(20) | |
| DimensionCode8 | NVARCHAR(20) | |
| DimensionCode9 | NVARCHAR(20) | |
| DimensionCode10 | NVARCHAR(20) | |
| PayrollTypeCode | NVARCHAR(20) | |
| OverTimeCode | NVARCHAR(20) | The way to see
if these hours are overtime or not
and what type. Can we setup in
SmartTID on each work type code |
| Remarks | NVARCHAR(MAX) | Remarks for
employee on this registration |
| JournalLineID | INT | Reference to
unique journal line in SmartTID |
| JournalLineEntryID | INT | Reference to
unique journal line entry in
SmartTID |
| JobJournalID | INT | Reference to
unique job journal in SmartTID.
Can be used to identify when one
registrations has produced more
than one record in JobLedgerEntry.
Could be due to over time. |
| PayrollReference | NVARCHAR(50) | Reference to
WorkType codes payroll reference |
| Quantity | DECIMAL | Quantity of
produced items (From version
6.17.19) |
Rev 02, Poul Christensen, 09-07-2019
From database version 6.01.01