RM20101 - RM Open File | Prospr - Dynamics GP Table Reference

RM20101 - RM Open File

Query Builder

Select * from RM20101

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CUSTNMBR	Customer Number	String	16	View
CPRCSTNM	Corporate Customer Number	String	16	View
DOCNUMBR	Document Number	String	22	View
CHEKNMBR	Check Number	String	22	View
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
TRXSORCE	TRX Source	String	14	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
CSHRCTYP	Cash Receipt Type	Integer	2	View
CBKIDCRD	Checkbook ID Credit Card	String	16	View
CBKIDCSH	Checkbook ID Cash	String	16	View
CBKIDCHK	Checkbook ID Check	String	16	View
DUEDATE	Due Date	Date	4	View
DOCDATE	Document Date	Date	4	View
POSTDATE	Post Date	Date	4	View
PSTUSRID	Post User ID	String	16	View
GLPOSTDT	GL Posting Date	Date	4	View
LSTEDTDT	Last Edit Date	Date	4	View
LSTUSRED	Last User to Edit	String	16	View
ORTRXAMT	Original Trx Amount	Currency	10	View
CURTRXAM	Current Trx Amount	Currency	10	View
SLSAMNT	Sales Amount	Currency	10	View
COSTAMNT	Cost Amount	Currency	10	View
FRTAMNT	Freight Amount	Currency	10	View
MISCAMNT	Misc Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
COMDLRAM	Commission Dollar Amount	Currency	10	View
CASHAMNT	Cash Amount	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
DISAVAMT	Discount Available Amount	Currency	10	View
DISAVTKN	Discount Available Taken	Currency	10	View
DISCRTND	Discount Returned	Currency	10	View
DISCDATE	Discount Date	Date	4	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
DSCPCTAM	Discount Percent Amount	Integer	2	View
WROFAMNT	Write Off Amount	Currency	10	View
TRXDSCRN	Transaction Description	String	32	View
CSPORNBR	Customer Purchase Order Number	String	22	View
SLPRSNID	Salesperson ID	String	16	View
SLSTERCD	Sales Territory Code	String	16	View
DINVPDOF	Date Invoice Paid Off	Date	4	View
PPSAMDED	PPS Amount Deducted	Currency	10	View
GSTDSAMT	GST Discount Amount	Currency	10	View
DELETE1	Delete	Boolean	2	View
AGNGBUKT	Aging Bucket	Integer	2	View
VOIDSTTS	Void Status 0 = Document has not been voided. 1 = Document has been voided. 2 = Document has been marked NSF and voided.	Integer	2	View
VOIDDATE	Void Date	Date	4	View
TAXSCHID	Tax Schedule ID	String	16	View
CURNCYID	Currency ID	String	16	View
PYMTRMID	Payment Terms ID	String	22	View
SHIPMTHD	Shipping Method	String	16	View
TRDISAMT	Trade Discount Amount	Currency	10	View
SLSCHDID	Sales Schedule ID	String	16	View
FRTSCHID	Freight Schedule ID	String	16	View
MSCSCHID	Misc Schedule ID	String	16	View
NOTEINDX	Note Index	Currency	10	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
Electronic	Electronic	Boolean	2	View
ECTRX	EC Transaction	Boolean	2	View
BKTSLSAM	Backout Sales Amount	Currency	10	View
BKTFRTAM	Backout Freight Amount	Currency	10	View
BKTMSCAM	Backout Misc Amount	Currency	10	View
BackoutTradeDisc	Backout Trade Discount Amount	Currency	10	View
Factoring	Factoring	Boolean	2	View
DIRECTDEBIT	Direct Debit	Boolean	2	View
ADRSCODE	Address Code	String	16	View
EFTFLAG	EFT Flag	Boolean	2	View

RM20101 - RM Open File

Query Builder

Customer Service

Information

My Account

Contact Us