| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDANT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PRUEFLOS | Inspection Lot Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | VORGLFNR | Current Node Number from Order Counter APLZL | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | MERKNR | Inspection Characteristic Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | REFOBJ | Reference to Object for Multiple Specification | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | ERSTELLER | Name of User Who Created the Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | ERSTELLZEIT | Time at which data record was created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 9 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 10 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | AENDERZEIT | Time of Last Data Record Change | nvarchar | 6 | 0 | | | | Allow NULL? |
| 12 | SATZSTATUS | Results Record Status | char | 1 | 0 | | | | Allow NULL? |
| 13 | MBEWERTGMS | Inspection Result Valuation | char | 1 | 0 | | | | Allow NULL? |
| 14 | ANZFEHLEH | Number of Nonconforming Sample Units | int | 10 | 0 | | | | Allow NULL? |
| 15 | ANTEILNI | Not Initialized for Fraction | char | 1 | 0 | | | | Allow NULL? |
| 16 | KATAB1 | Catalog Entry Is a Selected Set | char | 1 | 0 | | | | Allow NULL? |
| 17 | KATALGART1 | Catalog Type of Assigned Code Group or Selected Set | char | 1 | 0 | | | | Allow NULL? |
| 18 | AUSWMENGE1 | Assigned Code Group or Selected Set | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | AUSWMGWRK1 | Plant of the Assigned Selected Set | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | STELLEN | Number of Places to the Right of a Decimal Point (Accuracy) | tinyint | 3 | 0 | | | | |
| 21 | MASSEINHSW | Unit of Measurement, in Which Quantitative Data Is Stored | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | SOLLWERT | Target Value for a Quantitative Characteristic | float | 15 | 16 | | | | |
| 23 | SOLLWNI | Value Not Initial if Set | char | 1 | 0 | | | | Allow NULL? |
| 24 | TOLERANZOB | Upper Specification Limit | float | 15 | 16 | | | | |
| 25 | TOLOBNI | Value Not Initial if Set | char | 1 | 0 | | | | Allow NULL? |
| 26 | TOLERANZUN | Lower Tolerance Limit | float | 15 | 16 | | | | |
| 27 | TOLUNNI | Value Not Initial if Set | char | 1 | 0 | | | | Allow NULL? |
| 28 | GRENZEOB1 | First Upper Specification Limit | float | 15 | 16 | | | | |
| 29 | GRENZOB1NI | Value Not Initial if Set | char | 1 | 0 | | | | Allow NULL? |
| 30 | GRENZEUN1 | First Lower Specification Limit | float | 15 | 16 | | | | |
| 31 | GRENZUN1NI | Value Not Initial if Set | char | 1 | 0 | | | | Allow NULL? |
| 32 | GRENZEOB2 | Second Upper Specification Limit | float | 15 | 16 | | | | |
| 33 | GRENZOB2NI | Value Not Initial if Set | char | 1 | 0 | | | | Allow NULL? |
| 34 | GRENZEUN2 | Second Lower Specification Limit | float | 15 | 16 | | | | |
| 35 | GRENZUN2NI | Value Not Initial if Set | char | 1 | 0 | | | | Allow NULL? |
| 36 | DUMMY10 | Text Line for Additional Information | nvarchar | 10 | 0 | | | | Allow NULL? |
| 37 | DUMMY20 | Text Line for Additional Information | nvarchar | 20 | 0 | | | | Allow NULL? |
| 38 | DUMMY40 | Text Line for Additional Information | nvarchar | 40 | 0 | | | | Allow NULL? |
