Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVINTER5
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: ServiceMaintWarehouse
Physical Name: SVINTER5
Technical Name: ServiceMaintWarehouseSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR 
Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['ServiceMaintWarehouse'].CUSTNMBR AS 'ServiceMaintWarehouse-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVINTER5 AS ['ServiceMaintWarehouse']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['ServiceMaintWarehouse'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 ADRSCODE Address Code STR15_Address_Code String 15 3 Contract_Number WS Contract Number STR10 String 10 4 WSCONTSQ WS Contract Number Sequence LI_Sequence_Number Long Integer 10 5 Wennsoft_Affiliate Wennsoft Affiliate STR15_LBAU String 15 6 Wennsoft_Region Wennsoft Region STR15_LBAU String 15 7 Wennsoft_Branch Wennsoft Branch STR15_LBAU String 15 8 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ServiceMaintWarehouse'].USERID AS 'ServiceMaintWarehouse-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVINTER5 AS ['ServiceMaintWarehouse']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ServiceMaintWarehouse'].USERID = ['Users Master'].USERID9 Technician_ID Technician ID STR15_Employee_ID String 15 10 Technician_Team Technician Team STR15_LBAU String 15 11 Technician Technician STR10_LBAU String 10 12 CPRCSTNM Corporate Customer Number STR15_RM_Customer_Number String 15 13 Corporate_Contract_Nbr Corporate Contract Number STR20_LBAU String 20 14 WSMSTRCONTSQ WS Master Contract Seq Number LI_Sequence_Number Long Integer 10 15 Corporate_Invoice_Number Corporate Invoice Number STR17_LBAU String 17 16 Contract_Amount Contract Amount DLR14_RBS0_UTR$ Currency 14 17 Bill_Freq Bill Freq DDL_Bill_Freq Integer 0 18 Wennsoft_Close_Date Wennsoft Close Date DT Date 8 19 Amount_Billed Amount Billed0 DLR14_RBS0_STR$ Currency 14 20 SLPRSNID Salesperson ID STR15_Salesperson_ID String 15 Key to the RM Salesperson Master (RM00301).
Click to show/hide
SELECT
['ServiceMaintWarehouse'].SLPRSNID AS 'ServiceMaintWarehouse-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
SVINTER5 AS ['ServiceMaintWarehouse']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['ServiceMaintWarehouse'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID21 Annual_Contract_Value Annual Contract Value DLR14_RBS0_STR$ Currency 14 22 Revenue_Rec_Method_ID Revenue Recognition Method ID INT2 Integer 2 23 Invoice_Style Invoice Style INT2 Integer 2 24 Multiyear_Contract_Flag Multiyear Contract Flag Boolean Boolean 0 25 Contract_Start_Date WS Contract Start Date DT Date 8 26 Contract_Expiration_Date Contract Experation Date DT Date 8 27 Forecast_Original_Equip Forecast Original Equipment DLR14_RBS0_STR$ Currency 14 28 Forecast_Original_Labor Forecast Original Labor DLR14_RBS0_STR$ Currency 14 29 Fore_Orig_Material Forecast Original Material DLR14_RBS0_STR$ Currency 14 30 Forecast_Original_Other Forecast Original Other DLR14_RBS0_STR$ Currency 14 31 Forecast_Original_Subs Forecast Original Subs DLR14_RBS0_STR$ Currency 14 32 Forecast_Orig_Labor_1 Forecast Orig Labor 1 DLR14_RBS0_STR$ Currency 14 33 Forecast_Orig_Labor1_Hrs Forecast Orig Labor 1 Hours LI6_S2 Long Integer 6 34 Forecast_Orig_Labor_2 Forecast Orig Labor 2 DLR14_RBS0_STR$ Currency 14 35 Fore_Orig_Labor_2_Hrs Forecast Orig Labor 2 Hours LI6_S2 Long Integer 6 36 Forecast_Orig_Labor_3 Forecast Orig Labor 3 DLR14_RBS0_STR$ Currency 14 37 Forecast_Orig_Labor3_Hrs Forecast Orig Labor 3 Hours LI6_S2 Long Integer 6 38 Forecast_Orig_Labor_4 Forecast Orig Labor 4 DLR14_RBS0_STR$ Currency 14 39 Forecast_Orig_Labor4_Hrs Forecast Orig Labor 4 Hours LI6_S2 Long Integer 6 40 Forecast_Orig_Labor_5 Forecast Orig Labor 5 DLR14_RBS0_STR$ Currency 14 41 Forecast_Orig_Labor5_Hrs Forecast Orig Labor 5 Hours LI6_S2 Long Integer 6 42 Forecast_Orig_Tot_Labor Forecast Orig Total Labor DLR14_RBS0_STR$ Currency 14 43 Fore_Orig_Tot_Lbr_Hrs Forecast Orig Total Labor Hrs LI6_S2 Long Integer 6 44 Actual_Equipment Actual Equipment DLR14_RBS0_STR$ Currency 14 45 Actual_Labor Actual Labor DLR14_RBS0_STR$ Currency 14 46 Actual_Material Actual Material DLR14_RBS0_STR$ Currency 14 47 Actual_Subs Actual Subs DLR14_RBS0_STR$ Currency 14 48 Actual_Other Actual Other DLR14_RBS0_STR$ Currency 14 49 Total_Cost_Tax Total Cost Tax DLR11_$S2 Currency 14 50 Actual_Total_Cost Actual Total Cost DLR14_RBS0_STR$ Currency 14 51 Actual_Hours Actual Hours LI6_S2 Long Integer 6 52 Actual_Labor_1 Actual Labor 1 DLR14_RBS0_STR$ Currency 14 53 Actual_Labor_1_Hours Actual Labor 1 Hours LI6_S2 Long Integer 6 54 Actual_Labor_2 Actual Labor 2 DLR14_RBS0_STR$ Currency 14 55 Actual_Labor_2_Hours Actual Labor 2 Hours LI6_S2 Long Integer 6 56 Actual_Labor_3 Actual Labor 3 DLR14_RBS0_STR$ Currency 14 57 Actual_Labor_3_Hours Actual Labor 3 Hours LI6_S2 Long Integer 6 58 Actual_Labor_4 Actual Labor 4 DLR14_RBS0_STR$ Currency 14 59 Actual_Labor_4_Hours Actual Labor 4 Hours LI6_S2 Long Integer 6 60 Actual_Labor_5 Actual Labor 5 DLR14_RBS0_STR$ Currency 14 61 Actual_Labor_5_Hours Actual Labor 5 Hours LI6_S2 Long Integer 6 62 Actual_Total_Labor Actual Total Labor DLR14_RBS0_STR$ Currency 14 63 Actual_Total_Labor_Hrs Actual Total Labor Hrs LI6_S2 Long Integer 6 64 Estimate_Equipment Estimate Equipment DLR14_RBS0_STR$ Currency 14 65 Estimate_Labor Estimate Labor DLR14_RBS0_STR$ Currency 14 66 Estimate_Material Estimate Material DLR14_RBS0_STR$ Currency 14 67 Estimate_Subs Estimate Subs DLR14_RBS0_STR$ Currency 14 68 Estimate_Other Estimate Other DLR14_RBS0_STR$ Currency 14 69 Estimate_Total_Cost Estimate Total Cost DLR14_RBS0_STR$ Currency 14 70 Estimate_Hours Estimate Hours LI6_S2 Long Integer 6 71 Estimate_Labor_1 Estimate Labor 1 DLR14_RBS0_STR$ Currency 14 72 Estimate_Labor_1_Hours Estimate Labor 1 Hours LI6_S2 Long Integer 6 73 Estimate_Labor_2 Estimate Labor 2 DLR14_RBS0_STR$ Currency 14 74 Estimate_Labor_2_Hours Estimate Labor 2 Hours LI6_S2 Long Integer 6 75 Estimate_Labor_3 Estimate Labor 3 DLR14_RBS0_STR$ Currency 14 76 Estimate_Labor_3_Hours Estimate Labor 3 Hours LI6_S2 Long Integer 6 77 Estimate_Labor_4 Estimate Labor 4 DLR14_RBS0_STR$ Currency 14 78 Estimate_Labor_4_Hours Estimate Labor 4 Hours LI6_S2 Long Integer 6 79 Estimate_Labor_5 Estimate Labor 5 DLR14_RBS0_STR$ Currency 14 80 Estimate_Labor_5_Hours Estimate Labor 5 Hours LI6_S2 Long Integer 6 81 Estimate_Total_Labor Estimate Total Labor DLR14_RBS0_STR$ Currency 14 82 Estimate_Total_Labor_Hrs Estimate Total Labor Hrs LI6_S2 Long Integer 6 83 Forecast_Labor Forecast Labor DLR14_RBS0_STR$ Currency 14 84 Forecast_Equipment Forecast Equipment DLR14_RBS0_STR$ Currency 14 85 Forecast_Material Forecast Material DLR14_RBS0_STR$ Currency 14 86 Forecast_Subs Forecast Subs DLR14_RBS0_STR$ Currency 14 87 Forecast_Other Forecast Other DLR14_RBS0_STR$ Currency 14 88 Forecast_Total_Cost Forecast Total Cost DLR14_RBS0_STR$ Currency 14 89 Forecast_Hours Forecast Hours LI6_S2 Long Integer 6 90 Forecast_Labor_1 Forecast Labor 1 DLR14_RBS0_STR$ Currency 14 91 Forecast_Labor_1_Hours Forecast Labor 1 Hours LI6_S2 Long Integer 6 92 Forecast_Labor_2 Forecast Labor 2 DLR14_RBS0_STR$ Currency 14 93 Forecast_Labor_2_Hours Forecast Labor 2 Hours LI6_S2 Long Integer 6 94 Forecast_Labor_3 Forecast Labor 3 DLR14_RBS0_STR$ Currency 14 95 Forecast_Labor_3_Hours Forecast Labor 3 Hours LI6_S2 Long Integer 6 96 Forecast_Labor_4 Forecast Labor 4 DLR14_RBS0_STR$ Currency 14 97 Forecast_Labor_4_Hours Forecast Labor 4 Hours LI6_S2 Long Integer 6 98 Forecast_Labor_5 Forecast Labor 5 DLR14_RBS0_STR$ Currency 14 99 Forecast_Labor_5_Hours Forecast Labor 5 Hours LI6_S2 Long Integer 6 100 Forecast_Total_Labor Forecast Total Labor DLR14_RBS0_STR$ Currency 14 101 Forecast_Total_Labor_Hrs Forecast Total Labor Hrs LI6_S2 Long Integer 6 102 Task_Est_Rollup_Group Task Estimate Rollup Group GB Integer 0 103 Contract_Description Contract Description STR30_LBAU String 30 104 User_Define_1a User Define 1a STR30 String 30 105 User_Define_2a User Define 2a STR30 String 30 106 User_Define_3a User Define 3a STR30 String 30 107 User_Define_4a User Define 4a STR30 String 30 108 Service_User_Define_3 Service User Define 3 STR30 String 30 109 Service_User_Define_5 Service User Define 5 LI6_S2 Long Integer 6 110 Service_User_Define_6 Service User Define 6 LI6_S2 Long Integer 6 111 Service_User_Define_9 Service User Define 9 DT Date 8 112 Service_User_Define_10 Service User Define 10 DT Date 8 113 Service_User_Define_18 Service User Define 18 CB Boolean 0 114 Service_User_Define_19 Service User Define 19 CB Boolean 0 115 Service_User_Define_22 Service User Define 22 DLR14_RBS0_STR$ Currency 14 116 Service_User_Define_23 Service User Define 23 DLR14_RBS0_STR$ Currency 14 117 Service_User_Define_24 Service User Define 24 DLR14_RBS0_STR$ Currency 14 118 Contract_Billing_Date Contract Billing Date INT2_U0 Integer 2 119 Contract_Service_Date Contract Service Date INT2_U0 Integer 2 120 WS_Closed WS Closed True/False Boolean 0 121 Auto_Bill Auto Bill CB_Auto_Bill Boolean 0 122 Purchase_Order Purchase Order STR15 String 15 123 LSTFSCDY Last Fiscal Day DT_Date Date 6 124 Divisions Divisions STR15_LBAU String 15 125 PY_Labor PY Labor DLR14_RBS0_STR$ Currency 14 126 PY_Material PY Material DLR14_RBS0_STR$ Currency 14 127 PY_Equipment PY Equipment DLR14_RBS0_STR$ Currency 14 128 PY_Subcontractor PY Subcontractor DLR14_RBS0_STR$ Currency 14 129 PY_Other PY Other DLR14_RBS0_STR$ Currency 14 130 PY_Total_Cost PY Total Cost DLR14_RBS0_STR$ Currency 14 131 PY_Billed PY Billed DLR14_RBS0_STR$ Currency 14 132 PY_Contract_Earned PY Contract Earned DLR14_RBS0_STR$ Currency 14 133 PY_Gross_Profit PY Gross Profit DLR14_RBS0_STR$ Currency 14 134 PY_Revenue_Recognized PY Revenue Recognized DLR14_RBS0_STR$ Currency 14 135 PY_Hours PY Hours LI6_S2 Long Integer 6 136 PY_Labor_1 PY Labor 1 DLR14_RBS0_STR$ Currency 14 137 PY_Labor_1_Hours PY Labor 1 Hours LI6_S2 Long Integer 6 138 PY_Labor_2 PY Labor 2 DLR14_RBS0_STR$ Currency 14 139 PY_Labor_2_Hours PY Labor 2 Hours LI6_S2 Long Integer 6 140 PY_Labor_3 PY Labor 3 DLR14_RBS0_STR$ Currency 14 141 PY_Labor_3_Hours PY Labor 3 Hours LI6_S2 Long Integer 6 142 PY_Labor_4 PY Labor 4 DLR14_RBS0_STR$ Currency 14 143 PY_Labor_4_Hours PY Labor 4 Hours LI6_S2 Long Integer 6 144 PY_Labor_5 PY Labor 5 DLR14_RBS0_STR$ Currency 14 145 PY_Labor_5_Hours PY Labor 5 Hours LI6_S2 Long Integer 6 146 PY_Total_Labor PY Total Labor DLR14_RBS0_STR$ Currency 14 147 PY_Total_Labor_Hrs PY Total Labor Hrs LI6_S2 Long Integer 6 148 YTD_Labor YTD Labor DLR14_RBS0_STR$ Currency 14 149 YTD_Material YTD Material DLR14_RBS0_STR$ Currency 14 150 YTD_Equipment YTD Equipment DLR14_RBS0_STR$ Currency 14 151 YTD_Subcontractor YTD Subcontractor DLR14_RBS0_STR$ Currency 14 152 YTD_Other YTD Other DLR14_RBS0_STR$ Currency 14 153 YTD_Total_Cost YTD Total Cost DLR14_RBS0_STR$ Currency 14 154 YTD_Billed YTD Billed DLR14_RBS0_STR$ Currency 14 155 YTD_Contract_Earned YTD Contract Earned DLR14_RBS0_STR$ Currency 14 156 YTD_Gross_Profit YTD Gross Profit DLR14_RBS0_STR$ Currency 14 157 YTD_Revenue_Recognized YTD Revenue Recognized DLR14_RBS0_STR$ Currency 14 158 YTDHOURS YTD Hours LI6_S2 Long Integer 6 159 YTD_Labor_1 YTD Labor 1 DLR14_RBS0_STR$ Currency 14 160 YTD_Labor_1_Hours YTD Labor 1 Hours LI6_S2 Long Integer 6 161 YTD_Labor_2 YTD Labor 2 DLR14_RBS0_STR$ Currency 14 162 YTD_Labor_2_Hours YTD Labor 2 Hours LI6_S2 Long Integer 6 163 YTD_Labor_3 YTD Labor 3 DLR14_RBS0_STR$ Currency 14 164 YTD_Labor_3_Hours YTD Labor 3 Hours LI6_S2 Long Integer 6 165 YTD_Labor_4 YTD Labor 4 DLR14_RBS0_STR$ Currency 14 166 YTD_Labor_4_Hours YTD Labor 4 Hours LI6_S2 Long Integer 6 167 YTD_Labor_5 YTD Labor 5 DLR14_RBS0_STR$ Currency 14 168 YTD_Labor_5_Hours YTD Labor 5 Hours LI6_S2 Long Integer 6 169 YTD_Total_Labor YTD Total Labor DLR14_RBS0_STR$ Currency 14 170 YTD_Total_Labor_Hrs YTD Total Labor Hrs LI6_S2 Long Integer 6 171 TTD_Billed TTD Billed DLR14_RBS0_STR$ Currency 14 172 TTD_Contract_Earned TTD Contract Earned DLR14_RBS0_STR$ Currency 14 173 TTD_Gross_Profit TTD Gross Profit DLR14_RBS0_STR$ Currency 14 174 TTD_Revenue_Recognized TTD Revenue Recognized DLR14_RBS0_STR$ Currency 14 175 Auto_Date Auto Date DATE Date 6 176 Cancel_Box Cancel Box CB_Cancel Boolean 0 177 HOLD Hold CB_Hold Boolean 0 178 Excess_Cost Excess Cost DLR14_RBS0_STR$ Currency 14 179 Unbilled_Receivable Unbilled Receivable DLR14_RBS0_STR$ Currency 14 180 Contract_NTE_Units Contract NTE Units LI8 Long Integer 8 181 Contract_Actual_Units Contract Actual Units LI8 Long Integer 8 182 Equipment_ID Equipment ID STR30 String 30 183 Warranty_Checkbox Warranty Checkbox CB_Warranty Boolean 0 184 MODIFDT Modified Date DT Date 8 185 Modified_Time Modified Time TM6 Time 6 186 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ServiceMaintWarehouse'].MDFUSRID AS 'ServiceMaintWarehouse-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVINTER5 AS ['ServiceMaintWarehouse']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ServiceMaintWarehouse'].MDFUSRID = ['Users Master'].USERID187 Time_Zone Time Zone STR3 String 3 188 SV_Language_ID SV Language ID INT2 Integer 2 189 Base_Currency_ID Base Currency ID STR15_Currency_ID String 15 190 Billing_Currency_ID Billing Currency ID STR15_Currency_ID String 15 191 Local_Currency_ID Local Currency ID STR15_Currency_ID String 15 192 Hold_Reason_ID Hold Reason ID INT5 Integer 4 193 Billing_Equipment Billing Equipment DLR14_RBS0_STR$ Currency 14 194 Billing_Material Billing Material DLR14_RBS0_STR$ Currency 14 195 Billing_Labor Billing Labor DLR14_RBS0_STR$ Currency 14 196 Billing_Subs Billing Subs DLR14_RBS0_STR$ Currency 14 197 Billing_Other Billing Other DLR14_RBS0_STR$ Currency 14 198 Billing_Percentage_Equip Billing Percentage Equip DLR5_%2 Currency 8 199 Billing_Pct_Material Billing Percentage Material DLR5_%2 Currency 8 200 Billing_Percentage_Labor Billing Percentage Labor DLR5_%2 Currency 8 201 Billing_Percentage_Subs Billing Percentage Subs DLR5_%2 Currency 8 202 Billing_Percentage_Other Billing Percentage Other DLR5_%2 Currency 8 203 Current_Billing_Amount Current Billing Amount DLR14_RBS0_STR$ Currency 14 204 Escalation_Frequency Escalation Frequency STR15_LBAU String 15 205 Escalation_Date Escalation Date DATE Date 6 206 Escal_Notify_Days Escalation Notification Days INT3_U0 Integer 3 207 Next_Escalation_Date Next Escalation Date DATE Date 6 208 Begin_Date_CY Begin Date CY DATE Date 6 209 Anniversary_Date Anniversary Date DT Date 8 210 Evergreen_Contract_Flag Evergreen Contract Flag Boolean Boolean 0 211 Contract_Units_Measure Contract Units Measure STR15_LBAU String 15 212 Last_Review_Date Last Review Date DATE Date 6 213 Last_Review_User_ID Last Review User ID STR15_User_ID String 15 214 Contract_Internal_Name Contract Internal Name STR15_LBAU String 15 215 Auto_Escalation_Flag Automatic Escalation Flag CB Boolean 0 216 WSReserved_CB1 WSReserved CB1 CB Boolean 0 217 WSReserved_CB2 WSReserved CB2 CB Boolean 0 218 WSReserved_CB3 WSReserved CB3 CB Boolean 0 219 WSReserved_CB4 WSReserved CB4 CB Boolean 0 220 WSReserved_CB5 WSReserved CB5 CB Boolean 0 221 WSReserved_CB6 WSReserved CB6 CB Boolean 0 222 WSReserved_CB7 WSReserved CB7 CB Boolean 0 223 WSReserved_CB8 WSReserved CB8 CB Boolean 0 224 WSReserved_CB9 WSReserved CB9 CB Boolean 0 225 WSReserved_CB10 WSReserved CB10 CB Boolean 0 226 WSReserved_STR1 WSReserved STR1 STR10 String 10 227 WSReserved_STR2 WSReserved STR2 STR10 String 10