Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC35602
Product: FieldService (949)
Series:
Display Name: SVC_RTV_Serial_Lot_Work_HIST
Physical Name: SVC35602
Technical Name: SVC_RTV_Serial_Lot_Work_HISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 RTV_Number 
RTV Number String STR15_LBAU 15 2 RTV_Line RTV Line Currency Sequence_Number 19 3 QTYTYPE QTY Type Integer DDL_QTY_Type 0 4 SERLTQTY Serial/Lot QTY Currency DLR17_QTY_RBS0_UTR 17 5 SLTSQNUM Serial/Lot SEQ Number 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_RTV_Serial_Lot_Work_HIST'].ITEMNMBR AS 'SVC_RTV_Serial_Lot_Work_HIST-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SVC35602 AS ['SVC_RTV_Serial_Lot_Work_HIST']
INNER JOIN
IV00101 AS ['Item Master']
ON
['SVC_RTV_Serial_Lot_Work_HIST'].ITEMNMBR = ['Item Master'].ITEMNMBR7 SERLNMBR Serial Number String STR20_LBAU 20 8 SVC_Serial_ID SVC Serial ID String STR20_LBAU 20 9 EQUIPID Equipment ID Long Integer Long Int 8 10 Return_Item_Number Return Item Number String STR30_Item_Number 30 11 Return_Serial_Number Return Serial Number String STR20_LBAU 20 12 SVC_Return_Serial_ID SVC Return Serial ID String STR20_LBAU 20 13 Return_Equipment_ID Return Equipment ID Long Integer Long Int 8 14 BIN Bin String STR15_Bin 15 15 TOBIN To Bin String STR15_Bin 15 16 RETCOST Return Cost Currency DLR17_$S2 17 17 SVC_Original_Serial SVC Original Serial Boolean Boolean 0 18 DATERECD Date Received Date DATE 6 19 DTSEQNUM Date SEQ Number Currency Sequence_Number 19 20 TRXSORCE TRX Source String STR13 13 21 Shipped Shipped Boolean CB_Shipped 0 22 MARKED Marked Boolean Boolean 0 23 POSTED Posted Boolean True/False 0 24 MFGDATE Manufacture Date Date DT_Date 6 25 EXPNDATE Expiration Date Date DT_Date 6