if (recordSet.moveToFirst()) { do { String accName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ITSNAME"); String accId = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ACCID"); Long subaccId = getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "SUBACCID"); Integer subaccType = getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "SUBACCTYPE"); String accNumber = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ITSNUMBER"); String subaccName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "SUBACC"); Double debit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "DEBIT"); Double credit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "CREDIT"); TrialBalanceLine tbl = new TrialBalanceLine();
do { WarehouseSiteRestLine wrl = new WarehouseSiteRestLine(); wrl.setWarehouse(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "WAREHOUSE")); wrl.setWarehouseSite(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "WAREHOUSESITE")); wrl.setInvItemId(getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "INVITEMID")); wrl.setInvItem(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "INVITEM")); wrl.setUnitOfMeasure(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "UNITOFMEASURE")); wrl.setTheRest(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "THEREST")); result.add(wrl);
do { WarehouseRestLine wrl = new WarehouseRestLine(); wrl.setWarehouse(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "WAREHOUSE")); wrl.setInvItemId(getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "INVITEMID")); wrl.setInvItem(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "INVITEM")); wrl.setUnitOfMeasure(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "UNITOFMEASURE")); wrl.setTheRest(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "THEREST")); result.add(wrl);
if (recordSet.moveToFirst()) { do { String accName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ITSNAME"); String accId = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ACCID"); Long subaccId = getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "SUBACCID"); Integer subaccType = getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "SUBACCTYPE"); String accNumber = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ITSNUMBER"); String subaccName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "SUBACC"); Double debit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "DEBIT"); Double credit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "CREDIT"); if (debit != 0 || credit != 0) {
if (recordSet.moveToFirst()) { do { Long sourceId = getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "SOURCEID"); Integer sourceType = getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "SOURCETYPE"); Long sourceOwnerId = getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "SOURCEOWNERID"); Integer sourceOwnerType = getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "SOURCEOWNERTYPE"); BigDecimal theRest = getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "THEREST"); T source = createDrawItemEntry();
accEntry.setIdDatabaseBirth(getSrvDatabase().getIdDatabase()); if (itsDateLong == null) { itsDateLong = getSrvDatabase().getSrvRecordRetriever() .getDate(recordSet.getRecordSet(), "ITSDATE").getTime(); getSrvBalance().handleNewAccountEntry(null, null, String accDebitId = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ACCDEBIT"); Account accDebit = new Account(); accDebit.setItsId(accDebitId); accEntry.setAccDebit(accDebit); accEntry.setSubaccDebitType(getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "SUBACCDEBITTYPE")); accEntry.setSubaccDebitId(getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "SUBACCDEBITID")); accEntry.setSubaccDebit(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "SUBACCDEBIT")); accEntry.setDebit(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "DEBIT").setScale( getSrvAccSettings().lazyGetAccSettings().getCostPrecision(), getSrvAccSettings().lazyGetAccSettings().getRoundingMode())); String accCreditId = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ACCCREDIT"); Account accCredit = new Account(); accCredit.setItsId(accCreditId); accEntry.setAccCredit(accCredit); accEntry.setSubaccCreditType(getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "SUBACCCREDITTYPE")); accEntry.setSubaccCreditId(getSrvDatabase().getSrvRecordRetriever()
do { LedgerDetailLine ldl = new LedgerDetailLine(); ldl.setItsDate(getSrvDatabase().getSrvRecordRetriever() .getDate(recordSet.getRecordSet(), "ITSDATE")); ldl.setSourceId(getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "SOURCEID")); ldl.setSourceType(getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "SOURCETYPE")); ldl.setDescription(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "DESCRIPTION")); ldl.setSubaccName(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "SUBACC")); ldl.setCorrAccName(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "CORACC")); ldl.setCorrSubaccName(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "CORSUBACC")); ldl.setCorrAccNumber(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "CORACCNUMBER")); Boolean isDebit = getSrvDatabase().getSrvRecordRetriever() .getBoolean(recordSet.getRecordSet(), "ISDEBIT"); if (isDebit) { ldl.setDebit(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "ITSTOTAL") .setScale(getSrvAccSettings().lazyGetAccSettings() .lazyGetAccSettings().getRoundingMode())); } else { ldl.setCredit(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "ITSTOTAL")
if (recordSet.moveToFirst()) { do { String accName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ITSNAME"); String accNumber = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ITSNUMBER"); String subaccName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "SUBACC"); Double debit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "DEBIT"); Double credit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "CREDIT"); if (debit != 0 || credit != 0) {
do { LedgerPreviousLine lpl = new LedgerPreviousLine(); String subaccName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "SUBACC"); lpl.setDebit(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "DEBIT") .setScale(getSrvAccSettings().lazyGetAccSettings() .getCostPrecision(), getSrvAccSettings() .lazyGetAccSettings().getRoundingMode())); lpl.setCredit(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "CREDIT") .setScale(getSrvAccSettings().lazyGetAccSettings()
if (recordSet.moveToFirst()) { do { Long taxId = getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "TAXID"); Double totalTax = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "TOTALTAX"); SalesInvoiceTaxLine sit;
if (recordSet.moveToFirst()) { do { Long taxId = getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "TAXID"); Double totalTax = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "TOTALTAX"); PurchaseReturnTaxLine cit;
if (recordSet.moveToFirst()) { do { Long taxId = getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "TAXID"); Double totalTax = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "TOTALTAX"); SalesReturnTaxLine sit;
if (recordSet.moveToFirst()) { do { Long taxId = getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "TAXID"); Double totalTax = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "TOTALTAX"); PurchaseInvoiceTaxLine sit;
if (recordSet.moveToFirst()) { do { String accName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ACCOUNTNAME"); Integer accType = getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "ITSTYPE"); String accNumber = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ITSNUMBER"); Double debit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "DEBIT"); Double credit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "CREDIT"); if (debit != 0 || credit != 0) {