F48001GetRow

F48001 Get Row

Minor Business Rule

Object Name: B4800120

Parent DLL: CMFG

Location: Client/Server

Language: C

Functional Description

Purpose
This function will be used to retrieve a row from the WO Default Coding table (F48001) by the user
input index/key combination.

Setup Notes and Prerequisites
At this time, index one is the only valid index; however, index shall remain a parameter in
consideration of future additions. Partial keys may be used.
1 = WR01, WR02, WR03

Special Logic

Technical Specification




1.Test for a valid key.


2.Read the WO Default Coding table (F48001) by the input index/key combination.


3.If a row exists,


a.Return each row value.


b.Else, return an error.

Data Structure

D4800120 - F48001 Get Row

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szCategoryCode1	WR01	char	NONE	NONE
A user defined code (00/W1) that indicates the current stage or phase of development for a work order. You can assign a work order to only one phase code at a time. Note: Certain forms contain a processing option that allows you to enter a default value for this field. If you enter a default value on a form for which you have set this processing option, the system displays the value in the appropriate fields on any work orders that you create. The system also displays the value on the Project Setup form. You can either accept or override the default value.
szCategoryCode2	WR02	char	NONE	NONE
A user defined code (00/W2) that indicates the type or category of a work order. Note: A processing option for some forms lets you enter a default value for this field. The system enters the default value automatically in the appropriate fields on any work orders that you create on those forms and on the Project Setup form. You can either accept or override the default value.
szCategoryCode3	WR03	char	NONE	NONE
A user defined code (00/W3) that indicates the type or category of the work order. Note: A processing option for some forms allows you to enter a default value for this field. The system enters the default value automatically in the appropriate fields on any work orders that you create on those forms and on the Project Setup form. You can either accept or override the default value.
mnManagerAddressNumber	ANSA	MATH_NUMERIC	NONE	NONE
The address book number of a manager or planner. Note: A processing option for some forms allows you to enter a default value for this field based on values for category codes 1 (Phase), 2, and 3. You set up the default values on the Default Managers and Supervisors form. After you set up the default values and the processing option, the default information displays automatically on any work orders that you create if the category code criterion is met. You can either accept or override the default value.
mnSupervisorAddressNumber	ANPA	MATH_NUMERIC	NONE	NONE
The address book number of the supervisor.
nIndex	INT01	integer	NONE	NONE
Value of the key to fetch on ("1"). ^
nKeys	INT02	integer	NONE	NONE
Number of Days in the Past to Query for Quote Requests Received.
cSuppressErrorMessages	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szErrorMessageID	DTAI	char	NONE	NONE
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

Related Functions

None

Related Tables

F48001 Work Order Default Coding File