You can capture custom fields in the CostRecovery table by completing the following tasks.
- Add the custom field to the SQL database
- Enable the custom field in the AccuRoute Server Administrator
- Create a Filescan control file
Add the custom field to the SQL database
To add the custom field
In the SQL server, modify the dbo.CostRecoveryData table to add a column for the field using the following format for the field name: prTemplateVars.XXXX (where XXXX is the name of the field you are trying to capture). For example, if you are trying to capture the identification of a multifunctional device that scanned a job and need to add a custom field called MFDID, in the SQL database, you have to create a field called prTemplateVars.MFDID.
Enable the custom field in the Server Administrator
To enable the custom field
- Double-click Billing in the Components node to open Properties dialog box.
- Click the Configuration tab to open Configurationdialog box.
- Verify that the Enable Collection of billing data check box is selected.
- In the area labeled Select the columns to populate, find the new field you added in the SQL database and select the box beside the column to enable it.
- Click OK.
Create a Filescan control file
To create a Filescan control file
Create a filescan control file that references your new field. In the control file use the variable #XXXX . For example, if you create the field prTemplateVars.MFDID, use the variable #MfpID in the control file.
See also