B3700050
GetTestResultRecord
This function retrieves records from F3711 based on the selection and sort criteria set up in
SetTestResultSelection.
The pointer to the stored data structure (returned in idTestResSelection by SetTestResultSelection)
must be passed in via the idTestResSelection field. The next record that matches the selection criteria
and sequenced by the sort criteria referenced by this pointer is returned in the fields of the D3711
record.
^
D3711 - Test Results - All Fields
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnDOCO | 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,
| ||||
szDCTO | 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
| ||||
szKCOO | 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
| ||||
mnLNID | 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
| ||||
szRCTO | 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
| ||||
szRORN | 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
| ||||
szRKCO | RKCO | char | OPT | NONE |
The key company that is associated with the document number of the related order. | ||||
mnRLLN | 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
| ||||
szMCU | 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
| ||||
szLOCN | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
szLOTN | LOTN | char | OPT | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
mnAN8 | 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
| ||||
szCS18 | 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
| ||||
mnITM | 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
| ||||
szIT18 | 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
| ||||
szQTST | 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 | ||||
szMCU2 | MCU2 | char | OPT | NONE |
An accounting entity, such as a profit center, department, warehouse location, job, project, workcenter, and so on, required for management
| ||||
szQSPC | 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 -
| ||||
szHMCU | HMCU | char | OPT | NONE |
The number of the business unit in which the employee generally resides. | ||||
mnTSRT | TSRT | MATH_NUMERIC | OPT | NONE |
A number used to determine the sort order of tests and specifications within preference profiles (item/test specifications). | ||||
szQREV | QREV | char | OPT | NONE |
An alphanumeric character that represents the number of times a specification has changed. To avoid overlapping revisions, the system
| ||||
szQVAL | QVAL | char | OPT | NONE |
The result of the performed test. | ||||
cQPF | QPF | char | OPT | NONE |
The value which identifies whether the test passed (P) or failed (F). | ||||
cTOVR | TOVR | char | OPT | NONE |
The flag which designates whether a test has been overridden. Valid values are: 1 overridden 0 not overridden | ||||
szMUSE | 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
| ||||
mnANO | 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. | ||||
jdQDAT | QDAT | JDEDATE | OPT | NONE |
The date on which the test was performed. | ||||
mnQTIM | QTIM | MATH_NUMERIC | OPT | NONE |
The time at which the test was performed. | ||||
szQDSP | QDSP | char | OPT | NONE |
mnSNBR | SNBR | MATH_NUMERIC | OPT | NONE |
A number assigned to a group of tests within the same sample. | ||||
mnQSMP | QSMP | MATH_NUMERIC | OPT | NONE |
The number of samples to be taken for the test. | ||||
mnSMPC | 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
| ||||
mnACQT | 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
| ||||
mnACPC | 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
| ||||
szSY | 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
| ||||
szRT | 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. | ||||
szAMIN | AMIN | char | OPT | NONE |
The lowest value for a passing test result. | ||||
szAMAX | AMAX | char | OPT | NONE |
The highest value for a passing test result. | ||||
szPMIN | 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
| ||||
szPMAX | 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
| ||||
jdEFFF | 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
| ||||
jdEFFT | 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
| ||||
szQTRG | 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
| ||||
mnQSSZ | 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. | ||||
mnQASZ | QASZ | MATH_NUMERIC | OPT | NONE |
szQUM | 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. | ||||
cPTTS | 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
| ||||
szQTC1 | 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
| ||||
szQTC2 | 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
| ||||
szQTC3 | 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
| ||||
szQTC4 | 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
| ||||
szQTC5 | 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
| ||||
cTTTY | 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
| ||||
cMFGR | 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
| ||||
cMRRR | 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
| ||||
cMFGC | 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
| ||||
cPRCR | 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
| ||||
cPRER | 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
| ||||
cSHPR | 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
| ||||
cBLKR | 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
| ||||
mnOPSQ | 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
| ||||
mnOPRS | OPRS | MATH_NUMERIC | OPT | NONE |
The sequence in which the system performs the operations or steps of the route. | ||||
mnBSEQ | BSEQ | MATH_NUMERIC | OPT | NONE |
A secondary bill of material sequence number that indicates the drawing bubble number. | ||||
szTRT | 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
| ||||
mnTRP | 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
| ||||
mnTRPL | TRPL | MATH_NUMERIC | OPT | NONE |
A specific leg of a trip. | ||||
mnLCMP | LCMP | MATH_NUMERIC | OPT | NONE |
The compartment number in a connected vehicle.
A connected vehicle is a number of vehicles with compartments. The logical
| ||||
szVEHI | VEHI | char | OPT | NONE |
A unique identification number for a vehicle. This number serves as a primary identifier for a vehicle. | ||||
mnRSQQ | 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
| ||||
cTTST | TTST | char | OPT | NONE |
cDFCW | 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
| ||||
szQPCD | QPCD | char | OPT | NONE |
A user defined code that identifies the calling application for Test Result Revisions, for example:
MC Manufacturing Completions
SO Ship
| ||||
mnQTID | QTID | MATH_NUMERIC | OPT | NONE |
A unique identifier associating a test result with it's generic text. | ||||
szTMHD | 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.
| ||||
szRSUM | 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
| ||||
mnNUMB | NUMB | MATH_NUMERIC | OPT | NONE |
An 8-digit number that uniquely identifies an asset. | ||||
szASTM | ASTM | char | OPT | NONE |
Identifies a recommended testing procedure of the American Society of Testing Material. | ||||
szQPRP | QPRP | char | OPT | NONE |
The item attribute that is being tested. | ||||
szQDFC | QDFC | char | OPT | NONE |
szQRTC | QRTC | char | OPT | NONE |
szMMCU | 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
| ||||
cCDEC | 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
| ||||
mnUKID | UKID | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. | ||||
szDERC | 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
| ||||
szURCD | 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. | ||||
jdURDT | 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. | ||||
mnURAT | 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. | ||||
szURRF | 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. | ||||
mnURAB | 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. | ||||
szUSER | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
szPID | 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
| ||||
jdUPMJ | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
mnTDAY | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. | ||||
szJOBN | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
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
| ||||
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
| ||||
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
| ||||
idTestResSelection | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
cErrorCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. |
None |
None |