| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | QCAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | QCCS18 | Customer Group - Quality Management | String | UDC (40 18) | 8 | 0 | Allow NULL? |
| 3 | QCITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | QCIT18 | Item Group - Quality Management | String | UDC (40 68) | 8 | 0 | Allow NULL? |
| 5 | QCEFTJ | Date - Effective | Date | Generic Edit | 6 | 0 | |
| 6 | QCEXDJ | Date - Expired | Date | Generic Edit | 6 | 0 | |
| 7 | QCMNQ | Quantity - From | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 8 | QCMXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 9 | QCUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 10 | QCSTAW | Status | Character | UDC (00 WS) | 1 | 0 | Allow NULL? |
| 11 | QCTXID | Text ID Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 12 | QCSTPR | Status - Preference | Character | UDC (40 PT) | 1 | 0 | Allow NULL? |
| 13 | QCOSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 14 | QCEFFF | Effective - From Date | Date | Generic Edit | 6 | 0 | |
| 15 | QCEFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 | |
| 16 | QCQTSN | Quality Table Sequence Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 17 | QCMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 18 | QCTSRT | Test Sort Sequence Number | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 19 | QCQTST | Test ID | String | Generic Edit | 25 | 0 | Allow NULL? |
| 20 | QCTTTY | Test Type | Character | UDC (37 TY) | 1 | 0 | Allow NULL? |
| 21 | QCQREV | Specification Revision Level | String | Generic Edit | 3 | 0 | Allow NULL? |
| 22 | QCTSSP | Test/Specification flag | Character | UDC (37 TS) | 1 | 0 | Allow NULL? |
| 23 | QCMCU2 | Business Unit 2 | String | Generic Edit | 12 | 0 | Allow NULL? |
| 24 | QCSY | Product Code | String | UDC (98 SY) | 4 | 0 | Allow NULL? |
| 25 | QCRT | User Defined Codes | String | Generic Edit | 2 | 0 | Allow NULL? |
| 26 | QCAMIN | Allowed Minimum Value | String | Generic Edit | 15 | 0 | Allow NULL? |
| 27 | QCAMAX | Allowed Maximum Value | String | Generic Edit | 15 | 0 | Allow NULL? |
| 28 | QCPMIN | Preferred Minimum Value (future use) | String | Generic Edit | 15 | 0 | Allow NULL? |
| 29 | QCPMAX | Preferred Maximum Value (future use) | String | Generic Edit | 15 | 0 | Allow NULL? |
| 30 | QCQTRG | Target Value | String | Generic Edit | 15 | 0 | Allow NULL? |
| 31 | QCQSSZ | Sample Size | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 32 | QCQUM | Sample Size Unit of Measure | String | UDC (37 UM) | 3 | 0 | Allow NULL? |
| 33 | QCQSMP | Number of Samples | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 34 | QCSMPC | Sample Percentage | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 35 | QCACQT | Accept Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 36 | QCACPC | Accept Percentage | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 37 | QCPTTS | Print Test | Character | UDC (37 PT) | 1 | 0 | Allow NULL? |
| 38 | QCMFGR | Manufacturing Operations | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 39 | QCMRRR | Manufacturing Receipt Routing | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 40 | QCPRER | Purchasing Receipt Routing | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 41 | QCPRCR | Purchasing Receipts | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 42 | QCMFGC | Manufacturing Completions | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 43 | QCSHPR | Ship Confirm | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 44 | QCBLKR | Bulk Confirm | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | QCOPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 46 | QCOPRS | Sequence Number - Operations | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 47 | QCBSEQ | Sequence - Bubble Sequence | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 48 | QCTRT | Type of Routing | String | UDC (40 TR) | 3 | 0 | Allow NULL? |
| 49 | QCTMHD | Test Method | String | Generic Edit | 30 | 0 | Allow NULL? |
| 50 | QCRSUM | Results Unit of Measure | String | UDC (37 UM) | 3 | 0 | Allow NULL? |
| 51 | QCNUMB | Asset Item Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 52 | QCASTM | ASTM Reference | String | Generic Edit | 30 | 0 | Allow NULL? |
| 53 | QCQPRP | Property | String | UDC (37 PR) | 10 | 0 | Allow NULL? |
| 54 | QCTTST | Timing of Test (Future Use) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 55 | QCMMCU | Branch | String | Generic Edit | 12 | 0 | Allow NULL? |
| 56 | QCCDEC | Display Decimals | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 57 | QCURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 58 | QCURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 59 | QCURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 60 | QCURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 61 | QCURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 62 | QCUKID | Unique Key ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 63 | QCACTN | Action Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 64 | QCUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 65 | QCPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 66 | QCUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 67 | QCTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 68 | QCJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 69 | QCDERC | Derived Calculation | String | Generic Edit | 80 | 0 | Allow NULL? |
