gpPayWork - PM Payment WORK Temp | Prospr - Dynamics GP Table Reference

gpPayWork - PM Payment WORK Temp

Query Builder

Select * from gpPayWork

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
PMNTNMBR	Payment Number	String	22	View
CHEKBKID	Checkbook ID	String	16	View
DOCDATE	Document Date	Date	4	View
DOCNUMBR	Document Number	String	22	View
APPLDAMT	Applied Amount	Currency	10	View
CURTRXAM	Current Trx Amount	Currency	10	View
CHEKTOTL	Check Total	Currency	10	View
VENDORID	Vendor ID	String	16	View
VENDNAME	Vendor Name	String	66	View
COMMENT1	Comment1	String	32	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
COUNTRY	Country	String	62	View
VNDCHKNM	Vendor Check Name	String	66	View
SOURCDOC	Source Document 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo	String	12	View
DISTKNAM	Discount Taken Amount	Currency	10	View
DISAMTAV	Discount Amount Available	Currency	10	View
WROFAMNT	Write Off Amount	Currency	10	View
CURNCYID	Currency ID	String	16	View
VOIDED	Voided	Boolean	2	View
REPRNTED	Reprinted	Integer	2	View
GSTDSAMT	GST Discount Amount	Currency	10	View
PGRAMSBJ	Percent Of Gross Amount Subject	Integer	2	View
PPSTAXRT	PPS Tax Rate	Integer	2	View
PPSAMDED	PPS Amount Deducted	Currency	10	View
LDOCRMTC	List Documents on Remittance	Integer	2	View
SDORMBY	Sort Documents on Remittance By	Integer	2	View
KEYFIELD	Key Field	String	22	View
AMWDSNBR	Amount in Words and Numbers	String	62	View
NOTEINDX	Note Index	Currency	10	View
VCHRNMBR	Voucher Number	String	22	View
CNTRLTYP	Control Type	Integer	2	View
DOCTYPE	Document Type	Integer	2	View
MODIFDT	Modified Date	Date	4	View
MDFUSRID	Modified User ID	String	16	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
POSTEDDT	Posted Date	Date	4	View
PTDUSRID	Posted User ID	String	16	View
PMWRKMSG	PM WORK Messages	Long Integer	4	View
PMDSTMSG	PM Distribution Messages	Long Integer	4	View
CHKCOMNT	Check Comment	String	62	View
PSTGDATE	Posting Date	Date	4	View
STRGA255	String A 255	String	256	View
STRGB255	String B 255	String	256	View
SEPRMTNC	Seperate Remittance	Boolean	2	View
STBOVRFL	Stub Overflow	Boolean	2	View
CTYSTZIP	City-State-Zip Code	String	48	View
TotDocAmt	Total Document Amount	Currency	10	View
TotAmtPaid	Total Amount Paid	Currency	10	View
TotCrdAmt	Total Credit Amount	Currency	10	View
TotalPaidTot	Total Paid Total	Currency	10	View
TotNegTot	Total Negative Total	Currency	10	View
TotCrdDocAmt	Total Credit Document Amount	Currency	10	View
TotTotDocAmt	Total Total Document Amount	Currency	10	View
TotDiscTknAmt	Total Discount Taken Amount	Currency	10	View
TotWOAmt	Total Write Off Amount	Currency	10	View
TotPPSAmtDed	Total PPS Amount Deducted	Currency	10	View
TotGSTDiscAmt	Total GST Discount Amount	Currency	10	View
TotDiscTknTot	Total Discount Taken Total	Currency	10	View
TotWOTot	Total Write Off Total	Currency	10	View
Outstanding_Amount	Outstanding Amount	Currency	10	View
Net_Paid_Amount	Net Paid Amount	Currency	10	View
AMTINWDS	Amount in Words	Text	2	View

gpPayWork - PM Payment WORK Temp

Query Builder

Customer Service

Information

My Account

Contact Us