<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><p><strong>In this guide we will cover:</strong></p><p><strong>- Fields associated with the IDs returned by UCFieldID, DCFieldID and ELTableID</strong></p><p><br></p><p>The below list of Tables, Columns and References can be used when writing reports for tables such as Devicechange or Userchange so that you can properly label the field that was changed.</p><p><br></p><p><strong>Table = UserChange </strong></p><p style="margin-left: 20px;"><strong>Column = UCFieldID</strong></p><p style="margin-left: 40px;">Add = -1,</p><p style="margin-left: 40px;">SiteChange = 1,</p><p style="margin-left: 40px;">Inactive = 2,</p><p style="margin-left: 40px;">[ProRata]</p><p style="margin-left: 40px;">Delete = 3,</p><p style="margin-left: 40px;">ServiceAccount = 4,</p><p style="margin-left: 40px;">IgnoreAutomatedBilling = 5,</p><p style="margin-left: 40px;">PopUpNotes = 6,</p><p style="margin-left: 40px;">Username = 7,</p><p style="margin-left: 40px;">Email = 8,</p><p style="margin-left: 40px;">Firstname = 9,</p><p style="margin-left: 40px;">Lastname = 10,</p><p style="margin-left: 40px;">PhoneNumber = 11,</p><p style="margin-left: 40px;">HomeNumber = 12,</p><p style="margin-left: 40px;">MobileNumber = 13,</p><p style="margin-left: 40px;">MobileNumber2 = 14,</p><p style="margin-left: 40px;">Web_Access_Level = 15,</p><p style="margin-left: 40px;">Asset_Access_Level = 16,</p><p style="margin-left: 40px;">Role_Added = 17,</p><p style="margin-left: 40px;">Role_Removed = 18,</p><p style="margin-left: 40px;">ClientChange = 19,</p><p style="margin-left: 40px;"><br></p><p style="margin-left: 40px;"><br></p><p><strong>Table = DeviceChange </strong></p><p style="margin-left: 20px;"><strong>Column - DCFieldID</strong></p><p id="isPasted" style="margin-left: 40px;">User:-1</p><p style="margin-left: 40px;">Moved:-2</p><p style="margin-left: 40px;">Status:-3</p><p style="margin-left: 40px;">Assembled:-4</p><p style="margin-left: 40px;">Used in Assembly:-5</p><p style="margin-left: 40px;">Linked to Ticket:-6</p><p style="margin-left: 40px;">Passed Commission:-7</p><p style="margin-left: 40px;">Failed Commission:-8</p><p style="margin-left: 40px;">Reset Commission:-9</p><p style="margin-left: 40px;">Asset Tag:-11</p><p style="margin-left: 40px;">Note:-12</p><p style="margin-left: 40px;">Commission Date:-13</p><p style="margin-left: 40px;">Unchanged Commission:-14</p><p style="margin-left: 40px;">Attachment Added:-15</p><p style="margin-left: 40px;">Attachment Removed:-16</p><p style="margin-left: 40px;">Image Added:-17</p><p style="margin-left: 40px;">Image Removed:-18</p><p style="margin-left: 40px;">Status Changed:-19</p><p style="margin-left: 40px;">Child asset linked:-20</p><p style="margin-left: 40px;">Child asset unlinked:-21</p><p style="margin-left: 40px;">Parent asset linked:-22</p><p style="margin-left: 40px;">Parent asset unlinked:-23</p><p style="margin-left: 40px;">Sibling asset linked:-24</p><p style="margin-left: 40px;">Sibling asset unlinked:-25</p><p style="margin-left: 40px;">Created:-50</p><p style="margin-left: 40px;">Type Changed:-51</p><p style="margin-left: 40px;">Software Added:-52</p><p style="margin-left: 40px;">Software Deleted:-53</p><p style="margin-left: 40px;">Software version updated:-54</p><p style="margin-left: 40px;">Software install date updated:-55</p><p style="margin-left: 40px;">Software licence changed:-56</p><p style="margin-left: 40px;">Software licence count changed:-57</p><p style="margin-left: 40px;">Software licence role changed:-58</p><p style="margin-left: 40px;">Linked Asset relationship changed:-59</p><p style="margin-left: 40px;">Inactive:-60</p><p style="margin-left: 40px;">Teamviewer connection:-61</p><p style="margin-left: 40px;">Business Owner:-62</p><p style="margin-left: 40px;">Change Advice Board:-63</p><p style="margin-left: 40px;">Technical Owner:-64</p><p style="margin-left: 40px;">Priority:-65</p><p style="margin-left: 40px;">Supplier:-66</p><p style="margin-left: 40px;">Contract:-67</p><p style="margin-left: 40px;">Supplier Priority:-68</p><p style="margin-left: 40px;">Supplier Reference:-69</p><p style="margin-left: 40px;">::-70</p><p style="margin-left: 40px;">Service Linked:-71</p><p style="margin-left: 40px;">Service Unlinked:-72</p><p style="margin-left: 40px;">Name:-73</p><p style="margin-left: 40px;">Status:-74</p><p style="margin-left: 40px;">Sales Description:-75</p><p style="margin-left: 40px;">Purchase Description:-76</p><p style="margin-left: 40px;">Price:-77</p><p style="margin-left: 40px;">Cost:-78</p><p style="margin-left: 40px;">Tax Code:-79</p><p style="margin-left: 40px;">Accounts Code:-80</p><p style="margin-left: 40px;">Item Group:-81</p><p style="margin-left: 40px;">Parts Warranty Start Date:-82</p><p style="margin-left: 40px;">Parts Warranty End Date:-83</p><p style="margin-left: 40px;">Labour Warranty Start Date:-84</p><p style="margin-left: 40px;">Labour Warranty End Date:-85</p><p style="margin-left: 40px;">Licence Linked:-86</p><p style="margin-left: 40px;">Licence Unlinked:-87</p><p style="margin-left: 40px;">Contract Linked:-88</p><p style="margin-left: 40px;">Contract Unlinked:-89</p><p style="margin-left: 40px;">Taxable:-90</p><p style="margin-left: 40px;">Recurring Price:-91</p><p style="margin-left: 40px;">Recurring Cost:-92</p><p style="margin-left: 40px;">Not Consignable:-93</p><p style="margin-left: 40px;">Item Project Template:-94</p><p style="margin-left: 40px;">Do not receive on Purchase Order:-95</p><p style="margin-left: 40px;">Budget Type:-96</p><p style="margin-left: 40px;">Manufacturer SKU:-97</p><p style="margin-left: 40px;">Is a Contract:-98</p><p style="margin-left: 40px;">Don't Invoice on Sales Orders:-99</p><p style="margin-left: 40px;">Custom Table Row Added:-100</p><p style="margin-left: 40px;">Custom Table Row Deleted:-101</p><p style="margin-left: 40px;">Cusotm Table Row Edited:-102</p><p><br></p><p><strong>Table = ExternalLink</strong></p><p style="margin-left: 20px;"><strong>Column = ELTableID</strong></p><p style="margin-left: 20px;"> NavigationMenu = -1,</p><p style="margin-left: 20px;"> System = 0,</p><p style="margin-left: 20px;"> Faults = 1,</p><p style="margin-left: 20px;"> Area = 2,</p><p style="margin-left: 20px;"> Site = 3,</p><p style="margin-left: 20px;"> User = 4,</p><p style="margin-left: 20px;"> Asset = 5,</p><p style="margin-left: 20px;"> Contract = 6,</p><p style="margin-left: 20px;"> Action = 7,</p><p style="margin-left: 20px;"> Item = 8,</p><p style="margin-left: 20px;"> Supplier = 9,</p><p style="margin-left: 20px;"> LiveChatHeader = 980,</p><p style="margin-left: 20px;"> PurchaseOrderLines = 987,</p><p style="margin-left: 20px;"> QuotationLines = 988,</p><p style="margin-left: 20px;"> Invoice = 989,</p><p style="margin-left: 20px;"> SalesOrder = 990,</p><p style="margin-left: 20px;"> FAQList = 991,</p><p style="margin-left: 20px;"> KB = 992,</p><p style="margin-left: 20px;"> CRMNotes = 993,</p><p style="margin-left: 20px;"> Attachment = 995,</p><p style="margin-left: 20px;"> Quotation = 996,</p><p style="margin-left: 20px;"> AssetGroup = 997,</p><p style="margin-left: 20px;"> PurchaseOrder = 998,</p><p style="margin-left: 20px;"> Service = 999,</p><p style="margin-left: 20px;"> SupplierContract = 1001,</p><p style="margin-left: 20px;"> Agent = 1002,</p><p style="margin-left: 20px;"> Organization = 1003,</p><p style="margin-left: 20px;"> DistributionLists = 1005,</p><p style="margin-left: 20px;"> DistributionListsLog = 1006,</p><p style="margin-left: 20px;"> ECommerceOrder = 1007,</p><p style="margin-left: 20px;"> MailCampaignLog = 1008,</p><p style="margin-left: 20px;"> MailCampaign = 1009,</p><p style="margin-left: 20px;"> OutboundIntegrationMethod = 1010,</p><p style="margin-left: 20px;"> MailCampaignEmail = 1011,</p><p style="margin-left: 20px;"> Document = 1012,</p><p style="margin-left: 20px;"> DeviceChange = 1013,</p><p style="margin-left: 20px;"> EventManagement = 1014,</p><p style="margin-left: 20px;"> ServiceAvailability = 1015,</p><p style="margin-left: 20px;"> Downtime = 1016,</p><p style="margin-left: 20px;"> Appointment = 1017,</p><p style="margin-left: 20px;"> Lookup = 1018,</p><p style="margin-left: 20px;"> IntegrationRequest = 1019,</p><p style="margin-left: 20px;"> DeviceChangeBackup = 1020,</p><p style="margin-left: 20px;"> ToDoGroups = 1021,</p><p style="margin-left: 20px;"> ForecastDetails = 1022,</p><p style="margin-left: 20px;"> SavedForecast = 1023</p>
