D3700070 - F3701 Test Definitions Master Business Function
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| cActionCode | ACTN | char | OPT | NONE | 
A code that specifies the action that is performed. Valid values are: A Add C Change  | ||||
| cUpdateMasterFile | EV01 | char | OPT | NONE | 
An option that specifies the type of processing for an event.  | ||||
| cProcessEdits | EV01 | char | OPT | NONE | 
An option that specifies the type of processing for an event.  | ||||
| cSuppressErrorMessage | SUPPS | char | OPT | NONE | 
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
       0 = allow 
  | ||||
| szErrorMessageID | 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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  | ||||
| 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 
  | ||||
| szDescription1 | 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 
  | ||||
| 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 
  | ||||
| szUserDefinedCode | 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.  | ||||
| cNumberofDecimals | 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 
  | ||||
| szProperty | 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.  | ||||
| szAllowedMinimum | AMIN | char | OPT | NONE | 
The lowest value for a passing test result.  | ||||
| szAllowedMaximum | AMAX | char | OPT | NONE | 
The highest value for a passing test result.  | ||||
| szPreferredMinimum | 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 
  | ||||
| szPreferredMaximum | 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 
  | ||||
| szTarget | 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 
  | ||||
| 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.  | ||||
| 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.  | ||||
| mnNumberofSamples | QSMP | MATH_NUMERIC | OPT | NONE | 
The number of samples to be taken for the test.  | ||||
| cAverage | AVG | char | OPT | NONE | 
A Y indicates the average value of a field is to be computed.  | ||||
| cDisplayEvaluate | 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 
  | ||||
| cPrintTest | 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 
  | ||||
| cPrintText | 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| szSpecificationRevision | QREV | char | OPT | NONE | 
An alphanumeric character that represents the number of times a specification has changed. To avoid overlapping revisions, the system 
  | ||||
| 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. 
  | ||||
| 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 
  | ||||
| mnItemNumber | NUMB | MATH_NUMERIC | OPT | NONE | 
An 8-digit number that uniquely identifies an asset.  | ||||
| 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 | 
| cQualityManagementStatus06 | QM06 | char | OPT | NONE | 
| cQualityManagementStatus07 | QM07 | char | OPT | NONE | 
| cQualityManagementStatus08 | QM08 | char | OPT | NONE | 
| cQualityManagementStatus09 | QM09 | char | OPT | NONE | 
| cQualityManagementStatus10 | QM10 | char | OPT | NONE | 
| szBranch | 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 
  | ||||
| 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 
  | ||||
| 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.  | ||||
| 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.  | ||||
| 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.  | ||||
| szUserId | USER | char | OPT | NONE | 
The code that identifies a user profile.  | ||||
| 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.  | ||||
| cOriginCode | EV01 | char | OPT | NONE | 
An option that specifies the type of processing for an event.  | ||||
| cApprovalActionCode | APPRACT | char | OPT | NONE | 
A code that determines whether a workflow recipient has accepted or rejected a workflow task that has been submitted for approval. Valid 
  | ||||
| cActivateWorkflow | EV01 | char | OPT | NONE | 
An option that specifies the type of processing for an event.  | ||||
| cActivateLogging | EV01 | char | OPT | NONE | 
An option that specifies the type of processing for an event.  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| mnUniqueKeyIDInternal | UKID | MATH_NUMERIC | OPT | NONE | 
This field is a unique number used to identify a record in a file.  | ||||
| cStatus9 | STAW | char | OPT | NONE | 
A user-defined code (00/WS) that indicates the approval status.  | ||||
| mnAddNoOriginator | 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.  | ||||
| jdOriginalEffectiveThru | 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 
  | ||||
| jdOriginalEffectiveFrom | 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 
  | ||||
| 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 |