Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV00800
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Labor_Loading_Monthly_TEMP_SQL
Physical Name: SV00800
Technical Name: SV_Labor_Loading_Monthly_TEMP_SQLSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR 
Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['SV_Labor_Loading_Monthly_TEMP_SQL'].CUSTNMBR AS 'SV_Labor_Loading_Monthly_TEMP_SQL-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV00800 AS ['SV_Labor_Loading_Monthly_TEMP_SQL']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Labor_Loading_Monthly_TEMP_SQL'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 ADRSCODE Address Code STR15_Address_Code String 15 3 LOCATNNM Location Name STR30 String 30 4 Contract_Number WS Contract Number STR10 String 10 5 WSCONTSQ WS Contract Number Sequence LI_Sequence_Number Long Integer 10 6 Service_Call_ID Service Call ID STR17_LBAU String 17 7 Status_of_Call Status of Call STR10_LBAU String 10 8 Completion_Date SV Completion Date DT Date 8 9 TRXHRUNT TRX Hours/Units LI6_S2 Long Integer 6 10 Primary_HoursUnits Primary_Hours/Units LI6_S2 Long Integer 6 11 SLPRSNID Salesperson ID STR15_Salesperson_ID String 15 Key to the RM Salesperson Master (RM00301).
Click to show/hide
SELECT
['SV_Labor_Loading_Monthly_TEMP_SQL'].SLPRSNID AS 'SV_Labor_Loading_Monthly_TEMP_SQL-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
SV00800 AS ['SV_Labor_Loading_Monthly_TEMP_SQL']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['SV_Labor_Loading_Monthly_TEMP_SQL'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID12 Technician Technician STR10_LBAU String 10 13 Technician_Team Technician Team STR15_LBAU String 15 14 Technician_Long_Name Technician Long Name STR30 String 30 15 Current_Month Current_Month INT2 Integer 2 16 Total_Planned_Hours Total Planned Hours LI6_S2 Long Integer 6 17 Total_Non_Planned_Hours Total Non Planned Hours LI6_S2 Long Integer 6 18 Total_Planned_MCC_Hours Total Planned MCC Hours LI6_S2 Long Integer 6 19 TotalPlannedBurdenHrs Total Planned Burden Hours LI6_S2 Long Integer 6 20 TotalPlannedBillableHrs Total Planned Billable Hours LI6_S2 Long Integer 6 21 Start_Month_Number Start Month Number INT Integer 0 22 End_Month_Number End Month Number INT Integer 0 23 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Labor_Loading_Monthly_TEMP_SQL'].USERID AS 'SV_Labor_Loading_Monthly_TEMP_SQL-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV00800 AS ['SV_Labor_Loading_Monthly_TEMP_SQL']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Labor_Loading_Monthly_TEMP_SQL'].USERID = ['Users Master'].USERID24 CMPNYNAM Company Name STR64_Company_Name String 64 25 Salesperson_ID_Parm Salesperson_ID_Parm STR15_Salesperson_ID String 15 26 Technician_Team_Parm Technician_Team_Parm STR15_LBAU String 15 27 Technician_ID_Parm Technician_ID_Parm STR15_Employee_ID String 15 28 Wennsoft_Affiliate Wennsoft Affiliate STR15_LBAU String 15 29 Wennsoft_Region Wennsoft Region STR15_LBAU String 15 30 Wennsoft_Branch Wennsoft Branch STR15_LBAU String 15 31 Affiliate_Parm Affiliate_Parm STR15_LBAU String 15 32 Region_Parm Region_Parm STR15_LBAU String 15 33 Branch_Parm Branch_Parm STR15_LBAU String 15 34 intComplete intComplete INT2 Integer 2 35 intOpen intOpen INT2 Integer 2