PA10200 - PA Miscellaneous Log Header File | Prospr

PA10200 - PA Miscellaneous Log Header File

Query Builder

Select * from PA10200

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PSMISCLTRXTYPE	PA Miscellaneous Log TRX Type	Integer	2	View
PAMISCLDOCNO	PA Miscellaneous Log No.	String	18	View
PADOCDT	PA Document Date	Date	4	View
PAYR	PA Year	Integer	2	View
USERID	User ID	String	16	View
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
TRXSORCE	TRX Source	String	14	View
PAREFNO	PA Reference Document No.	String	18	View
PSMISCID	PA Miscellaneous ID	String	16	View
PAREPD	PA Reporting Period	Integer	2	View
PAREPDT	PA Reporting Date	Date	4	View
PAPeriodEndDate	PA Period End Date	Date	4	View
PACOMM	PA Comment	String	52	View
PAUD1	PA User Defined 1	String	22	View
PAUD2	PA User Defined 2	String	22	View
PATQTY	PA Total Quantity	Currency	10	View
PAtotcosts	PA Total Costs	Currency	10	View
PATACRV	PA Total Accrued Revenues	Currency	10	View
NOTEINDX	Note Index	Currency	10	View
PAreptsuff	PA Reporting Suffix	String	6	View
PAPD	PA Post Date	Date	4	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
PAML_HDR_Errors	PA ML HDR Errors	Long Integer	4	View
PAML_Dist_Errors	PA ML Distribution Errors	Long Integer	4	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
RTCLCMTD	Rate Calculation Method	Integer	2	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
PAORIGTOTCOSTS	PA Originating Total Costs	Currency	10	View
PAORIACCRREV	PA Originating Accrued Revenues	Currency	10	View
Correcting_Trx_Type	Correcting Trx Type	Integer	2	View
PAORIGINLDOCNUM	PA Original Document Number	String	18	View
CREATDDT	Created Date	Date	4	View
CRUSRID	Created User ID	String	16	View

PA10200 - PA Miscellaneous Log Header File

Query Builder

Customer Service

Information

My Account

Contact Us