CP_COMPANY |
Default Table Name | CP_COMPANY |
Definition | Name: Costpoint Company Table . Description: This table contains the valid Costpoint company codes. |
CP_COMPANY Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
CP_COMPANY_CD![]() |
VARCHAR(10) | NO | Name: Costpoint Company. Description: Costpoint Company Code. |
|
CP_COMPANY_NAME | VARCHAR(30) | NO | Name: Costpoint Company Name. Description: Description of Company Code. |
|
ACTIVE_FL | VARCHAR(1) | NO | Name: Active Flag. Description: Logical as to whether this Company Code is active. |
|
MODIFIED_BY | VARCHAR(20) | NO | Name: Modified By. Description: The User ID that 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_LOGO_NAME_DIR_S | VARCHAR(254) | YES | Name: Company Logo. Description: The location of the Costpoint Company logo. |
CP_COMPANY Keys |
Key Name | Key Type | Keys |
PI_0134 | PrimaryKey | CP_COMPANY_CD |
CP_COMPANY Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
LEAVE_TYPE | Non-Identifying | One To Zero or More | NO | ||||
UDT02 | Non-Identifying | One To Zero or More | NO | ||||
UDT04 | Non-Identifying | One To Zero or More | NO | ||||
UDT05 | Non-Identifying | One To Zero or More | NO | ||||
UDT06 | Identifying | One To Zero or More | NO | ||||
UDT07 | Identifying | One To Zero or More | NO | ||||
UDT09 | Non-Identifying | One To Zero or More | NO | ||||
EMPL_HISTORY | Non-Identifying | One To Zero or More | NO | ||||
TS | Non-Identifying | One To Zero or More | NO | ||||
EXP_RPT | Non-Identifying | Zero or One to Zero or More | NO | ||||
EXP_AUTH | Non-Identifying | One To Zero or More | NO |