F40318FetchSingle

F40318 Table I/O

Minor Business Rule

Object Name: N3700290

Parent DLL: CMFG

Location: Client/Server

Language: NER

Purpose:

• Select a single record from the Quality Preference file, F40318. Most often used to check if a
record is valid for delete, if found it can not be deleted.

Setup Notes:
• Used to replace table I/O in applications.

Special Logic:
• This function is used to see if either tests or specs exist in the preference file. Specifications
can be passed in the Test ID field in the data structure.

Processing:
• Perform Fetch Single on F40318 with a key of Test ID and Branch/Plant
^

Data Structure

D3700290A - F40318 Fetch Single

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szTestID	QTST	char	REQ	INPUT
The unique identification for a test to be performed on an item. For example: COL Color test DENS Density Test CL-2 Clarity Test
szCostCenter2	MCU2	char	REQ	INPUT
An accounting entity, such as a profit center, department, warehouse location, job, project, workcenter, and so on, required for management reporting.
cErrorCode	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
cStatus	STAW	char	OPT	BOTH
A user-defined code (00/WS) that indicates the approval status.

Related Functions

None

Related Tables

None

F40318VerifyStatusExists

F40318 Table I/O

Minor Business Rule

Object Name: N3700290

Parent DLL: CMFG

Location: Client/Server

Language: NER

Purpose:

• Determines whether a specific combination specific status for a given profile exists on the Quality
Management Profile table, F40318.
• If the "Use Test Sort Sequence" parameter is set to '1', it checks for a match on the following:

Customer (AN8)
Customer Group (CS18)
Item (ITM)
Item Group (IT18)
Expiration Date (EXDJ) - not the Effective Thru date !
Business Unit (MCU)
Status (STAW)
Test Sort Sequence (TSRT) - this is an individual line on a profile

• If the "Use Test Sort Sequence" parameter is not set to '1', it checks for a match on the following:

Customer (AN8)
Customer Group (CS18)
Item (ITM)
Item Group (IT18)
Expiration Date (EXDJ) - not the Effective Thru date !
Business Unit (MCU)
Status (STAW)

• A '1' is returned in the Error Code field and an error code of "0002" if a matching record is not
found.  The Error Code field will be blank if a matching record is found.

Setup Notes:
• Used to verify existence of a record with a particular status on the F40318 table.

Special Logic:
• None.

Processing:
• If the "Use Test Sort Sequence" option is '1', read F40318 with index 3 and all fields through the
Test Sort Seq. No data item populated from input parameters.  If a matching record is not found, return
a '1' in the Error code parameter; otherwise, return blank.
• If the "Use Test Sort Sequence" option is not '1', read F40318 with index 1 and all fields through
the Status data item populated from input parameters.  If a matching record is not found, return a '1'
in the Error code parameter; otherwise, return blank.
^

Data Structure

D3700290B - F40318 Verify Status Exists

Data Item Description        I/ORequiredNotes
AN8          Action Code            I          Y
CS18         Customer Group         I          Y
ITM          Item Number            I          Y
IT18         Item Group             I          Y
EXDJ         Expired Date           I          Y
MCU          Branch Plant           I          Y
STAW         Status                 I          Y
TSRT         Test Sort Seq.         I          Y
EV01         Use Test Sort Seq      I          N     '1' = reads F40318 using Test Sort Seq. No.
EV01         Suppress Error Msgs    I          N     '1' to suppress system error messages
DTAI         Error Message ID       O          N     Returns '0002' if matching record not found
EV01         Error Code             O          N     '1' = no matching record found, blank = matching record found

^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAddressNumber	AN8	MATH_NUMERIC	OPT	NONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
szCustomerGroupQualityManageme	CS18	char	OPT	NONE
User defined code (system 40, type 18) identifying a group to which you can assign customers for the Item/Test Specifications. Do this when the customers are similar and you want to group them together to define preferences quickly and easily. Enter the code that identifies the customer group for which you want to define a preference. You can define the preference for this group alone or for a combination of customer group and item or item group. If you leave both the Customer Number and the Customer Group fields blank, the system applies the preference to all customers.
mnIdentifierShortItem	ITM	MATH_NUMERIC	OPT	NONE
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
szItemGroupQualityManagement	IT18	char	OPT	NONE
User defined code (system 40, type 68) identifying a group to which you can assign items for the Item/Test Specifications. Do this when you have a group of similar items and you want to group them together to define preferences quickly and easily. Enter the code that identifies the item group for which you want to define a preference. You can define the preference for this group alone or for a combination of item group and customer or customer group. If you leave both the Item Number and Item Group fields blank, the system applies the preference to all items
jdDateExpiredJulian1	EXDJ	JDEDATE	OPT	NONE
The date on which a transaction, text message, agreement, obligation, or preference has expired or been completed.
szCostCenter	MCU	char	OPT	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
cStatus9	STAW	char	OPT	NONE
A user-defined code (00/WS) that indicates the approval status.
mnTestSortSequenceNumber	TSRT	MATH_NUMERIC	OPT	NONE
A number used to determine the sort order of tests and specifications within preference profiles (item/test specifications).
cUseTestSortSequenceNo	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cSuppressErrorMsgs	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szErrorMsgID	DTAI	char	OPT	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.
cErrorCode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

None