Difference between revisions of "36:User Params Window"

From coolearthwiki
Jump to: navigation, search
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.  
  
−
Use the <A> and <Z> keys to select the user parameter you wish to set up.
+
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 [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.
  
 
[[Image:UserParam1.gif|500px|Image:UserParam1.gif|500px]]
 
[[Image:UserParam1.gif|500px|Image:UserParam1.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.  
+
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 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.
 
  
 
[[Image:UserParam3.gif|500px|Image:UserParam3.gif|500px]]
 
[[Image:UserParam3.gif|500px|Image:UserParam3.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 [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]]
  
−
The Min and Max values set the length of the field. These are not required to be filled in.
+
The [Min] & [Max] fields denote the minimum and maximum values for the parameter value. The [Default] field holds the default value for the parameter.  
−
 
+
−
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 Hold List is not currently 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 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.
+
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.
  
  
 
There are no window settings for this window.
 
There are no window settings for this window.

Revision as of 13:43, 2 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 [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.

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] & [Max] fields denote the minimum and maximum values for the parameter value. The [Default] field holds the default value for the parameter.

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.


There are no window settings for this window.

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