RM20401 - RM Scheduled Payment Line | Prospr - Dynamics GP Table Reference

RM20401 - RM Scheduled Payment Line

Query Builder

Select * from RM20401

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
SCHEDULE_NUMBER	Schedule Number	String	22	View
DOCNUMBR	Document Number	String	22	View
Schedule_Payment_Number	Schedule Payment Number	Integer	2	View
CUSTNMBR	Customer Number	String	16	View
PAYMENT_AMOUNT	Payment Amount	Currency	10	View
INTEREST_AMOUNT	Interest Amount	Currency	10	View
PRINCIPAL_AMOUNT	Principal Amount	Currency	10	View
PRINCIPAL_BALANCE	Principal Balance	Currency	10	View
DUEDATE	Due Date	Date	4	View
DOCDATE	Document Date	Date	4	View
Status	Status	Integer	2	View
MARKED	Marked	Boolean	2	View
MKDBYUSR	Marked By User	String	16	View