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 TypeLength
1BACHNUMB SearchBatch NumberStringSTR15_LBAU15
2BCHSOURC SearchBatch SourceStringSTR1515
3DOCNUMBR SearchDocument NumberStringSTR20_Document_Number20
4CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
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-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
6DOCDATE SearchDocument DateDateDT8
7CSHRCTYP SearchCash Receipt TypeIntegerGB0
8CHEKNMBR SearchCheck NumberStringSTR20_Document_Number20
9CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
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 IDStringSTR1515
11DISAMCHK SearchDiscount Amount For CheckCurrencyDLR17_RBS0_STR$17
12CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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 AmountCurrencyDLR17_RBS0_STR$17
14TRXDSCRN SearchTransaction DescriptionStringSTR3030
15ONHOLD SearchOn HoldIntegerGB0
16POSTED SearchPostedBooleanTrue/False0
17NOTEINDX SearchNote IndexCurrencyDLR1414
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 DateDateDT_Date6
19LSTUSRED SearchLast User to EditStringSTR1515
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 AmountCurrencyDLR17_RBS0_STR$17
21CURTRXAM SearchCurrent Trx AmountCurrencyDLR17_RBS0_UTR$17
22WROFAMNT SearchWrite Off AmountCurrencyDLR17_RBS0_STR$17
23DISTKNAM SearchDiscount Taken AmountCurrencyDLR17_RBS0_UTR$17
24DISAVTKN SearchDiscount Available TakenCurrencyDLR17_RBS0_UTR$17
25PPSAMDED SearchPPS Amount DeductedCurrencyDLR17_RBS0_UTR$17
26GSTDSAMT SearchGST Discount AmountCurrencyDLR17_RBS0_STR$17
27RMTREMSG SearchRM TRX Posting Error MessagesLong IntegerRM_TRX_Posting_Error_Messages0
28RMDPEMSG SearchRM Dist Posting Error MessagesLong IntegerRM_Dist_Posting_Error_Messages0
29GLPOSTDT SearchGL Posting DateDateDT8
30RMTREMSG2 SearchRM TRX Posting Error Messages 2Long IntegerRM_TRX_Posting_Error_Messages_20
31PSTGSTUS SearchPosting StatusIntegerINT0
32EFTFLAG SearchEFT FlagBooleanCB_EFT0
azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Cash Receipts Work File (RM10201)

Leave a Reply

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