| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | OBJECT_GUID | GUID for an Assigned Object | varbinary | 16 | 0 | | | | |
| 3 | QMNUM | Notification No | nvarchar | 12 | 0 | | | | Allow NULL? |
| 4 | FENUM | Item Number in Item Record | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | SORT_NO | Sort Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | OBJCAT | Object Category for an Assigned Object | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | KEYFIELD_01 | Partial Key for an Assigned Object | nvarchar | 40 | 0 | | | | Allow NULL? |
| 8 | KEYFIELD_02 | Partial Key for an Assigned Object | nvarchar | 40 | 0 | | | | Allow NULL? |
| 9 | KEYFIELD_03 | Partial Key for an Assigned Object | nvarchar | 40 | 0 | | | | Allow NULL? |
| 10 | SHORTTEXT | Comment for Assigned Object | nvarchar | 40 | 0 | | | | Allow NULL? |
| 11 | CREATED_BY | Name of User Who Created the Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 12 | CREATED_TSTMP | Time Stamp for Assignment of Object | decimal | 15 | 0 | | | | |
| 13 | LAST_CHGED_BY | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 14 | LAST_CHGED_TSTMP | Time Stamp for Last Change to Assigned Object | decimal | 15 | 0 | | | | |
