| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DB_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 3 | PARENT_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 4 | DATETIME_CR | Date/Time of Item Creation | decimal | 15 | 0 | | | | |
| 5 | USER_ID_CR | Object Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 6 | DATETIME_CH | Date/Time of Item Change | decimal | 15 | 0 | | | | |
| 7 | USER_ID_CH | Object Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | REQ | Compliance Requirement (Check) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | VALID_FROM_DATE | Compliance Data revision valid from date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | VALID_TO_DATE | Compliance Data revision valid to date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | REASSESS_DATE | Compliance Data Revision Reassess Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | RELEASED_DATE | Compliance Data Revision Released Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | RELEASED_TS | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 14 | RELEASED_BY | Compliance Data Revision Released By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 15 | REV_STATUS | Compliance Data Revision Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | REGL_KEY_REF | Regulatory List Root Key Reference | varbinary | 16 | 0 | | | | |
| 17 | REV_PARENT_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 18 | REMARK | Requirement Revision Remark | nvarchar | 255 | 0 | | | | Allow NULL? |
| 19 | CLASS | Classification | char | 1 | 0 | | | | Allow NULL? |
| 20 | FUTURE_PROC_IND | Select Checkbox | char | 1 | 0 | | | | Allow NULL? |
| 21 | EEW_COD_REQR_D | Dummy function in length 1 | char | 1 | 0 | | | | Allow NULL? |