ICJC2000 - ICJC_Job_LINE | Prospr - Dynamics GP Table Reference

ICJC2000 - ICJC_Job_LINE

Query Builder

Select * from ICJC2000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
JOBNUMBER_I	Job Num	String	32	View
CHILDNUMBER_I	Child Number	String	46	View
CHILDTYPE_I	Child Type	Integer	2	View
CITEMNUMBERI	Citem Number	Integer	2	View
SEQORDER_I	SeqOrder	Integer	2	View
AMT_I	AMT	Currency	10	View
RE_I	RE	Boolean	2	View
POSITIVE_I	POSITIVE	Boolean	2	View
APPLIED_I	APPLIED	Boolean	2	View
REVENUEEXPENSECODE_I	Revenue/Expense Code	String	22	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
CHANGEDATE_I	Change Date	Date	4	View
USERID	User ID	String	16	View