Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC35001
Product: FieldService (949)
Series:
Display Name: SVC_RMA_MSTR_Line_HIST
Physical Name: SVC35001
Technical Name: SVC_RMA_MSTR_Line_HISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Return_Record_Type 
Return Record Type Integer DDL_Return_Record_Type 0 2 RETDOCID Return Document ID String STR15_LBAU 15 3 LNSEQNBR Line SEQ Number Currency Sequence_Number 19 4 LINITMTYP Line Item Type String STR3 3 5 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 6 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['SVC_RMA_MSTR_Line_HIST'].ITEMNMBR AS 'SVC_RMA_MSTR_Line_HIST-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SVC35001 AS ['SVC_RMA_MSTR_Line_HIST']
INNER JOIN
IV00101 AS ['Item Master']
ON
['SVC_RMA_MSTR_Line_HIST'].ITEMNMBR = ['Item Master'].ITEMNMBR7 ITEMDESC Item Description String STR100 100 8 SERLNMBR Serial Number String STR20_LBAU 20 9 QUANTITY QTY Currency DLR17_QTY_RBS0_STR 17 10 Received Received Boolean CB_Received 0 11 Shipped Shipped Boolean CB_Shipped 0