| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | PROFILE_ID | Declaration ID | nvarchar | 10 | 0 | CHAR | (N' ') | No | | /OTX/RM_DE_PROFILE_ID | Allow NULL? |
| 3 | DESCRIPTION | Description | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_DESC | Allow NULL? |
| 4 | PROPS_PROVIDER | Property provider | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_PROPS_PROVIDER | Allow NULL? |
| 5 | LES_ID | Enterprise Library ID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | /OTX/RM_TELIB | /OTX/RMCON_DE_LES_ID | Allow NULL? |
| 6 | ELIB_TYPE | ELib type (Obsolete) | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_ELIB_TYPE | Allow NULL? |
| 7 | SYS_CAT_ID | System category ID | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | /OTX/RMCON_DE_SYS_CAT_ID | Allow NULL? |
| 8 | STORAGE_TEMPL | Storage directory template | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_STORAGE_TEMPL | Allow NULL? |
| 9 | STORAGE_ROOT_DYN | SAP Property | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_SAP_PROP | Allow NULL? |
| 10 | STORAGE_ROOT_CON | Livelink folder ID | int | 10 | 0 | INT4 | ((0)) | Yes | | /OTX/RMCON_DE_LLFOLDER_ID | Allow NULL? |
| 11 | STORAGE_ROOT_OBJ | Workspace Object Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | /OTX/RM_TPWSC | /OTX/RMCON_DE_WORKSP_OBJTYPE | Allow NULL? |
| 12 | STORAGE_ROOT_USE | Storage root type (constant, workspace, business property) | char | 1 | 0 | CHAR | (N' ') | Yes | | /OTX/RMCON_DE_STOR_ROOT_TYPE | Allow NULL? |
| 13 | TITLE_TEMPL | Title template | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_TITLE_TEMPL | Allow NULL? |
| 14 | RECORD_DATE_DYN | Record date property | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_REC_DATE_PROP | Allow NULL? |
| 15 | RECORD_DATE_CON | Record date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /OTX/RM_DE_REC_DATE | Allow NULL? |
| 16 | RECORD_DATE_USE | Value mapping (D=dynamic value, C=constant value, T=templ.) | char | 1 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_VALUE_MAPPING | Allow NULL? |
| 17 | CLASS_ID_CON | Classification ID | int | 10 | 0 | INT4 | ((0)) | Yes | | /OTX/RM_DE_CLASS_ID | Allow NULL? |
| 18 | CLASS_ID_DYN | SAP Property | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_SAP_PROP | Allow NULL? |
| 19 | CLASS_ID_TEM | Class Id template | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_CLASS_ID_TEMPL | Allow NULL? |
| 20 | CLASS_ID_USE | Value mapping (D=dynamic value, C=constant value, T=templ.) | char | 1 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_VALUE_MAPPING | Allow NULL? |
| 21 | OFFICIAL_CON | Mark official record indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_OFFICIAL | Allow NULL? |
| 22 | OFFICIAL_DYN | SAP Property | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_SAP_PROP | Allow NULL? |
| 23 | OFFICIAL_USE | Value mapping (D=dynamic value, C=constant value, T=templ.) | char | 1 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_VALUE_MAPPING | Allow NULL? |
| 24 | STATUS_CON | Record status | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_STATUS | Allow NULL? |
| 25 | STATUS_DYN | SAP Property | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_SAP_PROP | Allow NULL? |
| 26 | STATUS_USE | Value mapping (D=dynamic value, C=constant value, T=templ.) | char | 1 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_VALUE_MAPPING | Allow NULL? |
| 27 | STATUS_DATE_CON | Record status date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /OTX/RM_DE_STATUS_DATE | Allow NULL? |
| 28 | STATUS_DATE_DYN | SAP Property | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_SAP_PROP | Allow NULL? |
| 29 | STATUS_DATE_USE | Value mapping (D=dynamic value, C=constant value, T=templ.) | char | 1 | 0 | CHAR | (N' ') | Yes | | /OTX/RM_DE_VALUE_MAPPING | Allow NULL? |
