SVC_RMA_MSTR_View_All (SVC5000V)

azurecurveProductsFieldService (949)ProjectSVC_RMA_MSTR_View_All (SVC5000V)

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_All

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1RETDOCID SearchReturn Document IDStringSTR15_LBAU15
2Return_Record_Type SearchReturn Record TypeIntegerDDL_Return_Record_Type0
3RETSTAT SearchReturn StatusStringSTR3_LBAU3
4OFFID SearchOffice IDStringSTR10_LBAU10
5LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
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
6CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
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
7CUSTNAME SearchCustomer NameStringSTR64_Customer_Name64
8SOP_Line_Item_Sequence SearchSOP Line Item SequenceLong IntegerLI_Sequence_Number10
9SOPNUMBE SearchSOP NumberStringSTR20_SOP_Number17
10RMA_Status SearchRMA StatusIntegerINT0
11ADDRESS1 SearchAddress 1StringSTR6060
12ADDRESS2 SearchAddress 2StringSTR6060
13ADDRESS3 SearchAddress 3StringSTR6060
14ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
15Bill_To_Customer SearchBill To CustomerStringSTR15_RM_Customer_Number15
16Bill_of_Lading SearchBill of LadingStringSTR3030
17CITY SearchCityStringSTR3535
18Commit_Date SearchCommit DateDateDT_Date6
19Commit_Time SearchCommit TimeTimeTM66
20COMPDTE SearchComplete DateDateDT_Date6
21COMPTME SearchComplete TimeTimeTM66
22CMPNTSEQ SearchComponent SequenceLong IntegerLI_Sequence_Number10
23CONTACT SearchContactStringSTR6060
24COUNTRY SearchCountryStringSTR6060
25CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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
26CSTPONBR SearchCustomer PO NumberStringSTR20_Document_Number20
27CURRNIDX SearchCurrency IndexIntegerINT33
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
28DECPLACS SearchDecimal PlacesIntegerDDL_Decimal_Places0
29RETTYPE SearchSVC Return TypeStringSTR10_LBAU10
30RETREF SearchReturn ReferenceStringSTR30_LBAU30
31Return_Time SearchReturn TimeTimeTM66
32DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
33ETADTE SearchETA DateDateDT_Date6
34ETATME SearchETA TimeTimeTM66
35ENTDTE SearchEntry DateDateDT_Date6
36ENTTME SearchEntry TimeTimeTM66
37EQPLINE SearchEquipment Line Item SequenceLong IntegerLI_Sequence_Number10
38EXCHDATE SearchExchange DateDateDT_Date6
39XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
40EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
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
41EXPNDATE SearchExpiration DateDateDT_Date6
42ISMCTRX SearchIS MC TrxIntegerINT0
43LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
44MCTRXSTT SearchMC Transaction StateIntegerINT11
45NOTEINDX SearchNote IndexCurrencyDLR1414
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
46RATECALC SearchRate Calc MethodIntegerINT0
47RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
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
48Received SearchReceivedBooleanCB_Received0
49RETADDR1 SearchReturn Address 1StringSTR6060
50RETADDR2 SearchReturn Address 2StringSTR6060
51RETADDR3 SearchReturn Address 3StringSTR6060
52RTRNCITY SearchReturn Address CityStringSTR20_LBU20
53RTRNNAME SearchReturn Address NameStringSTR44_LBU44
54RTRNZIP SearchReturn Address Zip CodeStringSTR1010
55Return_Country SearchReturn CountryStringSTR6060
56RETUDATE SearchReturn DateDateDT8
57RETORIG SearchReturn OriginIntegerDDL_Return0
58SOPTYPE SearchSOP TypeIntegerDDL_SOP_Type0
59SVC_Bill_To_Address_Code SearchSVC Bill To Address CodeStringSTR15_Address_Code15
60SVC_FO_ID SearchSVC FO IDStringSTR5050
61SVC_RMA_From_Service SearchSVC RMA From ServiceBooleanBoolean0
62SVC_Return_State SearchSVC Return StateStringSTR30_State29
63SVC_RMA_Reason_Code SearchSVC_RMA_Reason_CodeStringSTR3_LBAU3
64SVC_RMA_Reason_Code_Desc SearchSVC_RMA_Reason_Code_DescStringSTR3030
65CALLNBR SearchService Call NumberStringSTR10_LBAU10
66SRVRECTYPE SearchService Record TypeIntegerDDL_Service_Record_Type0
67SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
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
68STATE SearchStateStringSTR30_State29
69TIME1 SearchTimeTimeTM66
70USERDEF1 SearchUser Defined 1StringSTR2020
71USERDEF2 SearchUser Defined 2StringSTR2020
72USRDEF03 SearchUser Defined 3StringSTR2020
73USRDEF04 SearchUser Defined 4StringSTR2020
74USRDEF05 SearchUser Defined 5StringSTR2020
75USERID SearchUser IDStringSTR15_User_ID15
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
76VIEWMODE SearchView ModeIntegerINT0
77ZIPCODE SearchZip CodeStringSTR1010
azurecurveProductsFieldService (949)ProjectSVC_RMA_MSTR_View_All (SVC5000V)

Leave a Reply

Your email address will not be published. Required fields are marked *