RM10301 - RM Sales Work File
Dynamics GP table RM10301 (RM Sales Work File) contains 91 columns including DOCTYPE, RMDTYPAL, RMDNUMWK....
SQL Query Builder
91 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| DOCTYPE | Document Type1 = Sales / Invoice2 = Debit Memos3 = Finance Charges4 = Service/Repairs5 = Warranties6 = Credit Memo7= Returns | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| 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 | ||
| RMDNUMWK | RM Document Number-WORK | String | 18 | ||
| DOCNUMBR | Document Number | String | 22 | ||
| DOCPRFIX | Document Prefix | String | 4 | ||
| DOCDESCR | Document Description | String | 32 | ||
| DOCDATE | Document Date | Date | 4 | ||
| BACHNUMB | Batch Number | String | 16 | ||
| BCHSOURC | Batch Source | String | 16 | ||
| NOTEINDX | Note Index | Currency | 10 | ||
| CUSTNMBR | Customer Number | String | 16 | ||
| CUSTNAME | Customer Name | String | 66 | ||
| ADRSCODE | Address Code | String | 16 | ||
| SLPRSNID | Salesperson ID | String | 16 | ||
| SALSTERR | Sales Territory | String | 16 | ||
| COMAPPTO | Commission Applied To | Integer | 2 | ||
| COMDLRAM | Commission Dollar Amount | Currency | 10 | ||
| NCOMAMNT | Non-Commissioned Amount | Currency | 10 | ||
| SHIPMTHD | Shipping Method | String | 16 | ||
| CSTPONBR | Customer PO Number | String | 22 | ||
| TAXSCHID | Tax Schedule ID | String | 16 | ||
| SLSCHDID | Sales Schedule ID | String | 16 | ||
| FRTSCHID | Freight Schedule ID | String | 16 | ||
| MSCSCHID | Misc Schedule ID | String | 16 | ||
| COSTAMNT | Cost Amount | Currency | 10 | ||
| SLSAMNT | Sales Amount | Currency | 10 | ||
| TRDISAMT | Trade Discount Amount | Currency | 10 | ||
| TRDDISCT | Trade Discount | Integer | 2 | ||
| FRTAMNT | Freight Amount | Currency | 10 | ||
| MISCAMNT | Misc Amount | Currency | 10 | ||
| TAXAMNT | Tax Amount | Currency | 10 | ||
| BKTSLSAM | Backout Sales Amount | Currency | 10 | ||
| BKTFRTAM | Backout Freight Amount | Currency | 10 | ||
| BKTMSCAM | Backout Misc Amount | Currency | 10 | ||
| TXENGCLD | Tax Engine Called | Boolean | 2 | ||
| DOCAMNT | Document Amount | Currency | 10 | ||
| APPLDAMT | Applied Amount | Currency | 10 | ||
| CASHAMNT | Cash Amount | Currency | 10 | ||
| CBKIDCSH | Checkbook ID Cash | String | 16 | ||
| CASHDATE | Cash Date | Date | 4 | ||
| DCNUMCSH | Document Number Cash | String | 22 | ||
| CHEKAMNT | Check Amount | Currency | 10 | ||
| CBKIDCHK | Checkbook ID Check | String | 16 | ||
| CBKIDCRD | Checkbook ID Credit Card | String | 16 | ||
| CHEKNMBR | Check Number | String | 22 | ||
| CHEKDATE | Check Date | Date | 4 | ||
| DCNUMCHK | Document Number Check | String | 22 | ||
| CRCRDAMT | Credit Card Amount | Currency | 10 | ||
| CRCRDNAM | Credit Card Name | String | 16 | ||
| RCTNCCRD | Receipt Number Credit Card | String | 22 | ||
| CRCARDDT | Credit Card Date | Date | 4 | ||
| DCNUMCRD | Document Number Credit Card | String | 22 | ||
| DISCRTND | Discount Returned | Currency | 10 | ||
| DISTKNAM | Discount Taken Amount | Currency | 10 | ||
| DISAVTKN | Discount Available Taken | Currency | 10 | ||
| WROFAMNT | Write Off Amount | Currency | 10 | ||
| PPSAMDED | PPS Amount Deducted | Currency | 10 | ||
| GSTDSAMT | GST Discount Amount | Currency | 10 | ||
| ACCTAMNT | Account Amount | Currency | 10 | ||
| PYMTRMID | Payment Terms ID | String | 22 | ||
| DISAVAMT | Discount Available Amount | Currency | 10 | ||
| DISCDATE | Discount Date | Date | 4 | ||
| DUEDATE | Due Date | Date | 4 | ||
| DSCDLRAM | Discount Dollar Amount | Currency | 10 | ||
| DSCPCTAM | Discount Percent Amount | Integer | 2 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| POSTED | Posted | Boolean | 2 | ||
| LSTEDTDT | Last Edit Date | Date | 4 | ||
| LSTUSRED | Last User to Edit | String | 16 | ||
| RMTREMSG | RM TRX Posting Error Messages | Long Integer | 4 | ||
| RMDPEMSG | RM Dist Posting Error Messages | Long Integer | 4 | ||
| GLPOSTDT | GL Posting Date | Date | 4 | ||
| POSTEDDT | Posted Date | Date | 4 | ||
| PTDUSRID | Posted User ID | String | 16 | ||
| Tax_Date | Tax Date | Date | 4 | ||
| APLYWITH | Apply Withholding | Boolean | 2 | ||
| SALEDATE | Sale Date | Date | 4 | ||
| CORRCTN | Correction | Boolean | 2 | ||
| SIMPLIFD | Simplified | Boolean | 2 | ||
| CORRNXST | Correction to Nonexisting Transaction | Boolean | 2 | ||
| DOCNCORR | Document Number Corrected | String | 22 | ||
| RMTREMSG2 | RM TRX Posting Error Messages 2 | Long Integer | 4 | ||
| DocPrinted | DocPrinted | Boolean | 2 | ||
| DISGRPER | Discount Grace Period | Integer | 2 | ||
| DUEGRPER | Due Date Grace Period | Integer | 2 | ||
| Electronic | Electronic | Boolean | 2 | ||
| ECTRX | EC Transaction | Boolean | 2 | ||
| 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 | |||||
| BackoutTradeDisc | Backout Trade Discount Amount | Currency | 10 | ||
| DIRECTDEBIT | Direct Debit | Boolean | 2 | ||
| EFTFLAG | EFT Flag | Boolean | 2 | ||
Related Tables
Tables that share columns with RM10301. Click "Join" to add to your query.