1.Functional Description
1.1Purpose
The purpose of this business function is to validate and get test definition information against Test
Definitions Master File (F3701). Allowed Minimum Value, Allowed Maximum Value, Target Value,
Preferred Minimum Value, and Preferred Maximum Value will be scrubbed after fetched by B3700010 if fetch is
success.
1.2Setup Notes and Prerequisites
1.3Special Logic
2.Technical Specifications
VA evt_cFetchFlag="0"
cErrorCode="0"
szErrorMessageID=" "
IfszTestID ? "*"
cStatus=QASTAW
IfFetch is success
szDescriptionLine1 =QADSC1
cTestType =QATTTY
szAllowableMinimumValue =QAAMIN
szPreferableMinimumValue =QAPMIN
szTargetValue =QAQTRG
szPreferableMaximumValue =QAPMAX
szAllowableMaximumValue =QAAMAX
szPropertyfutureuse =QAQPRP
szASTMReference =QAASTM
szTestMethod =QATMHD
VA evt_cDisplayDecimals_CDEC=QACDEC
VA evt_szSystemCode_SY =QASY
VA evt_cFetchFlag ="1"
szCostCenter =Blank
cStatus=Blank (Active)
FetchNext F3701:szDescriptionLine1=QADSC1
End If
If VA evt_cFetchFlag = "0"
cErrorCode="1"
szErrorMessageID="038S"
IfcSuppressErrorMessageFlag ? "1"
Call Set NER Error
"038S"=Error Value
szTestID=Parameter
End If
szPreferableMinimumValue
szTargetValue=szStringValue (B3700010)
szPreferableMaximumValue
VA evt_cNumberic_NUMT=cNumericFlag
VA evt_cDisplayDecimals_CDEC=cDecimalNum
VA evt_szSystemCode_SY=szSystemCode
VA evt_szUDC_RT=szRecordTypeCode
"0"=cSuppressErrorMessageFlag
"1"=cDataOrigin
End If
D3700040 - F3701 Verify and Get Test Definition
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
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 | ||||
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
| ||||
szDescriptionLine1 | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation. | ||||
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
| ||||
szAllowableMinimumValue | AMIN | char | OPT | NONE |
The lowest 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
| ||||
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
| ||||
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
| ||||
szAllowableMaximumValue | AMAX | char | OPT | NONE |
The highest value for a passing test result. | ||||
szPropertyfutureuse | QPRP | char | OPT | NONE |
The item attribute that is being tested. | ||||
szASTMReference | ASTM | char | OPT | NONE |
Identifies a recommended testing procedure of the American Society of Testing Material. | ||||
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.
| ||||
cErrorCode | ERR | char | OPT | NONE |
The Data Field Error Code field is simply a generic data field to pass an error condition flag. This field is one of the fields that make up the
| ||||
cSuppressErrorMessageFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szErrorMessageID | DTA1 | char | OPT | NONE |
A 256 byte field used to hold miscellaneous data. | ||||
cNumeric10 | NUMT | char | OPT | NONE |
Determines whether a test result value will be numeric or alphanumeric.
Valid values are:
1 Indicates that the result value is numeric and
| ||||
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
| ||||
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
| ||||
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
| ||||
mnAssetItemNumber | NUMB | MATH_NUMERIC | OPT | NONE |
An 8-digit number that uniquely identifies an asset. | ||||
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
| ||||
szSpecificationRevisionLev | QREV | char | OPT | NONE |
An alphanumeric character that represents the number of times a specification has changed. To avoid overlapping revisions, the system
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
cPrintText10 | PTTX | char | OPT | NONE |
Determines whether the generic text for an item that is input through Test Result Revisions (P37111) will be printed on the Certificate of
| ||||
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
| ||||
cDisplayTest109 | TSDP | char | OPT | NONE |
A code that determines how test results appear in Test Results Inquiry when accessed from sales orders. This code also determines how
| ||||
cAverage | AVG | char | OPT | NONE |
A Y indicates the average value of a field is to be computed. | ||||
mnNumberofSamples | QSMP | MATH_NUMERIC | OPT | NONE |
The number of samples to be taken for the test. | ||||
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. | ||||
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. | ||||
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
| ||||
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. | ||||
cStatus9 | STAW | char | OPT | NONE |
A user-defined code (00/WS) that indicates the approval status. | ||||
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
| ||||
mnQualityTableSequenceNumber | QTSN | MATH_NUMERIC | OPT | NONE |
A control number that uniquely identifies master table records in the Quality Management system. The system automatically generates this
| ||||
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
| ||||
mnUniqueKeyIDInternal | UKID | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. | ||||
cApprovalActionCode | ACTN | char | OPT | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
jdCurrentTestDate | 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
| ||||
cQualityManagementStatus01 | QM01 | char | OPT | NONE |
cQualityManagementStatus02 | QM02 | char | OPT | NONE |
cQualityManagementStatus03 | QM03 | char | OPT | NONE |
cQualityManagementStatus04 | QM04 | char | OPT | NONE |
cQualityManagementStatus05 | QM05 | char | OPT | NONE |
cQualityManagementStat06 | QM06 | char | OPT | NONE |
cQualityManagementStat07 | QM07 | char | OPT | NONE |
cQualityManagementStat08 | QM08 | char | OPT | NONE |
cQualityManagementStat09 | QM09 | char | OPT | NONE |
cQualityManagementStat10 | QM10 | char | OPT | NONE |
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
| ||||
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. | ||||
cValidateConvertMinMaxTarget | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnChangeThreshold | CHGTHRES | MATH_NUMERIC | OPT | NONE |
The allowed percentage of variation from the previous result. | ||||
mnQualityMgmtAB1 | QMAB1 | MATH_NUMERIC | OPT | NONE |
Reserved for Quality Management. | ||||
szQualityMgmtCode1 | QMCD1 | char | OPT | NONE |
Reserved for Quality Management. | ||||
jdQualityMgmtDate1 | QMDT1 | JDEDATE | OPT | NONE |
Reserved for Quality Management. | ||||
mnQualityMgmtNumeric1 | QMNUM1 | MATH_NUMERIC | OPT | NONE |
Reserved for Quality Management. | ||||
szQualityMgmtReference1 | QMRF1 | char | OPT | NONE |
Reserved for Quality Management. | ||||
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
| ||||
mnResultDurationDays | RSDURDY | MATH_NUMERIC | OPT | NONE |
Number of days result is valid. This value is used to determine the result expiration date. | ||||
mnTestDurationDays | TSTDURDY | MATH_NUMERIC | OPT | NONE |
The number of days it takes to complete a test. | ||||
szTestResultName | TSTRSNM | char | OPT | NONE |
Unique name used to group test results. |
None |
None |