Contents of the Cost Pay Labor Code Tables Form

Use the form to specify effective dates for your employees' cost/pay labor code rates.

Contents

The fields and options in this section display at the top of the form.

Field	Description
Rate table search	Use the field next to the form title to search for and select an existing cost/pay labor code table to view or edit. Click the filter drop-down arrow on the left side of the search field, and select one of the following search types: All: Select from a list of all cost/pay labor code tables to which you have access. [saved custom search filter]: Select a previously saved custom filter to display the cost/pay labor code tables returned by that custom search. Custom: Display the Custom Search dialog box. You can then create and apply a new custom search filter, which you can save for future use. For information about creating and using searches, see the following topics in Basics: Search for and Select a Record Create a Custom Search Filter Custom Search Dialog Box
x of x	Use these arrow icons to scroll through the cost/pay labor code tables and open a different record on the form. The numbers show you which record you are viewing out of the total number of records in the search results.
+ New Rate Table	Click + New Rate Table to create a new cost/pay labor code table.
	Click the Switch to List View icon to switch to the list view of the form. In this view, fields are displayed in columns in one grid on the form rather than on separate tabs. Table name records are displayed in each row in the grid. This makes it easy to compare and update multiple records at one time because you do not have to open individual records. You can add, remove, or change the order of the columns in the grid by clicking to the right of the grid. This opens the List View Settings dialog box. Click to filter the grid contents based on column values. For information about how the filter works, see Filter the Grid Results. For information about selecting columns, see Select Columns for a Grid. For more information and instructions on how to use list view, see Use the List View.
	After you have switched to list view, click the Switch to Detailed View icon to switch back to the detailed view of the form. Detail view is the default view that displays when you open a form for the first time; thereafter, the view that was active when you closed the application will display when you open. The detail view is the format that is described in help topics in the Help system.
Edit	Click this button to open all fields in the form for editing.
Other Actions	Click this option and choose an option from the drop-down list: Copy: Select this option to copy the details of the currently displayed rate table. Export All: This option displays if you are in the List View. Select this option to export records to a .CSV file format. You have the option of selecting all records (the default) or a subset of records for export to the .CSV file. The export function is disabled if you are in Detail View. Delete: Select this option to delete the currently displayed rate table.

Header Information

Field	Description
Table Name	Enter a name for the table. The name displays in place of the table number on all drop-down lists for rate tables in Billing Terms Setup.
Table Number	Enter a number by which to identify this table. Assign sequential numbers to help identify tables quickly.
Rate Type	Select Cost Rate, Pay Rate, or Both from the drop-down list. If Payroll is not installed, you must select Cost Rate. Regardless of the rate type that you enter here, any table defined on this form displays in the Search lookup list.
Currency	If you use multiple currencies, select the currency to use for all employees in the table. The default is the functional currency of the active company. You can change the selection in this field unless the rate table is currently selected for a project in Billing Terms. If you try to change the currency for a table that is in use, DPS displays a prompt to indicate that you cannot change the currency.

Labor Code Grid

Field	Description
Labor Code Mask	Enter a labor code, or combination of valid labor code characters and wildcard characters. The wildcard is an underscore (_). For example, if your company uses four-digit labor codes, and you want to charge a specific code to all labor codes with a 2 as the second level, enter _2__. When you edit the labor override table or add a labor code rate, click to search for a labor code mask in the Labor Code Lookup dialog box. All of a table's rows must use the same approach, either a labor code or a labor code mask. If you use labor code masks, all of the masks in a table must use a wildcard for the same labor code levels. For information on the Labor Code Lookup dialog box, see the Contents of the Labor Code Lookup Dialog Box.
Description	Optional. Enter an internal description for the labor code, which will display in cost/pay labor code lists.
Effective Date	Specify the effective date for this labor code cost/pay rate. Each labor code in a table can have one row without an effective date specified. You can use this row to enter a default rate, which is used when no other row has an applicable effective date.
Rate	Enter the cost/pay rate to use for this labor code.
OVT PCT	Enter the overtime percent cost/pay rate that you want to use for costing/paying overtime labor by employees with this labor code. This field displays if it is enabled for Accounting or Payroll.
OVT-2 PCT	Enter the secondary overtime percent cost/pay rate that you want to use for costing/paying secondary overtime labor by employees with this labor code. This field displays if it is enabled for Accounting or Payroll.
	This icon displays at the end of the row when you click or hover over a grid row. Click the icon to select one of these actions for that row: Delete: Choose this option to delete the employee rate entry. Copy: Choose this option to copy the employee name and rate details as a new employee rate entry, excluding the effective date.
Filter	Click to filter the grid contents based on column values. For information about how the filter works, see Filter the Grid Results.
+ Add Labor Code Rate	Click + Add Labor Code Rate to create a new cost/pay labor code rate entry. Enter the labor code mask, description, effective date, and rate details. Press Enter or click outside the row to add the new labor code rate entry to the cost/pay labor code table.