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

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

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

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

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

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

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

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

SELECT * FROM [AccERP_VM].[dbo].[ApCreditNoteHeader] where TxnDate >= '2016-07-01';
SELECT x.* FROM [AccERP_VM].[dbo].[ApCreditNoteDetail] x left join [AccERP_VM].[dbo].[ApCreditNoteHeader] y on y.VoucherNo=x.VoucherNo
where y.TxnDate>='2016-07-01';

SELECT * FROM [AccERP_VM].[dbo].[ApDebitNoteHeader] where TxnDate >= '2016-07-01';
SELECT x.* FROM [AccERP_VM].[dbo].[ApDebitNoteDetail] x left join [AccERP_VM].[dbo].[ApDebitNoteHeader] y on y.VoucherNo=x.VoucherNo
where y.TxnDate>='2016-07-01';


SELECT * FROM [AccERP_VM].[dbo].[ApInvoiceHeader] where TxnDate >= '2016-07-01';
SELECT x.* FROM [AccERP_VM].[dbo].[ApInvoiceDetail] x left join [AccERP_VM].[dbo].[ApInvoiceHeader] y on y.VoucherNo=x.VoucherNo
where y.TxnDate>='2016-07-01';

SELECT * FROM [AccERP_VM].[dbo].[ArCreditNoteHeader] where TxnDate >= '2016-07-01';
SELECT x.* FROM [AccERP_VM].[dbo].[ArCreditNoteDetail] x left join [AccERP_VM].[dbo].[ArCreditNoteHeader] y on y.CreditNo=x.CreditNoteNo
where y.TxnDate>='2016-07-01';

SELECT * FROM [AccERP_VM].[dbo].[ArDebitNoteHeader] where TxnDate >= '2016-07-01';
SELECT x.* FROM [AccERP_VM].[dbo].[ArDebitNoteDetail] x left join [AccERP_VM].[dbo].[ArDebitNoteHeader] y on y.DebitNo=x.DebitNoteNo
where y.TxnDate>='2016-07-01';

SELECT * FROM [AccERP_VM].[dbo].[ArInvoiceHeader] where TxnDate >= '2016-07-01';
SELECT x.* FROM [AccERP_VM].[dbo].[ArInvoiceDetail] x left join [AccERP_VM].[dbo].[ArInvoiceHeader] y on y.InvNo=x.InvoiceNo
where y.TxnDate>='2016-07-01';

SELECT * FROM [AccERP_VM].[dbo].[CbPaymentHeader] where TxnDate >= '2016-07-01';
SELECT x.* FROM [AccERP_VM].[dbo].[CbPaymentDetail] x left join [AccERP_VM].[dbo].[CbPaymentHeader] y on y.VoucherNo=x.VoucherNo
where y.TxnDate>='2016-07-01';

SELECT * FROM [AccERP_VM].[dbo].[CbReceiptHeader] where TxnDate >= '2016-07-01';
SELECT x.* FROM [AccERP_VM].[dbo].[CbReceiptDetail] x left join [AccERP_VM].[dbo].[CbReceiptHeader] y on y.ReceiptNo=x.ReceiptNo
where y.TxnDate>='2016-07-01';

SELECT * FROM [AccERP_VM].[dbo].[GlJournalHeader] where TxtDate >= '2016-07-01';
SELECT x.* FROM [AccERP_VM].[dbo].[GlJournalDetail] x left join [AccERP_VM].[dbo].[GlJournalHeader] y on y.JournalNo=x.JournalNo
where y.TxtDate>='2016-07-01';

SELECT * FROM [AccERP_VM].[dbo].[GLTrans] where VoucherDate>='2016-07-01';

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

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

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

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

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