WKWOTSK

Work Order Tasks


Field Name	Caption	Mask	Description		Field Type
WT_AC_ID	Account Rec #	nnnnnnnnn	Link To WKACCTNO.AC_ID		Long Integer
WT_ACCOUNT	Account #	45x	Account #		Text
WT_ADR_B2	Street Post Bldg No	8x	Street Post Building No		Text
WT_ADR_BDG	Address	nnnnnn	Address : Building Number		Long Integer
WT_ADR_DIR	Street Direction	2x	Street Direction		Text
WT_ADR_PT	Street Prefix Type	5x	Street Prefix Type		Text
WT_ADR_SFX	Street Suffix	5x	Street Suffix		Text
WT_ADR_STR	Street Name	50x	Street Name		Text
WT_ADR_TY	Street Type	5x	Street Type		Text
WT_CALCUC	Calc'd Unit Cost	nnnnnnn.nn	Calc Unit Cost		Double
WT_CAT_INV	GBA System Category		Link to WKCATINV.CI_ID - Lucity System Category		Long Integer
WT_CITY_CD	Facility	nnn	Facility		Integer
WT_CITY_TY	Facility Text	50x	Facility Text		Text
WT_CLASS	Class	40x	Class		Text
WT_CONCST	Total Contractor Cost:	nnnnnnnn.nn	Total Contractor Cost:		Double
WT_CONDIF	Contractor Cost Diff	-nnnnnnnn.nn	Contractor Cost Difference		Double
WT_CONEST	Est Contractor Cost	nnnnnnnn.nn	Estimated Contractor Cost		Double
WT_CREW_CD	Task Crew	10x	Crew		Text
WT_CREW_TY	Task Crew Text	25x	Crew Text		Text
WT_CREWRS			Crew Supervisor Unique ID		Boolean
WT_CRT_BY	Created By	25x	Created By		Text
WT_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time		Date/Time
WT_DEPT_CD	Department	10x	Department		String
WT_DEPT_TY	Department Text	50x	Department Text		String
WT_DIV_CD	Division Code	10x	Division Code		String
WT_DIV_TY	Division Description	40x	Division Description		String
WT_DOC_FLG	Document Available		Doc Available: Doc Flag		Boolean
WT_DT1_DT	User Date 1	mm/dd/yyyy	User Date 1		Date/Time
WT_DT2_DT	User Date 2	mm/dd/yyyy	User Date 2		Date/Time
WT_DT3_DT	User Date 3	mm/dd/yyyy	User Date 3		Date/Time
WT_DT4_DT	User Date 4	mm/dd/yyyy	User Date 4		Date/Time
WT_EA_ID	Eden Acct Rec #	nnnnnnnnn	Link to WKEACCTNO.EA_ID		Long Integer
WT_END_DT	Task End Date	mm/dd/yyyy	End Date		Date/Time
WT_END_DT	Task End Date	mm/dd/yyyy	End Date		Date/Time
WT_END_TM	Task End Time	hh:mm am	End Time		Date/Time
WT_EP_ID	Eden Proj Rec #	nnnnnnnnn	Link to WKEPROJNO.EP_ID		Long Integer
WT_EQ_ACT	Actual Equip Cost	nnnnn.nn	Actual Equipment Cost		Double
WT_EQ_DIF	Equipment Cost Diff	-nnnnn.nn	Equipment Cost Difference		Double
WT_EQ_EST	Est Equipment Cost	nnnnn.nn	Est Equipment Cost		Double
WT_FIXEDIMP	Fixed Asset Cost Imported			Fixed Asset Cost Import Flag		Boolean
WT_FLUDCST	Total Fluid Cost:	nnnnnnnn.nn	Total Fluid Cost:		Double
WT_FLUDDIF	Fluid Cost Diff	-nnnnnnnn.nn	Fluid Cost Difference		Double
WT_FLUDEST	Est Fluid Cost	nnnnnnnn.nn	Estimated Fluid Cost		Double
WT_GENLOC	General Location	200x	General Location		Text
WT_HANDHELD		50x	Handheld Name		Text
WT_HOURS	Hours	nnnnnnnnn.	Hours		Double
WT_ID	Task Rec #	nnnnnnnn	Unique ID		Long Integer
WT_IMG_FLG			Image Available		Boolean
WT_INIDTTM	Initiated Date/Time	mm/dd/yyyy hh:mm am	Initiated Date/Time		Date/Time
WT_INV_ID	Asset Rec #	-nnnnnnnn	Asset Auto ID: to get the inventory table information		Long Integer
WT_LC_ACT	Actual Labor Cost	nnnnn.nn	Actual Labor Cost		Double
WT_LC_DIF	Labor Cost Diff	-nnnnn.nn	Labor Cost Difference		Double
WT_LC_EST	Est Labor Cost	nnnnn.nn	Est Labor Cost		Double
WT_LH_ACT	Actual Labor Hours	nnnn.nn	Actual Labor Hours		Double
WT_LH_DIF	Labor Hour Diff	-nnnnn.nn	Labor Hour Difference		Double
WT_LH_EST	Est Labor Hours	nnnn.nn	Est Labor Hours		Double
WT_LINK1	System ID 1	150x	Link 1		Text
WT_LINK2	System ID 2	150x	Link 2		Text
WT_LOCNO	Seq No	nnn	Sequence Number		Integer
WT_MAT_ACT	Actual Material Cost	nnnnn.nn	Actual Material Cost		Double
WT_MAT_DIF	Material Cost Diff	-nnnnn.nn	Material Cost Difference		Double
WT_MAT_EST	Est Material Cost	nnnnn.nn	Est Material Cost		Double
WT_MBL_ID			Copy of WT_ID for mobile device		Long Integer
WT_MISCCST	Misc. Cost:	nnnnnnnn.nn	Misc. Cost:		Double
WT_MISCDIF	Misc. Cost Diff	-nnnnnnnn.nn	Misc. Cost Difference		Double
WT_MISCEST	Est Misc. Cost	nnnnnnnn.nn	Estimated Misc. Cost		Double
WT_MOD_BY	Last Modified By	25x	Last Modified By		Text
WT_MOD_DT	Last Modified Date	mm/dd/yyyy	Last Modified Date		Date/Time
WT_MOD_TM	Last Modified Time	hh:mm am	Modified Time		Date/Time
WT_MOV_FLG			Movie Available		Boolean
WT_OID			Visual CE Linking Field		Long Integer
WT_PNUMACT	Proj No - Acct	40x	Proj No - Acct		Text
WT_PT_ID			Link to WKPTASK.PT_ID		Long Integer
WT_REQ	Required		Required Routing Step		Boolean
WT_RES_ACT	Use Actual Res Cost		Use Actual Resource Cost?		Boolean
WT_RES_EST	Use Est Res Cost		Use Estimated Resource Cost?		Boolean
WT_ROWVER			Rowversion for optimistic locking		Date/Time
WT_STAT_CD	Status	nnn	Status		Integer
WT_STAT_TY	Status Text	25x	Status Txt		Text
WT_STAT_TY	Status Text	25x	Status Txt		Text
WT_STRT_DT	Task Start Date	mm/dd/yyyy	Start Date		Date/Time
WT_STRT_DT	Task Start Date	mm/dd/yyyy	Start Date		Date/Time
WT_STRT_TM	Task Start Time	hh:mm am	Start Time		Date/Time
WT_SUPR_CD	Task Supervisor	20x	Supervisor		Text
WT_SUPR_TY	Task Supervisor Text	40x	Supervisor Text		Text
WT_SUPR_TY	Task Supervisor Text	40x	Supervisor Text		Text
WT_TASK_CD	Task	20x	Task		Text
WT_TASK_TY	Task Text	75x	Task Text		Text
WT_TC_DIF	Total Cost Diff	-nnnnnn.nn	Total Cost Difference		Double
WT_TC_EST	Est Total Cost	nnnnnn.nn	Est Total Cost		Double
WT_TIMESTAMP	Mobile Timestamp	mm/dd/yyyy	Timestamp for Visual CE		Date/Time
WT_TM1_TM	User Time 1	hh:mm am	User Time 1		Date/Time
WT_TM2_TM	User Time 2	hh:mm am	User Time 2		Date/Time
WT_TM3_TM	User Time 3	hh:mm am	User Time 3		Date/Time
WT_TM4_TM	User Time 4	hh:mm am	User Time 4		Date/Time
WT_TOTCOST	Total Cost	nnnnnnn.nn	Total Cost		Double
WT_UNIT_C	Unit Cost	nnnnn.nnn	Unit Cost		Double
WT_UNIT_M		10x	Unit of Measure		Text
WT_UNITLOCK	Lock Units		Locks the WT_UNITS field so that it is not re-auto calculated		Boolean
WT_UNITMTHD	Unit Calc Method	10x	Method used to auto calculate units		Text
WT_UNITS	# of Units	nnnnn.nn	# of Units		Double
WT_UOM_CD	Unit of Measure	5x	Unit of Measure		Text
WT_UOM_TY	Unit of Measure Text	25x	Unit of Measure Text		Text
WT_USER1CD	Task User 1	nnn	User 1		Integer
WT_USER1TY	Task User 1 Text	25x	User 1 Text		Text
WT_USER2	Task User 2	-nnnnnnnn.nn	User 2		Double
WT_USR3_CD	Task User 3	10x	User 3		Text
WT_USR3_TY	Task User 3 Text	60x	User 3 Text		Text
WT_USER4	User 4	nnnnnnn.nn	User 4		Double
WT_USER5	User 5	nnnnnnn.nn	User 5		Double
WT_USER6	User 6	nnnnnnn.nn	User 6		Double
WT_USER7CD	Task User 7	nnn	User 7		Integer
WT_USER7TY	Task User 7 Text	25x	User 7 Text		Text
WT_USER8CD	Task User 8	nnn	User 8		Integer
WT_USER8TY	Task User 8 Text	25x	User 8 Text		Text
WT_USER9CD	Task User 9	nnn	User 9		Integer
WT_USER9TY	Task User 9 Text	25x	User 9 Text		Text
WT_USER10	Task User 10		Task User 10		Boolean
WT_USER11	Task User11		Task User11		Boolean
WT_USER12	Task User 12		Task User 12		Boolean
WT_USER13	Task User 13		Task User 13		Boolean
WT_WF_ID	Routing Rec #	nnnnn	Link to WKWOFLOW.WF_ID		Long Integer
WT_WO_ID	Work Order Rec #	nnnnnnnn	Link to WKORDER.WO_ID		Long Integer