RM50104 - RM Email Statements Transactions Temporary File
Dynamics GP table RM50104 (RM Email Statements Transactions Temporary File) contains 24 columns including CUSTNMBR, DSCRIPTN, CURNCYID....
SQL Query Builder
24 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| CUSTNMBR | Customer Number | String | 16 | |
| DSCRIPTN | Description | String | 32 | |
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | |
| CURRNIDX | Currency Index | Integer | 2 | |
| DOCDATE | Document Date | Date | 4 | |
| DOCNUMBR | Document Number | String | 22 | |
| DOCPRFIX | Document Prefix | String | 4 | |
| 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 | |
| DOCDESCR | Document Description | String | 32 | |
| PORDNMBR | Purchase Order Number | String | 22 | |
| DOCAMNT | Document Amount | Currency | 10 | |
| Credit_Amount_String_30 | Credit Amount String 30 | String | 32 | |
| DEBITAMT | Debit Amount | Currency | 10 | |
| BALNCDUE | Balance Due | Currency | 10 | |
| AGNGBUKT | Aging Bucket | Integer | 2 | |
| CRDTAMNT | Credit Amount | Currency | 10 | |
| CHCUMNUM | Child Customer Number | String | 16 | |
| CHCUMNAM | Child Customer Name | String | 66 | |
| CURTRXAM | Current Trx Amount | Currency | 10 | |
| AMNTPAID | Amount Paid | Currency | 10 | |
| RNNMBR | Run Number | Long Integer | 4 | |
| SEQNUMBR | Sequence Number | Long Integer | 4 | |
| USERID | User ID | String | 16 | |
| Process_Index | Process Index | Long Integer | 4 |
Related Tables
Tables that share columns with RM50104. Click "Join" to add to your query.