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 TypeLength
1RETDOCID SearchReturn Document IDSTR15_LBAUString15
2Return_Record_Type SearchReturn Record TypeDDL_Return_Record_TypeInteger0
3LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency19
4SVC_Next_Line_SEQ_Number SearchSVC Next Line SEQ NumberSequence_NumberCurrency19
5SVC_Prev_Line_SEQ_Number SearchSVC Prev Line SEQ NumberSequence_NumberCurrency19
6RETTYPE SearchSVC Return TypeSTR10_LBAUString10
7RMA_Status SearchRMA StatusINTInteger0
8RETSTAT SearchReturn StatusSTR3_LBAUString3
9Received SearchReceivedCB_ReceivedBoolean0
10Traveler_Printed SearchTraveler PrintedCB_Traveler_PrintedBoolean0
11SVC_Ready_To_Close SearchSVC Ready To CloseCB_Ready_To_CloseBoolean0
12SVC_RMA_Reason_Code SearchSVC_RMA_Reason_CodeSTR3_LBAUString3
13SVC_RMA_Reason_Code_Desc SearchSVC_RMA_Reason_Code_DescSTR30String30
14NOTEINDX SearchNote IndexDLR14Currency14
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_ReturnInteger0
16RETREF SearchReturn ReferenceSTR30_LBAUString30
17SRVRECTYPE SearchService Record TypeDDL_Service_Record_TypeInteger0
18CALLNBR SearchService Call NumberSTR10_LBAUString10
19EQPLINE SearchEquipment Line Item SequenceLI_Sequence_NumberLong Integer10
20LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
21SVC_RMA_From_Service SearchSVC RMA From ServiceBooleanBoolean0
22SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger0
23SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString17
24CMPNTSEQ SearchComponent SequenceLI_Sequence_NumberLong Integer10
25SOP_Line_Item_Sequence SearchSOP Line Item SequenceLI_Sequence_NumberLong Integer10
26ENTDTE SearchEntry DateDT_DateDate6
27ENTTME SearchEntry TimeTM6Time6
28ETADTE SearchETA DateDT_DateDate6
29ETATME SearchETA TimeTM6Time6
30Commit_Date SearchCommit DateDT_DateDate6
31Commit_Time SearchCommit TimeTM6Time6
32RETUDATE SearchReturn DateDTDate8
33Return_Time SearchReturn TimeTM6Time6
34COMPDTE SearchComplete DateDT_DateDate6
35COMPTME SearchComplete TimeTM6Time6
36PRMDATE SearchPromised DateDATE_LDate0
37REFRENCE SearchReferenceSTR30String30
38USERID SearchUser IDSTR15_User_IDString15
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_LBAUString10
40LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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_LBUString44
42RETADDR1 SearchReturn Address 1STR60String60
43RETADDR2 SearchReturn Address 2STR60String60
44RETADDR3 SearchReturn Address 3STR60String60
45RTRNCITY SearchReturn Address CitySTR20_LBUString20
46SVC_Return_State SearchSVC Return StateSTR30_StateString29
47RTRNZIP SearchReturn Address Zip CodeSTR10String10
48Return_Country SearchReturn CountrySTR60String60
49CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_NameString64
51ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
52CONTACT SearchContactSTR60String60
53ADDRESS1 SearchAddress 1STR60String60
54ADDRESS2 SearchAddress 2STR60String60
55ADDRESS3 SearchAddress 3STR60String60
56CITY SearchCitySTR35String35
57STATE SearchStateSTR30_StateString29
58ZIPCODE SearchZip CodeSTR10String10
59COUNTRY SearchCountrySTR60String60
60Bill_To_Customer SearchBill To CustomerSTR15_RM_Customer_NumberString15
61SVC_Bill_To_Address_Code SearchSVC Bill To Address CodeSTR15_Address_CodeString15
62CSTPONBR SearchCustomer PO NumberSTR20_Document_NumberString20
63QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency17
64DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
65UOFM SearchU Of MU_Of_MString8
66ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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 DescriptionSTR100String100
68UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency17
69ORUNTCST SearchOriginating Unit CostDLR17_RBS0_UTR$Currency17
70EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency17
71OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency17
72UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency17
73ORUNTPRC SearchOriginating Unit PriceDLR17_RBS0_STR$Currency17
74XTNDPRCE SearchExtended PriceDLR17_RBS0_STR$Currency17
75OXTNDPRC SearchOriginating Extended PriceDLR17_RBS0_STR$Currency17
76CUSTOWN SearchCustomer OwnedCBBoolean0
77FACTSEAL SearchFactory SealedCBBoolean0
78ORDDOCID SearchOrder Document IDSTR15_LBAUString15
79TRANSLINESEQ SearchTransfer Line Item SequenceLI_Sequence_NumberLong Integer10
80STATUS SearchTransfer StatusINTInteger0
81Flat_Rate_Repair_Price SearchFlat Rate Repair PriceDLR17_RBSO_STR$Currency17
82Orig_Flat_RepairPrice SearchOriginating Flat Rate Repair PriceDLR17_RBS0_STR$Currency17
83Repair_Price SearchRepair PriceDLR17_RBSO_STR$Currency17
84Originating_Repair_Price SearchOriginating Repair PriceDLR17_RBS0_STR$Currency17
85NTE_Price SearchNTE PriceDLR17_RBS0_UTR$Currency17
86Originating_NTE_Price SearchOriginating NTE PriceDLR17_RBS0_UTR$Currency17
87Repair_Cost SearchRepair CostDLR17_RBS0_UTR$Currency17
88Originating_Repair_Cost SearchOriginating Repair CostDLR17_RBS0_UTR$Currency17
89Bill_of_Lading SearchBill of LadingSTR30String30
90SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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_TypeInteger0
92Credit_SOP_Number SearchCredit SOP NumberSTR20_SOP_NumberString17
93Credit_SOP_Line_Item_Seq SearchCredit SOP Line Item SequenceLI_Sequence_NumberLong Integer10
94Replace_SOP_Type SearchReplace SOP TypeDDL_SOP_TypeInteger0
95Replace_SOP_Number SearchReplace SOP NumberSTR20_SOP_NumberString17
96Replace_SOP_Line_Item_Se SearchReplace SOP Line Item SequenceLI_Sequence_NumberLong Integer10
97Location_Code_Replacemen SearchLocation Code ReplacementSTR10_Location_CodeString10
98Replace_Item_Number SearchReplace Item NumberSTR30_Item_NumberString30
99Replace_U_Of_M SearchReplace U Of MU_Of_MString8
100Replace_Price_Level SearchReplace Price LevelSTR10_LBAUString10
101Replace_QTY SearchReplace QTYDLR17_QTY_RBS0_UTRCurrency17
102Replace_Cost SearchReplace CostDLR17_RBS0_STR$Currency17
103Originating_Replace_Cost SearchOriginating Replace CostDLR17_RBS0_STR$Currency17
104Replace_Price SearchReplace PriceDLR17_RBS0_STR$Currency17
105Originating_Replace_Pric SearchOriginating Replace PriceDLR17_RBS0_STR$Currency17
106SOP_Number_Invoice SearchSOP Number InvoiceSTR20_SOP_NumberString17
107Item_Number_Invoice SearchItem Number InvoiceSTR30_Item_NumberString30
108USERDEF1 SearchUser Defined 1STR20String20
109USERDEF2 SearchUser Defined 2STR20String20
110USRDEF03 SearchUser Defined 3STR20String20
111USRDEF04 SearchUser Defined 4STR20String20
112USRDEF05 SearchUser Defined 5STR20String20
113CURRNIDX SearchCurrency IndexINT3Integer3
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_DollarsInteger0
115ODECPLCU SearchOriginating Decimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
116Return_Item_Number SearchReturn Item NumberSTR30_Item_NumberString30
117Return_Item_Description SearchReturn Item DescriptionSTR100String100
118Return_Location_Code SearchReturn Location CodeSTR10_Location_CodeString10
119Return_QTY SearchReturn QTYDLR17_QTY_RBS0_UTRCurrency17
120Return_U_Of_M SearchReturn U Of MU_Of_MString8
121RETCOST SearchReturn CostDLR17_$S2Currency17
122Originating_Return_Cost SearchOriginating Return CostDLR17_RBS0_STR$Currency17
123SVC_Extended_Return_Cost SearchSVC Extended Return CostDLR17_$S2Currency17
124SVC_Orig_Ext_Return_Cost SearchSVC Originating Extended Return CostDLR17_$S2Currency17
125SVC_Return_Price_Level SearchSVC Return Price LevelSTR10_LBAUString10
126SVC_Return_Price SearchSVC Return PriceDLR17_RBS0_STR$Currency17
127Originating_Return_Price SearchOriginating Return PriceDLR17_RBS0_STR$Currency17
128SVC_Extended_Return_Pric SearchSVC Extended Return PriceDLR17_$S2Currency17
129SVC_Orig_Ext_Return_Pric SearchSVC Originating Extended Return PriceDLR17_$S2Currency17
130SVC_FO_ID SearchSVC FO IDSTR50String50
131SVC_SCM_Complete SearchSVC SCM CompleteINTInteger0
132svcRMAKitComponentFrom SearchsvcRMAKitComponentFromRMAKitFromDDLInteger0
133svcRMAComponentSeq SearchsvcRMAComponentSeqLI_Sequence_NumberLong Integer10
134CMPITQTY SearchComponent Item QTYDLR17_QTY_RBS0_UTRCurrency17
135QTYONHND SearchQTY On HandDLR17_QTY_RBS0_STRCurrency17
136QTYRTRND SearchQTY ReturnedDLR17_QTY_RBS0_UTRCurrency17
137QTYINUSE SearchQTY In UseDLR17_QTY_RBS0_UTRCurrency17
138QTYINSVC SearchQTY In ServiceDLR17_QTY_RBS0_UTRCurrency17
139QTYDMGED SearchQTY DamagedDLR17_QTY_RBS0_UTRCurrency17
140DEX_ROW_ID Searchintint10

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 *