Seq No | Product Name | Series Name | Table Physical Name | Table Display Name | Field Physical Name | Field Display Name |
---|
1 | Microsoft Dynamics GP (0) | Sales | RM00301 | RM Salesperson Master | EMPLOYID | Employee ID |
2 | Microsoft Dynamics GP (0) | Inventory | IV00700V | Two Step Transfer View | EMPLOYID | Employee ID |
3 | Microsoft Dynamics GP (0) | Payroll | DD00100 | Direct Deposit Employee Master | EMPLOYID | Employee ID |
4 | Microsoft Dynamics GP (0) | Payroll | DD00200 | Direct Deposit Employee Account Master | EMPLOYID | Employee ID |
5 | Microsoft Dynamics GP (0) | Payroll | DD10100 | Direct Deposit Employee Deposits Work | EMPLOYID | Employee ID |
6 | Microsoft Dynamics GP (0) | Payroll | DD10300 | Direct Deposit ACH Cross Reference | EMPLOYID | Employee ID |
7 | Microsoft Dynamics GP (0) | Payroll | DD10500 | Direct Deposit ACH Items | EMPLOYID | Employee ID |
8 | Microsoft Dynamics GP (0) | Payroll | DD10600 | Direct Deposit Prenotes Completed | EMPLOYID | Employee ID |
9 | Microsoft Dynamics GP (0) | Payroll | DD10700 | Direct Deposit Exceptions | EMPLOYID | Employee ID |
10 | Microsoft Dynamics GP (0) | Payroll | DD20100 | ESS Direct Deposit Employee Work | EMPLOYID | Employee ID |
11 | Microsoft Dynamics GP (0) | Payroll | DD20101 | ESS Direct Deposit Employee Account Work | EMPLOYID | Employee ID |
12 | Microsoft Dynamics GP (0) | Payroll | DD30101 | Direct Deposit Transaction History Detail | EMPLOYID | Employee ID |
13 | Microsoft Dynamics GP (0) | Payroll | DD40500 | Direct Deposit ACH Prenotes Setup | EMPLOYID | Employee ID |
14 | Microsoft Dynamics GP (0) | Payroll | UPR00100 | Payroll Master | EMPLOYID | Employee ID |
15 | Microsoft Dynamics GP (0) | Payroll | UPR00102 | Payroll Address Master | EMPLOYID | Employee ID |
16 | Microsoft Dynamics GP (0) | Payroll | UPR00111 | Payroll Master Dependent | EMPLOYID | Employee ID |
17 | Microsoft Dynamics GP (0) | Payroll | UPR00112 | Payroll Master Education | EMPLOYID | Employee ID |
18 | Microsoft Dynamics GP (0) | Payroll | UPR00113 | Payroll Master Contacts | EMPLOYID | Employee ID |
19 | Microsoft Dynamics GP (0) | Payroll | UPR00200 | Payroll Timecard Time on Behalf Master | EMPLOYID | Employee ID |
20 | Microsoft Dynamics GP (0) | Payroll | UPR00201 | Payroll Timecard Time on Behalf Departments Master | EMPLOYID | Employee ID |
21 | Microsoft Dynamics GP (0) | Payroll | UPR00202 | Payroll Timecard Time on Behalf Classes Master | EMPLOYID | Employee ID |
22 | Microsoft Dynamics GP (0) | Payroll | UPR00203 | Payroll Time on Behalf Employees Master | EMPLOYID | Employee ID |
23 | Microsoft Dynamics GP (0) | Payroll | UPR00210 | Payroll Timecard Assignment Master | EMPLOYID | Employee ID |
24 | Microsoft Dynamics GP (0) | Payroll | UPR00211 | Payroll Timecard Assignment Detail Master | EMPLOYID | Employee ID |
25 | Microsoft Dynamics GP (0) | Payroll | UPR00220 | Payroll Timecard Template Transactions | EMPLOYID | Employee ID |
26 | Microsoft Dynamics GP (0) | Payroll | UPR00221 | Payroll Timecard Template Transaction Detail | EMPLOYID | Employee ID |
27 | Microsoft Dynamics GP (0) | Payroll | UPR00222 | Payroll Timecard Template Start/Stop | EMPLOYID | Employee ID |
28 | Microsoft Dynamics GP (0) | Payroll | UPR00300 | Payroll Tax Information Master | EMPLOYID | Employee ID |
29 | Microsoft Dynamics GP (0) | Payroll | UPR00400 | Payroll Pay Code Master | EMPLOYID | Employee ID |
30 | Microsoft Dynamics GP (0) | Payroll | UPR00402 | Payroll Post Dated Pay Code Master | EMPLOYID | Employee ID |
31 | Microsoft Dynamics GP (0) | Payroll | UPR00500 | Payroll Deduction Master | EMPLOYID | Employee ID |
32 | Microsoft Dynamics GP (0) | Payroll | UPR00501 | Payroll Deduction Based On Master | EMPLOYID | Employee ID |
33 | Microsoft Dynamics GP (0) | Payroll | UPR00502 | Payroll Deduction Sequence Master | EMPLOYID | Employee ID |
34 | Microsoft Dynamics GP (0) | Payroll | UPR00600 | Payroll Benefit Master | EMPLOYID | Employee ID |
35 | Microsoft Dynamics GP (0) | Payroll | UPR00601 | Payroll Benefit Based On Master | EMPLOYID | Employee ID |
36 | Microsoft Dynamics GP (0) | Payroll | UPR00700 | Payroll State Tax Master | EMPLOYID | Employee ID |
37 | Microsoft Dynamics GP (0) | Payroll | UPR00800 | Payroll Local Tax Master | EMPLOYID | Employee ID |
38 | Microsoft Dynamics GP (0) | Payroll | UPR00900 | Payroll Employee Summary | EMPLOYID | Employee ID |
39 | Microsoft Dynamics GP (0) | Payroll | UPR00901 | Payroll Employee Tips Summary | EMPLOYID | Employee ID |
40 | Microsoft Dynamics GP (0) | Payroll | UPR00902 | Payroll Employee Fiscal Summary | EMPLOYID | Employee ID |
41 | Microsoft Dynamics GP (0) | Payroll | UPR00903 | Payroll Employee Tips Fiscal Summary | EMPLOYID | Employee ID |
42 | Microsoft Dynamics GP (0) | Payroll | UPR00904 | Payroll Master Dependent ACA | EMPLOYID | Employee ID |
43 | Microsoft Dynamics GP (0) | Payroll | UPR00905 | Payroll Master Employee ACA | EMPLOYID | Employee ID |
44 | Microsoft Dynamics GP (0) | Payroll | UPR10101 | Payroll Year End Wage | EMPLOYID | Employee ID |
45 | Microsoft Dynamics GP (0) | Payroll | UPR10103 | Payroll Year End Pension | EMPLOYID | Employee ID |
46 | Microsoft Dynamics GP (0) | Payroll | UPR10104 | Payroll Year End Special | EMPLOYID | Employee ID |
47 | Microsoft Dynamics GP (0) | Payroll | UPR10105 | Payroll Year End State | EMPLOYID | Employee ID |
48 | Microsoft Dynamics GP (0) | Payroll | UPR10106 | Payroll Year End Local | EMPLOYID | Employee ID |
49 | Microsoft Dynamics GP (0) | Payroll | UPR10107 | Payroll Year End Other | EMPLOYID | Employee ID |
50 | Microsoft Dynamics GP (0) | Payroll | UPR10108 | Payroll Year End Dependent ACA History | EMPLOYID | Employee ID |
51 | Microsoft Dynamics GP (0) | Payroll | UPR10109 | Payroll Year End Dependent ACA | EMPLOYID | Employee ID |
52 | Microsoft Dynamics GP (0) | Payroll | UPR10110 | Payroll Year End Employee ACA History | EMPLOYID | Employee ID |
53 | Microsoft Dynamics GP (0) | Payroll | UPR10111 | Payroll Year End Employee ACA | EMPLOYID | Employee ID |
54 | Microsoft Dynamics GP (0) | Payroll | UPR10202 | Payroll Work Header | EMPLOYID | Employee ID |
55 | Microsoft Dynamics GP (0) | Payroll | UPR10203 | Payroll Work Pay Code | EMPLOYID | Employee ID |
56 | Microsoft Dynamics GP (0) | Payroll | UPR10204 | Payroll Work Deduction | EMPLOYID | Employee ID |
57 | Microsoft Dynamics GP (0) | Payroll | UPR10205 | Payroll Work Benefit | EMPLOYID | Employee ID |
58 | Microsoft Dynamics GP (0) | Payroll | UPR10206 | Payroll Work State Tax | EMPLOYID | Employee ID |
59 | Microsoft Dynamics GP (0) | Payroll | UPR10207 | Payroll Work Local Tax | EMPLOYID | Employee ID |
60 | Microsoft Dynamics GP (0) | Payroll | UPR10208 | Payroll Work Check | EMPLOYID | Employee ID |
61 | Microsoft Dynamics GP (0) | Payroll | UPR10209 | Payroll Work Post | EMPLOYID | Employee ID |
62 | Microsoft Dynamics GP (0) | Payroll | UPR10213 | Payroll Check Descriptions | EMPLOYID | Employee ID |
63 | Microsoft Dynamics GP (0) | Payroll | UPR10214 | Payroll Work Check YTD Amounts | EMPLOYID | Employee ID |
64 | Microsoft Dynamics GP (0) | Payroll | UPR10215 | Payroll Work Void Check Reasons | EMPLOYID | Employee ID |
65 | Microsoft Dynamics GP (0) | Payroll | UPR10302 | Payroll Transactions | EMPLOYID | Employee ID |
66 | Microsoft Dynamics GP (0) | Payroll | UPR10303 | Payroll Transaction Audit | EMPLOYID | Employee ID |
67 | Microsoft Dynamics GP (0) | Payroll | UPR10307 | Payroll Manual Check | EMPLOYID | Employee ID |
68 | Microsoft Dynamics GP (0) | Payroll | UPR10308 | Payroll Manual Check Detail | EMPLOYID | Employee ID |
69 | Microsoft Dynamics GP (0) | Payroll | UPR10500 | Payroll Timecard Header | EMPLOYID | Employee ID |
70 | Microsoft Dynamics GP (0) | Payroll | UPR10501 | Payroll Timecard Detail | EMPLOYID | Employee ID |
71 | Microsoft Dynamics GP (0) | Payroll | UPR10502 | Payroll Timecard Start/Stop Detail | EMPLOYID | Employee ID |
72 | Microsoft Dynamics GP (0) | Payroll | UPR30100 | Payroll Check History | EMPLOYID | Employee ID |
73 | Microsoft Dynamics GP (0) | Payroll | UPR30300 | Payroll Transaction History | EMPLOYID | Employee ID |
74 | Microsoft Dynamics GP (0) | Payroll | UPR30301 | Payroll Transaction History Header | EMPLOYID | Employee ID |
75 | Microsoft Dynamics GP (0) | Payroll | UPR30401 | Payroll Distribution History Detail | EMPLOYID | Employee ID |
76 | Microsoft Dynamics GP (0) | Payroll | UPR30500 | Payroll Timecard History Header | EMPLOYID | Employee ID |
77 | Microsoft Dynamics GP (0) | Payroll | UPR30501 | Payroll Timecard History Detail | EMPLOYID | Employee ID |
78 | Microsoft Dynamics GP (0) | Payroll | UPR30502 | Payroll Timecard Start/Stop History | EMPLOYID | Employee ID |
79 | Microsoft Dynamics GP (0) | Payroll | UPR30600 | ESS Profile | EMPLOYID | Employee ID |
80 | Microsoft Dynamics GP (0) | Payroll | UPR30601 | ESS Profile Personal | EMPLOYID | Employee ID |
81 | Microsoft Dynamics GP (0) | Payroll | UPR30602 | ESS Profile Contacts | EMPLOYID | Employee ID |
82 | Microsoft Dynamics GP (0) | Payroll | UPR30603 | ESS Profile Dependents | EMPLOYID | Employee ID |
83 | Microsoft Dynamics GP (0) | Payroll | UPR30604 | Payroll ESS W4 History | EMPLOYID | Employee ID |
84 | Microsoft Dynamics GP (0) | Payroll | UPR30700 | Payroll Employee History | EMPLOYID | Employee ID |
85 | Microsoft Dynamics GP (0) | Payroll | UPR41700 | Payroll Setup Supervisor | EMPLOYID | Employee ID |
86 | Microsoft Dynamics GP (0) | Payroll | UPR42106 | Payroll Pay Schedule Employees | EMPLOYID | Employee ID |
87 | Microsoft Dynamics GP (0) | Payroll | UPR42406 | Payroll Timecard Restriction Employees | EMPLOYID | Employee ID |
88 | Microsoft Dynamics GP (0) | Payroll | UPR42505 | Payroll Timecard Batch Prefix Employee Setup | EMPLOYID | Employee ID |
89 | Microsoft Dynamics GP (0) | Payroll | UPR50000 | UPR_EmployeeList_View | EMPLOYID | Employee ID |
90 | WennSoft Products (131) | 3rd Party | JC00801 | JC_Employee_Union_Code_MSTR | EMPLOYID | Employee ID |
91 | WennSoft Products (131) | 3rd Party | JC00802 | JC Employee Fringe Master | EMPLOYID | Employee ID |
92 | WennSoft Products (131) | 3rd Party | JC10302 | JC_Job_TRX_LINE_WORK | EMPLOYID | Employee ID |
93 | WennSoft Products (131) | 3rd Party | JC10504 | JC_Invoice_TRX_WORK | EMPLOYID | Employee ID |
94 | WennSoft Products (131) | 3rd Party | JC10514 | JC_Project_TRX_Level_Transfer | EMPLOYID | Employee ID |
95 | WennSoft Products (131) | 3rd Party | JC10701 | JC_Payroll_Transaction_WORK | EMPLOYID | Employee ID |
96 | WennSoft Products (131) | 3rd Party | JC10702 | JC Time Sheet TRX WORK | EMPLOYID | Employee ID |
97 | WennSoft Products (131) | 3rd Party | JC10703 | JC Payroll Post WORK | EMPLOYID | Employee ID |
98 | WennSoft Products (131) | 3rd Party | JC20001 | JC_Job_Transaction_OPEN | EMPLOYID | Employee ID |
99 | WennSoft Products (131) | 3rd Party | JC20504 | JC_Invoice_TRX_OPEN | EMPLOYID | Employee ID |
100 | WennSoft Products (131) | 3rd Party | JC20601 | JC_Union_Transaction_OPEN | EMPLOYID | Employee ID |
101 | WennSoft Products (131) | 3rd Party | JC30201 | JC_Job_Transaction_OPEN_HIST | EMPLOYID | Employee ID |
102 | WennSoft Products (131) | 3rd Party | JC30504 | JC_Invoice_TRX_HIST | EMPLOYID | Employee ID |
103 | WennSoft Products (131) | 3rd Party | JC90100 | JC_Labor_Summary_VIEW | EMPLOYID | Employee ID |
104 | WennSoft Products (131) | 3rd Party | JC90200 | JC_Certified_Payroll_VIEW | EMPLOYID | Employee ID |
105 | WennSoft Products (131) | 3rd Party | JC90700 | JC_Inv_TRX_Level_Batch_VIEW | EMPLOYID | Employee ID |
106 | WennSoft Products (131) | 3rd Party | JC90701 | JC_Inv_TRX_Level_Labor_Batch_VIEW | EMPLOYID | Employee ID |
107 | WennSoft Products (131) | 3rd Party | JC92001 | JC_Job_Transaction_VIEW | EMPLOYID | Employee ID |
108 | WennSoft Products (131) | 3rd Party | JC92601 | JC_Union_Trx_OPEN_Summary_VIEW | EMPLOYID | Employee ID |
109 | WennSoft Products (131) | 3rd Party | JCPAY01 | JC_Payroll_Union_TEMP | EMPLOYID | Employee ID |
110 | WennSoft Products (131) | 3rd Party | JCUNION1 | JC_Monthly_Union_Report_TEMP | EMPLOYID | Employee ID |
111 | WennSoft Products (131) | 3rd Party | JCUPAY1 | JC_Union_Monthly_Payroll_TEMP | EMPLOYID | Employee ID |
112 | WennSoft Products (131) | 3rd Party | SV000810 | SV_Job_Costs_WORK | EMPLOYID | Employee ID |
113 | WennSoft Products (131) | 3rd Party | SV000811 | SV_Job_Costs_WORK_Report | EMPLOYID | Employee ID |
114 | WennSoft Products (131) | 3rd Party | SV000815 | SV_Job_Costs_HISTORY | EMPLOYID | Employee ID |
115 | WennSoft Products (131) | 3rd Party | SV00115 | SV_Lookup_Tech_MSTR | EMPLOYID | Employee ID |
116 | WennSoft Products (131) | 3rd Party | SV00308 | SV_Service_Request_Lookup_MSTR | EMPLOYID | Employee ID |
117 | WennSoft Products (131) | 3rd Party | SV00309 | SV_Service_Request_MSTR | EMPLOYID | Employee ID |
118 | WennSoft Products (131) | 3rd Party | SV00910 | SV_User_Preference_MSTR | EMPLOYID | Employee ID |
119 | WennSoft Products (131) | 3rd Party | SVA00815 | SV_Job_Costs_HISTORY Archive | EMPLOYID | Employee ID |
120 | WennSoft Products (131) | 3rd Party | SVA0115 | SV_Lookup_Tech_MSTR Archive | EMPLOYID | Employee ID |
121 | WennSoft Products (131) | 3rd Party | SVA0309 | SV Service Requests Archive | EMPLOYID | Employee ID |
122 | WennSoft Products (131) | 3rd Party | SVINTER4 | ServiceTechWarehouse | EMPLOYID | Employee ID |
123 | WennSoft Products (131) | 3rd Party | SVINTER7 | ServiceJCHWarehouse | EMPLOYID | Employee ID |
124 | WennSoft Products (131) | 3rd Party | SV_Costs | SV_Service_Costs_VIEW | EMPLOYID | Employee ID |
125 | WennSoft Products (131) | 3rd Party | SV_NotGL | SV_ServiceNotInGL_View | EMPLOYID | Employee ID |
126 | WennSoft Products (131) | 3rd Party | SV_SVC_R | SV_Service_Request_MSTR_RPT | EMPLOYID | Employee ID |
127 | WennSoft Products (131) | 3rd Party | WS00106 | WS Notfications E-mail Addresses | EMPLOYID | Employee ID |
128 | WennSoft Products (131) | 3rd Party | WS00501 | WS_Notes_MSTR | EMPLOYID | Employee ID |
129 | WennSoft Products (131) | 3rd Party | WS10702 | WS Time Sheet TRX WORK | EMPLOYID | Employee ID |
130 | WennSoft Products (131) | 3rd Party | WS10802 | WS_GL_Transaction_WORK | EMPLOYID | Employee ID |
131 | WennSoft Products (131) | 3rd Party | WS20802 | WS_GL_Transaction_OPEN | EMPLOYID | Employee ID |
132 | WennSoft Products (131) | 3rd Party | WS30501 | WS_Notes_MSTR_HIST | EMPLOYID | Employee ID |
133 | WennSoft Products (131) | 3rd Party | WS30702 | WS Time Sheet TRX WORK HIST | EMPLOYID | Employee ID |
134 | WennSoft Products (131) | 3rd Party | WS41001 | WS_Registered_Users_SETP | EMPLOYID | Employee ID |
135 | WennSoft Products (131) | 3rd Party | WS42003 | WS_Work_Crew_Employees | EMPLOYID | Employee ID |
136 | WennSoft Products (131) | 3rd Party | WS50101 | WS Notifications Emailed Header Temp | EMPLOYID | Employee ID |
137 | WennSoft Products (131) | 3rd Party | WS50102 | WS Notifications Emailed RecipientsTemp | EMPLOYID | Employee ID |
138 | WennSoft Products (131) | 3rd Party | WS50103 | WS Notifications Header Temporary File | EMPLOYID | Employee ID |
139 | WennSoft Products (131) | 3rd Party | WS90000 | WS_Employee_Pay_Type_VIEW | EMPLOYID | Employee ID |
140 | WennSoft Products (131) | 3rd Party | WS90001 | WS_Batch_Lookup_VIEW | EMPLOYID | Employee ID |
141 | WennSoft Products (131) | 3rd Party | WS90011 | WS_Ex_Batch_Lookup_HIST_VIEW | EMPLOYID | Employee ID |
142 | WennSoft Products (131) | 3rd Party | WS90012 | WS_Ex_Employee_Lookup_HIST_VIEW | EMPLOYID | Employee ID |
143 | WennSoft Products (131) | 3rd Party | WS90013 | WS_Ex_Date_Lookup_HIST_VIEW | EMPLOYID | Employee ID |
144 | WennSoft Products (131) | 3rd Party | WS90015 | WS_Employee_Lookup_HIST_VIEW | EMPLOYID | Employee ID |
145 | WennSoft Products (131) | 3rd Party | WSAUDT | WS Time Sheet TRX WORK_AUDIT | EMPLOYID | Employee ID |
146 | WennSoft Products (131) | 3rd Party | WSWHSE | WS Time Sheet TRX WORK_WHSE | EMPLOYID | Employee ID |
147 | Company Archive (1755) | Company | pauprt01 | PA - Payroll Check History | EMPLOYID | Employee ID |
148 | Company Archive (1755) | Company | pauprt02 | PA - Payroll Transaction History | EMPLOYID | Employee ID |
149 | Mekorma MICR (2404) | Payroll | ME240467 | Mekorma MICR Payroll Direct Deposit Opt In | EMPLOYID | Employee ID |
150 | Mekorma MICR (2404) | Payroll | ME27646 | Mekorma MICR Payroll Work Check Sorted Sequence | EMPLOYID | Employee ID |
151 | Mekorma MICR (2404) | Payroll | ME27646 | Mekorma MICR Payroll Work Check Sorted Sequence | EMPLOYID | Employee ID |
152 | Mekorma MICR (2404) | Payroll | ME27646 | Mekorma MICR Payroll Work Check Sorted Sequence | EMPLOYID | Employee ID |
153 | Mekorma MICR (2404) | Payroll | ME27646 | ME_UPR_WORK_Check_Sorted_Sequence_1 | EMPLOYID | Employee ID |
154 | Mekorma MICR (2404) | Payroll | ME27646 | ME_UPR_WORK_Check_Sorted_Sequence_1 | EMPLOYID | Employee ID |
155 | Mekorma MICR (2404) | Payroll | ME27646 | ME_UPR_WORK_Check_Sorted_Sequence_1 | EMPLOYID | Employee ID |
156 | Mekorma MICR (2404) | Payroll | ME27646 | ME_UPR_WORK_Check_Sorted_Sequence_2 | EMPLOYID | Employee ID |
157 | Mekorma MICR (2404) | Payroll | ME27646 | ME_UPR_WORK_Check_Sorted_Sequence_2 | EMPLOYID | Employee ID |
158 | Mekorma MICR (2404) | Payroll | ME27646 | ME_UPR_WORK_Check_Sorted_Sequence_2 | EMPLOYID | Employee ID |
159 | Mekorma MICR (2404) | Payroll | ME61761 | MEM Connector for Payroll Employee Checkbook | EMPLOYID | Employee ID |
160 | MICR for Canadian Payroll (2916) | Payroll | ME27646 | ME_UPR_WORK_Check_Sorted_Sequence | EMPLOYID | Employee ID |
161 | Extender (3107) | Project | EXT41400 | Extender Timesheets | EMPLOYID | Employee ID |