GENERAL_CONFIG_ATTACHMENT 
Default Table Name  GENERAL_CONFIG_ATTACHMENT 
Definition 
Name: GENERAL CONFIG ATTACHMENT  Description: This table contains the valid type of attachments for the system.
 

GENERAL_CONFIG_ATTACHMENT Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
COMPANY_ID(PK)(FK)    VARCHAR(10)  NO 
Name: Record Key  Description: The Company ID for this configuration record.
 
ATTACHMENT_TYPE_CD(PK)    VARCHAR(10)  NO 
Name: Attachment Type Code Description: The unique code associated to attachment type.
 
START_DTT    DATE  NO 
Name: Active Date and Time Description: Date and time that attachment became active.
 
END_DTT    DATE  YES 
Name: Inactive Date and Time Description: Date and time that attachment became inactive.
 
S_ATTACH_OBJECT_CD    VARCHAR(10)  NO 
Name: Object Attachment Destination Description: Indicates the object that attachment is for. The valid values are: ER or EA
 
S_ATTACH_SUB_OBJECT_CD    VARCHAR(10)  NO 
Name: Task Sub Object Description: Indicates sub object that attachment is for. The valid values are: OVERALL or EXPENSE
 
MODIFIED_BY    VARCHAR(20)  NO 
 
ROWVERSION    NUMERIC(10, 0)  NO 
 
TIME_STAMP    DATE  NO 
 
S_PRINT_COVERSHEET_CD    VARCHAR(10)  NO 
Name: Print Coversheet Code  Description: Determines how the system will print the bar code coversheet.
 

GENERAL_CONFIG_ATTACHMENT Keys 
Key Name  Key Type  Keys 
UI_0001  Unique Constraint  ATTACHMENT_TYPE_CD 
PI_O234  PrimaryKey  COMPANY_ID, ATTACHMENT_TYPE_CD 
SI_0095  Inversion Entry  COMPANY_ID 

GENERAL_CONFIG_ATTACHMENT Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
COMPANY  Identifying  One To Zero or More        COMPANY_ID  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
GENERAL_CONFIG_ATTACHMENT_LBLS  Identifying  One To Zero or More          NO 
ATTACHMENT  Non-Identifying  Zero or One to Zero or More          NO 
EXP_TYPE_TASK  Identifying  One To Zero or More          NO 
EXP_RPT_TYPE_TASK  Identifying  One To Zero or More          NO 
TASK  Non-Identifying  One To Zero or More          NO 
CORRECT_TASK  Non-Identifying  One To Zero or More          NO