SV_Location_MSTR Archive (SVA0200)

azurecurveProductsWennSoft Products (131)3rd PartySV_Location_MSTR Archive (SVA0200)

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

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

Display Name: SV_Location_MSTR Archive
Physical Name: SVA0200
Technical Name: SV_Location_MSTR_Archive

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SV_Location_MSTR Archive'].CUSTNMBR AS 'SV_Location_MSTR Archive-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVA0200 AS ['SV_Location_MSTR Archive']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SV_Location_MSTR Archive'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
3Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
4Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
5Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
6USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Location_MSTR Archive'].USERID AS 'SV_Location_MSTR Archive-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVA0200 AS ['SV_Location_MSTR Archive']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Location_MSTR Archive'].USERID = ['Users Master'].USERID
7Technician_ID SearchTechnician IDSTR15_Employee_IDString1615
8Technician_Team SearchTechnician TeamSTR15_LBAUString1615
9CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
10PHONE1 SearchPhone 1Phone_NumberString2214
11Map_Grid SearchMap GridSTR15String1615
12FAX SearchFaxSTR14_FAXString2214
13Service_Area SearchService AreaSTR15_LBAUString1615
14LOCATNNM SearchLocation NameSTR30String3230
15STATE SearchStateSTR30_StateString3029
16ZIP SearchZipSTR10String1210
17PHONE2 SearchPhone 2Phone_NumberString2214
18ADDRESS1 SearchAddress 1STR60String6260
19CITY SearchCitySTR35String3635
20Labor_Group_Name SearchLabor Group NameSTR15_RM_Customer_NumberString1615
21Pricing_Matrix_Name SearchPricing Matrix NameSTR15_RM_Customer_NumberString1615
22SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['SV_Location_MSTR Archive'].SLPRSNID AS 'SV_Location_MSTR Archive-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SVA0200 AS ['SV_Location_MSTR Archive']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['SV_Location_MSTR Archive'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
23Technician SearchTechnicianSTR10_LBAUString1210
24Technician_2 SearchTechnician 2STR10_LBAUString1210
25Technician_ID2 SearchTechnician ID2STR15_Employee_IDString1615
26CNTCPRSN SearchContact PersonSTR60String6260
27Contact_Name SearchContact NameSTR15String1615
28Hold_Transaction_ID SearchHold Transaction IDLI_7LBAULong Integer47
29Safety_Flag SearchSafety FlagCBBoolean20
30Blanket_PO_CB SearchBlanket PO CheckboxCBBoolean20
31Blanket_PO_Number SearchBlanket PO NumberSTR17String1817
32Orig_Blanket_PO_Amt SearchOriginal Blanket PO AmountDLR19_RBS0_STR$Currency1019
33Blanket_PO_Amt_Spent SearchBlanket PO Amount SpentDLR19_RBS0_STR$Currency1019
34Blanket_PO_Amt__Remainin SearchBlanket PO Amount RemainingDLR19_RBS0_STR$Currency1019
35Blanket_PO_Exp_Date SearchBlanket PO Expiration DateDATEDate46
36User_Define_1a SearchUser Define 1aSTR30String3230
37User_Define_2a SearchUser Define 2aSTR30String3230
38User_Define_3a SearchUser Define 3aSTR30String3230
39User_Define_4a SearchUser Define 4aSTR30String3230
40User_Define_5a SearchUser Define 5aSTR30String3230
41User_Define_6a SearchUser Define 6aSTR30String3230
42PO_Required SearchPO RequiredCBBoolean20
43Out_of_Service_Flag SearchOut of Service FlagCB_Out_Of_Service_FlagBoolean20
44Alarm_Flag SearchAlarm FlagCBBoolean20
45Supervisors_ID SearchSupervisors IDSTR15_Employee_IDString1615
46Supervisors_Hold_Flag SearchSupervisors Hold FlagCBBoolean20
47CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString1615
48Divisions SearchDivisionsSTR15_LBAUString1615
49Travel_Rate_Name SearchTravel Rate NameSTR15_RM_Customer_NumberString1615
50SVSLARES SearchSV Service Level IDSTR10_LBAUString1210
51Bill_Customer_Number SearchBill Customer NumberSTR15_RM_Customer_NumberString1615
52Bill_Address_Code SearchBill Address CodeSTR15_Address_CodeString1615
53Longitude SearchLongitudeDLR5_RBS2_UCurrency105
54Latitude SearchLatitudeDLR5_RBS2_UCurrency105
55Priority_of_Call SearchPriority of CallSTR1String21
56Service_User_Define_1 SearchService User Define 1STR20String2220
57Service_User_Define_2 SearchService User Define 2STR20String2220
58Service_User_Define_3 SearchService User Define 3STR30String3230
59Service_User_Define_4 SearchService User Define 4STR30String3230
60Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer46
61Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer46
62Service_User_Define_7 SearchService User Define 7LI6_S2Long Integer46
63Service_User_Define_8 SearchService User Define 8LI6_S2Long Integer46
64Service_User_Define_9 SearchService User Define 9DTDate48
65Service_User_Define_10 SearchService User Define 10DTDate48
66Service_User_Define_11 SearchService User Define 11DTDate48
67Service_User_Define_12 SearchService User Define 12DTDate48
68Service_User_Define_18 SearchService User Define 18CBBoolean20
69Service_User_Define_19 SearchService User Define 19CBBoolean20
70Service_User_Define_20 SearchService User Define 20CBBoolean20
71Service_User_Define_21 SearchService User Define 21CBBoolean20
72Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency1014
73Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency1014
74Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency1014
75Service_User_Define_25 SearchService User Define 25DLR14_RBS0_STR$Currency1014
76MODIFDT SearchModified DateDTDate48
77Modified_Time SearchModified TimeTM6Time46
78MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Location_MSTR Archive'].MDFUSRID AS 'SV_Location_MSTR Archive-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVA0200 AS ['SV_Location_MSTR Archive']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Location_MSTR Archive'].MDFUSRID = ['Users Master'].USERID
79Time_Zone SearchTime ZoneSTR3String43
80Time_Zone_Tag SearchTime Zone TagSTR4String64
81SV_Language_ID SearchSV Language IDINT2Integer22
82Base_Currency_ID SearchBase Currency IDSTR15_Currency_IDString1615
83Billing_Currency_ID SearchBilling Currency IDSTR15_Currency_IDString1615
84Local_Currency_ID SearchLocal Currency IDSTR15_Currency_IDString1615
85Civic1Alpha SearchCivic1AlphaSTR5String65
86Civic1Num SearchCivic1NumINT5Integer24
87Civic1Dir SearchCivic1DirSTR5String65
88Civic2Alpha SearchCivic2AlphaSTR5String65
89Civic2Num SearchCivic2NumINT5Integer24
90Civic2Dir SearchCivic2DirSTR5String65
91StreetName SearchStreetNameSTR30String3230
92StreetType SearchStreetTypeSTR6String86
93PostDir SearchPostDirSTR5String65
94SecAddType1 SearchSecAddType1STR12String1412
95SecAddNum1 SearchSecAddNum1INT5Integer24
96SecAddAlpha1 SearchSecAddAlpha1STR4String64
97SecAddType2 SearchSecAddType2STR12String1412
98SecAddNum2 SearchSecAddNum2INT5Integer24
99SecAddAlpha2 SearchSecAddAlpha2STR4String64
100USETAXSCHID SearchUse Tax Schedule IDSTR15_Tax_Schedule_IDString1615
101RATECLSS SearchRate ClassSTR15String1615
102STATECD SearchState CodeSTR2_State_CodeString42
103SUTASTAT SearchSuta StateSTR2_State_CodeString42
104LOCALTAX SearchLocal TaxSTR6_Payroll_CodeString86
105WS_PPVWriteOffPercent SearchWS_PPVWriteOffPercentINT5_RBS2_U%Integer25
106WS_PPVWriteOffAmt SearchWS_PPVWriteOffAmtDLR14_RBS0_UTR$Currency1014
107WS_POHdrOrPOLineRG SearchWS_POHdrOrPOLineRGGBInteger20
108WSReserved_CB1 SearchWSReserved CB1CBBoolean20
109WSReserved_CB2 SearchWSReserved CB2CBBoolean20
110WSReserved_CB3 SearchWSReserved CB3CBBoolean20
111WSReserved_CB4 SearchWSReserved CB4CBBoolean20
112WSReserved_CB5 SearchWSReserved CB5CBBoolean20
113WSReserved_CB6 SearchWSReserved CB6CBBoolean20
114WSReserved_CB7 SearchWSReserved CB7CBBoolean20
115WSReserved_CB8 SearchWSReserved CB8CBBoolean20
116WSReserved_CB9 SearchWSReserved CB9CBBoolean20
117WSReserved_CB10 SearchWSReserved CB10CBBoolean20
118WSReserved_STR1 SearchWSReserved STR1STR10String1210
119WSReserved_STR2 SearchWSReserved STR2STR10String1210
azurecurveProductsWennSoft Products (131)3rd PartySV_Location_MSTR Archive (SVA0200)

Leave a Reply

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