Field Listing for Table LABOURMASTER

Field:LABOURCODE Type: VARCHAR Length: 50
Field:LABOURDESCRIPTION Type: VARCHAR Length: 255
Field:LABOURUNIT Type: VARCHAR Length: 15
Field:LABOURSTATUS Type: VARCHAR Length: 20
Field:LABOURBARCODE Type: VARCHAR Length: 30
Field:LABOURCATEGORY Type: VARCHAR Length: 20
Field:TAXGROUP Type: VARCHAR Length: 10
Field:ANALYSISGROUP Type: VARCHAR Length: 20
Field:PRICINGGROUP Type: VARCHAR Length: 20
Field:COSTCENTRECODE Type: VARCHAR Length: 50
Field:DEPARTMENTCODE Type: VARCHAR Length: 20
Field:STDSELLRATE Type: DOUBLE
Field:STANDARDCOST Type: DOUBLE
Field:LABOURDIRECTCOST Type: DOUBLE
Field:LABOURFIXEDOHCOST Type: DOUBLE
Field:LABOURVAROHPERCENT Type: DOUBLE
Field:LASTCOST Type: DOUBLE
Field:AVERAGECOST Type: DOUBLE
Field:WARRANTYAPPLIES Type: BOOLEAN
Field:WARRANTYCODE Type: VARCHAR Length: 20
Field:LASTRATEUPDATEDATE Type: TIMESTAMP
Field:DAILYCAPACITY Type: DOUBLE
Field:LABOURNOTES Type: BLOB
Field:SALESNOTES Type: BLOB
Field:JOBNOTES Type: BLOB
Field:PURCHASENOTES Type: BLOB
Field:ASSEMBLYNOTES Type: BLOB
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:PRICEFROMRECEIPTCOST Type: BOOLEAN
Field:RECEIPTCOSTMARKUP Type: DOUBLE
Field:ADDLINECODESTYLE Type: BOOLEAN
Field:LABOURSUBCATEGORY Type: VARCHAR Length: 20
Field:SALESMESSAGE Type: VARCHAR Length: 200
Field:JOBMESSAGE Type: VARCHAR Length: 200
Field:PURCHASEMESSAGE Type: VARCHAR Length: 200
Field:ASSEMBLYMESSAGE Type: VARCHAR Length: 200
Field:CAPACITYTYPE Type: VARCHAR Length: 10
Field:SUNDAYSTARTTIME Type: TIME
Field:LASTSCHEDULETIME Type: TIMESTAMP
Field:NOOFRESOURCES Type: INTEGER
Field:MINIMUMGAPINMINUTES Type: INTEGER
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:SCHEDULECONTINUOUSLY Type: BOOLEAN
Field:SCHEDULEEFFICIENCYPERCENT Type: DOUBLE
Field:SCHEDULECODE Type: VARCHAR Length: 50
Field:REQUIRESSCHEDULING Type: BOOLEAN
Field:NOSCHEDULING Type: BOOLEAN
Field:BUDGETREPRESENTATIVECODE Type: VARCHAR Length: 50
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30