unDetail 
Default Table Name  unDetail 
Definition  
Units Table - Data Entry Detail
 

unDetail Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Batch(PK)    nvarchar(30)  NO  
Name of the unit transaction data entry file.
 
Unit(PK)    nvarchar(30)  NO  
Unit number.
 
PKey(PK)    nvarchar(44)  NO  
Internal primary key.
 
Seq    int  NO  
Internal sequence number.
 
TransDate    datetime  YES  
Date of the transaction.
 
WBS1    nvarchar(30)  YES  
Project to which the unit amount applies.
 
WBS2    nvarchar(30)  YES  
The reference field for the project phase. This column is populated by Deltek once the WBS1 column in this table is filled in.
 
WBS3    nvarchar(30)  YES  
The reference field for the project task. This column is populated by Deltek once the WBS1 column in this table is filled in.
 
TableNo    nvarchar(30)  YES  
Unit table to use for the transaction.
 
Account    nvarchar(13)  YES  
Account to which the unit amount applies.
 
Description    nvarchar(80)  YES  
Unit description.
 
Quantity    decimal(19, 4)  NO  
Unit quantity.
 
CurrencyExchangeOverrideRate    decimal(19, 10)  NO  
The currency exchange override rate, if any, entered for the transaction. Used for converting the transaction currency to the functional currency of the company owning the project; the project's phase, if any; and the project's task, if any.
 
Employee    nvarchar(20)  YES  
The employee's employee number.
 
EmployeeCompany    nvarchar(14)  YES  
The company to which the employee belongs.
 
tkPKey    varchar(32)  YES  
Internal key.
 

unDetail Primary and Unique Keys 
Key Name  Key Type  Keys 
unDetailPK  PrimaryKey  Batch, Unit, PKey 

unDetail Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication