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.