CREATE TABLE FINANCIAL_ENTITY_ATTACHMENT
   (FINANCIAL_ENTITY_ATTACHMENT_ID NUMBER(12,0) NOT NULL ENABLE, 
    FINANCIAL_ENTITY_ID_FK NUMBER(12,0) NOT NULL ENABLE,
    FILE_ID NUMBER(12,0) NOT NULL ENABLE,
    DESCRIPTION VARCHAR2(200) NOT NULL ENABLE, 
    CONTACT_NAME VARCHAR2(30),
    EMAIL_ADDRESS VARCHAR2(60),
    PHONE_NUMBER VARCHAR2(20),
    COMMENTS VARCHAR2(300),
    OBJ_ID VARCHAR2(36) DEFAULT SYS_GUID()  NOT NULL ENABLE,
    UPDATE_TIMESTAMP DATE NOT NULL ENABLE,
    UPDATE_USER VARCHAR2(10) NOT NULL ENABLE,
    )
/

CREATE TABLE FINANCIAL_ENTITY_ATTACHMENT
   (FINANCIAL_ENTITY_ATTACHMENT_ID NUMBER(12,0) NOT NULL, 
    FINANCIAL_ENTITY_ID_FK NUMBER(12,0) NOT NULL,
    FILE_ID NUMBER(12,0) NOT NULL,
    DESCRIPTION VARCHAR2(200) NOT NULL, 
    CONTACT_NAME VARCHAR2(30),
    EMAIL_ADDRESS VARCHAR2(60),
    PHONE_NUMBER VARCHAR2(20),
    COMMENTS VARCHAR2(300),
    OBJ_ID VARCHAR2(36) NOT NULL,
    UPDATE_TIMESTAMP DATE NOT NULL,
    UPDATE_USER VARCHAR2(10) NOT NULL
    )
/

Add ability to associate attachments to Financial Entities
KCCOI-90: Add ability to associate attachments to Financial Entities
