Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVINTER4
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: ServiceTechWarehouse
Physical Name: SVINTER4
Technical Name: ServiceTechWarehouseSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Technician 
Technician STR10_LBAU String 10 2 Wennsoft_Affiliate Wennsoft Affiliate STR15_LBAU String 15 3 Wennsoft_Region Wennsoft Region STR15_LBAU String 15 4 Wennsoft_Branch Wennsoft Branch STR15_LBAU String 15 5 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ServiceTechWarehouse'].USERID AS 'ServiceTechWarehouse-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVINTER4 AS ['ServiceTechWarehouse']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ServiceTechWarehouse'].USERID = ['Users Master'].USERID6 Technician_ID Technician ID STR15_Employee_ID String 15 7 Technician_Team Technician Team STR15_LBAU String 15 8 Technician_Long_Name Technician Long Name STR30 String 30 9 EMPLOYID Employee ID STR15_Employee_ID String 15 10 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['ServiceTechWarehouse'].VENDORID AS 'ServiceTechWarehouse-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
SVINTER4 AS ['ServiceTechWarehouse']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['ServiceTechWarehouse'].VENDORID = ['PM Vendor Master File'].VENDORID11 Vendor_Switch Vendor Switch CB Boolean 0 12 RDC_Access_Number RDC Access Number STR14_Phone String 14 13 Pager_Number Pager Number STR14_Phone String 14 14 Primary_Skill_Level Primary Skill Level STR15_LBAU String 15 15 Employee_Vehicle Employee Vehicle STR15_LBAU String 15 16 MODIFDT Modified Date DT Date 8 17 Modified_Time Modified Time TM6 Time 6 18 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ServiceTechWarehouse'].MDFUSRID AS 'ServiceTechWarehouse-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVINTER4 AS ['ServiceTechWarehouse']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ServiceTechWarehouse'].MDFUSRID = ['Users Master'].USERID19 Time_Zone Time Zone STR3 String 3 20 SV_Language_ID SV Language ID INT2 Integer 2 21 WSReserved_CB1 WSReserved CB1 CB Boolean 0 22 WSReserved_CB2 WSReserved CB2 CB Boolean 0 23 WSReserved_CB3 WSReserved CB3 CB Boolean 0 24 WSReserved_CB4 WSReserved CB4 CB Boolean 0 25 WSReserved_CB5 WSReserved CB5 CB Boolean 0 26 WSReserved_CB6 WSReserved CB6 CB Boolean 0 27 WSReserved_CB7 WSReserved CB7 CB Boolean 0 28 WSReserved_CB8 WSReserved CB8 CB Boolean 0 29 WSReserved_CB9 WSReserved CB9 CB Boolean 0 30 WSReserved_CB10 WSReserved CB10 CB Boolean 0 31 WSReserved_STR1 WSReserved STR1 STR10 String 10 32 WSReserved_STR2 WSReserved STR2 STR10 String 10