Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME240472
Product: Mekorma MICR (2404)
Series: Purchasing
Display Name: Mekorma MICR Batch Reject Reason
Physical Name: ME240472
Technical Name: ME_BatchRejectReasonSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BACHNUMB 
Batch Number STR15_LBAU String 15 2 BCHSOURC Batch Source STR15 String 15 3 MEORIGBACHNUMB ME_OrigBatchNumber STR15_LBAU String 15 4 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['Mekorma MICR Batch Reject Reason'].VENDORID AS 'Mekorma MICR Batch Reject Reason-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ME240472 AS ['Mekorma MICR Batch Reject Reason']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Mekorma MICR Batch Reject Reason'].VENDORID = ['PM Vendor Master File'].VENDORID5 VENDNAME Vendor Name STR64_Vendor_Name String 64 6 PMNTNMBR Payment Number STR20_LBAU String 20 7 NUMOFTRX Number Of TRX LI6_U0 Long Integer 6 8 TotAmtPaid Total Amount Paid DLR19_RBS0_UTR$ Currency 19 9 REJECTIONREASON ME_Rejection_Reason STR255 String 255