Dong Shin 12.19.2013

  • deployed FinancialAssistant.jar, FA, RA,Req – all is well
  • discussed hot to handle multiple Commitments for a Requisition with Lenny
  • working on FA
    • added Financial Data datagrid to Requisition Editor
    • working on adding Committed Amount and Date to the Requisition Editor
    • added committed_amounts table to the database – DBUpdateEnhancements.sql
    • created CommittedAmount.as and CommittedAmountsTable.as for DB access
      • CREATE TABLE IF NOT EXISTS `committed_amounts` (
        `uid` int(11) NOT NULL AUTO_INCREMENT,
        `budget_center_id` int(11) NOT NULL,
        `committed_amount` decimal(10,2) NOT NULL,
        `committed_date` date NOT NULL,
        PRIMARY KEY (`uid`),
        KEY `budget_center_id` (`budget_center_id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;