RM20102 - RM Realtime Posting File | Prospr - Dynamics GP Table Reference

RM20102 - RM Realtime Posting File

Select * from RM20102

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CUSTNMBR	Customer Number	String	16	View
DOCNUMBR	Document Number	String	22	View
BACHNUMB	Batch Number	String	16	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
DISTKNAM	Discount Taken Amount	Currency	10	View
WROFAMNT	Write Off Amount	Currency	10	View
USERID	User ID	String	16	View
BCHSOURC	Batch Source	String	16	View
APTODCNM	Apply To Document Number	String	22	View
APTODCTY	Apply To Document Type	Integer	2	View
DISAVTKN	Discount Available Taken	Currency	10	View
ORDISTKN	Originating Discount Taken Amount	Currency	10	View
ORDATKN	Originating Discount Available Taken	Currency	10	View
ORWROFAM	Originating Write Off Amount	Currency	10	View
RLGANLOS	Realized Gain-Loss Amount	Currency	10	View
FuncRndAmt	FuncRndAmt	Currency	10	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View