| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | VARNUMH | Condition Record ID | varbinary | 16 | 0 | | | | |
| 3 | COUNTRY_TX | Country | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | TX_SUPPLIER_ID | Supplier Business Partner ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 5 | PARTNER_ID_TT | TTE Business Partner ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 6 | PRTXGRP | Product Tax Group | nvarchar | 20 | 0 | | | | Allow NULL? |
| 7 | KSCHL | Condition Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | OBJECT_ID | Higher-level object number for condition records | varbinary | 16 | 0 | | | | |
| 9 | TIMESTAMP_TO | Timestamp for Validity End Date | nvarchar | 14 | 0 | | | | Allow NULL? |
| 10 | RELEASE_STATUS | Release Status | char | 1 | 0 | | | | Allow NULL? |
| 11 | TIMESTAMP_FROM | Timestamp for Validity Start Date | nvarchar | 14 | 0 | | | | Allow NULL? |
| 12 | KSCHL_SUPP | Supplementary Condition Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | COND_GROUP_ID | ID of Group of Condition Records | varbinary | 16 | 0 | | | | |
| 14 | MAINT_STATUS | Editing status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | CREATED_BY | Name of User that Created the Condition Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | CREATED_ON | Date on which Condition Record was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | KOPOS | Condition Supplement ID | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | SUPP_EXIST | Additional Data Indicator for Condition Record | char | 1 | 0 | | | | Allow NULL? |
| 19 | SCALE_DIM | Dimenstion number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | KBETR | Condition Rate | decimal | 15 | 2 | | | | |
| 21 | KPEIN | Condition Pricing Unit | decimal | 5 | 0 | | | | |
| 22 | KMEIN | Unit of Measure for Product-Specific Quantity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | KONWA | Condition Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 24 | KRECH | Calculation Type for Condition | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | TAXTYP | Tax Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | TX_TAX_RATE_ID | Tax Rate ID | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | AUTHORITYID | Tax Authority ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | LICENSE | Exemption License ID in TTE | nvarchar | 20 | 0 | | | | Allow NULL? |
| 29 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | | | Allow NULL? |
| 30 | TX_ISSUE_DATE | Exemption License Issuing Date in TTE | nvarchar | 8 | 0 | | | | Allow NULL? |
