Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC35200
Product: FieldService (949)
Series:
Display Name: SVC_RMA_Line_HIST
Physical Name: SVC35200
Technical Name: SVC_RMA_Line_HISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 RETDOCID 
Return Document ID String STR15_LBAU 15 2 Return_Record_Type Return Record Type Integer DDL_Return_Record_Type 0 3 LNSEQNBR Line SEQ Number Currency Sequence_Number 19 4 SVC_Next_Line_SEQ_Number SVC Next Line SEQ Number Currency Sequence_Number 19 5 SVC_Prev_Line_SEQ_Number SVC Prev Line SEQ Number Currency Sequence_Number 19 6 RETTYPE SVC Return Type String STR10_LBAU 10 7 RMA_Status RMA Status Integer INT 0 8 RETSTAT Return Status String STR3_LBAU 3 9 Received Received Boolean CB_Received 0 10 Traveler_Printed Traveler Printed Boolean CB_Traveler_Printed 0 11 SVC_Ready_To_Close SVC Ready To Close Boolean CB_Ready_To_Close 0 12 SVC_RMA_Reason_Code SVC_RMA_Reason_Code String STR3_LBAU 3 13 SVC_RMA_Reason_Code_Desc SVC_RMA_Reason_Code_Desc String STR30 30 14 NOTEINDX Note Index Currency DLR14 14 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'].NOTEINDX15 RETORIG Return Origin Integer DDL_Return 0 16 RETREF Return Reference String STR30_LBAU 30 17 SRVRECTYPE Service Record Type Integer DDL_Service_Record_Type 0 18 CALLNBR Service Call Number String STR10_LBAU 10 19 EQPLINE Equipment Line Item Sequence Long Integer LI_Sequence_Number 10 20 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 21 SVC_RMA_From_Service SVC RMA From Service Boolean Boolean 0 22 SOPTYPE SOP Type Integer DDL_SOP_Type 0 23 SOPNUMBE SOP Number String STR20_SOP_Number 17 24 CMPNTSEQ Component Sequence Long Integer LI_Sequence_Number 10 25 SOP_Line_Item_Sequence SOP Line Item Sequence Long Integer LI_Sequence_Number 10 26 ENTDTE Entry Date Date DT_Date 6 27 ENTTME Entry Time Time TM6 6 28 ETADTE ETA Date Date DT_Date 6 29 ETATME ETA Time Time TM6 6 30 Commit_Date Commit Date Date DT_Date 6 31 Commit_Time Commit Time Time TM6 6 32 RETUDATE Return Date Date DT 8 33 Return_Time Return Time Time TM6 6 34 COMPDTE Complete Date Date DT_Date 6 35 COMPTME Complete Time Time TM6 6 36 PRMDATE Promised Date Date DATE_L 0 37 REFRENCE Reference String STR30 30 38 USERID User ID String STR15_User_ID 15 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'].USERID39 OFFID Office ID String STR10_LBAU 10 40 LOCNCODE Location Code String STR10_Location_Code 10 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'].LOCNCODE41 RTRNNAME Return Address Name String STR44_LBU 44 42 RETADDR1 Return Address 1 String STR60 60 43 RETADDR2 Return Address 2 String STR60 60 44 RETADDR3 Return Address 3 String STR60 60 45 RTRNCITY Return Address City String STR20_LBU 20 46 SVC_Return_State SVC Return State String STR30_State 29 47 RTRNZIP Return Address Zip Code String STR10 10 48 Return_Country Return Country String STR60 60 49 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 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'].CUSTNMBR50 CUSTNAME Customer Name String STR64_Customer_Name 64 51 ADRSCODE Address Code String STR15_Address_Code 15 52 CONTACT Contact String STR60 60 53 ADDRESS1 Address 1 String STR60 60 54 ADDRESS2 Address 2 String STR60 60 55 ADDRESS3 Address 3 String STR60 60 56 CITY City String STR35 35 57 STATE State String STR30_State 29 58 ZIPCODE Zip Code String STR10 10 59 COUNTRY Country String STR60 60 60 Bill_To_Customer Bill To Customer String STR15_RM_Customer_Number 15 61 SVC_Bill_To_Address_Code SVC Bill To Address Code String STR15_Address_Code 15 62 CSTPONBR Customer PO Number String STR20_Document_Number 20 63 QUANTITY QTY Currency DLR17_QTY_RBS0_STR 17 64 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 65 UOFM U Of M String U_Of_M 8 66 ITEMNMBR Item Number String STR30_Item_Number 30 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'].ITEMNMBR67 ITEMDESC Item Description String STR100 100 68 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 69 ORUNTCST Originating Unit Cost Currency DLR17_RBS0_UTR$ 17 70 EXTDCOST Extended Cost Currency DLR17_RBS0_UTR$ 17 71 OREXTCST Originating Extended Cost Currency DLR17_RBS0_UTR$ 17 72 UNITPRCE Unit Price Currency DLR17_RBS0_STR$ 17 73 ORUNTPRC Originating Unit Price Currency DLR17_RBS0_STR$ 17 74 XTNDPRCE Extended Price Currency DLR17_RBS0_STR$ 17 75 OXTNDPRC Originating Extended Price Currency DLR17_RBS0_STR$ 17 76 CUSTOWN Customer Owned Boolean CB 0 77 FACTSEAL Factory Sealed Boolean CB 0 78 ORDDOCID Order Document ID String STR15_LBAU 15 79 TRANSLINESEQ Transfer Line Item Sequence Long Integer LI_Sequence_Number 10 80 STATUS Transfer Status Integer INT 0 81 Flat_Rate_Repair_Price Flat Rate Repair Price Currency DLR17_RBSO_STR$ 17 82 Orig_Flat_RepairPrice Originating Flat Rate Repair Price Currency DLR17_RBS0_STR$ 17 83 Repair_Price Repair Price Currency DLR17_RBSO_STR$ 17 84 Originating_Repair_Price Originating Repair Price Currency DLR17_RBS0_STR$ 17 85 NTE_Price NTE Price Currency DLR17_RBS0_UTR$ 17 86 Originating_NTE_Price Originating NTE Price Currency DLR17_RBS0_UTR$ 17 87 Repair_Cost Repair Cost Currency DLR17_RBS0_UTR$ 17 88 Originating_Repair_Cost Originating Repair Cost Currency DLR17_RBS0_UTR$ 17 89 Bill_of_Lading Bill of Lading String STR30 30 90 SHIPMTHD Shipping Method String STR15_Shipping_Method 15 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'].SHIPMTHD91 Credit_SOP_Type Credit SOP Type Integer DDL_SOP_Type 0 92 Credit_SOP_Number Credit SOP Number String STR20_SOP_Number 17 93 Credit_SOP_Line_Item_Seq Credit SOP Line Item Sequence Long Integer LI_Sequence_Number 10 94 Replace_SOP_Type Replace SOP Type Integer DDL_SOP_Type 0 95 Replace_SOP_Number Replace SOP Number String STR20_SOP_Number 17 96 Replace_SOP_Line_Item_Se Replace SOP Line Item Sequence Long Integer LI_Sequence_Number 10 97 Location_Code_Replacemen Location Code Replacement String STR10_Location_Code 10 98 Replace_Item_Number Replace Item Number String STR30_Item_Number 30 99 Replace_U_Of_M Replace U Of M String U_Of_M 8 100 Replace_Price_Level Replace Price Level String STR10_LBAU 10 101 Replace_QTY Replace QTY Currency DLR17_QTY_RBS0_UTR 17 102 Replace_Cost Replace Cost Currency DLR17_RBS0_STR$ 17 103 Originating_Replace_Cost Originating Replace Cost Currency DLR17_RBS0_STR$ 17 104 Replace_Price Replace Price Currency DLR17_RBS0_STR$ 17 105 Originating_Replace_Pric Originating Replace Price Currency DLR17_RBS0_STR$ 17 106 SOP_Number_Invoice SOP Number Invoice String STR20_SOP_Number 17 107 Item_Number_Invoice Item Number Invoice String STR30_Item_Number 30 108 USERDEF1 User Defined 1 String STR20 20 109 USERDEF2 User Defined 2 String STR20 20 110 USRDEF03 User Defined 3 String STR20 20 111 USRDEF04 User Defined 4 String STR20 20 112 USRDEF05 User Defined 5 String STR20 20 113 CURRNIDX Currency Index Integer INT3 3 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'].CURRNIDX114 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 115 ODECPLCU Originating Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 116 Return_Item_Number Return Item Number String STR30_Item_Number 30 117 Return_Item_Description Return Item Description String STR100 100 118 Return_Location_Code Return Location Code String STR10_Location_Code 10 119 Return_QTY Return QTY Currency DLR17_QTY_RBS0_UTR 17 120 Return_U_Of_M Return U Of M String U_Of_M 8 121 RETCOST Return Cost Currency DLR17_$S2 17 122 Originating_Return_Cost Originating Return Cost Currency DLR17_RBS0_STR$ 17 123 SVC_Extended_Return_Cost SVC Extended Return Cost Currency DLR17_$S2 17 124 SVC_Orig_Ext_Return_Cost SVC Originating Extended Return Cost Currency DLR17_$S2 17 125 SVC_Return_Price_Level SVC Return Price Level String STR10_LBAU 10 126 SVC_Return_Price SVC Return Price Currency DLR17_RBS0_STR$ 17 127 Originating_Return_Price Originating Return Price Currency DLR17_RBS0_STR$ 17 128 SVC_Extended_Return_Pric SVC Extended Return Price Currency DLR17_$S2 17 129 SVC_Orig_Ext_Return_Pric SVC Originating Extended Return Price Currency DLR17_$S2 17 130 SVC_FO_ID SVC FO ID String STR50 50 131 SVC_SCM_Complete SVC SCM Complete Integer INT 0 132 svcRMAKitComponentFrom svcRMAKitComponentFrom Integer RMAKitFromDDL 0 133 svcRMAComponentSeq svcRMAComponentSeq Long Integer LI_Sequence_Number 10 134 CMPITQTY Component Item QTY Currency DLR17_QTY_RBS0_UTR 17 135 QTYONHND QTY On Hand Currency DLR17_QTY_RBS0_STR 17 136 QTYRTRND QTY Returned Currency DLR17_QTY_RBS0_UTR 17 137 QTYINUSE QTY In Use Currency DLR17_QTY_RBS0_UTR 17 138 QTYINSVC QTY In Service Currency DLR17_QTY_RBS0_UTR 17 139 QTYDMGED QTY Damaged Currency DLR17_QTY_RBS0_UTR 17