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 |