| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TOLGRP_ID | Tolerance Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | TOLGRP_UOM | Use of UoM for Tolerance Groups | char | 1 | 0 | | | | Allow NULL? |
| 4 | TOLGRP_CURR | Use of Currency Unit for Tolerance Groups | char | 1 | 0 | | | | Allow NULL? |
| 5 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 6 | MEINH | Alternative Unit of Measure for Stockkeeping Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | XAKZPU | Indicates tolerance limit check | char | 1 | 0 | | | | Allow NULL? |
| 8 | TAKZPU | Tolerance Groups: Positive Minor Difference | decimal | 13 | 3 | | | | |
| 9 | XAKZPB | Indicates tolerance limit check | char | 1 | 0 | | | | Allow NULL? |
| 10 | TAKZPB | Tolerance Groups: Absolute Positive Acceptance Upper Limit | decimal | 13 | 3 | | | | |
| 11 | XAKZPP | Indicates tolerance limit check | char | 1 | 0 | | | | Allow NULL? |
| 12 | TAKZPP | Tolerance Groups: Percentage Positive Upper Acceptance Limit | decimal | 4 | 2 | | | | |
| 13 | XAKZNB | Indicates tolerance limit check | char | 1 | 0 | | | | Allow NULL? |
| 14 | TAKZNB | Tolerance Groups: Negative Minor Difference | decimal | 13 | 3 | | | | |
| 15 | XAKZNU | Indicates tolerance limit check | char | 1 | 0 | | | | Allow NULL? |
| 16 | TAKZNU | Tolerance Groups: Absolute Negative Acceptance Limit | decimal | 13 | 3 | | | | |
| 17 | XAKZNP | Indicates tolerance limit check | char | 1 | 0 | | | | Allow NULL? |
| 18 | TAKZNP | Tolerance Groups: Percentage Negative Lower Acceptance Limit | decimal | 4 | 2 | | | | |