Create a custom table that you can reference in a transaction table for a crediting rule. Custom tables add qualification criteria for commissionable events that can be used in calculations for commissions.
Go to Commissions > Custom Tables.
Click New.
Complete the following fields, as needed:
Field
Description
Name
Type a unique name for the custom table.
Categories
Optional. Add or select categories to organize you custom table by.
Description
Optional. Type a description for the custom table.
Preview Imported Data
Optional. Toggle on to preview the data that you import from a
.csv
file.Enable Date Boundaries
Optional. Toggle on to check table entries for start and end dates.
From the Date Boundary dropdown, select a field to filter the date by.
CSW Delimiter
Select one of the following depending on the delimiter type used in your region:
Comma (,)—most common.
Semicolon(;)
Click Add Columns.
Select the column type you want to add:
Custom Column: Select the data type for that column.
Date Created: Date data type automatically populates when a row is created.
Date Modified: Date data type automatically populates when a row is updated.
Click Save & Continue.
Add custom columns
Click Add Columns > Custom Columns.
In the Column Name field, type a name for the column header.
From the dropdown, select the data type for the column and complete additional configurations, as needed:
Single Line
A single line of text such as a name.
Optional. Select the Case Sensitive checkbox if the data requires unique identification.
Phone Number
A single line of text with a combination of numbers and hyphens that indicate a phone number.
Round Number
An integer that indicates a whole number.
Decimal Number
A number that may have decimal value such as payment data or percentages.
Date
Displays the month, day, and year formatted as
MMDDYYYY
.Paragraph Text
Text that requires more than a single line.
Optional. Select the Case Sensitive checkbox if the data in a text type column requires unique identification.
Drop Down
Set options you select from:
In the Add Categories fields, type an option for the dropdown list.
Press Enter.
Add as many dropdown option as needed.
Note
If you import a
.csv
file, the values for a dropdown column must match. If values do not match the dropdown options, they will not import into the table.
Email
Single line of text associated with an individuals email address.
Optional. Select the Case Sensitive checkbox if the data requires unique identification.
URL
A single line of text associated with a website URL.
Optional. Select the Case Sensitive checkbox if the data requires unique identification.
User
Single line of text that pulls in available users in Fullcast to select from.
Optional. Select the Case Sensitive checkbox if the data requires unique identification.
Password
Single line of text associated with a unique password.
Truncate
A single line of text that is condensed when used in commissions calculations.
Add additional columns as needed.
Click Save & Continue.
Import or manually add rows to the table.