Update Record Configuration

Totally frustrated with clarification in Help Document.  I give up. The "Update Record Configuration" screen shows "Record ID" and gives no examples of any kind of what are you referring to as Record ID. I have a sequence number field i think is record id. 

Here is my dilema. I imported 12,000 rows of records from SharePoint into Data Entity using the DB Insert Record instead of DE Insert Records which is too long to discuss reasons why. So i successfully imported all 12,000 rows over 3 days into Data Entity except the large comment/notes fields that would error out because of special characters embedded into the notes field.

Now when i attempt to use the DB Update Stencil I get same error as DB Insert Stencil but I know the AgilePoint Update Record Stencil should work because in the past when i've used the AgilePoint Insert record on these special characters I never have any problems.

Here is the problem. My Source is the SharePoint CAML Query to retrieve every record from SP and only update the notes fields for every records in SP and copy via subform that information into AgilePoint via the DE Update Record Stencil.  I've tried everything but there is NOOOOO clarification in documentation what is RECORD ID: There is no GUID in SP to match my DE records. So i created a Query with AgilePoint DE to retrieve the matching record number in SP with records in DE table. Did my mapping and everything then i started thinking... How and where do i store the GUID record number from DE record into a Response Variable since there is no GUID datatype, so that isn't going to work.

So my question is 2 fold. Is RecordID the GUID or something else.. A simple screen shot example in your documentation would go a LONG way in showing us how to use the RECORD ID. If it is using the GUID how do i store the GUID in a variable since i don't see a GUID datatype.

Why can't your DE update record Stencil be like your SQL Update record stencil where i define the field I'm querying on to update the record.