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 TypeSQL DB LengthKeyable Length
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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_NumberString1615
3TRXSORCE SearchTRX SourceSTR13String1413
4DATE1 SearchDateDT6Date46
5TIME1 SearchTimeTM6Time46
6GLPOSTDT SearchGL Posting DateDTDate48
7POSTED SearchPostedTrue/FalseBoolean20
8TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString1615
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_NumberString2220
10APTODCTY SearchApply To Document TypeDDL_Document_TypeInteger20
11APTODCDT SearchApply To Document DateDTDate48
12ApplyToGLPostDate SearchApply To GL Posting DateDTDate48
13CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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 IndexINT3Integer23
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$Currency1017
16DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
17DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency1017
18WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
19ORAPTOAM SearchOriginating Apply To AmountDLR17_RBS0_UTR$Currency1017
20ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency1017
21ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency1017
22ORWROFAM SearchOriginating Write Off AmountDLR17_RBS0_STR$Currency1017
23APTOEXRATE SearchApply To Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
24APTODENRATE SearchApply To Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
25APTORTCLCMETH SearchApply To Rate Calc MethodINTInteger20
26APTOMCTRXSTT SearchApply To MC Transaction StateINTInteger20
27APFRDCNM SearchApply From Document NumberSTR20_Document_NumberString2220
28APFRDCTY SearchApply From Document TypeINT2Integer22
29APFRDCDT SearchApply From Document DateDTDate48
30ApplyFromGLPostDate SearchApply From GL Posting DateDTDate48
31FROMCURR SearchApply From Currency IDSTR15_Currency_IDString1615
32APFRMAPLYAMT SearchApply From Apply AmountDLR17_RBS0_UTR$Currency1017
33APFRMDISCTAKEN SearchApply From Discount Taken AmountDLR17_RBS0_UTR$Currency1017
34APFRMDISCAVAIL SearchApply From Discount Available TakenDLR17_RBS0_UTR$Currency1017
35APFRMWROFAMT SearchApply From Write Off AmountDLR17_RBS0_UTR$Currency1017
36ActualApplyToAmount SearchActual Apply To AmountDLR17_RBS0_UTR$Currency1017
37ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency1017
38ActualDiscAvailTaken SearchActual Discount Available TakenDLR17_RBS0_UTR$Currency1017
39ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency1017
40APFRMEXRATE SearchApply From Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
41APFRMDENRATE SearchApply From Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
42APFRMRTCLCMETH SearchApply From Rate Calc MethodINTInteger20
43APFRMMCTRXSTT SearchApply From MC Transaction StateINTInteger20
44APYFRMRNDAMT SearchApply From Round AmountDLR17_RBS0_STR$Currency1017
45APYTORNDAMT SearchApply To Round AmountDLR17_RBS0_STR$Currency1017
46APYTORNDDISC SearchApply To Round DiscountDLR17_RBS0_STR$Currency1017
47OAPYFRMRNDAMT SearchOriginating Apply From Round AmountDLR17_RBS0_STR$Currency1017
48OAPYTORNDAMT SearchOriginating Apply To Round AmountDLR17_RBS0_STR$Currency1017
49OAPYTORNDDISC SearchOriginating Apply To Round DiscountDLR17_RBS0_STR$Currency1017
50GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency1017
51PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency1017
52RLGANLOS SearchRealized Gain-Loss AmountDLR19_$S2Currency1019
53Settled_Gain_CreditCurrT SearchSettled Gain CreditCurrTrxDLR19_$S2Currency1019
54Settled_Loss_CreditCurrT SearchSettled Loss CreditCurrTrxDLR19_$S2Currency1019
55Settled_Gain_DebitCurrTr SearchSettled Gain DebitCurrTrxDLR19_$S2Currency1019
56Settled_Loss_DebitCurrTr SearchSettled Loss DebitCurrTrxDLR19_$S2Currency1019
57Settled_Gain_DebitDiscAv SearchSettled Gain DebitDiscAvailDLR19_$S2Currency1019
58Settled_Loss_DebitDiscAv SearchSettled Loss DebitDiscAvailDLR19_$S2Currency1019
59Revaluation_Status SearchRevaluation StatusINTInteger20
60DEX_ROW_ID Searchintint1010

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 *