RM Cash Receipts Work File (RM10201)

azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Cash Receipts Work File (RM10201)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Cash Receipts Work File
Physical Name: RM10201
Technical Name: RM_Cash_WORK

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1BACHNUMB SearchBatch NumberSTR15_LBAUString1615
2BCHSOURC SearchBatch SourceSTR15String1615
3DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
4CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['RM Cash Receipts Work File'].CUSTNMBR AS 'RM Cash Receipts Work File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       RM10201 AS ['RM Cash Receipts Work File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['RM Cash Receipts Work File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
5RMDTYPAL SearchRM Document Type-AllINT2Integer22
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
6DOCDATE SearchDocument DateDTDate48
7CSHRCTYP SearchCash Receipt TypeGBInteger20
8CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
9CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['RM Cash Receipts Work File'].CHEKBKID AS 'RM Cash Receipts Work File-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       RM10201 AS ['RM Cash Receipts Work File']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['RM Cash Receipts Work File'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
10CRCARDID SearchCredit Card IDSTR15String1615
11DISAMCHK SearchDiscount Amount For CheckDLR17_RBS0_STR$Currency1017
12CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['RM Cash Receipts Work File'].CURNCYID AS 'RM Cash Receipts Work File-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       RM10201 AS ['RM Cash Receipts Work File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['RM Cash Receipts Work File'].CURNCYID = ['Currency Setup'].CURNCYID
13NDSTAMNT SearchNon Distributed AmountDLR17_RBS0_STR$Currency1017
14TRXDSCRN SearchTransaction DescriptionSTR30String3230
15ONHOLD SearchOn HoldGBInteger20
16POSTED SearchPostedTrue/FalseBoolean20
17NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['RM Cash Receipts Work File'].NOTEINDX AS 'RM Cash Receipts Work File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       RM10201 AS ['RM Cash Receipts Work File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['RM Cash Receipts Work File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
18LSTEDTDT SearchLast Edit DateDT_DateDate46
19LSTUSRED SearchLast User to EditSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['RM Cash Receipts Work File'].LSTUSRED AS 'RM Cash Receipts Work File-Last User to Edit'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       RM10201 AS ['RM Cash Receipts Work File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['RM Cash Receipts Work File'].LSTUSRED = ['Users Master'].USERID
20ORTRXAMT SearchOriginal Trx AmountDLR17_RBS0_STR$Currency1017
21CURTRXAM SearchCurrent Trx AmountDLR17_RBS0_UTR$Currency1017
22WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
23DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
24DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency1017
25PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency1017
26GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency1017
27RMTREMSG SearchRM TRX Posting Error MessagesRM_TRX_Posting_Error_MessagesLong Integer40
28RMDPEMSG SearchRM Dist Posting Error MessagesRM_Dist_Posting_Error_MessagesLong Integer40
29GLPOSTDT SearchGL Posting DateDTDate48
30RMTREMSG2 SearchRM TRX Posting Error Messages 2RM_TRX_Posting_Error_Messages_2Long Integer40
31PSTGSTUS SearchPosting StatusINTInteger20
32EFTFLAG SearchEFT FlagCB_EFTBoolean20
33DEX_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.

azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Cash Receipts Work File (RM10201)

Leave a Reply

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