Security Tasks Master (SY09000)

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

Product: Microsoft Dynamics GP (0)
Series: System

Display Name: Security Tasks Master
Physical Name: SY09000
Technical Name: sySecurityMSTRTask

Group Display Name: Security Setup
Group Technical Name: Security Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SECURITYTASKID SearchSecurity Task IDStringSecurityID25
2SECURITYTASKNAME SearchSecurity Task NameStringSTR5050
3SECURITYTASKDESC SearchSecurity Task DescriptionStringSTR255255
4SECURITYTASKCATEGORY SearchSecurity Task CategoryIntegerSecurity Task Category0
5DEFSECTASK SearchDefault Security TaskBooleanCB0
6CRUSRID SearchCreated User IDStringSTR15_User_ID15
7CREATDDT SearchCreated DateDateDT8
8MDFUSRID SearchModified User IDStringSTR1515
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Security Tasks Master'].MDFUSRID AS 'Security Tasks Master-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SY09000 AS ['Security Tasks Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Security Tasks Master'].MDFUSRID = ['Users Master'].USERID
9MODIFDT SearchModified DateDateDT8
10Workflow_Status SearchWorkflow StatusIntegerWorkflow Status0
11SecurityTaskNameModified SearchSecurity Task Name ModifiedStringSTR5050
12SecurityTaskDescModified SearchSecurity Task Description ModifiedStringSTR255255
13SecurityTaskCatgModified SearchSecurity Task Category ModifiedIntegerSecurity Task Category0
14WorkflowOriginCompany SearchWorkflow Origin CompanyStringSTR5_IC_ID5

Leave a Reply

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