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