| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PHIO_CLASS | Document class | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | PHIO_OBJID | ID for documents and relations | nvarchar | 32 | 0 | | | | Allow NULL? |
| 4 | GUID | Globally Unique identifier | varbinary | 16 | 0 | | | | |
| 5 | P_GUID | Parent GUID | varbinary | 16 | 0 | | | | |
| 6 | LOGICAL_SYSTEM | Business Document Service: ID of Logical System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | CLASSNAME | Business Document Service: Class name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 8 | CLASSTYPE | Business Document Service: Class type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | OBJKEY | Business Document Service: Object key | nvarchar | 70 | 0 | | | | Allow NULL? |
| 10 | DOC_ID | Business Document Service: Document ID | nvarchar | 42 | 0 | | | | Allow NULL? |
| 11 | DOC_VER_NO | Business Document Service: Document version number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | DOC_VAR_ID | Business Document Service: Document variant ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | DESCRIPTION | Attachment Description | nvarchar | 64 | 0 | | | | Allow NULL? |
| 14 | URL | URL Case-Sensitive | nvarchar | 255 | 0 | | | | Allow NULL? |
| 15 | TYPE | Procurement Document Attachment Type | char | 1 | 0 | | | | Allow NULL? |
| 16 | INTERNAL_IND | Indicator Showing if Attachment is only for Internal Use | char | 1 | 0 | | | | Allow NULL? |
| 17 | DEL_IND | Deletion Indicator SRM Purchasing Document | char | 1 | 0 | | | | Allow NULL? |
| 18 | CATEG | Category Attachment | char | 1 | 0 | | | | Allow NULL? |
| 19 | CREATIONTIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 20 | LOIO_CLASS | Document class | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | LOIO_OBJID | ID for documents and relations | nvarchar | 32 | 0 | | | | Allow NULL? |
| 22 | PHIO_VERSION_NO | Business Document Service: Document version number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | PHIO_MODE | PHIO Mode | char | 1 | 0 | | | | Allow NULL? |
| 24 | DISP_URL | URL Case-Sensitive | nvarchar | 255 | 0 | | | | Allow NULL? |
