Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PO80000
Product: WennSoft Products (131)
Series: Purchasing
Display Name: PO_Line_Comments
Physical Name: PO80000
Technical Name: PO_Line_CommentsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PONUMWRK 
Purchase_Order_Number_WORK_STR STR20_LBAU String 20 2 SQNCLINE Sequence Line DLR19_$S2 Currency 19 3 OPEN1 Open CB_Open Boolean 0 4 COMMENT_1 Comment[1] STR50 String 50 5 COMMENT_2 Comment[2] STR50 String 50 6 COMMENT_3 Comment[3] STR50 String 50 7 COMMENT_4 Comment[4] STR50 String 50 8 COMMNTID Comment ID STR15_Comment_ID String 15 Key to the Comment Master (SY04200).
Click to show/hide
SELECT
['PO_Line_Comments'].COMMNTID AS 'PO_Line_Comments-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
PO80000 AS ['PO_Line_Comments']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['PO_Line_Comments'].COMMNTID = ['Comment Master'].COMMNTID9 TXTFIELD Text Field TX32000 Text 32000