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

UDT09 Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
UDT09_ID(PK)    VARCHAR(20)  NO 
Name: UDT09 ID. Description: Unique user-provided identifier ID for this 09 user-defined table record.
 
UDT09_NAME    VARCHAR(30)  NO 
Name: UDT09 Name. Description: Description of user-defined ID.
 
ACTIVE_FL    VARCHAR(1)  NO 
Name: Active Flag. Description: Logical as to whether this UDT09 ID is active.
 
MODIFIED_BY    VARCHAR(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMERIC(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)    VARCHAR(10)  NO 
Name: Costpoint Company. Description: Costpoint Company Code
 
UDT09_ABBRV_ID    VARCHAR(20)  YES 
Name: UDT09 Abbreviation ID. Description: Abbreviation for UDT09.
 

UDT09 Keys 
Key Name  Key Type  Keys 
RI_F00139  Inversion Entry  CP_COMPANY_CD 
PI_0011  PrimaryKey  UDT09_ID 

UDT09 Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
CP_COMPANY  Non-Identifying  One To Zero or More        CP_COMPANY_CD  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
LINK19  Identifying  One To Zero or More          NO 
LINK29  Identifying  One To Zero or More          NO 
LINK93  Identifying  One To Zero or More          NO 
EXP_RPT_CHARGE_ALLOCATIONS  Non-Identifying  One To Zero or More          NO 
EXP_AUTH_CHARGE_ALLOCATIONS  Non-Identifying  One To Zero or More          NO