Returns Line Master (SVC05200)

azurecurveProductsFieldService (949)ProjectReturns Line Master (SVC05200)

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

Product: FieldService (949)
Series:

Display Name: Returns Line Master
Physical Name: SVC05200
Technical Name: SVC_RMA_Line

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
3LNSEQNBR SearchLine SEQ NumberCurrencySequence_Number19
4SVC_Next_Line_SEQ_Number SearchSVC Next Line SEQ NumberCurrencySequence_Number19
5SVC_Prev_Line_SEQ_Number SearchSVC Prev Line SEQ NumberCurrencySequence_Number19
6RETTYPE SearchSVC Return TypeStringSTR10_LBAU10
7RMA_Status SearchRMA StatusIntegerINT0
8RETSTAT SearchReturn StatusStringSTR3_LBAU3
9Received SearchReceivedBooleanCB_Received0
10Traveler_Printed SearchTraveler PrintedBooleanCB_Traveler_Printed0
11SVC_Ready_To_Close SearchSVC Ready To CloseBooleanCB_Ready_To_Close0
12SVC_RMA_Reason_Code SearchSVC_RMA_Reason_CodeStringSTR3_LBAU3
13SVC_RMA_Reason_Code_Desc SearchSVC_RMA_Reason_Code_DescStringSTR3030
14NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Returns Line Master'].NOTEINDX AS 'Returns Line Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SVC05200 AS ['Returns Line Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Returns Line Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
15RETORIG SearchReturn OriginIntegerDDL_Return0
16RETREF SearchReturn ReferenceStringSTR30_LBAU30
17SRVRECTYPE SearchService Record TypeIntegerDDL_Service_Record_Type0
18CALLNBR SearchService Call NumberStringSTR10_LBAU10
19EQPLINE SearchEquipment Line Item SequenceLong IntegerLI_Sequence_Number10
20LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
21SVC_RMA_From_Service SearchSVC RMA From ServiceBooleanBoolean0
22SOPTYPE SearchSOP TypeIntegerDDL_SOP_Type0
23SOPNUMBE SearchSOP NumberStringSTR20_SOP_Number17
24CMPNTSEQ SearchComponent SequenceLong IntegerLI_Sequence_Number10
25SOP_Line_Item_Sequence SearchSOP Line Item SequenceLong IntegerLI_Sequence_Number10
26ENTDTE SearchEntry DateDateDT_Date6
27ENTTME SearchEntry TimeTimeTM66
28ETADTE SearchETA DateDateDT_Date6
29ETATME SearchETA TimeTimeTM66
30Commit_Date SearchCommit DateDateDT_Date6
31Commit_Time SearchCommit TimeTimeTM66
32RETUDATE SearchReturn DateDateDT8
33Return_Time SearchReturn TimeTimeTM66
34COMPDTE SearchComplete DateDateDT_Date6
35COMPTME SearchComplete TimeTimeTM66
36PRMDATE SearchPromised DateDateDATE_L0
37REFRENCE SearchReferenceStringSTR3030
38USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Returns Line Master'].USERID AS 'Returns Line Master-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVC05200 AS ['Returns Line Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Returns Line Master'].USERID = ['Users Master'].USERID
39OFFID SearchOffice IDStringSTR10_LBAU10
40LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Returns Line Master'].LOCNCODE AS 'Returns Line Master-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SVC05200 AS ['Returns Line Master']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Returns Line Master'].LOCNCODE = ['Site Setup'].LOCNCODE
41RTRNNAME SearchReturn Address NameStringSTR44_LBU44
42RETADDR1 SearchReturn Address 1StringSTR6060
43RETADDR2 SearchReturn Address 2StringSTR6060
44RETADDR3 SearchReturn Address 3StringSTR6060
45RTRNCITY SearchReturn Address CityStringSTR20_LBU20
46SVC_Return_State SearchSVC Return StateStringSTR30_State29
47RTRNZIP SearchReturn Address Zip CodeStringSTR1010
48Return_Country SearchReturn CountryStringSTR6060
49CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Returns Line Master'].CUSTNMBR AS 'Returns Line Master-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVC05200 AS ['Returns Line Master']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Returns Line Master'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
50CUSTNAME SearchCustomer NameStringSTR64_Customer_Name64
51ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
52CONTACT SearchContactStringSTR6060
53ADDRESS1 SearchAddress 1StringSTR6060
54ADDRESS2 SearchAddress 2StringSTR6060
55ADDRESS3 SearchAddress 3StringSTR6060
56CITY SearchCityStringSTR3535
57STATE SearchStateStringSTR30_State29
58ZIPCODE SearchZip CodeStringSTR1010
59COUNTRY SearchCountryStringSTR6060
60Bill_To_Customer SearchBill To CustomerStringSTR15_RM_Customer_Number15
61SVC_Bill_To_Address_Code SearchSVC Bill To Address CodeStringSTR15_Address_Code15
62CSTPONBR SearchCustomer PO NumberStringSTR20_Document_Number20
63QUANTITY SearchQTYCurrencyDLR17_QTY_RBS0_STR17
64DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
65UOFM SearchU Of MStringU_Of_M8
66ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Returns Line Master'].ITEMNMBR AS 'Returns Line Master-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SVC05200 AS ['Returns Line Master']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Returns Line Master'].ITEMNMBR = ['Item Master'].ITEMNMBR
67ITEMDESC SearchItem DescriptionStringSTR100100
68UNITCOST SearchUnit CostCurrencyDLR17_RBS0_UTR$17
69ORUNTCST SearchOriginating Unit CostCurrencyDLR17_RBS0_UTR$17
70EXTDCOST SearchExtended CostCurrencyDLR17_RBS0_UTR$17
71OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
72UNITPRCE SearchUnit PriceCurrencyDLR17_RBS0_STR$17
73ORUNTPRC SearchOriginating Unit PriceCurrencyDLR17_RBS0_STR$17
74XTNDPRCE SearchExtended PriceCurrencyDLR17_RBS0_STR$17
75OXTNDPRC SearchOriginating Extended PriceCurrencyDLR17_RBS0_STR$17
76CUSTOWN SearchCustomer OwnedBooleanCB0
77FACTSEAL SearchFactory SealedBooleanCB0
78ORDDOCID SearchOrder Document IDStringSTR15_LBAU15
79TRANSLINESEQ SearchTransfer Line Item SequenceLong IntegerLI_Sequence_Number10
80STATUS SearchTransfer StatusIntegerINT0
81Flat_Rate_Repair_Price SearchFlat Rate Repair PriceCurrencyDLR17_RBSO_STR$17
82Orig_Flat_RepairPrice SearchOriginating Flat Rate Repair PriceCurrencyDLR17_RBS0_STR$17
83Repair_Price SearchRepair PriceCurrencyDLR17_RBSO_STR$17
84Originating_Repair_Price SearchOriginating Repair PriceCurrencyDLR17_RBS0_STR$17
85NTE_Price SearchNTE PriceCurrencyDLR17_RBS0_UTR$17
86Originating_NTE_Price SearchOriginating NTE PriceCurrencyDLR17_RBS0_UTR$17
87Repair_Cost SearchRepair CostCurrencyDLR17_RBS0_UTR$17
88Originating_Repair_Cost SearchOriginating Repair CostCurrencyDLR17_RBS0_UTR$17
89Bill_of_Lading SearchBill of LadingStringSTR3030
90SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Returns Line Master'].SHIPMTHD AS 'Returns Line Master-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       SVC05200 AS ['Returns Line Master']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Returns Line Master'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
91Credit_SOP_Type SearchCredit SOP TypeIntegerDDL_SOP_Type0
92Credit_SOP_Number SearchCredit SOP NumberStringSTR20_SOP_Number17
93Credit_SOP_Line_Item_Seq SearchCredit SOP Line Item SequenceLong IntegerLI_Sequence_Number10
94Replace_SOP_Type SearchReplace SOP TypeIntegerDDL_SOP_Type0
95Replace_SOP_Number SearchReplace SOP NumberStringSTR20_SOP_Number17
96Replace_SOP_Line_Item_Se SearchReplace SOP Line Item SequenceLong IntegerLI_Sequence_Number10
97Location_Code_Replacemen SearchLocation Code ReplacementStringSTR10_Location_Code10
98Replace_Item_Number SearchReplace Item NumberStringSTR30_Item_Number30
99Replace_U_Of_M SearchReplace U Of MStringU_Of_M8
100Replace_Price_Level SearchReplace Price LevelStringSTR10_LBAU10
101Replace_QTY SearchReplace QTYCurrencyDLR17_QTY_RBS0_UTR17
102Replace_Cost SearchReplace CostCurrencyDLR17_RBS0_STR$17
103Originating_Replace_Cost SearchOriginating Replace CostCurrencyDLR17_RBS0_STR$17
104Replace_Price SearchReplace PriceCurrencyDLR17_RBS0_STR$17
105Originating_Replace_Pric SearchOriginating Replace PriceCurrencyDLR17_RBS0_STR$17
106SOP_Number_Invoice SearchSOP Number InvoiceStringSTR20_SOP_Number17
107Item_Number_Invoice SearchItem Number InvoiceStringSTR30_Item_Number30
108USERDEF1 SearchUser Defined 1StringSTR2020
109USERDEF2 SearchUser Defined 2StringSTR2020
110USRDEF03 SearchUser Defined 3StringSTR2020
111USRDEF04 SearchUser Defined 4StringSTR2020
112USRDEF05 SearchUser Defined 5StringSTR2020
113CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Returns Line Master'].CURRNIDX AS 'Returns Line Master-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       SVC05200 AS ['Returns Line Master']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Returns Line Master'].CURRNIDX = ['Currency Setup'].CURRNIDX
114DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
115ODECPLCU SearchOriginating Decimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
116Return_Item_Number SearchReturn Item NumberStringSTR30_Item_Number30
117Return_Item_Description SearchReturn Item DescriptionStringSTR100100
118Return_Location_Code SearchReturn Location CodeStringSTR10_Location_Code10
119Return_QTY SearchReturn QTYCurrencyDLR17_QTY_RBS0_UTR17
120Return_U_Of_M SearchReturn U Of MStringU_Of_M8
121RETCOST SearchReturn CostCurrencyDLR17_$S217
122Originating_Return_Cost SearchOriginating Return CostCurrencyDLR17_RBS0_STR$17
123SVC_Extended_Return_Cost SearchSVC Extended Return CostCurrencyDLR17_$S217
124SVC_Orig_Ext_Return_Cost SearchSVC Originating Extended Return CostCurrencyDLR17_$S217
125SVC_Return_Price_Level SearchSVC Return Price LevelStringSTR10_LBAU10
126SVC_Return_Price SearchSVC Return PriceCurrencyDLR17_RBS0_STR$17
127Originating_Return_Price SearchOriginating Return PriceCurrencyDLR17_RBS0_STR$17
128SVC_Extended_Return_Pric SearchSVC Extended Return PriceCurrencyDLR17_$S217
129SVC_Orig_Ext_Return_Pric SearchSVC Originating Extended Return PriceCurrencyDLR17_$S217
130SVC_FO_ID SearchSVC FO IDStringSTR5050
131SVC_SCM_Complete SearchSVC SCM CompleteIntegerINT0
132svcRMAKitComponentFrom SearchsvcRMAKitComponentFromIntegerRMAKitFromDDL0
133svcRMAComponentSeq SearchsvcRMAComponentSeqLong IntegerLI_Sequence_Number10
134CMPITQTY SearchComponent Item QTYCurrencyDLR17_QTY_RBS0_UTR17
135QTYONHND SearchQTY On HandCurrencyDLR17_QTY_RBS0_STR17
136QTYRTRND SearchQTY ReturnedCurrencyDLR17_QTY_RBS0_UTR17
137QTYINUSE SearchQTY In UseCurrencyDLR17_QTY_RBS0_UTR17
138QTYINSVC SearchQTY In ServiceCurrencyDLR17_QTY_RBS0_UTR17
139QTYDMGED SearchQTY DamagedCurrencyDLR17_QTY_RBS0_UTR17
140svcReverseFlag SearchsvcReverseFlagBooleanCB0
141svcRMAallocated SearchsvcRMAallocatedBooleanCB0
azurecurveProductsFieldService (949)ProjectReturns Line Master (SVC05200)

Leave a Reply

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