Field Service - Return to Vendors (RTVs) - Deep Dive

The 'Return to Vendors  (RTVs)' entity is msdyn_rtv



The fields are: -




RTV Id (Unique Identifier) msdyn_rtvid
RTV Number Number (string) msdyn_name
Vendor Contact (lookup)  msdyn_vendorcontact
Vendor (lookup)  msdyn_vendor
System Status (picklist)  msdyn_systemstatus
Sub-Status (lookup)  msdyn_substatus
Total Amount (money) msdyn_totalamount

Address 1 (string) msdyn_address1 *
Address 2 (string) msdyn_address2 *
Address 3 (string) msdyn_address3 *
City (string) msdyn_city *
State Or Province (string) msdyn_stateorprovince *
Country/Region (string) msdyn_country *
Postal Code (string) msdyn_postalcode *

Latitude (double) msdyn_latitude *
Longitude (double) msdyn_longitude *

Approved/Declined By (lookup)  msdyn_approveddeclinedby *
Booking (lookup)  msdyn_booking *
Ship Via (lookup)  msdyn_shipvia *
Original Purchase Order (lookup)  msdyn_originalpurchaseorder *
Originating (lookup)  msdyn_originatingrma *
Reference No (string) msdyn_referenceno *
Request Date (DateTime) msdyn_requestdate *
Return Date (DateTime) msdyn_returndate *
Returned By (lookup)  msdyn_returnedby *
Tax Code (lookup)  msdyn_taxcode *
Work Order (lookup)  msdyn_workorder *

------------------------------------------------------------------------------------
Late-binding example (using OData)
----------------------------------------------------------------------------------- 

var msdyn_address1 = result["msdyn_address1"];
var msdyn_address2 = result["msdyn_address2"];
var msdyn_address3 = result["msdyn_address3"];
           
var _msdyn_approveddeclinedby_value = result["_msdyn_approveddeclinedby_value"];
var _msdyn_approveddeclinedby_value_formatted = result["_msdyn_approveddeclinedby_value@OData.Community.Display.V1.FormattedValue"];
var _msdyn_approveddeclinedby_value_lookuplogicalname = result["_msdyn_approveddeclinedby_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
            
var _msdyn_booking_value = result["_msdyn_booking_value"];
var _msdyn_booking_value_formatted = result["_msdyn_booking_value@OData.Community.Display.V1.FormattedValue"];
var _msdyn_booking_value_lookuplogicalname = result["_msdyn_booking_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
            
var msdyn_city = result["msdyn_city"];
var msdyn_country = result["msdyn_country"];

var msdyn_latitude = result["msdyn_latitude"];
var msdyn_latitude_formatted = result["msdyn_latitude@OData.Community.Display.V1.FormattedValue"];
var msdyn_longitude = result["msdyn_longitude"];
var msdyn_longitude_formatted = result["msdyn_longitude@OData.Community.Display.V1.FormattedValue"];
            
var msdyn_name = result["msdyn_name"];
            
var _msdyn_originalpurchaseorder_value = result["_msdyn_originalpurchaseorder_value"];
var _msdyn_originalpurchaseorder_value_formatted = result["_msdyn_originalpurchaseorder_value@OData.Community.Display.V1.FormattedValue"];
var _msdyn_originalpurchaseorder_value_lookuplogicalname = result["_msdyn_originalpurchaseorder_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
            
var _msdyn_originatingrma_value = result["_msdyn_originatingrma_value"];
var _msdyn_originatingrma_value_formatted = result["_msdyn_originatingrma_value@OData.Community.Display.V1.FormattedValue"];
var _msdyn_originatingrma_value_lookuplogicalname = result["_msdyn_originatingrma_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
            
var msdyn_postalcode = result["msdyn_postalcode"];
var msdyn_referenceno = result["msdyn_referenceno"];
var msdyn_requestdate = result["msdyn_requestdate"];
var msdyn_returndate = result["msdyn_returndate"];
            
var _msdyn_returnedby_value = result["_msdyn_returnedby_value"];
var _msdyn_returnedby_value_formatted = result["_msdyn_returnedby_value@OData.Community.Display.V1.FormattedValue"];
var _msdyn_returnedby_value_lookuplogicalname = result["_msdyn_returnedby_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
            
var msdyn_rtvid = result["msdyn_rtvid"];
           
var _msdyn_shipvia_value = result["_msdyn_shipvia_value"];
var _msdyn_shipvia_value_formatted = result["_msdyn_shipvia_value@OData.Community.Display.V1.FormattedValue"];
var _msdyn_shipvia_value_lookuplogicalname = result["_msdyn_shipvia_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
            
var msdyn_stateorprovince = result["msdyn_stateorprovince"];
            
var _msdyn_substatus_value = result["_msdyn_substatus_value"];
var _msdyn_substatus_value_formatted = result["_msdyn_substatus_value@OData.Community.Display.V1.FormattedValue"];
var _msdyn_substatus_value_lookuplogicalname = result["_msdyn_substatus_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
var msdyn_systemstatus = result["msdyn_systemstatus"];
var msdyn_systemstatus_formatted = result["msdyn_systemstatus@OData.Community.Display.V1.FormattedValue"];
            
var _msdyn_taxcode_value = result["_msdyn_taxcode_value"];
var _msdyn_taxcode_value_formatted = result["_msdyn_taxcode_value@OData.Community.Display.V1.FormattedValue"];
var _msdyn_taxcode_value_lookuplogicalname = result["_msdyn_taxcode_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
            
var msdyn_totalamount = result["msdyn_totalamount"];
var msdyn_totalamount_formatted = result["msdyn_totalamount@OData.Community.Display.V1.FormattedValue"];
var msdyn_totalamount_base = result["msdyn_totalamount_base"];
var msdyn_totalamount_base_formatted = result["msdyn_totalamount_base@OData.Community.Display.V1.FormattedValue"];
            
var _msdyn_vendor_value = result["_msdyn_vendor_value"];
var _msdyn_vendor_value_formatted = result["_msdyn_vendor_value@OData.Community.Display.V1.FormattedValue"];
var _msdyn_vendor_value_lookuplogicalname = result["_msdyn_vendor_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
            
var _msdyn_vendorcontact_value = result["_msdyn_vendorcontact_value"];
var _msdyn_vendorcontact_value_formatted = result["_msdyn_vendorcontact_value@OData.Community.Display.V1.FormattedValue"];
var _msdyn_vendorcontact_value_lookuplogicalname = result["_msdyn_vendorcontact_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
            
var msdyn_vendorrma = result["msdyn_vendorrma"];
            
var _msdyn_workorder_value = result["_msdyn_workorder_value"];
var _msdyn_workorder_value_formatted = result["_msdyn_workorder_value@OData.Community.Display.V1.FormattedValue"];

var _msdyn_workorder_value_lookuplogicalname = result["_msdyn_workorder_value@Microsoft.Dynamics.CRM.lookuplogicalname"];

-----------------------------------------------------------------------------------
Early-binding example
-----------------------------------------------------------------------------------

var msdyn_Address1 = result.msdyn_Address1;
var msdyn_Address2 = result.msdyn_Address2;
var msdyn_Address3 = result.msdyn_Address3;
var msdyn_ApprovedDeclinedBy = result.msdyn_ApprovedDeclinedBy;
var msdyn_Booking = result.msdyn_Booking;
var msdyn_City = result.msdyn_City;
var msdyn_Country = result.msdyn_Country;
var msdyn_Latitude = result.msdyn_Latitude;
var msdyn_Longitude = result.msdyn_Longitude;
var msdyn_name = result.msdyn_name;
var msdyn_OriginalPurchaseOrder = result.msdyn_OriginalPurchaseOrder;
var msdyn_OriginatingRMA = result.msdyn_OriginatingRMA;
var msdyn_PostalCode = result.msdyn_PostalCode;
var msdyn_ReferenceNo = result.msdyn_ReferenceNo;
var msdyn_RequestDate = result.msdyn_RequestDate;
var msdyn_ReturnDate = result.msdyn_ReturnDate;
var msdyn_ReturnedBy = result.msdyn_ReturnedBy;
var msdyn_rtvId = result.msdyn_rtvId;
var msdyn_ShipVia = result.msdyn_ShipVia;
var msdyn_StateOrProvince = result.msdyn_StateOrProvince;
var msdyn_SubStatus = result.msdyn_SubStatus;
var msdyn_SystemStatus = result.msdyn_SystemStatus;
var msdyn_TaxCode = result.msdyn_TaxCode;
var msdyn_TotalAmount = result.msdyn_TotalAmount;
var msdyn_totalamount_Base = result.msdyn_totalamount_Base;
var msdyn_Vendor = result.msdyn_Vendor;
var msdyn_VendorContact = result.msdyn_VendorContact;
var msdyn_VendorRMA = result.msdyn_VendorRMA;

var msdyn_WorkOrder = result.msdyn_WorkOrder;