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 TypeLength
1Technician SearchTechnicianSTR10_LBAUString10
2Service_Call_ID SearchService Call IDSTR17_LBAUString17
3Appointment SearchAppointmentSTR25String25
4WS_Created_Date SearchWS Created DateDTDate8
5WS_Created_Time SearchWS Created TimeTM6Time6
6Estimate_Labor_Hours SearchEstimate Labor HoursDLR14_TSCurrency14
7Estimate_Material SearchEstimate MaterialDLR14_RBS0_STR$Currency14
8Estimate_Equipment SearchEstimate EquipmentDLR14_RBS0_STR$Currency14
9Estimate_Subs SearchEstimate SubsDLR14_RBS0_STR$Currency14
10Estimate_Other SearchEstimate OtherDLR14_RBS0_STR$Currency14
11CNTCPRSN SearchContact PersonSTR60String60
12PHONE1 SearchPhone 1Phone_NumberString14
13Follow_Up_Note SearchFollow Up NoteSTR255String255
14MDFUSRID SearchModified User IDSTR15String15
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 DateDTDate8
16UPDATED SearchUpdatedBooleanBoolean0
17Notes SearchNotesTX32000Text32000

Leave a Reply

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