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 Group Display Name: Receivables Open Transaction Files
Physical Name: RM10201
Technical Name: RM_Cash_WORK
Group Technical Name: RM_Open_Transaction_Logical_File
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
2 | BCHSOURC | Batch Source | String | STR15 | 15 | |
3 | DOCNUMBR | Document Number | String | STR20_Document_Number | 20 | |
4 | CUSTNMBR | Customer Number | String | STR15_RM_Customer_Number | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['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 | ||||||
5 | RMDTYPAL | RM Document Type-All | Integer | INT2 | 2 | |
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 | ||||||
6 | DOCDATE | Document Date | Date | DT | 8 | |
7 | CSHRCTYP | Cash Receipt Type | Integer | GB | 0 | |
8 | CHEKNMBR | Check Number | String | STR20_Document_Number | 20 | |
9 | CHEKBKID | Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['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 | ||||||
10 | CRCARDID | Credit Card ID | String | STR15 | 15 | |
11 | DISAMCHK | Discount Amount For Check | Currency | DLR17_RBS0_STR$ | 17 | |
12 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['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 | ||||||
13 | NDSTAMNT | Non Distributed Amount | Currency | DLR17_RBS0_STR$ | 17 | |
14 | TRXDSCRN | Transaction Description | String | STR30 | 30 | |
15 | ONHOLD | On Hold | Integer | GB | 0 | |
16 | POSTED | Posted | Boolean | True/False | 0 | |
17 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['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 | ||||||
18 | LSTEDTDT | Last Edit Date | Date | DT_Date | 6 | |
19 | LSTUSRED | Last User to Edit | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
20 | ORTRXAMT | Original Trx Amount | Currency | DLR17_RBS0_STR$ | 17 | |
21 | CURTRXAM | Current Trx Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
22 | WROFAMNT | Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
23 | DISTKNAM | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
24 | DISAVTKN | Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
25 | PPSAMDED | PPS Amount Deducted | Currency | DLR17_RBS0_UTR$ | 17 | |
26 | GSTDSAMT | GST Discount Amount | Currency | DLR17_RBS0_STR$ | 17 | |
27 | RMTREMSG | RM TRX Posting Error Messages | Long Integer | RM_TRX_Posting_Error_Messages | 0 | |
28 | RMDPEMSG | RM Dist Posting Error Messages | Long Integer | RM_Dist_Posting_Error_Messages | 0 | |
29 | GLPOSTDT | GL Posting Date | Date | DT | 8 | |
30 | RMTREMSG2 | RM TRX Posting Error Messages 2 | Long Integer | RM_TRX_Posting_Error_Messages_2 | 0 | |
31 | PSTGSTUS | Posting Status | Integer | INT | 0 | |
32 | EFTFLAG | EFT Flag | Boolean | CB_EFT | 0 |