D31B8180A - Add/Update/Delete QA Results Child Values
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| 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 
  | ||||
| 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  | ||||
| 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).  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| szProductCode | 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 | 
| 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 
  | ||||
| mnUniqueKeyIDInternal | UKID | MATH_NUMERIC | OPT | NONE | 
This field is a unique number used to identify a record in a file.  | ||||
| szBlendLotNumber | WLOTN | char | OPT | NONE | 
A number that identifies a Blend Lot. A lot is a group of items with similar characteristics.  | ||||
| nOperationID | WOPID | integer | OPT | NONE | 
| 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 
  | ||||
| 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.  | ||||
| szTestResultName | TSTRSNM | char | OPT | NONE | 
Unique name used to group test results.  | ||||
| cResultEntryStatus | RSSTS | char | OPT | NONE | 
A code used to determine if the test result was created from a blend rule.  | ||||
| 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 
  | ||||
| szFromResultValue | FRMRSVAL | char | OPT | NONE | 
Result used as the From value to convert the result.  | ||||
| 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 
  | ||||
| szQualityMgmtCode3 | QMCD3 | char | OPT | NONE | 
Reserved for Quality Management.  | ||||
| mnJobnumber | JOBS | MATH_NUMERIC | OPT | NONE | 
The job number (work station ID) which executed the particular job.  | ||||
| szErrorCode | 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 
  | ||||
| nRowNumber | INT01 | integer | OPT | NONE | 
Number of Days in Future to Query for Responses Due.  | ||||
| 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.  | ||||
| mnQualityMgmtNumeric3 | QMNUM3 | MATH_NUMERIC | OPT | NONE | 
Reserved for Quality Management.  | ||||
| None | 
| None |