| 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 | KZART | Inspection Lot, Partial Lot, Single Unit, Interval | char | 1 | 0 | | | | Allow NULL? |
| 4 | ZAEHLER | Counter for Usage Decision | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | VKATART | Catalog | char | 1 | 0 | | | | Allow NULL? |
| 6 | VWERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | VAUSWAHLMG | Selected Set of the Usage Decision | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | VCODEGRP | Code Group of the Usage Decision | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | VCODE | Usage Decision Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | VERSIONAM | Version Number of the Selected Set Record | nvarchar | 6 | 0 | | | | Allow NULL? |
| 11 | VERSIONCD | Version Number of the Code Record | nvarchar | 6 | 0 | | | | Allow NULL? |
| 12 | VBEWERTUNG | Code Valuation | char | 1 | 0 | | | | Allow NULL? |
| 13 | DBEWERTUNG | Dynamic Modif. Valuation According to Worst Case Principle | char | 1 | 0 | | | | Allow NULL? |
| 14 | VFOLGEAKTI | Follow-Up Action | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | QKENNZAHL | Quality Score | decimal | 3 | 0 | | | | |
| 16 | LTEXTKZ | Long Text for Usage Decision | char | 1 | 0 | | | | Allow NULL? |
| 17 | VNAME | Person who Made the Usage Decision | nvarchar | 12 | 0 | | | | Allow NULL? |
| 18 | VDATUM | Date of Code Used for Usage Decision | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | VEZEITERF | Time when Usage Decision Was Recorded | nvarchar | 6 | 0 | | | | Allow NULL? |
| 20 | VAENAME | Person who Changed the Usage Decision | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | VAEDATUM | Change Date of Usage Decision | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | VEZEITAEN | Time when Usage Decision Changed | nvarchar | 6 | 0 | | | | Allow NULL? |
| 23 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | | | Allow NULL? |
| 24 | TEILLOS | Partial lot number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 25 | VORGLFNR | Current Node Number from Order Counter APLZL | nvarchar | 8 | 0 | | | | Allow NULL? |