NUMBER Function (RecordRef)

Gets the table ID (number) of the table that contains the record that was referred to by the RecordRef.


No := RecordRef.NUMBER  


Type: RecordRef

The RecordRef that refers to the table in which you are interested.

Property Value/Return Value

Type: Integer

The number of the table or the number of the field.


In versions of Dynamics NAV earlier than Microsoft Dynamics NAV 2013, if a RecordRef referred to a temporary table, then the table number value of the RecordRef was the run-time generated sequence ID, which is from the base value of 2000100000. You could use the table number to determine whether a RecordRef referred to a temporary table. In Microsoft Dynamics NAV 2018, the table number value of a RecordRef always contains the ID of the originating physical table and not the run-time generated sequence ID. If you previously used the NUMBER Function (RECORDREF) to test for the sequence number and determine whether the RecordRef was temporary, then you must use the ISTEMPORARY Function (RecordRef) in Dynamics NAV instead.


The following example opens the Customer table (18) as a RecordRef object. The OPEN Function (RecordRef) accepts DATABASE::Customer as an integer. The NUMBER function retrieves the table number and displays the name and number of the table in a message box. This example requires that you create the following variables text constant in the C/AL Globals window.

Variable name DataType
varDatabaseName Integer
MyRecordRef RecordRef
varTableNumber Integer
Text constant name DataType ENU value
Text000 Text %1 is table %2.
varDatabaseName := DATABASE::Customer;  
varTableNumber := MyRecordRef.NUMBER;  
MESSAGE(Text000, MyRecordRef.CAPTION, varTableNumber);  

See Also

RecordRef Data Type