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