QA_HIST_SCAR (QA010532)

azurecurve Products Manufacturing (346)3rd PartyQA_HIST_SCAR (QA010532)

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

Display Name: QA_HIST_SCAR
Physical Name: QA010532
Technical Name: QA_HIST_SCAR

Group Display Name: Manufacturing QA
Group Technical Name: Manufacturing QA

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	SCAR_Number	SCAR Number	String	STR20_Document_Number	20
2	nsrnum	NSR Number	String	STR20_Document_Number	20
3	DATEENTERED_I	Date Entered	Date	DT	8
4	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['QA_HIST_SCAR'].ITEMNMBR AS 'QA_HIST_SCAR-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM QA010532 AS ['QA_HIST_SCAR'] INNER JOIN IV00101 AS ['Item Master'] ON ['QA_HIST_SCAR'].ITEMNMBR = ['Item Master'].ITEMNMBR
5	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['QA_HIST_SCAR'].VENDORID AS 'QA_HIST_SCAR-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM QA010532 AS ['QA_HIST_SCAR'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['QA_HIST_SCAR'].VENDORID = ['PM Vendor Master File'].VENDORID
6	ORIGINATOR	Originator	String	STR15	15
7	PORDNMBR	Purchase Order Number	String	Purchase Order Number	20
8	RECEIVINGNUMBER_I	Receiving Number	String	STR20_Document_Number	20
9	RECTRANSNUMBER_I	Receiving Transaction Number	Integer	INT4	4
10	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['QA_HIST_SCAR'].LOCNCODE AS 'QA_HIST_SCAR-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM QA010532 AS ['QA_HIST_SCAR'] INNER JOIN IV40700 AS ['Site Setup'] ON ['QA_HIST_SCAR'].LOCNCODE = ['Site Setup'].LOCNCODE
11	VENDNAME	Vendor Name	String	STR64_Vendor_Name	64
12	ADDRESS1	Address 1	String	STR60	60
13	ADDRESS2	Address 2	String	STR60	60
14	CITY	City	String	STR35	35
15	STATE	State	String	STR30_State	29
16	ZIPCODE	Zip Code	String	STR10	10
17	PHNUMBR1	Phone Number 1	String	Phone_Number	14
18	PHNUMBR2	Phone Number 2	String	Phone_Number	14
19	FAXNUMBR	Fax Number	String	STR14_FAX	14
20	ITEMDESC	Item Description	String	STR100	100
21	VNDITNUM	Vendor Item Number	String	Item_Number	30
22	QTYRECEIVED2_I	QTY Received2	Currency	DLR17_QTY_RBS0_STR	17
23	BASEUOFM	Base U Of M	String	U_Of_M	8
24	DATEDUE_I	Date Due	Date	DT	8
25	DATEIN_I	Date In	Date	DT	8
26	VNDCNTCT	Vendor Contact	String	STR60	60
27	PHONNAME	Phone Number	String	Phone_Number	14
28	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['QA_HIST_SCAR'].USERID AS 'QA_HIST_SCAR-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM QA010532 AS ['QA_HIST_SCAR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['QA_HIST_SCAR'].USERID = ['Users Master'].USERID
29	CHANGEDATE_I	Change Date	Date	DT	8
30	MFGNOTEINDEX_I	MFG Note Index	Currency	DLR14	14
31	MFGNOTEINDEX2_I	MFG Note Index2	Currency	DLR14	14
32	MFGNOTEINDEX3_I	MFG Note Index3	Currency	DLR14	14
33	MFGNOTEINDEX4I	MFG Note Index4	Currency	DLR14	14
34	MFGNOTEINDEX5I	MFG Note Index5	Currency	DLR14	14
35	MFGNOTEINDEX6I	MFG Note Index6	Currency	DLR14	14

azurecurve Products Manufacturing (346)3rd PartyQA_HIST_SCAR (QA010532)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply