Field Listing for Table JOBTASKS
Field: | ORDERNUMBER | Type: | VARCHAR Length: 15 |
Field: | TASKSEQUENCE | Type: | INTEGER |
Field: | TASKNAME | Type: | VARCHAR Length: 20 |
Field: | TASKDESCRIPTION | Type: | VARCHAR Length: 50 |
Field: | TASKTOJOBLINES | Type: | VARCHAR Length: 50 |
Field: | TASKBILLCODE | Type: | VARCHAR Length: 50 |
Field: | TASKBILLDESCRIPTION | Type: | VARCHAR Length: 255 |
Field: | TASKBILLUNIT | Type: | VARCHAR Length: 15 |
Field: | TASKBILLQTY | Type: | DOUBLE |
Field: | TASKBILLUNITPRICE | Type: | DOUBLE |
Field: | TASKBILLTAXCODE | Type: | VARCHAR Length: 10 |
Field: | TASKBILLANALYSISGROUP | Type: | VARCHAR Length: 20 |
Field: | TASKINSTRUCTIONS | Type: | BLOB |
Field: | BOOKINGSTATUS | Type: | VARCHAR Length: 20 |
Field: | TASKSTART | Type: | TIMESTAMP |
Field: | TASKSTARTDATE | Type: | DATE |
Field: | TASKSTARTTIME | Type: | TIME |
Field: | TASKFINISH | Type: | TIMESTAMP |
Field: | TASKFINISHDATE | Type: | DATE |
Field: | TASKFINISHTIME | Type: | TIME |
Field: | TASKSTATUS | Type: | VARCHAR Length: 20 |
Field: | TASKSTATUSID | Type: | INTEGER |
Field: | WORKFLOWSTATUS | Type: | VARCHAR Length: 20 |
Field: | TRACKINGCOLOUR | Type: | INTEGER |
Field: | DURATIONSCALE | Type: | VARCHAR Length: 10 |
Field: | TASKESTIMATEDDURATION | Type: | DOUBLE |
Field: | PRICEOVERRIDE | Type: | BOOLEAN |
Field: | COSTCALCULATEDPERCENT | Type: | DOUBLE |
Field: | COSTESTIMATEDPERCENT | Type: | DOUBLE |
Field: | COSTVARIANCETOCALC | Type: | DOUBLE |
Field: | COSTCALCULATEDOVERRIDE | Type: | BOOLEAN |
Field: | COSTCOMPLETIONCOMMENT | Type: | VARCHAR Length: 30 |
Field: | TIMECALCULATEDPERCENT | Type: | DOUBLE |
Field: | TIMEESTIMATEDPERCENT | Type: | DOUBLE |
Field: | TIMEVARIANCETOCALC | Type: | DOUBLE |
Field: | TIMECALCULATEDOVERRIDE | Type: | BOOLEAN |
Field: | TIMECOMPLETIONCOMMENT | Type: | VARCHAR Length: 30 |
Field: | TASKPLANNEDCOSTS | Type: | DOUBLE |
Field: | TASKACTUALCOSTS | Type: | DOUBLE |
Field: | TASKREMAININGCOSTS | Type: | DOUBLE |
Field: | TASKACTPLANCOSTPERCENT | Type: | DOUBLE |
Field: | TASKPLANNEDTIME | Type: | DOUBLE |
Field: | TASKACTUALTIME | Type: | DOUBLE |
Field: | TASKREMAININGTIME | Type: | DOUBLE |
Field: | TASKACTPLANTIMEPERCENT | Type: | DOUBLE |
Field: | TASKORIGINALPRICE | Type: | DOUBLE |
Field: | TASKPROJECTEDPRICE | Type: | DOUBLE |
Field: | TASKPROJECTEDCOSTS | Type: | DOUBLE |
Field: | TASKPROJECTEDTIME | Type: | DOUBLE |
Field: | TASKPROJECTEDMARGIN | Type: | DOUBLE |
Field: | COSTCALCULATEDTODATE | Type: | DOUBLE |
Field: | COSTCALCULATEDTOTAL | Type: | DOUBLE |
Field: | TIMECALCULATEDTODATE | Type: | DOUBLE |
Field: | TIMECALCULATEDTOTAL | Type: | DOUBLE |
Field: | TASKPROPLANCOSTPERCENT | Type: | DOUBLE |
Field: | TASKPROPLANTIMEPERCENT | Type: | DOUBLE |
Field: | HIGHERCOSTS | Type: | BOOLEAN |
Field: | HIGHERUSAGE | Type: | BOOLEAN |
Field: | LOWERUSAGE | Type: | BOOLEAN |
Field: | HIGHERTIME | Type: | BOOLEAN |
Field: | LOWERTIME | Type: | BOOLEAN |
Field: | LOWERCOSTS | Type: | BOOLEAN |
Field: | COSTESTIMATEDTODATE | Type: | DOUBLE |
Field: | TIMEESTIMATEDTODATE | Type: | DOUBLE |
Field: | DEPARTMENTCODE | Type: | VARCHAR Length: 20 |
Field: | TASKCUSTOMER | Type: | VARCHAR Length: 50 |
Field: | ORDERANDTASK | Type: | VARCHAR Length: 36 |
Field: | NOSCHEDULING | Type: | BOOLEAN |
Field: | ADDITIONALFIELD_1 | Type: | VARCHAR Length: 100 |
Field: | ADDITIONALFIELD_2 | Type: | VARCHAR Length: 100 |
Field: | ADDITIONALFIELD_3 | Type: | VARCHAR Length: 100 |
Field: | ADDITIONALFIELD_4 | Type: | VARCHAR Length: 100 |
Field: | ADDITIONALFIELD_5 | Type: | VARCHAR Length: 100 |
Field: | ADDITIONALFIELD_6 | Type: | VARCHAR Length: 100 |
Field: | ADDITIONALFIELD_7 | Type: | VARCHAR Length: 100 |
Field: | ADDITIONALFIELD_8 | Type: | VARCHAR Length: 100 |
Field: | ADDITIONALDATEFIELD_1 | Type: | DATE |
Field: | ADDITIONALDATEFIELD_2 | Type: | DATE |
Field: | ADDITIONALDATEFIELD_3 | Type: | DATE |
Field: | ADDITIONALDATEFIELD_4 | Type: | DATE |
Field: | ADDITIONALDATEFIELD_5 | Type: | DATE |
Field: | ADDITIONALDATEFIELD_6 | Type: | DATE |
Field: | ADDITIONALDATEFIELD_7 | Type: | DATE |
Field: | ADDITIONALDATEFIELD_8 | Type: | DATE |
Field: | TASKRESOURCESTART | Type: | TIMESTAMP |
Field: | TASKRESOURCEFINISH | Type: | TIMESTAMP |
Field: | TASKALLOCATIONHOURS | Type: | DOUBLE |
Field: | ALLOCATIONHOURSUPDATE | Type: | INTEGER |
Field: | RESOURCESASSIGNED | Type: | BOOLEAN |
Field: | ASSETNAME | Type: | VARCHAR Length: 90 |
Field: | STEPOVERLAP | Type: | VARCHAR Length: 20 |
Field: | OVERLAPMINUTES | Type: | DOUBLE |
Field: | BUFFERMINUTES | Type: | DOUBLE |
Field: | LASTSCHEDULETIME | Type: | TIMESTAMP |
Field: | STARTSCHEDULETIME | Type: | TIMESTAMP |
Field: | CALENDARRESOURCEID | Type: | BLOB |
Field: | TASKASSIGNED | Type: | BOOLEAN |
Field: | FINISHEDDATE | Type: | DATE |
Field: | DELETINGTASK | Type: | BOOLEAN |
Field: | STYLENAME | Type: | VARCHAR Length: 50 |
Field: | ASSETDESCRIPTION | Type: | VARCHAR Length: 100 |
Field: | ASSETSERVICED | Type: | BOOLEAN |
Field: | REASONFORNONSERVICE | Type: | VARCHAR Length: 100 |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |