| 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 | PROBENR | Sample Number | nvarchar | 6 | 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 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 9 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | SATZSTATUS | Specification Record Status | char | 1 | 0 | | | | Allow NULL? |
| 11 | ANNAHMEZ | Acceptance Number | smallint | 5 | 0 | | | | |
| 12 | RUECKWEZ | Rejection Number | smallint | 5 | 0 | | | | |
| 13 | KFAKTORNI | Value Not Initial if Set | char | 1 | 0 | | | | Allow NULL? |
| 14 | KFAKTOR | K-Factor for a Variable Inspection | float | 15 | 16 | | | | |
| 15 | ANTVERF | Fraction Calculation | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | BEWREGEL | Valuation Rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | FAKPLANME | Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure | float | 15 | 16 | | | | |
| 18 | FAKPROBME | Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure | float | 15 | 16 | | | | |
| 19 | PROBMGFAK | Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) | decimal | 5 | 2 | | | | |
| 20 | PROBEMGEH | Sample Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | STIPROUMF | Sample Size that Must Be Inspected | int | 10 | 0 | | | | Allow NULL? |
| 22 | PRUEFUMF | Quantity to Be Inspected | decimal | 13 | 3 | | | | |
| 23 | MENGENEINH | Base Unit of Measure for the Sample Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | QRKNR | Control Chart Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 25 | PRSTUFE | Inspection Stage | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | PRSCHAERFE | Inspection Severity | nvarchar | 3 | 0 | | | | Allow NULL? |
