WKROUTINE

Work Routines

Field Name	Caption	Mask	Description	Field Type
TO_AC_ID	Account Rec #	nnnnnnnn	Link To WKACCTNO.AC_ID	Long Integer
TO_ACCOUNT	Account #	45x	Account #	Text
TO_ACT_FLG	Inactive		Inactive	Boolean
TO_ACTN_CD	Main Task	20x	Action	Text
TO_ACTN_TY	Main Task Text	75x	Action Text	Text
TO_ADESC1	Desc 1	255x	Asset Description 1	Text
TO_ADESC2	Desc 2	255x	Asset Description 2	Text
TO_ADR_APT		25x	Apartment/Suite	Text
TO_ADR_B2	Street Post Bldg No	8x	Street Post Building No	Text
TO_ADR_BDG	Address	nnnnnn	Address - Building Number	Long Integer
TO_ADR_DIR	Street Direction	2x	Address - Direction	Text
TO_ADR_PT	Street Prefix Type	5x	Street Prefix Type	Text
TO_ADR_SFX	Street Suffix	5x	Address - Suffix	Text
TO_ADR_STR	Street Name	50x	Address - Street Name	Text
TO_ADR_TY	Street Type	5x	Address - Street Type	Text
TO_ADRDIR2		2x	Loc Street2 Direction :	Text
TO_ADRSFX2		5x	Loc Street2 Suffix :	Text
TO_ADRSTR2		50x	Loc Street2 Name :	Text
TO_ADRTY2		5x	Loc Street2 Type :	Text
TO_AFFECTEDPM	Affected PM		Affected PM	Boolean
TO_AREA_CD	Area	10x	Area Code	Text
TO_AREA_TY	Area Text	40x	Area Description	Text
TO_ASGN_CD	Assigned By	20x	Assigned By	Text
TO_ASGN_TY	Assigned By Text	40x	Assigned By Text	Text
TO_ASN_DT	Assigned Date	mm/dd/yyyy	Assigned Date	Date/Time
TO_ASN_TM	Assigned Time	hh:mm am	Assigned Time	Date/Time
TO_BADDR1	Bill Cust Address	50x	Billing Customer's Address 1	Text
TO_BCELL	Bill Cell #	20x	Bill Phone 2	Text
TO_BCITY	Bill Cust City	25x	Billing Customer's City	Text
TO_BCNAME	Contact Name	30x	Bill Contact Name	Text
TO_BCUSTID	Bill Cust ID	20x	Billing Customer's ID	Text
TO_BCUSTNO	Bill Cust No	20x	Billing Customer's No	Text
TO_BEMAIL	Bill E-mail	150x	Bill Email	Text
TO_BFAX	Bill Fax #	20x	Bill Fax	Text
TO_BFIRST	Bill Cust Name	25x	Billing Customer's First Name	Text
TO_BILLAMT	Billing Amount	nnnnnn.nn	Billing Amount	Double
TO_BLAST	Bill Cust Last Name	25x	Billing Customer's Last Name	Text
TO_BPHONE	Bill Cust Phone	20x	Billing Customer's Phone	Text
TO_BPOSTAL	Bill Cust Zip	15x	Billing Customer's Zip Code	Text
TO_BSTATE	Bill Cust State	25x	Billing Customer's State	Text
TO_CAT_CD	Category	10x	Category	Text
TO_CAT_TY	Category Text	60x	Category Text	Text
TO_CAUS_CD	Cause	10x	Cause	Text
TO_CAUS_TY	Cause Text	40x	Cause Text	Text
TO_CITY		25x	City	Text
TO_CITY_CD			Facility	Integer
TO_CITY_TY		50x	Facility Text	Text
TO_CLASSCD	Class	20x	Class	Text
TO_CLASSTY	Class Type	50x	Class Type	Text
TO_CONEST	Est. Contractor Cost	nnnnnn.nn	Estimated Contractor Cost	Double
TO_CREW_CD	Assigned Crew	10x	Crew	Text
TO_CREW_TY	Assigned Crew Text	25x	Crew Text	Text
TO_CRT_BY	Created By	25x	Created By	Text
TO_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
TO_CT_ID	Category Rec #	nnnnnnnn	Link to WKCAT.CT_ID	Long Integer
TO_DAYSAHD	Days Ahead	nnn	Days Ahead	Integer
TO_DEPT_CD	Department	10x	Department	Text
TO_DEPT_TY	Department Text	50x	Department Text	Text
TO_DIV_CD	Division	10x	Division Code	Text
TO_DIV_TY	Division Text	40x	Division Description	Text
TO_DNUN		10x	Duration Units - populated from the WKFREQ table	Text
TO_DOC_FLG	Document Available		Doc Available: Doc Flag	Boolean
TO_DT_INNO	End Date Interval	nnn	Date Interval Number	Integer
TO_DTINT_CD	End Interval Code	nnn	Date Interval Code	7
TO_DTINT_TY	End Interval Text	25x	Date Interval Text	Text
TO_DURATION	Estimated Duration to complete the Work order (in Days)	nnnnnnnn.nn	Estimated Duration to complete the Work order (in Days)	Double
TO_DURN			Duration	Long Integer
TO_EA_ID	Eden Acct Rec #	nnnnnnnnn	Link to WKEACCTNO.EA_ID	Long Integer
TO_EMP_CD	Lead Worker	20x	Assigned To	Text
TO_EMP_TY	Lead Worker Text	40x	Assigned To Text	Text
TO_END_DT			End Date	Date/Time
TO_END_TM			End Time	Date/Time
TO_EP_ID	Eden Proj Rec #	nnnnnnnnn	Link to WKEPROJNO.EP_ID	Long Integer
TO_EQ_EST	Est Equipment Cost	nnnnn.nn	Est Equipment Cost	Double
TO_FILTER	Filter Name	50x	Filter Name	Text
TO_FLUDEST	Est. Fluid Cost	nnnnnn.nn	Estimated Fluid Cost	Double
TO_FREQ			Frequency	Long Integer
TO_FRUN		10x	Frequency Text	Text
TO_GRASSET	Grouped Assets		Grouped Asset	Boolean
TO_GROUPPM	Grouped PM		Grouped PM	Boolean
TO_HR_AHD	Hourmeter Ahead	nnnnnn.nn	Hourmeter Ahead	Double
TO_HR_AMT	Hourmeter Interval	nnnnnn.nn	Hourmeter Interval	Double
TO_HR_NXT	Next Hourmeter	nnnnnn.nn	Next Hourmeter	Double
TO_HR_PRV	Previous Hourmeter	nnnnnn.nn	Previous Hourmeter	Double
TO_ID	Routine Rec #	nnnnnnnn	Unique ID	Long Integer
TO_IMG_FLG			Image Available	Boolean
TO_INIT_DT	Initiated Date	mm/dd/yyyy	Initiated Date	Date/Time
TO_INV_ID	Inventory Type ID	nnnnnnnn	Link to WKCATINV.CI_ID - Lucity System Category	Long Integer
TO_LC_EST	Est Labor Cost	nnnnn.nn	Est Labor Cost	Double
TO_LCHKLST	Lock Checklist		Lock Checklist	Boolean
TO_LH_EST	Est Labor Hours	nnnn.nn	Est Labor Hours	Double
TO_LOC_CD	Location	nnn	Location	Integer
TO_LOC_TY	Location Text	25x	Location Text	Text
TO_LSTRTDT	Last Start Date	mm/dd/yyyy	Last Start Date	Date/Time
TO_MAT_EST	Est Material Cost	nnnnn.nn	Est Material Cost	Double
TO_MISCEST	Est. Misc Cost	nnnnnn.nn	Estimated Misc. Cost	Double
TO_MOD_BY	Last Modified By	25x	Modified By	Text
TO_MOD_DT	Last Modified Date	mm/dd/yyyy	Modified Date	Date/Time
TO_MOD_TM	Last Modified Time	hh:mm am	Modified Time	Date/Time
TO_MOV_FLG			Movie Available	Boolean
TO_NXT_DT	End Next Date	mm/dd/yyyy	Next Date	Date/Time
TO_ODM_AHD	Odometer Ahead	nnnnnnn.n	Odometer Ahead	Double
TO_ODM_AMT	Odometer Interval	nnnnnnn.n	Odometer Interval	Double
TO_ODM_NXT	Next Odometer	nnnnnnn.n	Next Odometer	Double
TO_ODM_PRV	Previous Odometer	nnnnnnn.n	Previous Odometer	Double
TO_OLD_FLG	Override Leadworker		Override Leadworker Notif	Boolean
TO_OOD_FLG	Override Overdue		Override Overdue Notif	Boolean
TO_OOS	Out-of_Service		Out-of_Service	Boolean
TO_OPN_FLG	Override Problem		Override Problem Notif	Boolean
TO_OSU_FLG	Override Supervisor		Override Supervisor Notif	Boolean
TO_OTH_AHD	Interval Ahead	nnnnnnn.nn	Other Meter Ahead	Double
TO_OTH_AMT	Other Interval	nnnnnnn.nn	Other Interval	Double
TO_OTH_NXT	Next Other	nnnnnnn.nn	Next Other	Double
TO_OTH_PRV	Previous Other	nnnnnnn.nn	Previous Other	Double
TO_OTK_FLG	Override Task		Override Task Notif	Boolean
TO_OWN_CD	Owner	nnn	Owner	Integer
TO_OWN_TY	Owner Text	25x	Owner Text	Text
TO_PM	Scheduled PM		Scheduled PM	Boolean
TO_PMTEMPLATE	PM Template		PM Template	Boolean
TO_PNUMACT	Proj No - Acct	40x	Proj No - Acct	Text
TO_PRIORCD	Priority	nnn	Priority	Integer
TO_PRIORTY	Priority Text	25x	Priority Text	Text
TO_PRO_CD	Profit Center	nnn	Profit Center	Integer
TO_PRO_TY	Profit Center Text	25x	Profit Center Text	Text
TO_PROB_CD	Problem	10x	Problem	Text
TO_PROB_TY	Problem Text	40x	Problem Text	Text
TO_PROJ_NO	Project Text	30x	Project #	Text
TO_PRV_DT	Last End Date	mm/dd/yyyy	Previous End Date	Date/Time
TO_REAS_CD	Reason	nnn	Reason	Integer
TO_REAS_TY	Reason Text	25x	Reason Text	Text
TO_REP_CD	Repair Type	nnn	Repair Type	Integer
TO_REP_TY	Repair Type Text	25x	Repair Type Text	Text
TO_ROWVER			Rowversion for optimistic locking	Date/Time
TO_RUTN_CD	PM/Template	20x	Routine Number	Text
TO_RUTN_TY	PM/Template Text	80x	Routine Name	Text
TO_SAREACD	Sub-Area	10x	Sub-Area Code	Text
TO_SAREATY	Sub-Area Text	40x	Sub-Area Description	Text
TO_SDIV_CD	Sub-Division	10x	SubDivision Code	Text
TO_SDIV_TY	Sub-Division Text	40x	SubDivision Description	Text
TO_ST_INV	Start Date Interval	nnn	Start Date Interval	Integer
TO_STAT_CD	Status	nnn	Status	Integer
TO_STAT_TY	Status Text	25x	Status Text	Text
TO_STATE		25x	State	Text
TO_STINT_CD	Start Interval Code	nnn	Start Interval Code	7
TO_STINT_TY	Start Interval Text	25x	Start Interval Text	Text
TO_STNXTDT	Start Next Date	mm/dd/yyyy	Next Date by Start	Date/Time
TO_STRT_DT			Start Date	Date/Time
TO_STRT_TM			Start Time	Date/Time
TO_SUBCON	Subcontractor	30x	Subcontractor	Text
TO_SUPR_CD	Supervisor	20x	Supervisor	Text
TO_SUPR_TY	Supervisor Text	40x	Supervisor Text	Text
TO_TC_EST	Est. Total Cost	nnnnnn.nn	Estimated Total Cost	Double
TO_TLINKPM	Tightly Linked PM		Tightly Linked PM	Boolean
TO_TOTCOST			Total Cost	Double
TO_UOM_CD	Unit of Measure	5x	Unit of Measure	Text
TO_UOM_TY	Unit of Measure Text	25x	Unit of Measure Text	Text
TO_USER10	User 10	mm/dd/yyyy	User 10	Date/Time
TO_USER11	User 11	mm/dd/yyyy	User 11	Date/Time
TO_USER12	User 12	-nnnnnnnnn.nn	User 12	Double
TO_USER13	User 13	-nnnnnnnnn.nn	User 13	Double
TO_USER14	User 14	30x	User 14	Text
TO_USER15	User 15	30x	User 15	Text
TO_USER1CD	User 1	nnn	User 1	Integer
TO_USER1TY	User 1 Text	25x	User 1 Text	Text
TO_USER2CD	User 2	nnn	User 2	Integer
TO_USER2TY	User 2 Text	25x	User 2 Text	Text
TO_USER3CD	User 3	nnn	User 3	Integer
TO_USER3TY	User 3 Text	25x	User 3 Text	Text
TO_USER4	User 4	-nnnnnnnnn.nn	User 4	Double
TO_USER5	User 5	30x	User 5	Text
TO_USER6	User 6		User 6	Boolean
TO_USER7	User 7		User 7	Boolean
TO_USER8	User 8		User 8	Boolean
TO_USER9	User 9	mm/dd/yyyy	User 9	Date/Time
TO_WO_NUM	WO Number	18x	WO Number	Text
TO_WOAUTO			Auto Work Order Generation	Boolean
TO_WOTEMPLATE	WO Template		WO Template	Boolean
TO_WU25DT	WO User 25 Date	mm/dd/yyyy	User 25 Date	Date/Time
TO_WU25TM	WO User 25 Time	hh:mm am	User 25 Time	Date/Time
TO_WUSR10	WO User 10	mm/dd/yyyy	WO User 10	Date/Time
TO_WUSR11	WO User 11	mm/dd/yyyy	WO User 11	Date/Time
TO_WUSR12	WO User 12	-nnnnnnnn.nn	WO User 12	Double
TO_WUSR13	WO User 13	-nnnnnnnn.nn	WO User 13	Double
TO_WUSR14	WO User 14	30x	WO User 14	Text
TO_WUSR15	WO User 15	30x	WO User 15	Text
TO_WUSR16C	WO User 16	nnn	User 16	Integer
TO_WUSR16T	WO User 16 Text	25x	User 16 Text	Text
TO_WUSR17C	WO User 17	nnn	User 17	Integer
TO_WUSR17T	WO User 17 Text	25x	User 17 Text	Text
TO_WUSR18C	WO User 18	nnn	User 18	Integer
TO_WUSR18T	WO User 18 Text	25x	User 18 Text	Text
TO_WUSR19C	WO User 19	nnn	User 19	Integer
TO_WUSR19T	WO User 19 Text	25x	User 19 Text	Text
TO_WUSR1CD	WO User 1	nnn	Work Order Tab - User 1	Integer
TO_WUSR1TY	WO User 1 Text	25x	Work Order Tab - User 1 Text	Text
TO_WUSR20C	WO User 20	12x	User 20	Text
TO_WUSR20T	WO User 20 Text	50x	User 20 Text	Text
TO_WUSR21C	WO User 21	12x	User 21	Text
TO_WUSR21T	WO User 21 Text	50x	User 21 Text	Text
TO_WUSR22	WO User 22	30x	User 22	Text
TO_WUSR23	WO User 23	-nnnnnnnn.nn	User 23	Double
TO_WUSR24	WO User 24	-nnnnnnnn.nn	User 24	Double
TO_WUSR26	WO User 26		User 26	Boolean
TO_WUSR27	WO User 27		User 27	Boolean
TO_WUSR28	WO User 28		User 28	Boolean
TO_WUSR29	WO User 29		User 29	Boolean
TO_WUSR2CD	WO User 2	nnn	Work Order Tab - User 2	Integer
TO_WUSR2TY	WO User 2 Text	25x	Work Order Tab - User 2 Text	Text
TO_WUSR30	WO User 30		User 30	Boolean
TO_WUSR3CD	WO User 3	nnn	Work Order Tab - User 3	Integer
TO_WUSR3TY	WO User 3 Text	25x	Work Order Tab - User 3 Text	Text
TO_WUSR4	WO User 4	nnnnnnnnn.	Work Order Tab - User 4	Double
TO_WUSR5	WO User 5	30x	Work Order Tab - User 5	Text
TO_WUSR6	WO User 6		Work Order Tab - User 6	Boolean
TO_WUSR7	WO User 7		Work Order Tab - User 7	Boolean
TO_WUSR8	WO User 8		Work Order Tab - User 8	Boolean
TO_WUSR9	WO User 9	mm/dd/yyyy	WO User 9	Date/Time
TO_X_COORD			X Coordinate	Double
TO_Y_COORD			Y Coordinate	Double