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 TypeSQL DB LengthKeyable Length
1Task_Status SearchTask StatusSTR10_LBAUString1210
2Default_Task_Status SearchDefault Task StatusCB_DefaultBoolean20
3Task_Status_Description SearchTask Status DescriptionSTR30String3230
4CREATDDT SearchCreated DateDTDate48
5CRUSRID SearchCreated User IDSTR15_User_IDString1615
6MODIFDT SearchModified DateDTDate48
7Modified_Time SearchModified TimeTM6Time46
8MDFUSRID SearchModified User IDSTR15String1615
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 1STR20String2220
10USERDEF2 SearchUser Defined 2STR20String2220
11UDCB1 SearchUser Defined CB 11CBBoolean20
12UDCB2 SearchUser Defined CB 21CBBoolean20
13USRDAT01 SearchUser Defined Date 1DTDate48
14USRDAT02 SearchUser Defined Date 2DTDate48
15UserDD1 SearchUser Defined Dollar 11DLR14_RBS0_STR$Currency1014
16UserDD2 SearchUser Defined Dollar 21DLR14_RBS0_STR$Currency1014
17UDI1 SearchUser Defined Integer 11LI6_S2Long Integer46
18UDI2 SearchUser Defined Integer 21LI6_S2Long Integer46

Leave a Reply

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