Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RejectReason
Product: Mekorma MICR (2404)
Series: Company
Display Name: Mekorma MICR Batch Reject Reason TEMP
Physical Name: RejectReason
Technical Name: ME_BatchRejectReason_TEMPSeq 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 TEMP'].VENDORID AS 'Mekorma MICR Batch Reject Reason TEMP-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
RejectReason AS ['Mekorma MICR Batch Reject Reason TEMP']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Mekorma MICR Batch Reject Reason TEMP'].VENDORID = ['PM Vendor Master File'].VENDORID5 VENDNAME Vendor Name STR64_Vendor_Name String 64 6 NUMOFTRX Number Of TRX LI6_U0 Long Integer 6 7 TotAmtPaid Total Amount Paid DLR19_RBS0_UTR$ Currency 19 8 REJECTIONREASON ME_Rejection_Reason STR255 String 255