RM10301 - RM Sales Work File | Prospr - Dynamics GP Table Reference

RM10301 - RM Sales Work File

Query Builder

Select * from RM10301

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DOCTYPE	Document Type 1 = Sales / Invoice 2 = Debit Memos 3 = Finance Charges 4 = Service/Repairs 5 = Warranties 6 = Credit Memo 7= Returns	Integer	2	View
RMDTYPAL	RM Document Type-All 0 = Reserved for balance carried forward records 1 = Sales / Invoice 2 = Reserved for schedule payments 3 = Debit Memos 4 = Finance Charges 5 = Service Repairs 6= Warranties 7 = Credit Memos 8 = Returns 9 = Payments	Integer	2	View
RMDNUMWK	RM Document Number-WORK	String	18	View
DOCNUMBR	Document Number	String	22	View
DOCPRFIX	Document Prefix	String	4	View
DOCDESCR	Document Description	String	32	View
DOCDATE	Document Date	Date	4	View
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
NOTEINDX	Note Index	Currency	10	View
CUSTNMBR	Customer Number	String	16	View
CUSTNAME	Customer Name	String	66	View
ADRSCODE	Address Code	String	16	View
SLPRSNID	Salesperson ID	String	16	View
SALSTERR	Sales Territory	String	16	View
COMAPPTO	Commission Applied To	Integer	2	View
COMDLRAM	Commission Dollar Amount	Currency	10	View
NCOMAMNT	Non-Commissioned Amount	Currency	10	View
SHIPMTHD	Shipping Method	String	16	View
CSTPONBR	Customer PO Number	String	22	View
TAXSCHID	Tax Schedule ID	String	16	View
SLSCHDID	Sales Schedule ID	String	16	View
FRTSCHID	Freight Schedule ID	String	16	View
MSCSCHID	Misc Schedule ID	String	16	View
COSTAMNT	Cost Amount	Currency	10	View
SLSAMNT	Sales Amount	Currency	10	View
TRDISAMT	Trade Discount Amount	Currency	10	View
TRDDISCT	Trade Discount	Integer	2	View
FRTAMNT	Freight Amount	Currency	10	View
MISCAMNT	Misc Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
BKTSLSAM	Backout Sales Amount	Currency	10	View
BKTFRTAM	Backout Freight Amount	Currency	10	View
BKTMSCAM	Backout Misc Amount	Currency	10	View
TXENGCLD	Tax Engine Called	Boolean	2	View
DOCAMNT	Document Amount	Currency	10	View
APPLDAMT	Applied Amount	Currency	10	View
CASHAMNT	Cash Amount	Currency	10	View
CBKIDCSH	Checkbook ID Cash	String	16	View
CASHDATE	Cash Date	Date	4	View
DCNUMCSH	Document Number Cash	String	22	View
CHEKAMNT	Check Amount	Currency	10	View
CBKIDCHK	Checkbook ID Check	String	16	View
CBKIDCRD	Checkbook ID Credit Card	String	16	View
CHEKNMBR	Check Number	String	22	View
CHEKDATE	Check Date	Date	4	View
DCNUMCHK	Document Number Check	String	22	View
CRCRDAMT	Credit Card Amount	Currency	10	View
CRCRDNAM	Credit Card Name	String	16	View
RCTNCCRD	Receipt Number Credit Card	String	22	View
CRCARDDT	Credit Card Date	Date	4	View
DCNUMCRD	Document Number Credit Card	String	22	View
DISCRTND	Discount Returned	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
DISAVTKN	Discount Available Taken	Currency	10	View
WROFAMNT	Write Off Amount	Currency	10	View
PPSAMDED	PPS Amount Deducted	Currency	10	View
GSTDSAMT	GST Discount Amount	Currency	10	View
ACCTAMNT	Account Amount	Currency	10	View
PYMTRMID	Payment Terms ID	String	22	View
DISAVAMT	Discount Available Amount	Currency	10	View
DISCDATE	Discount Date	Date	4	View
DUEDATE	Due Date	Date	4	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
DSCPCTAM	Discount Percent Amount	Integer	2	View
CURNCYID	Currency ID	String	16	View
POSTED	Posted	Boolean	2	View
LSTEDTDT	Last Edit Date	Date	4	View
LSTUSRED	Last User to Edit	String	16	View
RMTREMSG	RM TRX Posting Error Messages	Long Integer	4	View
RMDPEMSG	RM Dist Posting Error Messages	Long Integer	4	View
GLPOSTDT	GL Posting Date	Date	4	View
POSTEDDT	Posted Date	Date	4	View
PTDUSRID	Posted User ID	String	16	View
Tax_Date	Tax Date	Date	4	View
APLYWITH	Apply Withholding	Boolean	2	View
SALEDATE	Sale Date	Date	4	View
CORRCTN	Correction	Boolean	2	View
SIMPLIFD	Simplified	Boolean	2	View
CORRNXST	Correction to Nonexisting Transaction	Boolean	2	View
DOCNCORR	Document Number Corrected	String	22	View
RMTREMSG2	RM TRX Posting Error Messages 2	Long Integer	4	View
DocPrinted	DocPrinted	Boolean	2	View
DISGRPER	Discount Grace Period	Integer	2	View
DUEGRPER	Due Date Grace Period	Integer	2	View
Electronic	Electronic	Boolean	2	View
ECTRX	EC Transaction	Boolean	2	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
BackoutTradeDisc	Backout Trade Discount Amount	Currency	10	View
DIRECTDEBIT	Direct Debit	Boolean	2	View
EFTFLAG	EFT Flag	Boolean	2	View

RM10301 - RM Sales Work File

Query Builder

Customer Service

Information

My Account

Contact Us