BTRRT 
Default Table Name  BTRRT 
Definition  
Billing Rate Table - Labor Rate Tables
 

BTRRT Columns 
ColumnName  Domain  Datatype  NULL  Definition 
TableNo(PK)    int  NO  
The labor rate table's number.
 
TableName    nvarchar(40)  YES  
The labor rate table's name.
 
AvailableForPlanning    varchar(1)  NO  
Variable indicating whether the table is available to Resource Planning.
 
CurrencyCode    nvarchar(3)  YES  
The labor rate table's currency code.
 
FilterOrg    nvarchar(30)  YES  
The code for the organization associated with the TableNo. This code works as a filter, enforcing record-level access for this table.
 
FilterPrincipal    nvarchar(20)  YES  
The Employee ID of the principal associated with the TableNo. This code works as a filter, enforcing record-level access for this table.
 
FilterProjMgr    nvarchar(20)  YES  
The Employee ID of the project manager associated with the TableNo. This code works as a filter, enforcing record-level access for this table.
 
FilterSupervisor    nvarchar(20)  YES  
The Employee ID of the supervisor associated with the TableNo. This code works as a filter, enforcing record-level access for this table.
 
FilterCode    nvarchar(10)  YES  
The table's code from the Billing Rate Code Table.
 

BTRRT Primary and Unique Keys 
Key Name  Key Type  Keys 
BTRRTPK  PrimaryKey  TableNo 

BTRRT 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