Examples of DeliveryNotePK

org.jallinone.warehouse.documents.java.DeliveryNotePK

Title: JAllInOne ERP/CRM application

Description: Primary key that identifies an in/out delivery note.

Copyright: Copyright (C) 2006 Mauro Carniel

This file is part of JAllInOne ERP/CRM application. This application is free software; you can redistribute it and/or modify it under the terms of the (LGPL) Lesser General Public License as published by the Free Software Foundation; GNU LESSER GENERAL PUBLIC LICENSE Version 2.1, February 1999 This application is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Library General Public License for more details. You should have received a copy of the GNU Library General Public License along with this library; if not, write to the Free Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. The author may be contacted at: maurocarniel@tin.it
@author Mauro Carniel @version 1.0

Examples of org.jallinone.warehouse.documents.java.DeliveryNotePK

          );
        }
        else if (docTypeDescr.equals(res.getResource("in delivery note"))) {
          new InDeliveryNoteController(
            null,
            new DeliveryNotePK(
              vo.getCompanyCodeSYS01(),
              vo.getDocType(),
              vo.getDocYear(),
              vo.getDocNumber()
            )
          );
        }
        else if (docTypeDescr.equals(res.getResource("out delivery note"))) {
          new OutDeliveryNoteController(
            null,
            new DeliveryNotePK(
              vo.getCompanyCodeSYS01(),
              vo.getDocType(),
              vo.getDocYear(),
              vo.getDocNumber()
            )

View Full Code Here

Examples of org.jallinone.warehouse.documents.java.DeliveryNotePK

   * @param persistentObject v.o. related to the selected row
   */
  public void doubleClick(int rowNumber,ValueObject persistentObject) {
    // create purchase order detail frame in READONLY mode...
    GridDeliveryNoteVO vo = (GridDeliveryNoteVO)persistentObject;
    DeliveryNotePK pk = new DeliveryNotePK(
        vo.getCompanyCodeSys01DOC08(),
        vo.getDocTypeDOC08(),
        vo.getDocYearDOC08(),
        vo.getDocNumberDOC08()
    );

View Full Code Here

Examples of org.jallinone.warehouse.documents.java.DeliveryNotePK

   * @param persistentObjects value objects to delete (related to the currently selected rows)
   * @return an ErrorResponse value object in case of errors, VOResponse if the operation is successfully completed
   */
  public Response deleteRecords(ArrayList persistentObjects) throws Exception {
    ArrayList pks = new ArrayList();
    DeliveryNotePK pk = null;
    GridDeliveryNoteVO vo = null;
    for(int i=0;i<persistentObjects.size();i++) {
      vo = (GridDeliveryNoteVO)persistentObjects.get(i);
      pk = new DeliveryNotePK(
          vo.getCompanyCodeSys01DOC08(),
          vo.getDocTypeDOC08(),
          vo.getDocYearDOC08(),
          vo.getDocNumberDOC08()
      );

View Full Code Here

Examples of org.jallinone.warehouse.documents.java.DeliveryNotePK

   * @param persistentObject v.o. related to the selected row
   */
  public void doubleClick(int rowNumber,ValueObject persistentObject) {
    // create purchase order detail frame in READONLY mode...
    GridDeliveryNoteVO vo = (GridDeliveryNoteVO)persistentObject;
    DeliveryNotePK pk = new DeliveryNotePK(
        vo.getCompanyCodeSys01DOC08(),
        vo.getDocTypeDOC08(),
        vo.getDocYearDOC08(),
        vo.getDocNumberDOC08()
    );

View Full Code Here

Examples of org.jallinone.warehouse.documents.java.DeliveryNotePK

   * @param persistentObjects value objects to delete (related to the currently selected rows)
   * @return an ErrorResponse value object in case of errors, VOResponse if the operation is successfully completed
   */
  public Response deleteRecords(ArrayList persistentObjects) throws Exception {
    ArrayList pks = new ArrayList();
    DeliveryNotePK pk = null;
    GridDeliveryNoteVO vo = null;
    for(int i=0;i<persistentObjects.size();i++) {
      vo = (GridDeliveryNoteVO)persistentObjects.get(i);
      pk = new DeliveryNotePK(
          vo.getCompanyCodeSys01DOC08(),
          vo.getDocTypeDOC08(),
          vo.getDocYearDOC08(),
          vo.getDocNumberDOC08()
      );

View Full Code Here

Examples of org.jallinone.warehouse.documents.java.DeliveryNotePK

      PreparedStatement pstmt = null;
      Connection conn = null;
      try {
        if (this.conn==null) conn = getConn(); else conn = this.conn;
        convBean.setConn(conn); // use same transaction...
        DeliveryNotePK pk = (DeliveryNotePK)pars.getOtherGridParams().get(ApplicationConsts.DELIVERY_NOTE_PK);


        String sql =
            "select DOC09_IN_DELIVERY_NOTE_ITEMS.PROGRESSIVE,DOC09_IN_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01,DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_TYPE,DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_YEAR,DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_NUMBER,"+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_TYPE_DOC06,DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_YEAR_DOC06,DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_NUMBER_DOC06,DOC09_IN_DELIVERY_NOTE_ITEMS.ROW_NUMBER,"+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.ITEM_CODE_ITM01,PUR02_SUPPLIER_ITEMS.SUPPLIER_ITEM_CODE,SYS10_COMPANY_TRANSLATIONS.DESCRIPTION,DOC09_IN_DELIVERY_NOTE_ITEMS.QTY,"+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.SUPPLIER_QTY,ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02,REG02_ALIAS1.DECIMALS,REG02_ALIAS2.DECIMALS,PUR02_SUPPLIER_ITEMS.UM_CODE_REG02,"+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.PROGRESSIVE_HIE02,DOC09_IN_DELIVERY_NOTE_ITEMS.PROGRESSIVE_HIE01,SYS10_LOC.DESCRIPTION,DOC08_DELIVERY_NOTES.WAREHOUSE_CODE_WAR01,ITM01_ITEMS.SERIAL_NUMBER_REQUIRED, "+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_SEQUENCE_DOC06,DOC09_IN_DELIVERY_NOTE_ITEMS.INVOICE_QTY, "+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM06,DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM11,"+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM07,DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM12,"+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM08,DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM13,"+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM09,DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM14,"+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM10,DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM15 "+
            " from DOC08_DELIVERY_NOTES,DOC09_IN_DELIVERY_NOTE_ITEMS,ITM01_ITEMS,SYS10_COMPANY_TRANSLATIONS,PUR02_SUPPLIER_ITEMS,REG02_MEASURE_UNITS REG02_ALIAS1,REG02_MEASURE_UNITS REG02_ALIAS2,SYS10_COMPANY_TRANSLATIONS SYS10_LOC where "+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01=ITM01_ITEMS.COMPANY_CODE_SYS01 and "+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.ITEM_CODE_ITM01=ITM01_ITEMS.ITEM_CODE and "+
            "ITM01_ITEMS.COMPANY_CODE_SYS01=SYS10_COMPANY_TRANSLATIONS.COMPANY_CODE_SYS01 and "+
            "ITM01_ITEMS.PROGRESSIVE_SYS10=SYS10_COMPANY_TRANSLATIONS.PROGRESSIVE and "+
            "SYS10_COMPANY_TRANSLATIONS.LANGUAGE_CODE=? and "+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.PROGRESSIVE_HIE01=SYS10_LOC.PROGRESSIVE and "+
            "SYS10_LOC.LANGUAGE_CODE=? and "+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01=DOC08_DELIVERY_NOTES.COMPANY_CODE_SYS01 and "+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_TYPE=DOC08_DELIVERY_NOTES.DOC_TYPE and "+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_YEAR=DOC08_DELIVERY_NOTES.DOC_YEAR and "+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_NUMBER=DOC08_DELIVERY_NOTES.DOC_NUMBER and "+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01=PUR02_SUPPLIER_ITEMS.COMPANY_CODE_SYS01 and "+
            "PUR02_SUPPLIER_ITEMS.PROGRESSIVE_REG04=DOC08_DELIVERY_NOTES.PROGRESSIVE_REG04 and "+
            "PUR02_SUPPLIER_ITEMS.ITEM_CODE_ITM01=DOC09_IN_DELIVERY_NOTE_ITEMS.ITEM_CODE_ITM01 and "+
            "PUR02_SUPPLIER_ITEMS.UM_CODE_REG02=REG02_ALIAS1.UM_CODE and "+
            "ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02=REG02_ALIAS2.UM_CODE and "+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01=? and "+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_TYPE=? and "+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_YEAR=? and "+
            "DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_NUMBER=? ";


        Map attribute2dbField = new HashMap();
        attribute2dbField.put("progressiveDOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.PROGRESSIVE");
        attribute2dbField.put("companyCodeSys01DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01");
        attribute2dbField.put("docTypeDOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_TYPE");
        attribute2dbField.put("docYearDOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_YEAR");
        attribute2dbField.put("docNumberDOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_NUMBER");
        attribute2dbField.put("docTypeDoc06DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_TYPE_DOC06");
        attribute2dbField.put("docYearDoc06DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_YEAR_DOC06");
        attribute2dbField.put("docNumberDoc06DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_NUMBER_DOC06");
        attribute2dbField.put("rowNumberDOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.ROW_NUMBER");
        attribute2dbField.put("itemCodeItm01DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.ITEM_CODE_ITM01");
        attribute2dbField.put("supplierItemCodePur02DOC09","PUR02_SUPPLIER_ITEMS.SUPPLIER_ITEM_CODE");
        attribute2dbField.put("descriptionSYS10","SYS10_COMPANY_TRANSLATIONS.DESCRIPTION");
        attribute2dbField.put("qtyDOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.QTY");
        attribute2dbField.put("supplierQtyDOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.SUPPLIER_QTY");
        attribute2dbField.put("umCodeREG02","ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02");
        attribute2dbField.put("decimalsREG02","REG02_ALIAS1.DECIMALS");
        attribute2dbField.put("supplierQtyDecimalsREG02","REG02_ALIAS2.DECIMALS");
        attribute2dbField.put("umCodeReg02PUR02","PUR02_SUPPLIER_ITEMS.UM_CODE_REG02");
        attribute2dbField.put("progressiveHie02DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.PROGRESSIVE_HIE02");
        attribute2dbField.put("progressiveHie01DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.PROGRESSIVE_HIE01");
        attribute2dbField.put("locationDescriptionSYS10","SYS10_LOC.DESCRIPTION");
        attribute2dbField.put("warehouseCodeWar01DOC08","DOC08_DELIVERY_NOTES.WAREHOUSE_CODE_WAR01");
        attribute2dbField.put("serialNumberRequiredITM01","ITM01_ITEMS.SERIAL_NUMBER_REQUIRED");
        attribute2dbField.put("docSequenceDoc06DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.DOC_SEQUENCE_DOC06");
        attribute2dbField.put("invoiceQtyDOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.INVOICE_QTY");


        attribute2dbField.put("variantTypeItm06DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM06");
        attribute2dbField.put("variantCodeItm11DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM11");
        attribute2dbField.put("variantTypeItm07DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM07");
        attribute2dbField.put("variantCodeItm12DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM12");
        attribute2dbField.put("variantTypeItm08DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM08");
        attribute2dbField.put("variantCodeItm13DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM13");
        attribute2dbField.put("variantTypeItm09DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM09");
        attribute2dbField.put("variantCodeItm14DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM14");
        attribute2dbField.put("variantTypeItm10DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM10");
        attribute2dbField.put("variantCodeItm15DOC09","DOC09_IN_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM15");


        ArrayList values = new ArrayList();
        values.add(serverLanguageId);
        values.add(serverLanguageId);
        values.add(pk.getCompanyCodeSys01DOC08());
        values.add(pk.getDocTypeDOC08());
        values.add(pk.getDocYearDOC08());
        values.add(pk.getDocNumberDOC08());


        int blockSize = 50;
        if (pars.getOtherGridParams().get(ApplicationConsts.BLOCK_SIZE)!=null)
          blockSize = Integer.parseInt(pars.getOtherGridParams().get(ApplicationConsts.BLOCK_SIZE).toString());

View Full Code Here

Examples of org.jallinone.warehouse.documents.java.DeliveryNotePK

      PreparedStatement pstmt = null;
      Connection conn = null;
      try {
        if (this.conn==null) conn = getConn(); else conn = this.conn;


        DeliveryNotePK pk = (DeliveryNotePK)pars.getOtherGridParams().get(ApplicationConsts.DELIVERY_NOTE_PK);


        String sql =
            "select DOC10_OUT_DELIVERY_NOTE_ITEMS.PROGRESSIVE,DOC10_OUT_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01,DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_TYPE,"+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_YEAR,DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_NUMBER,"+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_TYPE_DOC01,DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_YEAR_DOC01,"+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_NUMBER_DOC01,DOC10_OUT_DELIVERY_NOTE_ITEMS.ROW_NUMBER,"+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.ITEM_CODE_ITM01,SYS10_COMPANY_TRANSLATIONS.DESCRIPTION,DOC10_OUT_DELIVERY_NOTE_ITEMS.QTY,"+
            "ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02,REG02_ALIAS1.DECIMALS,DOC10_OUT_DELIVERY_NOTE_ITEMS.PROGRESSIVE_HIE02,"+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.PROGRESSIVE_HIE01,SYS10_LOC.DESCRIPTION,DOC08_DELIVERY_NOTES.WAREHOUSE_CODE_WAR01,ITM01_ITEMS.SERIAL_NUMBER_REQUIRED, "+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_SEQUENCE_DOC01,DOC10_OUT_DELIVERY_NOTE_ITEMS.INVOICE_QTY, "+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM06,DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM11,"+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM07,DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM12,"+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM08,DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM13,"+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM09,DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM14,"+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM10,DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM15 "+
            " from DOC08_DELIVERY_NOTES,DOC10_OUT_DELIVERY_NOTE_ITEMS,ITM01_ITEMS,SYS10_COMPANY_TRANSLATIONS,REG02_MEASURE_UNITS REG02_ALIAS1,SYS10_COMPANY_TRANSLATIONS SYS10_LOC where "+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01=ITM01_ITEMS.COMPANY_CODE_SYS01 and "+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.ITEM_CODE_ITM01=ITM01_ITEMS.ITEM_CODE and "+
            "ITM01_ITEMS.COMPANY_CODE_SYS01=SYS10_COMPANY_TRANSLATIONS.COMPANY_CODE_SYS01 and "+
            "ITM01_ITEMS.PROGRESSIVE_SYS10=SYS10_COMPANY_TRANSLATIONS.PROGRESSIVE and "+
            "SYS10_COMPANY_TRANSLATIONS.LANGUAGE_CODE=? and "+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01=SYS10_LOC.COMPANY_CODE_SYS01 and "+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.PROGRESSIVE_HIE01=SYS10_LOC.PROGRESSIVE and "+
            "SYS10_LOC.LANGUAGE_CODE=? and "+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01=DOC08_DELIVERY_NOTES.COMPANY_CODE_SYS01 and "+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_TYPE=DOC08_DELIVERY_NOTES.DOC_TYPE and "+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_YEAR=DOC08_DELIVERY_NOTES.DOC_YEAR and "+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_NUMBER=DOC08_DELIVERY_NOTES.DOC_NUMBER and "+
            "ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02=REG02_ALIAS1.UM_CODE and "+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01=? and "+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_TYPE=? and "+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_YEAR=? and "+
            "DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_NUMBER=? ";


        Map attribute2dbField = new HashMap();
        attribute2dbField.put("progressiveDOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.PROGRESSIVE");
        attribute2dbField.put("companyCodeSys01DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01");
        attribute2dbField.put("docTypeDOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_TYPE");
        attribute2dbField.put("docYearDOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_YEAR");
        attribute2dbField.put("docNumberDOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_NUMBER");
        attribute2dbField.put("docTypeDoc01DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_TYPE_DOC01");
        attribute2dbField.put("docYearDoc01DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_YEAR_DOC01");
        attribute2dbField.put("docNumberDoc01DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_NUMBER_DOC01");
        attribute2dbField.put("rowNumberDOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.ROW_NUMBER");
        attribute2dbField.put("itemCodeItm01DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.ITEM_CODE_ITM01");
        attribute2dbField.put("descriptionSYS10","SYS10_COMPANY_TRANSLATIONS.DESCRIPTION");
        attribute2dbField.put("qtyDOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.QTY");
        attribute2dbField.put("umCodeREG02","ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02");
        attribute2dbField.put("decimalsREG02","REG02_ALIAS1.DECIMALS");
        attribute2dbField.put("progressiveHie02DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.PROGRESSIVE_HIE02");
        attribute2dbField.put("progressiveHie01DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.PROGRESSIVE_HIE01");
        attribute2dbField.put("locationDescriptionSYS10","SYS10_LOC.DESCRIPTION");
        attribute2dbField.put("warehouseCodeWar01DOC08","DOC08_DELIVERY_NOTES.WAREHOUSE_CODE_WAR01");
        attribute2dbField.put("serialNumberRequiredITM01","ITM01_ITEMS.SERIAL_NUMBER_REQUIRED");
        attribute2dbField.put("docSequenceDoc01DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_SEQUENCE_DOC01");
        attribute2dbField.put("invoiceQtyDOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.INVOICE_QTY");


        attribute2dbField.put("variantTypeItm06DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM06");
        attribute2dbField.put("variantCodeItm11DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM11");
        attribute2dbField.put("variantTypeItm07DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM07");
        attribute2dbField.put("variantCodeItm12DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM12");
        attribute2dbField.put("variantTypeItm08DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM08");
        attribute2dbField.put("variantCodeItm13DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM13");
        attribute2dbField.put("variantTypeItm09DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM09");
        attribute2dbField.put("variantCodeItm14DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM14");
        attribute2dbField.put("variantTypeItm10DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_TYPE_ITM10");
        attribute2dbField.put("variantCodeItm15DOC10","DOC10_OUT_DELIVERY_NOTE_ITEMS.VARIANT_CODE_ITM15");


        ArrayList values = new ArrayList();
        values.add(serverLanguageId);
        values.add(serverLanguageId);
        values.add(pk.getCompanyCodeSys01DOC08());
        values.add(pk.getDocTypeDOC08());
        values.add(pk.getDocYearDOC08());
        values.add(pk.getDocNumberDOC08());


        int blockSize = 50;
        if (pars.getOtherGridParams().get(ApplicationConsts.BLOCK_SIZE)!=null)
          blockSize = Integer.parseInt(pars.getOtherGridParams().get(ApplicationConsts.BLOCK_SIZE).toString());

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.