Author: jpepin Date: 2010-08-20 01:48:02 +0200 (Fri, 20 Aug 2010) New Revision: 3008 Url: http://chorem.org/repositories/revision/lima/3008 Log: Fen?\195?\170tre d'import/export est d?\195?\169sormais modal Optimisation import/export : remont?\195?\169 des exception ?\195?\160 l'utilisateur Remise en marche du jaxx configbuilder Modified: trunk/lima-swing/src/main/java/org/chorem/lima/ui/MainView.jaxx trunk/lima-swing/src/main/java/org/chorem/lima/ui/MainViewHandler.java trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransaction/FinancialTransactionTable.java trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransaction/FinancialTransactionTableModel.java trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransactionsearch/FinancialTransactionSearchTableModel.java trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransactionunbalanced/FinancialTransactionUnbalancedTableModel.java trunk/lima-swing/src/main/java/org/chorem/lima/ui/importexport/ImportExport.java trunk/lima-swing/src/main/java/org/chorem/lima/ui/importexport/ImportExportWaitView.jaxx trunk/lima-swing/src/main/java/org/chorem/lima/ui/opening/OpeningView.jaxx trunk/lima-swing/src/main/java/org/chorem/lima/ui/opening/OpeningViewHandler.java trunk/lima-swing/src/main/resources/i18n/lima-swing-en_GB.properties trunk/lima-swing/src/main/resources/i18n/lima-swing-fr_FR.properties Modified: trunk/lima-swing/src/main/java/org/chorem/lima/ui/MainView.jaxx =================================================================== --- trunk/lima-swing/src/main/java/org/chorem/lima/ui/MainView.jaxx 2010-08-19 21:13:17 UTC (rev 3007) +++ trunk/lima-swing/src/main/java/org/chorem/lima/ui/MainView.jaxx 2010-08-19 23:48:02 UTC (rev 3008) @@ -159,16 +159,11 @@ actionIcon='entries-unbalanced'/> <JMenuItem text="lima.entries.searchtransaction" onActionPerformed='getHandler().showTransactionSearchView(this)' actionIcon='entries-search'/> - <JMenuItem text="lima.entries.lettering" onActionPerformed='getHandler().showLetteringView(this)' + <!-- Menu prévu pour le lettrage automatique + <JMenuItem text="lima.entries.lettering" onActionPerformed='getHandler().showLetteringView(this)' actionIcon='lettering'/> + --> </JMenu> - <!-- - <JMenu text="lima.view"> - <JCheckBoxMenuItem id="viewFlatten" text="lima.view.flatten" - onItemStateChanged='getHandler().onChangeView(this)' - selected="false" actionIcon='view'/> - </JMenu> - --> <JMenu text="lima.reports" mnemonic="{'R'}"> <JMenuItem text="lima.reports.accounts" onActionPerformed='getHandler().showAccountReports(this)' actionIcon='reports-account'/> @@ -225,12 +220,7 @@ </JMenu> </JMenuBar> <JPanel layout='{new BorderLayout()}'> - <JTabbedPane id="contentTabbedPane" constraints="BorderLayout.CENTER"/> - - <!-- class not found <jaxx.runtime.swing.StatusMessagePanel id='statusBar' - _help='"ui.main.statusBar"' - constraints="BorderLayout.SOUTH"/> --> </JPanel> </JFrame> Modified: trunk/lima-swing/src/main/java/org/chorem/lima/ui/MainViewHandler.java =================================================================== --- trunk/lima-swing/src/main/java/org/chorem/lima/ui/MainViewHandler.java 2010-08-19 21:13:17 UTC (rev 3007) +++ trunk/lima-swing/src/main/java/org/chorem/lima/ui/MainViewHandler.java 2010-08-19 23:48:02 UTC (rev 3008) @@ -24,9 +24,7 @@ import java.util.Locale; import jaxx.runtime.JAXXContext; import jaxx.runtime.swing.AboutPanel; -import jaxx.runtime.swing.editor.config.ConfigUI; -import jaxx.runtime.swing.editor.config.ConfigUIBuilder; -import jaxx.runtime.swing.editor.config.model.ConfigUIModel; +import jaxx.runtime.swing.editor.config.ConfigUIHelper; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.chorem.lima.LimaConfig; @@ -151,27 +149,19 @@ public void showConfig(JAXXContext context) { MainView ui = getUI(context); LimaConfig config = context.getContextValue(LimaConfig.class); - ConfigUIModel model = new ConfigUIModel(config); - //TODO pepin 20100510 methode deprecate - /* - // categorie repertoires - model.addCategory( - n_("lima.config.category.directories"), - n_("lima.config.category.directories.description"), - LimaConfig.Option.CONFIG_FILE); + //TODO pepin 2010-08-20 add all options - // others - model.addCategory( - n_("lima.config.category.other"), - n_("lima.config.category.other.description"), - LimaConfig.Option.FULL_SCREEN, - LimaConfig.Option.LOCALE); - */ - - ConfigUI configUI = ConfigUIBuilder.newConfigUI(context, model, "lima.config.category.directories"); - - ConfigUIBuilder.showConfigUI(configUI, ui, false); + ConfigUIHelper helper = new ConfigUIHelper(config); + helper.addCategory(_("lima.config.category.directories"), _("lima.config.category.directories.description")); + helper.addOption(LimaConfig.Option.CONFIG_FILE); + + helper.addCategory(_("lima.config.category.other"), _("lima.config.category.other.description")); + helper.addOption(LimaConfig.Option.FULL_SCREEN); + helper.addOption(LimaConfig.Option.LOCALE); + + helper.buildUI(context, _("lima.config.category.directories")); + helper.displayUI(ui, false); } public void showHelp(JAXXContext context, String helpId) { @@ -410,31 +400,4 @@ ImportExport importExport = ImportExport.getInstance(mainView); importExport.importExport(type, "", true); } - - public void showExportView(String type) { - - /*if (!getExportView(type).isEnabled()) { - getExportView(type).setEnabled(true); - }*/ - } - - public void showLetteringView(JAXXContext rootContext) { - MainView mainView = getUI(rootContext); - // LetteringView letteringView = new LetteringView(mainView); - // mainView.showTab(_("lima.entries.lettering"), letteringView); - } - - public void showSearchView(JAXXContext rootContext) { - /*if (!getSearchView().isEnabled()) { - getSearchView().setEnabled(true); - } - getSearchView().setVisible(true);*/ - } - - public void showResultView(JAXXContext rootContext) { - MainView mainView = getUI(rootContext); - //ResultView resultView = new ResultView(mainView); - // mainView.showTab(_("lima.tab.result"), resultView); - } - } Modified: trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransaction/FinancialTransactionTable.java =================================================================== --- trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransaction/FinancialTransactionTable.java 2010-08-19 21:13:17 UTC (rev 3007) +++ trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransaction/FinancialTransactionTable.java 2010-08-19 23:48:02 UTC (rev 3008) @@ -29,6 +29,8 @@ import java.math.BigDecimal; import java.util.Date; +import javax.swing.table.TableColumn; + import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.chorem.lima.entity.Account; @@ -68,7 +70,7 @@ public FinancialTransactionTable(FinancialTransactionViewHandler handler) { this.handler = handler; - + addKeyListener(this); //Get new date editor @@ -83,7 +85,7 @@ // highlight unbalanced financial transactions addColorNonBalancedTransaction(); } - + /** * Cette méthode permet de colorer toutes les transactions dans le tableau * afin de bien distinguer les transactions et entrées comptables. Modified: trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransaction/FinancialTransactionTableModel.java =================================================================== --- trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransaction/FinancialTransactionTableModel.java 2010-08-19 21:13:17 UTC (rev 3007) +++ trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransaction/FinancialTransactionTableModel.java 2010-08-19 23:48:02 UTC (rev 3008) @@ -159,7 +159,7 @@ result = String.class; break; case 5: - result = String.class; + result = BigDecimal.class; break; case 6: result = BigDecimal.class; @@ -168,13 +168,15 @@ result = BigDecimal.class; break; case 8: - result = BigDecimal.class; + result = String.class; break; } return result; } + + @Override public String getColumnName(int column) { String result = "n/a"; @@ -196,16 +198,16 @@ result = _("lima.table.description"); break; case 5: - result = _("lima.table.position"); + result = _("lima.table.debit"); break; case 6: - result = _("lima.table.debit"); + result = _("lima.table.credit"); break; case 7: - result = _("lima.table.credit"); + result = _("lima.table.balance"); break; case 8: - result = _("lima.table.balance"); + result = _("lima.table.letter"); break; } @@ -258,16 +260,16 @@ result = null; // description break; case 5 : - result = null; // position + result = amountDebit; break; case 6: - result = amountDebit; + result = amountCredit; break; case 7: - result = amountCredit; + result = amountDebit.subtract(amountCredit); break; case 8: - result = amountDebit.subtract(amountCredit); + result = null; break; } } @@ -295,16 +297,16 @@ result = currentEntry.getDescription(); break; case 5 : - result = currentEntry.getPosition(); + result = currentEntry.getDebit() ? currentEntry.getAmount() : 0; break; case 6: - result = currentEntry.getDebit() ? currentEntry.getAmount() : 0; + result = currentEntry.getDebit() ? 0 : currentEntry.getAmount(); break; case 7: - result = currentEntry.getDebit() ? 0 : currentEntry.getAmount(); + result = null; break; case 8: - result = null; // balance + result = currentEntry.getLettering(); break; } @@ -327,11 +329,11 @@ boolean editableCell=false; Object currentRow = cacheDataList.get(rowIndex); // cells editable for the entry row, all cells exclude the date - if ((currentRow instanceof Entry) && !((columnIndex==0) || (columnIndex==1) || (columnIndex==8))) { + if ((currentRow instanceof Entry) && !((columnIndex==0) || (columnIndex==1))) { editableCell=true; } // cells editable for the financialtransaction row, no cells exclude the date - if ((currentRow instanceof FinancialTransaction) && ((columnIndex==0) || (columnIndex==1))){ + if ((currentRow instanceof FinancialTransaction) && ((columnIndex==0) || (columnIndex==1) || (columnIndex==8))){ editableCell=true; } return editableCell; @@ -492,16 +494,16 @@ currentEntry.setDescription((String)value); break; case 5 : - currentEntry.setPosition((String)value); - break; - case 6: currentEntry.setAmount((BigDecimal)value); currentEntry.setDebit(true); break; - case 7: - currentEntry.setAmount((BigDecimal)value); + case 6: + currentEntry.setAmount((BigDecimal)value); currentEntry.setDebit(false); break; + case 8: + currentEntry.setLettering((String)value); + break; } try { financialTransactionService.updateEntry(currentEntry); Modified: trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransactionsearch/FinancialTransactionSearchTableModel.java =================================================================== --- trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransactionsearch/FinancialTransactionSearchTableModel.java 2010-08-19 21:13:17 UTC (rev 3007) +++ trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransactionsearch/FinancialTransactionSearchTableModel.java 2010-08-19 23:48:02 UTC (rev 3008) @@ -58,6 +58,7 @@ * By : $Author: jpepin $ */ public class FinancialTransactionSearchTableModel extends AbstractTableModel { + /** serialVersionUID. */ private static final long serialVersionUID = 3914954536809622358L; @@ -69,7 +70,6 @@ /** data cache */ protected List<Entry> cacheDataList; - public void refresh(List<Entry> objects){ cacheDataList = objects; @@ -103,7 +103,7 @@ result = String.class; break; case 5: - result = String.class; + result = BigDecimal.class; break; case 6: result = BigDecimal.class; @@ -112,7 +112,7 @@ result = BigDecimal.class; break; case 8: - result = BigDecimal.class; + result = String.class; break; } @@ -140,16 +140,16 @@ result = _("lima.table.description"); break; case 5: - result = _("lima.table.position"); + result = _("lima.table.debit"); break; case 6: - result = _("lima.table.debit"); + result = _("lima.table.credit"); break; case 7: - result = _("lima.table.credit"); + result = _("lima.table.balance"); break; case 8: - result = _("lima.table.balance"); + result = _("lima.table.letter"); break; } @@ -206,16 +206,16 @@ result = currentRow.getDescription(); break; case 5 : - result = currentRow.getPosition(); + result = currentRow.getDebit() ? currentRow.getAmount() : 0; break; case 6: - result = currentRow.getDebit() ? currentRow.getAmount() : 0; + result = currentRow.getDebit() ? 0 : currentRow.getAmount(); break; case 7: - result = currentRow.getDebit() ? 0 : currentRow.getAmount(); + result = null; // balance break; case 8: - result = null; // balance + result = currentRow.getLettering(); break; } @@ -225,104 +225,12 @@ } - /** - * To set cells editable or not - * different condition for entry or financial transaction - */ @Override public boolean isCellEditable(int rowIndex, int columnIndex) { - boolean editableCell=false; - Object currentRow = cacheDataList.get(rowIndex); - // cells editable for the entry row, all cells exclude the date - if ((currentRow instanceof Entry) && !((columnIndex==0) || (columnIndex==1))) { - editableCell=true; - } - // cells editable for the financialtransaction row, no cells exclude the date - if ((currentRow instanceof FinancialTransaction) && ((columnIndex==0) || (columnIndex==1))){ - editableCell=true; - } - return editableCell; + + return false; } - - /* /** - * to modifiy financialtransaction or entry - * - @Override - public void setValueAt(Object value, int row, int column) { - int financialTransactionRow=0; - // just prevent too much result - if (selectedFiscalPeriod != null) { - Object currentRow = cacheDataList.get(row); - if (currentRow instanceof FinancialTransaction) { - FinancialTransaction currentFinancialTransaction = - (FinancialTransaction)currentRow; - switch (column) { - case 0: - //update - currentFinancialTransaction.setTransactionDate((Date)value); - break; - case 1 : - currentFinancialTransaction.setEntryBook((EntryBook)value); - break; - } - // notify service for modification - try { - financialTransactionService. - updateFinancialTransaction(currentFinancialTransaction); - } catch (LimaException eee) { - if (log.isDebugEnabled()){ - log.debug("Can't update financial transaction", eee); - } - DialogHelper.showMessageDialog(eee.getMessage()); - } - //update the financial transaction in entire - financialTransactionRow = - cacheDataList.indexOf(((FinancialTransaction) currentRow)); - } - else if (currentRow instanceof Entry) { - Entry currentEntry = (Entry)currentRow; - switch (column) { - case 2 : - currentEntry.setVoucher((String)value); - break; - case 3: - currentEntry.setAccount((Account)value); - break; - case 4: - currentEntry.setDescription((String)value); - break; - case 5 : - currentEntry.setPosition((String)value); - break; - case 6: - currentEntry.setAmount((BigDecimal)value); - currentEntry.setDebit(true); - break; - case 7: - currentEntry.setAmount((BigDecimal)value); - currentEntry.setDebit(false); - break; - } - try { - financialTransactionService.updateEntry(currentEntry); - } catch (LimaException eee) { - if (log.isDebugEnabled()){ - log.debug("Can't update entry", eee); - } - DialogHelper.showMessageDialog(eee.getMessage()); - } - //update the financial transaction in entire - financialTransactionRow = - cacheDataList.indexOf(((Entry) currentRow). - getFinancialTransaction()); - } - //on recharge la liste - //TODO PEPIN 20100607 Get financial transaction of cachedatelist on replace it - fireTableRowsUpdated(financialTransactionRow, getRowCount()-1); - } - }*/ - public Object getElementAt(int row){ Object currentRow = cacheDataList.get(row); Modified: trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransactionunbalanced/FinancialTransactionUnbalancedTableModel.java =================================================================== --- trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransactionunbalanced/FinancialTransactionUnbalancedTableModel.java 2010-08-19 21:13:17 UTC (rev 3007) +++ trunk/lima-swing/src/main/java/org/chorem/lima/ui/financialtransactionunbalanced/FinancialTransactionUnbalancedTableModel.java 2010-08-19 23:48:02 UTC (rev 3008) @@ -153,7 +153,7 @@ result = String.class; break; case 5: - result = String.class; + result = BigDecimal.class; break; case 6: result = BigDecimal.class; @@ -162,7 +162,7 @@ result = BigDecimal.class; break; case 8: - result = BigDecimal.class; + result = String.class; break; } @@ -190,16 +190,16 @@ result = _("lima.table.description"); break; case 5: - result = _("lima.table.position"); + result = _("lima.table.debit"); break; case 6: - result = _("lima.table.debit"); + result = _("lima.table.credit"); break; case 7: - result = _("lima.table.credit"); + result = _("lima.table.balance"); break; case 8: - result = _("lima.table.balance"); + result = _("lima.table.letter"); break; } @@ -253,16 +253,16 @@ result = null; // description break; case 5 : - result = null; // position + result = amountDebit; break; case 6: - result = amountDebit; + result = amountCredit; break; case 7: - result = amountCredit; + result = amountDebit.subtract(amountCredit); break; case 8: - result = amountDebit.subtract(amountCredit); + result = null; break; } } @@ -290,16 +290,16 @@ result = currentEntry.getDescription(); break; case 5 : - result = currentEntry.getPosition(); + result = currentEntry.getDebit() ? currentEntry.getAmount() : 0; break; case 6: - result = currentEntry.getDebit() ? currentEntry.getAmount() : 0; + result = currentEntry.getDebit() ? 0 : currentEntry.getAmount(); break; case 7: - result = currentEntry.getDebit() ? 0 : currentEntry.getAmount(); + result = null; break; case 8: - result = null; // balance + result = currentEntry.getLettering(); break; } @@ -405,16 +405,16 @@ currentEntry.setDescription((String)value); break; case 5 : - currentEntry.setPosition((String)value); - break; - case 6: currentEntry.setAmount((BigDecimal)value); currentEntry.setDebit(true); break; - case 7: - currentEntry.setAmount((BigDecimal)value); + case 6: + currentEntry.setAmount((BigDecimal)value); currentEntry.setDebit(false); break; + case 8: + currentEntry.setLettering((String)value); + break; } try { financialTransactionService.updateEntry(currentEntry); Modified: trunk/lima-swing/src/main/java/org/chorem/lima/ui/importexport/ImportExport.java =================================================================== --- trunk/lima-swing/src/main/java/org/chorem/lima/ui/importexport/ImportExport.java 2010-08-19 21:13:17 UTC (rev 3007) +++ trunk/lima-swing/src/main/java/org/chorem/lima/ui/importexport/ImportExport.java 2010-08-19 23:48:02 UTC (rev 3008) @@ -181,9 +181,7 @@ log.debug("Can't get result message", eeeIE); } } catch (ExecutionException eeeEE) { - if (log.isDebugEnabled()){ - log.debug("Can't get result message", eeeEE); - } + DialogHelper.showMessageDialog(eeeEE.getMessage()); } } }.execute(); Modified: trunk/lima-swing/src/main/java/org/chorem/lima/ui/importexport/ImportExportWaitView.jaxx =================================================================== --- trunk/lima-swing/src/main/java/org/chorem/lima/ui/importexport/ImportExportWaitView.jaxx 2010-08-19 21:13:17 UTC (rev 3007) +++ trunk/lima-swing/src/main/java/org/chorem/lima/ui/importexport/ImportExportWaitView.jaxx 2010-08-19 23:48:02 UTC (rev 3008) @@ -15,7 +15,7 @@ Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. ##% --> -<JDialog id="waitDialog"> +<JDialog modal="true" id="waitDialog"> <script> <![CDATA[ Modified: trunk/lima-swing/src/main/java/org/chorem/lima/ui/opening/OpeningView.jaxx =================================================================== --- trunk/lima-swing/src/main/java/org/chorem/lima/ui/opening/OpeningView.jaxx 2010-08-19 21:13:17 UTC (rev 3007) +++ trunk/lima-swing/src/main/java/org/chorem/lima/ui/opening/OpeningView.jaxx 2010-08-19 23:48:02 UTC (rev 3008) @@ -41,6 +41,7 @@ <cell weightx="0.9" rows="4" fill="both"> <JPanel id='panel'> <JLabel text='lima.opening.welcome' /> + <JButton text='lima.opening.import' onActionPerformed="handler.importSave()"/> </JPanel> </cell> </row> Modified: trunk/lima-swing/src/main/java/org/chorem/lima/ui/opening/OpeningViewHandler.java =================================================================== --- trunk/lima-swing/src/main/java/org/chorem/lima/ui/opening/OpeningViewHandler.java 2010-08-19 21:13:17 UTC (rev 3007) +++ trunk/lima-swing/src/main/java/org/chorem/lima/ui/opening/OpeningViewHandler.java 2010-08-19 23:48:02 UTC (rev 3008) @@ -63,6 +63,13 @@ step = 0; } + + public void importSave(){ + ImportExport importExport = new ImportExport(view); + importExport.importExport(ImportExportEnum.CSV_ALL_IMPORT, "", true); + view.dispose(); + } + public void next(){ ImportExport importExport = ImportExport.getInstance(view); JPanel panel = view.getPanel(); Modified: trunk/lima-swing/src/main/resources/i18n/lima-swing-en_GB.properties =================================================================== --- trunk/lima-swing/src/main/resources/i18n/lima-swing-en_GB.properties 2010-08-19 21:13:17 UTC (rev 3007) +++ trunk/lima-swing/src/main/resources/i18n/lima-swing-en_GB.properties 2010-08-19 23:48:02 UTC (rev 3008) @@ -195,6 +195,7 @@ lima.openejb.remotemode.description= lima.opening.accounts= lima.opening.entrybook= +lima.opening.import= lima.opening.welcome= lima.pdf= lima.period.begindate= @@ -240,6 +241,7 @@ lima.table.grossamount= lima.table.label= lima.table.letter= +lima.table.lettering= lima.table.move.credit= lima.table.move.debit= lima.table.netamount= Modified: trunk/lima-swing/src/main/resources/i18n/lima-swing-fr_FR.properties =================================================================== --- trunk/lima-swing/src/main/resources/i18n/lima-swing-fr_FR.properties 2010-08-19 21:13:17 UTC (rev 3007) +++ trunk/lima-swing/src/main/resources/i18n/lima-swing-fr_FR.properties 2010-08-19 23:48:02 UTC (rev 3008) @@ -181,7 +181,8 @@ lima.openejb.remotemode.description= lima.opening.accounts=<html><center>Aucun plan comptable charg\u00E9<br/>Veuillez s\u00E9lectionner un plan par d\u00E9fault, <br/>importer un plan personnalis\u00E9<br/> ou annuler pour cr\u00E9er votre propre plan.</center></html> lima.opening.entrybook=<html>Cochez la case pour importer les journaux par d\u00E9faut \:<br/> Achats, Ventes, Tr\u00E9sorerie, Op\u00E9ration diverses</html> -lima.opening.welcome=<html><center>Bienvenue dans Lima<br/>Laissez vous guider par cet assistant pour d\u00E9marrer votre comptabilit\u00E9 en quelques instants\u0085</center></html> +lima.opening.import=Importer une sauvegarde CSV +lima.opening.welcome=<html><center>Bienvenue dans Lima<br/>Laissez vous guider par cet assistant pour d\u00E9marrer votre comptabilit\u00E9 en quelques instants\u0085<br/>Ou bien importer directement une ancienne sauvegarde de LIMA au format CSV<br/><br/><br/><br/></center></html> lima.pdf= lima.period.begindate=D\u00E9but lima.period.create=Choisissez la date de d\u00E9but et de fin du nouvel exercice @@ -226,6 +227,7 @@ lima.table.grossamount=Brut lima.table.label=Libell\u00E9 lima.table.letter=Lettre +lima.table.lettering= lima.table.move.credit=Mouvement au cr\u00E9dit lima.table.move.debit=Mouvement au d\u00E9bit lima.table.netamount=Net