PO_Line_Comments (PO80000)

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_Comments

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PONUMWRK SearchPurchase_Order_Number_WORK_STRSTR20_LBAUString2220
2SQNCLINE SearchSequence LineDLR19_$S2Currency1019
3OPEN1 SearchOpenCB_OpenBoolean20
4COMMENT_1 SearchComment[1]STR50String5250
5COMMENT_2 SearchComment[2]STR50String5250
6COMMENT_3 SearchComment[3]STR50String5250
7COMMENT_4 SearchComment[4]STR50String5250
8COMMNTID SearchComment IDSTR15_Comment_IDString1615
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'].COMMNTID
9TXTFIELD SearchText FieldTX32000Text232000

Leave a Reply

Your email address will not be published. Required fields are marked *