Returns Master (SVC05000)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC05000

Product: FieldService (949)
Series:

Display Name: Returns Master
Physical Name: SVC05000
Technical Name: SVC_RMA_MSTR

Group Display Name: Service Table Group
Group Technical Name: Service

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1RETDOCID SearchReturn Document IDStringSTR15_LBAU15
2Return_Record_Type SearchReturn Record TypeIntegerDDL_Return_Record_Type0
3RMA_Status SearchRMA StatusIntegerINT0
4Received SearchReceivedBooleanCB_Received0
5RETORIG SearchReturn OriginIntegerDDL_Return0
6RETREF SearchReturn ReferenceStringSTR30_LBAU30
7RETSTAT SearchReturn StatusStringSTR3_LBAU3
8RETTYPE SearchSVC Return TypeStringSTR10_LBAU10
9ENTDTE SearchEntry DateDateDT_Date6
10ENTTME SearchEntry TimeTimeTM66
11ETADTE SearchETA DateDateDT_Date6
12ETATME SearchETA TimeTimeTM66
13RETUDATE SearchReturn DateDateDT8
14Return_Time SearchReturn TimeTimeTM66
15COMPDTE SearchComplete DateDateDT_Date6
16COMPTME SearchComplete TimeTimeTM66
17USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Returns Master'].USERID AS 'Returns Master-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVC05000 AS ['Returns Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Returns Master'].USERID = ['Users Master'].USERID
18OFFID SearchOffice IDStringSTR10_LBAU10
19RTRNNAME SearchReturn Address NameStringSTR44_LBU44
20RETADDR1 SearchReturn Address 1StringSTR6060
21RETADDR2 SearchReturn Address 2StringSTR6060
22RETADDR3 SearchReturn Address 3StringSTR6060
23RTRNCITY SearchReturn Address CityStringSTR20_LBU20
24SVC_Return_State SearchSVC Return StateStringSTR30_State29
25RTRNZIP SearchReturn Address Zip CodeStringSTR1010
26Return_Country SearchReturn CountryStringSTR6060
27LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Returns Master'].LOCNCODE AS 'Returns Master-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SVC05000 AS ['Returns Master']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Returns Master'].LOCNCODE = ['Site Setup'].LOCNCODE
28CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Returns Master'].CUSTNMBR AS 'Returns Master-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVC05000 AS ['Returns Master']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Returns Master'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
29ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
30CUSTNAME SearchCustomer NameStringSTR64_Customer_Name64
31CONTACT SearchContactStringSTR6060
32ADDRESS1 SearchAddress 1StringSTR6060
33ADDRESS2 SearchAddress 2StringSTR6060
34ADDRESS3 SearchAddress 3StringSTR6060
35CITY SearchCityStringSTR3535
36STATE SearchStateStringSTR30_State29
37ZIPCODE SearchZip CodeStringSTR1010
38COUNTRY SearchCountryStringSTR6060
39NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Returns Master'].NOTEINDX AS 'Returns Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SVC05000 AS ['Returns Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Returns Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
40CALLNBR SearchService Call NumberStringSTR10_LBAU10
41SRVRECTYPE SearchService Record TypeIntegerDDL_Service_Record_Type0
42EQPLINE SearchEquipment Line Item SequenceLong IntegerLI_Sequence_Number10
43LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
44Bill_of_Lading SearchBill of LadingStringSTR3030
45SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Returns Master'].SHIPMTHD AS 'Returns Master-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       SVC05000 AS ['Returns Master']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Returns Master'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
46SOPTYPE SearchSOP TypeIntegerDDL_SOP_Type0
47SOPNUMBE SearchSOP NumberStringSTR20_SOP_Number17
48SOP_Line_Item_Sequence SearchSOP Line Item SequenceLong IntegerLI_Sequence_Number10
49CMPNTSEQ SearchComponent SequenceLong IntegerLI_Sequence_Number10
50Bill_To_Customer SearchBill To CustomerStringSTR15_RM_Customer_Number15
51SVC_Bill_To_Address_Code SearchSVC Bill To Address CodeStringSTR15_Address_Code15
52Commit_Date SearchCommit DateDateDT_Date6
53Commit_Time SearchCommit TimeTimeTM66
54USERDEF1 SearchUser Defined 1StringSTR2020
55USERDEF2 SearchUser Defined 2StringSTR2020
56USRDEF03 SearchUser Defined 3StringSTR2020
57USRDEF04 SearchUser Defined 4StringSTR2020
58USRDEF05 SearchUser Defined 5StringSTR2020
59CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Returns Master'].CURNCYID AS 'Returns Master-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       SVC05000 AS ['Returns Master']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Returns Master'].CURNCYID = ['Currency Setup'].CURNCYID
60CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Returns Master'].CURRNIDX AS 'Returns Master-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       SVC05000 AS ['Returns Master']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Returns Master'].CURRNIDX = ['Currency Setup'].CURRNIDX
61RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Returns Master'].RATETPID AS 'Returns Master-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       SVC05000 AS ['Returns Master']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Returns Master'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
62EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['Returns Master'].EXGTBLID AS 'Returns Master-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       SVC05000 AS ['Returns Master']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Returns Master'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
63XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
64EXCHDATE SearchExchange DateDateDT_Date6
65DECPLACS SearchDecimal PlacesIntegerDDL_Decimal_Places0
66TIME1 SearchTimeTimeTM66
67RATECALC SearchRate Calc MethodIntegerINT0
68VIEWMODE SearchView ModeIntegerINT0
69ISMCTRX SearchIS MC TrxIntegerINT0
70EXPNDATE SearchExpiration DateDateDT_Date6
71DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
72MCTRXSTT SearchMC Transaction StateIntegerINT11
73CSTPONBR SearchCustomer PO NumberStringSTR20_Document_Number20
74SVC_RMA_Reason_Code SearchSVC_RMA_Reason_CodeStringSTR3_LBAU3
75SVC_RMA_Reason_Code_Desc SearchSVC_RMA_Reason_Code_DescStringSTR3030
76SVC_RMA_From_Service SearchSVC RMA From ServiceBooleanBoolean0
77SVC_FO_ID SearchSVC FO IDStringSTR5050

Leave a Reply

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