| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | FOLTP | Object folder: Object type from ID | nvarchar | 3 | 0 | | | | Allow NULL? |
| 3 | FOLYR | Object folder: Year from ID | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | FOLNO | Object folder: Number from ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 5 | DOCTP | Object: Object Type From ID | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | DOCYR | Object: Year from ID | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | DOCNO | Object: Number from ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | FORTP | Forwarder: Object type from ID | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | FORYR | Forwarder: year from the ID | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | FORNO | Forwarder: number from the ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 11 | PERMA | SAPoffice: Object is displayed independent of selection date | char | 1 | 0 | | | | Allow NULL? |
| 12 | HOLDO | The object has status HOLD | char | 1 | 0 | | | | Allow NULL? |
| 13 | ARCHI | The document is stored in archive | char | 1 | 0 | | | | Allow NULL? |
| 14 | DLDAT | Document Expiration Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | DLTIM | Expiry time of object | nvarchar | 6 | 0 | | | | Allow NULL? |
| 16 | NOTTP | Default setting of document class | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | NOTYR | Object note: year from the ID | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | NOTNO | Object note: number from the ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | RCDAT | Date document was received | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | RCTIM | Time object was received | nvarchar | 6 | 0 | | | | Allow NULL? |
| 21 | SNDDR | Send: As disregard | char | 1 | 0 | | | | Allow NULL? |
| 22 | SNDEX | Send express | char | 1 | 0 | | | | Allow NULL? |
| 23 | SNDCP | Send: As copy | char | 1 | 0 | | | | Allow NULL? |
| 24 | SNDBC | Send as a blind copy | char | 1 | 0 | | | | Allow NULL? |
| 25 | OBJAC | The recipient must take action | char | 1 | 0 | | | | Allow NULL? |
| 26 | OBJRR | A reply must be sent for this object | char | 1 | 0 | | | | Allow NULL? |
| 27 | OBJRD | Object has already been viewed | char | 1 | 0 | | | | Allow NULL? |
| 28 | RESUB | SAPoffice: folder entry is a resubmitted object | char | 1 | 0 | | | | Allow NULL? |
| 29 | RECPRI | Priority | char | 1 | 0 | | | | Allow NULL? |
| 30 | FLAG1 | Search of private or shared folders | char | 1 | 0 | | | | Allow NULL? |
| 31 | FLAG2 | Search of private or shared folders | char | 1 | 0 | | | | Allow NULL? |
| 32 | FLAG3 | Search of private or shared folders | char | 1 | 0 | | | | Allow NULL? |
| 33 | FLAG4 | Search of private or shared folders | char | 1 | 0 | | | | Allow NULL? |
| 34 | FLAG5 | Search of private or shared folders | char | 1 | 0 | | | | Allow NULL? |
| 35 | RBDAT | Date On Which The Object Was Resubmitted | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | LFOLTP | Object folder: Object type from ID | nvarchar | 3 | 0 | | | | Allow NULL? |
| 37 | LFOLYR | Object folder: Year from ID | nvarchar | 2 | 0 | | | | Allow NULL? |
| 38 | LFOLNO | Object folder: Number from ID | nvarchar | 12 | 0 | | | | Allow NULL? |