Difference between revisions of "SOP-MES0036 Generic Attribute Maintenance"

From 42Q
Jump to navigation Jump to search
Line 105: Line 105:
 
See below for Generic Attributes descriptions:  
 
See below for Generic Attributes descriptions:  
  
<font size = "5">'''A'''</font>
+
<font size="5">'''A'''</font>  
  
'''add_log_incomplete_container'''
+
'''add_log_incomplete_container'''  
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' set if is allowed to log some reason/information when an incomplete container is closing.
+
'''Description:''' set if is allowed to log some reason/information when an incomplete container is closing.  
  
'''Default Value''': the default value is NO.
+
'''Default Value''': the default value is NO.  
  
'''Module:''' this generic attribute is used in the Muli-Level Containerization module.
+
'''Module:''' this generic attribute is used in the Muli-Level Containerization module.  
  
'''Functionality''': containerization
+
'''Functionality''': containerization  
  
'''System Configuration''': NO
+
'''System Configuration''': NO  
 
 
{|border="0" cellspacing="2" width="100%"
 
|'''ato_so_order_number
 
|'''
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''ato_so_order_number'''
 +
| <br>
 
|}
 
|}
  
'''Table: '''shop_order
+
'''Table: '''shop_order  
 
 
'''Description:''' ato_so_order_number
 
  
'''Default Value''': FALSE
+
'''Description:''' ato_so_order_number
  
'''Module''': N/A
+
'''Default Value''': FALSE
  
'''Functionality''': N/A
+
'''Module''': N/A  
  
'''System Configuration''': N/A
+
'''Functionality''': N/A  
  
<font size = "5">'''C'''</font>
+
'''System Configuration''': N/A
  
'''ctr_export_ftp_dir'''
+
<font size="5">'''C'''</font>
  
'''Table: '''Project
+
'''ctr_export_ftp_dir'''  
  
'''Description:''' it is the directory where the exported container file will be stored.
+
'''Table: '''Project
  
'''Default Value''': N/A
+
'''Description:''' it is the directory where the exported container file will be stored.
  
'''Module''': this generic attribute is used in the Multi-Level Containerization Browser.
+
'''Default Value''': N/A
  
'''Functionality''': this generic attribute is used in the Export Container and Export Filtered Containers.
+
'''Module''': this generic attribute is used in the Multi-Level Containerization Browser.  
  
'''System Configuration''': N/A
+
'''Functionality''': this generic attribute is used in the Export Container and Export Filtered Containers.
  
'''ctr_export_ftp_password'''
+
'''System Configuration''': N/A
  
'''Table: '''Project
+
'''ctr_export_ftp_password'''  
  
'''Description:''' it is the password authentication to access the server where the exported container file will be stored. Multi-Level
+
'''Table: '''Project
  
'''Default Value''': N/A
+
'''Description:''' it is the password authentication to access the server where the exported container file will be stored. Multi-Level
  
'''Module''': this generic attribute is used in the Multi-Level Containerization Browser
+
'''Default Value''': N/A
  
'''Functionality''': export Container and Export Filtered Containers
+
'''Module''': this generic attribute is used in the Multi-Level Containerization Browser
  
'''System Configuration''': N/A
+
'''Functionality''': export Container and Export Filtered Containers
  
'''ctr_export_ftp_server'''
+
'''System Configuration''': N/A
  
'''Table: '''Project
+
'''ctr_export_ftp_server'''  
  
'''Description:''' it is the server address where the exported container file will be stored.
+
'''Table: '''Project
  
'''Default Value''':
+
'''Description:''' it is the server address where the exported container file will be stored.
  
'''Module''': this generic attribute is used in the Multi-Level Containerization Browser
+
'''Default Value''':  
  
'''Functionality''': export container and export filtered Containers
+
'''Module''': this generic attribute is used in the Multi-Level Containerization Browser
  
'''System Configuration''': N/A
+
'''Functionality''': export container and export filtered Containers
  
'''ctr_export_ftp_user'''
+
'''System Configuration''': N/A
  
'''Table: '''Project
+
'''ctr_export_ftp_user'''  
  
{|border="0" cellspacing="2" width="100%"
+
'''Table: '''Project
|'''Description:''' it is the user authentication to access the server where the exported container file will be stored. 
 
|&nbsp;
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''Description:''' it is the user authentication to access the server where the exported container file will be stored.
 +
| &nbsp;
 
|}
 
|}
  
'''Default Value''': N/A
+
'''Default Value''': N/A  
  
'''Module''': this generic attribute is used in the Multi-Level Containerization Browser
+
'''Module''': this generic attribute is used in the Multi-Level Containerization Browser  
  
'''Functionality''': export container and export filtered containers
+
'''Functionality''': export container and export filtered containers  
  
'''System Configuration''': N/A
+
'''System Configuration''': N/A  
  
'''customer_part_number'''
+
'''customer_part_number'''  
  
'''Table: '''shop_order
+
'''Table: '''shop_order  
  
'''Description:''' 150512
+
'''Description:''' 150512  
  
'''Default Value''': FALSE
+
'''Default Value''': FALSE  
  
'''Module''': N/A
+
'''Module''': N/A  
  
'''Functionality''': N/A
+
'''Functionality''': N/A  
  
'''System Configuration''': N/A
+
'''System Configuration''': N/A  
  
<font size = "5">'''D'''</font>
+
<font size="5">'''D'''</font>  
  
'''define_usl_on_release'''
+
'''define_usl_on_release'''  
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' set if is allowed to define the Unit Started Location to the serials when release Shop Order.
+
'''Description:''' set if is allowed to define the Unit Started Location to the serials when release Shop Order.  
  
'''Default Value''': N/A
+
'''Default Value''': N/A  
  
'''Module''': this generic attribute is used in the "Shop Order Release"
+
'''Module''': this generic attribute is used in the "Shop Order Release"  
  
'''Functionality''': N/A
+
'''Functionality''': N/A  
  
'''System Configuration''': N/A
+
'''System Configuration''': N/A  
 
 
<font size = "5">'''F'''</font>
 
  
{|border="0" cellspacing="2" width="100%"
+
<font size="5">'''F'''</font>
|'''frus_child_ctr_export'''
 
|&nbsp;
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''frus_child_ctr_export'''
 +
| &nbsp;
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
 
 
'''Description:''' N/A
 
  
'''Default Value''': YES
+
'''Description:''' N/A
  
'''Module''': N/A
+
'''Default Value''': YES
  
'''Functionality''': N/A
+
'''Module''': N/A  
  
'''System Configuration''': N/A
+
'''Functionality''': N/A  
  
<font size = "5">'''K'''</font>
+
'''System Configuration''': N/A
  
'''kit_complete'''
+
<font size="5">'''K'''</font>
  
'''Table: '''Project
+
'''kit_complete'''  
  
'''Description:''' it forces the user to do the kit with all Top Level Assemblies at the same time.
+
'''Table: '''Project
  
'''Default Value''': NO
+
'''Description:''' it forces the user to do the kit with all Top Level Assemblies at the same time.
  
'''Module''': this generic attribute is used in the Kit Verify
+
'''Default Value''': NO
  
'''Functionality''': kit consolidation
+
'''Module''': this generic attribute is used in the Kit Verify
  
'''System Configuration''': NO
+
'''Functionality''': kit consolidation
  
'''kit_genband_enabled'''
+
'''System Configuration''': NO
  
'''Table: '''Project
+
'''kit_genband_enabled'''  
  
{|border="0" cellspacing="2" width="100%"
+
'''Table: '''Project
|'''Description:''' set if is possible work in Kit verify modules with GenBand project.
 
|&nbsp;
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''Description:''' set if is possible work in Kit verify modules with GenBand project.
 +
| &nbsp;
 
|}
 
|}
  
'''Default Value''': NO
+
'''Default Value''': NO  
 
 
{|border="0" cellspacing="2" width="100%"
 
|'''Module''': this generic attribute is used in the Kit Verify
 
|&nbsp;
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''Module''': this generic attribute is used in the Kit Verify
 +
| &nbsp;
 
|}
 
|}
  
'''Functionality''': kit verify functionalities (Kit Consolidation/Work)
+
'''Functionality''': kit verify functionalities (Kit Consolidation/Work)  
  
'''System Configuration''': NO
+
'''System Configuration''': NO  
  
'''kit_genband_files_path'''
+
'''kit_genband_files_path'''  
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' it is the path of the folder where is stored the genband files.
+
'''Description:''' it is the path of the folder where is stored the genband files.  
  
'''Default Value''': N/A
+
'''Default Value''': N/A  
 
 
{|border="0" cellspacing="2" width="100%"
 
|'''Module''': this generic attribute is used in the Kit Verify
 
|&nbsp;
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''Module''': this generic attribute is used in the Kit Verify
 +
| &nbsp;
 
|}
 
|}
  
'''Functionality''': kit verify functionalities (Kit Consolidation/Work)
+
'''Functionality''': kit verify functionalities (Kit Consolidation/Work)  
  
'''System Configuration''': N/A
+
'''System Configuration''': N/A  
  
<font size = "5">'''L'''</font>
+
<font size="5">'''L'''</font>  
 
 
{|border="0" cellspacing="2" width="100%"
 
|'''label_engine_context'''
 
|&nbsp;
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''label_engine_context'''
 +
| &nbsp;
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
 
 
'''Description:''' N/A
 
  
'''Default Value''': N/A
+
'''Description:''' N/A  
  
'''Module''': this generic attribute is used in the SO / Container
+
'''Default Value''': N/A
  
'''Functionality''': print label
+
'''Module''': this generic attribute is used in the SO / Container
  
'''System Configuration''': TRUE
+
'''Functionality''': print label
  
{|border="0" cellspacing="2" width="100%"
+
'''System Configuration''': TRUE
|'''label_engine_MDS_active
 
|'''
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''label_engine_MDS_active'''
 +
| <br>
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
 
 
'''Description:''' N/A
 
  
'''Default Value''': N/A
+
'''Description:''' N/A  
  
'''Module''': this generic attribute is used in the SO / Container
+
'''Default Value''': N/A
  
'''Functionality''': print label
+
'''Module''': this generic attribute is used in the SO / Container
  
'''System Configuration''': TRUE
+
'''Functionality''': print label
  
{|border="0" cellspacing="2" width="100%"
+
'''System Configuration''': TRUE
|'''label_engine_port'''
 
|&nbsp;
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''label_engine_port'''
 +
| &nbsp;
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' N/A
+
'''Description:''' N/A  
  
'''Default Value''': N/A
+
'''Default Value''': N/A  
  
'''Module''': this generic attribute is used in the SO / Container
+
'''Module''': this generic attribute is used in the SO / Container  
  
'''Functionality''': print label
+
'''Functionality''': print label  
  
'''System Configuration''': TRUE
+
'''System Configuration''': TRUE  
 
 
{|border="0" cellspacing="2" width="100%"
 
|'''label_engine_server
 
|'''
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''label_engine_server'''
 +
| <br>
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' N/A
+
'''Description:''' N/A  
  
'''Default Value''': N/A
+
'''Default Value''': N/A  
  
'''Module''': this generic attribute is used in the SO / Container
+
'''Module''': this generic attribute is used in the SO / Container  
  
'''Functionality''': print label
+
'''Functionality''': print label  
  
'''System Configuration''': TRUE
+
'''System Configuration''': TRUE  
  
'''label_engine_token_JMDS'''
+
'''label_engine_token_JMDS'''  
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' N/A
+
'''Description:''' N/A  
  
'''Default Value''': N/A
+
'''Default Value''': N/A  
  
'''Module''': this generic attribute is used in the SO / Container
+
'''Module''': this generic attribute is used in the SO / Container  
  
'''Functionality''': print label
+
'''Functionality''': print label  
  
'''System Configuration''': TRUE
+
'''System Configuration''': TRUE  
 
 
{|border="0" cellspacing="2" width="100%"
 
|'''label_engine_token_SFDC
 
|'''
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''label_engine_token_SFDC'''
 +
| <br>
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' N/A
+
'''Description:''' N/A  
  
'''Default Value''': N/A
+
'''Default Value''': N/A  
  
'''Module''': this generic attribute is used in the SO / Container
+
'''Module''': this generic attribute is used in the SO / Container  
  
'''Functionality''': print label
+
'''Functionality''': print label  
  
'''System Configuration''': TRUE
+
'''System Configuration''': TRUE  
  
'''labor_tracking_database_name'''
+
'''labor_tracking_database_name'''  
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' Labor Tracking modules access a PostgresSQL database, and then jMDS needs to know which database access.
+
'''Description:''' Labor Tracking modules access a PostgresSQL database, and then jMDS needs to know which database access.  
  
'''Default Value''': N/A
+
'''Default Value''': N/A  
  
'''Module''': this generic attribute is used in the Labor Tracking Maintenance
+
'''Module''': this generic attribute is used in the Labor Tracking Maintenance  
  
'''Functionality''': to have access to all Labor Tracking functionalities
+
'''Functionality''': to have access to all Labor Tracking functionalities  
 
 
{|border="0" cellspacing="2" width="100%"
 
|'''System Configuration''': N/A
 
|&nbsp;
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''System Configuration''': N/A
 +
| &nbsp;
 
|}
 
|}
  
'''labor_tracking_password'''
+
'''labor_tracking_password'''  
 
 
'''Table: '''Project
 
  
'''Description:''' It is the password to access Labor Tracking database.
+
'''Table: '''Project
  
'''Default Value''': N/A
+
'''Description:''' It is the password to access Labor Tracking database.
  
'''Module''': this generic attribute is used in the Labor Tracking Maintenance
+
'''Default Value''': N/A
  
'''Functionality''': To have access to all Labor Tracking functionalities
+
'''Module''': this generic attribute is used in the Labor Tracking Maintenance
  
'''System Configuration''': N/A
+
'''Functionality''': To have access to all Labor Tracking functionalities
  
'''labor_tracking_port'''
+
'''System Configuration''': N/A
  
'''Table: '''Project
+
'''labor_tracking_port'''  
  
'''Description:''' it is the number of the Labor Tracking server port.
+
'''Table: '''Project
  
'''Default Value''': N/A
+
'''Description:''' it is the number of the Labor Tracking server port.
  
'''Module''': this generic attribute is used in the Labor Tracking Maintenance
+
'''Default Value''': N/A
  
'''Functionality''': to have access to all Labor Tracking functionalities
+
'''Module''': this generic attribute is used in the Labor Tracking Maintenance
  
'''System Configuration''': N/A
+
'''Functionality''': to have access to all Labor Tracking functionalities
  
'''labor_tracking_server'''
+
'''System Configuration''': N/A
  
'''Table: '''Project
+
'''labor_tracking_server'''  
  
'''Description:''' it is the Labor Tracking database server address.
+
'''Table: '''Project
  
'''Default Value''': N/A
+
'''Description:''' it is the Labor Tracking database server address.
  
'''Module''': this generic attribute is used in the Labor Tracking Maintenance
+
'''Default Value''': N/A
  
'''Functionality''': To have access to all Labor Tracking functionalities
+
'''Module''': this generic attribute is used in the Labor Tracking Maintenance
  
'''System Configuration''': N/A
+
'''Functionality''': To have access to all Labor Tracking functionalities
  
'''labor_tracking_user'''
+
'''System Configuration''': N/A
  
'''Table: '''Project
+
'''labor_tracking_user'''  
  
'''Description:''' it is the user to access Labor Tracking database.
+
'''Table: '''Project
  
'''Default Value''': N/A
+
'''Description:''' it is the user to access Labor Tracking database.
  
'''Module''': this generic attribute is used in the Labor Tracking Maintenance
+
'''Default Value''': N/A
  
'''Functionality''': To have access to all Labor Tracking functionalities
+
'''Module''': this generic attribute is used in the Labor Tracking Maintenance
  
'''System Configuration''': N/A
+
'''Functionality''': To have access to all Labor Tracking functionalities
  
<font size = "5">'''N'''</font>
+
'''System Configuration''': N/A
  
{|border="0" cellspacing="2" width="100%"
+
<font size="5">'''N'''</font>
|'''next_sokey'''
 
|&nbsp;
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''next_sokey'''
 +
| &nbsp;
 
|}
 
|}
  
'''Table: '''shop_order
+
'''Table: '''shop_order  
  
'''Description:''' 695770
+
'''Description:''' 695770  
  
'''Default Value''': FALSE
+
'''Default Value''': FALSE  
  
'''Module''': this generic attribute is used in the Shop Order
+
'''Module''': this generic attribute is used in the Shop Order  
  
'''Functionality''': N/A
+
'''Functionality''': N/A  
  
'''System Configuration''': N/A
+
'''System Configuration''': N/A  
  
<font size = "5">'''O'''</font>
+
<font size="5">'''O'''</font>  
  
'''oracle_release_default_options and standard_release_default_options'''
+
'''oracle_release_default_options and standard_release_default_options'''  
  
'''Table: '''shop_order
+
'''Table: '''shop_order  
  
'''Description:''' control which options are checked by default in Shop Order Release Wizard
+
'''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
+
'''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
+
'''Module''': Shop Order Release  
  
'''Functionality''': Shop Order Release Wizard
+
'''Functionality''': Shop Order Release Wizard  
  
'''System Configuration''': N/A
+
'''System Configuration''': N/A  
  
'''order_line_qty_chk_warning'''
+
'''order_line_qty_chk_warning'''  
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' set if the Sales Order Line quantity of units assigned can exceed or not.
+
'''Description:''' set if the Sales Order Line quantity of units assigned can exceed or not.  
  
'''Default Value''': N/A
+
'''Default Value''': N/A  
  
'''Module''': N/A
+
'''Module''': N/A  
  
'''Functionality''': N/A
+
'''Functionality''': N/A  
  
'''System Configuration''': N/A
+
'''System Configuration''': N/A  
  
'''original_part_number'''
+
'''original_part_number'''  
  
'''Table: '''shop_order
+
'''Table: '''shop_order  
  
'''Description:''' 150512
+
'''Description:''' 150512  
  
'''Default Value''': FALSE
+
'''Default Value''': FALSE  
  
'''Module''': N/A
+
'''Module''': N/A  
  
'''Functionality''': N/A
+
'''Functionality''': N/A  
  
'''System Configuration''': N/A
+
'''System Configuration''': N/A  
  
<font size = "5">'''P'''</font>
+
<font size="5">'''P'''</font>  
  
'''part_bom_description_column'''
+
'''part_bom_description_column'''  
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' it<nowiki>’</nowiki>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.
+
'''Description:''' it<nowiki>’</nowiki>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
+
'''Default Value''': 3, FALSE  
  
'''Module''': this generic attribute is used in the Part Number Maintenance
+
'''Module''': this generic attribute is used in the Part Number Maintenance  
  
'''Functionality''': To load a BOM structure for the Part Number.
+
'''Functionality''': To load a BOM structure for the Part Number.  
  
'''System Configuration''': N/A
+
'''System Configuration''': N/A  
  
'''part_bom_part_number_column'''
+
'''part_bom_part_number_column'''  
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' it<nowiki>’</nowiki>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.
+
'''Description:''' it<nowiki>’</nowiki>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
+
'''Default Value''': 2, FALSE  
  
'''Module''': this generic attribute is used in the Part Number Maintenance
+
'''Module''': this generic attribute is used in the Part Number Maintenance  
  
'''Functionality''': To load a BOM structure for the Part Number
+
'''Functionality''': To load a BOM structure for the Part Number  
  
'''System Configuration''': N/A
+
'''System Configuration''': N/A  
  
'''part_bom_quantity_column'''
+
'''part_bom_quantity_column'''  
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' it<nowiki>’</nowiki>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.
+
'''Description:''' it<nowiki>’</nowiki>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
+
'''Default Value''': 6, FALSE  
  
'''Module''': this generic attribute is used in the Part Number Maintenance
+
'''Module''': this generic attribute is used in the Part Number Maintenance  
  
'''Functionality''': To load a BOM structure for the Part Number
+
'''Functionality''': To load a BOM structure for the Part Number  
  
'''System Configuration''': N/A
+
'''System Configuration''': N/A  
  
'''part_bom_reference_designator_column'''
+
'''part_bom_reference_designator_column'''  
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' it<nowiki>’</nowiki>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.
+
'''Description:''' it<nowiki>’</nowiki>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
+
'''Default Value''': 7. FALSE  
  
'''Module''': this generic attribute is used in the Part Number Maintenance
+
'''Module''': this generic attribute is used in the Part Number Maintenance  
  
'''Functionality''': To load a BOM structure for the Part Number
+
'''Functionality''': To load a BOM structure for the Part Number  
  
'''System Configuration''': N/A
+
'''System Configuration''': N/A  
  
'''part_bom_revision_column'''
+
'''part_bom_revision_column'''  
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' it<nowiki>’</nowiki>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.
+
'''Description:''' it<nowiki>’</nowiki>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
+
'''Default Value''': 4, FALSE  
  
'''Module''': this generic attribute is used in the Part Number Maintenance
+
'''Module''': this generic attribute is used in the Part Number Maintenance  
  
'''Functionality''': To load a BOM structure for the Part Number
+
'''Functionality''': To load a BOM structure for the Part Number  
 
 
'''System Configuration''': N/A
 
  
'''part_opportunities_joint_errors_column'''
+
'''System Configuration''': N/A
  
'''Table: '''Project
+
'''part_opportunities_joint_errors_column'''  
  
'''Description:''' it<nowiki>’</nowiki>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.
+
'''Table: '''Project
  
'''Default Value''': 7, FALSE
+
'''Description:''' it<nowiki>’</nowiki>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.
  
'''Module''': this generic attribute is used in the Part Number Maintenance
+
'''Default Value''': 7, FALSE
  
'''Functionality''': to load Defect Opportunities for the Part Number.
+
'''Module''': this generic attribute is used in the Part Number Maintenance
  
'''System Configuration''': N/A
+
'''Functionality''': to load Defect Opportunities for the Part Number.
  
'''part_opportunities_process_column'''
+
'''System Configuration''': N/A
  
'''Description:''' it<nowiki>’</nowiki>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.
+
'''part_opportunities_process_column'''  
  
'''Default Value''': 9, FALSE
+
'''Description:''' it<nowiki>’</nowiki>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.
  
'''Module''': this generic attribute is used in the Part Number Maintenance
+
'''Default Value''': 9, FALSE
  
'''Functionality''': to load Defect Opportunities for the Part Number.
+
'''Module''': this generic attribute is used in the Part Number Maintenance
  
'''System Configuration''': N/A
+
'''Functionality''': to load Defect Opportunities for the Part Number.
  
'''part_opportunities_reference_designator_column'''
+
'''System Configuration''': N/A
  
'''Table: '''Project
+
'''part_opportunities_reference_designator_column'''  
  
'''Description:''' it<nowiki>’</nowiki>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
+
'''Table: '''Project
  
'''Default Value''': 4, FALSE
+
'''Description:''' it<nowiki>’</nowiki>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
  
'''Module''': this generic attribute is used in the Part Number Maintenance
+
'''Default Value''': 4, FALSE
  
'''Functionality''': to load Defect Opportunities for the Part Number.
+
'''Module''': this generic attribute is used in the Part Number Maintenance
  
'''System Configuration''': N/A
+
'''Functionality''': to load Defect Opportunities for the Part Number.
  
'''print_current_released'''
+
'''System Configuration''': N/A
  
'''Table: '''Project
+
'''print_current_released'''  
  
'''Description:''' set if is allowed to print the currently released Serial Number or all released
+
'''Table: '''Project
  
'''Default Value''': YES
+
'''Description:''' set if is allowed to print the currently released Serial Number or all released
  
'''Module''': this generic attribute is used in the Shop Order
+
'''Default Value''': YES
  
'''Functionality''': release – export serials to a file
+
'''Module''': this generic attribute is used in the Shop Order
  
'''System Configuration''': N/A
+
'''Functionality''': release – export serials to a file
  
'''print_label_log_on'''
+
'''System Configuration''': N/A
  
'''Table: '''Project
+
'''print_label_log_on'''  
  
'''Description:''' N/A
+
'''Table: '''Project
  
'''Default Value''': NO
+
'''Description:''' N/A
  
'''Module''': N/A
+
'''Default Value''': NO
  
'''Functionality''': print label (labelfmt_v3_buffer)
+
'''Module''': N/A
  
'''System Configuration''': FALSE
+
'''Functionality''': print label (labelfmt_v3_buffer)
  
{|border="0" cellspacing="2" width="100%"
+
'''System Configuration''': FALSE
|'''print_label_log_verbose
 
|'''
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''print_label_log_verbose'''
 +
| <br>
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' N/A
+
'''Description:''' N/A  
  
'''Default Value''': NO
+
'''Default Value''': NO  
  
'''Module''': N/A
+
'''Module''': N/A  
  
'''Functionality''': print label (labelfmt_v3_buffer)
+
'''Functionality''': print label (labelfmt_v3_buffer)  
  
'''System Configuration''': FALSE
+
'''System Configuration''': FALSE  
  
<font size = "5">'''Q'''</font>
+
<font size="5">'''Q'''</font>  
  
'''quantity'''
+
'''quantity'''  
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' N/A
+
'''Description:''' N/A  
  
'''Default Value''': FALSE
+
'''Default Value''': FALSE  
  
'''Module''': this generic attribute is used in the SFDC GUI
+
'''Module''': this generic attribute is used in the SFDC GUI  
  
'''Functionality''': configure Record and repair defects
+
'''Functionality''': configure Record and repair defects  
  
'''System Configuration''': N/A
+
'''System Configuration''': N/A  
  
<font size = "5">'''R'''</font>
+
<font size="5">'''R'''</font>  
 
 
{|border="0" cellspacing="2" width="100%"
 
|'''receive_sit_range_default_optional_attributes
 
|'''
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''receive_sit_range_default_optional_attributes'''
 +
| <br>
 
|}
 
|}
  
'''Table: '''project
+
'''Table: '''project  
 
 
'''Description:''' control which attributes will prompted when receiving a serial number range in SIT
 
  
'''Default Value''': LOT Code, Date Code, MPN
+
'''Description:''' control which attributes will prompted when receiving a serial number range in SIT
  
'''Module''': SIT
+
'''Default Value''': LOT Code, Date Code, MPN
  
'''Functionality''': Receive SIT range
+
'''Module''': SIT  
  
'''System Configuration''': N/A
+
'''Functionality''': Receive SIT range
  
'''recursive_ctr_export'''
+
'''System Configuration''': N/A
  
'''Table: '''Project
+
'''recursive_ctr_export'''  
  
'''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.
+
'''Table: '''Project
  
'''Default Value''': NO
+
'''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.
  
'''Module''': this generic attribute is used in the Containerization Browse
+
'''Default Value''': NO
  
'''Functionality''': export container and export filtered containers
+
'''Module''': this generic attribute is used in the Containerization Browse
  
'''System Configuration''': FALSE
+
'''Functionality''': export container and export filtered containers
  
'''reference_designator'''
+
'''System Configuration''': FALSE
  
'''Table: '''Project
+
'''reference_designator'''  
  
'''Description:''' N/A
+
'''Table: '''Project
  
'''Default Value''': TRUE
+
'''Description:''' N/A
  
'''Module''': this generic attribute is used in the SFDC GUI
+
'''Default Value''': TRUE
  
'''Functionality''': configure Record and repair defects
+
'''Module''': this generic attribute is used in the SFDC GUI
  
'''System Configuration''': N/A
+
'''Functionality''': configure Record and repair defects
  
{|border="0" cellspacing="2" width="100%"
+
'''System Configuration''': N/A
|'''release_sn_block_delay
 
|'''
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''release_sn_block_delay'''
 +
| <br>
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
 
 
'''Description:''' N/A
 
  
'''Default Value''': N/A
+
'''Description:''' Defines the time in seconds that the release process will wait before it begins the next block.
  
'''Module''': this generic attribute is used in the
+
'''Default Value''': Numeric (Seconds)
  
'''Functionality''': N/A
+
'''Module''': this generic attribute is used in the
  
'''System Configuration''': TRUE
+
'''Functionality''': N/A
  
{|border="0" cellspacing="2" width="100%"
+
'''System Configuration''': TRUE
|'''release_sn_block_size'''
 
|&nbsp;
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''release_sn_block_size'''
 +
| &nbsp;
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' N/A
+
'''Description:''' Defines the number of serial numbers to be released per block.
  
'''Default Value''': N/A
+
'''Default Value''': Numeric (Serial Quantity)
  
'''Module''': this generic attribute is used in the
+
'''Module''': this generic attribute is used in the  
  
'''Functionality''': N/A
+
'''Functionality''': N/A  
  
'''System Configuration''': FALSE
+
'''System Configuration''': FALSE  
 
 
{|border="0" cellspacing="2" width="100%"
 
|'''remove_on_hold_log'''
 
|&nbsp;
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''remove_on_hold_log'''
 +
| &nbsp;
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' set if when a rule is removed from the Hold is forced to log it.
+
'''Description:''' set if when a rule is removed from the Hold is forced to log it.  
  
'''Default Value''': NO
+
'''Default Value''': NO  
  
'''Module''': this generic attribute is used in the Mfg Hold
+
'''Module''': this generic attribute is used in the Mfg Hold  
  
'''Functionality''': Release a hold
+
'''Functionality''': Release a hold  
  
'''System Configuration''': FALSE
+
'''System Configuration''': FALSE  
  
'''repair_code'''
+
'''repair_code'''  
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' N/A
+
'''Description:''' N/A  
  
'''Default Value''': FALSE
+
'''Default Value''': FALSE  
  
'''Module''': this generic attribute is used in the SFDC GUI
+
'''Module''': this generic attribute is used in the SFDC GUI  
  
'''Functionality''': configure Record and repair defects
+
'''Functionality''': configure Record and repair defects  
  
'''System Configuration''': N/A
+
'''System Configuration''': N/A  
 
 
{|border="0" cellspacing="2" width="100%"
 
|'''revision_controlled'''
 
|&nbsp;
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''revision_controlled'''
 +
| &nbsp;
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
 
 
'''Description:''' N/A
 
  
'''Default Value''': 1
+
'''Description:''' N/A
  
'''Module''': this generic attribute is used in the Shop Order
+
'''Default Value''': 1
  
'''Functionality''': info
+
'''Module''': this generic attribute is used in the Shop Order
  
'''System Configuration''': TRUE
+
'''Functionality''': info
  
<font size = "5">'''S'''</font>
+
'''System Configuration''': TRUE
  
'''so_control_help_link'''
+
<font size="5">'''S'''</font>
  
'''Table: '''Project
+
'''so_control_help_link'''  
  
'''Description:''' it is the link to Shop Order Control Usage page
+
'''Table: '''Project
  
'''Default Value''': N/A
+
'''Description:''' it is the link to Shop Order Control Usage page
  
'''Module''': this generic attribute is used in the Shop Order Release/Browser
+
'''Default Value''': N/A
  
'''Functionality''': help area inside Shop Order Browse main screen and also inside Shop Order View screen
+
'''Module''': this generic attribute is used in the Shop Order Release/Browser
  
'''System Configuration''': TRUE
+
'''Functionality''': help area inside Shop Order Browse main screen and also inside Shop Order View screen
  
{|border="0" cellspacing="2" width="100%"
+
'''System Configuration''': TRUE
|'''so_linkage_active'''
 
|&nbsp;
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''so_linkage_active'''
 +
| &nbsp;
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
 
 
'''Description:''' set if is allowed to link Shop Orders
 
  
'''Default Value''': YES
+
'''Description:''' set if is allowed to link Shop Orders
  
'''Module''': this generic attribute is used in the Shop Order Release/Browser
+
'''Default Value''': YES
  
'''Functionality''': release moment and Shop Order View screen
+
'''Module''': this generic attribute is used in the Shop Order Release/Browser
  
'''System Configuration''': TRUE
+
'''Functionality''': release moment and Shop Order View screen
  
{|border="0" cellspacing="2" width="100%"
+
'''System Configuration''': TRUE
|'''soms_mes_web_address
 
|'''
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''soms_mes_web_address'''
 +
| <br>
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
 
 
'''Description:''' N/A
 
  
'''Default Value''': NO
+
'''Description:''' N/A
  
'''Module''': this generic attribute is used in the Shop Oder
+
'''Default Value''': NO
  
'''Functionality''': SO Linkage
+
'''Module''': this generic attribute is used in the Shop Oder
  
'''System Configuration''': SO Linkage
+
'''Functionality''': SO Linkage  
  
{|border="0" cellspacing="2" width="100%"
+
'''System Configuration''': SO Linkage
|'''spcparam_putonhold_available'''
 
|&nbsp;
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''spcparam_putonhold_available'''
 +
| &nbsp;
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
 
 
'''Description:''' set if skeleton units must be created or not
 
  
'''Default Value''': N/A
+
'''Description:''' set if skeleton units must be created or not
  
'''Module''': N/A
+
'''Default Value''': N/A  
  
'''Functionality''': N/A
+
'''Module''': N/A  
  
'''System Configuration''': N/A
+
'''Functionality''': N/A  
  
<font size = "5">'''T'''</font>
+
'''System Configuration''': N/A
  
{|border="0" cellspacing="2" width="100%"
+
<font size="5">'''T'''</font>
|'''traceability_warning
 
|'''
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''traceability_warning'''
 +
| <br>
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' N/A
+
'''Description:''' N/A  
  
'''Default Value''': YES
+
'''Default Value''': YES  
  
'''Module''': this generic attribute is used in the Shop Order
+
'''Module''': this generic attribute is used in the Shop Order  
  
'''Functionality''': traceability check;
+
'''Functionality''': traceability check;  
  
'''System Configuration''': N/A
+
'''System Configuration''': N/A  
  
<font size = "5">'''U'''</font>
+
<font size="5">'''U'''</font>  
 
 
{|border="0" cellspacing="2" width="100%"
 
|'''update_pts_data
 
|'''
 
  
 +
{| width="100%" cellspacing="2" border="0"
 +
|-
 +
| '''update_pts_data'''
 +
| <br>
 
|}
 
|}
  
'''Table: '''Project
+
'''Table: '''Project  
  
'''Description:''' N/A
+
'''Description:''' N/A  
  
'''Default Value''': NO
+
'''Default Value''': NO  
  
'''Module''': this generic attribute is used in the SIT
+
'''Module''': this generic attribute is used in the SIT  
  
'''Functionality''': SIT Range maintenance
+
'''Functionality''': SIT Range maintenance  
  
 
'''System Configuration''': N/A
 
'''System Configuration''': N/A
 
  
 
== Document Revision History  ==
 
== Document Revision History  ==

Revision as of 19:42, 18 December 2014

Cirrus > Administration > Generic Attribute Maintenance
Sanmina logo.png


Administration
Generic Attribute
Version MES15 Portal 1.0
Work Instruction


This Work Instruction is Sanmina's corporate standard.
This document is under revision control. The latest revision is located on SanminaNet.
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 Cirrus 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 Cirrus 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 Cirrus Portal and then select the Administration expandable heading located in the menu on the left of the screen.

Figure 1: User Sign-In

SOP-5-I-MDS0022-C LE RA1 Generic Attribute Maintenance 01.jpg


Figure 2: Cirrus Welcome

SOP-5-I-MDS0022-C LE RA1 Generic Attribute Maintenance 02.jpg



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

SOP-5-I-MDS0022-C LE RA1 Generic Attribute Maintenance 03.jpg


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

SOP-5-I-MDS0022-C LE RA1 Generic Attribute Maintenance 04.jpg


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

SOP-5-I-MDS0022-C LE RA1 Generic Attribute Maintenance 05.jpg


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

SOP-5-I-MDS0022-C LE RA1 Generic Attribute Maintenance 06.jpg



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

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

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: Defines the time in seconds that the release process will wait before it begins the next block.

Default Value: Numeric (Seconds)

Module: this generic attribute is used in the

Functionality: N/A

System Configuration: TRUE

release_sn_block_size  

Table: Project

Description: Defines the number of serial numbers to be released per block.

Default Value: Numeric (Serial Quantity)

Module: this generic attribute is used in the

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 the Shop Order

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

Document Revision History

Date Author Title Version Change Reference
02/14/14 Elaine Fonaro Technical Writer v 1.0 This is the first revision of Generic Attribute User Guide.
02/14/14 Ashley Martin Technical Writer v 1.0 General Review and New Images
02/24/14 Elaine Fonaro Technical Writer v 1.0 Formatting for WIKI