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 |