SELECT * FROM [AccERP].[dbo].[AccBank];

SELECT * FROM [AccERP].[dbo].[AccBankRecon];

SELECT * FROM [AccERP].[dbo].[AccBranch];

SELECT * FROM [AccERP].[dbo].[AccCategory];

SELECT * FROM [AccERP].[dbo].[AccChartOfAccount];

SELECT * FROM [AccERP].[dbo].[AccDept];

SELECT * FROM [AccERP].[dbo].[AccGroup];

SELECT * FROM [AccERP].[dbo].[AdUser];

SELECT * FROM [AccERP].[dbo].[AccPayment];

SELECT * FROM [AccERP].[dbo].[AdGroup];

SELECT * FROM [AccERP].[dbo].[AdUser];

SELECT * FROM [AccERP].[dbo].[ApCreditNoteHeader] where TxnDate BETWEEN '2020-01-01' and '2020-03-31';
SELECT x.* FROM [AccERP].[dbo].[ApCreditNoteDetail] x left join [AccERP].[dbo].[ApCreditNoteHeader] y on y.VoucherNo=x.VoucherNo
where y.TxnDate BETWEEN '2020-01-01' and '2020-03-31';

SELECT * FROM [AccERP].[dbo].[ApDebitNoteHeader] where TxnDate BETWEEN '2020-01-01' and '2020-03-31';
SELECT x.* FROM [AccERP].[dbo].[ApDebitNoteDetail] x left join [AccERP].[dbo].[ApDebitNoteHeader] y on y.VoucherNo=x.VoucherNo
where y.TxnDate BETWEEN '2020-01-01' and '2020-03-31';


SELECT * FROM [AccERP].[dbo].[ApInvoiceHeader] where TxnDate BETWEEN '2020-01-01' and '2020-03-31';
SELECT x.* FROM [AccERP].[dbo].[ApInvoiceDetail] x left join [AccERP].[dbo].[ApInvoiceHeader] y on y.VoucherNo=x.VoucherNo
where y.TxnDate BETWEEN '2020-01-01' and '2020-03-31';

SELECT * FROM [AccERP].[dbo].[ArCreditNoteHeader] where TxnDate BETWEEN '2020-01-01' and '2020-03-31';
SELECT x.* FROM [AccERP].[dbo].[ArCreditNoteDetail] x left join [AccERP].[dbo].[ArCreditNoteHeader] y on y.CreditNo=x.CreditNoteNo
where y.TxnDate BETWEEN '2020-01-01' and '2020-03-31';

SELECT * FROM [AccERP].[dbo].[ArDebitNoteHeader] where TxnDate BETWEEN '2020-01-01' and '2020-03-31';
SELECT x.* FROM [AccERP].[dbo].[ArDebitNoteDetail] x left join [AccERP].[dbo].[ArDebitNoteHeader] y on y.DebitNo=x.DebitNoteNo
where y.TxnDate BETWEEN '2020-01-01' and '2020-03-31';

SELECT * FROM [AccERP].[dbo].[ArInvoiceHeader] where TxnDate BETWEEN '2020-01-01' and '2020-03-31';
SELECT x.* FROM [AccERP].[dbo].[ArInvoiceDetail] x left join [AccERP].[dbo].[ArInvoiceHeader] y on y.InvNo=x.InvoiceNo
where y.TxnDate BETWEEN '2020-01-01' and '2020-03-31';

SELECT * FROM [AccERP].[dbo].[CbPaymentHeader] where TxnDate BETWEEN '2020-01-01' and '2020-03-31';
SELECT x.* FROM [AccERP].[dbo].[CbPaymentDetail] x left join [AccERP].[dbo].[CbPaymentHeader] y on y.VoucherNo=x.VoucherNo
where y.TxnDate BETWEEN '2020-01-01' and '2020-03-31';

SELECT * FROM [AccERP].[dbo].[CbReceiptHeader] where TxnDate BETWEEN '2020-01-01' and '2020-03-31';
SELECT x.* FROM [AccERP].[dbo].[CbReceiptDetail] x left join [AccERP].[dbo].[CbReceiptHeader] y on y.ReceiptNo=x.ReceiptNo
where y.TxnDate BETWEEN '2020-01-01' and '2020-03-31';

SELECT * FROM [AccERP].[dbo].[DebtorAgingInfo];

SELECT * FROM [AccERP].[dbo].[GlJournalHeader] where TxtDate BETWEEN '2020-01-01' and '2020-03-31';
SELECT x.* FROM [AccERP].[dbo].[GlJournalDetail] x left join [AccERP].[dbo].[GlJournalHeader] y on y.JournalNo=x.JournalNo
where y.TxtDate BETWEEN '2020-01-01' and '2020-03-31';

SELECT * FROM [AccERP].[dbo].[GLTrans] where VoucherDate BETWEEN '2020-01-01' and '2020-03-31';

SELECT * FROM [AccERP].[dbo].[POSupplier];

SELECT * FROM [AccERP].[dbo].[SaCurrency];

SELECT * FROM [AccERP].[dbo].[SaCurrRate];

SELECT * FROM [AccERP].[dbo].[SaCust];

SELECT * FROM [AccERP].[dbo].[SaCustAdd];

SELECT * FROM [AccERP].[dbo].[SaPaymentTerm];

SELECT * FROM [AccERP].[dbo].[SaSalesRep];

SELECT * FROM [AccERP].[dbo].[SaTaxGroup];

SELECT * FROM [AccERP].[dbo].[StockOpenClose];
