Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PO80011
Product: WennSoft Products (131)
Series: Purchasing
Display Name: Expense_Claim_Line_Comments
Physical Name: PO80011
Technical Name: Expense_Claim_Line_CommentsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 RECNUM 
Receivings_Number_STR STR17_LBAU String 17 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
['Expense_Claim_Line_Comments'].COMMNTID AS 'Expense_Claim_Line_Comments-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
PO80011 AS ['Expense_Claim_Line_Comments']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['Expense_Claim_Line_Comments'].COMMNTID = ['Comment Master'].COMMNTID9 CMMTTEXT Comment Text TX500 Text 500