ICJC9001 - PM Transaction WORK File | Prospr - Dynamics GP Table Reference

ICJC9001 - PM Transaction WORK File

Query Builder

Select * from ICJC9001

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
VCHNUMWK	Voucher Number - WORK	String	18	View
VENDORID	Vendor ID	String	16	View
DOCNUMBR	Document Number	String	22	View
DOCTYPE	Document Type	Integer	2	View
SOURCDOC	Source Document 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo	String	12	View
DOCAMNT	Document Amount	Currency	10	View
DOCDATE	Document Date	Date	4	View
PSTGDATE	Posting Date	Date	4	View
VADDCDPR	Vendor Address Code - Primary	String	16	View
PYMTRMID	Payment Terms ID	String	22	View
TAXSCHID	Tax Schedule ID	String	16	View
DUEDATE	Due Date	Date	4	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
DISCDATE	Discount Date	Date	4	View
PRCHAMNT	Purchases Amount	Currency	10	View
CHRGAMNT	Charge Amount	Currency	10	View
CASHAMNT	Cash Amount	Currency	10	View
CAMCBKID	Cash Amount Checkbook ID	String	16	View
CDOCNMBR	Cash Document Number	String	22	View
CAMTDATE	Cash Amount Date	Date	4	View
CAMPMTNM	Cash Amount Payment Number	String	22	View
CHEKAMNT	Check Amount	Currency	10	View
CHAMCBID	Check Amount Checkbook ID	String	16	View
CHEKDATE	Check Date	Date	4	View
CAMPYNBR	Check Amount Payment Number	String	22	View
CRCRDAMT	Credit Card Amount	Currency	10	View
CCAMPYNM	Credit Card Amount Payment Number	String	22	View
CHEKNMBR	Check Number	String	22	View
CARDNAME	Card Name	String	16	View
CCRCTNUM	Credit Card Receipt Number	String	22	View
CRCARDDT	Credit Card Date	Date	4	View
CURNCYID	Currency ID	String	16	View
CHEKBKID	Checkbook ID	String	16	View
TRXDSCRN	Transaction Description	String	32	View
UN1099AM	Unapplied 1099 Amount	Currency	10	View
TRDISAMT	Trade Discount Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
FRTAMNT	Freight Amount	Currency	10	View
TEN99AMNT	1099 Amount	Currency	10	View
MSCCHAMT	Misc Charges Amount	Currency	10	View
PORDNMBR	Purchase Order Number	String	22	View
SHIPMTHD	Shipping Method	String	16	View
DISAMTAV	Discount Amount Available	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
APDSTKAM	Applied Discount Taken Amount	Currency	10	View
WROFAMNT	Write Off Amount	Currency	10	View
CURTRXAM	Current Trx Amount	Currency	10	View
TXENGCLD	Tax Engine Called	Boolean	2	View
PMWRKMSG	PM WORK Messages	Long Integer	4	View
PMDSTMSG	PM Distribution Messages	Long Integer	4	View
GSTDSAMT	GST Discount Amount	Currency	10	View
PGRAMSBJ	Percent Of Gross Amount Subject	Integer	2	View
PPSAMDED	PPS Amount Deducted	Currency	10	View
PPSTAXRT	PPS Tax Rate	Integer	2	View
POSTED	Posted	Boolean	2	View
APPLDAMT	Applied Amount	Currency	10	View
VCHRNMBR	Voucher Number	String	22	View
CNTRLTYP	Control Type	Integer	2	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
NOTEINDX	Note Index	Currency	10	View
BKTFRTAM	Backout Freight Amount	Currency	10	View
BKTMSCAM	Backout Misc Amount	Currency	10	View
BKTPURAM	Backout Purchases Amount	Currency	10	View
PCHSCHID	Purchase Schedule ID	String	16	View
FRTSCHID	Freight Schedule ID	String	16	View
MSCSCHID	Misc Schedule ID	String	16	View
PRINTED	Printed	Boolean	2	View
PRCTDISC	Percent Discount	Integer	2	View
RETNAGAM	Retainage Amount	Currency	10	View

ICJC9001 - PM Transaction WORK File

Query Builder

Customer Service

Information

My Account

Contact Us