RM50505 - RM_PMatch_TRX_WORK | Prospr - Dynamics GP Table Reference

RM50505 - RM_PMatch_TRX_WORK

Select * from RM50505

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
POSTEDDT	Posted Date	Date	4	View
CUSTNMBR	Customer Number	String	16	View
TRXSORCE	TRX Source	String	14	View
ORTRXSRC	Originating TRX Source	String	14	View
DOCNUMBR	Document Number	String	22	View
STRVAL	StringValue	String	134	View
TRX_ID	TRX ID	String	20	View
ACCTAMNT	Account Amount	Currency	10	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