| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PROFILE_ID | Declaration ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | DESCRIPTION | Description | nvarchar | 255 | 0 | | | | Allow NULL? |
| 4 | PROPS_PROVIDER | Property provider | nvarchar | 32 | 0 | | | | Allow NULL? |
| 5 | LES_ID | Enterprise Library ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | ELIB_TYPE | ELib type (Obsolete) | nvarchar | 128 | 0 | | | | Allow NULL? |
| 7 | SYS_CAT_ID | System category ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | STORAGE_TEMPL | Storage directory template | nvarchar | 255 | 0 | | | | Allow NULL? |
| 9 | STORAGE_ROOT_DYN | SAP Property | nvarchar | 32 | 0 | | | | Allow NULL? |
| 10 | STORAGE_ROOT_CON | Livelink folder ID | int | 10 | 0 | | | | Allow NULL? |
| 11 | STORAGE_ROOT_OBJ | Workspace Object Type | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | STORAGE_ROOT_USE | Storage root type (constant, workspace, business property) | char | 1 | 0 | | | | Allow NULL? |
| 13 | TITLE_TEMPL | Title template | nvarchar | 255 | 0 | | | | Allow NULL? |
| 14 | RECORD_DATE_DYN | Record date property | nvarchar | 32 | 0 | | | | Allow NULL? |
| 15 | RECORD_DATE_CON | Record date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | RECORD_DATE_USE | Value mapping (D=dynamic value, C=constant value, T=templ.) | char | 1 | 0 | | | | Allow NULL? |
| 17 | CLASS_ID_CON | Classification ID | int | 10 | 0 | | | | Allow NULL? |
| 18 | CLASS_ID_DYN | SAP Property | nvarchar | 32 | 0 | | | | Allow NULL? |
| 19 | CLASS_ID_TEM | Class Id template | nvarchar | 255 | 0 | | | | Allow NULL? |
| 20 | CLASS_ID_USE | Value mapping (D=dynamic value, C=constant value, T=templ.) | char | 1 | 0 | | | | Allow NULL? |
| 21 | OFFICIAL_CON | Mark official record indicator | char | 1 | 0 | | | | Allow NULL? |
| 22 | OFFICIAL_DYN | SAP Property | nvarchar | 32 | 0 | | | | Allow NULL? |
| 23 | OFFICIAL_USE | Value mapping (D=dynamic value, C=constant value, T=templ.) | char | 1 | 0 | | | | Allow NULL? |
| 24 | STATUS_CON | Record status | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | STATUS_DYN | SAP Property | nvarchar | 32 | 0 | | | | Allow NULL? |
| 26 | STATUS_USE | Value mapping (D=dynamic value, C=constant value, T=templ.) | char | 1 | 0 | | | | Allow NULL? |
| 27 | STATUS_DATE_CON | Record status date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | STATUS_DATE_DYN | SAP Property | nvarchar | 32 | 0 | | | | Allow NULL? |
| 29 | STATUS_DATE_USE | Value mapping (D=dynamic value, C=constant value, T=templ.) | char | 1 | 0 | | | | Allow NULL? |