Table structure
In Varicent Incentives, when you add Data, Structural, and Custom tables in the Data module, you must add columns to the table to create the structure of the table.
Table column types
In Incentives, you can define the structure of tables using several different column types.
The following types of columns can be used to create your table schema.
Column Type | Description |
|---|---|
Text | Can contain any numeric, alpha, or symbol, but cannot be used in a formula. Text fields have a limit of 100 characters. |
Date | Can contain any data in a date format ( |
Numeric | Can contain only figures and can be used in formulas. A numeric column can contain up to 28 integers and 14 decimal places. |
Pick List | A link to another table. Values that are loaded into this field must be contained in the linked table or they will be rejected during an import. Pick lists are ideal for situations where the data that you need exists. For example, you can add a pick list for the payee ID. If you want to add a Data table that contains accounts, dates, payees, values, and customers, you can define pick lists for accounts and payees. ImportantPick lists can only pick from Hierarchy and Structural tables. |
A column similar to Text but with extra validation to restrict the input to email addresses. | |
Comment | A column that is designed for longer text input. Comment fields have a limit of 1000 characters. |
URL | Restricts input to valid URLs. |
Calculated | A column type that performs a calculation based on other columns in the table. |
Lookup | A column that uses conditions to extract data from a source table to add to the target table containing the lookup column. |
Primary keys
In Incentives, a primary key uniquely identifies each row in a table.
If your primary key is the payee ID, no two rows of data in your table can contain the same payee ID. You can identify more than one primary key in some tables. If you add a custom table that identifies both the payee ID column and the date column as primary keys, no two rows of data can contain the same combination of date and payee ID.