ICJC_Linker (ICJC1002)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ICJC1002

Display Name: ICJC_Linker
Physical Name: ICJC1002
Technical Name: ICJC_Linker

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	Link_ID	Link ID	Long Integer	LI_Sequence_Number	10
2	AUTOLINKED_I	AutoLinked	Boolean	Boolean	0
3	PARENTNUMBER_I	Parent Number	String	STR30_I	30
4	PARENTTYPE_I	Parent Type	Integer	DDL_Type	0
5	CHILDNUMBER_I	Child Number	String	STR45	45
6	CHILDTYPE_I	Child Type	Integer	DDL_Type	0
7	JOBNUMBER_I	Job Num	String	STR30	30
8	SOPTYPE	SOP Type	Integer	DDL_SOP_Type	0
9	DOCID	Document ID	String	STR15_LBAU	15
10	MOPDOCNUM	MOP Document Number	String	STR30_UC	30
11	POLINE_I	PO Line Item	Integer	INT3	3
12	POBLANKETLINEITEM_I	PO Blanket Line Item	Integer	INT4_U0	4
13	RECTRANSNUMBER_I	Receiving Transaction Number	Integer	INT4	4
14	IVDOCTYP	IV Document Type	Integer	DDL_IV_Document_Type	0
15	DOCTYPE	Document Type	Integer	DDL_Document_Type	0
16	LNSEQNBR	Line SEQ Number	Currency	Sequence_Number	19
17	SEQ_I	Seq	Long Integer	LINT_10	10
18	Split	Split	Long Integer	LONG_INT	10
19	VCHRNMBR	Voucher Number	String	STR20_LBAU	20
20	DONECB_I	done_cb	Boolean	CB_Done	0
21	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['ICJC_Linker'].USERID AS 'ICJC_Linker-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ICJC1002 AS ['ICJC_Linker'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['ICJC_Linker'].USERID = ['Users Master'].USERID
22	CHANGEDATE_I	Change Date	Date	DT	8