SV_Refrigerant_Tracking (SV30180)

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_Tracking

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1RTReferenceID SearchRTReferenceIDSTR40String4240
2Void SearchVoidCBBoolean20
3Service_Date_1 SearchService Date 1DATEDate46
4Service_Time_1 SearchService Time 1TM6Time46
5Service_Call_ID SearchService Call IDSTR17_LBAUString1817
6Equipment_ID SearchEquipment IDSTR30String3230
7Technician_ID SearchTechnician IDSTR15_Employee_IDString1615
8CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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'].CUSTNMBR
9ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
10StoreNumber SearchStoreNumberSTR65_StoreNumberString6610
11SystemType SearchSystemTypeSTR50String5250
12AssetTagNumber SearchAssetTagNumberSTR50String5250
13EPACertification SearchEPACertificationSTR50String5250
14RefrigerantTransfer SearchRefrigerantTransferCBBoolean20
15RefrigerantSuppliedBy SearchRefrigerantSuppliedBySTR50String5250
16RefrigerantTypeID SearchRefrigerantTypeIDLILong Integer40
17LeakFound SearchLeakFoundCBBoolean20
18LeakIDs_1 SearchLeakIDs[1]LILong Integer40
19LeakIDs_2 SearchLeakIDs[2]LILong Integer40
20LeakIDs_3 SearchLeakIDs[3]LILong Integer40
21LeakIDs_4 SearchLeakIDs[4]LILong Integer40
22LeakIDs_5 SearchLeakIDs[5]LILong Integer40
23LeakIDs_6 SearchLeakIDs[6]LILong Integer40
24LeakIDs_7 SearchLeakIDs[7]LILong Integer40
25LeakIDs_8 SearchLeakIDs[8]LILong Integer40
26LeakIDs_9 SearchLeakIDs[9]LILong Integer40
27LeakIDs_10 SearchLeakIDs[10]LILong Integer40
28CodeIDs_1 SearchCodeIDs[1]LILong Integer40
29CodeIDs_2 SearchCodeIDs[2]LILong Integer40
30CodeIDs_3 SearchCodeIDs[3]LILong Integer40
31CodeIDs_4 SearchCodeIDs[4]LILong Integer40
32CodeIDs_5 SearchCodeIDs[5]LILong Integer40
33CodeIDs_6 SearchCodeIDs[6]LILong Integer40
34CodeIDs_7 SearchCodeIDs[7]LILong Integer40
35CodeIDs_8 SearchCodeIDs[8]LILong Integer40
36CodeIDs_9 SearchCodeIDs[9]LILong Integer40
37CodeIDs_10 SearchCodeIDs[10]LILong Integer40
38CodeIDs_11 SearchCodeIDs[11]LILong Integer40
39CodeIDs_12 SearchCodeIDs[12]LILong Integer40
40CodeIDs_13 SearchCodeIDs[13]LILong Integer40
41CodeIDs_14 SearchCodeIDs[14]LILong Integer40
42CodeIDs_15 SearchCodeIDs[15]LILong Integer40
43LeakRepaired SearchLeakRepairedCBBoolean20
44RepairAttempted SearchRepairAttemptedCBBoolean20
45Init_Leak_Test_Date SearchInit Leak Test DateDateDate410
46Init_Leak_Test_Method SearchInit Leak Test MethodSTR30String3230
47Followup_Leak_Test_Date SearchFollowup Leak Test DateDateDate410
48Followup_Leak_Test_Metho SearchFollowup Leak Test MethodSTR30String3230
49OptimalCharge SearchOptimalChargeDLR14_TS2Currency1014
50RefrigerantDisposed SearchRefrigerantDisposedDLR14_TS2Currency1014
51RefrigerantRecovered SearchRefrigerantRecoveredDLR14_TS2Currency1014
52RefrigerantRecharged SearchRefrigerantRechargedDLR14_TS2Currency1014
53RefrigerantRecycled SearchRefrigerantRecycledDLR14_TS2Currency1014
54RefrigerantAdded SearchRefrigerantAddedDLR14_TS2Currency1014
55RefrigerantReleased SearchRefrigerantReleasedDLR14_TS2Currency1014
56RefrigerantNetAdded SearchRefrigerantNetAddedDLR14_TS2Currency1014
57ThirdPartyConfirmation SearchThirdPartyConfirmationSTR50String5250
58CREATDDT SearchCreated DateDTDate48
59Created_Time SearchCreated TimeTimeTime40
60CRUSRID SearchCreated User IDSTR15_User_IDString1615
61MODIFDT SearchModified DateDTDate48
62Modified_Time SearchModified TimeTM6Time46
63MDFUSRID SearchModified User IDSTR15String1615
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'].USERID
64User_Define_1 SearchUser Define 1STR30String3230
65User_Define_2 SearchUser Define 2STR30String3230
66User_Define_3 SearchUser Define 3STR30String3230
67User_Define_4 SearchUser Define 4STR30String3230
68User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer46
69User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer46
70User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer46
71User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer46
72USRDAT01 SearchUser Defined Date 1DTDate48
73USRDAT02 SearchUser Defined Date 2DTDate48
74USRDAT03 SearchUser Defined Date 3DTDate48
75User_Defined_Date2_4 SearchUser Defined Date 4DATEDate46
76User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency1014
77User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency1014
78User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency1014
79User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency1014
80User_Defined_CB_1 SearchUser Defined CB 1CBBoolean20
81User_Defined_CB_2 SearchUser Defined CB 2CBBoolean20
82User_Defined_CB_3 SearchUser Defined CB 3CBBoolean20
83User_Defined_CB_4 SearchUser Defined CB 4CBBoolean20
84CMMTTEXT SearchComment TextTX500Text2500

Leave a Reply

Your email address will not be published. Required fields are marked *