RM Apply History File (RM30201)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM30201

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Apply History File
Physical Name: RM30201
Technical Name: RM_Applied_History

Group Display Name: Receivable Transaction History Files
Group Technical Name: RM_Transaction_History_Logical_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['RM Apply History File'].CUSTNMBR AS 'RM Apply History File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       RM30201 AS ['RM Apply History File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['RM Apply History File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString15
3TRXSORCE SearchTRX SourceSTR13String13
4DATE1 SearchDateDT6Date6
5TIME1 SearchTimeTM6Time6
6GLPOSTDT SearchGL Posting DateDTDate8
7POSTED SearchPostedTrue/FalseBoolean0
8TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString15
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['RM Apply History File'].TAXDTLID AS 'RM Apply History File-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       RM30201 AS ['RM Apply History File']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['RM Apply History File'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
9APTODCNM SearchApply To Document NumberSTR20_Document_NumberString20
10APTODCTY SearchApply To Document TypeDDL_Document_TypeInteger0
11APTODCDT SearchApply To Document DateDTDate8
12ApplyToGLPostDate SearchApply To GL Posting DateDTDate8
13CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['RM Apply History File'].CURNCYID AS 'RM Apply History File-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       RM30201 AS ['RM Apply History File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['RM Apply History File'].CURNCYID = ['Currency Setup'].CURNCYID
14CURRNIDX SearchCurrency IndexINT3Integer3
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['RM Apply History File'].CURRNIDX AS 'RM Apply History File-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       RM30201 AS ['RM Apply History File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['RM Apply History File'].CURRNIDX = ['Currency Setup'].CURRNIDX
15APPTOAMT SearchApply To AmountDLR17_RBS0_UTR$Currency17
16DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
17DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency17
18WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency17
19ORAPTOAM SearchOriginating Apply To AmountDLR17_RBS0_UTR$Currency17
20ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency17
21ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency17
22ORWROFAM SearchOriginating Write Off AmountDLR17_RBS0_STR$Currency17
23APTOEXRATE SearchApply To Exchange RateDLR14_Exchange_RateCurrency (Variable)14
24APTODENRATE SearchApply To Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
25APTORTCLCMETH SearchApply To Rate Calc MethodINTInteger0
26APTOMCTRXSTT SearchApply To MC Transaction StateINTInteger0
27APFRDCNM SearchApply From Document NumberSTR20_Document_NumberString20
28APFRDCTY SearchApply From Document TypeINT2Integer2
29APFRDCDT SearchApply From Document DateDTDate8
30ApplyFromGLPostDate SearchApply From GL Posting DateDTDate8
31FROMCURR SearchApply From Currency IDSTR15_Currency_IDString15
32APFRMAPLYAMT SearchApply From Apply AmountDLR17_RBS0_UTR$Currency17
33APFRMDISCTAKEN SearchApply From Discount Taken AmountDLR17_RBS0_UTR$Currency17
34APFRMDISCAVAIL SearchApply From Discount Available TakenDLR17_RBS0_UTR$Currency17
35APFRMWROFAMT SearchApply From Write Off AmountDLR17_RBS0_UTR$Currency17
36ActualApplyToAmount SearchActual Apply To AmountDLR17_RBS0_UTR$Currency17
37ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency17
38ActualDiscAvailTaken SearchActual Discount Available TakenDLR17_RBS0_UTR$Currency17
39ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency17
40APFRMEXRATE SearchApply From Exchange RateDLR14_Exchange_RateCurrency (Variable)14
41APFRMDENRATE SearchApply From Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
42APFRMRTCLCMETH SearchApply From Rate Calc MethodINTInteger0
43APFRMMCTRXSTT SearchApply From MC Transaction StateINTInteger0
44APYFRMRNDAMT SearchApply From Round AmountDLR17_RBS0_STR$Currency17
45APYTORNDAMT SearchApply To Round AmountDLR17_RBS0_STR$Currency17
46APYTORNDDISC SearchApply To Round DiscountDLR17_RBS0_STR$Currency17
47OAPYFRMRNDAMT SearchOriginating Apply From Round AmountDLR17_RBS0_STR$Currency17
48OAPYTORNDAMT SearchOriginating Apply To Round AmountDLR17_RBS0_STR$Currency17
49OAPYTORNDDISC SearchOriginating Apply To Round DiscountDLR17_RBS0_STR$Currency17
50GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency17
51PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency17
52RLGANLOS SearchRealized Gain-Loss AmountDLR19_$S2Currency19
53Settled_Gain_CreditCurrT SearchSettled Gain CreditCurrTrxDLR19_$S2Currency19
54Settled_Loss_CreditCurrT SearchSettled Loss CreditCurrTrxDLR19_$S2Currency19
55Settled_Gain_DebitCurrTr SearchSettled Gain DebitCurrTrxDLR19_$S2Currency19
56Settled_Loss_DebitCurrTr SearchSettled Loss DebitCurrTrxDLR19_$S2Currency19
57Settled_Gain_DebitDiscAv SearchSettled Gain DebitDiscAvailDLR19_$S2Currency19
58Settled_Loss_DebitDiscAv SearchSettled Loss DebitDiscAvailDLR19_$S2Currency19
59Revaluation_Status SearchRevaluation StatusINTInteger0
60DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *