Field Search

Tables in All Products where the Field Physical Name Is WS_JOB_NUMBER

Seq No	Product Name	Series Name	Table Physical Name	Table Display Name	Field Physical Name	Field Display Name
1	WennSoft Products (131)	Purchasing	PO10202	PO_WORK_LINE_File	WS_Job_Number	WS Job Number
2	WennSoft Products (131)	Purchasing	PO10302	Receivings_WORK_LINE_File	WS_Job_Number	WS Job Number
3	WennSoft Products (131)	Purchasing	PO20202	PO_OPEN_LINE_File	WS_Job_Number	WS Job Number
4	WennSoft Products (131)	Purchasing	PO20302	Receivings_OPEN_LINE_File	WS_Job_Number	WS Job Number
5	WennSoft Products (131)	Purchasing	PO30202	PO_HIST_LINE_File	WS_Job_Number	WS Job Number
6	WennSoft Products (131)	Purchasing	PO30302	Receivings_HIST_LINE_File	WS_Job_Number	WS Job Number
7	WennSoft Products (131)	3rd Party	JC00102	JC_Job_MSTR	WS_Job_Number	WS Job Number
8	WennSoft Products (131)	3rd Party	JC00103	temp_JC_Prior_Year_MSTR	WS_Job_Number	WS Job Number
9	WennSoft Products (131)	3rd Party	JC00103	temp_JC_Prior_Year_MSTR	WS_Job_Number	WS Job Number
10	WennSoft Products (131)	3rd Party	JC00103	JC_Prior_Year_MSTR	WS_Job_Number	WS Job Number
11	WennSoft Products (131)	3rd Party	JC00103	JC_Prior_Year_MSTR	WS_Job_Number	WS Job Number
12	WennSoft Products (131)	3rd Party	JC00104	JC_Job_Contract_Max_MSTR	WS_Job_Number	WS Job Number
13	WennSoft Products (131)	3rd Party	JC00105	JC_Job_Architect_MSTR	WS_Job_Number	WS Job Number
14	WennSoft Products (131)	3rd Party	JC00106	JC_Job_Address_MSTR	WS_Job_Number	WS Job Number
15	WennSoft Products (131)	3rd Party	JC00107	Job User Defined Master	WS_Job_Number	WS Job Number
16	WennSoft Products (131)	3rd Party	JC00114	JC_Job_Contract_Amount_Audit	WS_Job_Number	WS Job Number
17	WennSoft Products (131)	3rd Party	JC00115	JC_Job_Change_Order_Amount_Audit	WS_Job_Number	WS Job Number
18	WennSoft Products (131)	3rd Party	JC00201	JC_Forecast_Cost_Revision_MSTR	WS_Job_Number	WS Job Number
19	WennSoft Products (131)	3rd Party	JC00203	JC_Forecast_Total_MSTR	WS_Job_Number	WS Job Number
20	WennSoft Products (131)	3rd Party	JC00301	JC_Keys_MSTR	WS_Job_Number	WS Job Number
21	WennSoft Products (131)	3rd Party	JC00401	JC_Estimate_Cost_Revision_MSTR	WS_Job_Number	WS Job Number
22	WennSoft Products (131)	3rd Party	JC00501	JC_Notes_MSTR	WS_Job_Number	WS Job Number
23	WennSoft Products (131)	3rd Party	JC00601	JC_Billing_Codes_MSTR	WS_Job_Number	WS Job Number
24	WennSoft Products (131)	3rd Party	JC00701	JC_Job_Detail_MSTR	WS_Job_Number	WS Job Number
25	WennSoft Products (131)	3rd Party	JC00702	JC_Estimate_Detail_TEMP	WS_Job_Number	WS Job Number
26	WennSoft Products (131)	3rd Party	JC00901	JC_Job_Index_MSTR	WS_Job_Number	WS Job Number
27	WennSoft Products (131)	3rd Party	JC01001	JC_Change_Orders_MSTR	WS_Job_Number	WS Job Number
28	WennSoft Products (131)	3rd Party	JC01002	JC_Chg_Ord_Detail_MSTR	WS_Job_Number	WS Job Number
29	WennSoft Products (131)	3rd Party	JC01003	JC_Chg_Ord_Est_Revision_MSTR	WS_Job_Number	WS Job Number
30	WennSoft Products (131)	3rd Party	JC01201	JC_Cost_Code_Description_MSTR	WS_Job_Number	WS Job Number
31	WennSoft Products (131)	3rd Party	JC01501	JC_Vendor_MSTR	WS_Job_Number	WS Job Number
32	WennSoft Products (131)	3rd Party	JC01502	JC_Vendor_Contact_MSTR	WS_Job_Number	WS Job Number
33	WennSoft Products (131)	3rd Party	JC01503	JC_Vendor_Detail_MSTR	WS_Job_Number	WS Job Number
34	WennSoft Products (131)	3rd Party	JC01504	JC_Vendor_Dates_MSTR	WS_Job_Number	WS Job Number
35	WennSoft Products (131)	3rd Party	JC01511	JC_Master_Subcontractor_MSTR	WS_Job_Number	WS Job Number
36	WennSoft Products (131)	3rd Party	JC01521	JC_Contract_Cost_Code_DTL	WS_Job_Number	WS Job Number
37	WennSoft Products (131)	3rd Party	JC01531	JC_CO_Contract_Cost_Code_DTL	WS_Job_Number	WS Job Number
38	WennSoft Products (131)	3rd Party	JC10001L	JC_RFP_Transaction_WORK_LINES	WS_Job_Number	WS Job Number
39	WennSoft Products (131)	3rd Party	JC10201	JC_Inventory_Transaction_WORK	WS_Job_Number	WS Job Number
40	WennSoft Products (131)	3rd Party	JC10211	JC_SOP_LINE_WORK	WS_Job_Number	WS Job Number
41	WennSoft Products (131)	3rd Party	JC10302	JC_Job_TRX_LINE_WORK	WS_Job_Number	WS Job Number
42	WennSoft Products (131)	3rd Party	JC10400	JC_Job_Close_Audit	WS_Job_Number	WS Job Number
43	WennSoft Products (131)	3rd Party	JC10501	JC_Invoice_WORK	WS_Job_Number	WS Job Number
44	WennSoft Products (131)	3rd Party	JC10503	JC_Invoice_Schedule_WORK	WS_Job_Number	WS Job Number
45	WennSoft Products (131)	3rd Party	JC10504	JC_Invoice_TRX_WORK	WS_Job_Number	WS Job Number
46	WennSoft Products (131)	3rd Party	JC10506	JC_CO_Bill_Codes_WORK	WS_Job_Number	WS Job Number
47	WennSoft Products (131)	3rd Party	JC10512	JC_Project_TRX_Level_Bill_Code	WS_Job_Number	WS Job Number
48	WennSoft Products (131)	3rd Party	JC10513	JC_Project_TRX_Level_Move	WS_Job_Number	WS Job Number
49	WennSoft Products (131)	3rd Party	JC10514	JC_Project_TRX_Level_Transfer	WS_Job_Number	WS Job Number
50	WennSoft Products (131)	3rd Party	JC10523	JC_Invoice_Schedule_Bill_Codes_WORK	WS_Job_Number	WS Job Number
51	WennSoft Products (131)	3rd Party	JC10601	JC_Chg_Ord_Detail_WORK	WS_Job_Number	WS Job Number
52	WennSoft Products (131)	3rd Party	JC10701	JC_Payroll_Transaction_WORK	WS_Job_Number	WS Job Number
53	WennSoft Products (131)	3rd Party	JC10702	JC Time Sheet TRX WORK	WS_Job_Number	WS Job Number
54	WennSoft Products (131)	3rd Party	JC10704	JC_Payroll_Detail_For_Summary	WS_Job_Number	WS Job Number
55	WennSoft Products (131)	3rd Party	JC10802	JC_Unit_TRX_LINE_WORK	WS_Job_Number	WS Job Number
56	WennSoft Products (131)	3rd Party	JC10901	JC_Prod_Units_LINE_WORK	WS_Job_Number	WS Job Number
57	WennSoft Products (131)	3rd Party	JC10902	JC_Prod_Units_HDR_WORK	WS_Job_Number	WS Job Number
58	WennSoft Products (131)	3rd Party	JC11526	JC Contract Payment Distribution WORK OPEN	WS_Job_Number	WS Job Number
59	WennSoft Products (131)	3rd Party	JC20001	JC_Job_Transaction_OPEN	WS_Job_Number	WS Job Number
60	WennSoft Products (131)	3rd Party	JC20002	JC_Job_Detail_Summary	WS_Job_Number	WS Job Number
61	WennSoft Products (131)	3rd Party	JC20003	JC_Job_MSTR_Summary	WS_Job_Number	WS Job Number
62	WennSoft Products (131)	3rd Party	JC20004	JC Vendor TRX OPEN	WS_Job_Number	WS Job Number
63	WennSoft Products (131)	3rd Party	JC20005	JC_Estimate_Cost_Summary	WS_Job_Number	WS Job Number
64	WennSoft Products (131)	3rd Party	JC20020	JC_Transfered_Service_Calls	WS_Job_Number	WS Job Number
65	WennSoft Products (131)	3rd Party	JC20101	JC_POC_WORK_OPEN	WS_Job_Number	WS Job Number
66	WennSoft Products (131)	3rd Party	JC20401	JC_Job_Transaction_Entry_POST	WS_Job_Number	WS Job Number
67	WennSoft Products (131)	3rd Party	JC20501	JC_Invoice_OPEN	WS_Job_Number	WS Job Number
68	WennSoft Products (131)	3rd Party	JC20502	JC_Cash_Receipts_OPEN	WS_Job_Number	WS Job Number
69	WennSoft Products (131)	3rd Party	JC20503	JC_Invoice_Schedule_OPEN	WS_Job_Number	WS Job Number
70	WennSoft Products (131)	3rd Party	JC20504	JC_Invoice_TRX_OPEN	WS_Job_Number	WS Job Number
71	WennSoft Products (131)	3rd Party	JC20523	JC_Invoice_Schedule_Bill_Codes_OPEN	WS_Job_Number	WS Job Number
72	WennSoft Products (131)	3rd Party	JC20601	JC_Union_Transaction_OPEN	WS_Job_Number	WS Job Number
73	WennSoft Products (131)	3rd Party	JC20705	JC_Lien_Waivers_OPEN	WS_Job_Number	WS Job Number
74	WennSoft Products (131)	3rd Party	JC20902	JC_Prod_Units_HDR_OPEN	WS_Job_Number	WS Job Number
75	WennSoft Products (131)	3rd Party	JC30001	JC_Job_MSTR_HIST	WS_Job_Number	WS Job Number
76	WennSoft Products (131)	3rd Party	JC30001L	JC_RFP_Transaction_HIST_LINES	WS_Job_Number	WS Job Number
77	WennSoft Products (131)	3rd Party	JC30002	JC_Job_Index_MSTR_HIST	WS_Job_Number	WS Job Number
78	WennSoft Products (131)	3rd Party	JC30003	JC_Job_MSTR_Summary_HIST	WS_Job_Number	WS Job Number
79	WennSoft Products (131)	3rd Party	JC30004	JC_Job_Architect_HIST	WS_Job_Number	WS Job Number
80	WennSoft Products (131)	3rd Party	JC30006	JC_Job_Address_HIST	WS_Job_Number	WS Job Number
81	WennSoft Products (131)	3rd Party	JC30101	JC_Job_Detail_MSTR_HIST	WS_Job_Number	WS Job Number
82	WennSoft Products (131)	3rd Party	JC30102	JC_Job_Detail_Summary_HIST	WS_Job_Number	WS Job Number
83	WennSoft Products (131)	3rd Party	JC30107	Job User Defined Master History	WS_Job_Number	WS Job Number
84	WennSoft Products (131)	3rd Party	JC30201	JC_Job_Transaction_OPEN_HIST	WS_Job_Number	WS Job Number
85	WennSoft Products (131)	3rd Party	JC30210	JC_SOP_LINE_HIST	WS_Job_Number	WS Job Number
86	WennSoft Products (131)	3rd Party	JC30301	JC_Notes_HIST	WS_Job_Number	WS Job Number
87	WennSoft Products (131)	3rd Party	JC30401	JC_Est_Cost_Rev_MSTR_HIST	WS_Job_Number	WS Job Number
88	WennSoft Products (131)	3rd Party	JC30501	JC_Invoice_HIST	WS_Job_Number	WS Job Number
89	WennSoft Products (131)	3rd Party	JC30502	JC_Cash_Receipts_HIST	WS_Job_Number	WS Job Number
90	WennSoft Products (131)	3rd Party	JC30503	JC_Invoice_Schedule_HIST	WS_Job_Number	WS Job Number
91	WennSoft Products (131)	3rd Party	JC30504	JC_Invoice_TRX_HIST	WS_Job_Number	WS Job Number
92	WennSoft Products (131)	3rd Party	JC30523	JC_Invoice_Schedule_Bill_Codes_HIST	WS_Job_Number	WS Job Number
93	WennSoft Products (131)	3rd Party	JC30601	JC_Billing_Codes_HIST	WS_Job_Number	WS Job Number
94	WennSoft Products (131)	3rd Party	JC30701	JC_SOP_Jobs_WORK_HIST	WS_Job_Number	WS Job Number
95	WennSoft Products (131)	3rd Party	JC31001	JC_Change_Orders_MSTR_HIST	WS_Job_Number	WS Job Number
96	WennSoft Products (131)	3rd Party	JC31002	JC_Chg_Ord_Detail_MSTR_HIST	WS_Job_Number	WS Job Number
97	WennSoft Products (131)	3rd Party	JC31003	JC_Chg_Ord_Est_Revision_MSTR_HIST	WS_Job_Number	WS Job Number
98	WennSoft Products (131)	3rd Party	JC31201	JC_Forecast_Cost_Rev_MSTR_HIST	WS_Job_Number	WS Job Number
99	WennSoft Products (131)	3rd Party	JC50101	JC_Job_TRX_Number_TEMP	WS_Job_Number	WS Job Number
100	WennSoft Products (131)	3rd Party	JC50201	JC_Application_Payment_TEMP	WS_Job_Number	WS Job Number
101	WennSoft Products (131)	3rd Party	JC90001	JC_Project_Job_Invoice_VIEW	WS_Job_Number	WS Job Number
102	WennSoft Products (131)	3rd Party	JC90100	JC_Labor_Summary_VIEW	WS_Job_Number	WS Job Number
103	WennSoft Products (131)	3rd Party	JC90101	JC_Labor_Breakdown_VIEW	WS_Job_Number	WS Job Number
104	WennSoft Products (131)	3rd Party	JC90102	JC_Job_MSTR_VIEW	WS_Job_Number	WS Job Number
105	WennSoft Products (131)	3rd Party	JC90200	JC_Certified_Payroll_VIEW	WS_Job_Number	WS Job Number
106	WennSoft Products (131)	3rd Party	JC90400	JC_Estimate_Period_VIEW	WS_Job_Number	WS Job Number
107	WennSoft Products (131)	3rd Party	JC90700	JC_Inv_TRX_Level_Batch_VIEW	WS_Job_Number	WS Job Number
108	WennSoft Products (131)	3rd Party	JC90701	JC_Inv_TRX_Level_Labor_Batch_VIEW	WS_Job_Number	WS Job Number
109	WennSoft Products (131)	3rd Party	JC92001	JC_Job_Transaction_VIEW	WS_Job_Number	WS Job Number
110	WennSoft Products (131)	3rd Party	JC99701	JC_Cost_Code_Segment_View	WS_Job_Number	WS Job Number
111	WennSoft Products (131)	3rd Party	JC_NotGL	JC_JCTransactionNotInGL	WS_Job_Number	WS Job Number
112	WennSoft Products (131)	3rd Party	JC_WIP	JC_WIPReconciliation	WS_Job_Number	WS Job Number
113	WennSoft Products (131)	3rd Party	SV00300	SV_Service_MSTR	WS_Job_Number	WS Job Number
114	WennSoft Products (131)	3rd Party	SV00301	SV_Service_Appointments_MSTR	WS_Job_Number	WS Job Number
115	WennSoft Products (131)	3rd Party	SV70001	SV_SQL_Dispatch_Join	WS_Job_Number	WS Job Number
116	WennSoft Products (131)	3rd Party	SV90001	SV_Dispatch_Join	WS_Job_Number	WS Job Number
117	WennSoft Products (131)	3rd Party	SV90002	SV_Tech_Board_Join	WS_Job_Number	WS Job Number
118	WennSoft Products (131)	3rd Party	SV99300	SV_Service_MSTR_VIEW	WS_Job_Number	WS Job Number
119	WennSoft Products (131)	3rd Party	SVA0300	SV_Service_MSTR_Archive	WS_Job_Number	WS Job Number
120	WennSoft Products (131)	3rd Party	SVA0301	SV_Service_Appointments_MSTR_Archive	WS_Job_Number	WS Job Number
121	WennSoft Products (131)	3rd Party	WS00501	WS_Notes_MSTR	WS_Job_Number	WS Job Number
122	WennSoft Products (131)	3rd Party	WS10001	WS_Payables_TRX_WORK	WS_Job_Number	WS Job Number
123	WennSoft Products (131)	3rd Party	WS10702	WS Time Sheet TRX WORK	WS_Job_Number	WS Job Number
124	WennSoft Products (131)	3rd Party	WS10802	WS_GL_Transaction_WORK	WS_Job_Number	WS Job Number
125	WennSoft Products (131)	3rd Party	WS20001	WS_Payables_TRX_OPEN	WS_Job_Number	WS Job Number
126	WennSoft Products (131)	3rd Party	WS20002	WS_MT_INV_WORK	WS_Job_Number	WS Job Number
127	WennSoft Products (131)	3rd Party	WS20003	WS_MT_POP_WORK	WS_Job_Number	WS Job Number
128	WennSoft Products (131)	3rd Party	WS20802	WS_GL_Transaction_OPEN	WS_Job_Number	WS Job Number
129	WennSoft Products (131)	3rd Party	WS30002	WS_MT_INV_WORK_HIST	WS_Job_Number	WS Job Number
130	WennSoft Products (131)	3rd Party	WS30003	WS_MT_POP_HIST	WS_Job_Number	WS Job Number
131	WennSoft Products (131)	3rd Party	WS30501	WS_Notes_MSTR_HIST	WS_Job_Number	WS Job Number
132	WennSoft Products (131)	3rd Party	WS30702	WS Time Sheet TRX WORK HIST	WS_Job_Number	WS Job Number
133	WennSoft Products (131)	3rd Party	WSAUDT	WS Time Sheet TRX WORK_AUDIT	WS_Job_Number	WS Job Number
134	WennSoft Products (131)	3rd Party	WSDC009	SV_Comm_SalespersonJob	WS_Job_Number	WS Job Number
135	WennSoft Products (131)	3rd Party	WSDC010	SV_Comm_SalespersonJobTier	WS_Job_Number	WS Job Number
136	WennSoft Products (131)	3rd Party	WSDOCS	WS_Docs_MSTR	WS_Job_Number	WS Job Number
137	WennSoft Products (131)	3rd Party	WSPORET1	WS_PO_Retention_TEMP	WS_Job_Number	WS Job Number
138	WennSoft Products (131)	3rd Party	WSS10100	WS Sales Transaction Work	WS_Job_Number	WS Job Number
139	WennSoft Products (131)	3rd Party	WSS10200	WS Sales Transaction Amounts Work	WS_Job_Number	WS Job Number
140	WennSoft Products (131)	3rd Party	WSS30200	WS Sales Transaction History	WS_Job_Number	WS Job Number
141	WennSoft Products (131)	3rd Party	WSS30300	WS Sales Transaction Amounts History	WS_Job_Number	WS Job Number
142	WennSoft Products (131)	3rd Party	WSWHSE	WS Time Sheet TRX WORK_WHSE	WS_Job_Number	WS Job Number