AMS WO MSTR (AMS00203)

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

Display Name: AMS WO MSTR
Physical Name: AMS00203
Technical Name: AMS_WO_MSTR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	AMS_WO_ID	AMS WO ID	Long Int	Long Integer	8
2	AMS_WO_Reference	AMS WO Reference	STR20	String	20
3	AMS_WO_Description	AMS WO Description	AMS_STR255	String	255
4	VENDORID	Vendor ID	STR_15_Vendor_ID	String	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['AMS WO MSTR'].VENDORID AS 'AMS WO MSTR-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM AMS00203 AS ['AMS WO MSTR'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['AMS WO MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID