Custom Bank Statement - Display From To / LedgerDimension

BankAccountTable bankAccounttable; BankAccountTable bankAccounttable2; BankAccountTrans bankAccountTrans; LedgerJournalTrans ledgerJournalTrans; BGPaymentLine bgPaymentLine; MK_ReportBankStatementLPP bankStatementLPP; DimensionAttributeValueCombination DimensionAttributeValueCombination; VNBankAccountStatementTmp VNBankAccountStatementTmp; LJCustTable LJCustTable; BGPaymentTable BGPaymentTable; BGMonitoringtable BGMonitoringtable; MAINACCOUNT MAINACCOUNT; VendTable VendTable; VendTable VendTable2; CustTable CustTable; CustTable CustTable2; // DIRPA LPPJournalTable LPPTABLE; LPPJournalTable lppJournalTable; str TXT; str UM; //add by Vina select ledgerJournalTrans where ledgerJournalTrans.Voucher == bankAccountTrans.Voucher && ledgerJournalTrans.TransDate == bankAccountTrans.TransDate && ledgerJournalTrans.RecId == bankAccountTrans.SourceRecId; //add by Vina select RecId, DISPLAYVALUE FROM DimensionAttributeValueCombination WHERE DimensionAttributeValueCombination.RecId == ledgerJournalTrans.LedgerDimension; //add by Vina select firstOnly VendTable WHERE VendTable.AccountNum == DimensionAttributeValueCombination.DisplayValue; //add by Vina select firstOnly CustTable WHERE CustTable.AccountNum == DimensionAttributeValueCombination.DisplayValue; //add by Vina select firstOnly bankAccounttable2 WHERE bankAccounttable2.AccountID == DimensionAttributeValueCombination.DisplayValue; //add by Vina select firstOnly MainAccount WHERE MainAccount.MainAccountId == subStr(DimensionAttributeValueCombination.DisplayValue,1,9); //add by Vina select firstOnly VendTable2 WHERE VendTable2.AccountNum == ledgerJournalTrans.NoteAccountNum; //add by Vina select firstOnly DimensionAttributeValueCombination WHERE DimensionAttributeValueCombination.RecId == ledgerJournalTrans.LedgerDimension; //add by Vina select * FROM BGPaymentTable WHERE BGPaymentTable.JournalIdClearing == ledgerJournalTrans.JournalNum; select * FROM BGMonitoringtable WHERE BGMonitoringtable.JournalIdClearing == ledgerJournalTrans.JournalNum; bankAccountStatementTmp.MK_BG = ledgerJournalTrans.ChequeNumber; Txt=""; //add by Vina // UM=BGPaymentTable.noteAccountNum() +BGMonitoringtable.; IF (SUBSTR ( ledgerJournalTrans.Voucher,3,2) == "GR" || "GC") { select * FROM LJCustTable WHERE LJCustTable.CustId == BGPaymentTable.noteAccountNum(); // select * from custtable2 where CustTable2.AccountNum== IF (LJCustTable) { Txt =BGPaymentTable.kepada_R2 + LJCustTable.Name; } else { if (BGMonitoringtable) { Txt =BGPaymentTable.kepada_R2 + BGMonitoringtable.custName() ; } else {Txt =BGPaymentTable.kepada_R2 + BGPaymentTable.noteAccountNum() ;} } } //add by Vina // bankAccountStatementTmp.MK_KepadaDari = ledgerJournalTrans.dispOffsetMainAccountNumDesc(); if(ledgerJournalTrans.OffsetAccountType!=6) { bankAccounttable2.Name=""; } //add by Vina bankAccountStatementTmp.MK_KepadaDari = Txt +VENDTABLE2.name() + VENDTABLE.name() +CUSTTABLE.name() +MainAccount.Name + bankAccounttable2.NAME;