SV_Location_MSTR (SV00200)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV00200

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: SV_Location_MSTR
Physical Name: SV00200
Technical Name: SV_Location_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SV_Location_MSTR'].CUSTNMBR AS 'SV_Location_MSTR-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SV00200 AS ['SV_Location_MSTR']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SV_Location_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
3Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
4Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
5Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
6USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Location_MSTR'].USERID AS 'SV_Location_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00200 AS ['SV_Location_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Location_MSTR'].USERID = ['Users Master'].USERID
7Technician_ID SearchTechnician IDSTR15_Employee_IDString15
8Technician_Team SearchTechnician TeamSTR15_LBAUString15
9CUSTNAME SearchCustomer NameSTR64_Customer_NameString64
10PHONE1 SearchPhone 1Phone_NumberString14
11Map_Grid SearchMap GridSTR15String15
12FAX SearchFaxSTR14_FAXString14
13Service_Area SearchService AreaSTR15_LBAUString15
14LOCATNNM SearchLocation NameSTR30String30
15STATE SearchStateSTR30_StateString29
16ZIP SearchZipSTR10String10
17PHONE2 SearchPhone 2Phone_NumberString14
18ADDRESS1 SearchAddress 1STR60String60
19CITY SearchCitySTR35String35
20Labor_Group_Name SearchLabor Group NameSTR15_RM_Customer_NumberString15
21Pricing_Matrix_Name SearchPricing Matrix NameSTR15_RM_Customer_NumberString15
22SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['SV_Location_MSTR'].SLPRSNID AS 'SV_Location_MSTR-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SV00200 AS ['SV_Location_MSTR']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['SV_Location_MSTR'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
23Technician SearchTechnicianSTR10_LBAUString10
24Technician_2 SearchTechnician 2STR10_LBAUString10
25Technician_ID2 SearchTechnician ID2STR15_Employee_IDString15
26CNTCPRSN SearchContact PersonSTR60String60
27Contact_Name SearchContact NameSTR15String15
28Hold_Transaction_ID SearchHold Transaction IDLI_7LBAULong Integer7
29Safety_Flag SearchSafety FlagCBBoolean0
30Blanket_PO_CB SearchBlanket PO CheckboxCBBoolean0
31Blanket_PO_Number SearchBlanket PO NumberSTR17String17
32Orig_Blanket_PO_Amt SearchOriginal Blanket PO AmountDLR19_RBS0_STR$Currency19
33Blanket_PO_Amt_Spent SearchBlanket PO Amount SpentDLR19_RBS0_STR$Currency19
34Blanket_PO_Amt__Remainin SearchBlanket PO Amount RemainingDLR19_RBS0_STR$Currency19
35Blanket_PO_Exp_Date SearchBlanket PO Expiration DateDATEDate6
36User_Define_1a SearchUser Define 1aSTR30String30
37User_Define_2a SearchUser Define 2aSTR30String30
38User_Define_3a SearchUser Define 3aSTR30String30
39User_Define_4a SearchUser Define 4aSTR30String30
40User_Define_5a SearchUser Define 5aSTR30String30
41User_Define_6a SearchUser Define 6aSTR30String30
42PO_Required SearchPO RequiredCBBoolean0
43Out_of_Service_Flag SearchOut of Service FlagCB_Out_Of_Service_FlagBoolean0
44Alarm_Flag SearchAlarm FlagCBBoolean0
45Supervisors_ID SearchSupervisors IDSTR15_Employee_IDString15
46Supervisors_Hold_Flag SearchSupervisors Hold FlagCBBoolean0
47CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString15
48Divisions SearchDivisionsSTR15_LBAUString15
49Travel_Rate_Name SearchTravel Rate NameSTR15_RM_Customer_NumberString15
50SVSLARES SearchSV Service Level IDSTR10_LBAUString10
51Bill_Customer_Number SearchBill Customer NumberSTR15_RM_Customer_NumberString15
52Bill_Address_Code SearchBill Address CodeSTR15_Address_CodeString15
53Longitude SearchLongitudeDLR5_RBS2_UCurrency5
54Latitude SearchLatitudeDLR5_RBS2_UCurrency5
55Priority_of_Call SearchPriority of CallSTR1String1
56Service_User_Define_1 SearchService User Define 1STR20String20
57Service_User_Define_2 SearchService User Define 2STR20String20
58Service_User_Define_3 SearchService User Define 3STR30String30
59Service_User_Define_4 SearchService User Define 4STR30String30
60Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer6
61Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer6
62Service_User_Define_7 SearchService User Define 7LI6_S2Long Integer6
63Service_User_Define_8 SearchService User Define 8LI6_S2Long Integer6
64Service_User_Define_9 SearchService User Define 9DTDate8
65Service_User_Define_10 SearchService User Define 10DTDate8
66Service_User_Define_11 SearchService User Define 11DTDate8
67Service_User_Define_12 SearchService User Define 12DTDate8
68Service_User_Define_18 SearchService User Define 18CBBoolean0
69Service_User_Define_19 SearchService User Define 19CBBoolean0
70Service_User_Define_20 SearchService User Define 20CBBoolean0
71Service_User_Define_21 SearchService User Define 21CBBoolean0
72Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency14
73Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency14
74Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency14
75Service_User_Define_25 SearchService User Define 25DLR14_RBS0_STR$Currency14
76MODIFDT SearchModified DateDTDate8
77Modified_Time SearchModified TimeTM6Time6
78MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Location_MSTR'].MDFUSRID AS 'SV_Location_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00200 AS ['SV_Location_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Location_MSTR'].MDFUSRID = ['Users Master'].USERID
79Time_Zone SearchTime ZoneSTR3String3
80Time_Zone_Tag SearchTime Zone TagSTR4String4
81SV_Language_ID SearchSV Language IDINT2Integer2
82Base_Currency_ID SearchBase Currency IDSTR15_Currency_IDString15
83Billing_Currency_ID SearchBilling Currency IDSTR15_Currency_IDString15
84Local_Currency_ID SearchLocal Currency IDSTR15_Currency_IDString15
85Civic1Alpha SearchCivic1AlphaSTR5String5
86Civic1Num SearchCivic1NumINT5Integer4
87Civic1Dir SearchCivic1DirSTR5String5
88Civic2Alpha SearchCivic2AlphaSTR5String5
89Civic2Num SearchCivic2NumINT5Integer4
90Civic2Dir SearchCivic2DirSTR5String5
91StreetName SearchStreetNameSTR30String30
92StreetType SearchStreetTypeSTR6String6
93PostDir SearchPostDirSTR5String5
94SecAddType1 SearchSecAddType1STR12String12
95SecAddNum1 SearchSecAddNum1INT5Integer4
96SecAddAlpha1 SearchSecAddAlpha1STR4String4
97SecAddType2 SearchSecAddType2STR12String12
98SecAddNum2 SearchSecAddNum2INT5Integer4
99SecAddAlpha2 SearchSecAddAlpha2STR4String4
100USETAXSCHID SearchUse Tax Schedule IDSTR15_Tax_Schedule_IDString15
101RATECLSS SearchRate ClassSTR15String15
102STATECD SearchState CodeSTR2_State_CodeString2
103SUTASTAT SearchSuta StateSTR2_State_CodeString2
104LOCALTAX SearchLocal TaxSTR6_Payroll_CodeString6
105WS_PPVWriteOffPercent SearchWS_PPVWriteOffPercentINT5_RBS2_U%Integer5
106WS_PPVWriteOffAmt SearchWS_PPVWriteOffAmtDLR14_RBS0_UTR$Currency14
107WS_POHdrOrPOLineRG SearchWS_POHdrOrPOLineRGGBInteger0
108WSReserved_CB1 SearchWSReserved CB1CBBoolean0
109WSReserved_CB2 SearchWSReserved CB2CBBoolean0
110WSReserved_CB3 SearchWSReserved CB3CBBoolean0
111WSReserved_CB4 SearchWSReserved CB4CBBoolean0
112WSReserved_CB5 SearchWSReserved CB5CBBoolean0
113WSReserved_CB6 SearchWSReserved CB6CBBoolean0
114WSReserved_CB7 SearchWSReserved CB7CBBoolean0
115WSReserved_CB8 SearchWSReserved CB8CBBoolean0
116WSReserved_CB9 SearchWSReserved CB9CBBoolean0
117WSReserved_CB10 SearchWSReserved CB10CBBoolean0
118WSReserved_STR1 SearchWSReserved STR1STR10String10
119WSReserved_STR2 SearchWSReserved STR2STR10String10

Leave a Reply

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