ICJC_Applied_Purchases (ICJC2005)

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

Display Name: ICJC_Applied_Purchases
Physical Name: ICJC2005
Technical Name: ICJC_Applied_Purchases

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	VCHRNMBR	Voucher Number	String	STR20_LBAU	20
2	JOBNUMBER_I	Job Num	String	STR30	30
3	CHANGEDATE_I	Change Date	Date	DT	8
4	DOCTYPE	Document Type	Integer	DDL_Document_Type	0
5	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['ICJC_Applied_Purchases'].VENDORID AS 'ICJC_Applied_Purchases-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM ICJC2005 AS ['ICJC_Applied_Purchases'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['ICJC_Applied_Purchases'].VENDORID = ['PM Vendor Master File'].VENDORID
6	DOCDATE	Document Date	Date	DT	8
7	DOCNUMBR	Document Number	String	STR20_Document_Number	20
8	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['ICJC_Applied_Purchases'].USERID AS 'ICJC_Applied_Purchases-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ICJC2005 AS ['ICJC_Applied_Purchases'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['ICJC_Applied_Purchases'].USERID = ['Users Master'].USERID
9	MFGNOTEINDEX_I	MFG Note Index	Currency	DLR14	14
10	BOOLEANFLAG_I	Boolean Flag	Boolean	Boolean_Flag	0