GS:User Params Window - Revision history

64.122.111.148 at 22:14, 28 June 2006

2006-06-28T22:14:44Z

64.122.111.148 at 22:14, 28 June 2006

2006-06-28T22:14:00Z

64.122.111.148 at 22:13, 28 June 2006

2006-06-28T22:13:41Z

64.122.111.148 at 22:04, 28 June 2006

2006-06-28T22:04:52Z

64.122.111.148 at 18:45, 2 June 2006

2006-06-02T18:45:06Z

64.122.111.148 at 18:43, 2 June 2006

2006-06-02T18:43:51Z

64.122.111.148 at 18:07, 2 June 2006

2006-06-02T18:07:31Z

64.122.111.148 at 18:06, 2 June 2006

2006-06-02T18:06:20Z

64.122.111.148 at 23:42, 1 June 2006

2006-06-01T23:42:14Z

64.122.111.148 at 22:36, 1 June 2006

2006-06-01T22:36:33Z

← Older revision		Revision as of 22:14, 28 June 2006
Line 27:		Line 27:

	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 '''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.		There are no window settings for this window.

@@ Line 26: / Line 26: @@
 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.
+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.

@@ Line 11: / Line 11: @@
 [[Image:UserParam1.gif|500px|Image:UserParam1.gif|500px]]
-The Name and Short Name inputfields take the naming values for the parameter.
+The '''Name''' and '''Short Name''' inputfields take the naming values for the parameter.
 [[Image:UserParam2.gif|500px|Image:UserParam2.gif|500px]]
@@ Line 18: / Line 18: @@
 [[Image:UserParam3.gif|500px|Image:UserParam3.gif|500px]]
-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.
+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]]
-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.
+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.
+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.

@@ Line 3: / Line 3: @@
 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.
+The '''Company''', '''Warehouse''', and '''Table''' fields will be automatically filled in.  They are for information purposes only, and can't be changed.
 [[Image:UserParam1.gif|500px|Image:UserParam1.gif|500px]]

@@ Line 3: / Line 3: @@
 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.
+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]]
-The [Name] and [Short Name] inputfields take the naming values for the parameter.
+The Name and Short Name inputfields take the naming values for the parameter.
 [[Image:UserParam2.gif|500px|Image:UserParam2.gif|500px]]
@@ Line 14: / Line 14: @@
 [[Image:UserParam3.gif|500px|Image:UserParam3.gif|500px]]
-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.
+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]]
-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 Min and 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.
+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.

@@ 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.
 [[Image:UserParam1.gif|500px|Image:UserParam1.gif|500px]]
-Use the <A> and <Z> keys to select the user parameter you wish to set up.
+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: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.
+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]]
-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.
+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.
 [[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.

← Older revision		Revision as of 22:36, 1 June 2006
Line 1:		Line 1:
	User parameters are user-defined fields for containers. Currently, they are 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. Information can been retrieved from the database if desired, as part of the individual parameters.		User parameters are user-defined fields for containers. Currently, they are 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. Information can been retrieved from the database if desired, as part of the individual parameters.

		+	[[Image:UserParam1.gif\|500px\|Image:UserParam1.gif\|500px]]
		+	[[Image:UserParam2.gif\|500px\|Image:UserParam2.gif\|500px]]
		+	[[Image:UserParam3.gif\|500px\|Image:UserParam3.gif\|500px]]
		+	[[Image:UserParam4.gif\|500px\|Image:UserParam4.gif\|500px]]


	There are no window settings for this window.		There are no window settings for this window.