RM10201 - RM Cash Receipts Work File
Dynamics GP table RM10201 (RM Cash Receipts Work File) contains 32 columns including BACHNUMB, BCHSOURC, DOCNUMBR....
SQL Query Builder
32 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| BACHNUMB | Batch Number | String | 16 | ||
| BCHSOURC | Batch Source | String | 16 | ||
| DOCNUMBR | Document Number | String | 22 | ||
| CUSTNMBR | Customer Number | String | 16 | ||
| RMDTYPAL | RM Document Type-All0 = Reserved for balance carried forward records1 = Sales / Invoice2 = Reserved for schedule payments3 = Debit Memos4 = Finance Charges5 = Service Repairs6= Warranties7 = Credit Memos8 = Returns9 = Payments | Integer | 2 | ||
| DOCDATE | Document Date | Date | 4 | ||
| CSHRCTYP | Cash Receipt Type | Integer | 2 | ||
| CHEKNMBR | Check Number | String | 22 | ||
| CHEKBKID | Checkbook ID | String | 16 | ||
| CRCARDID | Credit Card ID | String | 16 | ||
| DISAMCHK | Discount Amount For Check | Currency | 10 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| NDSTAMNT | Non Distributed Amount | Currency | 10 | ||
| TRXDSCRN | Transaction Description | String | 32 | ||
| ONHOLD | On Hold | Integer | 2 | ||
| POSTED | Posted | Boolean | 2 | ||
| NOTEINDX | Note Index | Currency | 10 | ||
| LSTEDTDT | Last Edit Date | Date | 4 | ||
| LSTUSRED | Last User to Edit | String | 16 | ||
| ORTRXAMT | Original Trx Amount | Currency | 10 | ||
| CURTRXAM | Current Trx Amount | Currency | 10 | ||
| WROFAMNT | Write Off Amount | Currency | 10 | ||
| DISTKNAM | Discount Taken Amount | Currency | 10 | ||
| DISAVTKN | Discount Available Taken | Currency | 10 | ||
| PPSAMDED | PPS Amount Deducted | Currency | 10 | ||
| GSTDSAMT | GST Discount Amount | Currency | 10 | ||
| RMTREMSG | RM TRX Posting Error Messages | Long Integer | 4 | ||
| RMDPEMSG | RM Dist Posting Error Messages | Long Integer | 4 | ||
| GLPOSTDT | GL Posting Date | Date | 4 | ||
| RMTREMSG2 | RM TRX Posting Error Messages 2 | Long Integer | 4 | ||
| PSTGSTUS | Posting Status1 = Work2 = Open3 = History4 = Originating | Integer | 2 | ||
Posting Status values (11) 0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch | |||||
| EFTFLAG | EFT Flag | Boolean | 2 | ||
Related Tables
Tables that share columns with RM10201. Click "Join" to add to your query.