Invoice 
ColumnName  Invoice 
Definition 
Invoice number.
 

MainWBS1 
ColumnName  MainWBS1 
Definition 
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 unit transaction.
 

OriginalPeriod 
ColumnName  OriginalPeriod 
Definition 
Accounting period when the original unit transaction was posted.
 

OriginalPostSeq 
ColumnName  OriginalPostSeq 
Definition 
Posting sequence number of the original unit transaction.
 

OriginalPKey 
ColumnName  OriginalPKey 
Definition 
Internal primary key in the original table.
 

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 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 
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.
 

UnitTable 
ColumnName  UnitTable 
Definition 
Unit table used for the unit transaction.
 

Unit 
ColumnName  Unit 
Definition 
Unit number.
 

Account 
ColumnName  Account 
Definition 
Account number to which the unit transaction is posted.
 

TransDate 
ColumnName  TransDate 
Definition 
Transaction date of the unit transaction, as entered in data entry.
 

UnitName 
ColumnName  UnitName 
Definition 
Unit name from the UnitTable.
 

Description 
ColumnName  Description 
Definition 
The unit transaction description, from data entry.
 

Calculation 
ColumnName  Calculation 
Definition 
Calculation (quantity times rate).
 

Quantity 
ColumnName  Quantity 
Definition 
Quantity of the unit.
 

Rate 
ColumnName  Rate 
Definition 
Billing rate per unit.
 

Amount 
ColumnName  Amount 
Definition 
Extended unit amount.
 

CostRate 
ColumnName  CostRate 
Definition 
Cost rate per unit.
 

CostAmount 
ColumnName  CostAmount 
Definition 
Cost amount (cost rate times quantity).
 

Multiplier 
ColumnName  Multiplier 
Definition 
Unit multiplier from the project's billing terms.
 

DispFormat 
ColumnName  DispFormat 
Definition 
Level of unit detail to display on the generated invoice.
 

Summarize 
ColumnName  Summarize 
Definition 
Flag indicating whether to consolidate detail for the unit.
 

ShowDate 
ColumnName  ShowDate 
Definition 
Flag indicating whether to print the unit transaction date on the invoice.
 

ShowCalc 
ColumnName  ShowCalc 
Definition 
Flag indicating whether to show the calculation of the extended unit amount on the invoice.
 

ShowMult 
ColumnName  ShowMult 
Definition 
Flag indicating whether to show the unit multiplier on the invoice.
 

UnitDetail 
ColumnName  UnitDetail 
Definition 
Flag indicating whether to print transaction detail for the unit section on the invoice.
 

RateFlag 
ColumnName  RateFlag 
Definition 
The flag that indicates if expenses are displayed even if they are not included in the invoice.