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 |