| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | PHIO_ID | Physical document | nvarchar | 32 | 0 | CHAR | (N' ') | No | | SDOK_PHID | Allow NULL? |
| 2 | PH_CLASS | Physical document class | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SDOKPHCL | SDOK_PHCL | Allow NULL? |
| 3 | LOIO_ID | Logical document | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | * | SDOK_LOID | Allow NULL? |
| 4 | LO_CLASS | Class of logical document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SDOK_LOCL | Allow NULL? |
| 5 | STATE | Technical Status of a Physical Document | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SDOK_PHSTA | Allow NULL? |
| 6 | DESCRIPT | Title of a document | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | SDOK_TITEL | Allow NULL? |
| 7 | LANGU | Language Key | char | 1 | 0 | LANG | (N' ') | Yes | T002 | SPRAS | Allow NULL? |
| 8 | CREA_USER | Created by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SDOK_CRUSR | Allow NULL? |
| 9 | CREA_TIME | Creation time (UTC) | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | SDOK_CRTST | Allow NULL? |
| 10 | CHNG_USER | Last changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SDOK_CHUSR | Allow NULL? |
| 11 | CHNG_TIME | Time of change (UTC) | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | SDOK_CHTST | Allow NULL? |
| 12 | STOR_CAT | Category for physical documents | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SDOKSTCAE | SDOK_STCAT | Allow NULL? |
| 13 | DOC_FORMAT | Document format (TEXT, TIFF, RTF, PDF, ...) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | SDOKFORM | SDOK_FORM | Allow NULL? |
| 14 | DOC_PROT | Document protection | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SDOK_DPROT | Allow NULL? |
| 15 | PROP01 | Attribute feature (short version) | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | SDOK_PRV_S | Allow NULL? |
| 16 | PROP02 | Attribute feature (short version) | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | SDOK_PRV_S | Allow NULL? |
| 17 | PROP03 | Attribute feature (short version) | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | SDOK_PRV_S | Allow NULL? |
| 18 | PROP04 | Attribute feature (short version) | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | SDOK_PRV_S | Allow NULL? |
| 19 | PROP05 | Attribute feature (mid-length version) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | SDOK_PRV_M | Allow NULL? |
| 20 | PROP06 | Attribute feature (mid-length version) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | SDOK_PRV_M | Allow NULL? |
| 21 | PROP07 | Attribute feature (mid-length version) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | SDOK_PRV_M | Allow NULL? |
| 22 | PROP08 | Attribute feature (long version) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SDOK_PRV_L | Allow NULL? |
| 23 | PROP09 | Attribute feature (long version) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SDOK_PRV_L | Allow NULL? |
| 24 | PROP10 | Attribute feature (long version) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SDOK_PRV_L | Allow NULL? |
