Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PO20204
Product: WennSoft Products (131)
Series: Purchasing
Display Name: PO_OPEN_LINE_SOP_Reserved
Physical Name: PO20204
Technical Name: PO_OPEN_LINE_SOP_ReservedSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PONUMWRK 
Purchase_Order_Number_WORK_STR STR20_LBAU String 20 2 PURORDLINSEQ Purchase_Order_Line_Sequence_DOL DLR17_RBS0_STR Currency 17 3 SOPNUMBE SOP Number STR20_SOP_Number String 17 4 LNSEQNBR Line SEQ Number Sequence_Number Currency 19 5 DATE1 Date DT6 Date 6 6 ATYALLOC QTY Allocated DLR17_QTY_RBS0_UTR Currency 17 7 QTYREMAI QTY Remaining DLR17_QTY_RBS0_UTR Currency 17 8 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PO_OPEN_LINE_SOP_Reserved'].USERID AS 'PO_OPEN_LINE_SOP_Reserved-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PO20204 AS ['PO_OPEN_LINE_SOP_Reserved']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PO_OPEN_LINE_SOP_Reserved'].USERID = ['Users Master'].USERID9 ITMNUM Item_Number_STR STR30_Item_Number String 30