UDT07 
Default Table Name  UDT07 
Definition 
 Name: UDT07 Master.     Description: This is the master table of UDT07 IDs.
 

UDT07 Columns 
ColumnName  Domain  Datatype  NULL  Definition 
UDT07_ID(PK)    VARCHAR2(20)  NO 
Name: UDT07 ID. Description: Unique user-provided identifier ID for this 07 user-defined table record.
 
UDT07_NAME    VARCHAR2(30)  NO 
Name: UDT07 Name. Description: Description of user-defined ID.
 
ACTIVE_FL    VARCHAR2(1)  NO 
Name: Active Flag. Description: Logical as to whether this UDT07 ID is active.
 
MODIFIED_BY    VARCHAR2(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMBER(10, 0)  NO 
Name: Row Version. Description: The number of times this record has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 
CP_COMPANY_CD(PK)(FK)    VARCHAR2(10)  NO 
Name: Costpoint Company. Description: Costpoint Company Code
 
RATE1_RATE    NUMBER(15, 5)  NO 
Name: User Defined Rate 1. Description: User-defined rate 1 for UDT07. 
 
RATE2_RATE    NUMBER(15, 5)  NO 
Name: User Defined Rate 2. Description: User-defined rate 2 for UDT07
 

UDT07 Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0009  PrimaryKey  UDT07_ID, CP_COMPANY_CD 

UDT07 Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
CP_COMPANY  Identifying  One To Zero or More  F00138      CP_COMPANY_CD  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
LINK17  Identifying  One To Zero or More  F00055        NO  NO 
LINK27  Identifying  One To Zero or More  F00057        NO  NO 
LINK17_WILDCARD  Identifying  One To Zero or More  F00067        NO  NO 
LINK27_WILDCARD  Identifying  One To Zero or More  F00068        NO  NO 
WAGE_SCHEDULE_RATE  Identifying  One To Zero or More  F00180        NO  NO