PMV0100 - PM Scheduled Payment Header View | Prospr

PMV0100 - PM Scheduled Payment Header View

Select * from PMV0100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
VENDNAME	Vendor Name	String	66	View
SCHEDULE_NUMBER	Schedule Number	String	22	View
SCHEDULE_DESC	Schedule Description	String	32	View
ORIG_DOC_NUMBER	Original Document Number	String	22	View
ORIG_DOC_TYPE	Original Document Type	Integer	2	View
ORIG_VOUCHER_NUM	Original Voucher Number	String	22	View
VENDORID	Vendor ID	String	16	View
SCH_DOC_DATE	Schedule Document Date	Date	4	View
SCHEDULE_AMOUNT	Schedule Amount	Currency	10	View
FuncSchAmnt	Functional Schedule Amount	Currency	10	View
CURNCYID	Currency ID	String	16	View
SCHEDULE_INT_TYPE1	Schedule Interest Type	Integer	2	View
SCHEDULE_INT_RATE	Schedule Interest Rate	Long Integer	4	View
NUM_PAYMENTS	Number of Payments	Integer	2	View
PYMNT_FREQUENCY	Payment Frequency	Integer	2	View
PAYMENT_AMOUNT	Payment Amount	Currency	10	View
FIRST_INV_DOC_DATE	First Invoice Document Date	Date	4	View
FIRST_INV_DUE_DATE	First Invoice Due Date	Date	4	View
PAY_ACCT_IDX	Account Payable Account Index	Long Integer	4	View
PAY_OFFSET_ACCT_IDX	Payables Offset Account Index	Long Integer	4	View
INT_EXP_ACCT_IDX	Interest Expense Account Index	Long Integer	4	View
CREDIT_MEMO_DOC_NUM	Credit Memo Document Number	String	22	View
Status	Status	Integer	2	View
NOTEINDX	Note Index	Currency	10	View
VADCDTRO	Vendor Address Code - Remit To	String	16	View