WKORDER

Work Orders

Field Name	Caption	Mask	Description	Field Type
WO_AC_ID	Account Rec #	-nnnnnnnn	Link To WKACCTNO	Long Integer
WO_ACCOUNT	Account #	45x	Account #	Text
WO_ACTN_CD	Main Task	20x	Action	Text
WO_ACTN_TY	Main Task Text	75x	Action Text	Text
WO_ADESC1	Desc 1	255x	Asset Description 1	Text
WO_ADESC2	Desc 2	255x	Asset Description 2	Text
WO_ADR_APT		25x	Apartment/Suite	Text
WO_ADR_B2	Street Post Bldg No	8x	Street Post Building No	Text
WO_ADR_BDG	Address	nnnnnn	Address - Building Number	Long Integer
WO_ADR_DIR	Street Direction	2x	Address - Direction	Text
WO_ADR_PT	Street Prefix Type	5x	Street Prefix Type	Text
WO_ADR_SFX	Street Suffix	5x	Address - Suffix	Text
WO_ADR_STR	Street Name	50x	Address - Street Name	Text
WO_ADR_TY	Street Type	5x	Address - Street Type	Text
WO_ADRDIR2	Street 2	2x	Street Direction 2 :	Text
WO_ADRSFX2	Street Suffix 2	5x	Street Suffix 2 :	Text
WO_ADRSTR2	Street Name 2	50x	Street Name 2 :	Text
WO_ADRTY2	Street Type 2	5x	Street Type 2 :	Text
WO_ADR2_PT	Street 2 Prefix Type	5x	Street 2 Prefix Type	String
WO_AREA_CD	Area	10x	Area Code	Text
WO_AREA_TY	Area Text	40x	Area Description	Text
WO_ASGN_CD	Assigned By	20x	Assigned By	Text
WO_ASGN_TY	Assigned By Text	40x	Assigned By Text	Text
WO_ASN_DT	Assigned Date	mm/dd/yyyy	Assigned Date	Date/Time
WO_ASN_TM	Assigned Time	hh:mm am	Assigned Time	Date/Time
WO_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
WO_AZONE_TY	Alternate Zone Desc	60x	Alternate Zone Desc	String
WO_BADDR1	Bill Cust Address	50x	Billing Customer's Address 1	Text
WO_BCELL	Bill Cell #	20x	Bill Phone 2	Text
WO_BCITY	Bill Cust City	25x	Billing Customer's City	Text
WO_BCNAME	Contact Name	30x	Bill Contact Name	Text
WO_BCUSTID	Bill Cust ID	20x	Billing Customer's ID	Text
WO_BCUSTNO	Bill Cust No	20x	Billing Customer's No	Text
WO_BEMAIL	Bill E-mail	150x	Bill Email	Text
WO_BFAX	Bill Fax #	20x	Bill Fax	Text
WO_BFIRST	Bill Cust Name	30x	Billing Customer's First Name	Text
WO_BILLAMT	Billing Amount	nnnnnn.nn	Billing Amount	Double
WO_BILLFLAG	Billing Required		Billing Flag	Boolean
WO_BINACCT	Incoming Acct No	45x	Billing Incoming Account No	Text
WO_BINVNO	Invoice Number	20x	Billing Invoice Number	Text
WO_BLAST	Bill Cust Last Name	30x	Billing Customer's Last Name	Text
WO_BPHONE	Bill Cust Phone	20x	Billing Customer's Phone	Text
WO_BPMT_CD	Payment Method	nnn	Payment Method	Integer
WO_BPMT_TY	Payment Method Text	25x	Payment Method Text	Text
WO_BPOSTAL	Bill Cust Zip	15x	Billing Customer's Zip Code	Text
WO_BPROCCES	Billing Processed		Billing Processed	Boolean
WO_BRCV_DT	Payment Recvd	mm/dd/yyyy	Date Payment Received	Date/Time
WO_BSNT_DT	Date Bill Sent	mm/dd/yyyy	Date Bill Sent	Date/Time
WO_BSTATE	Bill Cust State	25x	Billing Customer's State	Text
WO_CAT_CD	Category	10x	Category	Text
WO_CAT_TY	Category Text	60x	Category Text	Text
WO_CAUS_CD	Cause	10x	Cause	Text
WO_CAUS_TY	Cause Text	40x	Cause Text	Text
WO_CITY		25x	Obsolete but referenced in desktop code	Text
WO_CLASSCD	Classification	20x	Classification Code	Text
WO_CLASSTY	Classification Text	50x	Classification Type	Text
WO_CONCST	Contractor Cost	nnnnnnnn.nn	Total Contractor Cost:	Double
WO_CONDIF	Contractor Cost Diff	-nnnnnn.nn	Contractor Cost Difference	Double
WO_CONEST	Est. Contractor Cost	nnnnnnnn.nn	Estimated Contractor Cost	Double
WO_CONT_CD	Contractor	20x	Contractor	String
WO_CONT_TY	Contractor Name	40x	Contractor Name	String
WO_CREW_CD	Assigned Crew	10x	Crew	Text
WO_CREW_TY	Assigned Crew Text	25x	Crew Text	Text
WO_CRT_BY	Created By	25x	Created By	Text
WO_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
WO_CT_ID	Category Rec #	-nnnnnnnn	Link to WKCAT.CT_ID	Long Integer
WO_DEPT_CD	Department	10x	Department	Text
WO_DEPT_TY	Department Text	50x	Department Text	Text
WO_DIV_CD	Division	10x	Division Code	Text
WO_DIV_TY	Division Text	40x	Division Description	Text
WO_DOC_FLG	Document Available		Doc Available: Doc Flag	Boolean
WO_DUR_ACT	WO Duration Actual	nnn.nn	WO Duration Actual	Double
WO_DUR_DIF	WO Duration Difference	-nnn.nn	WO Duration Difference	Double
WO_DUR_EST	WO Duration Estimate	nnn.nn	WO Duration Estimate	Double
WO_EA_ID	Eden Acct Rec #	nnnnnnnnn	Link to WKEACCTNO.EA_ID	Long Integer
WO_EM_ID	LW Emp Rec #	-nnnnnnnn	Link to WKUEMP.EM_ID	Long Integer
WO_EMP_CD	Lead Worker	20x	Assigned To	Text
WO_EMP_TY	Lead Worker Text	40x	Assigned To Text	Text
WO_END_DT	End Date	mm/dd/yyyy	End Date	Date/Time
WO_END_TM	End Time	hh:mm am	End Time	Date/Time
WO_EP_ID	Eden Proj Rec #	nnnnnnnnn	Link to WKEPROJNO.EP_ID	Long Integer
WO_EQ_ACT	Actual Equip Cost	nnnnn.nn	Actual Equipment Cost	Double
WO_EQ_DIF	Equipment Cost Diff	-nnnnn.nn	Equipment Cost Difference	Double
WO_EQ_EST	Est Equipment Cost	nnnnn.nn	Est Equipment Cost	Double
WO_FIMPORT	Imported to Finance		Financial Import Flag	Boolean
WO_FLUDCST	Total Fluid Cost	nnnnnnnn.nn	Total Fluid Cost:	Double
WO_FLUDDIF	Fluid Cost Diff	-nnnnnn.nn	Fluid Cost Difference	Double
WO_FLUDEST	Est. Fluid Cost	nnnnnnnn.nn	Estimated Fluid Cost	Double
WO_HANDHELD		50x	Handheld Name	Text
WO_HLWO_FLG	Hard Lock WO		Hard Lock WO	Boolean
WO_HR_MTR	Hourmeter #	nnnnnn.nn	Hour Meter Reading	Double
WO_IBY_CD	Inspected By	20x	Inspected By	String
WO_IBY_TY	Inspected By Text	40x	Inspected By Text	String
WO_ID	Work Order Rec #	nnnnnnnn	Unique ID	Long Integer
WO_INIDATE	WO Creation Date	mm/dd/yyyy	Date of Initial Work Order Creation	Date/Time
WO_INISTAF	WO Creator	25x	Initials of initial work order creator	Text
WO_INITIME	WO Creation Time	hh:mm am	Time of initial work order creation	Date/Time
WO_INV_ID	Inventory Type ID	-nnnnnnnn	Inventory Type ID	Long Integer
WO_JT_ID	Proj Task Rec #	-nnnnnnnn	Link to WKPROJT.JT_ID	Long Integer
WO_LC_ACT	Actual Labor Cost	nnnnn.nn	Actual Labor Cost	Double
WO_LC_DIF	Labor Cost Diff	-nnnnn.nn	Labor Cost Difference	Double
WO_LC_EST	Est Labor Cost	nnnnn.nn	Est Labor Cost	Double
WO_LH_ACT	Actual Labor Hours	nnnn.nn	Actual Labor Hours	Double
WO_LH_DIF	Labor Hour Diff	-nnnnn.nn	Labor Hour Difference	Double
WO_LH_EST	Est Labor Hours	nnnn.nn	Est Labor Hours	Double
WO_LINK1	System ID 1	150x	Link 1	Text
WO_LOC_CD	Location	nnn	Location	Integer
WO_LOC_TY	Location Text	25x	Location Text	Text
WO_MAT_ACT	Actual Material Cost	nnnnn.nn	Actual Material Cost	Double
WO_MAT_DIF	Material Cost Diff	-nnnnn.nn	Material Cost Difference	Double
WO_MAT_EST	Est Material Cost	nnnnn.nn	Est Material Cost	Double
WO_MBL_ID			Copy of WO_ID for mobile device	Long Integer
WO_MISCCST	Misc. Cost	nnnnnnnn.nn	Misc. Cost:	Double
WO_MISCDIF	Misc. Cost Diff	-nnnnnnn.nn	Misc. Cost Difference	Double
WO_MISCEST	Est. Misc. Cost	nnnnnnnn.nn	Estimated Misc. Cost	Double
WO_MOD_BY	Last Modified By	25x	Modified By	Text
WO_MOD_DT	Last Modified Date	mm/dd/yyyy	Modified Date	Date/Time
WO_MOD_TM	Last Modified Time	hh:mm am	Modified Time	Date/Time
WO_MW_ID	Master Work Link	-nnnnnnnn	Link to WKWOMWO.MW_ID	Long Integer
WO_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
WO_MZONE_TY	Maintenance Zone Desc	60x	Maintenance Zone Desc	String
WO_NUMBER	Work Order #	25x	Work Order #	Text
WO_ODO_MTR	Odometer #	nnnnnnn.n	Odometer Reading	Double
WO_OID			Visual CE Linking Field	Long Integer
WO_OLD_FLG	Override Leadworker		Override Leadworker Notif	Boolean
WO_OOD_FLG	Override Overdue		Override Overdue Notif	Boolean
WO_OPN_FLG	Override Problem		Override Problem Notif	Boolean
WO_OSU_FLG	Override Supervisor		Override Supervisor Notif	Boolean
WO_OTH_MTR	Other Meter #	nnnnnnn.nn	Other Meter Reading	Double
WO_OTK_FLG	Override Task		Override Task Notif	Boolean
WO_OWN_CD	Owner	nnn	Owner	Integer
WO_OWN_TY	Owner Text	25x	Owner Text	Text
WO_PCLOCK	Projected Compl Lock		Projected Completion Lock	Boolean
WO_PMTRG_CD	PM Trigger	nnn	PM Trigger	Integer
WO_PMTRG_TY	PM Trigger Text	25x	PM Trigger Text	Text
WO_PNUMACT	Proj No - Acct	40x	Proj No - Acct	Text
WO_POSTAL		15x	Zip Code	Text
WO_PRIORCD	Priority	nnn	Priority	Integer
WO_PRIORTY	Priority Text	25x	Priority Text	Text
WO_PRJ_DT	Projected Compl	mm/dd/yyyy	Projected End Date	Date/Time
WO_PRJ_TM	Projected Compl Time	hh:mm am	Projected End Time	Date/Time
WO_PRO_CD	Profit Center	nnn	Profit Center	Integer
WO_PRO_TY	Profit Center Text	25x	Profit Center Text	Text
WO_PROB_CD	Problem	10x	Problem	Text
WO_PROB_TY	Problem Text	40x	Problem Text	Text
WO_PROJ_NO	Project	30x	Project #	Text
WO_PT_ID	Plan Task Rec #	-nnnnnnnn	Link to WKPTASK.PT_ID	Long Integer
WO_QLOCK	Quantity Lock		Quantity Lock	Boolean
WO_QUANT	Quantity	nnnnnnnnn.nn	Quantity	Double
WO_RBY_CD	Received By	20x	Received By	String
WO_RBY_TY	Received By Text	40x	Received By Text	String
WO_REAS_CD	Reason	nnn	Reason	Integer
WO_REAS_TY	Reason Text	25x	Reason Text	Text
WO_REP_CD	Repair Type	nnn	Repair Type	Integer
WO_REP_TY	Repair Type Text	25x	Repair Type Text	Text
WO_ROWVER			Rowversion for optimistic locking	Date/Time
WO_SAREACD	Sub-Area	10x	Sub-Area Code	Text
WO_SAREATY	Sub-Area Text	40x	Sub-Area Description	Text
WO_SDIV_CD	Sub-Division	10x	SubDivision Code	Text
WO_SDIV_TY	Sub-Division Text	40x	SubDivision Description	Text
WO_STAT_CD	Status	nnn	Status	Integer
WO_STAT_DT	Status Date	mm/dd/yyyy	Status Date:	Date/Time
WO_STAT_TM	Status Time	hh:mm am	Status Time:	Date/Time
WO_STAT_TY	Status Text	25x	Status Text	Text
WO_STATE		25x	Obsolete but referenced in desktop code	Text
WO_STRT_DT	Start Date	mm/dd/yyyy	Start Date	Date/Time
WO_STRT_TM	Start Time	hh:mm am	Start Time	Date/Time
WO_SUBCON	Subcontractor	30x	Subcontractor	Text
WO_SUPR_CD	Supervisor	20x	Supervisor	Text
WO_SUPR_TY	Supervisor Text	40x	Supervisor Text	Text
WO_TC_DIF	Total Cost Diff	-nnnnnn.nn	Total Cost Difference	Double
WO_TC_EST	Est Total Cost	nnnnnn.nn	Est Total Cost	Double
WO_TIMESTAMP	Timestamp for Mobile	mm/dd/yyyy	Timestamp for Visual CE	Date/Time
WO_TOTCOST	Total Cost	nnnnnnnn.nn	Total Cost	Double
WO_TSK_ACT	Use Task Actual Costs		Use Task Actual Costs	Boolean
WO_TSK_EST	Use Task Est.		Use Task Estimates?	Boolean
WO_U25_DT	WO User 25 Date	mm/dd/yyyy	User 25 Date	Date/Time
WO_U25_TM	WO User 25 Time	hh:mm am	User 25 Time	Date/Time
WO_UCOST	Unit Cost	nnnnnn.nn	Summary Unit Cost	Double
WO_UOM_CD	Unit of Measure	5x	Unit of Measure	Text
WO_UOM_TY	Unit of Measure Text	25x	Unit of Measure Text	Text
WO_USER1CD	WO User 1	nnn	User 1	Integer
WO_USER1TY	WO User 1 Text	25x	User 1 Text	Text
WO_USER2CD	WO User 2	nnn	User 2	Integer
WO_USER2TY	WO User 2 Text	25x	User 2 Text	Text
WO_USER3CD	WO User 3	nnn	User 3	Integer
WO_USER3TY	WO User 3 Text	25x	User 3 Text	Text
WO_USER4	WO User 4	nnnnnnnnn.	User 4	Double
WO_USER5	WO User 5	30x	User 5	Text
WO_USER6	WO User 6		User 6	Boolean
WO_USER7	WO User 7		User 7	Boolean
WO_USER8	WO User 8		User 8	Boolean
WO_USER9	User 9	mm/dd/yyyy	User 9	Date/Time
WO_USER10	User 10	mm/dd/yyyy	User 10	Date/Time
WO_USER11	User 11	mm/dd/yyyy	User 11	Date/Time
WO_USER12	User 12	-nnnnnnnnn.nn	User 12	Double
WO_USER13	User 13	-nnnnnnnnn.nn	User 13	Double
WO_USER14	User 14	30x	User 14	Text
WO_USER15	User 15	30x	User 15	Text
WO_USER16C	WO User 16	nnn	User 16	Integer
WO_USER16T	WO User 16 Text	25x	User 16 Text	Text
WO_USER17C	WO User 17	nnn	User 17	Integer
WO_USER17T	WO User 17 Text	25x	User 17 Text	Text
WO_USER18C	WO User 18	nnn	User 18	Integer
WO_USER18T	WO User 18 Text	25x	User 18 Text	Text
WO_USER19C	WO User 19	nnn	User 19	Integer
WO_USER19T	WO User 19 Text	25x	User 19 Text	Text
WO_USER20C	WO User 20	12x	User 20	Text
WO_USER20T	WO User 20 Text	50x	User 20 Text	Text
WO_USER21C	WO User 21	12x	User 21	Text
WO_USER21T	WO User 21 Text	50x	User 21 Text	Text
WO_USER22	WO User 22	30x	User 22	Text
WO_USER23	WO User 23	-nnnnnnnn.nn	User 23	Double
WO_USER24	WO User 24	-nnnnnnnn.nn	User 24	Double
WO_USER26	WO User 26		User 26	Boolean
WO_USER27	WO User 27		User 27	Boolean
WO_USER28	WO User 28		User 28	Boolean
WO_USER29	WO User 29		User 29	Boolean
WO_USER30	WO User 30		User 30	Boolean
WO_USER31CD	WO User 31	nnn	User 31	Integer
WO_USER31TY	WO User 31 Text	30x	User 31 Text	Text
WO_USER32CD	WO User 32	nnn	User 32	Integer
WO_USER32TY	WO User 32 Text	30x	User 32 Text	Text
WO_USER33CD	WO User 33	nnn	User 33	Integer
WO_USER33TY	WO User 33 Text	30x	User 33 Text	Text
WO_USER34C	WO User 34	12x	User 34	Text
WO_USER34T	WO User 34 Text	50x	User 34 Text	Text
WO_USER35C	WO User 35	12x	User 35	Text
WO_USER35T	WO User 35 Text	50x	User 35 Text	Text
WO_USER36C	WO User 36	12x	User 36	Text
WO_USER36T	WO User 36 Text	50x	User 36 Text	Text
WO_USER37C	WO User 37	12x	User 37	Text
WO_USER37T	WO User 37 Text	50x	User 37 Text	Text
WO_USER38C	WO User 38	12x	User 38	Text
WO_USER38T	WO User 38 Text	50x	User 38 Text	Text
WO_USER39C	WO User 39	12x	User 39	Text
WO_USER39T	WO User 39 Text	50x	User 39 Text	Text
WO_USER40	WO User 40	30x	User 40	Text
WO_USER41	WO User 41	30x	User 41	Text
WO_USER42	WO User 42	-nnnnnnnnn.nn	User 42	Double
WO_USER43	WO User 43	-nnnnnnnnn.nn	User 43	Double
WO_USER44	WO User 44	-nnnnnnnnn.nn	User 44	Double
WO_USER45	WO User 45	-nnnnnnnnn.nn	User 45	Double
WO_USER46	WO User 46	-nnnnnnnnn.nn	User 46	Double
WO_USER47	WO User 47	30x	User 51	Text
WO_USER48	WO User 48	30x	User 52	Text
WO_USER50C	WO User 50	12x	User 50	Text
WO_USER50T	WO User 50 Text	50x	User 50 Text	Text
WO_USER51C	WO User 51	12x	User 51	Text
WO_USER51T	WO User 51 Text	50x	User 51 Text	Text
WO_WOHRS	WO Hours	nnnn.nn	Work Order Summary Hours	Double