RM10101 - RM Distribution Work File | Prospr - Dynamics GP Table Reference

RM10101 - RM Distribution Work File

Select * from RM10101

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
TRXSORCE	TRX Source	String	14	View
POSTED	Posted	Boolean	2	View
POSTEDDT	Posted Date	Date	4	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
CHANGED	Changed	Boolean	2	View
DOCNUMBR	Document Number	String	22	View
DCSTATUS	Document Status 1 = Work 2 = Open 3 = History	Integer	2	View
DISTTYPE	Distribution Type 1 = Cash 2 = Payable 3 = Discount Available 4 = Discount Taken 5 = Finance Charge 6 = Purchase 8 = Misc. Charge 9 = Freight 10 = Taxes 11 = Writeoffs 12 = Other 13 = GST Disc	Integer	2	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
SEQNUMBR	Sequence Number	Long Integer	4	View
CUSTNMBR	Customer Number	String	16	View
DSTINDX	Distribution Account Index	Long Integer	4	View
DEBITAMT	Debit Amount	Currency	10	View
CRDTAMNT	Credit Amount	Currency	10	View
PROJCTID	Project ID	String	16	View
USERID	User ID	String	16	View
CATEGUSD	Category Used	Integer	2	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
ORCRDAMT	Originating Credit Amount	Currency	10	View
ORDBTAMT	Originating Debit Amount	Currency	10	View
DistRef	Distribution Reference	String	32	View