RM10201 - RM Cash Receipts Work File | Prospr

RM10201 - RM Cash Receipts Work File

Query Builder

Select * from RM10201

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
DOCNUMBR	Document Number	String	22	View
CUSTNMBR	Customer 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
DOCDATE	Document Date	Date	4	View
CSHRCTYP	Cash Receipt Type	Integer	2	View
CHEKNMBR	Check Number	String	22	View
CHEKBKID	Checkbook ID	String	16	View
CRCARDID	Credit Card ID	String	16	View
DISAMCHK	Discount Amount For Check	Currency	10	View
CURNCYID	Currency ID	String	16	View
NDSTAMNT	Non Distributed Amount	Currency	10	View
TRXDSCRN	Transaction Description	String	32	View
ONHOLD	On Hold	Integer	2	View
POSTED	Posted	Boolean	2	View
NOTEINDX	Note Index	Currency	10	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
WROFAMNT	Write Off Amount	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
DISAVTKN	Discount Available Taken	Currency	10	View
PPSAMDED	PPS Amount Deducted	Currency	10	View
GSTDSAMT	GST Discount Amount	Currency	10	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
RMTREMSG2	RM TRX Posting Error Messages 2	Long Integer	4	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
EFTFLAG	EFT Flag	Boolean	2	View

RM10201 - RM Cash Receipts Work File

Query Builder

Customer Service

Information

My Account

Contact Us