| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | | | |
| 3 | VALID_TO | Valid To (Time Stamp) | decimal | 15 | 0 | | | | |
| 4 | LINE_ID | Row Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | LEVEL_ID | Level ID | nvarchar | 5 | 0 | | | | Allow NULL? |
| 6 | INSTANCE | Instance for Complex Data Types | nvarchar | 5 | 0 | | | | Allow NULL? |
| 7 | SPLITTER | Counter for Long Values and Value Data Set | nvarchar | 5 | 0 | | | | Allow NULL? |
| 8 | PREDEC | Previous Value in Hierarchy | nvarchar | 5 | 0 | | | | Allow NULL? |
| 9 | VALID_FROM | Valid From (Time Stamp) | decimal | 15 | 0 | | | | |
| 10 | UPNAME | Name of the User Who Last Changed the Set | nvarchar | 12 | 0 | | | | Allow NULL? |
| 11 | LOGSYS | Original System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | UPDATE_TYPE | Type of Change | char | 1 | 0 | | | | Allow NULL? |
| 13 | STRING | Character-Type Values | nvarchar | 254 | 0 | | | | Allow NULL? |
| 14 | INT_FROM | Integer Values, Lower Limit | decimal | 31 | 0 | | | | |
| 15 | INT_TO | Integer Values, Upper Limit | decimal | 31 | 0 | | | | |
| 16 | FLT_FROM | Exponential Number, Lower Limit | float | 15 | 16 | | | | |
| 17 | FLT_TO | Exponential Number, Upper Limit | float | 15 | 16 | | | | |
| 18 | TMS_FROM | Time Stamp, Lower Limit | decimal | 15 | 0 | | | | |
| 19 | TMS_TO | Time Stamp, Upper Limit | decimal | 15 | 0 | | | | |
| 20 | PREPARED | Value | nvarchar | 254 | 0 | | | | Allow NULL? |
| 21 | ACC_FROM | Input Accuracy of Lower Limit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | ACC_TO | Input Accuracy of Upper Limit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | UOM_FROM | Alternative Unit of Measure of Upper Limit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | UOM_TO | Alternative Unit of Measure of Upper Limit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | INTERV | Key Interval Limits | char | 1 | 0 | | | | Allow NULL? |
| 26 | ORG_INPUT | Original Input | nvarchar | 254 | 0 | | | | Allow NULL? |
| 27 | LANG_DATA | Key Texts | varbinary | 16 | 0 | | | | |
| 28 | ORDER_CNT | Sequence Counter | nvarchar | 5 | 0 | | | | Allow NULL? |
| 29 | PREINST | Previous Instance | nvarchar | 5 | 0 | | | | Allow NULL? |
| 30 | DEF_VALUE | Default Value | char | 1 | 0 | | | | Allow NULL? |
| 31 | NODE | Nodes in Value Hierarchy | char | 1 | 0 | | | | Allow NULL? |
| 32 | DOCUMENTS | Document Key | varbinary | 16 | 0 | | | | |
| 33 | ECM_COUNT | Change Management Counter | nvarchar | 5 | 0 | | | | Allow NULL? |
| 34 | ECM_DEL | Deletion Indicator | char | 1 | 0 | | | | Allow NULL? |
