RM30301 - Receivables GL Distribution History | Prospr

RM30301 - Receivables GL Distribution History

Select * from RM30301

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
TRXSORCE	TRX Source	String	14	View
POSTEDDT	Posted Date	Date	4	View
DOCNUMBR	Document Number	String	22	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