Difference between revisions of "36:User Params Window"

From coolearthwiki
Jump to: navigation, search
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
User parameters are user-defined fields for containers.  Currently, they are stored in the container detail table in the database.  The fields currently available are UserParamVC1-10, and UserParamF1-5.  They are used for collecting specific information that is not currently available on various screens, or for presenting users with different options in the drop down lists.
+
This window allows the User Parameters for a given Company/Warehouse to be specified.
 +
 
 +
User parameters are user-defined fields for containers.  Currently, they are only stored in the container detail table in the database.  They are used for collecting specific information that is not currently available on various screens, or for presenting users with different options in the drop down lists.
 +
 
 +
The '''Company''', '''Warehouse''', and '''Table''' fields will be automatically filled in.  They are for information purposes only, and can't be changed.
 +
 
 +
The '''Param''' scroll-field designates the parameter being defined.  Use the "A" and "Z" keys to select the user parameter field you wish to set up.
 +
 
 +
;Note:  After the parameter is highlighted, you have to press "Enter" to see any details for that selection.
  
 
[[Image:UserParam1.gif|500px|Image:UserParam1.gif|500px]]
 
[[Image:UserParam1.gif|500px|Image:UserParam1.gif|500px]]
  
−
Use the <A> and <Z> keys to select the user parameter you wish to set up.
+
The '''Name''' and '''Short Name''' inputfields take the naming values for the parameter.
  
 
[[Image:UserParam2.gif|500px|Image:UserParam2.gif|500px]]
 
[[Image:UserParam2.gif|500px|Image:UserParam2.gif|500px]]
  
−
Enter the name to be associated with this user parameter.  This must match a name in Whistle.  To see the currently available names, look in the database table wms_usercols_tbl, in the column named wms_col_name.
 
  
 
[[Image:UserParam3.gif|500px|Image:UserParam3.gif|500px]]
 
[[Image:UserParam3.gif|500px|Image:UserParam3.gif|500px]]
  
−
Enter the short name associated with this user parameter.  This name can also be found in the database table wms_usercols_tbl, in the column wms_col_shortname.
+
The '''Type''' field denotes the field’s data type.  Select the type by using the "A" and "Z" keys to move between the choices.  The currently supported choices are text, datetime, and dropdown.
  
 
[[Image:UserParam4.gif|500px|Image:UserParam4.gif|500px]]
 
[[Image:UserParam4.gif|500px|Image:UserParam4.gif|500px]]
  
−
Enter the type of field that will be used for this user parameter, by using the <A> and <Z> keys to move between the choices.  The currently supported choices are text, datetime, and dropdown.
+
The '''Min''' and '''Max''' fields denote the minimum and maximum values for the parameter value. The '''Default''' field holds the default value for the parameter.  Currently, these fields are not used.
−
 
+
−
The Min and Max values set the length of the field.  These are not required to be filled in.
+
−
 
+
−
The Default field is where you enter any default value you wish to plug into this field.
+
−
 
+
−
The next section contains the names of some of the windows in Whistle.  You need to check any of the windows that you wish this user parameter to appear in.
+
  
−
The Required flag indicates whether or not the user will be required to put a value in this user parameter field or no.  Check it if you want this to be a required field for your users.
+
The next section contains the names of some of the transactions available in Whistle.  You need to check any of the windows that you wish this user parameter to appear in.
  
−
The Hold List is not currently used.
+
The '''Required''' checkbox denotes obligatory use of the parameter.  The '''Hold List''' checkbox denotes use of the parameter in using the value for hold status.  The '''SQL''' text form takes associated SQL statements to be used by the parameter for either validation use, or to populate dropdown lists.
  
−
The SQL column has two uses.  When the type is "dropdown" list, it will get the data used to populate the list.  For other data types, it is used to validate the value entered in the field.
+
When you have finished setting up this user parameter, press "<Save>" to save the entry.
  
  
 
There are no window settings for this window.
 
There are no window settings for this window.

Latest revision as of 17:14, 28 June 2006

This window allows the User Parameters for a given Company/Warehouse to be specified.

User parameters are user-defined fields for containers. Currently, they are only stored in the container detail table in the database. They are used for collecting specific information that is not currently available on various screens, or for presenting users with different options in the drop down lists.

The Company, Warehouse, and Table fields will be automatically filled in. They are for information purposes only, and can't be changed.

The Param scroll-field designates the parameter being defined. Use the "A" and "Z" keys to select the user parameter field you wish to set up.

Note
After the parameter is highlighted, you have to press "Enter" to see any details for that selection.

Image:UserParam1.gif

The Name and Short Name inputfields take the naming values for the parameter.

Image:UserParam2.gif


Image:UserParam3.gif

The Type field denotes the field’s data type. Select the type by using the "A" and "Z" keys to move between the choices. The currently supported choices are text, datetime, and dropdown.

Image:UserParam4.gif

The Min and Max fields denote the minimum and maximum values for the parameter value. The Default field holds the default value for the parameter. Currently, these fields are not used.

The next section contains the names of some of the transactions available in Whistle. You need to check any of the windows that you wish this user parameter to appear in.

The Required checkbox denotes obligatory use of the parameter. The Hold List checkbox denotes use of the parameter in using the value for hold status. The SQL text form takes associated SQL statements to be used by the parameter for either validation use, or to populate dropdown lists.

When you have finished setting up this user parameter, press "<Save>" to save the entry.


There are no window settings for this window.

Retrieved from "http://demo.coolearth.com/index.php?title=36:User_Params_Window&oldid=2175"