Field Listing for Table ASSIGNMENTRESOURCES
Field: | ASSIGNMENTID | Type: | DOUBLE |
Field: | ASSIGNMENTTYPE | Type: | VARCHAR Length: 20 |
Field: | ASSIGNMENTSUBJECT | Type: | VARCHAR Length: 200 |
Field: | ASSIGNMENTLOCATION | Type: | VARCHAR Length: 200 |
Field: | ASSIGNMENTMESSAGE | Type: | BLOB |
Field: | RESOURCETYPE | Type: | VARCHAR Length: 20 |
Field: | RESOURCENAME | Type: | VARCHAR Length: 30 |
Field: | RESOURCESTARTTIME | Type: | TIMESTAMP |
Field: | RESOURCEFINISHTIME | Type: | TIMESTAMP |
Field: | CALENDARRESOURCEID | Type: | INTEGER |
Field: | DECOUPLED | Type: | BOOLEAN |
Field: | ASSIGNMENTICON | Type: | VARCHAR Length: 30 |
Field: | NOOFRESOURCES | Type: | INTEGER |
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: | BLOCKEDFLAG | Type: | BOOLEAN |
Field: | BLOCKEDID | Type: | DOUBLE |
Field: | ACTUALFLAG | Type: | BOOLEAN |
Field: | ACTUALID | Type: | DOUBLE |
Field: | RESOURCEFINISHED | Type: | BOOLEAN |
Field: | ACTUALINPROGRESS | Type: | BOOLEAN |
Field: | SOURCEID | Type: | DOUBLE |
Field: | SOURCENAME | Type: | VARCHAR Length: 20 |
Field: | JOBTASKUPDATED | Type: | BOOLEAN |
Field: | DELETEDFROMTASK | Type: | BOOLEAN |
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 |
Field: | ORIGINALPOOLINGRESOURCE | Type: | VARCHAR Length: 30 |
Field: | ORIGINALSTARTTIME | Type: | TIMESTAMP |
Field: | ORIGINALFINISHTIME | Type: | TIMESTAMP |
Field: | MOVEID | Type: | DOUBLE |