ICJC9000 - ICJC RM Sales Work | Prospr - Dynamics GP Table Reference

ICJC9000 - ICJC RM Sales Work

Query Builder

Select * from ICJC9000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DOCTYPE	Document Type	Integer	2	View
RMDTYPAL	RM Document Type-All 0 = Reserved for balance carried forward records 1 = Sales / Invoice 2 = Reserved for schedule payments 3 = Debit Memos 4 = Finance Charges 5 = Service Repairs 6= Warranties 7 = Credit Memos 8 = Returns 9 = Payments	Integer	2	View
RMDNUMWK	RM Document Number-WORK	String	18	View
DOCNUMBR	Document Number	String	22	View
DOCPRFIX	Document Prefix	String	4	View
DOCDESCR	Document Description	String	32	View
DOCDATE	Document Date	Date	4	View
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
NOTEINDX	Note Index	Currency	10	View
CUSTNMBR	Customer Number	String	16	View
CUSTNAME	Customer Name	String	66	View
ADRSCODE	Address Code	String	16	View
SLPRSNID	Salesperson ID	String	16	View
SALSTERR	Sales Territory	String	16	View
COMAPPTO	Commission Applied To	Integer	2	View
COMDLRAM	Commission Dollar Amount	Currency	10	View
NCOMAMNT	Non-Commissioned Amount	Currency	10	View
SHIPMTHD	Shipping Method	String	16	View
CSTPONBR	Customer PO Number	String	22	View
TAXSCHID	Tax Schedule ID	String	16	View
SLSCHDID	Sales Schedule ID	String	16	View
FRTSCHID	Freight Schedule ID	String	16	View
MSCSCHID	Misc Schedule ID	String	16	View
COSTAMNT	Cost Amount	Currency	10	View
SLSAMNT	Sales Amount	Currency	10	View
TRDISAMT	Trade Discount Amount	Currency	10	View
TRDDISCT	Trade Discount	Integer	2	View
FRTAMNT	Freight Amount	Currency	10	View
MISCAMNT	Misc Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
BKTSLSAM	Backout Sales Amount	Currency	10	View
BKTFRTAM	Backout Freight Amount	Currency	10	View
BKTMSCAM	Backout Misc Amount	Currency	10	View
TXENGCLD	Tax Engine Called	Boolean	2	View
DOCAMNT	Document Amount	Currency	10	View
APPLDAMT	Applied Amount	Currency	10	View
CASHAMNT	Cash Amount	Currency	10	View
CBKIDCSH	Checkbook ID Cash	String	16	View
CASHDATE	Cash Date	Date	4	View
DCNUMCSH	Document Number Cash	String	22	View
CHEKAMNT	Check Amount	Currency	10	View
CBKIDCHK	Checkbook ID Check	String	16	View
CBKIDCRD	Checkbook ID Credit Card	String	16	View
CHEKNMBR	Check Number	String	22	View
CHEKDATE	Check Date	Date	4	View
DCNUMCHK	Document Number Check	String	22	View
CRCRDAMT	Credit Card Amount	Currency	10	View
CRCRDNAM	Credit Card Name	String	16	View
RCTNCCRD	Receipt Number Credit Card	String	22	View
CRCARDDT	Credit Card Date	Date	4	View
DCNUMCRD	Document Number Credit Card	String	22	View
DISCRTND	Discount Returned	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
DISAVTKN	Discount Available Taken	Currency	10	View
WROFAMNT	Write Off Amount	Currency	10	View
PPSAMDED	PPS Amount Deducted	Currency	10	View
GSTDSAMT	GST Discount Amount	Currency	10	View
ACCTAMNT	Account Amount	Currency	10	View
PYMTRMID	Payment Terms ID	String	22	View
DISAVAMT	Discount Available Amount	Currency	10	View
DISCDATE	Discount Date	Date	4	View
DUEDATE	Due Date	Date	4	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
DSCPCTAM	Discount Percent Amount	Integer	2	View
CURNCYID	Currency ID	String	16	View
POSTED	Posted	Boolean	2	View
LSTEDTDT	Last Edit Date	Date	4	View
LSTUSRED	Last User to Edit	String	16	View
RMTREMSG	RM TRX Posting Error Messages	Long Integer	4	View
RMDPEMSG	RM Dist Posting Error Messages	Long Integer	4	View
GLPOSTDT	GL Posting Date	Date	4	View
POSTEDDT	Posted Date	Date	4	View
PTDUSRID	Posted User ID	String	16	View

ICJC9000 - ICJC RM Sales Work

Query Builder

Customer Service

Information

My Account

Contact Us