| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | ID | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 2 | VERSION | FDT: Version | nvarchar | 6 | 0 | | | | Allow NULL? |
| 3 | OPERATION | FDT: Table Operation | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | TABLE_PARAM | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 5 | AGGR_COLUMN | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 6 | SORT_COL1 | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 7 | SORT_C1_DESC | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 8 | SORT_COL2 | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 9 | SORT_C2_DESC | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 10 | SORT_COL3 | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 11 | SORT_C3_DESC | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 12 | SORT_COL4 | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 13 | SORT_C4_DESC | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 14 | SORT_COL5 | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 15 | SORT_C5_DESC | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 16 | NUMBER_OF_LINES | Dummy for B20 int1 (Local Everywhere) | tinyint | 3 | 0 | | | | |
| 17 | SELECT_8001 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |