CREATE TABLE EmailIn (; Created_dt T ,; Ref_id I ,; Media C(7) ,; Type C(8) ,; Inout C(1) ,; Appcode C(10) ,; Subject C(80) ,; Sent_dt T ,; Fromaddr M ,; Textbody M ,; Htmlbody M ,; Attachment M ,; Toaddr M ,; Replyto M ,; Cc M ,; Bcc M ,; Fullmessag M ,; Created_by C(16) ,; Proc_stat C(3) ,; Proc_dt T ,; Proc_note M ,; Comment M ,; Rid I ; )