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

UDT09 Columns 
ColumnName  Domain  Datatype  NULL  Definition 
UDT09_ID(PK)    VARCHAR2(20)  NO 
Name: UDT09 ID. Description: Unique user-provided identifier ID for this 09 user-defined table record.
 
UDT09_NAME    VARCHAR2(30)  NO 
Name: UDT09 Name. Description: Description of user-defined ID.
 
ACTIVE_FL    VARCHAR2(1)  NO 
Name: Active Flag. Description: Logical as to whether this UDT09 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(FK)    VARCHAR2(10)  NO 
Name: Costpoint Company. Description: Costpoint Company Code
 
UDT09_ABBRV_ID    VARCHAR2(20)  YES 
Name: UDT09 Abbreviation ID. Description: Abbreviation for UDT09.
 

UDT09 Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0011  PrimaryKey  UDT09_ID 

UDT09 Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
CP_COMPANY  Non-Identifying  One To Zero or More  F00139      CP_COMPANY_CD  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
LINK19  Identifying  One To Zero or More  F00053        NO  NO 
LINK29  Identifying  One To Zero or More  F00059        NO  NO 
LINK93  Identifying  One To Zero or More  F00060        NO  NO 
EXP_RPT_CHARGE_ALLOCATIONS  Non-Identifying  One To Zero or More  F00342        NO  NO 
EXP_AUTH_CHARGE_ALLOCATIONS  Non-Identifying  One To Zero or More  F00358        NO  NO