SV_Task_Status_SETP (SV00324)

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

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

Display Name: SV_Task_Status_SETP
Physical Name: SV00324
Technical Name: SV_Task_Status_SETP

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Task_Status SearchTask StatusSTR10_LBAUString10
2Default_Task_Status SearchDefault Task StatusCB_DefaultBoolean0
3Task_Status_Description SearchTask Status DescriptionSTR30String30
4CREATDDT SearchCreated DateDTDate8
5CRUSRID SearchCreated User IDSTR15_User_IDString15
6MODIFDT SearchModified DateDTDate8
7Modified_Time SearchModified TimeTM6Time6
8MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Task_Status_SETP'].MDFUSRID AS 'SV_Task_Status_SETP-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00324 AS ['SV_Task_Status_SETP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Task_Status_SETP'].MDFUSRID = ['Users Master'].USERID
9USERDEF1 SearchUser Defined 1STR20String20
10USERDEF2 SearchUser Defined 2STR20String20
11UDCB1 SearchUser Defined CB 11CBBoolean0
12UDCB2 SearchUser Defined CB 21CBBoolean0
13USRDAT01 SearchUser Defined Date 1DTDate8
14USRDAT02 SearchUser Defined Date 2DTDate8
15UserDD1 SearchUser Defined Dollar 11DLR14_RBS0_STR$Currency14
16UserDD2 SearchUser Defined Dollar 21DLR14_RBS0_STR$Currency14
17UDI1 SearchUser Defined Integer 11LI6_S2Long Integer6
18UDI2 SearchUser Defined Integer 21LI6_S2Long Integer6

Leave a Reply

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