PM20100 - PM Apply To OPEN OPEN Temporary File | Prospr

PM20100 - PM Apply To OPEN OPEN Temporary File

Query Builder

Select * from PM20100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
KEYSOURC	Key Source	String	42	View
DOCDATE	Document Date	Date	4	View
TIME1	Time	Time	4	View
VENDORID	Vendor ID	String	16	View
POSTED	Posted	Boolean	2	View
BCHSOURC	Batch Source	String	16	View
USERID	User ID	String	16	View
APTVCHNM	Apply To Voucher Number	String	22	View
APTODCTY	Apply To Document Type	Integer	2	View
APTODCDT	Apply To Document Date	Date	4	View
APTODCNM	Apply To Document Number	String	22	View
APPLDAMT	Applied Amount	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
DISAVTKN	Discount Available Taken	Currency	10	View
WROFAMNT	Write Off Amount	Currency	10	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
ORAPPAMT	Originating Applied Amount	Currency	10	View
ORDISTKN	Originating Discount Taken Amount	Currency	10	View
ORDATKN	Originating Discount Available Taken	Currency	10	View
ORWROFAM	Originating Write Off Amount	Currency	10	View
Apply_To_Document_Amount	Apply To Document Amount	Currency	10	View
Apply_To_Orig_Doc_Amount	Apply To Orig Doc Amount	Currency	10	View
Apply_To_Discount_Date	Apply To Discount Date	Date	4	View
Apply_To_Due_Date	Apply To Due Date	Date	4	View
Apply_To_Description	Apply To Description	String	32	View
Apply_To_IS_MC_Trx	Apply To IS MC Trx	Integer	2	View
ApplyToGLPostDate	Apply To GL Posting Date	Date	4	View
APTOEXRATE	Apply To Exchange Rate	Currency (Variable)	10	View
APTODENRATE	Apply To Denomination Exchange Rate	Currency (Variable)	10	View
APTORTCLCMETH	Apply To Rate Calc Method	Integer	2	View
APTOMCTRXSTT	Apply To MC Transaction State	Integer	2	View
ISMCTRX	IS MC Trx	Integer	2	View
VCHRNMBR	Voucher Number	String	22	View
DOCTYPE	Document Type	Integer	2	View
APFRDCNM	Apply From Document Number	String	22	View
FROMCURR	Apply From Currency ID	String	16	View
Apply_From_Document_Amou	Apply From Document Amount	Currency	10	View
Apply_From_Orig_Doc_Amou	Apply From Orig Doc Amount	Currency	10	View
APFRMAPLYAMT	Apply From Apply Amount	Currency	10	View
APFRMDISCTAKEN	Apply From Discount Taken Amount	Currency	10	View
APFRMDISCAVAIL	Apply From Discount Available Taken	Currency	10	View
APFRMWROFAMT	Apply From Write Off Amount	Currency	10	View
ActualApplyToAmount	Actual Apply To Amount	Currency	10	View
ActualDiscTakenAmount	Actual Discount Taken Amount	Currency	10	View
ActualDiscAvailTaken	Actual Discount Available Taken	Currency	10	View
ActualWriteOffAmount	Actual Write Off Amount	Currency	10	View
APFRMEXRATE	Apply From Exchange Rate	Currency (Variable)	10	View
APFRMDENRATE	Apply From Denomination Exchange Rate	Currency (Variable)	10	View
APFRMRTCLCMETH	Apply From Rate Calc Method	Integer	2	View
APFRMMCTRXSTT	Apply From MC Transaction State	Integer	2	View
Apply_From_Description	Apply From Description	String	32	View
Apply_From_IS_MC_Trx	Apply From IS MC Trx	Integer	2	View
PPSAMDED	PPS Amount Deducted	Currency	10	View
GSTDSAMT	GST Discount Amount	Currency	10	View
TAXDTLID	Tax Detail ID	String	16	View
UPDTKNAM	Unposted Discount Taken Amount	Currency	10	View
UPGSTDAM	Unposted GST Discount Amount	Currency	10	View
UNPPPSAD	Unposted PPS Amount Deducted	Currency	10	View
UPWROFAM	Unposted Write Off Amount	Currency	10	View
PMDSTMSG	PM Distribution Messages	Long Integer	4	View
MODIFDT	Modified Date	Date	4	View
MDFUSRID	Modified User ID	String	16	View
POSTEDDT	Posted Date	Date	4	View
PTDUSRID	Posted User ID	String	16	View
TEN99AMNT	1099 Amount	Currency	10	View
RLGANLOS	Realized Gain-Loss Amount	Currency	10	View
APYFRMRNDAMT	Apply From Round Amount	Currency	10	View
APYTORNDAMT	Apply To Round Amount	Currency	10	View
APYTORNDDISC	Apply To Round Discount	Currency	10	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
DECPLCUR	Decimal Places Currency	Integer	2	View
RATECALC	Rate Calc Method	Integer	2	View
Payment_To_Print_On_Stub	Payment To Print On Stub	String	22	View
OAPYFRMRNDAMT	Originating Apply From Round Amount	Currency	10	View
OAPYTORNDAMT	Originating Apply To Round Amount	Currency	10	View
OAPYTORNDDISC	Originating Apply To Round Discount	Currency	10	View
Settled_Gain_CreditCurrT	Settled Gain CreditCurrTrx	Currency	10	View
Settled_Loss_CreditCurrT	Settled Loss CreditCurrTrx	Currency	10	View
Settled_Gain_DebitCurrTr	Settled Gain DebitCurrTrx	Currency	10	View
Settled_Loss_DebitCurrTr	Settled Loss DebitCurrTrx	Currency	10	View
Settled_Gain_DebitDiscAv	Settled Gain DebitDiscAvail	Currency	10	View
Settled_Loss_DebitDiscAv	Settled Loss DebitDiscAvail	Currency	10	View
VADCDTRO	Vendor Address Code - Remit To	String	16	View
Credit1099Amount	Credit 1099 Amount	Currency	10	View
DEFTEN99TYPE	Default 1099 Type	Integer	2	View
DEFTEN99BOXNUMBER	Default 1099 Box Number	Integer	2	View

PM20100 - PM Apply To OPEN OPEN Temporary File

Query Builder

Customer Service

Information

My Account

Contact Us