RVLPD010 - Sales Payment Document HISTORY | Prospr

RVLPD010 - Sales Payment Document HISTORY

Query Builder

Select * from RVLPD010

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
RMDTYPAL	RM Document Type-All 0 = Reserved for balance carried forward records 1 = Sales / Invoice 2 = Reserved for schedule payments 3 = Debit Memos 4 = Finance Charges 5 = Service Repairs 6= Warranties 7 = Credit Memos 8 = Returns 9 = Payments	Integer	2	View
DOCNUMBR	Document Number	String	22	View
CUSTNMBR	Customer Number	String	16	View
CUSTNAME	Customer Name	String	66	View
STMTNAME	Statement Name	String	66	View
PMTDOCID	PmntDocID	String	16	View
CHEKNMBR	Check Number	String	22	View
PDOCSTRM	PmntDocStateRM	Integer	2	View
CHEKBKID	Checkbook ID	String	16	View
DOCDATE	Document Date	Date	4	View
DUEDATE	Due Date	Date	4	View
DOCAMNT	Document Amount	Currency	10	View
ORDOCAMT	Originating Document Amount	Currency	10	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
TRXDSCRN	Transaction Description	String	32	View
NOTEINDX	Note Index	Currency	10	View
VALSTRG1	ValueUserDefnStr1	String	66	View
VALSTRG2	ValueUserDefnStr2	String	66	View
VALSTRG3	ValueUserDefnStr3	String	66	View
VALSTRG4	ValueUserDefnStr4	String	66	View
VALSTRG5	ValueUserDefnStr5	String	66	View
VALSTRG6	ValueUserDefnStr6	String	66	View
VALDATE1	ValueUserDefnDate1	Date	4	View
VALDATE2	ValueUserDefnDate2	Date	4	View
VALCURR1	ValueUserDefnCurr1	Currency	10	View
VALCURR2	ValueUserDefnCurr2	Currency	10	View
VALBACT1	ValueUserDefnBankAcct1	String	36	View
VALBACT2	ValueUserDefnBankAcct2	String	36	View
TRXSORCE	TRX Source	String	14	View
MKDBYUSR	Marked By User	String	16	View
MKTOPROC	Marked To Process	Boolean	2	View
REMTYPE	RemitType	Integer	2	View
REMITID	RemitID	String	16	View
CMRecordNumber	CMRecordNumber	Currency	10	View

RVLPD010 - Sales Payment Document HISTORY

Query Builder

Customer Service

Information

My Account

Contact Us