| Invoice |
| ColumnName | Invoice |
| Definition | Invoice number. |
| MainWBS1 |
| ColumnName | MainWBS1 |
| Definition | The project for which the entire invoice is being created. This is either the main project in a billing group or the actual project. |
| OriginalTable |
| ColumnName | OriginalTable |
| Definition | Table containing the original labor transaction. |
| OriginalPeriod |
| ColumnName | OriginalPeriod |
| Definition | The accounting period when the original labor transaction was posted. |
| OriginalPostSeq |
| ColumnName | OriginalPostSeq |
| Definition | The posting sequence number for the original labor transaction. |
| OriginalPKey |
| ColumnName | OriginalPKey |
| Definition | The internal primary key of the OriginalTable. |
| BillWBS1 |
| ColumnName | BillWBS1 |
| Definition | Project with which the transaction is to be billed. This is either the main project in a billing group or the actual project. |
| BillWBS2 |
| ColumnName | BillWBS2 |
| Definition | The reference field for the project phase. This column is populated by Deltek once the BillWBS1 column in this table is filled in. |
| BillWBS3 |
| ColumnName | BillWBS3 |
| Definition | The reference field for the project task. This column is populated by Deltek once the BillWBS1 column in this table is filled in. |
| PostWBS1 |
| ColumnName | PostWBS1 |
| Definition | Project to which the labor transaction is to be posted. |
| PostWBS2 |
| ColumnName | PostWBS2 |
| Definition | The reference field for the project phase. This column is populated by Deltek once the PostWBS1 column in this table is filled in. |
| PostWBS3 |
| ColumnName | PostWBS3 |
| Definition | The reference field for the project task. This column is populated by Deltek once the PostWBS1 column in this table is filled in. |
| WBS1 |
| ColumnName | WBS1 |
| Definition | The project for which the entire invoice is being created. This is either the main project in a billing group or the actual project. |
| 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. |
| SortKey1 |
| ColumnName | SortKey1 |
| Definition | First sorting criterion for the labor transaction. |
| SortKey2 |
| ColumnName | SortKey2 |
| Definition | Second sorting criterion for the labor transaction. |
| SortLabel1 |
| ColumnName | SortLabel1 |
| Definition | Label for the first sorting criterion for the labor transaction. |
| SortLabel2 |
| ColumnName | SortLabel2 |
| Definition | Label for the second sorting criterion for the labor transaction. |
| Employee |
| ColumnName | Employee |
| Definition | Employee number. |
| Name |
| ColumnName | Name |
| Definition | Employee name. |
| OvertimeFlag |
| ColumnName | OvertimeFlag |
| Definition | Displays "Ovt" or overtime hours. |
| TimesheetDate |
| ColumnName | TimesheetDate |
| Definition | Date of timesheet entered. |
| Hours |
| ColumnName | Hours |
| Definition | Total hours. |
| Rate |
| ColumnName | Rate |
| Definition | Employee's rate as it appears on the labor detail line. |
| RateFlag |
| ColumnName | RateFlag |
| Definition | Flag indicating whether an asterisk marks rates from the override table. |
| Extension |
| ColumnName | Extension |
| Definition | Total hours times the employee's rate. |
| TransComment |
| ColumnName | TransComment |
| Definition | Transaction comment. |
| OverrideType |
| ColumnName | OverrideType |
| Definition | Override type. |
| SubjectToMarkup |
| ColumnName | SubjectToMarkup |
| Definition | Amount subject to markup on total amount. This will be the same as the extension amount without override billing rates for Method 1. |
| FullExtension |
| ColumnName | FullExtension |
| Definition | Extension with all markups. This amount is usually not printed. |
| OvertimePremium |
| ColumnName | OvertimePremium |
| Definition | Overtime premium. With markup if multiplier not to be shown, otherwise without. |
| Method |
| ColumnName | Method |
| Definition | Variable indicating the labor billing method. Valid options are 0-No labor billing, 1-Rate times multiplier, 2-Rate table, 3-By category, 4-by labor code. |
| Multiplier1 |
| ColumnName | Multiplier1 |
| Definition | Labor multiplier 1. |
| Multiplier2 |
| ColumnName | Multiplier2 |
| Definition | Labor multiplier 2. |
| Multiplier3 |
| ColumnName | Multiplier3 |
| Definition | Labor multiplier 3. |
| OvtMultiplier |
| ColumnName | OvtMultiplier |
| Definition | Labor overtime multiplier. |
| LaborDetail |
| ColumnName | LaborDetail |
| Definition | Flag indicating whether to display labor detail on the invoice. |
| ShowComment |
| ColumnName | ShowComment |
| Definition | Flag indicating whether to print timesheet comments on the invoice. |
| ShowRate |
| ColumnName | ShowRate |
| Definition | Flag indicating whether to print the billing rate and extension on the invoice. |
| ShowDate |
| ColumnName | ShowDate |
| Definition | Flag indicating whether to print the timesheet date on the invoice. |
| ShowMults |
| ColumnName | ShowMults |
| Definition | Flag indicating whether to show the labor multiplier(s) on the invoice. |
| ShowOvtMult |
| ColumnName | ShowOvtMult |
| Definition | Flag indicating whether to show the labor overtime multiplier on the invoice. |
| SortMeth1 |
| ColumnName | SortMeth1 |
| Definition | First level sort method. |
| SortMeth2 |
| ColumnName | SortMeth2 |
| Definition | Second level sort method. |
| LaborCode |
| ColumnName | LaborCode |
| Definition | Labor code from the timesheet. |
| SpecialOvertimePremium |
| ColumnName | SpecialOvertimePremium |
| Definition | Special overtime premium amount. |
| SpecialOvtMultiplier |
| ColumnName | SpecialOvtMultiplier |
| Definition | Special overtime multiplier. |
| SortKey3 |
| ColumnName | SortKey3 |
| Definition | Third sorting criterion for the labor transaction. |
| SortLabel3 |
| ColumnName | SortLabel3 |
| Definition | Label for the third sorting criterion for the labor transaction. |
| LaborCategory |
| ColumnName | LaborCategory |
| Definition | The labor category on the Billing Backup report. |
| FixedFee |
| ColumnName | FixedFee |
| Definition | Flag Y/N indicating whether the project is a so-called fixed fee project. Y indicates that the project has fee billing terms and that on the Billing Backup tab, the Include Labor For option is set to Sections with Labor or Fee Terms. |
| EmpName |
| ColumnName | EmpName |
| Definition | The name of the employee as it appears on the labor section of the Invoice report. |
| BackupEmpName |
| ColumnName | BackupEmpName |
| Definition | The name of the employee as it appears on the labor section of the Backup Invoice report. |