RowIDs

Top  Previous  Next

RowIDs are system generated unique keys for each record in the database.  They are the primary key for a record and cannot be modified.  This value is auto generated and unique within a database, across companies.  The "RowID" should always be used as the absolute key reference to a specific Entity or Document and should be the value used when integrating with 3rd party systems.  Most entities and documents also have an "Entity ID" or "Document ID" that is assigned by the user through the presentation layer and can be changed by the user.  RowIDs are static and should never be accessible by, or be presented to, the user. 

 

The actual RowID value is a String value with a company suffix that indicates which ObjAcctMain database holds the company's data.  The RowID suffix is set for each production database by the system administrator during installation and setup.  A typical RowID might look like: "3923.1".  The suffix value appended to the RowID generated by the system should be unique for each production database within an organization.  This allows databases to be merged in the future without encountering duplicate RowID key values.