Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MAV20300
Product: MIS-AMS Extensions (3459)
Series: Purchasing
Display Name: MAV POP Receipts
Physical Name: MAV20300
Technical Name: MAV_POP_ReceiptsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 POPRCTNM 
POP Receipt Number STR17_POP_Number String 17 2 VCHRNMBR Voucher Number STR20_LBAU String 20 Partial key to the PM Key Master File (PM00400).
Click to show/hide
SELECT
['MAV POP Receipts'].VCHRNMBR AS 'MAV POP Receipts-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
MAV20300 AS ['MAV POP Receipts']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['MAV POP Receipts'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['MAV POP Receipts'].DOCTYPE = ['PM Key Master File'].DOCTYPE3 NONREC MAV Non_Recoverable Amount DLR17_RBS0_UTR$ Currency 17 4 POPTYPE POP Type DDL_POP_Type Integer 0 5 MAVPAMNT MAV Purchases Amount DLR17_RBS0_UTR$ Currency 17 6 MAVTAMNT MAV Tax Amount DLR17_RBS0_UTR$ Currency 17