Field Listing for Table ASSIGNMENTREFERENCES
| Field: | ASSIGNMENTID | Type: | DOUBLE |
| Field: | ASSIGNMENTSUBJECT | Type: | VARCHAR Length: 200 |
| Field: | ASSIGNMENTLOCATION | Type: | VARCHAR Length: 200 |
| Field: | ASSIGNMENTTYPE | Type: | VARCHAR Length: 20 |
| Field: | ASSIGNMENTREFERENCE | Type: | VARCHAR Length: 50 |
| Field: | ASSIGNMENTMESSAGE | Type: | BLOB |
| Field: | REFERENCEDESCRIPTION | Type: | VARCHAR Length: 500 |
| Field: | REQUIREDDATE | Type: | DATE |
| Field: | SOURCESEQUENCE | Type: | INTEGER |
| Field: | SOURCEID | Type: | DOUBLE |
| Field: | SOURCEORDERNUMBER | Type: | VARCHAR Length: 15 |
| Field: | RESOURCESTARTTIME | Type: | TIMESTAMP |
| Field: | RESOURCEFINISHTIME | Type: | TIMESTAMP |
| Field: | CALENDARRESOURCEID | Type: | INTEGER |
| Field: | ASSIGNMENTICON | Type: | VARCHAR Length: 30 |
| Field: | TIMEUPDATEFROMRESOURCE | Type: | BOOLEAN |
| Field: | TRACKINGCOLOUR | Type: | INTEGER |
| Field: | HIGHLIGHTCOLOUR | Type: | INTEGER |
| Field: | STATUSCOLOUR | Type: | INTEGER |
| Field: | OVERDUECOLOUR | Type: | INTEGER |
| Field: | OUTOFSEQCOLOUR | Type: | INTEGER |
| Field: | DOUBLEBOOKEDCOLOUR | Type: | INTEGER |
| Field: | SHORTAGECOLOUR | Type: | INTEGER |
| Field: | MULTIPLERECORDS | Type: | BOOLEAN |
| Field: | CUSTOMER | Type: | VARCHAR Length: 50 |
| Field: | SITENAME | Type: | VARCHAR Length: 50 |
| Field: | ACTUALFLAG | Type: | BOOLEAN |
| Field: | ACTUALID | Type: | DOUBLE |
| Field: | BLOCKEDFLAG | Type: | BOOLEAN |
| Field: | SOURCEPROJECT | Type: | VARCHAR Length: 30 |
| Field: | PROJECTID | Type: | DOUBLE |
| Field: | DIMENSIONSCHANGED | Type: | INTEGER |
| Field: | REFERENCEWEIGHT | Type: | DOUBLE |
| Field: | REFERENCEVOLUME | Type: | DOUBLE |
| Field: | REFERENCETIME | Type: | DOUBLE |
| Field: | ORDERUPDATED | Type: | BOOLEAN |
| Field: | ACTUALINPROGRESS | Type: | BOOLEAN |
| Field: | SERVICEZONE | Type: | VARCHAR Length: 30 |
| Field: | ZONEID | Type: | DOUBLE |
| Field: | STEPNAME | Type: | VARCHAR Length: 20 |
| Field: | ITEMCODE | Type: | VARCHAR Length: 50 |
| Field: | SYSDATECREATED | Type: | TIMESTAMP |
| Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
| Field: | SYSUNIQUEID | Type: | DOUBLE |
| Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
| Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |
| Field: | WARNINGID | Type: | DOUBLE |