CFM20101 - CFM RM OPEN | Prospr - Dynamics GP Table Reference

CFM20101 - CFM RM OPEN

Select * from CFM20101

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CUSTNMBR	Customer Number	String	16	View
DOCNUMBR	Document Number	String	22	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
DUEDATE	Due Date	Date	4	View
DOCDATE	Document Date	Date	4	View
ORTRXAMT	Original Trx Amount	Currency	10	View
CURTRXAM	Current Trx Amount	Currency	10	View
TRXDSCRN	Transaction Description	String	32	View