Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV30180
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Refrigerant_Tracking
Physical Name: SV30180
Technical Name: SV_Refrigerant_TrackingSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 RTReferenceID 
RTReferenceID STR40 String 40 2 Void Void CB Boolean 0 3 Service_Date_1 Service Date 1 DATE Date 6 4 Service_Time_1 Service Time 1 TM6 Time 6 5 Service_Call_ID Service Call ID STR17_LBAU String 17 6 Equipment_ID Equipment ID STR30 String 30 7 Technician_ID Technician ID STR15_Employee_ID String 15 8 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['SV_Refrigerant_Tracking'].CUSTNMBR AS 'SV_Refrigerant_Tracking-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV30180 AS ['SV_Refrigerant_Tracking']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Refrigerant_Tracking'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR9 ADRSCODE Address Code STR15_Address_Code String 15 10 StoreNumber StoreNumber STR65_StoreNumber String 10 11 SystemType SystemType STR50 String 50 12 AssetTagNumber AssetTagNumber STR50 String 50 13 EPACertification EPACertification STR50 String 50 14 RefrigerantTransfer RefrigerantTransfer CB Boolean 0 15 RefrigerantSuppliedBy RefrigerantSuppliedBy STR50 String 50 16 RefrigerantTypeID RefrigerantTypeID LI Long Integer 0 17 LeakFound LeakFound CB Boolean 0 18 LeakIDs_1 LeakIDs[1] LI Long Integer 0 19 LeakIDs_2 LeakIDs[2] LI Long Integer 0 20 LeakIDs_3 LeakIDs[3] LI Long Integer 0 21 LeakIDs_4 LeakIDs[4] LI Long Integer 0 22 LeakIDs_5 LeakIDs[5] LI Long Integer 0 23 LeakIDs_6 LeakIDs[6] LI Long Integer 0 24 LeakIDs_7 LeakIDs[7] LI Long Integer 0 25 LeakIDs_8 LeakIDs[8] LI Long Integer 0 26 LeakIDs_9 LeakIDs[9] LI Long Integer 0 27 LeakIDs_10 LeakIDs[10] LI Long Integer 0 28 CodeIDs_1 CodeIDs[1] LI Long Integer 0 29 CodeIDs_2 CodeIDs[2] LI Long Integer 0 30 CodeIDs_3 CodeIDs[3] LI Long Integer 0 31 CodeIDs_4 CodeIDs[4] LI Long Integer 0 32 CodeIDs_5 CodeIDs[5] LI Long Integer 0 33 CodeIDs_6 CodeIDs[6] LI Long Integer 0 34 CodeIDs_7 CodeIDs[7] LI Long Integer 0 35 CodeIDs_8 CodeIDs[8] LI Long Integer 0 36 CodeIDs_9 CodeIDs[9] LI Long Integer 0 37 CodeIDs_10 CodeIDs[10] LI Long Integer 0 38 CodeIDs_11 CodeIDs[11] LI Long Integer 0 39 CodeIDs_12 CodeIDs[12] LI Long Integer 0 40 CodeIDs_13 CodeIDs[13] LI Long Integer 0 41 CodeIDs_14 CodeIDs[14] LI Long Integer 0 42 CodeIDs_15 CodeIDs[15] LI Long Integer 0 43 LeakRepaired LeakRepaired CB Boolean 0 44 RepairAttempted RepairAttempted CB Boolean 0 45 Init_Leak_Test_Date Init Leak Test Date Date Date 10 46 Init_Leak_Test_Method Init Leak Test Method STR30 String 30 47 Followup_Leak_Test_Date Followup Leak Test Date Date Date 10 48 Followup_Leak_Test_Metho Followup Leak Test Method STR30 String 30 49 OptimalCharge OptimalCharge DLR14_TS2 Currency 14 50 RefrigerantDisposed RefrigerantDisposed DLR14_TS2 Currency 14 51 RefrigerantRecovered RefrigerantRecovered DLR14_TS2 Currency 14 52 RefrigerantRecharged RefrigerantRecharged DLR14_TS2 Currency 14 53 RefrigerantRecycled RefrigerantRecycled DLR14_TS2 Currency 14 54 RefrigerantAdded RefrigerantAdded DLR14_TS2 Currency 14 55 RefrigerantReleased RefrigerantReleased DLR14_TS2 Currency 14 56 RefrigerantNetAdded RefrigerantNetAdded DLR14_TS2 Currency 14 57 ThirdPartyConfirmation ThirdPartyConfirmation STR50 String 50 58 CREATDDT Created Date DT Date 8 59 Created_Time Created Time Time Time 0 60 CRUSRID Created User ID STR15_User_ID String 15 61 MODIFDT Modified Date DT Date 8 62 Modified_Time Modified Time TM6 Time 6 63 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Refrigerant_Tracking'].MDFUSRID AS 'SV_Refrigerant_Tracking-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV30180 AS ['SV_Refrigerant_Tracking']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Refrigerant_Tracking'].MDFUSRID = ['Users Master'].USERID64 User_Define_1 User Define 1 STR30 String 30 65 User_Define_2 User Define 2 STR30 String 30 66 User_Define_3 User Define 3 STR30 String 30 67 User_Define_4 User Define 4 STR30 String 30 68 User_Def_Integer_1 User Defined Integer 1 LI6_S2 Long Integer 6 69 User_Def_Integer_2 User Defined Integer 2 LI6_S2 Long Integer 6 70 User_Defined_Integer_3 User Defined Integer 3 LI6_S2 Long Integer 6 71 User_Defined_Integer_4 User Defined Integer 4 LI6_S2 Long Integer 6 72 USRDAT01 User Defined Date 1 DT Date 8 73 USRDAT02 User Defined Date 2 DT Date 8 74 USRDAT03 User Defined Date 3 DT Date 8 75 User_Defined_Date2_4 User Defined Date 4 DATE Date 6 76 User_Defined_Dollar_1 User Defined Dollar 1 DLR14_RBS0_STR$ Currency 14 77 User_Defined_Dollar_2 User Defined Dollar 2 DLR14_RBS0_STR$ Currency 14 78 User_Defined_Dollar_3 User Defined Dollar 3 DLR14_RBS0_STR$ Currency 14 79 User_Defined_Dollar_4 User Defined Dollar 4 DLR14_RBS0_STR$ Currency 14 80 User_Defined_CB_1 User Defined CB 1 CB Boolean 0 81 User_Defined_CB_2 User Defined CB 2 CB Boolean 0 82 User_Defined_CB_3 User Defined CB 3 CB Boolean 0 83 User_Defined_CB_4 User Defined CB 4 CB Boolean 0 84 CMMTTEXT Comment Text TX500 Text 500