1. Go to the Data Maps screen (MPPP7020).
2. In the summary area, click the edit icon () next to the Source field.
   
3. On the toolbar of the Data Map Source Types window, click the Add Row icon ().
4. In the new row, complete the Source type and Description fields.
   
5. If you want this source to be the default data map used on other screens, select the Default type checkbox.
6. If you're setting up a source for a time card data map:
   1. Select the Time Card type checkbox.
   2. In the Subaccount Source dropdown, select where the subaccount will be taken from when importing time card data using this source.
7. If the source is for importing materials costs, select the Import Materials checkbox.
8. On the toolbar, click the Save current record and close the screen icon ().

1. Go to the Data Maps screen (MPPP7020).
2. In the Source field, select which timesheet source you want to set up a data map for.
3. Select which Entity Type you want to map records for:
   • Employee – All active payroll employees.
   • Pay item – All active pay items that have a calculation method of “Rated” or “Amount”.
   • Subaccount – All active subaccounts.
   • Project – All projects.
   • Inventory Item – All Non-Stock Items.

   UI Text Box
   size medium type info
   Mapping for projects and inventory items is used for the allocation of payroll expenses. Project tasks can also be imported, but the mapping for these is not set here—tasks are mapped directly by name, or the default project task is used.

4. The main grid displays details of the records in the Internal ID and Internal Description columns. Each record can only have a single external identifier mapped against it.  There are two ways you can complete mapping:

   • Manually enter enter the External ID and External Description for each record.

     
     

   • On the toolbar, click the Export to Excel icon (). Complete the mappings in the exported Microsoft Excel file. On the Data Maps toolbar, click the Load Records from File icon () to upload the completed Excel file back into the grid.

   UI Text Box
   size medium type info
   You don’t need to map all records to be able to save the mapping—any unmapped records will be ignored when mapping imported timesheet data.

5. On the toolbar, click the Save icon ().