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