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 TypeLength
1Service_Call_ID SearchService Call IDSTR17_LBAUString17
2USERID SearchUser IDSTR15_User_IDString15
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 ProblemSTR30String30
4Technician SearchTechnicianSTR10_LBAUString10
5Priority_of_Call SearchPriority of CallSTR1String1
6Status_of_Call SearchStatus of CallSTR10_LBAUString10
7LOCATNNM SearchLocation NameSTR30String30
8ADDRESS1 SearchAddress 1STR60String60
9CITY SearchCitySTR35String35
10STATE SearchStateSTR30_StateString29
11ZIP SearchZipSTR10String10
12Service_Description SearchService DescriptionSTR30_LBAUString30
13Purchase_Order SearchPurchase OrderSTR15String15
14WS_Time_1 SearchWS Time 1TM6Time6
15Time_String_1_1 SearchTime String 1[1]STR10String10
16Time_String_1_2 SearchTime String 1[2]STR10String10
17Time_String_1_3 SearchTime String 1[3]STR10String10
18Time_String_1_4 SearchTime String 1[4]STR10String10
19Time_String_1_5 SearchTime String 1[5]STR10String10
20Time_String_1_6 SearchTime String 1[6]STR10String10
21Division SearchDivisionDDL_DivisionInteger0
22Divisions SearchDivisionsSTR15_LBAUString15
23Contract_Number SearchWS Contract NumberSTR10String10
24User_Define_1a SearchUser Define 1aSTR30String30
25User_Define_2a SearchUser Define 2aSTR30String30
26User_Define_3a SearchUser Define 3aSTR30String30
27User_Define_4a SearchUser Define 4aSTR30String30
28Date_of_Service_Call SearchDate of Service CallDTDate8
29Type_Call_Short SearchType Call ShortSTR3_LBAUString3
30Type_of_Call SearchType of CallSTR15String15
31Call_Time SearchCall TimeLI6_S2Long Integer6
32CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_NameString64
34Call_Invoice_Number SearchCall Invoice NumberSTR17_LBAUString17
35ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
36Technician_Team SearchTechnician TeamSTR15_LBAUString15
37Service_Area SearchService AreaSTR15_LBAUString15
38Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
39Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
40Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
41Completion_Date SearchSV Completion DateDTDate8
42Color_Type SearchColor TypeDDL_ColorInteger0
azurecurveProductsWennSoft Products (131)3rd PartyDispatch Mapping Temporary (SVDISMAP)

Leave a Reply

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