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