Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC35000
Product: FieldService (949)
Series:
Display Name: SVC_RMA_MSTR_HIST
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 String STR15_LBAU 15 2 Return_Record_Type Return Record Type Integer DDL_Return_Record_Type 0 3 RMA_Status RMA Status Integer INT 0 4 Received Received Boolean CB_Received 0 5 RETORIG Return Origin Integer DDL_Return 0 6 RETREF Return Reference String STR30_LBAU 30 7 RETSTAT Return Status String STR3_LBAU 3 8 RETTYPE SVC Return Type String STR10_LBAU 10 9 ENTDTE Entry Date Date DT_Date 6 10 ENTTME Entry Time Time TM6 6 11 ETADTE ETA Date Date DT_Date 6 12 ETATME ETA Time Time TM6 6 13 RETUDATE Return Date Date DT 8 14 Return_Time Return Time Time TM6 6 15 COMPDTE Complete Date Date DT_Date 6 16 COMPTME Complete Time Time TM6 6 17 USERID User ID String STR15_User_ID 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 String STR10_LBAU 10 19 RTRNNAME Return Address Name String STR44_LBU 44 20 RETADDR1 Return Address 1 String STR60 60 21 RETADDR2 Return Address 2 String STR60 60 22 RETADDR3 Return Address 3 String STR60 60 23 RTRNCITY Return Address City String STR20_LBU 20 24 SVC_Return_State SVC Return State String STR30_State 29 25 RTRNZIP Return Address Zip Code String STR10 10 26 Return_Country Return Country String STR60 60 27 LOCNCODE Location Code String STR10_Location_Code 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 String STR15_RM_Customer_Number 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 String STR15_Address_Code 15 30 CUSTNAME Customer Name String STR64_Customer_Name 64 31 CONTACT Contact String STR60 60 32 ADDRESS1 Address 1 String STR60 60 33 ADDRESS2 Address 2 String STR60 60 34 ADDRESS3 Address 3 String STR60 60 35 CITY City String STR35 35 36 STATE State String STR30_State 29 37 ZIPCODE Zip Code String STR10 10 38 COUNTRY Country String STR60 60 39 NOTEINDX Note Index Currency DLR14 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 String STR10_LBAU 10 41 SRVRECTYPE Service Record Type Integer DDL_Service_Record_Type 0 42 EQPLINE Equipment Line Item Sequence Long Integer LI_Sequence_Number 10 43 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 44 Bill_of_Lading Bill of Lading String STR30 30 45 SHIPMTHD Shipping Method String STR15_Shipping_Method 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 Integer DDL_SOP_Type 0 47 SOPNUMBE SOP Number String STR20_SOP_Number 17 48 SOP_Line_Item_Sequence SOP Line Item Sequence Long Integer LI_Sequence_Number 10 49 CMPNTSEQ Component Sequence Long Integer LI_Sequence_Number 10 50 Bill_To_Customer Bill To Customer String STR15_RM_Customer_Number 15 51 SVC_Bill_To_Address_Code SVC Bill To Address Code String STR15_Address_Code 15 52 Commit_Date Commit Date Date DT_Date 6 53 Commit_Time Commit Time Time TM6 6 54 USERDEF1 User Defined 1 String STR20 20 55 USERDEF2 User Defined 2 String STR20 20 56 USRDEF03 User Defined 3 String STR20 20 57 USRDEF04 User Defined 4 String STR20 20 58 USRDEF05 User Defined 5 String STR20 20 59 CURNCYID Currency ID String STR15_Currency_ID 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 Integer INT3 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 String STR15_Rate_Type_ID 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 String STR15_Exchange_Table_ID 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 Currency (Variable) DLR14_Exchange_Rate 14 64 EXCHDATE Exchange Date Date DT_Date 6 65 DECPLACS Decimal Places Integer DDL_Decimal_Places 0 66 TIME1 Time Time TM6 6 67 RATECALC Rate Calc Method Integer INT 0 68 VIEWMODE View Mode Integer INT 0 69 ISMCTRX IS MC Trx Integer INT 0 70 EXPNDATE Expiration Date Date DT_Date 6 71 DENXRATE Denomination Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 72 MCTRXSTT MC Transaction State Integer INT1 1 73 CSTPONBR Customer PO Number String STR20_Document_Number 20 74 SVC_RMA_Reason_Code SVC_RMA_Reason_Code String STR3_LBAU 3 75 SVC_RMA_Reason_Code_Desc SVC_RMA_Reason_Code_Desc String STR30 30 76 SVC_RMA_From_Service SVC RMA From Service Boolean Boolean 0 77 SVC_FO_ID SVC FO ID String STR50 50