Is there a master list of what the .com/0030V or the .com001D mean? eg. v for contacts? d for accounts? are there others? Where I'm going with my question is connecting our datavault via Power BI and connecting tables. Is there a master key list? Can you create one with SF tools?
In the URL, there will always be a record ID when viewing a record. The first 3 characters denote the object. For standard objects, this is the same across all orgs. 001 is account, 003 is contact, etc. Characters 4 and 5 denote the server on which the record was originally created. Then, there are a placeholder character for future use, characters 7-15 are a unique identifier, and if you see 18 characters, the last 3 are a checksum for case sensitivity.
This is the most comprehensive list I've ever seen (dated 2011, but still maintained): http://www.fishofprey.com/2011/09/obscure-salesforce-object-key-prefixes.html
Custom object prefixes are unique to the org and start at a01 and count up from there. They will only be the same between prod and sandboxes if the sandbox was created after the object.
