CP_COMPANY |
Default Table Name | CP_COMPANY |
Definition | Name: Costpoint Company Table . Description: This table contains the valid Costpoint company codes. |
CP_COMPANY Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CP_COMPANY_CD![]() |
VARCHAR2(10) | NO | Name: Costpoint Company. Description: Costpoint Company Code. |
|
CP_COMPANY_NAME | VARCHAR2(30) | NO | Name: Costpoint Company Name. Description: Description of Company Code. |
|
ACTIVE_FL | VARCHAR2(1) | NO | Name: Active Flag. Description: Logical as to whether this Company Code is active. |
|
MODIFIED_BY | VARCHAR2(20) | NO | Name: Modified By. Description: The User ID that 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_LOGO_NAME_DIR_S | VARCHAR2(254) | YES | Name: Company Logo. Description: The location of the Costpoint Company logo. |
CP_COMPANY Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0134 | PrimaryKey | CP_COMPANY_CD |
CP_COMPANY Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable |
LEAVE_TYPE | Non-Identifying | One To Zero or More | F00133 | NO | NO | |||
UDT02 | Non-Identifying | One To Zero or More | F00134 | NO | NO | |||
UDT04 | Non-Identifying | One To Zero or More | F00135 | NO | NO | |||
UDT05 | Non-Identifying | One To Zero or More | F00136 | NO | NO | |||
UDT06 | Identifying | One To Zero or More | F00137 | NO | NO | |||
UDT07 | Identifying | One To Zero or More | F00138 | NO | NO | |||
UDT09 | Non-Identifying | One To Zero or More | F00139 | NO | NO | |||
EMPL_HISTORY | Non-Identifying | One To Zero or More | F00140 | NO | NO | |||
TS | Non-Identifying | One To Zero or More | F00141 | NO | NO | |||
EXP_RPT | Non-Identifying | One To Zero or More | F00203 | NO | NO | |||
EXP_AUTH | Non-Identifying | One To Zero or More | F00347 | NO | NO |