Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVMAINTE
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Maint_Escalation_TEMP
Physical Name: SVMAINTE
Technical Name: SV_Maint_Escalation_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Maint_Escalation_TEMP'].USERID AS 'SV_Maint_Escalation_TEMP-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVMAINTE AS ['SV_Maint_Escalation_TEMP']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Maint_Escalation_TEMP'].USERID = ['Users Master'].USERID2 PROCNAME Process Name STR30 String 30 3 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['SV_Maint_Escalation_TEMP'].CUSTNMBR AS 'SV_Maint_Escalation_TEMP-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVMAINTE AS ['SV_Maint_Escalation_TEMP']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Maint_Escalation_TEMP'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR4 ADRSCODE Address Code STR15_Address_Code String 15 5 Contract_Number WS Contract Number STR10 String 10 6 WSCONTSQ WS Contract Number Sequence LI_Sequence_Number Long Integer 10 7 Corporate_Contract_Nbr Corporate Contract Number STR20_LBAU String 20 8 WSMSTRCONTSQ WS Master Contract Seq Number LI_Sequence_Number Long Integer 10 9 Contract_Expiration_Date Contract Experation Date DT Date 8 10 Escalation_Date Escalation Date DATE Date 6 11 Escalation_Year Escalation Year Year Integer 4 12 Escalation_Month Escalation Month Month Integer 0 13 Wennsoft_Affiliate Wennsoft Affiliate STR15_LBAU String 15 14 Wennsoft_Region Wennsoft Region STR15_LBAU String 15 15 Wennsoft_Branch Wennsoft Branch STR15_LBAU String 15 16 Bill_Freq Bill Freq DDL_Bill_Freq Integer 0 17 Next_Escalation_Date Next Escalation Date DATE Date 6 18 Escalation_Notifiy_Date Escalation Notification Date DATE Date 6 19 Escalation_Calc_Date Escalation Calculated Date DATE Date 6 20 Escalation_Calculated_By Escalation Calculated By STR15_User_ID String 15 21 Escalation_Approved Escalation Approved CB Boolean 0 22 SLPRSNID Salesperson ID STR15_Salesperson_ID String 15 Key to the RM Salesperson Master (RM00301).
Click to show/hide
SELECT
['SV_Maint_Escalation_TEMP'].SLPRSNID AS 'SV_Maint_Escalation_TEMP-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
SVMAINTE AS ['SV_Maint_Escalation_TEMP']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['SV_Maint_Escalation_TEMP'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID23 APPRVLDT Approval Date DATE Date 6 24 Escalation_Idx_ID_Equip Escalation Index ID Equip STR3_LBAU String 3 25 Escal_Idx_ID_Material Escalation Index ID Material STR3_LBAU String 3 26 Escalation_Idx_ID_Labor Escalation Index ID Labor STR3_LBAU String 3 27 Escalation_Index_ID_Subs Escalation Index ID Subs STR3_LBAU String 3 28 Escalation_Idx_ID_Other Escalation Index ID Other STR3_LBAU String 3 29 Escal_Fixed_Amt_Equip Escalation Fixed Amount Equip DLR14_RBS0_STR$ Currency 14 30 Escalation_Fixed_Amt_Mat Escalation Fixed Amount Mat DLR14_RBS0_STR$ Currency 14 31 Escal_Fixed_Amt_Labor Escalation Fixed Amount Labor DLR14_RBS0_STR$ Currency 14 32 Escal_Fixed_Amt_Subs Escalation Fixed Amount Subs DLR14_RBS0_STR$ Currency 14 33 Escal_Fixed_Amt_Other Escalation Fixed Amount Other DLR14_RBS0_STR$ Currency 14 34 Escalation_Pct_Equip Escalation Percentage Equip DLR5_%2 Currency 8 35 Escalation_Pct_Material Escalation Percentage Material DLR5_%2 Currency 8 36 Escalation_Pct_Labor Escalation Percentage Labor DLR5_%2 Currency 8 37 Escalation_Pct_Subs Escalation Percentage Subs DLR5_%2 Currency 8 38 Escalation_Pct_Other Escalation Percentage Other DLR5_%2 Currency 8 39 Proposed_Billing_Equip Proposed Billing Equip DLR14_RBS0_STR$ Currency 14 40 Prop_Billing_Material Proposed Billing Material DLR14_RBS0_STR$ Currency 14 41 Proposed_Billing_Labor Proposed Billing Labor DLR14_RBS0_STR$ Currency 14 42 Proposed_Billing_Subs Proposed Billing Subs DLR14_RBS0_STR$ Currency 14 43 Proposed_Billing_Other Proposed Billing Other DLR14_RBS0_STR$ Currency 14 44 Accepted_Billing_Equip Accepted Billing Equip DLR14_RBS0_STR$ Currency 14 45 Accepted_Billing_Materl Accepted Billing Material DLR14_RBS0_STR$ Currency 14 46 Accepted_Billing_Labor Accepted Billing Labor DLR14_RBS0_STR$ Currency 14 47 Accepted_Billing_Subs Accepted Billing Subs DLR14_RBS0_STR$ Currency 14 48 Accepted_Billing_Other Accepted Billing Other DLR14_RBS0_STR$ Currency 14 49 Proposed_Estimate_Equip Proposed Estimate Equip DLR14_RBS0_STR$ Currency 14 50 Proposed_Est_Material Proposed Estimate Material DLR14_RBS0_STR$ Currency 14 51 Proposed_Estimate_Labor Proposed Estimate Labor DLR14_RBS0_STR$ Currency 14 52 Proposed_Estimate_Subs Proposed Estimate Subs DLR14_RBS0_STR$ Currency 14 53 Proposed_Estimate_Other Proposed Estimate Other DLR14_RBS0_STR$ Currency 14 54 Proposed_Estimate_Hours Proposed Estimate Hours LI6_S2 Long Integer 6 55 Accepted_Estimate_Equip Accepted Estimate Equip DLR14_RBS0_STR$ Currency 14 56 Accepted_Est_Material Accepted Estimate Material DLR14_RBS0_STR$ Currency 14 57 Accepted_Estimate_Labor Accepted Estimate Labor DLR14_RBS0_STR$ Currency 14 58 Accepted_Estimate_Subs Accepted Estimate Subs DLR14_RBS0_STR$ Currency 14 59 Accepted_Estimate_Other Accepted Estimate Other DLR14_RBS0_STR$ Currency 14 60 Accepted_Estimate_Hours Accepted Estimate Hours LI6_S2 Long Integer 6 61 POSTED Posted True/False Boolean 0 62 POSTEDDT Posted Date DATE Date 6 63 SV_Language_ID SV Language ID INT2 Integer 2 64 MODIFDT Modified Date DT Date 8 65 Modified_Time Modified Time TM6 Time 6 66 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Maint_Escalation_TEMP'].MDFUSRID AS 'SV_Maint_Escalation_TEMP-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVMAINTE AS ['SV_Maint_Escalation_TEMP']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Maint_Escalation_TEMP'].MDFUSRID = ['Users Master'].USERID67 Service_User_Define_1 Service User Define 1 STR20 String 20 68 Service_User_Define_2 Service User Define 2 STR20 String 20 69 Service_User_Define_3 Service User Define 3 STR30 String 30 70 Service_User_Define_4 Service User Define 4 STR30 String 30 71 Service_User_Define_5 Service User Define 5 LI6_S2 Long Integer 6 72 Service_User_Define_6 Service User Define 6 LI6_S2 Long Integer 6 73 Service_User_Define_7 Service User Define 7 LI6_S2 Long Integer 6 74 Service_User_Define_8 Service User Define 8 LI6_S2 Long Integer 6 75 Service_User_Define_9 Service User Define 9 DT Date 8 76 Service_User_Define_10 Service User Define 10 DT Date 8 77 Service_User_Define_11 Service User Define 11 DT Date 8 78 Service_User_Define_12 Service User Define 12 DT Date 8 79 Service_User_Define_18 Service User Define 18 CB Boolean 0 80 Service_User_Define_19 Service User Define 19 CB Boolean 0 81 Service_User_Define_20 Service User Define 20 CB Boolean 0 82 Service_User_Define_21 Service User Define 21 CB Boolean 0 83 Service_User_Define_22 Service User Define 22 DLR14_RBS0_STR$ Currency 14 84 Service_User_Define_23 Service User Define 23 DLR14_RBS0_STR$ Currency 14 85 Service_User_Define_24 Service User Define 24 DLR14_RBS0_STR$ Currency 14 86 Service_User_Define_25 Service User Define 25 DLR14_RBS0_STR$ Currency 14 87 Error_Flag_Equip Error Flag Equip CB Boolean 0 88 Contract_Valid Contract Valid INT2 Integer 2 89 Error_Flag_Material Error Flag Material CB Boolean 0 90 Error_Flag_Labor Error Flag Labor CB Boolean 0 91 Error_Flag_Subs Error Flag Subs CB Boolean 0 92 Error_Flag_Other Error Flag Other CB Boolean 0 93 Contract_Open_Calls Contract Open Calls CB Boolean 0 94 Contract_Not_Billed Contract Not Billed CB Boolean 0 95 Contract_Not_Rev Contract Not Rev CB Boolean 0 96 Forecasted_Indicator Forecasted Indicator CB Boolean 0 97 Escalation_Indicator Escalation Indicator CB Boolean 0 98 HOLD Hold CB_Hold Boolean 0 99 Contract_Billed_Not_Reco Contract Billed Not Recognized CB Boolean 0 100 WSReserved_CB1 WSReserved CB1 CB Boolean 0 101 WSReserved_CB2 WSReserved CB2 CB Boolean 0 102 WSReserved_CB3 WSReserved CB3 CB Boolean 0 103 WSReserved_CB4 WSReserved CB4 CB Boolean 0 104 WSReserved_CB5 WSReserved CB5 CB Boolean 0 105 WSReserved_STR1 WSReserved STR1 STR10 String 10 106 WSReserved_STR2 WSReserved STR2 STR10 String 10