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_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Service_Call_ID 
Service Call ID STR17_LBAU String 17 2 USERID User ID STR15_User_ID String 15 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'].USERID3 Type_of_Problem Type of Problem STR30 String 30 4 Technician Technician STR10_LBAU String 10 5 Priority_of_Call Priority of Call STR1 String 1 6 Status_of_Call Status of Call STR10_LBAU String 10 7 LOCATNNM Location Name STR30 String 30 8 ADDRESS1 Address 1 STR60 String 60 9 CITY City STR35 String 35 10 STATE State STR30_State String 29 11 ZIP Zip STR10 String 10 12 Service_Description Service Description STR30_LBAU String 30 13 Purchase_Order Purchase Order STR15 String 15 14 WS_Time_1 WS Time 1 TM6 Time 6 15 Time_String_1_1 Time String 1[1] STR10 String 10 16 Time_String_1_2 Time String 1[2] STR10 String 10 17 Time_String_1_3 Time String 1[3] STR10 String 10 18 Time_String_1_4 Time String 1[4] STR10 String 10 19 Time_String_1_5 Time String 1[5] STR10 String 10 20 Time_String_1_6 Time String 1[6] STR10 String 10 21 Division Division DDL_Division Integer 0 22 Divisions Divisions STR15_LBAU String 15 23 Contract_Number WS Contract Number STR10 String 10 24 User_Define_1a User Define 1a STR30 String 30 25 User_Define_2a User Define 2a STR30 String 30 26 User_Define_3a User Define 3a STR30 String 30 27 User_Define_4a User Define 4a STR30 String 30 28 Date_of_Service_Call Date of Service Call DT Date 8 29 Type_Call_Short Type Call Short STR3_LBAU String 3 30 Type_of_Call Type of Call STR15 String 15 31 Call_Time Call Time LI6_S2 Long Integer 6 32 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 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'].CUSTNMBR33 CUSTNAME Customer Name STR64_Customer_Name String 64 34 Call_Invoice_Number Call Invoice Number STR17_LBAU String 17 35 ADRSCODE Address Code STR15_Address_Code String 15 36 Technician_Team Technician Team STR15_LBAU String 15 37 Service_Area Service Area STR15_LBAU String 15 38 Wennsoft_Affiliate Wennsoft Affiliate STR15_LBAU String 15 39 Wennsoft_Region Wennsoft Region STR15_LBAU String 15 40 Wennsoft_Branch Wennsoft Branch STR15_LBAU String 15 41 Completion_Date SV Completion Date DT Date 8 42 Color_Type Color Type DDL_Color Integer 0