Import sample file for timesheet or paycard (T2)
This is an example of what the file format should be when importing time cards or job costing.
USE Time America
SamplePayrollImport.txt
L373-TRA,102,4,0
L373-TRA,101,0,152.32
L322-JIM,102,80,0
L322-JIM,103,4,0
Column Description:
1- Employee ID
2- Payroll Category Code
3- Rate
4- Quantity of hours
SampleJobCostImport.txt
W,L373-TRA,102,10/10/2009,4,14.50,0,MAIN,001,001
W,L373-TRA,102,11/10/2009,3,14.50,0,MAIN,001,001
W,L373-TRA,102,11/10/2009,4,23.20,0,SECS,001,001
Column Descr1
1 "Work Detail Identifier"
2 Employee ID
3 Category Number
4 Date
5 Hours
6 Rate
7 Amount
8 Department
9 Job Center
10 Cost center
