ICJC1002 - ICJC_Linker | Prospr - Dynamics GP Table Reference

ICJC1002 - ICJC_Linker

Select * from ICJC1002

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
Link_ID	Link ID	Long Integer	4	View
AUTOLINKED_I	AutoLinked	Boolean	2	View
PARENTNUMBER_I	Parent Number	String	32	View
PARENTTYPE_I	Parent Type	Integer	2	View
CHILDNUMBER_I	Child Number	String	46	View
CHILDTYPE_I	Child Type	Integer	2	View
JOBNUMBER_I	Job Num	String	32	View
SOPTYPE	SOP Type 1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order (In SBF, this value is not available.)	Integer	2	View
DOCID	Document ID	String	16	View
MOPDOCNUM	MOP Document Number	String	32	View
POLINE_I	PO Line Item	Integer	2	View
POBLANKETLINEITEM_I	PO Blanket Line Item	Integer	2	View
RECTRANSNUMBER_I	Receiving Transaction Number	Integer	2	View
IVDOCTYP	IV Document Type	Integer	2	View
DOCTYPE	Document Type	Integer	2	View
LNSEQNBR	Line SEQ Number	Currency	10	View
SEQ_I	Seq	Long Integer	4	View
Split	Split	Long Integer	4	View
VCHRNMBR	Voucher Number	String	22	View
DONECB_I	done_cb	Boolean	2	View
USERID	User ID	String	16	View
CHANGEDATE_I	Change Date	Date	4	View