Sortings can be set up. For the first sorting you can select from a list of templates or enter an SQL-Order-Statement.
The standard sortings are as follows:
manual sorting: Work orders can be sorted using drag & drop per scenario
planned start: Work orders can be sorted by start time of the manufacturing assembly ("BEAS_FTPOS"."STARTZEIT")
Delivery date: Work orders can be sorted by delivery date of the assembly ("BEAS_FTPOS"."LIEFERDATUM")
Document number: Work orders can be sorted by document number and assembly position number
Project: Work orders can be sorted by project number and start time of the manufacturing assembly
Customer: Work orders can be sorted by customer number and start time of the manufacturing assembly
Item: Work orders can be sorted by item (assembly) and start time of the manufacturing assembly
Priority: Work orders can be sorted by priority ID ("BEAS_FTPOS"."ABGKZ")
For the next two criteria the name and the SQL-Order-Statement is to be entered.
Note: No syntax check is performed by Beas. If an invalid value is entered, this leads to error when opening the planning list. The entered sorting templates are displayed in planning view at the end of the templates list.
Tables BEAS_FTPOS, OITM and BEAS_FTHAUPT are available.
Example: "BEAS_FTHAUPT"."AUFTRAG" sort by order number
To define this, click on the SQL symbol. In the SQL editor you can only see the available tables.
Choose a table and a double-click on all necessary fields
If you execute the SQL statement, you can see the result.
If you click on update, Beas inserts this information in the scheduling window.
Window sys_sqleditor.psr
For more information see SQL Editor.
Tips and tricks (sorting, filter, task descriptions) 10/2017
|