SVC_RTV_MSTR_View (SVC5600V)

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

Display Name: SVC_RTV_MSTR_View
Physical Name: SVC5600V
Technical Name: SVC_RTV_MSTR_View

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	RTV_Number	RTV Number	String	STR15_LBAU	15
2	RTV_Type	RTV Type	String	STR10_LBAU	10
3	RTV_Return_Status	RTV Return Status	String	STR3_LBAU	3
4	RTV_Status	RTV Status	Integer	DDL_RTV_Type	0
5	RETDOCID	Return Document ID	String	STR15_LBAU	15
6	DSCRIPTN	Description	String	STR30	30
7	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['SVC_RTV_MSTR_View'].VENDORID AS 'SVC_RTV_MSTR_View-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM SVC5600V AS ['SVC_RTV_MSTR_View'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['SVC_RTV_MSTR_View'].VENDORID = ['PM Vendor Master File'].VENDORID
8	VENDNAME	Vendor Name	String	STR64_Vendor_Name	64
9	ADRSCODE	Address Code	String	STR15_Address_Code	15
10	ENTDTE	Entry Date	Date	DT_Date	6
11	Shipped_Date	Shipped Date	Date	DT_Date	6
12	receiptdate	Receipt Date	Date	DT	8
13	COMPDTE	Complete Date	Date	DT_Date	6
14	OFFID	Office ID	String	STR10_LBAU	10
15	HISTORY	History	Boolean	CB_History	0