SQL Query to retrieve Untransferred to GL transactions

Hi,

Does any body has got SQL query to retrieve details of transactions which are not posted to GL:-

Under AP:-

Query should cover the following:-

1. Unaccounted and not transferred to GL (Invoices and Payments)

2. Accounted, but not transferred to GL (Invoices and Payments)

Under AR:-

Query should cover the following:-

1. Unaccounted and not transferred to GL (Invoices, Adjustments and Receipts)

2. Accounted, but not transferred to GL (Invoices, Adjustments and Receipts)

Regards,

Arvind