Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC35000
Product: FieldService (949)
Series: Project
Display Name: SVC_RMA_MSTR_HIST 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: SVC35000
Technical Name: SVC_RMA_MSTR_HISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 RETDOCID 
Return Document ID STR15_LBAU String 15 2 Return_Record_Type Return Record Type DDL_Return_Record_Type Integer 0 3 RMA_Status RMA Status INT Integer 0 4 Received Received CB_Received Boolean 0 5 RETORIG Return Origin DDL_Return Integer 0 6 RETREF Return Reference STR30_LBAU String 30 7 RETSTAT Return Status STR3_LBAU String 3 8 RETTYPE SVC Return Type STR10_LBAU String 10 9 ENTDTE Entry Date DT_Date Date 6 10 ENTTME Entry Time TM6 Time 6 11 ETADTE ETA Date DT_Date Date 6 12 ETATME ETA Time TM6 Time 6 13 RETUDATE Return Date DT Date 8 14 Return_Time Return Time TM6 Time 6 15 COMPDTE Complete Date DT_Date Date 6 16 COMPTME Complete Time TM6 Time 6 17 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SVC_RMA_MSTR_HIST'].USERID AS 'SVC_RMA_MSTR_HIST-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVC35000 AS ['SVC_RMA_MSTR_HIST']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SVC_RMA_MSTR_HIST'].USERID = ['Users Master'].USERID18 OFFID Office ID STR10_LBAU String 10 19 RTRNNAME Return Address Name STR44_LBU String 44 20 RETADDR1 Return Address 1 STR60 String 60 21 RETADDR2 Return Address 2 STR60 String 60 22 RETADDR3 Return Address 3 STR60 String 60 23 RTRNCITY Return Address City STR20_LBU String 20 24 SVC_Return_State SVC Return State STR30_State String 29 25 RTRNZIP Return Address Zip Code STR10 String 10 26 Return_Country Return Country STR60 String 60 27 LOCNCODE Location Code STR10_Location_Code String 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['SVC_RMA_MSTR_HIST'].LOCNCODE AS 'SVC_RMA_MSTR_HIST-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
SVC35000 AS ['SVC_RMA_MSTR_HIST']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['SVC_RMA_MSTR_HIST'].LOCNCODE = ['Site Setup'].LOCNCODE28 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['SVC_RMA_MSTR_HIST'].CUSTNMBR AS 'SVC_RMA_MSTR_HIST-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVC35000 AS ['SVC_RMA_MSTR_HIST']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SVC_RMA_MSTR_HIST'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR29 ADRSCODE Address Code STR15_Address_Code String 15 30 CUSTNAME Customer Name STR64_Customer_Name String 64 31 CONTACT Contact STR60 String 60 32 ADDRESS1 Address 1 STR60 String 60 33 ADDRESS2 Address 2 STR60 String 60 34 ADDRESS3 Address 3 STR60 String 60 35 CITY City STR35 String 35 36 STATE State STR30_State String 29 37 ZIPCODE Zip Code STR10 String 10 38 COUNTRY Country STR60 String 60 39 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['SVC_RMA_MSTR_HIST'].NOTEINDX AS 'SVC_RMA_MSTR_HIST-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
SVC35000 AS ['SVC_RMA_MSTR_HIST']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['SVC_RMA_MSTR_HIST'].NOTEINDX = ['Record Notes Master'].NOTEINDX40 CALLNBR Service Call Number STR10_LBAU String 10 41 SRVRECTYPE Service Record Type DDL_Service_Record_Type Integer 0 42 EQPLINE Equipment Line Item Sequence LI_Sequence_Number Long Integer 10 43 LNITMSEQ Line Item Sequence LI_Sequence_Number Long Integer 10 44 Bill_of_Lading Bill of Lading STR30 String 30 45 SHIPMTHD Shipping Method STR15_Shipping_Method String 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['SVC_RMA_MSTR_HIST'].SHIPMTHD AS 'SVC_RMA_MSTR_HIST-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
SVC35000 AS ['SVC_RMA_MSTR_HIST']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['SVC_RMA_MSTR_HIST'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD46 SOPTYPE SOP Type DDL_SOP_Type Integer 0 47 SOPNUMBE SOP Number STR20_SOP_Number String 17 48 SOP_Line_Item_Sequence SOP Line Item Sequence LI_Sequence_Number Long Integer 10 49 CMPNTSEQ Component Sequence LI_Sequence_Number Long Integer 10 50 Bill_To_Customer Bill To Customer STR15_RM_Customer_Number String 15 51 SVC_Bill_To_Address_Code SVC Bill To Address Code STR15_Address_Code String 15 52 Commit_Date Commit Date DT_Date Date 6 53 Commit_Time Commit Time TM6 Time 6 54 USERDEF1 User Defined 1 STR20 String 20 55 USERDEF2 User Defined 2 STR20 String 20 56 USRDEF03 User Defined 3 STR20 String 20 57 USRDEF04 User Defined 4 STR20 String 20 58 USRDEF05 User Defined 5 STR20 String 20 59 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['SVC_RMA_MSTR_HIST'].CURNCYID AS 'SVC_RMA_MSTR_HIST-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
SVC35000 AS ['SVC_RMA_MSTR_HIST']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SVC_RMA_MSTR_HIST'].CURNCYID = ['Currency Setup'].CURNCYID60 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['SVC_RMA_MSTR_HIST'].CURRNIDX AS 'SVC_RMA_MSTR_HIST-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
SVC35000 AS ['SVC_RMA_MSTR_HIST']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SVC_RMA_MSTR_HIST'].CURRNIDX = ['Currency Setup'].CURRNIDX61 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['SVC_RMA_MSTR_HIST'].RATETPID AS 'SVC_RMA_MSTR_HIST-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
SVC35000 AS ['SVC_RMA_MSTR_HIST']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['SVC_RMA_MSTR_HIST'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID62 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['SVC_RMA_MSTR_HIST'].EXGTBLID AS 'SVC_RMA_MSTR_HIST-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
SVC35000 AS ['SVC_RMA_MSTR_HIST']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['SVC_RMA_MSTR_HIST'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID63 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 64 EXCHDATE Exchange Date DT_Date Date 6 65 DECPLACS Decimal Places DDL_Decimal_Places Integer 0 66 TIME1 Time TM6 Time 6 67 RATECALC Rate Calc Method INT Integer 0 68 VIEWMODE View Mode INT Integer 0 69 ISMCTRX IS MC Trx INT Integer 0 70 EXPNDATE Expiration Date DT_Date Date 6 71 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 72 MCTRXSTT MC Transaction State INT1 Integer 1 73 CSTPONBR Customer PO Number STR20_Document_Number String 20 74 SVC_RMA_Reason_Code SVC_RMA_Reason_Code STR3_LBAU String 3 75 SVC_RMA_Reason_Code_Desc SVC_RMA_Reason_Code_Desc STR30 String 30 76 SVC_RMA_From_Service SVC RMA From Service Boolean Boolean 0 77 SVC_FO_ID SVC FO ID STR50 String 50 78 DEX_ROW_ID int int 10