Field Listing for Table ASSIGNMENTHEADER
| Field: | ASSIGNMENTID | Type: | DOUBLE |
| Field: | ASSIGNMENTICON | Type: | VARCHAR Length: 30 |
| Field: | ASSIGNMENTSTATUS | Type: | VARCHAR Length: 20 |
| Field: | ASSIGNMENTSTART | Type: | TIMESTAMP |
| Field: | ASSIGNMENTSTOP | Type: | TIMESTAMP |
| Field: | ASSIGNMENTTYPE | Type: | VARCHAR Length: 20 |
| Field: | ASSIGNMENTREFERENCES | Type: | VARCHAR Length: 200 |
| Field: | ASSIGNMENTRESOURCES | Type: | VARCHAR Length: 200 |
| Field: | ASSIGNMENTWARNINGS | Type: | VARCHAR Length: 200 |
| Field: | ASSIGNMENTSHORTAGES | Type: | VARCHAR Length: 200 |
| Field: | CAPABILITYSATISFIED | Type: | BOOLEAN |
| Field: | CAPABILITYMESSAGE | Type: | BLOB |
| Field: | ASSIGNMENTMESSAGE | Type: | BLOB |
| Field: | INCREATION | Type: | BOOLEAN |
| Field: | MULTIPLEREFERENCES | Type: | BOOLEAN |
| Field: | ASSIGNMENTINPROGRESS | Type: | BOOLEAN |
| Field: | ASSIGNMENTFINISHED | Type: | BOOLEAN |
| Field: | ASSIGNMENTACTUAL | Type: | BOOLEAN |
| Field: | ASSIGNMENTSUBJECT | Type: | VARCHAR Length: 200 |
| Field: | ASSIGNMENTLOCATION | Type: | VARCHAR Length: 200 |
| Field: | OVERRIDESUBJECT | Type: | BOOLEAN |
| Field: | OVERRIDESUBJECTCAPTION | Type: | VARCHAR Length: 200 |
| Field: | PLANNEDHOURS | Type: | DOUBLE |
| Field: | PLANNEDWEIGHT | Type: | DOUBLE |
| Field: | PLANNEDVOLUME | Type: | DOUBLE |
| Field: | RESOURCEHOURS | Type: | DOUBLE |
| Field: | RESOURCEWEIGHT | Type: | DOUBLE |
| Field: | RESOURCEVOLUME | Type: | DOUBLE |
| Field: | HOURSPERCENT | Type: | INT64 |
| Field: | WEIGHTPERCENT | Type: | INT64 |
| Field: | VOLUMEPERCENT | Type: | INT64 |
| Field: | TRACKINGCOLOUR | Type: | INTEGER |
| Field: | STATUSCOLOUR | Type: | INTEGER |
| Field: | HIGHLIGHTCOLOUR | Type: | INTEGER |
| Field: | SOURCEID | Type: | DOUBLE |
| Field: | SITENAME | 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: | NOTIFICATIONNAME | Type: | VARCHAR Length: 30 |
| Field: | ASSIGNMENTCANNOTBESPLIT | Type: | BOOLEAN |
| Field: | MOVEID | Type: | DOUBLE |
| Field: | FIXEDTIMESLOT | Type: | BOOLEAN |