Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC5600V
Product: FieldService (949)
Series:
Display Name: SVC_RTV_MSTR_View
Physical Name: SVC5600V
Technical Name: SVC_RTV_MSTR_ViewSeq 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'].VENDORID8 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