Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME234605
Product: MICR for Canadian Payroll (2916)
Series: Purchasing
Display Name: ME PM Payment Apply To Work File DUP
Physical Name: ME234605
Technical Name: ME_PM_Payment_Apply_WORK_DUPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DiscTknTot 
Discount Taken Total DLR19_RBS0_STR$ Currency 19 2 NetCkAmt Net Check Amount DLR17_RBS0_STR$ Currency 17 3 PdTot Paid Total DLR17_RBS0_STR$ Currency 17 4 NegTot Negative Total DLR17_RBS0_STR$ Currency 17 5 CrdDocAmt Credit Document Amount DLR19_$S2 Currency 19 6 TotDocAmt Total Document Amount DLR19_RBS0_STR$ Currency 19 7 WrOffTot Write Off Total DLR19_RBS0_UTR$ Currency 19 8 CrdtDesc Credit Description STR30 String 30 9 TRXDSCRN Transaction Description STR30 String 30 10 PrtOnStb Print On Stub Boolean Boolean 0 11 PMNTNMBR Payment Number STR20_LBAU String 20 12 KEYFIELD Key Field STR20 String 20 13 APFVCHNM Apply From Voucher Number STR20_LBAU String 20 14 APTVCHNM Apply To Voucher Number STR20_LBAU String 20 15 APFRDCTY Apply From Document Type INT2 Integer 2 16 APTODCTY Apply To Document Type DDL_Document_Type Integer 0 17 DOCNUMBR Document Number STR20_Document_Number String 20 18 DOCDATE Document Date DT Date 8 19 AMNTPAID Amount Paid DLR17_RBS0_STR$ Currency 17 20 CRDTAMNT Credit Amount DLR19_$S2 Currency 19 21 DocDueDate Document Due Date DATE Date 6 22 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 19 23 DISCDATE Discount Date DT Date 8 24 DISTKNAM Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 25 WROFAMNT Write Off Amount DLR17_RBS0_STR$ Currency 17 26 PPSAMDED PPS Amount Deducted DLR17_RBS0_UTR$ Currency 17 27 GSTDSAMT GST Discount Amount DLR17_RBS0_STR$ Currency 17 28 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['ME PM Payment Apply To Work File DUP'].CURNCYID AS 'ME PM Payment Apply To Work File DUP-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
ME234605 AS ['ME PM Payment Apply To Work File DUP']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['ME PM Payment Apply To Work File DUP'].CURNCYID = ['Currency Setup'].CURNCYID29 Outstanding_Amount Outstanding Amount DLR19_RBS0_UTR$ Currency 19 30 Net_Paid_Amount Net Paid Amount DLR19_RBS0_UTR$ Currency 19 31 VCHRNMBR Voucher Number STR20_LBAU String 20 Partial key to the PM Key Master File (PM00400).
Click to show/hide
SELECT
['ME PM Payment Apply To Work File DUP'].VCHRNMBR AS 'ME PM Payment Apply To Work File DUP-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
ME234605 AS ['ME PM Payment Apply To Work File DUP']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['ME PM Payment Apply To Work File DUP'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['ME PM Payment Apply To Work File DUP'].DOCTYPE = ['PM Key Master File'].DOCTYPE32 DOCTYPE Document Type DDL_Document_Type Integer 0 Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo33 Selected_To_Print Selected To Print CB Boolean 0