Production > Work order general > WO structure > Window setting WO structure view > Customization WO structure view - robinfeng/beashelp GitHub Wiki

Navigation: Production > Work order general > WO structure > Window settings WO structure view: Customization WO structure view No contents entries on this page Contents The work order structure view can not be changed with the normal settings and customizations which beas offers, because different forms are nested. Each row type (work order, assembly, routing etc.) has its own SQL-statement and output form.

To make possible a limited customization nevertheless, to window settings some options have been added. For BOM and routing additional information can be called from data base. The description can be changed for this line type. see window settings WO structure view

Note: Extended knowledge is required for customization.

Example: display quality control plans in routing. Approach:

Window settings -> Routing -> SQL-Template field1: beas_ftapl.qs_id Window settings -> Routing -> Description: bez+" ('+templatefield1+')'

Result: in the view the activity is displayed and next to it in brackets, the quality control plan

Example: display quality control plan only, if one was stored before

Window settings -> Routing -> SQL-Template field1: isnull(beas_ftapl.qs_id,'') Window settings -> Routing -> Description: bez+if(templatefield1='','',' ('+templatefield1+')' )

SQL-statement Direct access on the following tables BOM: beas_ftstl, beas_ftpos, oitm, beas_me Routing: beas_ftapl, beas_aplatz, beas_ftpos, beas_agtyp, beas_me

Statement needs to return a value of type "char" or "varchar". Other data types need to be converted using convert(varchar(50),[fieldname]). Sub-Select-statements need to be put n brackets: (select myfield from [@myTable] where itemcode=beas_ftpos.itemcode)

Description There you can determine, what to display as description. Enter in Datawindow-Syntax. see DataWindow-Syntax

All fields in the window can be accessed. see Debug-Window - "Variable" tab - Button "Local"

返回 主页