Table Properties

The following properties are related to report models that are used to add information to a report. For more information, see Create Reports Using Report Builder.

  • AnalysisSelection

  • AnalysisVisibility

  • IsLookup

  • SingularLabel

  • TypicalRowCount

For information about system properties available for tables, see System Properties. For guidelines about setting property values, see Best Practice for table properties.

The following table describes table properties.

Property

Description

AnalysisSelection

Specifies whether a drop-down list, a list box, or a filtered list box is used to select table records when you are using Report Builder for Microsoft SQL Server Reporting Services.

For more information about report models, see Create an Ad Hoc Report Model.

AnalysisVisibility

Specifies the visibility of a table in report models using the following property values:

  • High specifies that a table appears in the root of the reporting model.

  • Medium specifies that a table appears in a folder for the security key associated with the table.

  • Low specifies that a table appears in a subfolder called Other Data.

If you set the property to None, the table does not appear in report models.

For more information about report models, see Create an Ad Hoc Report Model.

AOSAuthorization

Specifies the type of operation that a user can perform on a table, depending on the user's permissions.

When the property is set to None, an authorization check is not performed.

For more information about user permissions, see Restrict Access to Tables and Fields.

CacheLookup

Determines how to cache the records retrieved during a lookup operation.

ClusterIndex

Specifies the cluster index.

This property is used only for SQL optimization purposes.

ConfigurationKey

Specifies the configuration key for the table.

Configuration keys allow a system administrator to enable and disable certain parts of an application.

CreatedBy

Indicates whether the system maintains the CreatedBy field for the records in a table. This field contains information about who created a particular record.

CreatedDate

Indicates whether the system maintains the CreatedDate field for the records in a table. This field contains the date when a record was created.

CreatedTime

Indicates whether the system maintains the CreatedTime field for the records in a table. This field contains the time when a record was created.

CreatedTransactionId

Indicates whether the system maintains the CreatedTransactionId field for the records in a table. This field contains information about which transaction created the record.

CreateRecIdIndex

Indicates whether an index on the Record ID field is created.

FormRef

Specifies the display menu item that is activated when a table is referenced. A display menu item is associated with a form.

When you use a primary index field on a report, this form is available as a link in the report. A primary index is specified by using the PrimaryIndex property.

If you leave this field blank, the system attempts to display a form that has the same name as the table.

ID

Specifies the table ID generated by the system. For more information, see Application Object IDs.

IsLookup

Specifies whether the table information is incorporated into other tables that reference it when a report model is generated.

Label

Specifies the label for a table.

MaxAccessMode

Specifies the access rights when the table is used as a data source in a form or a report.

If the table is used as a data source in a form, then the access rights in the form cannot exceed the access rights defined for the table.

ModifiedBy

Indicates whether the system maintains the ModifiedBy field for the records in a table. This field records the person who performed the last modification to a record.

ModifiedDate

Indicates whether the system maintains the ModifiedDate field for the records in a table. This field records the date of the last modification of a record.

ModifiedTime

Indicates whether the system maintains the ModifiedTime field for the records in a table. This field records the time when a record was last modified.

ModifiedTransactionId

Indicates whether the system maintains the ModifiedTransactionId field for the records in a table. This field contains the ID of the transaction that performed the last modification to a record.

Name

Specifies the table name.

OccEnabled

Specifies whether the optimistic concurrency mode is enabled for a table.

When this mode is enabled, data is not locked from future modification when it is fetched from the database. Data is locked only when the actual update is performed.

PrimaryIndex

Specifies the primary index.

Only a unique index can be selected.

The property is used for database optimization purposes and to indicate which unique index to use as the caching key. If a primary index is not specified, the unique index with the lowest ID is used as the caching key.

ReportRef

Specifies the output menu item that is activated when a table is referenced. An output menu item is associated with a report.

When you use a primary index field on a report, this report is available as a link in the report. A primary index is specified using the PrimaryIndex property.

SaveDataPerCompany

Indicates whether the data for the current company is saved.

If you set the property to No, data is saved without a company identifier (DataAreaId).

NoteNote
If the SaveDataPerCompany property on a table is set to Yes, the SetCompany property on a form design that uses the table as a data source must also be set to Yes.

To see a list of tables with non-company-specific data, see Tables that are not Company-Specific.

TipTip
The company acronym can be seen in the status line. Double-clicking the acronym opens a dialog box to change to another company.

SearchLinkRefName

Specifies the name of the menu item that links to information on a Web site about a table record listed in the Enterprise Portal search results.

If the SearchLinkRefType property is set to URL, select a menu item from the SearchLinkRefName property list that links to a Web part page that displays the table data.

Forms and reports on Web part pages can display data. For more information, see Create Forms for Web Part Pages and Create Reports for Web Part Pages.

For information about setting up Enterprise Portal search for a Web site, see Set up search for Enterprise Portal.

SearchLinkRefType

Specifies the type of the menu item that links to information on a Web site about a table record listed in the Enterprise Portal search results.

SecurityKey

Specifies the security key for a table. This will usually be the key called ModuleTable, where Module is the name of the Module in the Navigation Pane where the table is used, for example LedgerTable.

SingularLabel

Specifies the label that is used in a report model to display the singular name of items stored in the table.

SystemTable

Indicates if a table appears as a System table. It can then be filtered during export and import.

System tables are always synchronized when you log in. This may be useful for tables that you use as soon as you log in.

TableContents

Specifies how setup/parameter data can be reused from one customer to another. The following values are possible:

  • Not specified – For most tables.

  • Default Data – Use for customer-independent data such as ZIP/Postal Codes, units, and time intervals.

  • Base Data – Use for customer-dependent data such as calendars, groups, and parameters.

  • Default+Base data – Use for data where the local perception varies. For example, Chart of Accounts is not customer-dependent in Germany, but is most other places in the world.

TableGroup

Determines which group the table belongs to.

Table Groups provide a method for categorizing tables according to the type of data they contain. Table groups can be used to define whether the system should prompt users when they update or delete from the table in forms by using the table as the data source. When exporting data, you can use table groups to filter records.

Temporary

Marks a table as temporary if you need to gather temporary information in a table format.

Temporary tables are not persistent. They are written to local disk storage, but not stored in the database.

TitleField1, TitleField2

Enables you to do the following:

  • Add table field data to a form caption.

  • Display additional fields in a lookup form. For more information, see Creating lookup Forms. The TitleField1 property is also used when activating the lookup list in a field on a form. The fields you specify for TitleField1 and TitleField2 properties can be merged with the key value.

  • Display field information in a tooltip.

TypicalRowCount

Specifies the number of records that typically appear in a table.

If the AnalysisSelection property is not set, the TypicalRowCount property determines how records are selected by using Report Builder for Microsoft SQL Server Reporting Services.

The TypicalRowCount property setting affects whether a drop-down list, list box, or a filtered list box is used to select table records. For more information, see Best Practice for table properties.

For more information about report models, see Create an Ad Hoc Report Model.

Community Additions

ADD
Show: