RVLPD027 - Purchasing Payment Document Settlement Header | Prospr

RVLPD027 - Purchasing Payment Document Settlement Header

Select * from RVLPD027

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
REMTYPE	RemitType	Integer	2	View
REMITID	RemitID	String	16	View
PMTDOCID	PmntDocID	String	16	View
OrigPmntDocStatus	OrigPmntDocStatus	Integer	2	View
ORICBOOK	OrigCheckbookID	String	16	View
DESCBOOK	DestCheckbookID	String	16	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
MCSTRUCT_1	MC Def Structure:Currency ID	String	16	View
MCSTRUCT_2	MC Def Structure:Currency Index	Integer	2	View
MCSTRUCT_3	MC Def Structure:Rate Type ID	String	16	View
MCSTRUCT_4	MC Def Structure:Exchange Table ID	String	16	View
MCSTRUCT_5	MC Def Structure:Exchange Rate	Currency (Variable)	10	View
MCSTRUCT_6	MC Def Structure:Exchange Date	Date	4	View
MCSTRUCT_7	MC Def Structure:Decimal Places	Integer	2	View
MCSTRUCT_8	MC Def Structure:Time	Time	4	View
MCSTRUCT_9	MC Def Structure:Rate Calc Method	Integer	2	View
MCSTRUCT_10	MC Def Structure:View Mode	Integer	2	View
MCSTRUCT_11	MC Def Structure:IS MC Trx	Integer	2	View
MCSTRUCT_12	MC Def Structure:Expiration Date	Date	4	View
MCSTRUCT_13	MC Def Structure:Denomination Exchange Rate	Currency (Variable)	10	View
MCSTRUCT_14	MC Def Structure:MC Transaction State	Integer	2	View
TRXDATE	TRX Date	Date	4	View
PSTGDATE	Posting Date	Date	4	View
BANKACCT	BankAcct	String	36	View
COMMAMNT	Commission Amount	Currency	10	View
ACTINDX	Account Index	Long Integer	4	View
REMTSTAT	RemitStatus	Integer	2	View
NUMOFTRX	Number Of TRX	Long Integer	4	View
FUNCTAMT	Functional Amount	Currency	10	View
ORIGAMT	Originating Amount	Currency	10	View
CMRecordNumber	CMRecordNumber	Currency	10	View
NOTEINDX	Note Index	Currency	10	View