SVC_RMA_Line_HIST (SVC35200)

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

Product: FieldService (949)
Series: Project

Display Name: SVC_RMA_Line_HIST
Physical Name: SVC35200
Technical Name: SVC_RMA_Line_HIST

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1RETDOCID SearchReturn Document IDSTR15_LBAUString1615
2Return_Record_Type SearchReturn Record TypeDDL_Return_Record_TypeInteger20
3LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency1019
4SVC_Next_Line_SEQ_Number SearchSVC Next Line SEQ NumberSequence_NumberCurrency1019
5SVC_Prev_Line_SEQ_Number SearchSVC Prev Line SEQ NumberSequence_NumberCurrency1019
6RETTYPE SearchSVC Return TypeSTR10_LBAUString1210
7RMA_Status SearchRMA StatusINTInteger20
8RETSTAT SearchReturn StatusSTR3_LBAUString43
9Received SearchReceivedCB_ReceivedBoolean20
10Traveler_Printed SearchTraveler PrintedCB_Traveler_PrintedBoolean20
11SVC_Ready_To_Close SearchSVC Ready To CloseCB_Ready_To_CloseBoolean20
12SVC_RMA_Reason_Code SearchSVC_RMA_Reason_CodeSTR3_LBAUString43
13SVC_RMA_Reason_Code_Desc SearchSVC_RMA_Reason_Code_DescSTR30String3230
14NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SVC_RMA_Line_HIST'].NOTEINDX AS 'SVC_RMA_Line_HIST-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SVC35200 AS ['SVC_RMA_Line_HIST']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SVC_RMA_Line_HIST'].NOTEINDX = ['Record Notes Master'].NOTEINDX
15RETORIG SearchReturn OriginDDL_ReturnInteger20
16RETREF SearchReturn ReferenceSTR30_LBAUString3230
17SRVRECTYPE SearchService Record TypeDDL_Service_Record_TypeInteger20
18CALLNBR SearchService Call NumberSTR10_LBAUString1210
19EQPLINE SearchEquipment Line Item SequenceLI_Sequence_NumberLong Integer410
20LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
21SVC_RMA_From_Service SearchSVC RMA From ServiceBooleanBoolean20
22SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger20
23SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString2217
24CMPNTSEQ SearchComponent SequenceLI_Sequence_NumberLong Integer410
25SOP_Line_Item_Sequence SearchSOP Line Item SequenceLI_Sequence_NumberLong Integer410
26ENTDTE SearchEntry DateDT_DateDate46
27ENTTME SearchEntry TimeTM6Time46
28ETADTE SearchETA DateDT_DateDate46
29ETATME SearchETA TimeTM6Time46
30Commit_Date SearchCommit DateDT_DateDate46
31Commit_Time SearchCommit TimeTM6Time46
32RETUDATE SearchReturn DateDTDate48
33Return_Time SearchReturn TimeTM6Time46
34COMPDTE SearchComplete DateDT_DateDate46
35COMPTME SearchComplete TimeTM6Time46
36PRMDATE SearchPromised DateDATE_LDate40
37REFRENCE SearchReferenceSTR30String3230
38USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SVC_RMA_Line_HIST'].USERID AS 'SVC_RMA_Line_HIST-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVC35200 AS ['SVC_RMA_Line_HIST']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SVC_RMA_Line_HIST'].USERID = ['Users Master'].USERID
39OFFID SearchOffice IDSTR10_LBAUString1210
40LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['SVC_RMA_Line_HIST'].LOCNCODE AS 'SVC_RMA_Line_HIST-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SVC35200 AS ['SVC_RMA_Line_HIST']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['SVC_RMA_Line_HIST'].LOCNCODE = ['Site Setup'].LOCNCODE
41RTRNNAME SearchReturn Address NameSTR44_LBUString4644
42RETADDR1 SearchReturn Address 1STR60String6260
43RETADDR2 SearchReturn Address 2STR60String6260
44RETADDR3 SearchReturn Address 3STR60String6260
45RTRNCITY SearchReturn Address CitySTR20_LBUString2220
46SVC_Return_State SearchSVC Return StateSTR30_StateString3029
47RTRNZIP SearchReturn Address Zip CodeSTR10String1210
48Return_Country SearchReturn CountrySTR60String6260
49CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SVC_RMA_Line_HIST'].CUSTNMBR AS 'SVC_RMA_Line_HIST-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVC35200 AS ['SVC_RMA_Line_HIST']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SVC_RMA_Line_HIST'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
50CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
51ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
52CONTACT SearchContactSTR60String6260
53ADDRESS1 SearchAddress 1STR60String6260
54ADDRESS2 SearchAddress 2STR60String6260
55ADDRESS3 SearchAddress 3STR60String6260
56CITY SearchCitySTR35String3635
57STATE SearchStateSTR30_StateString3029
58ZIPCODE SearchZip CodeSTR10String1210
59COUNTRY SearchCountrySTR60String6260
60Bill_To_Customer SearchBill To CustomerSTR15_RM_Customer_NumberString1615
61SVC_Bill_To_Address_Code SearchSVC Bill To Address CodeSTR15_Address_CodeString1615
62CSTPONBR SearchCustomer PO NumberSTR20_Document_NumberString2220
63QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency1017
64DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
65UOFM SearchU Of MU_Of_MString108
66ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['SVC_RMA_Line_HIST'].ITEMNMBR AS 'SVC_RMA_Line_HIST-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SVC35200 AS ['SVC_RMA_Line_HIST']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['SVC_RMA_Line_HIST'].ITEMNMBR = ['Item Master'].ITEMNMBR
67ITEMDESC SearchItem DescriptionSTR100String102100
68UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
69ORUNTCST SearchOriginating Unit CostDLR17_RBS0_UTR$Currency1017
70EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency1017
71OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency1017
72UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency1017
73ORUNTPRC SearchOriginating Unit PriceDLR17_RBS0_STR$Currency1017
74XTNDPRCE SearchExtended PriceDLR17_RBS0_STR$Currency1017
75OXTNDPRC SearchOriginating Extended PriceDLR17_RBS0_STR$Currency1017
76CUSTOWN SearchCustomer OwnedCBBoolean20
77FACTSEAL SearchFactory SealedCBBoolean20
78ORDDOCID SearchOrder Document IDSTR15_LBAUString1615
79TRANSLINESEQ SearchTransfer Line Item SequenceLI_Sequence_NumberLong Integer410
80STATUS SearchTransfer StatusINTInteger20
81Flat_Rate_Repair_Price SearchFlat Rate Repair PriceDLR17_RBSO_STR$Currency1017
82Orig_Flat_RepairPrice SearchOriginating Flat Rate Repair PriceDLR17_RBS0_STR$Currency1017
83Repair_Price SearchRepair PriceDLR17_RBSO_STR$Currency1017
84Originating_Repair_Price SearchOriginating Repair PriceDLR17_RBS0_STR$Currency1017
85NTE_Price SearchNTE PriceDLR17_RBS0_UTR$Currency1017
86Originating_NTE_Price SearchOriginating NTE PriceDLR17_RBS0_UTR$Currency1017
87Repair_Cost SearchRepair CostDLR17_RBS0_UTR$Currency1017
88Originating_Repair_Cost SearchOriginating Repair CostDLR17_RBS0_UTR$Currency1017
89Bill_of_Lading SearchBill of LadingSTR30String3230
90SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['SVC_RMA_Line_HIST'].SHIPMTHD AS 'SVC_RMA_Line_HIST-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       SVC35200 AS ['SVC_RMA_Line_HIST']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['SVC_RMA_Line_HIST'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
91Credit_SOP_Type SearchCredit SOP TypeDDL_SOP_TypeInteger20
92Credit_SOP_Number SearchCredit SOP NumberSTR20_SOP_NumberString2217
93Credit_SOP_Line_Item_Seq SearchCredit SOP Line Item SequenceLI_Sequence_NumberLong Integer410
94Replace_SOP_Type SearchReplace SOP TypeDDL_SOP_TypeInteger20
95Replace_SOP_Number SearchReplace SOP NumberSTR20_SOP_NumberString2217
96Replace_SOP_Line_Item_Se SearchReplace SOP Line Item SequenceLI_Sequence_NumberLong Integer410
97Location_Code_Replacemen SearchLocation Code ReplacementSTR10_Location_CodeString1210
98Replace_Item_Number SearchReplace Item NumberSTR30_Item_NumberString3230
99Replace_U_Of_M SearchReplace U Of MU_Of_MString108
100Replace_Price_Level SearchReplace Price LevelSTR10_LBAUString1210
101Replace_QTY SearchReplace QTYDLR17_QTY_RBS0_UTRCurrency1017
102Replace_Cost SearchReplace CostDLR17_RBS0_STR$Currency1017
103Originating_Replace_Cost SearchOriginating Replace CostDLR17_RBS0_STR$Currency1017
104Replace_Price SearchReplace PriceDLR17_RBS0_STR$Currency1017
105Originating_Replace_Pric SearchOriginating Replace PriceDLR17_RBS0_STR$Currency1017
106SOP_Number_Invoice SearchSOP Number InvoiceSTR20_SOP_NumberString2217
107Item_Number_Invoice SearchItem Number InvoiceSTR30_Item_NumberString3230
108USERDEF1 SearchUser Defined 1STR20String2220
109USERDEF2 SearchUser Defined 2STR20String2220
110USRDEF03 SearchUser Defined 3STR20String2220
111USRDEF04 SearchUser Defined 4STR20String2220
112USRDEF05 SearchUser Defined 5STR20String2220
113CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SVC_RMA_Line_HIST'].CURRNIDX AS 'SVC_RMA_Line_HIST-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       SVC35200 AS ['SVC_RMA_Line_HIST']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SVC_RMA_Line_HIST'].CURRNIDX = ['Currency Setup'].CURRNIDX
114DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
115ODECPLCU SearchOriginating Decimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
116Return_Item_Number SearchReturn Item NumberSTR30_Item_NumberString3230
117Return_Item_Description SearchReturn Item DescriptionSTR100String102100
118Return_Location_Code SearchReturn Location CodeSTR10_Location_CodeString1210
119Return_QTY SearchReturn QTYDLR17_QTY_RBS0_UTRCurrency1017
120Return_U_Of_M SearchReturn U Of MU_Of_MString108
121RETCOST SearchReturn CostDLR17_$S2Currency1017
122Originating_Return_Cost SearchOriginating Return CostDLR17_RBS0_STR$Currency1017
123SVC_Extended_Return_Cost SearchSVC Extended Return CostDLR17_$S2Currency1017
124SVC_Orig_Ext_Return_Cost SearchSVC Originating Extended Return CostDLR17_$S2Currency1017
125SVC_Return_Price_Level SearchSVC Return Price LevelSTR10_LBAUString1210
126SVC_Return_Price SearchSVC Return PriceDLR17_RBS0_STR$Currency1017
127Originating_Return_Price SearchOriginating Return PriceDLR17_RBS0_STR$Currency1017
128SVC_Extended_Return_Pric SearchSVC Extended Return PriceDLR17_$S2Currency1017
129SVC_Orig_Ext_Return_Pric SearchSVC Originating Extended Return PriceDLR17_$S2Currency1017
130SVC_FO_ID SearchSVC FO IDSTR50String5250
131SVC_SCM_Complete SearchSVC SCM CompleteINTInteger20
132svcRMAKitComponentFrom SearchsvcRMAKitComponentFromRMAKitFromDDLInteger20
133svcRMAComponentSeq SearchsvcRMAComponentSeqLI_Sequence_NumberLong Integer410
134CMPITQTY SearchComponent Item QTYDLR17_QTY_RBS0_UTRCurrency1017
135QTYONHND SearchQTY On HandDLR17_QTY_RBS0_STRCurrency1017
136QTYRTRND SearchQTY ReturnedDLR17_QTY_RBS0_UTRCurrency1017
137QTYINUSE SearchQTY In UseDLR17_QTY_RBS0_UTRCurrency1017
138QTYINSVC SearchQTY In ServiceDLR17_QTY_RBS0_UTRCurrency1017
139QTYDMGED SearchQTY DamagedDLR17_QTY_RBS0_UTRCurrency1017
140DEX_ROW_ID Searchintint1010

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.

Leave a Reply

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