| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | EHPRCD_ORGIDS | Organisation | 13 | ISDELETED | Deletion Indicator | nvarchar | 1 | 0 | | |
2 | EHPRCD_ORGPER | Contact | 11 | ISDELETED | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPBusiness Configuration Sets |
3 | SCPRSREVERT | Revert SBCSets: Contents of tables before BCSet activation | 3 | ISDELETED | Boolean Variable (X=True, Space=False) | nvarchar | 1 | 0 | | |
4 | SCPRSREVERTD | Revert SBCSets: Contents of tables before BCSet activation | 4 | ISDELETED | Boolean Variable (X=True, Space=False) | nvarchar | 1 | 0 | | |
5 | SCPRSREVERTI | Revert SBCSets: Contents of tables before BCSet activation | 3 | ISDELETED | Boolean Variable (X=True, Space=False) | nvarchar | 1 | 0 | | |
TOPEnvironment, Health and Safety |
6 | /TDAG/CPT_ORGIDS | IMDS Organisation | 13 | ISDELETED | Deletion Indicator | nvarchar | 1 | 0 | | |
7 | /TDAG/CPT_ORGPER | IMDS Contact | 11 | ISDELETED | Deletion Indicator | nvarchar | 1 | 0 | | |