wotime

Creates Work order-Time-Entry

 

hmtoggle_plus1Important information

The time receipt uses "old" objects which use additional instance variables.

If the variable is defined, the variables have higher priority than the properties.

This functionality cannot be deleted, otherwise compatibility to old customization functions would be lost.

 

Example:

setvar=e_whscode=B

If this variable is defined, the system uses WareHouse "B" for all Bill of Material positions.

 

Problem:

After the first transaction, the system always writes the Default warehouse in the instance variables.

If you make a second transaction in the same window, it uses the same warehouse from the first transaction.

 

Workaround:

Make a sandbox with pushvar and popvar

 

// Save current variables (Sandbox)

pushvar

// now make the time receipt

declare=wotime=...

...

// at end restore all variables

popvar

 

 

Start work time: see wostart

 

 

Method

Function

Description

woreset

Resets all Inputs

addwotimeline, addline, new

Adds a new Row.

Basically you should only work /  add one row at a time.

( Add, Save, Reset )

 

add / save

Saves Data

If you specify a Row Number only this will be stored, otherwise all Rows.

wotime=addline

wotime=add

setrow=x, currentrow=x

Sets the current Position

With <objectname.currentrow> you can get the Current Row

timecalc, timecalculate, zeitberechnung

 

Mandatory fields:

fromtime, fromdate, totime, todate, user

Optional: ftstmpnumber, buchnr_id

 

Result will be stored in <objectname.duration>

declare=wotime=ue_api_time

wotime=addline

wotime=barcode=1000443

if <return> = -1 then

  return failure

end if

wotime=docdate=<today,yyyy/mm/dd>

wotime=fromdate=2006/08/02

wotime=fromtime=10:00

wotime=totime=14:00

wotime=user=5000

wotime=timecalc

wotime=save

destroy=wotime

 

if  you set variable setvar=sys_parallelcalculate=N  , Beas calculates the time without parallel-calculation (ignored other order-messages)

display=y/n

If "N", then prevent queries and Output (for server application)

order_logon

 

This is a part of object ue_bdemodul.

Use this syntax:

object=ue_bdemodul=order_logon=parameter=value<tab>parameter=...<tab>

 

Parameter

belnr_id, belpos_id, pos_id, pers_id,aplatz_id, oldbatchnum, newbatchnum, barcode, timetype_id, typ, date, time

 

Simple Logon

object=ue_bdemodul=order_logon=belnr_id=100<tab>belpos_id=10<tab>pos_id=30<tab>pers_id=5

 

in Variable "returnvalue" you can check, if all ok

if <returnvalue> = true then

 messagebox=ok$ok

end if

if you need this as service or in silend-mode, you can set this

declare=mbde=ue_bdemodul

mbde=display=N

mbde=order_logoin=...

mbde=getmessage

message=<shortmessage> / <longmessage>

destroy=mbde

 

Attention: You need terminal FDC License.

order_logoff

 

You need the "BUCHNR" id from current running

 

select top 1 "BUCHNR_ID" into ll_buchnr_id from "BEAS_FTSTMP" where "PERS_ID"=<ls_pers_id,dbstring> and "BELNR_ID"=<belnr_id>

and "BELPOS_ID"=<belpos_id> and "POS_ID"=<pos_id>

 

declare=wotime=ue_api_time

wotime=addline

wotime=order_logoff=<ll_buchnr_id>

wotime=save

 

Attention: You need terminal FDC License.

 

avaiable with beas 9.3-000-006-000

 

Properties

(beas 9.3 PL2)

Older Versions use "old name"

Property

Old name

Description

AddScrapId

addscrappid

wotime=scrap=5

wotime=addscrappid=scrap_id1=3
wotime=addscrappid=scrap_id2=2

 

Barcode

barcode

Message about BarCode with link to Number Sequence of the work sequence. beas_ftapl.nummer. Automatic  determines belnr_id,belpos_id,pos_id

BPLid

bplid

Branch Id (OBLP.BPLId)

Only for information!

BPLName

bplname

Name of Branch (OBPL.BPLName)

if you set bplid, beas get the name automatically.

Check_Presence

check_presence

true = Check, if the User is presence (only, if activated in the Configuration)

false = disable the User-Presence-Check

Default=true

CloseEntry

close, abgkz

Closes Work Sequence

CloseEntry

cancel

1 = cancellation this entry (price = 0) - other way to delete the entry

CostCenter

costcenter, kstst_id

cost center oprc.prccode determined aus beas_aplatz.kstst_id

CostElementId

timetype_id

Defines Cost Lement (TimeType_id)

Attention: The object don't copy this from Routing position to Time Receipt

If you need this property, you must set this manually.

CurrentRow

currentrow

Sets / Adds Current Row. Only existing rows can be set.

To add a new row you need to use addline

DocDate

docdate

Date for journal entry

only for new entry. You can't change this propertie in an exist entry!

DocEntry

belnr_id

Document Number

Duration

time, minute, dauer, duration

Length in minutes

ExternalCosts

costs, fagprice

Additional costs

FromDate

fromdate

Start Date in Format: yyyy/mm/dd

Also set the end date to "Today"

If you want to set a different end date, use the Command "fromdate"

 

FromMinute

fromminute

from minute (minutes)

FromTime

fromtime

from time in Format: hh:mm

Ftstmp_Buchnr_id

ftstmp_buchnr_id

if you set this, Beas will delete this entry after create the time receipt

Urgend: if you will close the workorder-position, then you must set the variable setvar=e_buchnr_id=<beas_ftstmp_buchnr_id>

LineNumber

belpos_id

Assembly

LineNumber2

pos_id

Work sequence

LineNumber3

resourcenpos_id

see parallel.

Returns the parallel resource of the current work step.

ManualBooking

manualbooking

 

DEFAULT = Yes !! Backflush function is disabled!

If you want to activate the backflush function, you must define the property to "N"

wotime=manualbooking=N

 

Receipt function

If this is the last operation, Beas creates the receipt document.

If you want to overwrite the batch number, you can define this with

setvar=e_setbatchnum=<your batch number>

OrderName

ordername

Name of the Order beas_fthaupt.auftrag

Parallel

parallel

Sets this to J, if this a parallel resource

you need to provide resourcepos_id.

In that case no material posting will take place

PersonnelId

user, pers_id

Employee Number (Personalstamm BEAS beas_personal.pers_id))

Current user is <system.pers_id>

QuanittyGood

quantity, menge_gut

Quantity in Consumption unit of the related Assembly

QuanittyScrap

scrap, menge_schlecht

Rejected quantity in Consumption unit of the related Assembly

QuantityGoodRUoM

quantity_rm

The Confirm UoM can be defined in

Routing Position -> Extended -> Confirm in units and -> Factor per inventory UoM

 

The system calculates
QuantityGoodRUoM * Factor per Invent

 

Example:

Stock Unit = kg

Consumption Unit of Assembly = g

Factor = 1000

 

Routing Position

Confirm Unit = ml

Confirm factor = 3

 

Confirm Quantity in Confirm Unit * Confirm Factor / Consumption Factor = Quantity in Stock Unit

Example:

1ml * 3  = 3 g / 1000 = 0.003 kg

 

Calculation to Stock Unit of Assembly

 

Confirm Quantity in Confirm Unit / Confirm Factor / Consumption Factor = Quantity in Stock Unit

QuantityScrapRUoM

scrap_rm

Rejected quantity [feedback unit]

Remarks

info

Info

ResourceId

workcenter, resource_id, aplatz_id

Work Station beas_aplatz.aplatz_id

RUoM

unit_rm

Feedback unit. If emtpy, storage unit

RUoMFactor

faktor_rm

Amount Inventory per feedback unit (conversion factor)

SetLeaving

setleaving

if active (1, true, yes), then personnel is leaving (time-system)if

SystemNumber

entry, nr

Current Number(If 0 than new)

SystemNumber

nr, entry, load, buchnr_id

Must be set if you work on a a existing Contract.

The parameter you have to pass is the "BEAS_ARBZEIT"."BUCHNR_ID"

wotime.load=dtw.buchnr_id

TimeObligation

timeobligation, bde

Completion confirmation of time is required?

TimeReceiptRunningId

ftstmpnumber

For timecalculate you must set this variable, if you logoff a current timestamp (= "BEAS_FTSTMP"."BUCHNR_ID" )

TimeType

messagetype

set the time type normal time=A, tool time=R, time 2 (H)=H, time 3 (N)=N

ToDate

todate

End-Date in Format yyyy/mm/dd

ToMinute

tominute

bis-minutes

ToolId

wkz_id

the tool-Id (use only, if beas_wkz.choosable=int)

ToTime

totime

to-time

udf=<fieldname>

udf=<fieldname>=<content>

You can add new columns in the table "beas_arbzeit" and can fill this fields with this command

Example: db.ini

column=beas_arbeit=myfield=varchar(50)

Saves a time via wotime

wotime=udf=myfield=hello world

Udf1...15

udf1 ... udf15

UDF  - Field

 

Events

The following Functions will be executed at the time a booking is handled.

Event

Description

workordermanagement:timerecordingstart

Variables

e_belnr_id,e_belpos_id,e_pos_id

e_row: actual row

e_pers_id= employee Number

 

Alternatively, you can access properties of the object:

declare=wotime=ue_api_time

// load a timeorder

wotime=load=10

...

// Booking

function timerecordingstart

if <wotime.belnr_id> n= 20 then

  ...

end if

return true

 

Beas always uses wotime as declaration.

 

The whole process can be aborted with return failure.

 

workordermanagement:timerecordingend

 

Error Messages

Error Messages will be stored in the Variable "errormessage".

ID

Message

1000

Unknown Personal Number

1100

userfunction timerecordingstart() returned "failure"

1101

userfunction timerecordingend() returned "failure"

1102

Unknown  Work Order or

(AE_FAW2) invalid resource (get all information  from BEAS_APLATZ. Entry not found or SQL Error)

1103

already closed

1155

(rueckmeldabgkz43) Preceding work sequence needs to be completed first.

1156

(AW_FAW1AB) Preceding work sequence confirmed. Reported: already posted: .... A confirmation of is impossible

1167

Error select BEAS_FTAPL_WKZ ue_api_time.wo_time Errorplace:1167 (get price from parallel routing position)

1195

(afogrpressource0234) No confirmations possible for group resources. Please select a resource.

1199

error select last quantity from delivery ue_api_time of_wotime (Table PDN1) or

error select sum qty from time receipt (Table BEAS_ARBZEIT)

1330

(bderstanw44) Please log on first in the presence registration!

1441

(afoanmqs95532) Quality assurance in working order sequence is not OK. Registration is not possible!

1442

SQL Error get related QC measure position (BEAS_QSFTMESSUNG)

1443

(afoanmqs9435) In work sequence the QC-inspection has not yet started. Registration is not possible!        

1445

SQL Error search for related QC Order

1500

Booking failed

1600

(AE_STEMP1) Error while writing BDE-Entry

1800

SQL Error loading routing position (not found, wrong itemcode, syntax error)

1801

(fsperrung1) Order (BEAS_FTHAUPT) or Position (BEAS_FTPOS) or routing position (BEAS_FTAPL)  locked or closed or logon for position is locked or Logon on routing position is locked.

You can save a time receipt on closed routing position, if you set setup=fert_afoabgallow=N

1881

(ftstmpminqty234) The minimum value is not reached- Maintenance sequence can not be closed!

1882

(ftstplanqty4954) Planned quantity is exceeded. Planned Quantity ... , Currently receipt ... , Total ....

1888

(ftstmpminbqty523) Minimum quantity not reached. Minimum quantity to confirm

2000

(AE_FAW3FAG) Foreign production step: "Prize entry is compelling, but has not occurred"

2001

(AE_FAW3) Time Entry is compelling, but has not occurred.

2114

Currency not found

9991

Error get old journal entrys