BeginDoc

F3711 Test Results MBF

Minor Business Rule

Object Name: N3700150

Parent DLL: CMFG

Location: Client/Server

Language: NER

Purpose:
• Opens and initializes the F3711 and Work Caches.
• Validates Lot/Location
• Retrieves current Lot Status Code
'b7Setup Notes:
• Called from Form Post Dialog is Initialized when in Update Mode
• Called from Form Set Focus on Grid when in Add Mode
'b7
Special Logic:
none

Processing:
Initialize F3711
If Process Edits == '1' (Full Edit)
Perform Data Dictionary Validation (BDDVAL) for following fields:
AN8, MCU, DCTO, KCOO,
Endif
If Item Number is not blank
Validate Item Number
Endif
If Lot Number is not equal to blank or null
Get Lot Process Type from Item Branch file
Validate Item Location
If Invalid Lot/Location

If Lot Process Type == Null, blank or '4'

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnJobnumberA	JOBS	MATH_NUMERIC	OPT	NONE
The job number (work station ID) which executed the particular job.
cSupressErrorMessage	EV02	char	OPT	NONE
An option that specifies the type of processing for an event.
cErrorCode	ERRC	char	OPT	NONE
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document Set Server program (XT4914).
szErrorMessage	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.
szVersion	VERS	char	OPT	NONE
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
szProgramId	PID	char	OPT	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
cDataDictionaryValidation	EV03	char	OPT	NONE
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX, and IZ types. Or, select Derivative Lots Only to display only those transactions that may have created new derivative lot.
mnDocumentOrderInvoiceE	DOCO	MATH_NUMERIC	OPT	NONE
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, and so on.
szOrderType	DCTO	char	OPT	NONE
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents
szCompanyKeyOrderNo	KCOO	char	OPT	NONE
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a sales order, and so on). If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order type, the order company lets you locate the desired document. If you use the regular Next Numbers facility, the order company is not used to assign a next number. In this case, you probably would not use the order company to locate the document.
mnLineNumber	LNID	MATH_NUMERIC	OPT	NONE
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns this number,but in some cases you can override it.
szBranchPlant	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.
szLot	LOTN	char	OPT	NONE
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.
mnCustomerNumber	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.
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
mnTripNumber	TRP	MATH_NUMERIC	OPT	NONE
The number assigned to a trip during direct assignment or trip building. The Trip Depot and the Trip Number fields identify the unique combination of vehicle, registration number, load date, and shift.
mnLogicalCompartmentNumber	LCMP	MATH_NUMERIC	OPT	NONE
The compartment number in a connected vehicle. A connected vehicle is a number of vehicles with compartments. The logical compartment number represents the compartments as if the connected vehicle were one vehicle. The first compartment is closest to the power unit. Example: Three vehicles are connected. The first is the power unit, the second has 4 compartments and the third has 3 compartments. The first 4 logical compartment numbers equal the compartment numbers on the first vehicle. The 5th, 6th, and 7th logical compartments represent the compartments in the second vehicle.
szVehicleId	VEHI	char	OPT	NONE
A unique identification number for a vehicle. This number serves as a primary identifier for a vehicle.
cScreenFormat	EV04	char	OPT	NONE
PeopleSoft event point processing flag 04.
cLotStatusCode	LOTS	char	OPT	NONE
A user defined code (41/L) that indicates the status of the lot. If you leave this field blank, it indicates that the lot is approved. All other codes indicate that the lot is on hold. You can assign a different status code to each location in which a lot resides on Item/Location Information or Location Lot Status Change.
szLotStatusDescription	DSC1	char	OPT	NONE
Brief information about an item; a remark or an explanation.
jdDateLoaded	LOAD	JDEDATE	OPT	NONE
The date that the product from an order line is loaded onto a vehicle for delivery.
szRegistrationLicenseNumbe	RLNO	char	OPT	NONE
Identifies the identification number that appears on the license, permit, or certificate.
szApplicationCode	VC02A	char	OPT	NONE
A generic field that is used as a work field.
mnTripLegNumber	TRPL	MATH_NUMERIC	OPT	NONE
A specific leg of a trip.
szLocation	LOCN	char	OPT	NONE
The storage location from which goods will be moved.
szLocationOrder	LOCN	char	OPT	NONE
The storage location from which goods will be moved.
szLocationPreference	LOCN	char	OPT	NONE
The storage location from which goods will be moved.
szItemNumberOrder	UITM	char	OPT	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szItemNumberPreference	UITM	char	OPT	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szItemNumberAdvTrans	UITM	char	OPT	NONE
A number that the system assigns to an item. It can be in short, long, or third item number format.
szBranchPlantOrder	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.
szBranchPlantPreference	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.
szBranchPlantAdvTrans	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.
cApplicationProcessFlag	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.

Set error
Endif

Else
Get Lot Status Code from  Item Location file
Endif

Endif
Load F3711 header information to output parameters

Data Structure

D3700150A - F3711 Test Results MBF Begin Doc

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnJobnumberA JOBS MATH_NUMERIC OPT NONE

The job number (work station ID) which executed the particular job.

cSupressErrorMessage EV02 char OPT NONE

An option that specifies the type of processing for an event.

cErrorCode ERRC char OPT NONE

This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
Set Server program (XT4914).

szErrorMessage 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.

szVersion VERS char OPT NONE

A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a
menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.

szProgramId PID char OPT NONE

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

cDataDictionaryValidation EV03 char OPT NONE

A radio button that specifies the level at which trace/track result is to be displayed.  Select the Detail to display all transactions except IB, IX,
and IZ types.  Or, select Derivative Lots Only to display only those transactions that may have created new derivative lot.

mnDocumentOrderInvoiceE DOCO MATH_NUMERIC OPT NONE

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on.

szOrderType DCTO char OPT NONE

A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and
should not be changed: P Accounts Payable documents   R Accounts Receivable documents   T Payroll documents   I Inventory documents
O Purchase Order Processing documents   J General Accounting/Joint Interest Billing documents   S Sales Order Processing documents

szCompanyKeyOrderNo KCOO char OPT NONE

A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
sales order, and so on). If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the
order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order
type, the order company lets you locate the desired document. If you use the regular Next Numbers facility, the order company is not used to
assign a next number. In this case, you probably would not use the order company to locate the document.

mnLineNumber LNID MATH_NUMERIC OPT NONE

A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
this number,but in some cases you can override it.

szBranchPlant 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.

szLot LOTN char OPT NONE

A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.

mnCustomerNumber 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.

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

mnTripNumber TRP MATH_NUMERIC OPT NONE

The number assigned to a trip during direct assignment or trip building. The Trip Depot and the Trip Number fields identify the unique
combination of vehicle, registration number, load date, and shift.

mnLogicalCompartmentNumber LCMP MATH_NUMERIC OPT NONE

The compartment number in a connected vehicle. A connected vehicle is a number of vehicles with compartments. The logical
compartment number represents the compartments as if the connected vehicle were one vehicle.  The first compartment is closest to the power
unit. Example:  Three vehicles are connected.  The first is the power unit, the second has 4 compartments and the third has 3 compartments. The first 4
logical compartment numbers equal the compartment numbers on the first vehicle. The 5th, 6th, and 7th logical compartments represent the
compartments in the second vehicle.

szVehicleId VEHI char OPT NONE

A unique identification number for a vehicle. This number serves as a primary identifier for a vehicle.

cScreenFormat EV04 char OPT NONE

PeopleSoft event point processing flag 04.

cLotStatusCode LOTS char OPT NONE

A user defined code (41/L) that indicates the status of the lot. If you leave this field blank, it indicates that the lot is approved. All other codes
indicate that the lot is on hold. You can assign a different status code to each location in which a lot resides on Item/Location Information or
Location Lot Status Change.

szLotStatusDescription DSC1 char OPT NONE

Brief information about an item; a remark or an explanation.

jdDateLoaded LOAD JDEDATE OPT NONE

The date that the product from an order line is loaded onto a vehicle for delivery.

szRegistrationLicenseNumbe RLNO char OPT NONE

Identifies the identification number that appears on the license, permit, or certificate.

szApplicationCode VC02A char OPT NONE

A generic field that is used as a work field.

mnTripLegNumber TRPL MATH_NUMERIC OPT NONE

A specific leg of a trip.

szLocation LOCN char OPT NONE

The storage location from which goods will be moved.

szLocationOrder LOCN char OPT NONE

The storage location from which goods will be moved.

szLocationPreference LOCN char OPT NONE

The storage location from which goods will be moved.

szItemNumberOrder UITM char OPT NONE

A number that the system assigns to an item. It can be in short, long, or third item number format.

szItemNumberPreference UITM char OPT NONE

A number that the system assigns to an item. It can be in short, long, or third item number format.

szItemNumberAdvTrans UITM char OPT NONE

A number that the system assigns to an item. It can be in short, long, or third item number format.

szBranchPlantOrder 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.

szBranchPlantPreference 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.

szBranchPlantAdvTrans 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.

cApplicationProcessFlag EV01 char OPT NONE

An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

None

EditLine
EditLine

F3711 Test Results MBF

Minor Business Rule

Object Name: N3700150

Parent DLL: CMFG

Location: Client/Server

Language: NER

Purpose:
• To handle all editing related to one F3711 record.  Will perform editing for retrieving, adding,
updating or deleting a record.
'b7'b7'b7'b7
Setup Notes:
• Call with Process Edits = 2 (Partial) when called from interactive application (P3711)
• Call with Process Edits = 1 (Full) when called from batch program (R37800)
• Call with Action Code = 'A'dd to add a new record in Row is Exited and Changed
• Call with Action Code = 'C'hange to update an exiting record in Row is Exited and Changed
• Call with Action Code = 'D'elete to perform editing in Delete Button Pressed
'b7'b7'b7'b7
Special Logic:
• none
'b7'b7'b7'b7
Processing:
If Process Edits == Full
Call Data Dictionary Validation (BDDVAL) for the following fields:

QDSP, QSMP, SMPC, ACQT, ACPC, QSSZ, QASZ, TOVR, QUM, PTT, QTC1, QTC2, QTC3, QTC4, QTC5, MFGR,
MRRR, MFGC, PRCR, PRER, SHPR, BLKR, OPRS, BSEQ, TRT, DFCW, QPCD, QSPC, SY, QTID, MCU2, QRTC,
CDEC, QDFC, OPSQ, MMCU, QPRP, TTTY, RSUM,

Endif

Verify Test ID and Branch (N3700040)

If Invalid Test
Set error
Else
If Record Change flag == '1' or '2'

Verify Effective Dates

If Allowed Min and Allowed Max and Target and Preferred Min and Preferred Max and Print Test
and Test Type and Test Method and Result UOM and Property and Number of Samples and Sample
Percentage and Accept Quantity and Accept Percentage and Display Decimals == Blank (or zero)
Get F3701 record
Endif

If Test Type == 'R' or Test Value == blank and Test Type == 'O' or Test Value == blank and
test Type == 'G'

Validate, Convert (B3700010) Allowed Minimum, Allowed Maximum, Preferred Minimum, Preferred
Maximum, Target, Test Value
If any validation fails
Set error
Endif

If Test Override != '1'
Pass/Fail == blank
Endif

If test Value != Blank and test ID != Blank and Validate Error != '1'

If Test Override flag != '1'

If PO PreferredMinMax == '1'

Edit Tests (N3700140) - pass preferred minimum and maximum
Else
Edit Tests (N3700140) - pass allowed minimum and maximum
Endif
Endif

If Date Tested == zero

Get today's date
Endif

If time tested == zero

Get Time
Endif

If Tester == zero and PO Default Tester != zero

Tester == PO Default Tester
Endif
Endif

Endif
Endif
Endif

Write record to Cache (B3700160)

If Error Code == '1'
Set Error
Endif

Data Structure

D3700150B - F3711 Test Results MBF Edit Line

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnJobnumberA JOBS MATH_NUMERIC OPT NONE

The job number (work station ID) which executed the particular job.

cProcessEdits EV01 char OPT NONE

An option that specifies the type of processing for an event.

cActionCode2 ACTN char OPT NONE

A code that specifies the action that is performed. Valid values are: A Add C Change

cDataDictionaryValidation EV02 char OPT NONE

An option that specifies the type of processing for an event.

cSupressErrorMessage EV03 char OPT NONE

A radio button that specifies the level at which trace/track result is to be displayed.  Select the Detail to display all transactions except IB, IX,
and IZ types.  Or, select Derivative Lots Only to display only those transactions that may have created new derivative lot.

cErrorCode ERRC char OPT NONE

This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
Set Server program (XT4914).

szErrorMessage 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.

nCacheRowNumber INT01 integer OPT NONE

Number of Days in Future to Query for Responses Due.

mnDocumentOrderInvoiceE DOCO MATH_NUMERIC OPT NONE

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on.

szOrderType DCTO char OPT NONE

A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and
should not be changed: P Accounts Payable documents   R Accounts Receivable documents   T Payroll documents   I Inventory documents
O Purchase Order Processing documents   J General Accounting/Joint Interest Billing documents   S Sales Order Processing documents

szCompanyKeyOrderNo KCOO char OPT NONE

A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
sales order, and so on). If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the
order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order
type, the order company lets you locate the desired document. If you use the regular Next Numbers facility, the order company is not used to
assign a next number. In this case, you probably would not use the order company to locate the document.

mnLineNumber LNID MATH_NUMERIC OPT NONE

A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
this number,but in some cases you can override it.

szRelatedOrderType RCTO char OPT NONE

A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase
order might be document type OP and might have been created to fill a related work order with document type WO.

szRelatedPoSoNumber RORN char OPT NONE

A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for
informational purposes only.

mnUniqueKeyIDInternal UKID MATH_NUMERIC OPT NONE

This field is a unique number used to identify a record in a file.

szCompanyKeyRelated RKCO char OPT NONE

The key company that is associated with the document number of the related order.

mnRelatedPoSoLineNo RLLN MATH_NUMERIC OPT NONE

A number of the detail line on the related order for which the current order was created. For example, on a purchase order created to fill
open sales orders, this is the line number of the sales order on which the item you are ordering appears.

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.

szLot LOTN char OPT NONE

A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.

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.

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

szTestID QTST char OPT NONE

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 OPT NONE

An accounting entity, such as a profit center, department, warehouse location, job, project, workcenter, and so on, required for management
reporting.

szSpecification QSPC char OPT NONE

The unique identification for a set of tests which need to be performed together. For example:        F-156 - FDA Specification 156        SP34 -
Specification 34

szCostCenterHome HMCU char OPT NONE

The number of the business unit in which the employee generally resides.

mnTestSortSequenceNumber TSRT MATH_NUMERIC OPT NONE

A number used to determine the sort order of tests and specifications within preference profiles (item/test specifications).

szSpecificationRevisionLev QREV char OPT NONE

An alphanumeric character that represents the number of times a specification has changed. To avoid overlapping revisions, the system
verifies that the start dates of revisions are greater than the end dates of other revisions.

szTestValue QVAL char OPT NONE

The result of the performed test.

cPassFailPF QPF char OPT NONE

The value which identifies whether the test passed (P) or failed (F).

cTestoverrideflag TOVR char OPT NONE

The flag which designates whether a test has been overridden. Valid values are:    1   overridden    0   not overridden

szRecordUpdateByUserNa MUSE char OPT NONE

The IBM defined user identification. Used where a second User ID is required (in addition to USER), such as the Financial Reporting
Merge file (F1011) where field name is duplicated.

mnTester ANO MATH_NUMERIC OPT NONE

The address book number of the person who originated the change request. The system verifies this number against the Address Book.

jdDatetested QDAT JDEDATE OPT NONE

The date on which the test was performed.

mnTimetested QTIM MATH_NUMERIC OPT NONE

The time at which the test was performed.

szDispositionCodeQm QDSP char OPT NONE

mnSampleNumber9 SNBR MATH_NUMERIC OPT NONE

A number assigned to a group of tests within the same sample.

mnNumberofSamples QSMP MATH_NUMERIC OPT NONE

The number of samples to be taken for the test.

mnSamplePercentage SMPC MATH_NUMERIC OPT NONE

The percentage of an order quantity that determines the number of samples to create in Test Results Revisions. For example, if the sample
percentage is 50 percent and the order quantity is 10, then 5 samples will be created in Test Results Revisions. Use either this field or
Number of Samples to control how many samples to create. You can use this field only with the order mode of Test Results Revisions. If the
sample percentage is 100 percent, then testing is required for every unit on the order. You cannot use Accept Percentage or Accept Quantity,
since all units on the order must pass for the lot to pass.

mnAcceptQuantity ACQT MATH_NUMERIC OPT NONE

A flag that indicates the quantity of tests that must pass in order for the test sample to pass quality control. The system evaluates this value
when the sample percentage is not equal to 100. To use this accept quantity value, you must complete the following fields on Test Definitions
accordingly:    1       Display/Evaluate    Blank Accept Percentage

mnAcceptPercentage ACPC MATH_NUMERIC OPT NONE

A flag that indicates the percentage of tests that must pass in order for the sample to pass quality control. The system evaluates this value
when the sample percentage is not equal to 100. To use the accept percentage value, you must complete the following fields on Test
Definitions accordingly:    1         Display/Evaluate    Blank Accept Quantity

szSystemCode SY char OPT NONE

A user defined code (98/SY) that identifies a system. Valid values include: 01 Address Book 03B Accounts Receivable 04 Accounts
Payable 09 General Accounting 11 Multicurrency

szUserDefinedCodes RT char OPT NONE

A code that identifies the table that contains user defined codes. The table is also referred to as a UDC type.

szAllowableMinimumValuefut AMIN char OPT NONE

The lowest value for a passing test result.

szAllowableMaximumValuefut AMAX char OPT NONE

The highest value for a passing test result.

szPreferableMinimumValue PMIN char OPT NONE

The lowest value for the preferred test result. This value must be greater than or equal to the allowed minimum value. Use the preferred
minimum value to measure quality to a more precise specification than a customer requests. Processing options for the Certificate of Analysis
program allow you to print the preferred value on the Certificate of Analysis report. Processing options for the Test Revisions program allow you
to evaluate samples against the preferred values.

szPreferableMaximumValue PMAX char OPT NONE

The highest value for the preferred test result. This value must be less than or equal to the allowed maximum value. Use the preferred
maximum value to measure quality to a more precise specification than a customer requests. Processing options for the Certificate of Analysis
program allow you to print the preferred value on the Certificate of Analysis report. Processing options for the Test Revisions program allow you
to evaluate samples against the preferred values.

jdEffectiveFromDate EFFF JDEDATE OPT NONE

A date that indicates one of the following:     o When a component part goes into effect on a bill of material     o When a routing step goes into
effect as a sequence on the routing for an item     o When a rate schedule is in effect The default is the current system date. You can enter
future effective dates so that the system plans for upcoming changes. Items that are no longer effective in the future can still be recorded and
recognized in Product Costing, Shop Floor Management, and Capacity Requirements Planning. The Material Requirements Planning system
determines valid components by effectivity dates, not by the bill of material revision level. Some forms display data based on the effectivity
dates you enter.

jdEffectiveThruDate EFFT JDEDATE OPT NONE

A date that indicates one of the following:     o When a component part is no longer in effect on a bill of material     o When a routing step is no
longer in effect as a sequence on the routing for an item     o When a rate schedule is no longer active The default is December 31 of the
default year defined in the Data Dictionary for Century Change Year. You can enter future effective dates so that the system plans for upcoming
changes. Items that are no longer effective in the future can still be recorded and recognized in Product Costing, Shop Floor Management,
and Capacity Requirements Planning. The Material Requirements Planning system determines valid components by effectivity dates, not by
the bill of material revision level. Some forms display data based on the effectivity dates you enter.

szTargetValue QTRG char OPT NONE

The preferable or target test result within the test results range. As the system does not test against a target value, this field is for your
information only.

mnSampleSize QSSZ MATH_NUMERIC OPT NONE

The quantity of one sample to be taken for the test. As the system does not use this field, it is for your information only.

mnActualSampleSize QASZ MATH_NUMERIC OPT NONE

szQualityUnitofMeasure QUM char OPT NONE

Identifies the unit of measure for a sample you take to test. Examples of units of measure include barrels, gallons, hours, and cubic yards.

cPrintTest109 PTTS char OPT NONE

A code used to determine whether or not a test will be printed on the Certificate of Analysis. The valid values are:    0   The test will not be
printed on the Certificate of Analysis.    1   Print all occurrences of a test on the Certificate of Analysis.    2   Print just the average test result record
when printing the Certificate of Analysis.    3   Print the last occurrence of a test when printing the Certificate of Analysis. The last occurrence will
be the test results record that was entered last using Test Results Revisions.

szTestCategoryCode1 QTC1 char OPT NONE

One of five reporting codes that can be assigned to each test defined.  Use these codes to categorize tests into different groups.  Category
codes are user defined (System 37, types T1 through T5). Examples:        Category code T1 - Test Equipment        Category code T2 - Test
Process

szTestCategoryCode2 QTC2 char OPT NONE

One of five reporting codes that can be assigned to each test defined.  Use these codes to categorize tests into different groups.  Category
codes are user defined (System 37, types T1 through T5). Examples:        Category code T1 - Test Equipment        Category code T2 - Test
Process

szTestCategoryCode3 QTC3 char OPT NONE

One of five reporting codes that can be assigned to each test defined.  Use these codes to categorize tests into different groups.  Category
codes are user defined (System 37, types T1 through T5). Examples:        Category code T1 - Test Equipment        Category code T2 - Test
Process

szTestCategoryCode4 QTC4 char OPT NONE

One of five reporting codes that can be assigned to each test defined.  Use these codes to categorize tests into different groups.  Category
codes are user defined (System 37, types T1 through T5). Examples:        Category code T1 - Test Equipment        Category code T2 - Test
Process

szTestCategoryCode5 QTC5 char OPT NONE

One of five reporting codes that can be assigned to each test defined.  Use these codes to categorize tests into different groups.  Category
codes are user defined (System 37, types T1 through T5). Examples:        Category code T1 - Test Equipment        Category code T2 - Test
Process

cTestType TTTY char OPT NONE

A value that specifies how the system processes tests as you enter test results. Valid values are:    R  Required. Result values must be
within the allowable range for the test to pass. The system does not allow an item to pass quality inspection until you enter results for each
required test.    O  Optional. Result values are optional during results entry. The system does not require the entry of a result for each optional test.
However, if you enter failing results, the item fails quality inspection.    G  Guaranteed. Result values are optional during results entry. You can
control whether Guaranteed tests appear as you enter test results with the Display Test field on Test Revisions. In addition, guaranteed tests
print on the Certificate of Analysis.

cManufacturingOperations MFGR char OPT NONE

A value that specifies whether the system displays the test on the Test Results Revisions form when you access the Test Results
Revisions program (P3711) from any of the following Manufacturing programs:   o  Co-/By-Product Completion (P31115)   o  Super Backflush (P31123)
o  Work Order Time Entry (P311221) If you enter 1 in the grid column or if this option is checked, the system displays the test on the Test
Results Revisions form. You can use this value with the operation sequence and routing type to control the appearance of the test at an operation
or routing type.

cManufacturingReceiptRouting MRRR char OPT NONE

A value that controls whether a test will display on the Test Results Revisions form when you access test results from the Routing
Movement and Disposition (P43250) program when the routed order is a manufacturing work order. Valid values are:    1   The test will appear on Test
Results Revisions.    0   The test will not appear on Test Results Revisions. You can use this value with the operation sequence to control the
appearance of the test at a route operation.

cManufacturingCompletions MFGC char OPT NONE

A value that specifies whether the system displays the test on the Test Results Revisions form when you access the Test Results
Revisions program (P3711) from either of the following Manufacturing programs:   o  Work Order Completions (P31114)   o  Completions Workbench
(P3119) If you enter 1 in the grid column or if this option is checked, the system displays the test on the Test Results Revisions form.

cPurchasingReceipts PRCR char OPT NONE

A value that controls whether a test will display on the Test Results Revisions form when you access test results from either Receipts by
P/O or Receipts by Item (P4312). Valid values are:    1   The test will appear in Test Results Revisions.    0   The test will not appear in Test
Results Revisions.

cPurchasingReceiptRouting PRER char OPT NONE

A value that controls whether the test will display on the Test Results Revisions form when you access test results from Routing Movement
and Disposition (P43250) and the routed order is a purchase order. Valid values are:    1   The test will appear on Test Results Revisions.    0
The test will not appear on Test Results Revisions. You can use this value with the operation sequence to control the appearance of the test
at an operation.

cShipConfirm SHPR char OPT NONE

A value that controls whether the test will display on the Test Results Revisions form when you access test results from the Ship
Confirmation (P4205) program. Valid values are:    1   The test will appear on Test Results Revisions.    0   The test will not appear on Test Results
Revisions.

cBulkLoadConfirm BLKR char OPT NONE

A value that controls whether the test will display on the Test Results Revisions form when you access test results from one of the following
programs:     o Bulk Confirm by Order or Bulk Confirm by Trip (P49510)     o Packaged Load Confirmation (P49530) Valid values are:    1   The
test will appear on Test Results Revisions.    0   The test will not appear on Test Results Revisions.

mnSequenceNoOperations OPSQ MATH_NUMERIC OPT NONE

A number used to indicate an order of succession. In routing instructions, a number that sequences the fabrication or assembly steps in the
manufacture of an item. You can track costs and charge time by operation. In bills of material, a number that designates the routing step in the
fabrication or assembly process that requires a specified component part. You define the operation sequence after you create the routing
instructions for the item. The Shop Floor Management system uses this number in the backflush/preflush by operation process. In engineering
change orders, a number that sequences the assembly steps for the engineering change. For repetitive manufacturing, a number that
identifies the sequence in which an item is scheduled to be produced. Skip To fields allow you to enter an operation sequence that you want to begin
the display of information. You can use decimals to add steps between existing steps. For example, use 12.5 to add a step between steps
12 and 13.

mnOperationSequence OPRS MATH_NUMERIC OPT NONE

The sequence in which the system performs the operations or steps of the route.

mnBubbleSequence BSEQ MATH_NUMERIC OPT NONE

A secondary bill of material sequence number that indicates the drawing bubble number.

szTypeRouting TRT char OPT NONE

A user defined code (40/TR) that indicates the type of routing. You can define different types of routing instructions for different uses. For
example:    M    Standard Manufacturing Routing    RWK  Rework Routing    RSH  Rush Routing You define the routing type on the work order
header. The system then uses the specific type of routing that you define in the work order routing. Product Costing and Capacity Planning systems
use only M type routings.

mnTripNumber TRP MATH_NUMERIC OPT NONE

The number assigned to a trip during direct assignment or trip building. The Trip Depot and the Trip Number fields identify the unique
combination of vehicle, registration number, load date, and shift.

mnLogicalCompartmentNumber LCMP MATH_NUMERIC OPT NONE

The compartment number in a connected vehicle. A connected vehicle is a number of vehicles with compartments. The logical
compartment number represents the compartments as if the connected vehicle were one vehicle.  The first compartment is closest to the power
unit. Example:  Three vehicles are connected.  The first is the power unit, the second has 4 compartments and the third has 3 compartments. The first 4
logical compartment numbers equal the compartment numbers on the first vehicle. The 5th, 6th, and 7th logical compartments represent the
compartments in the second vehicle.

szVehicleId VEHI char OPT NONE

A unique identification number for a vehicle. This number serves as a primary identifier for a vehicle.

mnResultSortSequenceNumber RSQQ MATH_NUMERIC OPT NONE

A sequence number used within the Test Results Revisions programs to maintain the order of tests decided within Item/Test
Specifications.

cTimingofTestFutureUse TTST char OPT NONE

cDefectWriteCode DFCW char OPT NONE

A code used to indicate that a failed test has been written to the Non-Conforming Material file. Valid values are:    1   The failed test has been
recorded to the Non-Conforming Material file    0   Either the test has not failed quality inspection or the failed test has not been recorded in
the Non-Conforming Material file.

szQualityApplicationCode QPCD char OPT NONE

A user defined code that identifies the calling application for Test Result Revisions, for example:    MC Manufacturing Completions    SO Ship
Confirm    PR Purchasing Receipts    EC Load and Delivery Confirm

mnQualityTextIDNumber QTID MATH_NUMERIC OPT NONE

A unique identifier associating a test result with it's generic text.

szTestMethod TMHD char OPT NONE

A description of how to run a quality test. The test method is useful to both your company's Quality Control department and your customers.
For example:        Test: Viscosity        Method: RVF #4 @10RPM        Text: Run the viscosity test on a RVF viscometer with a number 4 spindle
at 10 revolutions per minute.

szResultUnitofMeasure RSUM char OPT NONE

A user defined code (37/UM) that identifies the unit of measure for a test result.  Examples of units of measure include barrels, boxes, cubic
yards, gallons, and hours.

mnAssetItemNumber NUMB MATH_NUMERIC OPT NONE

An 8-digit number that uniquely identifies an asset.

szASTMReference ASTM char OPT NONE

Identifies a recommended testing procedure of the American Society of Testing Material.

szPropertyfutureuse QPRP char OPT NONE

The item attribute that is being tested.

szDefectSource QDFC char OPT NONE

szRootCauseQM QRTC char OPT NONE

szCostCenterAlt MMCU char OPT NONE

A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which
represent lower-level business units, subordinate to it. For example:     o Branch/Plant (MMCU)     o Dept A (MCU)     o Dept B (MCU)     o Job 123
(MCU) Business unit security is based on the higher-level business unit.

szDerivedCalculation DERC char OPT NONE

An algebraic formula that specifies the quantity, price, hours, or a value associated with a rule. The following examples illustrate the syntax
for possible derived calculations: Segment References     o S3 indicates segment 3.     o S3=Piston= indicates segment 3 in item
Piston. Trigonometric and Logarithmic Functions     o SIN(20) indicates the sine of 20.     o COS(S3) indicates the cosine of segment 3.     o TAN(S4) indicates
the tangent of segment 4.     o ARC(S3) indicates the arctangent of segment 3.     o LOG indicates log to base 10.     o LN indicates natural log.
o 2**5 indicates an exponent, 2 to the fifth power. Substring SUBSTR(S10,1,4) indicates that the substring from segment 10 starts at the first
position of the string and includes the first 4 positions. Concatenations CONCAT(S3,S4) combines the values of segments 3 and 4. External
Fields Specifies the fields from non-configurator tables that you want the system to access as part of a calculation. Use the ampersand character
followed by the field name. For example, &T2AMTU(WD) indicates an amount field in the Item Supplemental Database table, and the WD
data type. External Programs Specifies that a program external to the system is to be used for the calculation. Enter the name of the external
program and EXTVAR in the Derived Calculations field. Smart Parts PS4 indicates a smart part number P2000 when the value of segment 4 is
2000.

szUserReservedCode URCD char OPT NONE

This is a 2 position code that is reserved for the user.  JDE does not currently use this field and will not utilize this field in the future.

jdUserReservedDate URDT JDEDATE OPT NONE

This is a 6 position code that is reserved for the user.  JDE does not currently use this field and will not utilize this field in the future.

mnUserReservedAmount URAT MATH_NUMERIC OPT NONE

This is a 15 position code that is reserved for the user.  JDE does not currently use this field and will not utilize this field in the future.

szUserReservedReference URRF char OPT NONE

A 15-position reference that is reserved for the user.  J.D. Edwards does not currently use this field and does not plan to use it in the future.

mnUserReservedNumber URAB MATH_NUMERIC OPT NONE

This is a 8 position code that is reserved for the user.  JDE does not currently use this field and will not utilize this field in the future.

szUserId USER char OPT NONE

The code that identifies a user profile.

szProgramId PID char OPT NONE

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

jdDateUpdated UPMJ JDEDATE OPT NONE

The date that specifies the last update to the file record.

mnTimeOfDay TDAY MATH_NUMERIC OPT NONE

The computer clock in hours:minutes:seconds.

szWorkStationId JOBN char OPT NONE

The code that identifies the work station ID that executed a particular job.

cPOPreferredMinMax EV04 char OPT NONE

PeopleSoft event point processing flag 04.

mnPODefaultTester 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.

mnTripLegNumber TRPL MATH_NUMERIC OPT NONE

A specific leg of a trip.

szLocation LOCN char OPT NONE

The storage location from which goods will be moved.

cRecordChangeFlag EV01 char OPT NONE

An option that specifies the type of processing for an event.

szAllowableMinimumStoreString AMIN char OPT NONE

The lowest value for a passing test result.

szAllowableMaximumStoreString AMAX char OPT NONE

The highest value for a passing test result.

szPreferableMinimumStoreString PMIN char OPT NONE

The lowest value for the preferred test result. This value must be greater than or equal to the allowed minimum value. Use the preferred
minimum value to measure quality to a more precise specification than a customer requests. Processing options for the Certificate of Analysis
program allow you to print the preferred value on the Certificate of Analysis report. Processing options for the Test Revisions program allow you
to evaluate samples against the preferred values.

szPreferableMaximumStoreString PMAX char OPT NONE

The highest value for the preferred test result. This value must be less than or equal to the allowed maximum value. Use the preferred
maximum value to measure quality to a more precise specification than a customer requests. Processing options for the Certificate of Analysis
program allow you to print the preferred value on the Certificate of Analysis report. Processing options for the Test Revisions program allow you
to evaluate samples against the preferred values.

szTargetStoreString QTRG char OPT NONE

The preferable or target test result within the test results range. As the system does not test against a target value, this field is for your
information only.

szTestValueStoreString QVAL char OPT NONE

The result of the performed test.

cDataDisplayDecimals CDEC char OPT NONE

A value that designates the number of decimals in the currency, amount, or quantity fields the system displays. For example, U.S. Dollars
would be 2  decimals, Japanese Yen would be no decimals, and Cameroon Francs would be 3  decimals.

mnTextIDNumberPreferences TXID MATH_NUMERIC OPT NONE

Unique identifier associating a preference with it's generic text.

cPOSysSampNum_EV01 EV01 char OPT NONE

An option that specifies the type of processing for an event.

jdOrderTransactionDate TRDJ JDEDATE OPT NONE

The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing.

szFromResultUM FRMRSUM char OPT NONE

A user defined code (37/UM) that identifies the From unit of measure used to convert a test result.  Examples of units of measure include
barrels, boxes, cubic yards, gallons, and hours.

szFromResultValue FRMRSVAL char OPT NONE

Result used as the From value to convert the result.

mnQualityMgmtAB3 QMAB3 MATH_NUMERIC OPT NONE

Reserved for Quality Management.

szQualityMgmtCode3 QMCD3 char OPT NONE

Reserved for Quality Management.

jdQualityMgmtDate3 QMDT3 JDEDATE OPT NONE

Reserved for Quality Management.

mnQualityMgmtNumeric3 QMNUM3 MATH_NUMERIC OPT NONE

Reserved for Quality Management.

szQualityMgmtReference3 QMRF3 char OPT NONE

Reserved for Quality Management.

jdResultExpirationDate RSEXPD JDEDATE OPT NONE

The expiration date for a result.  In Blend Management a result will not be carried forward if it has expired.  The expiration date is calculated
using the result duration in the test definition.

cResultEntryStatus RSSTS char OPT NONE

A code used to determine if the test result was created from a blend rule.

szTestResultName TSTRSNM char OPT NONE

Unique name used to group test results.

nOperationID WOPID integer OPT NONE

mnVesselID WVID MATH_NUMERIC OPT NONE

Unique identifier of any container used to store wine.

cVesselClass WVTY char OPT NONE

Vessel Class specifies the kind of vessel.  Examples of vessel classes are tanks, barrels, puncheons, barrel collections and VBTs.

szBlendLotNumber WLOTN char OPT NONE

A number that identifies a Blend Lot.  A lot is a group of items with similar characteristics.

szResultConversionID RSCONVID char OPT NONE

Indicates the conversion table ID to use to convert a test result.  For example, a test result is entered in Fahrenheit but must be recorded in
Celsius.

Related Functions

None

Related Tables

None

F3711EndDoc
F3711EndDoc

F3711 Test Results MBF

Minor Business Rule

Object Name: N3700150

Parent DLL: CMFG

Location: Client/Server

Language: NER

Purpose:
• Will write Cache records to F3711
• Call Evaluate BSFN and and return a pass/fail Lot Status
• Destroy or clear all the Caches
• Closes all open tables
• 'b7
Setup Notes:
• Called from OK Button - Post Button Clicked.
• 'b7
Special Logic:
• none
• 'b7
Function Outline:
If the Process Edits does not = NO_EDITS
Reset F3711 Cache Cursor to first record in F3711 Cache
While the fetch to the F3711 cache is successful call N3700180 to update F3711
If the Cache fetched record's Changed Flag = '1'
Add the record to the F3711
Else If the Cache fetched record's Changed Flag = '2'
Fetch the F3711 record using the Cache's Order Number, Order Type, Key Company, Line
Number, Lot, Location, Item, Branch, Trip Leg, Compartment and Test Sort Sequence as keys
If the fetch to the Table is successful
Load the cache values to the table structure
Update the F3711 table record
End If
Else If the Cache fetched record's Changed Flag = '3'
Delete the record from the F3711
End If
Call Evaluate BSFN (B3700190)
If Pass/Fail (WF) == Fail
Lot Status Code = PO Failed Lot Status
Else If Pass/Fail (WF) == Pass
Lot Status Code = PO Passing Lot Status
Endif
End If

Data Structure

D3700150C - F3711 Test Results MBF End Doc

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnJobnumberA JOBS MATH_NUMERIC OPT NONE

The job number (work station ID) which executed the particular job.

cProcessEdits EV01 char OPT NONE

An option that specifies the type of processing for an event.

cSuppressErrorMessages EV02 char OPT NONE

An option that specifies the type of processing for an event.

cErrorCode ERRC char OPT NONE

This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
Set Server program (XT4914).

szErrorMessage 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.

cLotStatusCode LOTS char OPT NONE

A user defined code (41/L) that indicates the status of the lot. If you leave this field blank, it indicates that the lot is approved. All other codes
indicate that the lot is on hold. You can assign a different status code to each location in which a lot resides on Item/Location Information or
Location Lot Status Change.

szLot LOTN char OPT NONE

A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.

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

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.

szLocation LOCN char OPT NONE

The storage location from which goods will be moved.

cPONonConforming EV01 char OPT NONE

An option that specifies the type of processing for an event.

mnAddressNumberShipTo SHAN MATH_NUMERIC OPT NONE

The address number of the location to which you want to ship this order. The address book provides default values for customer address,
including street, city, state, zip code, and country.

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.

mnUnitsTransactionQty UORG MATH_NUMERIC OPT NONE

The quantity of units affected by this transaction.

mnDocumentOrderInvoiceE DOCO MATH_NUMERIC OPT NONE

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on.

szOrderType DCTO char OPT NONE

A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and
should not be changed: P Accounts Payable documents   R Accounts Receivable documents   T Payroll documents   I Inventory documents
O Purchase Order Processing documents   J General Accounting/Joint Interest Billing documents   S Sales Order Processing documents

szCompanyKeyOrderNo KCOO char OPT NONE

A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
sales order, and so on). If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the
order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order
type, the order company lets you locate the desired document. If you use the regular Next Numbers facility, the order company is not used to
assign a next number. In this case, you probably would not use the order company to locate the document.

mnLineNumber LNID MATH_NUMERIC OPT NONE

A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
this number,but in some cases you can override it.

mnTripNumber TRP MATH_NUMERIC OPT NONE

The number assigned to a trip during direct assignment or trip building. The Trip Depot and the Trip Number fields identify the unique
combination of vehicle, registration number, load date, and shift.

mnTripLegNumber TRPL MATH_NUMERIC OPT NONE

A specific leg of a trip.

mnLogicalCompartmentNumber LCMP MATH_NUMERIC OPT NONE

The compartment number in a connected vehicle. A connected vehicle is a number of vehicles with compartments. The logical
compartment number represents the compartments as if the connected vehicle were one vehicle.  The first compartment is closest to the power
unit. Example:  Three vehicles are connected.  The first is the power unit, the second has 4 compartments and the third has 3 compartments. The first 4
logical compartment numbers equal the compartment numbers on the first vehicle. The 5th, 6th, and 7th logical compartments represent the
compartments in the second vehicle.

szVehicleId VEHI char OPT NONE

A unique identification number for a vehicle. This number serves as a primary identifier for a vehicle.

cPOPreferredMinMax EV01 char OPT NONE

An option that specifies the type of processing for an event.

cPOPassingLotStatus EV01 char OPT NONE

An option that specifies the type of processing for an event.

cPOFailedLotStatus EV01 char OPT NONE

An option that specifies the type of processing for an event.

cPOCopyGenericText EV01 char OPT NONE

An option that specifies the type of processing for an event.

szProgramId PID char OPT NONE

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

cPOSysSampNum_EV01 EV01 char OPT NONE

An option that specifies the type of processing for an event.

szPlanningDepot VMCU char OPT NONE

Indicates the depot from which a trip originates. The Trip Depot and the Trip Number fields identify the unique combination of vehicle,
registration number, load date, and shift.

szQualityApplicationCode QPCD char OPT NONE

A user defined code that identifies the calling application for Test Result Revisions, for example:    MC Manufacturing Completions    SO Ship
Confirm    PR Purchasing Receipts    EC Load and Delivery Confirm

Related Functions

None

Related Tables

None

F3711TerminateCache
F3711TerminateCache

F3711 Test Results MBF

Minor Business Rule

Object Name: N3700150

Parent DLL: CMFG

Location: Client/Server

Language: NER

Purpose:
• Terminates Cache

Setup Notes:
• Called from EndDoc and Cancel Button  Post Button Clicked

Special Logic:
• none

Processing:
Terminates Cache

^

Data Structure

D3700150D - F3711 Test Results MBF Terminate Cache

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnJobnumberA JOBS MATH_NUMERIC REQ INPUT

The job number (work station ID) which executed the particular job.

Related Functions

None

Related Tables

None

F3711UpdateLotStatus
F3711UpdateLotStatus

F3711 Test Results MBF

Minor Business Rule

Object Name: N3700150

Parent DLL: CMFG

Location: Client/Server

Language: NER

Purpose:
• Creates the Lot Master
• Creates Item location  and Cardex records
• Updates the Lot Status Code for the Lot Master and creates Cardex for changed Lot Status Code
• Updates the Lot Status Code for the Item Location records based on the processing option and creates
Cardex for changed Lot Status Code

Setup Notes:
• Called from OK button - Post Button Clicked; directly after End Doc

Special Logic:
• none

Processing:
Adds/updates Lot Master Record
Check for existence of Item Location record
If Item Location record does not exist
Write Item Location record and Cardex
Endif
Only update Lot master and Location if Lot Status Code changed
If Lot Status Flag  = 1
Update Lot Status Code in Lot Master and write Cardex record
If PO Lot Status Update = 1
Update Lot Status Code for all locations
Else If PO Lot Status Update = 2
Call Item Location Window
Endif
Endif

Data Structure

D3700150E - F3711 Test Results MBF Update Lot Status

Parameter Name Data Item Data Type Req/Opt I/O/Both

szLot LOTN char OPT NONE

A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.

szLocation LOCN char OPT NONE

The storage location from which goods will be moved.

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.

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

mnDocumentOrderInvoiceE DOCO MATH_NUMERIC OPT NONE

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on.

szOrderType DCTO char OPT NONE

A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and
should not be changed: P Accounts Payable documents   R Accounts Receivable documents   T Payroll documents   I Inventory documents
O Purchase Order Processing documents   J General Accounting/Joint Interest Billing documents   S Sales Order Processing documents

szCompanyKeyOrderNo KCOO char OPT NONE

A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
sales order, and so on). If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the
order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order
type, the order company lets you locate the desired document. If you use the regular Next Numbers facility, the order company is not used to
assign a next number. In this case, you probably would not use the order company to locate the document.

cLotStatusCode LOTS char OPT NONE

A user defined code (41/L) that indicates the status of the lot. If you leave this field blank, it indicates that the lot is approved. All other codes
indicate that the lot is on hold. You can assign a different status code to each location in which a lot resides on Item/Location Information or
Location Lot Status Change.

cPOLotStatusUpdate EV01 char OPT NONE

An option that specifies the type of processing for an event.

szProgramId PID char OPT NONE

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

cLotStatusChange EV01 char OPT NONE

An option that specifies the type of processing for an event.

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.

Related Functions

None

Related Tables

None

es into effect on a bill of material     o When a routing step goes into
effect as a sequence on the routing for an item     o When a rate schedule is in effect The default is the current system date. You can enter
future effective dates so that the system plans for upcoming changes. Items that are no longer effective in the future can still be recorded and
recognized in Product Costing, Shop Floor Management, and Capacity Requirements Planning. The Material Requirements Planning system
determines valid components by effectivity dates, not by the bill of material revision level. Some forms display data based on the effectivity
dates you enter.
jdEffectiveThruDateEFFTJDEDATEOPTNONE
A date that indicates one of the following:     o When a component part is no longer in effect on a bill of material     o When a routing step is no
longer in effect as a sequence on the routing for an item     o When a rate schedule is no longer active The default is December 31 of the
default year defined in the Data Dictionary for Century Change Year. You can enter future effective dates so that the system plans for upcoming
changes. Items that are no longer effective in the future can still be recorded and recognized in Product Costing, Shop Floor Management,
and Capacity Requirements Planning. The Material Requirements Planning system determines valid components by effectivity dates, not by
the bill of material revision level. Some forms display data based on the effectivity dates you enter.
szTargetValueQTRGcharOPTNONE
The preferable or target test result within the test results range. As the system does not test against a target value, this field is for your
information only.
mnSampleSizeQSSZMATH_NUMERICOPTNONE
The quantity of one sample to be taken for the test. As the system does not use this field, it is for your information only.
mnActualSampleSizeQASZMATH_NUMERICOPTNONE
szQualityUnitofMeasureQUMcharOPTNONE
Identifies the unit of measure for a sample you take to test. Examples of units of measure include barrels, gallons, hours, and cubic yards.
cPrintTest109PTTScharOPTNONE
A code used to determine whether or not a test will be printed on the Certificate of Analysis. The valid values are:    0   The test will not be
printed on the Certificate of Analysis.    1   Print all occurrences of a test on the Certificate of Analysis.    2   Print just the average test result record
when printing the Certificate of Analysis.    3   Print the last occurrence of a test when printing the Certificate of Analysis. The last occurrence will
be the test results record that was entered last using Test Results Revisions.
szTestCategoryCode1QTC1charOPTNONE
One of five reporting codes that can be assigned to each test defined.  Use these codes to categorize tests into different groups.  Category
codes are user defined (System 37, types T1 through T5). Examples:        Category code T1 - Test Equipment        Category code T2 - Test
Process
szTestCategoryCode2QTC2charOPTNONE
One of five reporting codes that can be assigned to each test defined.  Use these codes to categorize tests into different groups.  Category
codes are user defined (System 37, types T1 through T5). Examples:        Category code T1 - Test Equipment        Category code T2 - Test
Process
szTestCategoryCode3QTC3charOPTNONE
One of five reporting codes that can be assigned to each test defined.  Use these codes to categorize tests into different groups.  Category
codes are user defined (System 37, types T1 through T5). Examples:        Category code T1 - Test Equipment        Category code T2 - Test
Process
szTestCategoryCode4QTC4charOPTNONE
One of five reporting codes that can be assigned to each test defined.  Use these codes to categorize tests into different groups.  Category
codes are user defined (System 37, types T1 through T5). Examples:        Category code T1 - Test Equipment        Category code T2 - Test
Process
szTestCategoryCode5QTC5charOPTNONE
One of five reporting codes that can be assigned to each test defined.  Use these codes to categorize tests into different groups.  Category
codes are user defined (System 37, types T1 through T5). Examples:        Category code T1 - Test Equipment        Category code T2 - Test
Process
cTestTypeTTTYcharOPTNONE
A value that specifies how the system processes tests as you enter test results. Valid values are:    R  Required. Result values must be
within the allowable range for the test to pass. The system does not allow an item to pass quality inspection until you enter results for each
required test.    O  Optional. Result values are optional during results entry. The system does not require the entry of a result for each optional test.
However, if you enter failing results, the item fails quality inspection.    G  Guaranteed. Result values are optional during results entry. You can
control whether Guaranteed tests appear as you enter test results with the Display Test field on Test Revisions. In addition, guaranteed tests
print on the Certificate of Analysis.
cManufacturingOperationsMFGRcharOPTNONE
A value that specifies whether the system displays the test on the Test Results Revisions form when you access the Test Results
Revisions program (P3711) from any of the following Manufacturing programs:   o  Co-/By-Product Completion (P31115)   o  Super Backflush (P31123)
o  Work Order Time Entry (P311221) If you enter 1 in the grid column or if this option is checked, the system displays the test on the Test
Results Revisions form. You can use this value with the operation sequence and routing type to control the appearance of the test at an operation
or routing type.
cManufacturingReceiptRoutingMRRRcharOPTNONE
A value that controls whether a test will display on the Test Results Revisions form when you access test results from the Routing
Movement and Disposition (P43250) program when the routed order is a manufacturing work order. Valid values are:    1   The test will appear on Test
Results Revisions.    0   The test will not appear on Test Results Revisions. You can use this value with the operation sequence to control the
appearance of the test at a route operation.
cManufacturingCompletionsMFGCcharOPTNONE
A value that specifies whether the system displays the test on the Test Results Revisions form when you access the Test Results
Revisions program (P3711) from either of the following Manufacturing programs:   o  Work Order Completions (P31114)   o  Completions Workbench
(P3119) If you enter 1 in the grid column or if this option is checked, the system displays the test on the Test Results Revisions form.
cPurchasingReceiptsPRCRcharOPTNONE
A value that controls whether a test will display on the Test Results Revisions form when you access test results from either Receipts by
P/O or Receipts by Item (P4312). Valid values are:    1   The test will appear in Test Results Revisions.    0   The test will not appear in Test
Results Revisions.
cPurchasingReceiptRoutingPRERcharOPTNONE
A value that controls whether the test will display on the Test Results Revisions form when you access test results from Routing Movement
and Disposition (P43250) and the routed order is a purchase order. Valid values are:    1   The test will appear on Test Results Revisions.    0
The test will not appear on Test Results Revisions. You can use this value with the operation sequence to control the appearance of the test
at an operation.
cShipConfirmSHPRcharOPTNONE
A value that controls whether the test will display on the Test Results Revisions form when you access test results from the Ship
Confirmation (P4205) program. Valid values are:    1   The test will appear on Test Results Revisions.    0   The test will not appear on Test Results
Revisions.
cBulkLoadConfirmBLKRcharOPTNONE
A value that controls whether the test will display on the Test Results Revisions form when you access test results from one of the following
programs:     o Bulk Confirm by Order or Bulk Confirm by Trip (P49510)     o Packaged Load Confirmation (P49530) Valid values are:    1   The
test will appear on Test Results Revisions.    0   The test will not appear on Test Results Revisions.
mnSequenceNoOperationsOPSQMATH_NUMERICOPTNONE
A number used to indicate an order of succession. In routing instructions, a number that sequences the fabrication or assembly steps in the
manufacture of an item. You can track costs and charge time by operation. In bills of material, a number that designates the routing step in the
fabrication or assembly process that requires a specified component part. You define the operation sequence after you create the routing
instructions for the item. The Shop Floor Management system uses this number in the backflush/preflush by operation process. In engineering
change orders, a number that sequences the assembly steps for the engineering change. For repetitive manufacturing, a number that
identifies the sequence in which an item is scheduled to be produced. Skip To fields allow you to enter an operation sequence that you want to begin
the display of information. You can use decimals to add steps between existing steps. For example, use 12.5 to add a step between steps
12 and 13.
mnOperationSequenceOPRSMATH_NUMERICOPTNONE
The sequence in which the system performs the operations or steps of the route.
mnBubbleSequenceBSEQMATH_NUMERICOPTNONE
A secondary bill of material sequence number that indicates the drawing bubble number.
szTypeRoutingTRTcharOPTNONE
A user defined code (40/TR) that indicates the type of routing. You can define different types of routing instructions for different uses. For
example:    M    Standard Manufacturing Routing    RWK  Rework Routing    RSH  Rush Routing You define the routing type on the work order
header. The system then uses the specific type of routing that you define in the work order routing. Product Costing and Capacity Planning systems
use only M type routings.
mnTripNumberTRPMATH_NUMERICOPTNONE
The number assigned to a trip during direct assignment or trip building. The Trip Depot and the Trip Number fields identify the unique
combination of vehicle, registration number, load date, and shift.
mnLogicalCompartmentNumberLCMPMATH_NUMERICOPTNONE
The compartment number in a connected vehicle. A connected vehicle is a number of vehicles with compartments. The logical
compartment number represents the compartments as if the connected vehicle were one vehicle.  The first compartment is closest to the power
unit. Example:  Three vehicles are connected.  The first is the power unit, the second has 4 compartments and the third has 3 compartments. The first 4
logical compartment numbers equal the compartment numbers on the first vehicle. The 5th, 6th, and 7th logical compartments represent the
compartments in the second vehicle.
szVehicleIdVEHIcharOPTNONE
A unique identification number for a vehicle. This number serves as a primary identifier for a vehicle.
mnResultSortSequenceNumberRSQQMATH_NUMERICOPTNONE
A sequence number used within the Test Results Revisions programs to maintain the order of tests decided within Item/Test
Specifications.
cTimingofTestFutureUseTTSTcharOPTNONE
cDefectWriteCodeDFCWcharOPTNONE
A code used to indicate that a failed test has been written to the Non-Conforming Material file. Valid values are:    1   The failed test has been
recorded to the Non-Conforming Material file    0   Either the test has not failed quality inspection or the failed test has not been recorded in
the Non-Conforming Material file.
szQualityApplicationCodeQPCDcharOPTNONE
A user defined code that identifies the calling application for Test Result Revisions, for example:    MC Manufacturing Completions    SO Ship
Confirm    PR Purchasing Receipts    EC Load and Delivery Confirm
mnQualityTextIDNumberQTIDMATH_NUMERICOPTNONE
A unique identifier associating a test result with it's generic text.
szTestMethodTMHDcharOPTNONE
A description of how to run a quality test. The test method is useful to both your company's Quality Control department and your customers.
For example:        Test: Viscosity        Method: RVF #4 @10RPM        Text: Run the viscosity test on a RVF viscometer with a number 4 spindle
at 10 revolutions per minute.
szResultUnitofMeasureRSUMcharOPTNONE
A user defined code (37/UM) that identifies the