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 |