database.beginTransaction(); cursor = database.cursor("select * from LP_BATCH order by ID");

Transaction Batches

if (request.type == "credit") write("
Click on a Batch ID to view transactions for crediting.

"); if (request.type == "view") write("
Click on a Batch ID to view its transactions.

");
while (cursor.next()) { } cursor.close() database.commitTransaction();
Batch Transactions Processed as of
var curDate = new Date(); write(curDate);
ID Batch Number Status Merchant
Reference
Sales Amt Credit Amt Sales Count Credit Count Currency
write("" + cursor.id + ""); if (cursor.batchNumber != null) write(cursor.batchNumber); if (cursor.status != null) write(cursor.status); if (cursor.merchantReference != null) write(cursor.merchantReference); if ((cursor.totalSalesAmount + "") != "null") write(cursor.totalSalesAmount); if ((cursor.totalCreditAmount + "") != "null") write(cursor.totalCreditAmount); if ((cursor.salesCount + "") != "null") write(cursor.salesCount); if ((cursor.creditCount + "") != "null") write(cursor.creditCount); if (cursor.currency != null) write(cursor.currency);

Back to Administration