Expense_Claim_Line_Comments (PO80011)

azurecurveProductsWennSoft Products (131)PurchasingExpense_Claim_Line_Comments (PO80011)

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_Comments

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1RECNUM SearchReceivings_Number_STRSTR17_LBAUString1817
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
       ['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'].COMMNTID
9CMMTTEXT SearchComment TextTX500Text2500
azurecurveProductsWennSoft Products (131)PurchasingExpense_Claim_Line_Comments (PO80011)

Leave a Reply

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