CFM20101 - CFM RM OPEN
Dynamics GP table CFM20101 (CFM RM OPEN) contains 8 columns including CUSTNMBR, DOCNUMBR, RMDTYPAL....
SQL Query Builder
8 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| CUSTNMBR | Customer Number | String | 16 | |
| DOCNUMBR | Document Number | String | 22 | |
| 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 | |
| DUEDATE | Due Date | Date | 4 | |
| DOCDATE | Document Date | Date | 4 | |
| ORTRXAMT | Original Trx Amount | Currency | 10 | |
| CURTRXAM | Current Trx Amount | Currency | 10 | |
| TRXDSCRN | Transaction Description | String | 32 |
Related Tables
Tables that share columns with CFM20101. Click "Join" to add to your query.