Integrated Master

Menu Bar - Table View

GUI overview

The Integrated Master Editor enables you to input master data that is required for scheduling on a single screen. You can also load the master data that has already been entered in multiple tables and edit the data in the Integrated Master Editor.

Selecting [Table View] - [Integrated Master Editor] from the menu opens the Integrated Master Editor containing the current data.

Data Input Rules

In the Integrated Master Editor, you are supposed to specify data for each item.
If an item does not have a process (e.g. raw material), you only enter the item.
If an item has a process(es), you specify the data about the process(es) (operations), resources, and capacity for producing that item.

If those fields necessary for the Intergrated Master Editor are not entered, or a field is incorrectly set, then the background color of the cell will turn yellow to signify the requirement is missing or wrong.
See here for more details.


When you input new data in a Integrated Master Editor row, enter the data in the following order:

1. Item

Usually, enter here the finished item. For items such as common parts, enter the item that is finally produced as parts. You can group data in the Integrated Master Editor by item.

2. Process Number

Enter here the number of the process in which the item is produced. Enter the smallest value in the first process and the biggest value in the last process.

3. Process code

Enter the process code. You can also select the process code from the select box.

4. Instruction type

Instruction types include input instruction, output instruction and use instruction.

Input InstructionRepresents the item that is input to this process.
Use instructionRepresents the resource that is used in this process.
Output instructionRepresents the item that is output from this process.

The "Process selector", "Process selector valid condition", "Task selector", and "Task selector valid condition" fields are not mandatory.Specify a value if necessary.


If you want to specify a process for an item, you will need to enter the following:

  • Zero or more input instructions.
  • Zero or more output instructions.
  • One or more use instructions.

!!!DELETE!!!

Depending on the type of the instruction you selected, properties for which you specify a value will be determined.
Main properties for each instruction type are as follows:

Input Instruction

Property nameSetting
Instruction codeSet a string other than a blank. Normally, “In” is set. Multiple input instructions can be generated by adding different strings, but make sure that input instructions for the same item are not generated.
Item/resourceRepresents the item that is input to this process.
Previous process numberSpecifies the process number of the previous process when explicitly specifying the previous process. (If the immediately preceding process number is the previous process, this does not have to be set.)
ProductionSet here the ratio of the item of the input instruction required for producing one unit of the item that is produced in this process.
Time constraint methodSpecifies the time relationship between this process and previous process. The type of the time constraint method includes ES (End-Start), SS (Start-Start), SSEE (Start-Start, End-End), EES (End-Each-Start) and ESE (End-Start-Each).
Time constraint MINSpecify here the minimum amount of time required to be separated with the previous process according to the time relationship between the processes you specified in the [Time constraint method] field.
Time constraint MAXSpecify here the maximum amount of time allowed to be separated with the previous process according to the time relationship between the processes you specified in the "Time constraint method" field. (To validate this value, you are required to have the Time constraint MAX option.)


Use instruction

Property nameSetting
Instruction codeSpecify here the instruction code for the use instruction.
Item/resourceEnter the resources (equipment, operator, metal mold, tooling, and so on) that are required to produce an item.
SetupSpecify here the setup time.
ProductionSpecify here the capacity when this item is manufactured with these resources.
TeardownSpecify here the teardown time.
Resource priorityWhen there are multiple resources that can produce the same item, specify here the priority of assigning to those resources. A bigger value means higher priority. Note, however, that the resource of the highest priority is not always chosen since Asprova APS assigns resources based on various criteria besides the resource priority.


Output instruction

This is for the item that is output from the process.

Property nameSetting
Instruction codeSet a string other than a blank. Normally, “Out” is set. Multiple output instructions can be generated by adding different strings, but make sure that output instructions for the same item are not generated.
Item/resourceSet the item that is output from this process.


The data you specified in the Integrated Master Editor will immediately be reflected in Asprova APS master data.

Asprova SCP

In Asprova SCP, it just generated one operation for the last process and ignores others.


Data edit in the Integrated Master Editor

In the Integrated Master Editor, there are various operations for editing data.


Data edit

The data can be edited directly in the cell. In case that there are many options for the data in the cell. It can be selected from the drop down list.


Copy and paste

One or several cells or rows can be copied.
Select expected copied cells and click "Edit - Copy", then the data is copied into clipboard.
Select a destination cell and click "Edit - Paste", then copied data will be pasted.
But if the data type of destination cell is different with the one of the copied data, it will NOT be pasted.
In case that one row is copied and pasted, a red "New" tag will be displayed above the row number. It will disappear when the purchase master table is opened again. If you revert the Integrated Master Editor window, the string "New" will disappear.

Please click here for more info about copy and paste.


Fill

One or several cells can be filled at one time.
Select filled cells, move the mouse to the right bottom of selected cells
and the cursor is changed to "+". Then click the left key and drag the mouse.


Fill rule

In case of one cell, the same value will be filled. But if there is number character in the selected filled string, the most left number will be increased by 1 for each time.
When filling multiple cells, the original data selected to be filled is repeatedly filled. But if there is number or date character in the selected filled string, what's more there is a rule for the string, the rule will be applied when new cells is filled.


Column operation

You can change column widths of a table view by placing the mouse cursor between columns and move the boundary with the left mouse button.
If you select multiple columns and then change the column widths as above stated, all of the selected columns will have the same width.

The column width can be changed separately, but you also can set one column with and make all columns' width are the same with the specific column width.

Select columns and drag it by mouse, then the display order can be changed.


Row operation

You can change row heights of a table view by placing the mouse cursor between rows and move the boundary with the left mouse button.
If you select multiple rows and then change the row heights as above stated, all of the selected rows will have the same height.

Normally the height of rows is changed in batch, but by changing the setting, the height of individual rows can be changed.


Popup menu

Right-clicking the mouse on each area of the Integrated Master Editor invokes a corresponding popup menu.


HelpNo.:707000
© Since 1994 Asprova Corporation, All rights reserved.