MC020105 - Multicurrency PM Revaluation Activity | Prospr

MC020105 - Multicurrency PM Revaluation Activity

Query Builder

Select * from MC020105

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
VCHRNMBR	Voucher Number	String	22	View
DOCTYPE	Document Type	Integer	2	View
VENDORID	Vendor ID	String	16	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
SEQNUMBR	Sequence Number	Long Integer	4	View
DOCDATE	Document Date	Date	4	View
RVLUDATE	Revaluation Date	Date	4	View
RevalPostDate	Revaluation Posting Date	Date	4	View
RATETPID	Rate Type ID	String	16	View
RTCLCMTD	Rate Calculation Method	Integer	2	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
AUDITTRAIL	Audit Trail Code	String	14	View
DOCNUMBR	Document Number	String	22	View
GAINLOSS	Gain or Loss Type	Integer	2	View
GLCURTRX	Gain or Loss on Current Trx Amount	Currency	10	View
GLDSCAVL	Gain or Loss on Disc Avail Amount	Currency	10	View
ORCTRXAM	Originating Current Trx Amount	Currency	10	View
ORDAVAMT	Originating Discount Available Amount	Currency	10	View
CURTRXAR	Current Trx Amount After Revaluation	Currency	10	View
DSCAVAAR	Disc Avail Amount After Revaluation	Currency	10	View
UnsettledCurrentGainLoss	Unsettled Gain or Loss on Current Trx Amount	Currency	10	View
UnsettledAvailGainLoss	Unsettled Gain or Loss on Disc Avail Amount	Currency	10	View
Total_Gain_or_Loss_on_Cu	Total Gain or Loss on Current Trx Amount	Currency	10	View
Total_Gain_or_Loss_on_Di	Total Gain or Loss on Disc Avail Amount	Currency	10	View
CURTRXAI	Current Trx Amount Account Index	Long Integer	4	View
DSCAVAAI	Disc Avail Amount Account Index	Long Integer	4	View
RVLUEIDX	Revaluation Account Index	Long Integer	4	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = Originating is not a denomination; Functional is the Euro currency. 3 = Originating is not a denomination; Functional is a denomination. 4 = Originating is a denomination; Functional is not a denomination. 5 = Originating is a denomination; Functional is a denomination. 6 = Originating is a denomination; Functional is the Euro currency. 7 = Originating is the Euro currency; Functional is a denomination. 8 = Originating is the Euro currency; Functional is not a denomination.	Integer	2	View

MC020105 - Multicurrency PM Revaluation Activity

Query Builder

Customer Service

Information

My Account

Contact Us