GET

TimeReceipt

 

Property

Description

Table

BEAS_ARBZEIT

Primary key

SystemNumber/i

$transaction

no

$branch

no

$mask

no

 

Fields

Name

Type

Description

SystemNumber

Edm.Int32

Primary key

Database: "BEAS_ARBZEIT"."BUCHNR_ID"

DocEntry

Edm.Int32

Integration hub: Importable

Mandatory field

Database: "BEAS_ARBZEIT"."BELNR_ID"

LineNumber

Edm.Int32

Integration hub: Importable

Mandatory field

Database: "BEAS_ARBZEIT"."BELPOS_ID"

LineNumber2

Edm.Int32

Integration hub: Importable

Mandatory field

Database: "BEAS_ARBZEIT"."POS_ID"

LineNumber3

Edm.Int32

Internal position number of parallel resource

linked to BEAS_FTAPL.WKZPOS_ID !

Integration hub: Importable

Database: "BEAS_ARBZEIT"."RESOURCENPOS_ID"

Canceled

Edm.Boolean

Database: coalesce("BEAS_ARBZEIT"."CANCELD",0)

CloseEntry

Edm.Boolean

Database: case when "BEAS_ARBZEIT"."ABGKZ"='J' then 1 else 0 end

TimeType

Edm.String(1)

Constraints:

normal time=A

tool time=R

time 2 (H)=H

time 3 (N)=N

Integration hub: Importable

Database: coalesce("BEAS_ARBZEIT"."TYP",'A')

PersonnelId

Edm.String(20)

Entity Relation: Employee -> PersonnelId

Database: rtrim("BEAS_ARBZEIT"."PERS_ID")

ResourceId

Edm.String(20)

Entity Relation: Resource -> ResourceId

Database: rtrim("BEAS_ARBZEIT"."APLATZ_ID")

StartDateTime

Edm.DateTimeOffset

best date format: yyyy/mm/dd hh:mm in 24 hour format

Time format with am/pm not working.

Integration hub: Importable

Mandatory field

Database: "BEAS_ARBZEIT"."ANFZEIT"

EndDateTime

Edm.DateTimeOffset

best date format: yyyy/mm/dd hh:mm in 24 hour format

Time format with am/pm not working.

Integration hub: Importable

Mandatory field

Database: "BEAS_ARBZEIT"."ENDZEIT"

Duration

Edm.Decimal

Integration hub: Importable

Mandatory field

Database: "BEAS_ARBZEIT"."ZEIT"

QuantityGood

Edm.Decimal

Database: "BEAS_ARBZEIT"."MENGE_GUT"

QuantityScrap

Edm.Decimal

Database: "BEAS_ARBZEIT"."MENGE_SCHLECHT"

QuantityGoodRUoM

Edm.Decimal

Quantity im time receipt unit

Integration hub: Importable

Database: "BEAS_ARBZEIT"."MENGE_GUT_RM"

QuantityScrapRUoM

Edm.Decimal

Scrap Quantity im time receipt unit

Integration hub: Importable

Database: "BEAS_ARBZEIT"."MENGE_SCHLECHT_RM"

RUoMFactor

Edm.Decimal

Default Value: 1

Database: "BEAS_ARBZEIT"."RM_FAKTOR"

RUoM

Edm.String(20)

Database: "BEAS_ARBZEIT"."RM_ME"

ExternalCosts

Edm.Decimal

Cost (manual entry)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."EXTERNAL_COST"

Remarks

Edm.String(255)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."GRUND"

ExternalWork

Edm.Boolean

Database: case when coalesce("BEAS_ARBZEIT"."AUSWAERTSBEARBEITUNG",'N')='J' then 1 else 0 end

CostElementId

Edm.String(20)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."TIMETYPE_ID"

CostCenter

Edm.String(20)

Linked table: OPRC

Linked column: PrcCode

Integration hub: Importable

Database: "BEAS_ARBZEIT"."KSTST_ID"

ToolId

Edm.String(20)

Which Tool id (from tool administration BEAS_WKZ) used for this time operation

Only for information. Not mandatory

Linked table: BEAS_WKZ

Linked column: WKZ_ID

Integration hub: Importable

Database: "BEAS_ARBZEIT"."WKZ_ID"

StationId

Edm.String(50)

Database: "BEAS_ARBZEIT"."STATIONNAME"

UDF1

Edm.String(50)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."UDF1"

UDF2

Edm.String(50)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."UDF2"

UDF3

Edm.String(50)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."UDF3"

UDF4

Edm.String(50)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."UDF4"

UDF5

Edm.String(50)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."UDF5"

UDF6

Edm.String(50)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."UDF6"

UDF7

Edm.String(50)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."UDF7"

UDF8

Edm.String(50)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."UDF8"

UDF9

Edm.String(50)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."UDF9"

UDF10

Edm.String(50)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."UDF10"

UDF11

Edm.String(50)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."UDF11"

UDF12

Edm.String(50)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."UDF12"

UDF13

Edm.String(50)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."UDF13"

UDF14

Edm.String(50)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."UDF14"

UDF15

Edm.String(50)

Integration hub: Importable

Database: "BEAS_ARBZEIT"."UDF15"

TimeReceiptRunningId

Edm.Decimal

Only Post:

Define a Logoff with The TimeReceiptRunning.SystemNumber

 

This example close the current running time for current user 


{line=[
  {"TimeReceiptRunning":3}
  ]
}

Database: 0

DontDeleteTimeReceiptRunning

Edm.Decimal

Only Post:

If activated, the system don't delete the running time receipt

 

This example close the current running time for current user but don't delete the TimeReceiptRunning entry

 


{line=[
  {"TimeReceiptRunning":3, "DontDeleteTimeReceiptRunning":1}
  ]
}

Database: 0

Barcode

Edm.Decimal

Database: (select "NUMMER" from "BEAS_FTAPL" f where f."BELNR_ID"="BEAS_ARBZEIT"."BELNR_ID" and f."BELPOS_ID"="BEAS_ARBZEIT"."BELPOS_ID" and f."POS_ID"="BEAS_ARBZEIT"."POS_ID")

 

Relations

Join to Entiy Object

Relation

Resource

ResourceId

Employee

PersonnelId

WorkorderRouting

DocEntry,LineNumber,LineNumber2

WorkorderRoutingParallel

DocEntry,LineNumber,LineNumber2,LineNumber3

 

Functions

Function

Parameter

Description

TimeCalculation

Json Parameter/j

Parameter: Json String with follow Parameter

PersonnelId - the Personnel Id. Default is current Personnel Id

ResourceId - the Resource (optional) - important to check Interruptions

SystemNumberId - The TimeReceiptRunning.SystemNumberId (optional)

StartDate - the Start date in format yyyy/mm/dd, example: 2019/01/03. Default is Today

StartTime - the Start time in format hh:mm. Default is now

EndDate - the End Date. Default is Today

EndTime - the End Time. Default is now

 

Return the time duration between Start date / time and now

If all parameter defined, it check all rules.

 

Example: Duration for Personnel Id 10 from 8 am to current time:

 


TimeReceipt/TimeCalculation({"PersonnelId":10,"StartTime":"8:00"})

Return:
{
    "value": 1,
    "Duration": 204,
    "LogInfo": "calculate for 1 days .. Date 2019/03/27 ....",
    "LogInfo_Html": "html text for calculation description...."
}

value = 1 (all ok)

Duration = the calulated duration in Minutes

LogInfo = Text information about the calculation process

LogInfoHtml LogInfo in HTML format