code: @Override
    public final List<WarehouseSiteRestLine> retrieveWarehouseSiteRests(
      final Map<String, Object> pAddParam) throws Exception {
      List<WarehouseSiteRestLine> result = new ArrayList<WarehouseSiteRestLine>();
      if (this.queryMain == null) {
        String flName = "/" + "accounting" + "/"
          + "warehouse" + "/" + "rests-in-sites.sql";
        this.queryMain = loadString(flName);
      }
      IRecordSet<RS> recordSet = null;
      try {
        recordSet = getSrvDatabase().retrieveRecords(this.queryMain);
        if (recordSet.moveToFirst()) {
          do {
            WarehouseSiteRestLine wrl = new WarehouseSiteRestLine();
            wrl.setWarehouse(recordSet.getString("WAREHOUSE"));
            wrl.setWarehouseSite(recordSet.getString("WAREHOUSESITE"));
            wrl.setInvItemId(recordSet.getLong("INVITEMID"));
            wrl.setInvItem(recordSet.getString("INVITEM"));
            wrl.setUnitOfMeasure(recordSet.getString("UNITOFMEASURE"));
            wrl.setTheRest(BigDecimal
                .valueOf(recordSet.getDouble("THEREST")));
            result.add(wrl);
          } while (recordSet.moveToNext());
        }
      } finally {
        if (recordSet != null) {
          recordSet.close();
        }
      }
      return result;
    }
docs: <p>Retrieve Trial Balance.</p>
  @param pAddParam additional param
  @param pDate date
  @throws Exception - an exception