| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | STICHPRVER | Sampling Procedure | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | STICHPRART | Sampling Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | BEWERTMOD | Valuation Mode | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | KZOHI | No Inspection Stage Change | char | 1 | 0 | | | | Allow NULL? |
| 6 | KZUMFS | Multiple Samples | char | 1 | 0 | | | | Allow NULL? |
| 7 | KZNOCUT | Sample Size Not Reduced | char | 1 | 0 | | | | Allow NULL? |
| 8 | STPRANZ | Number of Samples for Multiple Samples | tinyint | 3 | 0 | | | | |
| 9 | STPRUMF | Number of Sampling Units in a Sample | int | 10 | 0 | | | | Allow NULL? |
| 10 | ANNAHMEZ | Acceptance Number | smallint | 5 | 0 | | | | |
| 11 | KFAKTOR | K-Factor for a Variable Inspection | float | 15 | 16 | | | | |
| 12 | KFAKTORNI | Value Not Initial if Set | char | 1 | 0 | | | | Allow NULL? |
| 13 | KZNVWSV | Sampling Procedure Cannot Be Used | char | 1 | 0 | | | | Allow NULL? |
| 14 | KZVWSVPL | Sampling Procedure Is Used in Inspection Plan | char | 1 | 0 | | | | Allow NULL? |
| 15 | FBKEY | Identifier for the Sample Determination Rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | FBKEYMFS | Code for Valuation Rule for Independent Multiple sampling | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | STPRPLAN | Sampling Scheme in Sampling Procedure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | PRSCHAERFE | Inspection Severity in Sampling Procedure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | AQLWERT | AQL Value in Sampling Procedure | decimal | 7 | 3 | | | | |
| 20 | PROZUMF | Sample Size as Percentage of Lot Size | float | 15 | 16 | | | | |
| 21 | PROZUMFNI | Value Not Initial if Set | char | 1 | 0 | | | | Allow NULL? |
| 22 | PROZAZL | Acceptance Number as Percentage of Sample Size | float | 15 | 16 | | | | |
| 23 | PROZAZLNI | Value Not Initial if Set | char | 1 | 0 | | | | Allow NULL? |
| 24 | ERSTELLER | Name of User Who Created the Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 25 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 26 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | KZRAST | Indicator: Sampling Procedure for Inspection Points | char | 1 | 0 | | | | Allow NULL? |
| 29 | RASTER | Inspection Frequency (Only for Inspection with Insp. Points) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 30 | QRKART | Control Chart Type | nvarchar | 3 | 0 | | | | Allow NULL? |
