PM10200 - PM Apply To WORK OPEN File | Prospr

PM10200 - PM Apply To WORK OPEN File

Query Builder

Select * from PM10200

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
VENDORID	Vendor ID	String	16	View
DOCDATE	Document Date	Date	4	View
DATE1	Date	Date	4	View
GLPOSTDT	GL Posting Date	Date	4	View
TIME1	Time	Time	4	View
APTVCHNM	Apply To Voucher Number	String	22	View
APTODCTY	Apply To Document Type	Integer	2	View
APTODCNM	Apply To Document Number	String	22	View
APTODCDT	Apply To Document Date	Date	4	View
ApplyToGLPostDate	Apply To GL Posting Date	Date	4	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	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
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
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
VCHRNMBR	Voucher Number	String	22	View
DOCTYPE	Document Type	Integer	2	View
APFRDCNM	Apply From Document Number	String	22	View
ApplyFromGLPostDate	Apply From GL Posting Date	Date	4	View
FROMCURR	Apply From Currency ID	String	16	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
PPSAMDED	PPS Amount Deducted	Currency	10	View
GSTDSAMT	GST Discount Amount	Currency	10	View
TAXDTLID	Tax Detail ID	String	16	View
POSTED	Posted	Boolean	2	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
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
Revaluation_Status	Revaluation Status	Integer	2	View
Credit1099Amount	Credit 1099 Amount	Currency	10	View
DEFTEN99TYPE	Default 1099 Type	Integer	2	View
DEFTEN99BOXNUMBER	Default 1099 Box Number	Integer	2	View

PM10200 - PM Apply To WORK OPEN File

Query Builder

Customer Service

Information

My Account

Contact Us