RM Open File Debit Copy (RM20101)

azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Open File Debit Copy (RM20101)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Open File
Physical Name: RM20101
Technical Name: RM_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 Open File'].CUSTNMBR AS 'RM Open File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       RM20101 AS ['RM Open File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['RM Open File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2CPRCSTNM SearchCorporate Customer NumberStringSTR15_RM_Customer_Number15
3DOCNUMBR SearchDocument NumberStringSTR20_Document_Number20
4CHEKNMBR SearchCheck NumberStringSTR20_Document_Number20
5BACHNUMB SearchBatch NumberStringSTR15_LBAU15
6BCHSOURC SearchBatch SourceStringSTR1515
7TRXSORCE SearchTRX SourceStringSTR1313
8RMDTYPAL SearchRM Document Type-AllIntegerINT22
Document Type records the type of document.

Click to show/hide the Document Types


0	Balance Carried Forward
1	Sales / Invoice
2	Scheduled Payments
3	Debit Memo
4	Finance Charge
5	Service Repairs
6	Warranties
7	Credit Memo
8	Returns
9	Payments
9CSHRCTYP SearchCash Receipt TypeIntegerGB0
10CBKIDCRD SearchCheckbook ID Credit CardStringSTR15_Checkbook_ID15
11CBKIDCSH SearchCheckbook ID CashStringSTR15_Checkbook_ID15
12CBKIDCHK SearchCheckbook ID CheckStringSTR15_Checkbook_ID15
13DUEDATE SearchDue DateDateDT8
14DOCDATE SearchDocument DateDateDT8
15POSTDATE SearchPost DateDateDT_Date6
16PSTUSRID SearchPost User IDStringSTR1515
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['RM Open File'].PSTUSRID AS 'RM Open File-Post User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       RM20101 AS ['RM Open File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['RM Open File'].PSTUSRID = ['Users Master'].USERID
17GLPOSTDT SearchGL Posting DateDateDT8
18LSTEDTDT SearchLast Edit DateDateDT_Date6
19LSTUSRED SearchLast User to EditStringSTR1515
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['RM Open File'].LSTUSRED AS 'RM Open File-Last User to Edit'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       RM20101 AS ['RM Open File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['RM Open File'].LSTUSRED = ['Users Master'].USERID
20ORTRXAMT SearchOriginal Trx AmountCurrencyDLR17_RBS0_STR$17
21CURTRXAM SearchCurrent Trx AmountCurrencyDLR17_RBS0_UTR$17
22SLSAMNT SearchSales AmountCurrencyDLR19_RBSO_UTR$19
23COSTAMNT SearchCost AmountCurrencyDLR19_RBSO_UTR$19
24FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
25MISCAMNT SearchMisc AmountCurrencyDLR17_RBS0_UTR$17
26TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
27COMDLRAM SearchCommission Dollar AmountCurrencyDLR17_RBSO_STR$17
28CASHAMNT SearchCash AmountCurrencyDLR19_RBS0_UTR$19
29DISTKNAM SearchDiscount Taken AmountCurrencyDLR17_RBS0_UTR$17
30DISAVAMT SearchDiscount Available AmountCurrencyDLR17_RBS0_UTR$17
31DISAVTKN SearchDiscount Available TakenCurrencyDLR17_RBS0_UTR$17
32DISCRTND SearchDiscount ReturnedCurrencyDLR17_RBS0_STR$17
33DISCDATE SearchDiscount DateDateDT8
34DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
35DSCPCTAM SearchDiscount Percent AmountIntegerINT5_%25
36WROFAMNT SearchWrite Off AmountCurrencyDLR17_RBS0_STR$17
37TRXDSCRN SearchTransaction DescriptionStringSTR3030
38CSPORNBR SearchCustomer Purchase Order NumberStringDocument_Number20
39SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['RM Open File'].SLPRSNID AS 'RM Open File-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       RM20101 AS ['RM Open File']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['RM Open File'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
40SLSTERCD SearchSales Territory CodeStringSTR1515
41DINVPDOF SearchDate Invoice Paid OffDateDT8
42PPSAMDED SearchPPS Amount DeductedCurrencyDLR17_RBS0_UTR$17
43GSTDSAMT SearchGST Discount AmountCurrencyDLR17_RBS0_STR$17
44DELETE1 SearchDeleteBooleanYN0
45AGNGBUKT SearchAging BucketIntegerINT1_U01
46VOIDSTTS SearchVoid StatusIntegerINT0
47VOIDDATE SearchVoid DateDateDT8
48TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['RM Open File'].TAXSCHID AS 'RM Open File-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       RM20101 AS ['RM Open File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['RM Open File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
49CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['RM Open File'].CURNCYID AS 'RM Open File-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       RM20101 AS ['RM Open File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['RM Open File'].CURNCYID = ['Currency Setup'].CURNCYID
50PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['RM Open File'].PYMTRMID AS 'RM Open File-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       RM20101 AS ['RM Open File']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['RM Open File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
51SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['RM Open File'].SHIPMTHD AS 'RM Open File-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       RM20101 AS ['RM Open File']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['RM Open File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
52TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
53SLSCHDID SearchSales Schedule IDStringSTR15_LBU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['RM Open File'].SLSCHDID AS 'RM Open File-Sales Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       RM20101 AS ['RM Open File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['RM Open File'].SLSCHDID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
54FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['RM Open File'].FRTSCHID AS 'RM Open File-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       RM20101 AS ['RM Open File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['RM Open File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
55MSCSCHID SearchMisc Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['RM Open File'].MSCSCHID AS 'RM Open File-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       RM20101 AS ['RM Open File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['RM Open File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
56NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['RM Open File'].NOTEINDX AS 'RM Open File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       RM20101 AS ['RM Open File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['RM Open File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
57Tax_Date SearchTax DateDateDT8
58APLYWITH SearchApply WithholdingBooleanBoolean0
59SALEDATE SearchSale DateDateDT8
60CORRCTN SearchCorrectionBooleanCB_Correction0
61SIMPLIFD SearchSimplifiedBooleanCB_Simplified0
62Electronic SearchElectronicBooleanCB_Electronic0
63ECTRX SearchEC TransactionBooleanCB_EC_Transaction0
The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.

Click to show/hide Document Printed flag


0	Not an EU Transaction.
1	EU Transaction.
64BKTSLSAM SearchBackout Sales AmountCurrencyDLR19_RBS0_UTR$19
65BKTFRTAM SearchBackout Freight AmountCurrencyDLR19_RBS0_UTR$19
66BKTMSCAM SearchBackout Misc AmountCurrencyDLR19_RBS0_UTR$19
67BackoutTradeDisc SearchBackout Trade Discount AmountCurrencyDLR19_RBS0_UTR$19
68Factoring SearchFactoringBooleanboolean0
69DIRECTDEBIT SearchDirect DebitBooleanCB_DirectDebit0
70ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
71EFTFLAG SearchEFT FlagBooleanCB_EFT0
azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Open File Debit Copy (RM20101)

2 thoughts on “RM Open File Debit Copy (RM20101)

  1. Nipuni says:

    What are the other related table with RM_OPEN. Is there any header and line level tables related?
    I’m looking for SQL tables when saving credit memo document.

    Thanks

    1. iangrieve says:

      Clicking on the Group Display Name or Group Technical Name at the top of the page will show you the other tables in the group which will include headers, lines, taxes and so on.

Leave a Reply

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