Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVRMA302
Product: WennSoft Products (131)
Series: Sales
Display Name: RM Apply History File_Archive
Physical Name: SVRMA302
Technical Name: RM_Applied_History_ArchiveSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR 
Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['RM Apply History File_Archive'].CUSTNMBR AS 'RM Apply History File_Archive-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVRMA302 AS ['RM Apply History File_Archive']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['RM Apply History File_Archive'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 CPRCSTNM Corporate Customer Number STR15_RM_Customer_Number String 15 3 TRXSORCE TRX Source STR13 String 13 4 DATE1 Date DT6 Date 6 5 TIME1 Time TM6 Time 6 6 GLPOSTDT GL Posting Date DT Date 8 7 POSTED Posted True/False Boolean 0 8 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['RM Apply History File_Archive'].TAXDTLID AS 'RM Apply History File_Archive-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
SVRMA302 AS ['RM Apply History File_Archive']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['RM Apply History File_Archive'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID9 APTODCNM Apply To Document Number STR20_Document_Number String 20 10 APTODCTY Apply To Document Type DDL_Document_Type Integer 0 11 APTODCDT Apply To Document Date DT Date 8 12 ApplyToGLPostDate Apply To GL Posting Date DT Date 8 13 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['RM Apply History File_Archive'].CURNCYID AS 'RM Apply History File_Archive-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
SVRMA302 AS ['RM Apply History File_Archive']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['RM Apply History File_Archive'].CURNCYID = ['Currency Setup'].CURNCYID14 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['RM Apply History File_Archive'].CURRNIDX AS 'RM Apply History File_Archive-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
SVRMA302 AS ['RM Apply History File_Archive']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['RM Apply History File_Archive'].CURRNIDX = ['Currency Setup'].CURRNIDX15 APPTOAMT Apply To Amount DLR17_RBS0_UTR$ Currency 17 16 DISTKNAM Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 17 DISAVTKN Discount Available Taken DLR17_RBS0_UTR$ Currency 17 18 WROFAMNT Write Off Amount DLR17_RBS0_STR$ Currency 17 19 ORAPTOAM Originating Apply To Amount DLR17_RBS0_UTR$ Currency 17 20 ORDISTKN Originating Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 21 ORDATKN Originating Discount Available Taken DLR17_RBS0_UTR$ Currency 17 22 ORWROFAM Originating Write Off Amount DLR17_RBS0_STR$ Currency 17 23 APTOEXRATE Apply To Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 24 APTODENRATE Apply To Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 25 APTORTCLCMETH Apply To Rate Calc Method INT Integer 0 26 APTOMCTRXSTT Apply To MC Transaction State INT Integer 0 27 APFRDCNM Apply From Document Number STR20_Document_Number String 20 28 APFRDCTY Apply From Document Type INT2 Integer 2 29 APFRDCDT Apply From Document Date DT Date 8 30 ApplyFromGLPostDate Apply From GL Posting Date DT Date 8 31 FROMCURR Apply From Currency ID STR15_Currency_ID String 15 32 APFRMAPLYAMT Apply From Apply Amount DLR17_RBS0_UTR$ Currency 17 33 APFRMDISCTAKEN Apply From Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 34 APFRMDISCAVAIL Apply From Discount Available Taken DLR17_RBS0_UTR$ Currency 17 35 APFRMWROFAMT Apply From Write Off Amount DLR17_RBS0_UTR$ Currency 17 36 ActualApplyToAmount Actual Apply To Amount DLR17_RBS0_UTR$ Currency 17 37 ActualDiscTakenAmount Actual Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 38 ActualDiscAvailTaken Actual Discount Available Taken DLR17_RBS0_UTR$ Currency 17 39 ActualWriteOffAmount Actual Write Off Amount DLR17_RBS0_UTR$ Currency 17 40 APFRMEXRATE Apply From Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 41 APFRMDENRATE Apply From Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 42 APFRMRTCLCMETH Apply From Rate Calc Method INT Integer 0 43 APFRMMCTRXSTT Apply From MC Transaction State INT Integer 0 44 APYFRMRNDAMT Apply From Round Amount DLR17_RBS0_STR$ Currency 17 45 APYTORNDAMT Apply To Round Amount DLR17_RBS0_STR$ Currency 17 46 APYTORNDDISC Apply To Round Discount DLR17_RBS0_STR$ Currency 17 47 OAPYFRMRNDAMT Originating Apply From Round Amount DLR17_RBS0_STR$ Currency 17 48 OAPYTORNDAMT Originating Apply To Round Amount DLR17_RBS0_STR$ Currency 17 49 OAPYTORNDDISC Originating Apply To Round Discount DLR17_RBS0_STR$ Currency 17 50 GSTDSAMT GST Discount Amount DLR17_RBS0_STR$ Currency 17 51 PPSAMDED PPS Amount Deducted DLR17_RBS0_UTR$ Currency 17 52 RLGANLOS Realized Gain-Loss Amount DLR19_$S2 Currency 19 53 Settled_Gain_CreditCurrT Settled Gain CreditCurrTrx DLR19_$S2 Currency 19 54 Settled_Loss_CreditCurrT Settled Loss CreditCurrTrx DLR19_$S2 Currency 19 55 Settled_Gain_DebitCurrTr Settled Gain DebitCurrTrx DLR19_$S2 Currency 19 56 Settled_Loss_DebitCurrTr Settled Loss DebitCurrTrx DLR19_$S2 Currency 19 57 Settled_Gain_DebitDiscAv Settled Gain DebitDiscAvail DLR19_$S2 Currency 19 58 Settled_Loss_DebitDiscAv Settled Loss DebitDiscAvail DLR19_$S2 Currency 19 59 Revaluation_Status Revaluation Status INT Integer 0