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 TypeLength
1RTReferenceID SearchRTReferenceIDSTR40String40
2Void SearchVoidCBBoolean0
3Service_Date_1 SearchService Date 1DATEDate6
4Service_Time_1 SearchService Time 1TM6Time6
5Service_Call_ID SearchService Call IDSTR17_LBAUString17
6Equipment_ID SearchEquipment IDSTR30String30
7Technician_ID SearchTechnician IDSTR15_Employee_IDString15
8CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_CodeString15
10StoreNumber SearchStoreNumberSTR65_StoreNumberString10
11SystemType SearchSystemTypeSTR50String50
12AssetTagNumber SearchAssetTagNumberSTR50String50
13EPACertification SearchEPACertificationSTR50String50
14RefrigerantTransfer SearchRefrigerantTransferCBBoolean0
15RefrigerantSuppliedBy SearchRefrigerantSuppliedBySTR50String50
16RefrigerantTypeID SearchRefrigerantTypeIDLILong Integer0
17LeakFound SearchLeakFoundCBBoolean0
18LeakIDs_1 SearchLeakIDs[1]LILong Integer0
19LeakIDs_2 SearchLeakIDs[2]LILong Integer0
20LeakIDs_3 SearchLeakIDs[3]LILong Integer0
21LeakIDs_4 SearchLeakIDs[4]LILong Integer0
22LeakIDs_5 SearchLeakIDs[5]LILong Integer0
23LeakIDs_6 SearchLeakIDs[6]LILong Integer0
24LeakIDs_7 SearchLeakIDs[7]LILong Integer0
25LeakIDs_8 SearchLeakIDs[8]LILong Integer0
26LeakIDs_9 SearchLeakIDs[9]LILong Integer0
27LeakIDs_10 SearchLeakIDs[10]LILong Integer0
28CodeIDs_1 SearchCodeIDs[1]LILong Integer0
29CodeIDs_2 SearchCodeIDs[2]LILong Integer0
30CodeIDs_3 SearchCodeIDs[3]LILong Integer0
31CodeIDs_4 SearchCodeIDs[4]LILong Integer0
32CodeIDs_5 SearchCodeIDs[5]LILong Integer0
33CodeIDs_6 SearchCodeIDs[6]LILong Integer0
34CodeIDs_7 SearchCodeIDs[7]LILong Integer0
35CodeIDs_8 SearchCodeIDs[8]LILong Integer0
36CodeIDs_9 SearchCodeIDs[9]LILong Integer0
37CodeIDs_10 SearchCodeIDs[10]LILong Integer0
38CodeIDs_11 SearchCodeIDs[11]LILong Integer0
39CodeIDs_12 SearchCodeIDs[12]LILong Integer0
40CodeIDs_13 SearchCodeIDs[13]LILong Integer0
41CodeIDs_14 SearchCodeIDs[14]LILong Integer0
42CodeIDs_15 SearchCodeIDs[15]LILong Integer0
43LeakRepaired SearchLeakRepairedCBBoolean0
44RepairAttempted SearchRepairAttemptedCBBoolean0
45Init_Leak_Test_Date SearchInit Leak Test DateDateDate10
46Init_Leak_Test_Method SearchInit Leak Test MethodSTR30String30
47Followup_Leak_Test_Date SearchFollowup Leak Test DateDateDate10
48Followup_Leak_Test_Metho SearchFollowup Leak Test MethodSTR30String30
49OptimalCharge SearchOptimalChargeDLR14_TS2Currency14
50RefrigerantDisposed SearchRefrigerantDisposedDLR14_TS2Currency14
51RefrigerantRecovered SearchRefrigerantRecoveredDLR14_TS2Currency14
52RefrigerantRecharged SearchRefrigerantRechargedDLR14_TS2Currency14
53RefrigerantRecycled SearchRefrigerantRecycledDLR14_TS2Currency14
54RefrigerantAdded SearchRefrigerantAddedDLR14_TS2Currency14
55RefrigerantReleased SearchRefrigerantReleasedDLR14_TS2Currency14
56RefrigerantNetAdded SearchRefrigerantNetAddedDLR14_TS2Currency14
57ThirdPartyConfirmation SearchThirdPartyConfirmationSTR50String50
58CREATDDT SearchCreated DateDTDate8
59Created_Time SearchCreated TimeTimeTime0
60CRUSRID SearchCreated User IDSTR15_User_IDString15
61MODIFDT SearchModified DateDTDate8
62Modified_Time SearchModified TimeTM6Time6
63MDFUSRID SearchModified User IDSTR15String15
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 1STR30String30
65User_Define_2 SearchUser Define 2STR30String30
66User_Define_3 SearchUser Define 3STR30String30
67User_Define_4 SearchUser Define 4STR30String30
68User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer6
69User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer6
70User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer6
71User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer6
72USRDAT01 SearchUser Defined Date 1DTDate8
73USRDAT02 SearchUser Defined Date 2DTDate8
74USRDAT03 SearchUser Defined Date 3DTDate8
75User_Defined_Date2_4 SearchUser Defined Date 4DATEDate6
76User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency14
77User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency14
78User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency14
79User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency14
80User_Defined_CB_1 SearchUser Defined CB 1CBBoolean0
81User_Defined_CB_2 SearchUser Defined CB 2CBBoolean0
82User_Defined_CB_3 SearchUser Defined CB 3CBBoolean0
83User_Defined_CB_4 SearchUser Defined CB 4CBBoolean0
84CMMTTEXT SearchComment TextTX500Text500

Leave a Reply

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