RM Apply Open File (RM20201)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Apply Open File
Physical Name: RM20201
Technical Name: RM_Applied_OPEN

Group Display Name: Receivables Open Transaction Files
Group Technical Name: RM_Open_Transaction_Logical_File

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

Click to show/hide

SELECT
       ['RM Apply Open File'].CUSTNMBR AS 'RM Apply Open File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       RM20201 AS ['RM Apply Open File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['RM Apply Open File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2CPRCSTNM SearchCorporate Customer NumberStringSTR15_RM_Customer_Number15
3TRXSORCE SearchTRX SourceStringSTR1313
4DATE1 SearchDateDateDT66
5TIME1 SearchTimeTimeTM66
6GLPOSTDT SearchGL Posting DateDateDT8
7POSTED SearchPostedBooleanTrue/False0
8TAXDTLID SearchTax Detail IDStringSTR15_Tax_Detail_ID15
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['RM Apply Open File'].CURRNIDX AS 'RM Apply Open File-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       RM20201 AS ['RM Apply Open File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['RM Apply Open File'].CURRNIDX = ['Currency Setup'].CURRNIDX
15APPTOAMT SearchApply To AmountCurrencyDLR17_RBS0_UTR$17
16DISTKNAM SearchDiscount Taken AmountCurrencyDLR17_RBS0_UTR$17
17DISAVTKN SearchDiscount Available TakenCurrencyDLR17_RBS0_UTR$17
18WROFAMNT SearchWrite Off AmountCurrencyDLR17_RBS0_STR$17
19ORAPTOAM SearchOriginating Apply To AmountCurrencyDLR17_RBS0_UTR$17
20ORDISTKN SearchOriginating Discount Taken AmountCurrencyDLR17_RBS0_UTR$17
21ORDATKN SearchOriginating Discount Available TakenCurrencyDLR17_RBS0_UTR$17
22ORWROFAM SearchOriginating Write Off AmountCurrencyDLR17_RBS0_STR$17
23APTOEXRATE SearchApply To Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
24APTODENRATE SearchApply To Denomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
25APTORTCLCMETH SearchApply To Rate Calc MethodIntegerINT0
26APTOMCTRXSTT SearchApply To MC Transaction StateIntegerINT0
27APFRDCNM SearchApply From Document NumberStringSTR20_Document_Number20
28APFRDCTY SearchApply From Document TypeIntegerINT22
29APFRDCDT SearchApply From Document DateDateDT8
30ApplyFromGLPostDate SearchApply From GL Posting DateDateDT8
31FROMCURR SearchApply From Currency IDStringSTR15_Currency_ID15
32APFRMAPLYAMT SearchApply From Apply AmountCurrencyDLR17_RBS0_UTR$17
33APFRMDISCTAKEN SearchApply From Discount Taken AmountCurrencyDLR17_RBS0_UTR$17
34APFRMDISCAVAIL SearchApply From Discount Available TakenCurrencyDLR17_RBS0_UTR$17
35APFRMWROFAMT SearchApply From Write Off AmountCurrencyDLR17_RBS0_UTR$17
36ActualApplyToAmount SearchActual Apply To AmountCurrencyDLR17_RBS0_UTR$17
37ActualDiscTakenAmount SearchActual Discount Taken AmountCurrencyDLR17_RBS0_UTR$17
38ActualDiscAvailTaken SearchActual Discount Available TakenCurrencyDLR17_RBS0_UTR$17
39ActualWriteOffAmount SearchActual Write Off AmountCurrencyDLR17_RBS0_UTR$17
40APFRMEXRATE SearchApply From Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
41APFRMDENRATE SearchApply From Denomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
42APFRMRTCLCMETH SearchApply From Rate Calc MethodIntegerINT0
43APFRMMCTRXSTT SearchApply From MC Transaction StateIntegerINT0
44APYFRMRNDAMT SearchApply From Round AmountCurrencyDLR17_RBS0_STR$17
45APYTORNDAMT SearchApply To Round AmountCurrencyDLR17_RBS0_STR$17
46APYTORNDDISC SearchApply To Round DiscountCurrencyDLR17_RBS0_STR$17
47OAPYFRMRNDAMT SearchOriginating Apply From Round AmountCurrencyDLR17_RBS0_STR$17
48OAPYTORNDAMT SearchOriginating Apply To Round AmountCurrencyDLR17_RBS0_STR$17
49OAPYTORNDDISC SearchOriginating Apply To Round DiscountCurrencyDLR17_RBS0_STR$17
50GSTDSAMT SearchGST Discount AmountCurrencyDLR17_RBS0_STR$17
51PPSAMDED SearchPPS Amount DeductedCurrencyDLR17_RBS0_UTR$17
52RLGANLOS SearchRealized Gain-Loss AmountCurrencyDLR19_$S219
53Settled_Gain_CreditCurrT SearchSettled Gain CreditCurrTrxCurrencyDLR19_$S219
54Settled_Loss_CreditCurrT SearchSettled Loss CreditCurrTrxCurrencyDLR19_$S219
55Settled_Gain_DebitCurrTr SearchSettled Gain DebitCurrTrxCurrencyDLR19_$S219
56Settled_Loss_DebitCurrTr SearchSettled Loss DebitCurrTrxCurrencyDLR19_$S219
57Settled_Gain_DebitDiscAv SearchSettled Gain DebitDiscAvailCurrencyDLR19_$S219
58Settled_Loss_DebitDiscAv SearchSettled Loss DebitDiscAvailCurrencyDLR19_$S219
59Revaluation_Status SearchRevaluation StatusIntegerINT0

Leave a Reply

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