# System functions

## VarInfo

Use this function to return the value of a property for a given variable. Use the variable reference not name.

For example:

Expression

```apteco
varInfo("boCost","Minimum")
```

This expression returns £120.

## TableInfo

Use this function to return the value of the property for the given table.

Expression

```apteco
TableInfor("tablename","tableproperty")
```

Allowed properties are:

- `NumRecords`
- `NumRecordsMatchParent`
- `MinMatches`
- `MaxMatches`

The result is a number. If a property is not defined for the given table then a missing value is returned.

For example, `TableInfo("bookings","NumRecords")` returns the number of records in the Bookings table.

## VarCountsInfoNth

Use this function to return the value of the property for the given variable.

Expression

```apteco
VarCountsInfoNth("variablename","ordering","Nth number","returnvalue","omitunclassified")
```

Allowed orderings are:

- `Top`
- `Bottom`

Allowed return values are:

- `Code`
- `Desc`
- `Count`
- `Index`

Omit Unclassified is optional and is false by default. If a property is not defined for the given variable then a missing value is returned.

For example, `VarCountsInfoNth("boDest","Top",1,"Desc")` returns the description of the Booking Destination with the highest instant count.