| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | ID | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | CHAR | (N' ') | No | | FDT_UUID | Allow NULL? |
| 2 | VERSION | FDT: Version | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | FDT_VERSION | Allow NULL? |
| 3 | ELEMENT_TYPE | FDT: Elementary Data Type | char | 1 | 0 | CHAR | (N' ') | Yes | | FDT_ELEMENT_TYPE | Allow NULL? |
| 4 | ELEMENT_ID | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | FDT_UUID | Allow NULL? |
| 5 | COMPARISONS | FDT: Allowed Comparisons | char | 1 | 0 | CHAR | (N' ') | Yes | | FDT_ALLOWED_COMPARISONS | Allow NULL? |
| 6 | INCLUDE_SIGN | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLE_D | Allow NULL? |
| 7 | EXCLUDE_SIGN | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLE_D | Allow NULL? |
| 8 | MULTIPLE_VALUES | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLE_D | Allow NULL? |
| 9 | OPTION_STRING | | nvarchar | 60 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 10 | COMPOUND_ID | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | FDT_UUID | Allow NULL? |
| 11 | LENGTH | FDT: Element: Length | int | 10 | 0 | INT4 | ((0)) | Yes | | FDT_ELEMENT_LENGTH | Allow NULL? |
| 12 | DECIMALS | FDT: Element: Number of decimals | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | FDT_ELEMENT_DECIMALS | |
| 13 | ONLY_POSITIVE | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLE_D | Allow NULL? |
| 14 | TIMEPOINT_TYPE | BRFplus Timepoint Type | char | 1 | 0 | NUMC | (N'0') | Yes | | FDT_TIMEPOINT_TYPE | Allow NULL? |
| 15 | XSTNCE_CHECK_SEV | FDT: Message Severity | char | 1 | 0 | CHAR | (N' ') | Yes | | FDT_MSG_SEVERITY | Allow NULL? |
| 16 | CMPRSN_CHECK_SEV | FDT: Message Severity | char | 1 | 0 | CHAR | (N' ') | Yes | | FDT_MSG_SEVERITY | Allow NULL? |
| 17 | QUAN_DIMENSION | FDT: Quantitty Dimension key | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | FDT_QUANTITY_DIMENSION | Allow NULL? |
| 18 | ONLY_UPPERCASE | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLE_D | Allow NULL? |
| 19 | IS_NUMC | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLE_D | Allow NULL? |
