Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CO00201
Product: Microsoft Dynamics GP (0)
Series: Company
Display Name: Document Viewer Query Designer
Physical Name: CO00201
Technical Name: CODocViewerQDSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 SERIES 
Series Integer DDL_Series 0 2 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Document Viewer Query Designer'].USERID AS 'Document Viewer Query Designer-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
CO00201 AS ['Document Viewer Query Designer']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Document Viewer Query Designer'].USERID = ['Users Master'].USERID3 TYPEID Type ID Integer INT 0 4 CustVenID Customer Vendor ID String STR15_LBU 15 5 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 6 OPTION1 Option1 Boolean CB 0 7 OPTION2 Option2 Boolean CB 0 8 OPTION3 Option3 Boolean CB 0 9 OPTION4 Option4 Boolean CB 0 10 OPTION5 Option5 Boolean CB 0 11 OPTION6 Option6 Boolean CB 0 12 FieldPhysicalName FieldPhysicalName String STR30 30 13 FieldDataType FieldDataType Integer FieldDataType 0 14 FieldRefID FieldRefID Integer FieldRefID 0 15 FilterType FilterType Integer DDL 0 16 Start_Position_String Start Position String String STR89 89 17 End_Position_String End Position String String STR89 89 18 STRTAMNT Start Amount Currency DLR17_RBSO_STR$ 17 19 ENDAMNT End Amount Currency DLR17_RBSO_STR$ 17 20 STRTDATE Start Date Date DT 8 21 ENDDATE End Date Date DT 8 22 startValue startValue Long Integer long 8 23 endValue endValue Long Integer long 8 24 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['Document Viewer Query Designer'].ITEMNMBR AS 'Document Viewer Query Designer-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
CO00201 AS ['Document Viewer Query Designer']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Document Viewer Query Designer'].ITEMNMBR = ['Item Master'].ITEMNMBR