Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY01301
Product: Microsoft Dynamics GP (0)
Series: System
Display Name: Process Group Cleanup Information
Physical Name: SY01301
Technical Name: coProcessCleanupSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ParamID 
ParamID Long Integer long 8 2 Process_ID Process ID Integer INT5 4 3 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Process Group Cleanup Information'].USERID AS 'Process Group Cleanup Information-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SY01301 AS ['Process Group Cleanup Information']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Process Group Cleanup Information'].USERID = ['Users Master'].USERID4 IsMultiGroup IsMultiGroup Boolean CB 0 5 GroupCount GroupCount Integer INT5 4 6 PRCSSQNC Process Sequence Integer INT 0 7 RPTGRIND Report Group Index Integer INT 0 8 RTPACHIN Report Palette Choice Index Integer INT 0 9 RTGRSBIN Report Group Sub Index Currency DLR14 14 10 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 11 BACHNUMB Batch Number String STR15_LBAU 15 12 IntegerValue IntegerValue Integer INT 0 13 Array_of_Booleans_1 Array of Booleans[1] Boolean Boolean 0 14 Array_of_Booleans_2 Array of Booleans[2] Boolean Boolean 0 15 Array_of_Booleans_3 Array of Booleans[3] Boolean Boolean 0 16 Array_of_Booleans_4 Array of Booleans[4] Boolean Boolean 0 17 Array_of_Booleans_5 Array of Booleans[5] Boolean Boolean 0 18 Array_of_Booleans_6 Array of Booleans[6] Boolean Boolean 0 19 Array_of_Booleans_7 Array of Booleans[7] Boolean Boolean 0 20 Array_of_Booleans_8 Array of Booleans[8] Boolean Boolean 0 21 Array_of_Booleans_9 Array of Booleans[9] Boolean Boolean 0 22 Array_of_Booleans_10 Array of Booleans[10] Boolean Boolean 0 23 Array_of_Booleans_11 Array of Booleans[11] Boolean Boolean 0 24 Array_of_Booleans_12 Array of Booleans[12] Boolean Boolean 0 25 Array_of_Booleans_13 Array of Booleans[13] Boolean Boolean 0 26 Array_of_Booleans_14 Array of Booleans[14] Boolean Boolean 0 27 Array_of_Booleans_15 Array of Booleans[15] Boolean Boolean 0 28 GROUPBOX Group Box Integer GB 0 29 CMPANYID Company ID Integer INT5 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Process Group Cleanup Information'].CMPANYID AS 'Process Group Cleanup Information-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
SY01301 AS ['Process Group Cleanup Information']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Process Group Cleanup Information'].CMPANYID = ['Company Master'].CMPANYID30 CMPNYNAM Company Name String STR64_Company_Name 64