Get payment status

Returns the current status and details of a specific payment transaction.