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![]() |
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![]() |
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 |