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_FileSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VCHRNMBR 
Voucher Number STR20_LBAU String 20 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'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
PO00800 AS ['PO_Link_File']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['PO_Link_File'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['PO_Link_File'].DOCTYPE = ['PM Key Master File'].DOCTYPE2 RECNUM Receivings_Number_STR STR17_LBAU String 17 3 PONUMWRK Purchase_Order_Number_WORK_STR STR20_LBAU String 20