Field Listing for Table RESOURCEMASTER

Field:RESOURCETYPE Type: VARCHAR Length: 20
Field:RESOURCENAME Type: VARCHAR Length: 30
Field:RESOURCENUMBER Type: VARCHAR Length: 20
Field:RESOURCESTATUS Type: VARCHAR Length: 20
Field:DEPARTMENTCODE Type: VARCHAR Length: 20
Field:RESOURCESTARTDATE Type: DATE
Field:RESOURCEENDDATE Type: DATE
Field:RESOURCENOTES Type: BLOB
Field:EMPLOYEETITLE Type: VARCHAR Length: 5
Field:EMPLOYEEFIRSTNAME Type: VARCHAR Length: 15
Field:EMPLOYEELASTNAME Type: VARCHAR Length: 15
Field:EMPLOYEEPOSITION Type: VARCHAR Length: 20
Field:EMPLOYEEPHONE Type: VARCHAR Length: 20
Field:EMPLOYEEFAX Type: VARCHAR Length: 20
Field:EMPLOYEEEMAIL Type: VARCHAR Length: 100
Field:EMPLOYEEMOBILE Type: VARCHAR Length: 20
Field:EMPLOYEECLASSIFICATION Type: VARCHAR Length: 15
Field:EMPLOYEELABOURCODE Type: VARCHAR Length: 50
Field:EMPLOYEEHOURLYCOST Type: DOUBLE
Field:EMPLOYEEADDRESS1 Type: VARCHAR Length: 50
Field:EMPLOYEEADDRESS2 Type: VARCHAR Length: 50
Field:EMPLOYEEADDRESS3 Type: VARCHAR Length: 50
Field:EMPLOYEEPOSTALCODE Type: VARCHAR Length: 20
Field:EMPLOYEESTATE Type: VARCHAR Length: 20
Field:EMPLOYEECITY Type: VARCHAR Length: 30
Field:EMPLOYEECOUNTRY Type: VARCHAR Length: 30
Field:EMPLOYEEHOMEPHONE Type: VARCHAR Length: 20
Field:EMPLOYEESKILLS Type: BLOB
Field:ISSALESPERSON Type: BOOLEAN
Field:ISBUYER Type: BOOLEAN
Field:EMERGENCYCONTACT Type: VARCHAR Length: 30
Field:EMERGENCYPHONE1 Type: VARCHAR Length: 20
Field:EMERGENCYPHONE2 Type: VARCHAR Length: 20
Field:ANNUALLEAVEDAYS Type: INTEGER
Field:ANNUALSICKDAYS Type: INTEGER
Field:ASSETTYPE Type: VARCHAR Length: 20
Field:ASSETDESCRIPTION Type: VARCHAR Length: 50
Field:ASSETLOCATION Type: VARCHAR Length: 50
Field:ASSETSUPPLIER Type: VARCHAR Length: 50
Field:ASSETSITENAME Type: VARCHAR Length: 50
Field:ASSETPURCHASEORDER Type: VARCHAR Length: 15
Field:ASSETPURCHASEVALUE Type: DOUBLE
Field:ASSETPURCHASEDATE Type: DATE
Field:ASSETWARRANTYAPPLIES Type: BOOLEAN
Field:ASSETWARRANTYEXPIRY Type: DATE
Field:ASSETWARRANTYREFERENCE Type: VARCHAR Length: 50
Field:CURRENTASSETSITE Type: VARCHAR Length: 20
Field:COSTCENTRECODE Type: VARCHAR Length: 50
Field:REMINDERUSERNAME Type: VARCHAR Length: 30
Field:EXCLUDEFROMJOBPLANNING Type: BOOLEAN
Field:POSPWORD Type: VARCHAR Length: 100
Field:ISPOSOPERATOR Type: BOOLEAN
Field:POSCANCHANGEPRICE Type: BOOLEAN
Field:POSCANCHANGEDATE Type: BOOLEAN
Field:POSREALTEDBUTTONSSEC Type: BLOB
Field:POSPAYOUTWITHNOSALE Type: BOOLEAN
Field:POSSALESPERSON Type: VARCHAR Length: 30
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:NOSCHEDULING Type: BOOLEAN
Field:CALENDARORDER Type: INTEGER
Field:POSDISPLAYCOSTS Type: BOOLEAN
Field:POSNOCUSTOMERCREATION Type: BOOLEAN
Field:LINKEDCUSTASSETNAME Type: VARCHAR Length: 90
Field:ASSETTIMECHARGECODE Type: VARCHAR Length: 50
Field:RESOURCEIMAGEID Type: INTEGER
Field:NOOFRESOURCES Type: INTEGER
Field:SUBCONTRACTORSUPPLIER Type: VARCHAR Length: 50
Field:ASSETFORTIMESHEETS Type: VARCHAR Length: 30
Field:MAXWEIGHT Type: DOUBLE
Field:MAXVOLUME Type: DOUBLE
Field:ASSIGNMENTPRIORITY Type: INTEGER
Field:SUNDAYSTARTTIME Type: TIME
Field:MONDAYSTARTTIME Type: TIME
Field:TUESDAYSTARTTIME Type: TIME
Field:WEDNESDAYSTARTTIME Type: TIME
Field:THURSDAYSTARTTIME Type: TIME
Field:FRIDAYSTARTTIME Type: TIME
Field:SATURDAYSTARTTIME Type: TIME
Field:SUNDAYENDTIME Type: TIME
Field:MONDAYENDTIME Type: TIME
Field:TUESDAYENDTIME Type: TIME
Field:WEDNESDAYENDTIME Type: TIME
Field:THURSDAYENDTIME Type: TIME
Field:FRIDAYENDTIME Type: TIME
Field:SATURDAYENDTIME Type: TIME
Field:TEAMNAME Type: VARCHAR Length: 20
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:POSPAYMENTONLY Type: BOOLEAN