Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA50105
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: RMPMOpen
Physical Name: PA50105
Technical Name: paRMPMOpenSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['RMPMOpen'].USERID AS 'RMPMOpen-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PA50105 AS ['RMPMOpen']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['RMPMOpen'].USERID = ['Users Master'].USERID2 DOCTYPE Document Type Integer DDL_Document_Type 0 3 DOCNUMBR Document Number String STR20_Document_Number 20 4 VCHRNMBR Voucher Number String STR20_LBAU 20 5 MODULEID Module ID Integer INT4 4 6 DOCDATE Document Date Date DT 8 7 DUEDATE Due Date Date DT 8 8 CustVenID Customer Vendor ID String STR15_LBU 15 9 CURTRXAM Current Trx Amount Currency DLR17_RBS0_UTR$ 17 10 ORCTRXAM Originating Current Trx Amount Currency DLR17_RBS0_UTR$ 17 11 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['RMPMOpen'].CURNCYID AS 'RMPMOpen-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PA50105 AS ['RMPMOpen']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['RMPMOpen'].CURNCYID = ['Currency Setup'].CURNCYID12 VOIDSTTS Void Status Integer INT 0 13 APPLDAMT Applied Amount Currency DLR17_RBS0_STR$ 17 14 ORAPPAMT Originating Applied Amount Currency DLR17_RBS0_STR$ 17 15 DISTKNAM Discount Taken Amount Currency DLR17_RBS0_UTR$ 17 16 ORDISTKN Originating Discount Taken Amount Currency DLR17_RBS0_UTR$ 17 17 DISAVTKN Discount Available Taken Currency DLR17_RBS0_UTR$ 17 18 ORDATKN Originating Discount Available Taken Currency DLR17_RBS0_UTR$ 17 19 TAXDTLID Tax Detail ID String STR15_Tax_Detail_ID 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['RMPMOpen'].TAXDTLID AS 'RMPMOpen-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
PA50105 AS ['RMPMOpen']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['RMPMOpen'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID20 GSTDSAMT GST Discount Amount Currency DLR17_RBS0_STR$ 17 21 PPSAMDED PPS Amount Deducted Currency DLR17_RBS0_UTR$ 17