PM20400 - PM Scheduled Payments Header | Prospr

PM20400 - PM Scheduled Payments Header

Select * from PM20400

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
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
NOTEINDX	Note Index	Currency	10	View
Status	Status	Integer	2	View
CREDIT_MEMO_DOC_NUM	Credit Memo Document Number	String	22	View
VADCDTRO	Vendor Address Code - Remit To	String	16	View