AX1639
GetTableInfo function
Returns information about a table, given the table name.
Syntax
GetTableInfo("CodeName", "TableName")
Parameter | Description |
---|---|
CodeName |
Specifies the table property to return. Use one of the following values:
The following options only apply to product systems, and are configured by product development and implementation consultants:
|
TableName |
The name of the table for which you want to return information. |
All non-numeric entries must be placed in double quotation marks, unless you are using cell references to reference the text held in another cell.
Remarks
GetTableInfo is a non-volatile function.
Examples
=GetTableInfo("Classification","Dept")
This example returns the table classification of Dept. For example: Reference.
=GetTableInfo("TableType","GL2019")
This example returns the table type that the table is assigned to. For example: GLData.