SOP-MES0036 Generic Attribute Maintenance

42Q Home > Administration > Generic Attribute Maintenance

Administration Generic Attribute Version MES15 Portal 1.0 Work Instruction

This Work Instruction is 42Q's corporate standard. This document is under revision control. The latest revision is located on Intranet. Once printed it is an uncontrolled copy. All alterations to this work instruction require approval. Contact the IT Global Education and Training Department to submit suggested alterations and or updates.

This edition applies to MES15 Portal 1.0 and all subsequent releases and modifications until otherwise indicated in new revisions.

Introduction

Administrative privileges for the <span style="background-color: navy; color: white;" />42Q portal are located in the Administration menu heading. With the portal, Administrators are able to access privileges from one convenient location. Privileges include User Maintenance, Plant Maintenance, Site Maintenance, Profile Maintenance, and Generic Attribute Maintenance. Also located in the Administration menu heading are SFDC Administrator, Document Control, PTS Administrator, and LE Administration.

This work instruction is intended to guide administrators on how to manage and maintain the <span style="background-color: navy; color: white;" />42Q Portal, as well as to provide specific user groups a common sense of portal operation.

To access any of the Administration functionalities, the user must sign into the <span style="background-color: navy; color: white;" />42Q Portal and then select the Administration expandable heading located in the menu on the left of the screen.

Figure 1: User Sign-In

Figure 2: <span style="background-color: navy; color: white;" />42Q Welcome

Generic Attributes Maintenance

The Generic Attributes module allows users to set parameters that will be used at specific MDS modules as described below.

To access the Generic Attribute Maintenance page, navigate to Administration > Generic Attribute Maintenance.

Figure 3: Generic Attribute Maintenance Main Page

The main screen displays all defined generic attributes.

Filter Generic Attributes

The user can filter the results by Table and Attribute Name.

1. Enter the Table or Attribute Name in the appropriate field.

2. Select Filter to filter results or Clear to clear the filter fields.

(NOTE: The user can sort the columns alphabetically by clicking on the Table, Attribute Name, or Value fields.)

Figure 4: Filter Results

Add Generic Attribute

1. To add a Generic Attribute, select Add Generic Attribute located above the generic attribute list.

2. The Generic Attribute Form is displayed:

Figure 5: Add Generic Attribute

3. Select a Table and Attribute Name from the drop-down boxes in the form.

4. Enter a value in the Value field.

5. Select Save to confirm, Reset to clear fields, or Cancel to exit the form.

Editing Generic Attribute

1. To edit a Generic Attribute, select Edit Generic Attribute located above the list of Generic Attributes.

2. The Generic Attribute Form is displayed:

Figure 6: Edit Generic Attribute

NOTE: The user is only able to edit the attribute value. The other fields are not available to be edited.

Generic Attributes Descriptions

See below for Generic Attributes descriptions:

A

add_log_incomplete_container

Table: Project

Description: set if is allowed to log some reason/information when an incomplete container is closing.

Default Value: the default value is NO.

Module: this generic attribute is used in the Muli-Level Containerization module.

Functionality: containerization

System Configuration: NO

ato_so_order_number

Table: shop_order

Description: ato_so_order_number

Default Value: FALSE

Module: N/A

Functionality: N/A

System Configuration: N/A

B

base34_device_number_on

Table: Project
Description: Allows for adding additional device numbers above 999.
Default Value: False
Module: SFDC Configuration
Functionality: Allows device numbers above 999 to be defined, especially for the PCB environment
System Configuration: True


C

ctr_export_ftp_dir

Table: Project

Description: it is the directory where the exported container file will be stored.

Default Value: N/A

Module: this generic attribute is used in the Multi-Level Containerization Browser.

Functionality: this generic attribute is used in the Export Container and Export Filtered Containers.

System Configuration: N/A

ctr_export_ftp_password

Table: Project

Description: it is the password authentication to access the server where the exported container file will be stored. Multi-Level

Default Value: N/A

Module: this generic attribute is used in the Multi-Level Containerization Browser

Functionality: export Container and Export Filtered Containers

System Configuration: N/A

ctr_export_ftp_server

Table: Project

Description: it is the server address where the exported container file will be stored.

Default Value:

Module: this generic attribute is used in the Multi-Level Containerization Browser

Functionality: export container and export filtered Containers

System Configuration: N/A

ctr_export_ftp_user

Table: Project

Description: it is the user authentication to access the server where the exported container file will be stored.

Default Value: N/A

Module: this generic attribute is used in the Multi-Level Containerization Browser

Functionality: export container and export filtered containers

System Configuration: N/A

customer_part_number

Table: shop_order

Description: 150512

Default Value: FALSE

Module: N/A

Functionality: N/A

System Configuration: N/A

D

define_usl_on_release

Table: Project

Description: set if is allowed to define the Unit Started Location to the serials when release Shop Order.

Default Value: N/A

Module: this generic attribute is used in the "Shop Order Release"

Functionality: N/A

System Configuration: N/A

F

frus_child_ctr_export

Table: Project

Description: N/A

Default Value: YES

Module: N/A

Functionality: N/A

System Configuration: N/A

K

kit_complete

Table: Project

Description: it forces the user to do the kit with all Top Level Assemblies at the same time.

Default Value: NO

Module: this generic attribute is used in the Kit Verify

Functionality: kit consolidation

System Configuration: NO

kit_genband_enabled

Table: Project

Description: set if is possible work in Kit verify modules with GenBand project.

Default Value: NO

Module: this generic attribute is used in the Kit Verify

Functionality: kit verify functionalities (Kit Consolidation/Work)

System Configuration: NO

kit_genband_files_path

Table: Project

Description: it is the path of the folder where is stored the genband files.

Default Value: N/A

Module: this generic attribute is used in the Kit Verify

Functionality: kit verify functionalities (Kit Consolidation/Work)

System Configuration: N/A

L

label_engine_context

Table: Project

Description: N/A

Default Value: N/A

Module: this generic attribute is used in the SO / Container

Functionality: print label

System Configuration: TRUE

label_engine_MDS_active

Table: Project

Description: N/A

Default Value: N/A

Module: this generic attribute is used in the SO / Container

Functionality: print label

System Configuration: TRUE

label_engine_port

Table: Project Description: N/A

Default Value: N/A

Module: this generic attribute is used in the SO / Container

Functionality: print label

System Configuration: TRUE

label_engine_server

Table: Project

Description: N/A

Default Value: N/A

Module: this generic attribute is used in the SO / Container

Functionality: print label

System Configuration: TRUE

label_engine_token_JMDS

Table: Project

Description: N/A

Default Value: N/A

Module: this generic attribute is used in the SO / Container

Functionality: print label

System Configuration: TRUE

label_engine_token_SFDC

Table: Project

Description: N/A

Default Value: N/A

Module: this generic attribute is used in the SO / Container

Functionality: print label

System Configuration: TRUE

labor_tracking_database_name

Table: Project

Description: Labor Tracking modules access a PostgresSQL database, and then jMDS needs to know which database access.

Default Value: N/A

Module: this generic attribute is used in the Labor Tracking Maintenance

Functionality: to have access to all Labor Tracking functionalities

System Configuration: N/A

labor_tracking_password

Table: Project

Description: It is the password to access Labor Tracking database.

Default Value: N/A

Module: this generic attribute is used in the Labor Tracking Maintenance

Functionality: To have access to all Labor Tracking functionalities

System Configuration: N/A

labor_tracking_port

Table: Project

Description: it is the number of the Labor Tracking server port.

Default Value: N/A

Module: this generic attribute is used in the Labor Tracking Maintenance

Functionality: to have access to all Labor Tracking functionalities

System Configuration: N/A

labor_tracking_server

Table: Project

Description: it is the Labor Tracking database server address.

Default Value: N/A

Module: this generic attribute is used in the Labor Tracking Maintenance

Functionality: To have access to all Labor Tracking functionalities

System Configuration: N/A

labor_tracking_user

Table: Project

Description: it is the user to access Labor Tracking database.

Default Value: N/A

Module: this generic attribute is used in the Labor Tracking Maintenance

Functionality: To have access to all Labor Tracking functionalities

System Configuration: N/A

N

next_sokey

Table: shop_order

Description: 695770

Default Value: FALSE

Module: this generic attribute is used in the Shop Order

Functionality: N/A

System Configuration: N/A

no_route_assigned_release

Table: shop_order

Description: This attribute controls the release of serials with no route assigned. If TRUE, the Shop Order is allowed to be released without a route assignment, if FALSE the Shop Order is not allowed to be released without a route assignment.

Default Value: TRUE

Module: this generic attribute is used in Shop Order Control.

Functionality: N/A

System Configuration: N/A

no_mapped_shop_order_release

Table: Project

Description: This global setting enables/disables the releases of non-mapped ERP interfaced shop orders.

Default Value: FALSE

Module: this generic attribute is used in Shop Order Control.

Functionality: If TRUE, the user can release a Shop Order with no mapping created. If FALSE, the user cannot release a Shop Order without a mapping created.

System Configuration: N/A

O

oracle_release_default_options and standard_release_default_options

Table: shop_order

Description: control which options are checked by default in Shop Order Release Wizard

Default Value: create_skl, non_sn_batch, def_rev, def_order_line, def_usl, print_label, create_file, create_notes, print_unit_trav, print_wip_unit_trav, print_order_trav, link_so

Module: Shop Order Release

Functionality: Shop Order Release Wizard

System Configuration: N/A

order_line_qty_chk_warning

Table: Project

Description: set if the Sales Order Line quantity of units assigned can exceed or not.

Default Value: N/A

Module: N/A

Functionality: N/A

System Configuration: N/A

original_part_number

Table: shop_order

Description: 150512

Default Value: FALSE

Module: N/A

Functionality: N/A

System Configuration: N/A

P

part_bom_description_column

Table: Project

Description: it’s the position of the column into the file used to load a BOM for a Part Number, which have the Part Number Description information (this position starts in 1), and in the mask field (attr_data) should be informed the name header of this column.

Default Value: 3, FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: To load a BOM structure for the Part Number.

System Configuration: N/A

part_bom_part_number_column

Table: Project

Description: it’s the position of the column into the file used to load a BOM for a Part Number, which have the Part Number Description information (the position starts in 1), and in the mask field (attr_data) should be informed the name header of this column.

Default Value: 2, FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: To load a BOM structure for the Part Number

System Configuration: N/A

part_bom_quantity_column

Table: Project

Description: it’s the position of the column into the file used to load a BOM for a Part Number, which have the item quantity information (the position starts in 1), and in the mask field (attr_data) should be informed the name header of this column.

Default Value: 6, FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: To load a BOM structure for the Part Number

System Configuration: N/A

part_bom_reference_designator_column

Table: Project

Description: it’s the position of the column into the file used to load a BOM for a Part Number, which have the Reference Designator information to the item (this position starts in 1), and in the mask field(attr_data) should be informed the name header of this column.

Default Value: 7. FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: To load a BOM structure for the Part Number

System Configuration: N/A

part_bom_revision_column

Table: Project

Description: it’s the position of the column into the file used to load a BOM for a Part Number, which have the Revision information of the item (this position starts in 1), and in the mask field attr_data) should be informed the name header of this column.

Default Value: 4, FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: To load a BOM structure for the Part Number

System Configuration: N/A

part_opportunities_joint_errors_column

Table: Project

Description: it’s the position of the column into the file used to load Defect Opportunities for a Part Number, which have the Joint Errors information of the Reference Designator for the item (this position starts in 1), and in the mask field(attr_data) should be informed the name header of this column.

Default Value: 7, FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: to load Defect Opportunities for the Part Number.

System Configuration: N/A

part_opportunities_process_column

Description: it’s the position of the column into the file used to load Defect Opportunities for a Part Number, which have the Process information of the Reference Designator for the item (this position starts in 1), and in the mask field(attr_data) should be informed the name header of this column.

Default Value: 9, FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: to load Defect Opportunities for the Part Number.

System Configuration: N/A

part_opportunities_reference_designator_column

Table: Project

Description: it’s the position of the column into the file used to load Defect Opportunities for a Part Number, which have Reference Designator for the item (this position starts in 1), and in the mask field (attr_data) should be informed the name header of this column

Default Value: 4, FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: to load Defect Opportunities for the Part Number.

System Configuration: N/A

print_current_released

Table: Project

Description: set if is allowed to print the currently released Serial Number or all released

Default Value: YES

Module: this generic attribute is used in the Shop Order

Functionality: release – export serials to a file

System Configuration: N/A

print_label_log_on

Table: Project

Description: N/A

Default Value: NO

Module: N/A

Functionality: print label (labelfmt_v3_buffer)

System Configuration: FALSE

print_label_log_verbose

Table: Project

Description: N/A

Default Value: NO

Module: N/A

Functionality: print label (labelfmt_v3_buffer)

System Configuration: FALSE

Q

quantity

Table: Project

Description: N/A

Default Value: FALSE

Module: this generic attribute is used in the SFDC GUI

Functionality: configure Record and repair defects

System Configuration: N/A

R

receive_sit_range_default_optional_attributes

Table: project

Description: control which attributes will prompted when receiving a serial number range in SIT

Default Value: LOT Code, Date Code, MPN

Module: SIT

Functionality: Receive SIT range

System Configuration: N/A

recursive_ctr_export

Table: Project

Description: Set if will be exported only units inside the first level of the Container or all the units inside the Containers child will be exported too.

Default Value: NO

Module: this generic attribute is used in the Containerization Browse

Functionality: export container and export filtered containers

System Configuration: FALSE

reference_designator

Table: Project

Description: N/A

Default Value: TRUE

Module: this generic attribute is used in the SFDC GUI

Functionality: configure Record and repair defects

System Configuration: N/A

release_sn_block_delay

Table: Project

Description: N/A

Default Value: N/A

Module: this generic attribute is used in Shop Order Control.

Functionality: N/A

System Configuration: TRUE

release_sn_block_size

Table: Project

Description: N/A

Default Value: N/A

Module: this generic attribute is used in Shop Order Control.

Functionality: N/A

System Configuration: FALSE

remove_on_hold_log

Table: Project

Description: set if when a rule is removed from the Hold is forced to log it.

Default Value: NO

Module: this generic attribute is used in the Mfg Hold

Functionality: Release a hold

System Configuration: FALSE

repair_code

Table: Project

Description: N/A

Default Value: FALSE

Module: this generic attribute is used in the SFDC GUI

Functionality: configure Record and repair defects

System Configuration: N/A

revision_controlled

Table: Project

Description: N/A

Default Value: 1

Module: this generic attribute is used in Shop Order Control

Functionality: info

System Configuration: TRUE

S

so_control_help_link

Table: Project

Description: it is the link to Shop Order Control Usage page

Default Value: N/A

Module: this generic attribute is used in the Shop Order Release/Browser

Functionality: help area inside Shop Order Browse main screen and also inside Shop Order View screen

System Configuration: TRUE

so_linkage_active

Table: Project

Description: set if is allowed to link Shop Orders

Default Value: YES

Module: this generic attribute is used in the Shop Order Release/Browser

Functionality: release moment and Shop Order View screen

System Configuration: TRUE

soms_mes_web_address

Table: Project

Description: N/A

Default Value: NO

Module: this generic attribute is used in the Shop Oder

Functionality: SO Linkage

System Configuration: SO Linkage

spcparam_putonhold_available

Table: Project

Description: set if skeleton units must be created or not

Default Value: N/A

Module: N/A

Functionality: N/A

System Configuration: N/A

T

traceability_warning

Table: Project

Description: N/A

Default Value: YES

Module: this generic attribute is used in the Shop Order

Functionality: traceability check;

System Configuration: N/A

U

update_pts_data

Table: Project

Description: N/A

Default Value: NO

Module: this generic attribute is used in the SIT

Functionality: SIT Range maintenance

System Configuration: N/A

W

wip_traveler_customer_prefix

Table: Project

Description: Applicable for Customer Part # field

Default Value: NO

Module: this generic attribute is used in the Shop Order – Traveler Report

Functionality: removes the configured value of the Part Number beginning

System Configuration: N/A

wip_traveler_customer_suffix_regex

Table: shop_order

Description: Applicable for Customer Part # field

Default Value: ’’

Module: this generic attribute is used in the Shop Order – Traveler Report

Functionality: Replaces the regex by empty ’’

System Configuration: N/A

wip_traveler_start_operation_sequence

Table: Project

Description: Applicable for Customer Part # field

Default Value: 0

Module: this generic attribute is used in the Shop Order – Traveler Report

Functionality: displays in the list only the op codes > = the set value

System Configuration: N/A

Document Revision History

Date	Author	Title	Version	Change Reference
24/06/13	Elaine Fonaro	Technical Writer	v 1.0	This is the first revision of Generic Attribute User Guide.
28/07/14	Elaine Fonaro	Technical Writer	v 1.0	Added new parameters for SIT and Shop Order
12/02/15	Elaine Fonaro	Technical Writer	v 1.0	Added new parameters for Shop Order Module : ’wip_traveler_customer_prefix’ ’wip_traveler_start_operation_sequence’ ’wip_traveler_customer_suffix_regex’
10/05/15	Ashley Martin	Technical Writer	v 1.0	Added no_route_assigned_release.
10/02/16	Dane Parker	Technical Writer	v 1.0	Added base34_device_number_on.
03/04/16	Elaine Fonaro	Technical Writer	v 1.0	Updated Oracle occurrences to ERP