Dispatch Mapping Temporary (SVDISMAP)

azurecurveProductsWennSoft Products (131)3rd PartyDispatch Mapping Temporary (SVDISMAP)

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

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

Display Name: Dispatch Mapping Temporary
Physical Name: SVDISMAP
Technical Name: SV_Dispatch_Mapping_TEMP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Service_Call_ID SearchService Call IDSTR17_LBAUString1817
2USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Dispatch Mapping Temporary'].USERID AS 'Dispatch Mapping Temporary-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVDISMAP AS ['Dispatch Mapping Temporary']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Dispatch Mapping Temporary'].USERID = ['Users Master'].USERID
3Type_of_Problem SearchType of ProblemSTR30String3230
4Technician SearchTechnicianSTR10_LBAUString1210
5Priority_of_Call SearchPriority of CallSTR1String21
6Status_of_Call SearchStatus of CallSTR10_LBAUString1210
7LOCATNNM SearchLocation NameSTR30String3230
8ADDRESS1 SearchAddress 1STR60String6260
9CITY SearchCitySTR35String3635
10STATE SearchStateSTR30_StateString3029
11ZIP SearchZipSTR10String1210
12Service_Description SearchService DescriptionSTR30_LBAUString3230
13Purchase_Order SearchPurchase OrderSTR15String1615
14WS_Time_1 SearchWS Time 1TM6Time46
15Time_String_1_1 SearchTime String 1[1]STR10String1210
16Time_String_1_2 SearchTime String 1[2]STR10String1210
17Time_String_1_3 SearchTime String 1[3]STR10String1210
18Time_String_1_4 SearchTime String 1[4]STR10String1210
19Time_String_1_5 SearchTime String 1[5]STR10String1210
20Time_String_1_6 SearchTime String 1[6]STR10String1210
21Division SearchDivisionDDL_DivisionInteger20
22Divisions SearchDivisionsSTR15_LBAUString1615
23Contract_Number SearchWS Contract NumberSTR10String1210
24User_Define_1a SearchUser Define 1aSTR30String3230
25User_Define_2a SearchUser Define 2aSTR30String3230
26User_Define_3a SearchUser Define 3aSTR30String3230
27User_Define_4a SearchUser Define 4aSTR30String3230
28Date_of_Service_Call SearchDate of Service CallDTDate48
29Type_Call_Short SearchType Call ShortSTR3_LBAUString43
30Type_of_Call SearchType of CallSTR15String1615
31Call_Time SearchCall TimeLI6_S2Long Integer46
32CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Dispatch Mapping Temporary'].CUSTNMBR AS 'Dispatch Mapping Temporary-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVDISMAP AS ['Dispatch Mapping Temporary']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Dispatch Mapping Temporary'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
33CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
34Call_Invoice_Number SearchCall Invoice NumberSTR17_LBAUString1817
35ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
36Technician_Team SearchTechnician TeamSTR15_LBAUString1615
37Service_Area SearchService AreaSTR15_LBAUString1615
38Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
39Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
40Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
41Completion_Date SearchSV Completion DateDTDate48
42Color_Type SearchColor TypeDDL_ColorInteger20
azurecurveProductsWennSoft Products (131)3rd PartyDispatch Mapping Temporary (SVDISMAP)

Leave a Reply

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