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")
|
|