Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC05602
Product: FieldService (949)
Series: Project
Display Name: SVC_RTV_Serial_Lot_Work DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
Physical Name: SVC05602
Technical Name: SVC_RTV_Serial_Lot_WorkSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 RTV_Number 
RTV Number STR15_LBAU String 15 2 RTV_Line RTV Line Sequence_Number Currency 19 3 QTYTYPE QTY Type DDL_QTY_Type Integer 0 4 SERLTQTY Serial/Lot QTY DLR17_QTY_RBS0_UTR Currency 17 5 SLTSQNUM Serial/Lot SEQ Number LI_Sequence_Number Long Integer 10 6 ITEMNMBR Item Number STR30_Item_Number String 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['SVC_RTV_Serial_Lot_Work'].ITEMNMBR AS 'SVC_RTV_Serial_Lot_Work-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SVC05602 AS ['SVC_RTV_Serial_Lot_Work']
INNER JOIN
IV00101 AS ['Item Master']
ON
['SVC_RTV_Serial_Lot_Work'].ITEMNMBR = ['Item Master'].ITEMNMBR7 SERLNMBR Serial Number STR20_LBAU String 20 8 SVC_Serial_ID SVC Serial ID STR20_LBAU String 20 9 EQUIPID Equipment ID Long Int Long Integer 8 10 Return_Item_Number Return Item Number STR30_Item_Number String 30 11 Return_Serial_Number Return Serial Number STR20_LBAU String 20 12 SVC_Return_Serial_ID SVC Return Serial ID STR20_LBAU String 20 13 Return_Equipment_ID Return Equipment ID Long Int Long Integer 8 14 BIN Bin STR15_Bin String 15 15 TOBIN To Bin STR15_Bin String 15 16 RETCOST Return Cost DLR17_$S2 Currency 17 17 SVC_Original_Serial SVC Original Serial Boolean Boolean 0 18 DATERECD Date Received DATE Date 6 19 DTSEQNUM Date SEQ Number Sequence_Number Currency 19 20 TRXSORCE TRX Source STR13 String 13 21 Shipped Shipped CB_Shipped Boolean 0 22 MARKED Marked Boolean Boolean 0 23 POSTED Posted True/False Boolean 0 24 MFGDATE Manufacture Date DT_Date Date 6 25 EXPNDATE Expiration Date DT_Date Date 6 26 DEX_ROW_ID int int 10