TimeReceipt

Contents

Present Work order time receipts

timereceipt

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

A Time Receipt is a summary of many objects

- The Time Receipt self

- Time Receipt Scrap information

- Issue Document

- Receipt Document

In background

- Post Calculation

- Additional Warehouse transaction

- Quality Control Order

- Close Document request

It's possible to create a time receipt with automatic backflush process

But it's possible to create a time receipt with all information about Issue and Receipt document

Example

Create Time Receipt for work order 1314, Line 10, Routing Position 10 and PersonnelId 14 for 2 Pcs from 8 to current time

(Assembly: If Stock and Production unit not the same or Consume Unit is defined: See "Confirm Units"

With Scrap Definition

With Issue Document

With Reciept Document

[

{"DocEntry":1314,"LineNumber":10,"LineNumber2":10,"PersonnelId":"14","QuantityGoodRUoM":2,"FromTime":"8:00",

"TimeReceiptScrap":

[

{"ScrapId":"DontCheckQty","Quantity":3,"UDF1":"test"},

{"ScrapId":"Scrap-001","Quantity":3,"UDF1":"test"}

"Issue":{"Lines":[{"ItemCode":"RM","WhsCode":"01","Quantity":1,"BaseLineNumber2":10}]},

"Receipt":{"Lines":[{"ItemCode":"FP","WhsCode":"01","Quantity":2}]}

}

]

Result

{

"value": 1, // 1 = ok, otherwise the error message

"SystemNumber": [

2581 // the created Time Receipt number, can be a list of Numbers

]

}

All properties available from TimeReceipt, TimeReceiptScrap, Issue and ReceiptDocument

In Receipt and Issue document you don't need to define BaseDocentry/BaseLineNumber, only LineNumber2 for BoM Position

The System don't check, if the defined Material is ok. If wrong Material defined, the system book the wrong Material

The System book Items only for not closed Positions. If position is closed or position number is wrong, the system ignore the Information without error message

In routing position -> extended -> Confirm Unit you can define a Confirm unit and a Conversion Factor

If you want to work with the confirm unit, you must define the quantity in field QuantityGoodRUoM

You can read the UoM in WorkorderRouting/RUoM

If you want to create a receipt for the assembly in same time you must calculate the quantity in Warehouse Unit from the Assembly

Formula is

Receipt Quantity = QuantityGoodRUoM * WorkorderRouting/RUoMFactor : WorkorderPos/UoMConsumptionFactor

Additional Properties are Available

Field

Type

Description

DocEntry

Edm.Integer

Work order DocEntry

LineNumber

Edm.Integer

Work order Position

LineNumber2

Edm.Integer

Work order Routing Position (internal Number)

LineNumber3

Edm.Integer

Optional Position Parallel Resource

PersonnelId

Edm.String

PersonnelId

TimeType

Edm.String

Optional The Time Type

ResourceId

Edm.String

Optional The ResourceId, if not Standard ResourceId

QuantityGood

Edm.Decimal

Optional Quantity in Unit of Assembly

QuantityGoodRUoM

Edm.Decimal

Quantity in Unit of Measurement from Routing Position

QuanittyScrap

Edm.Decimal

Optional Quantity Scrap

QuantityScrapRUoM

Edm.Decimal

Optional Quantity Scrap in Unit of measurement from Routing position. Don't define this, if scrap information defined

ExternalCosts

Edm.Decimal

Price

Remarks

Edm.String

a Remark

CostElementId

Edm.String

Optional Cost Element Id

CostCenter

Edm.String

Optional Cost Center

DocDate

Edm.Date

Define the document (Validation) Date

In Beas Userinterface the DocDate and StartDate is always the same
In BSL you must define the DocDate separatly

StartDate

Edm.Date

Start date

Information: StartDateTime is not allowed. Use Start Date and Start Time
Note: if StarDate not today, you must define the DocDate and the Date in Receipt and Issue Document too (Beas 2020.02.01)

[{
   "DocEntry": 6001745,
   "LineNumber": "10",
   "LineNumber2": "10",
   "PersonnelId": "1",
   "QuantityGood": 1,
   "DocDate": "2020/02/28",
   "StartDate": "2020/02/28",
   "EndDate": "2020/02/28",
   "Duration": "75",
   "ResourceId":"R-01-1T.STD.08H",
   "QuantityScrap":0,
   "Remarks": "2554_20_10_4",
   "CloseEntry": false, /* Note: if you set this to true: See CloseEntry */
   "ManualBooking": true,
    "Issue":{"Date":"2020/02/28", "Lines":
        [{"ItemCode":"RM","WhsCode":"01","Quantity":1,"BaseLineNumber2":10,"CloseEntry": false}]},
    "Receipt":{"Date":"2020/02/28", "Lines":
        [{"ItemCode":"FP001","WhsCode":"01","Quantity":1,"CloseEntry": false}]}

}]

StartTime

Edm.String

Start time

EndDate

Edm.Date

Optional End Date. If current Date, you don't need to define this

EndTime

Edm.String

Optional End Time. If current Time, you don't need to define this

FromTimeReceiptRunning

Edm.Integer

Get all information from the TimeReceiptRunning with defined System Number. In this case you don't need to define StartDate or StartTime

The TimeReceiptRunning Entry will be deleted

CloseEntry

Edm.Boolean

if defined as "true", the system will close the routing position

if this the last routing position, the system will related to close the work order position and com

if you want to close the position with receipt assembly, the system will close the receipt position too
You don't need to send the close information to the receipt document

TimeReceipt {
"CloseEntry":true,  /* Last entry. We will close time receipt and work order position */
"Receipt":{
   "Lines":[{
    "ItemCode":"FP",
    "WhsCode":"01",
    "Quantity":2
  }]
  }

}

ManualBooking

Edm.Boolean

Define, if the system create the issue and receipt document automatically, related to the configuration settings or if you define the material self in this post command

"ManualBooking":true

You define the materual for issue in .. "issue":{IssueWo} and "receipt":{receiptWo}

Example:

{"DocEntry":1314,"LineNumber":10,"LineNumber2":10,"PersonnelId":"14","QuantityGood":2,"FromTime":"8:00",

"Issue":{"Lines":[{"ItemCode":"RM","WhsCode":"01","BaseLineNumber2":10}]},

"Receipt":{"Lines":[{"ItemCode":"FP","WhsCode":"01","Quantity":2}]}

}

With the PreAssign object you can read the material, which you need for this time receipt

"ManualBooking":false

The system check configuration wizzard settings and related to this setting the system create the issue / receipt document automatically.

Note: if the assembly is booked on a bin managed warehouse, then this produce an error or an open document

TimeReceiptRunningId

Edm.Integer

The System Number of linked TimeReceiptRunning Object. Define this, if you don't use "FromTimeReceiptRunning", but it's linked to the item.

Needed for calculate Duration

The system will delete the entry after saving

TimeReceiptScrap

Edm.Array

Define Json Array with Scrap Information

[
  {
    "ScrapId":edm.String,
    "Quantity":edm.Decimal,
    "UDF1"..."UDF4":edm.String,
    "ScrapReason":edm.String,
    "Percent":edm.Decimal
  }
]

Quantity in UoM of Routing Position
The system calculate automatically the Scrap Quantity

Duration

Edm.Integer

Duration in Minute

If not defined, the system calculate this autoamtically

Barcode

Edm.String

Optional: Define Document by Routing Barcode
(Not compatible, if you work with parallel Resource)

CalculateDuration

Edm.Bolean

Define, if the system must calculate the duration.
You don't need to set this. If Duration is not defined, the system calculate this always. But it's possible to disable the automatic calculation

Issue

Edm.Json

Define the Issue document for all material positions

Don't define DocEntry or LineNumber. Only LineNumber2 for Bill of Material positions must be defined.

More see Receipt Document

Example:

"Receipt":{"Lines":[{"ItemCode":"FP","WhsCode":"01","Quantity":2}]}

LogInfo

Edm.String

Information about the Time Calculation.

The function TimeReceipt.TimeCalculation return this information.

You must define this, if time Calculation not inside this process

LogInfoHtml

Edm.String

Infomation about the Time Calculation in HTML Format

UDF1...UDF15

Edm.String

UDF 1-15 Beas2020.08

Examples

POST

beas script Create simple time receipt

setvar=ls_json=&
   {"DocEntry":<dw_1.item.belnr_id.value>,"LineNumber":<dw_1.item.belpos_id.value>,"LineNumber2":<dw_1.item.pos_id.value>,&
        "PersonnelId":<dw_1.item.pers_id.value,bsl>,&
        "QuantityGood":<dw_1.item.quantity.value,num(6)>,&
        "StartDate":"<dw_1.item.startdate.value,yyyy/mm/dd>",&
        "StartTime":"<dw_1.item.starttime.value,hh:mm>"&
       }
instance bsl b
b.post=TimeReceipt=<ls_json>
messagebox=<b.ret_code> <b.ret_text> <b.ret_value>

Note:

You must convert all fields in correct form

PersonnelId is a string. We use convert to "bsl" format: "PersonnelId":<dw_1.item.pers_id.value,bsl>

Quantity in international format with "..,num(6)>"

Date in JSON Format yyyy/mm/dd and time in hh:mm, always as String

beas script Create time receipt from TimeReceiptRunning

setvar=ls_json=&
   {"TimeReceiptRunningId":<e_ftstmp_buchnr_id,#0>,&
        "DocEntry":<dw_1.item.belnr_id.value>,"LineNumber":<dw_1.item.belpos_id.value>,"LineNumber2":<dw_1.item.pos_id.value>,&
        "StartDate":"<dw_1.item.start.value,yyyy/mm/dd>",
        "StartTime":"<dw_1.item.start.value,hh:mm",
        "PersonnelId":<dw_1.item.pers_id.value,bsl>,&
        "QuantityGood":<dw_1.item.quantity.value,num(6)>,&
       }

instance bsl b
b.post=TimeReceipt=<ls_json>
messagebox=<b.ret_code> <b.ret_text> <b.ret_value>

Note:

You must define the document from Start Time Receipt (table: BEAS_FTSTMP.BUCHNR_ID, BSL TimeReceiptRunning.DocEntry)

In beas window "Logoff Time Receipt" the information is saved in variable "e_ftstmp_buchnr_id"

HTTP Post time receipt Create simple time receipt

odata4/TimeReceipt

[
  {"DocEntry":644,
   "LineNumber":10,"LineNumber2":10,
   "LineNumber3":0,
   "TimeType":"A",
   "ResourceId":"C003",   // the resource
   "QuantityGood":1,
   "PersonnelId": "1",    // Personal Number
   "QuantityScrap":0,
   "StartDate": "2020/05/29",
   "EndDate": "2020/05/29",
   "StartTime":"10:00",
   "EndTime":"10:30",
   "CloseEntry":false,     // don't close the work order position
   "ManualBooking":true,   // don't book automatically
   "TimeReceiptScrap":[],  // no scrap information
   "Duration":60,
   "CalculateDuration":false, // don't calculate duration
   "Remarks": "posted from bsl"
}]

HTTP Post time receipt: wtith Issue and receipt document

odata4/TimeReceipt

[
  {"DocEntry":644,
  "LineNumber":10,
  "LineNumber2":10,
  "LineNumber3":0,
  "TimeType":"A",
  "ResourceId":"C003",
  "QuantityGood":1,
  "PersonnelId": "1",
  "QuantityScrap":0,
  "StartDate": "2020/05/29",
  "EndDate": "2020/05/29",
  "StartTime":"10:00",
  "EndTime":"10:30",
  "CloseEntry":false,
  "ManualBooking":true,
  "TimeReceiptScrap":[],
  "Duration":60,
  "CalculateDuration":false,
  "Remarks": "posted from bsl",
  "Issue":{
      "Date":"2020/05/29",
      "Lines":[
         {"ItemCode":"030011612",
          "WhsCode":"Mc",
          "Quantity":1,
          "BaseLineNumber2":10
         }
        ]
   },
   "Receipt":{
      "Date":"2020/05/29",
      "Lines": [
          {"ItemCode":"030011800",
           "WhsCode":"Mc",
           "Quantity":1
          }
        ]
   }
  }
]