The rcd_toid column
This column groups all records in the database that belong to one object. For example, if the model would contain the “sls400” SalesOrder type, then all records that belong to the same SalesOrder object would have the same rcd_toid
value. The first six positions of the rcd_toid
column contain the object type, such as “sls400”. Together with the remaining positions they form a unique identifier.
The value of the rcd_toid
column can be blank
(a string of spaces only), in which case it is at this time is unknown to which object this record belongs. As soon as the record is modified, the rcd_toid
value is determined. The value of the rcd_toid
column can also be the “-NONE-“ value, in which case it is known that the record does not belong to any object.