PM20401 - PM Scheduled Payment LINE | Prospr - Dynamics GP Table Reference

PM20401 - PM Scheduled Payment LINE

Query Builder

Select * from PM20401

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