| Batch |
| ColumnName | Batch |
| Definition | Named of the timesheet transaction data entry file. |
| Employee |
| ColumnName | Employee |
| Definition | The employee's employee number. |
| PKey |
| ColumnName | PKey |
| Definition | Internal primary key. |
| Seq |
| ColumnName | Seq |
| Definition | Internal sequence number. |
| TransDate |
| ColumnName | TransDate |
| Definition | Date on the transaction detail line. |
| WBS1 |
| ColumnName | WBS1 |
| Definition | Project to which the timesheet amount applies. |
| WBS2 |
| ColumnName | WBS2 |
| Definition | The reference field for the project phase. This column is populated by Deltek once the WBS1 column in this table is filled in. |
| WBS3 |
| ColumnName | WBS3 |
| Definition | The reference field for the project task. This column is populated by Deltek once the WBS1 column in this table is filled in. |
| LaborCode |
| ColumnName | LaborCode |
| Definition | Labor code to which the timesheet amount applies. |
| RegHrs |
| ColumnName | RegHrs |
| Definition | Regular hours adjusted on the detail line. |
| OvtHrs |
| ColumnName | OvtHrs |
| Definition | Overtime hours adjusted on the detail line. |
| TransComment |
| ColumnName | TransComment |
| Definition | Comment. |
| SpecialOvtHrs |
| ColumnName | SpecialOvtHrs |
| Definition | Special overtime hours. |
| BillCategory |
| ColumnName | BillCategory |
| Definition | The employee's default category when using the By category labor billing method. |
| Locale |
| ColumnName | Locale |
| Definition | The employee's payroll tax locale. |
| RegAmt |
| ColumnName | RegAmt |
| Definition | The employee's regular pay amount. |
| OvtAmt |
| ColumnName | OvtAmt |
| Definition | The employee's overtime pay amount. |
| SpecialOvtAmt |
| ColumnName | SpecialOvtAmt |
| Definition | The employee's special overtime pay amount. |
| ExchangeInfo |
| ColumnName | ExchangeInfo |
| Definition | For internal use. |
| RegAmtProjectCurrency |
| ColumnName | RegAmtProjectCurrency |
| Definition | The employee's regular pay amount in the functional currency of the company owning the project, phase if any, and task if any. |
| OvtAmtProjectCurrency |
| ColumnName | OvtAmtProjectCurrency |
| Definition | The employee's overtime pay amount in the functional currency of the company owning the project, phase if any, and task if any. |
| SpecialOvtAmtProjectCurrency |
| ColumnName | SpecialOvtAmtProjectCurrency |
| Definition | The employee's special overtime pay amount in the functional currency of the company owning the project, phase if any, and task if any. |
| ProjectExchangeInfo |
| ColumnName | ProjectExchangeInfo |
| Definition | For internal use. |
| BillExt |
| ColumnName | BillExt |
| Definition | The billing extension. |
| OvtPct |
| ColumnName | OvtPct |
| Definition | The employee's overtime percentage rate. |
| SpecialOvtPct |
| ColumnName | SpecialOvtPct |
| Definition | The employee's special overtime percentage rate. |
| Rate |
| ColumnName | Rate |
| Definition | The employee's job cost rate. |
| OvtRate |
| ColumnName | OvtRate |
| Definition | The employee's overtime rate. |
| SpecialOvtRate |
| ColumnName | SpecialOvtRate |
| Definition | The employee's special overtime rate. |
| RateProjectCurrency |
| ColumnName | RateProjectCurrency |
| Definition | The employee's job cost rate in the functional currency of the company owning the project, phase if any, and task if any. |
| OvtRateProjectCurrency |
| ColumnName | OvtRateProjectCurrency |
| Definition | The employee's overtime rate in the functional currency of the company owning the project, phase if any, and task if any. |
| SpecialOvtRateProjectCurrency |
| ColumnName | SpecialOvtRateProjectCurrency |
| Definition | The employee's special overtime rate in the functional currency of the company owning the project, phase if any, and task if any. |
| TLInternalKey |
| ColumnName | TLInternalKey |
| Definition | Traffic Live Internal Key |