UNTable 
Default Table Name  UNTable 
Definition  
Units Table - Data Entry Master
 

UNTable Columns 
ColumnName  Domain  Datatype  NULL  Definition 
UnitTable(PK)    nvarchar(30)  NO 
 
Company    nvarchar(14)  NO 
 
ProjectCurrencyCode    nvarchar(3)  YES 
 
BillingCurrencyCode    nvarchar(3)  YES 
 
AvailableForPlanning    varchar(1)  NO 
 
FilterOrg    nvarchar(30)  YES 
 
FilterPrincipal    nvarchar(20)  YES 
 
FilterProjMgr    nvarchar(20)  YES 
 
FilterSupervisor    nvarchar(20)  YES 
 
FilterCode    nvarchar(10)  YES 
 
Status    varchar(1)  YES  
The value in the Status field on the transaction entry screen.
 
Rowversion    timestamp  NO  
The date and time when the last insert or update was done. This column is used for Incremental Cube Data Refresh.
 
CreateUser    nvarchar(32)  YES  
The user who created this record
 
CreateDate    datetime  YES  
The date and time when this record was created.
 
ModUser    nvarchar(32)  YES  
The user who modified this record.
 
ModDate    datetime  YES  
The date and time when this record was modified.
 

UNTable Primary and Unique Keys 
Key Name  Key Type  Keys 
UNTablePK  PrimaryKey  UnitTable 

UNTable 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