WS_MT_ADDITIONAL_WORK (WSMTADWK)

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

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

Display Name: WS_MT_ADDITIONAL_WORK
Physical Name: WSMTADWK
Technical Name: WS_MT_ADDITIONAL_WORK

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Technician SearchTechnicianSTR10_LBAUString1210
2Service_Call_ID SearchService Call IDSTR17_LBAUString1817
3Appointment SearchAppointmentSTR25String2625
4WS_Created_Date SearchWS Created DateDTDate48
5WS_Created_Time SearchWS Created TimeTM6Time46
6Estimate_Labor_Hours SearchEstimate Labor HoursDLR14_TSCurrency1014
7Estimate_Material SearchEstimate MaterialDLR14_RBS0_STR$Currency1014
8Estimate_Equipment SearchEstimate EquipmentDLR14_RBS0_STR$Currency1014
9Estimate_Subs SearchEstimate SubsDLR14_RBS0_STR$Currency1014
10Estimate_Other SearchEstimate OtherDLR14_RBS0_STR$Currency1014
11CNTCPRSN SearchContact PersonSTR60String6260
12PHONE1 SearchPhone 1Phone_NumberString2214
13Follow_Up_Note SearchFollow Up NoteSTR255String256255
14MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['WS_MT_ADDITIONAL_WORK'].MDFUSRID AS 'WS_MT_ADDITIONAL_WORK-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       WSMTADWK AS ['WS_MT_ADDITIONAL_WORK']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['WS_MT_ADDITIONAL_WORK'].MDFUSRID = ['Users Master'].USERID
15MODIFDT SearchModified DateDTDate48
16UPDATED SearchUpdatedBooleanBoolean20
17Notes SearchNotesTX32000Text232000

Leave a Reply

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