RM30401 - RM Scheduled Payment Header History | Prospr

RM30401 - RM Scheduled Payment Header History

Select * from RM30401

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
CUSTNMBR	Customer Number	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
REC_ACCT_IDX	Account Receivable Account Index	Long Integer	4	View
REC_OFFSET_ACCT_IDX	Receivables Offset Account Index	Long Integer	4	View
INT_INCOME_ACCT_IDX	Interest Income Account Index	Long Integer	4	View
CREDIT_MEMO_DOC_NUM	Credit Memo Document Number	String	22	View
NOTEINDX	Note Index	Currency	10	View
Status	Status	Integer	2	View