PO_Link_File (PO00800)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PO00800

Product: WennSoft Products (131)
Series: Purchasing

Display Name: PO_Link_File
Physical Name: PO00800
Technical Name: PO_Link_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
Partial key to the PM Key Master File (PM00400).

Click to show/hide

SELECT
       ['PO_Link_File'].VCHRNMBR AS 'PO_Link_File-Voucher Number'
       ,['PM Key Master File'].VCHRNMBR AS 
FROM
       PO00800 AS ['PO_Link_File']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['PO_Link_File'].VCHRNMBR = ['PM Key Master File'].VCHRNMBR
              AND
                     ['PO_Link_File'].DOCTYPE = ['PM Key Master File'].DOCTYPE
              AND
                     ['PM Key Master File'].CNTRLTYP = 0
2RECNUM SearchReceivings_Number_STRSTR17_LBAUString1817
3PONUMWRK SearchPurchase_Order_Number_WORK_STRSTR20_LBAUString2220

Leave a Reply

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